EXCEL 2 - Assignment Essays

You will develop a marketing budget. This budget is critical to helping you determine how much it will cost you to reach your market and achieve your sales goals. To create your marketing budget, you will use the Business Plan Financials Excel Template. IT WILL BE ATTACHED

Reminders

You will complete only the Setup and Marketing Budget worksheets for this assignment; be sure to upload the entire Excel Template.

Instructions

Develop a marketing budget, supporting your marketing plan and sales goals, in which you:

Prepare the Setup worksheet for your selected company based on the appropriate guidelines and instructions.
Prepare the Marketing Budget worksheet for your selected company based on the appropriate guidelines and instructions. When filling out the Marketing Budget worksheet in the Excel Template, do the following:
Begin with the current year and complete a marketing budget for the business’s first two years.
Leave at zero any marketing vehicles you do not plan to use.
Reminder: All marketing activities involve costs. If social media represents a significant portion of your marketing plan, assume you will incur advertising costs; reflect these in your marketing budget. Even if a social media site charges nothing to use it, you will need to use company resources to manage the site, execute your social media marketing campaigns, and most likely pay for ads on that site.
Do not leave the Marketing Budget worksheet blank assuming you will not have any marketing costs.
Do not complete all the rows; only fill in the costs for the marketing vehicles you will actually use. These must match the content you described in Item 4 of Section 1 of this assignment. (I WILL ATTACH)

Warning

W A R N I N G !

IT APPEARS THAT YOU DO NOT HAVE EXCEL’S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED.

Excel 2010 for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.

If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instructions, under
“Excel 2010 and Excel 2013 on Windows – Enabling Macros”

Excel 2013& 2016 for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.

If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instructions, under
“Excel 2010 & Excel 2013 on Windows – Enabling Macros”

Excel 2011 & 2016 for Mac:
1. A pop-up window appears. Select “Enable Macros”.
2. Your workbook should now be ready to use.

Excel 2013 and Excel 2016 on Windows – Enabling Macros

Note: The procedure is exactly the same for Excel 2013 & 2016, even though the two versions look slightly different.
1. In the upper left corner of the Excel Ribbon, press the “File” tab.

2. Select Options, in the lower left corner.

3. Select Trust Center from the Lower Left.
4. Click the “Trust Center Settings…” button in the lower right

5. Select “Macros Settings” from the left side menu
6. Select the “Disable all macros except digitally signed macros” radio button.
7. Click “OK” twice

Your Company Name

Welcome

Welcome to Business Plan Financials!

Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com.
First, a few tips to get you started:
SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES
You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank “ORIG_PlanningShop_BizPlanFin(2.8)” file in your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy.
NAVIGATING THE WORKSHEETS
You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a “PlanningShop” tab, that contains controls to let you navigate between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2013 and Excel 2016, but the functionality is the same.

Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel.

Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac:

In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it).
Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.

HOW TO FILL IN THE WORKSHEETS
Each worksheet is composed of “cells” containing either black text or blue text. All you need to do is enter data in the blue cells–the black cells are automatically calculated for you.

While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a “help balloon” that will popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.

FOR MORE HELP
For more in-depth help and assistance,please refer to the companion PDF entitled “Business Plan Financials Help”. It contains extensive information about each worksheet, along with a “Frequently Asked Questions” (FAQ).
To get started, click on the right-pointing arrow in the PlanningShop toolbar to reach the “Setup and Assumptions” worksheet, where you’ll enter some basic information about your business.

About Our Support of Mac vs. Windows

PlanningShop supports Business Plan Financials on the following platforms:

Windows

1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365

2. Microsoft Windows 8 or later with Microsoft Excel 2013

Mac

4 Mac OS X with Microsoft Excel 2016

5. Mac OS X with Microsoft Excel for Mac 2011

Setup

Setup and Assumptions

COMPANY INFORMATION

What is your company’s name?

Yummy Yummy

What month will you officially start your company?

January

What year will you officially start your company?

2023

SALES ASSUMPTIONS

The Worksheets can accommodate sales projections for up to 10 major product/service lines. How many major product/service lines do you plan to have for your business?

Ten

Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product “lines,” and then base your projections on these groups of products instead of each individual product.

Ten

Most businesses sell at least some of their products/services on credit (e.g., “net 30” as opposed to cash). What percentage of your sales will be made on credit?

25%

Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.

For sales you make on credit, what terms will you extend? In other words, how many days will pass from the date of sale to when you expect to be paid?

Author: If, for instance, your terms will be “Net 30,” put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.

PERSONNEL ASSUMPTIONS

Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)?

$5,000

Author: This number should reflect the amount you will spend on ONE FULL-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)?

$1,200

Author: This number should reflect the amount you will spend on ONE PART-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

With health insurance and other benefits costing more each year, your plan should account for annual increases. How much do you estimate your benefit costs will increase each year?

5.00%

If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by?

3.50%

Approximately what percentage of each employee’s salary or wages do you plan to set aside for payroll taxes?

15.00%

Author: If you’re not sure what percentage to enter here, leave it at the default (15%).

FINANCIAL ASSUMPTIONS

What will be the opening balance in your bank account on the first day of business? This will be the opening balance in your Cash Flow Statements.

$5,000

Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

At approximately what rate do you expect to be taxed on your net income?

25.00%

Author: If you’re not sure what percentage to enter here, leave it at the default (25%).

If you will use an interest-bearing account for your banking, at what rate will you accrue interest?

1.00%

Author: If you’re not sure what percentage to enter here, leave it at the default (1.00%).

Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.

Author: If, for instance, your terms will be “Net 30,” put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.

Author: If you’re not sure what percentage to enter here, leave it at the default (15%).

Setup & Assumptions

SalesProj

Sales Projections

Author: For information about this worksheet, see the chapter “Marketing Plan & Sales Strategy” in Successful Business Plan: Secrets & Strategies.

2023

2024

2025

2026

2027

Assumptions

January
February
March
April
May
June
July
August
September
October
November
December
TOTAL

1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
TOTAL

Product Line 1

Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.

Unit Volume

2.00%

Author: MONTHLY VOLUME GROWTH RATE
The Worksheets automatically increase the volume in each month on this line using the rate you enter here.
You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.

Author: Enter the number of units you expect to sell during this month. If you are running a service-based company charging on an hourly basis, enter the number of billable hours you expect you and your employees to work during this month. If you will be selling your service on a per-project basis, enter the number of projects you expect to sell during this period.

Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.

0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

Sure Product Consulting: YEARLY PRICE GROWTH RATE
This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).
As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.
You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0.00
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%

Author: COMMISSIONED SALES
What percentage of this product line’s sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?

15.00%

Author: SALES COMMISSION RATE
What will be the commission rate paid to your salesperson for each sale?

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%

Author: RETURNS AND ALLOWANCES
A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate–but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales.

$0.00
$0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0

$0.00
$0.00
$0.00
$0.00
$0

$0.00

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%

Author: COST OF GOODS
Approximately what percentage of your product’s sale price will be spent on manufacturing? If you are a reseller or retailer, what percentage of your product’s sale price will be spent on buying the product from your distributor? A service business may not need to track cost of goods, in which case you can set this number to zero.

$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 2

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 & 2010 for Windows
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Unit Volume

5.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 3

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 4

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 5

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 6

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 7

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 8

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 9

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 10

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

Unit Volume

2.00%
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

0
0
0
0

0
0
0
0
0

Unit Price

2.50%

$0.00

Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.

$0.00

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
50.00%
15.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and Allowances)

3.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods Sold)

50.00%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Totals for All Product Lines

Total Unit Volume

0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0

Total Gross Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Total Commissions)

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Total Returns and Allowances)

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Net Sales

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Total Cost of Goods Sold)

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

TOTAL GROSS PROFIT

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Sales Projections

Inventory

Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.

2023

2024

2025

2026

2027

January
February
March
April
May
June
July
August
September
October
November
December
TOTAL

1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
TOTAL

Product Line 1

Cost of Goods Sold
$0

Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It’s here simply to aid you in determining how much inventory you need to purchase.

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet.
You can override the automatically entered values by entering in actuals in the blue cells.

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0

Author: Are these cells showing red?
As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period.
In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn’t, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 2

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 3

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 4

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 5

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 6

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 7

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 8

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 9

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Product Line 10

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Cost of Goods Sold
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 1
$0

Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.
On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide
On Excel 2007 and 2010 for Windows:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Items/Parts 4
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GRAND TOTAL INVENTORY
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

CapEx

Capital Purchases

Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.

12/31/18

Item
Cost
Purchase
Date

Years of
Service
Salvage
Value

Reminder: All purchases must be on or after your business start date of:

Facilities

Author: Facilities include, land, buildings, building upgrades, fixtures, etc.
NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.

Month
Year

December-2018

Item Name (change name here)
$0

Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.

Jan

Author: Enter the month you will purchase the item(s).
Note: When entering dates on this worksheet, make sure that they don’t fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause “#NUM!” calculation errors on later worksheets. However, you need not change the dates on lines you are not using.

2023

Author: Enter the year you will purchase the item(s).

Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it.
This number will be used to calculate depreciation in your financial statements using the Straight Line method.
NOTE: If you’d rather “expense” the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements.
For information about the tax implications/requirements of depreciation, please consult a competent accountant.

Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it.
For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell.
If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.

Item Name (change name here)
$0
Jan
2023
1
$0

Equipment

Author: Equipment includes machinery, furniture, vehicles, etc.

Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.

Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.

Item Name (change name here)
$0
Jan
2023
1
$0

Computer Hardware/Software

Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.

Item Name (change name here)
$0
Jan
2023
3
$0

Item Name (change name here)
$0
Jan
2023
1
$0

Telecommunications

Author: Telecommunications includes phone systems, fax machines, etc.

Author: Enter the year you will purchase the item(s).

Item Name (change name here)
$0
Jan
2023
1
$0

Land

Author: Land purchases are not depreciable.

Item Name (change name here)
$0
Jan
2023
Land is a
non-depreciable
asset

Item Name (change name here)
$0
Jan
2023

Capital Purchases

StaffBudj

Staffing Budget

Author: For information about this worksheet, see “Staffing Budget” section and worksheet in “The Financials” chapter of Successful Business Plan: Secrets & Strategies.

2023

2024

2025

2026

2027

January
February
March
April
May
June
July
August
September
October
November
December
TOTAL

1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
TOTAL

TOTAL

Management

# Salaried Employees
0.0

Author: Enter the number of full-time employees you expect to have working for you in this category during this month.
For part-time employees, enter their information below under “Part-time / Hourly Employees”.

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

0.0
0.0
0.0

0.0
0.0
0.0
0.0

0.0

Avg Salary per employee
$0

Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits (across all employees)
$0

Author: This value is calculated using the number you entered on the “Setup and Assumptions” worksheet and the number of employees you entered above.

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Administrative/Support

# Salaried Employees
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

0.0
0.0
0.0

0.0
0.0
0.0
0.0

0.0

Avg Salary per employee
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Sales/Marketing

# Salaried Employees
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

Author: For information about this worksheet, see “Staffing Budget” section and worksheet in “The Financials” chapter of Successful Business Plan: Secrets & Strategies.

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

0.0
0.0
0.0

0.0
0.0
0.0
0.0

0.0

Avg Salary per employee
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Operations/Production

# Salaried Employees
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

0.0
0.0
0.0

0.0
0.0
0.0
0.0

0.0

Avg Salary per employee
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Other

# Salaried Employees
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

0.0

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

0.0
0.0
0.0

0.0
0.0
0.0
0.0

0.0

Avg Salary per employee
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Part-Time / Hourly Employees

# Part-Time Employees
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

Author: This value is calculated using the number you entered on the “Setup and Assumptions” worksheet and the number of employees you entered above.

Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!

0
0
0

0
0
0
0

Avg. Hours per Hourly Employee
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0

Avg Hourly Rate
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00

$0.00

Calculated Wages Per Hourly Employee
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Wages
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes (across all employees)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

TOTAL

# Full Time Employees
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0

# Part-Time Employees
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0

Salary/Wages
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Benefits
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll Taxes
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GRAND TOTAL COSTS
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Staffing Budget

MktBudj

For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates
from PlanningShop.

Marketing Budget

Author: For information about this worksheet, see Chapter 10, “Marketing Plan & Sales Strategy” in Successful Business Plan: Secrets & Strategies

2023

2024

2025

2026

2027

January
February
March
April
May
June
July
August
September
October
November
December
TOTAL

1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
TOTAL

Professional Assistance

Marketing/PR Consultants
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Advertising Agencies
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Social Media Specialists
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

SEO Specialist
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Graphic/Web Design
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Brochures/Leaflets/Flyers
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Signs/Billboards
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Merchandising Displays
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Sampling/Premiums
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Media Advertising

Print (newspaper, etc.)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Television and Radio
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Online

Author: Includes AdWords, banner ads, social media ads, etc.

Author: For information about this worksheet, see Chapter 10, “Marketing Plan & Sales Strategy” in Successful Business Plan: Secrets & Strategies

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Other Media
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Phone Directories
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Advertising Specialties
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Direct Mail
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Website

Development/Programming
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Maintenance and Hosting
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Trade Shows

Fees and Setup
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Travel/Shipping
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Exhibits/Signs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Public Relations/Materials
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Informal Marketing / Networking

Memberships/Meetings
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Entertainment
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Other
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GRAND TOTAL COSTS
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Marketing Budget

ProSvs

Professional Services

Author: For information about this worksheet, see Chapter 13, “Management & Organization” in Successful Business Plan: Secrets & Strategies.

2023
2024
2025
2026
2027

General

Author: For professional services related to marketing, use the Marketing Budget spreadsheets.

Attorneys
$0

Author: The number you enter here will be equally divided among the 12 months of the year on your Income Statement.

$0
$0
$0
$0

Accountants
$0
$0
$0
$0
$0

Management consultants
$0
$0
$0
$0
$0

Industry specialists
$0
$0
$0
$0
$0

Technology consultants
$0
$0
$0
$0
$0

Other (change title here)
$0
$0
$0
$0
$0

Total Costs
$0
$0
$0
$0
$0

GRAND TOTAL COSTS
$0
$0
$0
$0
$0

Professional Services Budget

CapInvest

Capital Investments and Loans

Author: This worksheet will help you manage loans and investments in your business.

Item
Amount
Date

Loan Period

Sure Product Consulting: Loan period is in NUMBER OF MONTHS

Interest Rate

Reminder: All invesments & loans must be on or after your business start date of:

Equity Capital Investments

Author: Equity capital investments can come from a number of sources, including venture capitalists, angel investors, and family members. Generally, these investors are purchasing a percentage of (or shares in) your company. They expect to reap the rewards of your business’ success through periodic dividend payments (a share of the profits) and/or when the company is sold.

Sure Product Consulting: Loan period is in NUMBER OF MONTHS

Month
Year

December-2018

Investment Source Name
$0

Author: Enter the amount that will be invested in your business from this source. If this investor will inject cash into your business more than one time, use separate lines for each investment.

Jan

Author: Enter the month that you will receive the investment cash.
Note: When entering dates on this worksheet, make sure that they don’t fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause “#NUM!” calculation errors on later worksheets. However, you need not change the dates on lines you are not using.

2023

Author: Enter the year you will receive the investment cash.

Capital investments are not paid back on a loan schedule.

Investment Source Name
$0
Jan
2023

Total Capital Investments
$0

Loans

Author: Unlike equity capital inventments, lenders are typically not interested in purchasing shares in your company–they simply want to be paid back on a fixed schedule, with interest. Lenders can include banks and family members.

Loan Source Name
$0
Jan
2023
12

Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.

0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Loan Source Name
$0
Jan
2023
12
0.00%

Author: Enter the loan’s annual interest rate.

Total Loans
$0

TOTAL INVESTMENTS AND LOANS
$0

Capital Investments and Loans

IncSt

Income Statements

Author: For information about this worksheet, see “Income Statements” in Successful Business Plan: Secrets & Strategies.

2023

2024

2025

2026

2027

January
February
March
April
May
June
July
August
September
October
November
December
TOTAL

1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
TOTAL

INCOME

Gross Sales
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Commissions)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Returns and allowances)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net Sales
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

(Cost of Goods)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

GROSS PROFIT
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

EXPENSES – General and Administrative

Salaries and wages
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Employee benefits
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Payroll taxes
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Professional services
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Marketing and advertising
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Rent
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Equipment rental
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Maintenance
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Depreciation
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Insurance
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Telephone service
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Utilities
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Office supplies
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Postage and shipping
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Travel
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Entertainment
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Interest on loans
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Other (change title here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Other (change title here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

TOTAL EXPENSES
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Net income before taxes and interest
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Interest Income
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$50

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$51

$13
$13
$13
$13
$51

$13
$13
$13
$13
$52

$52

Provision for taxes on income
$1
$1
$1
$1
$1
$1
$1
$1
$1
$1
$1
$1
$0

$1
$1
$1
$1
$1
$1
$1
$1
$1
$1
$1
$1
$0

$3
$3
$3
$3
$13

$13

NET PROFIT
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$50

$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$51

$10
$10
$10
$10
$38

$10
$10
$10
$10
$39

$39

Income Statements

CshFlw

Cash Flow

Author: For information about this worksheet, see “Cash-Flow Projections” in “The Financials” chapter of Successful Business Plan: Secrets & Strategies.

2023

2024

2025

2026

2027

January
February
March
April
May
June
July
August
September
October
November
December
TOTAL

1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
TOTAL

CASH RECEIPTS

Income from Sales

Cash Sales
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Collections
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Cash from Sales
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Income from Financing

Interest Income
$4

Author: This line item is automatically calculated for you based on the interest rate you entered on the “Setup and Assumptions” sheet.

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$50

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$51

$13
$13
$13
$13
$51

$13
$13
$13
$13
$52

$52

Loan Proceeds
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Equity Capital Investments
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Total Cash from Financing
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$50

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$51

$13
$13
$13
$13
$51

$13
$13
$13
$13
$52

$52

Other Cash Receipts
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

TOTAL CASH RECEIPTS
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$50

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$51

$13
$13
$13
$13
$51

$13
$13
$13
$13
$52

$52

CASH DISBURSEMENTS

Inventory
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Operating Expenses
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Commissions/Returns & Allowances
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Capital Purchases
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Loan Payments
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Income Tax Payments
$0

Author: Note that on your Income Statements, we’ve generated an estimate for income taxes. This line on the Cash Flow statement is where you should reflect the actual payments you intend to make on a regular basis (probably quarterly).

Author: This line item is automatically calculated for you based on the interest rate you entered on the “Setup and Assumptions” sheet.

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Investor Dividend Payments
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

Owner’s Draw
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

TOTAL CASH DISBURSEMENTS
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

NET CASH FLOW
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$50

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$51

$13
$13
$13
$13
$51

$13
$13
$13
$13
$52

$52

Opening Cash Balance
$5,000
$5,004
$5,008
$5,013
$5,017
$5,021
$5,025
$5,029
$5,033
$5,038
$5,042
$5,046

$5,050
$5,054
$5,059
$5,063
$5,067
$5,071
$5,076
$5,080
$5,084
$5,088
$5,092
$5,097

$5,101
$5,114
$5,127
$5,139

$5,152
$5,165
$5,178
$5,191

$5,204

Cash Receipts
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4

$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4
$4

$13
$13
$13
$13

$52

Cash Disbursements
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0

ENDING CASH BALANCE
$5,004
$5,008
$5,013
$5,017
$5,021
$5,025
$5,029
$5,033
$5,038
$5,042
$5,046
$5,050
$5,050

$5,054
$5,059
$5,063
$5,067
$5,071
$5,076
$5,080
$5,084
$5,088
$5,092
$5,097
$5,101
$5,101

$5,114
$5,127
$5,139
$5,152
$5,152

$5,165
$5,178
$5,191
$5,204
$5,204

$5,256

Cash Flow Statements

BalSht

Balance Sheet

Author: For information about this worksheet, see “Balance Sheet” in “The Financials” chapter of Successful Business Plan: Secrets & Strategies.

Balance Sheet

Yummy Yummy

First Quarter

Second Quarter

Third Quarter

Fourth Quarter

2024

2025

2026

2027

2023

ASSETS

Current Assets

Cash
$5,013

Cash
$5,025

Cash
$5,038

Cash
$5,050

Cash
$5,101

Cash
$5,152

Cash
$5,204

Cash
$5,256

Accounts Receivable
$0

Inventory
$0

Other Current Assets
$0

Total Current Assets

$5,013

Total Current Assets

$5,025

Total Current Assets

$5,038

Total Current Assets

$5,050

Total Current Assets

$5,101

Total Current Assets

$5,152

Total Current Assets

$5,204

Total Current Assets

$5,256

Fixed Assets

Land
$0

Facilities
$0

Equipment
$0

Computers & Telecommunications
$0

(Less Accumlated Depreciation)
$0

Total Fixed Assets

Other Assets

TOTAL ASSETS

$5,013

TOTAL ASSETS

$5,025

TOTAL ASSETS

$5,038

TOTAL ASSETS

$5,050

TOTAL ASSETS

$5,101

TOTAL ASSETS

$5,152

TOTAL ASSETS

$5,204

TOTAL ASSETS

$5,256

LIABILITIES

Current Liabilities

Short-Term Notes Payable
$0

Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year

Short-Term Notes Payable
$0

Income Taxes Due
$3

Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you’ve said you will actually pay (as entered on your Cash Flow statements).

Income Taxes Due
$6

Income Taxes Due
$9

Income Taxes Due
$0

Income Taxes Due
$13

Income Taxes Due
$26

Income Taxes Due
$39

Other Current Liabilities
$0

Total Current Liabilities

$13

Total Current Liabilities

$26

Total Current Liabilities

$39

Long-Term Liabilities

Long-Term Notes Payable
$0

Other Long-Term Liabilities
$0

Total Long-Term Liabilities

NET WORTH

Paid-In Capital
$5,000

Retained Earnings
$9

Retained Earnings
$19

Retained Earnings
$28

Retained Earnings
$50

Retained Earnings
$101

Retained Earnings
$139

Retained Earnings
$178

Retained Earnings
$217

Total Net Worth

$5,009

Total Net Worth

$5,019

Total Net Worth

$5,028

Total Net Worth

$5,050

Total Net Worth

$5,101

Total Net Worth

$5,139

Total Net Worth

$5,178

Total Net Worth

$5,217

TOTAL LIABILITIES AND NET WORTH

$5,013

TOTAL LIABILITIES AND NET WORTH

$5,025

TOTAL LIABILITIES AND NET WORTH

$5,038

TOTAL LIABILITIES AND NET WORTH

$5,050

TOTAL LIABILITIES AND NET WORTH

$5,101

TOTAL LIABILITIES AND NET WORTH

$5,152

TOTAL LIABILITIES AND NET WORTH

$5,204

TOTAL LIABILITIES AND NET WORTH

$5,256

Balance Sheet

BrkEvn

Break-even Estimates

Author: For information about this worksheet, see “Break-Even Analysis” in “The Financials” chapter of Successful Business Plan: Secrets & Strategies. Note that this Worksheet differs from that shown in the book slightly by also factoring the costs of sales commissions and returns/allowances. This gives you a more accurate break-even estimate.

Year 1 (2023)

January
$0

Author: This is the amount of sales you will need to make each month to break even.

February
$0

March
$0

April
$0

May
$0

June
$0

July
$0

August
$0

September
$0

October
$0

November
$0

December
$0

Monthly Average
$0

Year 2 (2024)

January
$0

February
$0

March
$0

April
$0

May
$0

June
$0

July
$0

August
$0

September
$0

October
$0

November
$0

December
$0

Monthly Average
$0

Year 3 (2025)

1st Quarter
$0

2nd Quarter
$0

3rd Quarter
$0

4th Quarter
$0

Quarterly Average
$0

Year 4 (2026)

1st Quarter
$0

2nd Quarter
$0

3rd Quarter
$0

4th Quarter
$0

Quarterly Average
$0

Year 5 (2027)

Annual Average
$0

Break-even Estimates

Ratios

Key Ratios

Author: This sheet provides a mathematical snapshot of your company’s performance. These ratios are often used by lenders or investors in determining how well a company is managing its finances.

Year 1 (2023)
Working
Capital

Author: Working Capital is the amount of readily available funds the company has to cover upcoming expenses. More is better!

Current Ratio

Author: This ratio divides your current assets by your current liabilities. In general, it should be greater than 2. If an “N.A.” appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.

Quick Ratio

Author: Similar to the Current Ratio, but we’ve subtracted inventory from your assets. A number greater than 1 is desirable. If an “N.A.” appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.

Cash
Turnover

Author: This ratio divides your net sales for the period by your “working capital,” (your current assets minus your current liabilities). In other words, it shows by what multiple your sales exceed your working capital. In general, 5 or above is good to aim for, but this can vary based on your industry, etc.

Debt to
Equity

Author: To calculate your Debt to Equity ratio, we divided your total liabilities by your net worth. A high number (greater than 1), indicates a high debt load relative to your assets. Potential funders may be wary of investing in such a case.

Return on
Investment

Author: This ratio is achieved by dividing your net worth into your net income for the period. It shows the rate of return you and your investors are receiving on your investments in the company. The higher the better!

Return on
Sales

Author: This ratio is calculated by dividing your net income for the period by your net sales for the period. The higher the number here, the more profit you are extracting from each sale. Your ideal number will depend greatly on your industry, margins, etc.

Return on
Assets

Author: Your Return on Assets indicates how much profit you are generating on all the investments you’ve made in the company’s assets. In particular, this will help you (and your investors) determine if you are achieving a good rate-of-return on your investments. This will depend greatly on your industry.

Net Sales

1st Quarter
$5,009
1,602.67
1,602.67
0.00
0.00
0%
N.A.
0%
$0.00

2nd Quarter
$5,019
802.33
802.33
0.00
0.00
0%
N.A.
0%
$0.00

3rd Quarter
$5,028
535.56
535.56
0.00
0.00
0%
N.A.
0%
$0.00

4th Quarter
$5,050
N.A.
N.A.
0.00
0.00
0%
N.A.
0%
$0.00

Year 2 (2024)
$5,101
N.A.
N.A.
0.00
0.00
0%
N.A.
0%
$0.00

Year 3 (2025)
$5,139
402.50
402.50
0.00
0.00
0%
N.A.
0%
$0.00

Year 4 (2026)
$5,178
202.26
202.26
0.00
0.00
0%
N.A.
0%
$0.00

Year 5 (2027)
$5,217
135.68
135.68
0.00
0.01
0%
N.A.
0%
$0.00

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2023) Gross Sales January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Gross Profit January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Net Profit January February March April May June July August September October November December 3.125 3.127604166666667 3.1302105034722221 3.1328190122251165 3.1354296947353033 3.138042552814249 3.1406575882749275 3.1432748029318232 3.1458941986009332 3.1485157770997674 3.1511395402473505 3.1537654898642233

NSYr1

Year 1: Net Sales (2023) Product Line 1 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 2 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 3 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 4 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 5 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 6 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 7 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 8 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 9 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 10 0 0 0 0 0 0 0 0 0 0 0 0

1YrCshFlw

Year 1: Cash Flow (2023) Net Cash Flow January February March April May June July August September October November December 4.166666666666667 4.1701388888888893 4.1736140046296297 4.177092016300155 4.1805729263137374 4.1840567370856654 4.1875434510332363 4.1910330705757639 4.1945255981345779 4.1980210361330235 4.2015193869964671 4.2050206531522978 Ending Cash Balance 5004.166666666667 5008.3368055555557 5012.5104195601853 5016.6875115764851 5020.8680845027984 5025.0521412398839 5029.2396846909169 5033.4307177614928 5037.6252433596273 5041.8232643957608 5046.0247837827574 5050.2298044359095

2ndYrCshFlw

Year 2: Cash Flow (2024) Net Cash Flow January February March April May June July August September October November December 4.2085248370299242 4.2120319410607827 4.215541967678333 4.2190549193180651 4.2225707984174967 4.2260896074161778 4.2296113487556912 4.2331360248796539 4.2366636382337211 4.2401941912655827 4.2437276864249709 4.2472641261636577 Ending Cash Balance January February March April May June July August September October November December 5054.438329272939 5058.6503612139995 5062.8659031816778 5067.0849581009961 5071.3075288994132 5075.533618506829 5079.7632298555845 5083.9963658804645 5088.2330295186985 5092.4732237099643 5096.716951396389 5100.9642155225529

5YrAtGl

5-Year Financials at-a-Glance
Gross Sales 2023 2024 2025 2026 2027 0 0 0 0 0 Gross Profit 2023 2024 2025 2026 2027 0 0 0 0 0 Net Profit 2023 2024 2025 2026 2027 50.22 9804435910104 50.734411086644052 38.400935492120638 38.7863872836813 39.029104844177169

NS5Yr

5-Year Net Sales

Product Line 1 2023 2024 2025 2026 2027 0 0 0 0 0 Product Line 2 2023 2024 2025 2026 2027 0 0 0 0 0 Product Line 3 2023 2024 2025 2026 2027 0 0 0 0 0 Product Line 4 2023 2024 2025 2026 2027 0 0 0 0 0 Product Line 5 0 0 0 0 0 Product Line 6 0 0 0 0 0 Product Line 7 0 0 0 0 0 Product Line 8 0 0 0 0 0 Product Line 9 0 0 0 0 0 Product Line 10 0 0 0 0 0

License

License Agreement

LICENSE AGREEMENT FOR PLANNINGSHOP’S BUSINESS PLAN FINANCIALS
This License Agreement is a legal agreement between you (the product purchaser/user) and PlanningShop for the Business Plan Financials product (“Software”) that accompanies this Agreement, including all associated documentation and packaging. By installing and/or using the Software, you accept the terms of this Agreement.
PRODUCT LICENSE
The Software is protected by intellectual property laws and treaties. It is owned by PlanningShop and licensed to you for your use (not sold). You acknowledge that PlanningShop has conferred to you NO title or ownership of the Software or any of its constituent parts. Re-distribution of the Software or any of constituent its parts, whether in an original or modified form, is strictly forbidden.
1. General License. You may install one copy of the Software on a single computing device for use by a single user. Additional users, whether using the same computing device or a separate device, must purchase additional licenses. Multi-user licenses are available from PlanningShop. A second copy of the Software may be stored on a separate device for the sole purpose of backing up the original copy. You may not copy, distribute, or resell the Software.
2. Unauthorized Use. You may not modify, disassemble, or reverse engineer the Software or its code for any form of distribution. The Software, its content, design and programming are copyrighted by PlanningShop.
3. WARRANTY. THIS SOFTWARE IS PROVIDED AS IS. PLANNINGSHOP AND ITS AFFILIATED PARTIES MAKE NO CLAIMS, PROMISES OR GUARANTEES ABOUT THE ACCURACY, COMPLETENESS, OR ADEQUACY OF THE SOFTWARE FOR ANY PURPOPSE AND EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS, OMISSIONS, FAILURES, OR DEFECTS. NO WARRANTY OF ANY KIND, IMPLIED, EXPRESS OR STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND FREEDOM FROM COMPUTER VIRUS, IS GIVEN IN CONJUNCTION WITH THE SOFTWARE.

4. DAMAGES. IN NO EVENT WILL PLANNINGSHOP BE LIABLE FOR ANY DAMAGES, INCLUDING WITHOUT LIMITATION DIRECT OR INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, LOSSES OR EXPENSES ARISING IN CONNECTION WITH THIS SOFTWARE OR USE THEREOF OR INABILITY TO USE BY ANY PARTY, OR IN CONNECTION WITH ANY FAILURE OF PERFORMANCE, ERROR, OMISSION, DEFECT, OR COMPUTER VIRUS EVEN IF THE PLANNINGSHOP, OR AFFILIATED PARTIES, ARE ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, LOSSES OR EXPENSES.
5. Governing Law. This Agreement shall be treated as though it were executed and performed in Palo Alto, California, and shall be governed by and construed in accordance with the laws of the State of California, USA (without regard to conflict of law principles). All actions shall be subject to the limitations set forth in Section 3 and Section 4. The language in this Agreement shall be interpreted as in accordance with its fair meaning and not strictly for or against either party. All legal proceedings arising out of or in connection with this Agreement shall be brought solely in Palo Alto, California. You expressly submit to the exclusive jurisdiction of said courts and consent to extraterritorial service of process. Should any part of this Agreement be held invalid or unenforceable, that portion shall be construed consistent with applicable law and the remaining portions shall remain in full force and effect.
6. Contact. Should you have any questions concerning this agreement, or if you desire to contact PlanningShop for any reason, you may do so at: PlanningShop, 555 Bryant Street #180, Palo Alto, California, USA, 94301.

About

About Business Plan Financials

PlanningShop

Business Plan Financials

Version 3.1

SUBJECT TO END-USER LICENSE AGREEMENT

www.planningshop.com

PlanningShop — Plan. Start. Grow.

Config

CONFIG WORKSHEET

Sure Product Consulting: IMPORTANT:
Do not remove or change anything on this worksheet! Doing so may render this product unusable!

Startup Year

2023

Sure Product Consulting: Sure Product Consulting:
How does this get set?
Headings on each worksheet are driven from it, but this does not seem to be connected t the Setup worksheet “what year wll your business start” question.

Version:

Startup Month

3.0

January

8/1/13

Startup Month Abbrev

Jan

Start Date:

Dec-18

CREDIT MULTIPLIER

Multiple
With “Credit Sales”

A
0.00
0.00

B
1.00
0.25

Working Capital Calc

Sure Product Consulting: Used by Ratios worksheet

Q1
$5,009

Q2
$5,019

Q3
$5,028

Q4
$5,050

Y2
$5,101

Y3
$5,139

Y4
$5,178

Y5
$5,217

Chart Titles

Year 1 String
2023

Year 1: Financials at-a-Glance (2023)

Year 2 String
2024

Year 1: Net Sales (2023)

Year 3 String
2025

Year 1: Cash Flow (2023)

Year 4 String
2026

Year 2: Cash Flow (2024)

Year 5 String
2027

DOUBLE LIST FOR Months on top of worksheets

January

February

March

April

May

June

July

August

September

October

November

December

January

February

March

April

May

June

July

August

September

October

November

December

Start Month

From Setup
January
February
March
April
May
June
July
August
September
October
November
December

Match Position in Doublelist
1
2
3
4
5
6
7
8
9
10
11
12

Adjust index to 1-12
1
2
3
4
5
6
7
8
9
10
11
12

Abbrev
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

To-Do List

Making a “Demo” version of this workbook, with watermark, 1 loan, 1 product line, 1 investment

Adding a Worksheet to do revolving credit calculations. See http://www.vertex42.com/Files/download/line-of-credit.html for a cool line of credit worksheet (it’s complicated)

Cleaning up all the dates, lists of months, etc. on the config worksheet

Adding “Reset_XXX” subroutines for ALL the worksheets

Check PrintAreas, footers, headers for New DepnSchedule and New LoanPaymentSchedule

Your Company Name

Unlicensed Copy Unlicensed Copy
Demo Use Only Demo Use Only
Unlicensed Copy Unlicensed Copy
Demo Use Only
Demo Use Only
Unlicensed Copy Unlicensed Copy
Demo Use Only Demo Use Only
Unlicensed Copy Unlicensed Copy
Demo Use Only Demo Use Only

DepnSchedule

Sure Product Consulting: Is this depreciation schedule correct?
If only one year of service, nothing is depreciated.
If more than one year, we don’t depreciate anything for year 1 it seems (or does that show up as an expense?)

Depreciation Schedule from CapEx Worksheet

Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Jan-23
Feb-23
Mar-23
Apr-23
May-23
Jun-23
Jul-23
Aug-23
Sep-23
Oct-23
Nov-23

Item#
Category
Item Name
Purch Value
Salvage Value
Yrs of Service
Mos of Service
Month Purchased
Year Purchased
Purchase Month
End Month
End Date
Depn Amt montly

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

1
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

–
–

Sure Product Consulting: If “today’s” month is one in this asset is dep’d over,

–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–

2
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–

3
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

4
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

5
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

6
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

7
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

8
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

9
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

10
Facilities
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

11
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

12
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

13
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

14
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

15
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

16
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

17
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

18
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

19
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

20
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

21
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

22
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

23
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

24
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

25
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

26
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

27
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

28
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

29
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

30
Equip
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

31
Comp
Item Name (change name here)
$0.00
$0.00
3
36
Jan
2023
1
36
Nov-21
$ – 0

32
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

33
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

34
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

35
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

36
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

37
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

38
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

39
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

40
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

41
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

42
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

43
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

44
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

45
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

46
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

47
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

48
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

49
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

50
Comp
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19
$ – 0

51
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

52
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

53
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

54
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

55
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

56
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

57
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

58
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

59
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

60
Land
Item Name (change name here)
$0.00
$0.00
1
12
Jan
2023
1
12
Nov-19

TOTAL

$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –
$ –

Land

Facilities

Equip

Comp

TOTAL

Author: This goes into Cash Flow statement.

TOTAL NON-DEPRECIABLE CAPITAL ASSETS

Author: This goes into Income statement under “non-depreciable capital purchases”

Author: This goes into Cash Flow statement.

Author: This goes into Income statement under “non-depreciable capital purchases”

Depreciation Schedule

LoanInvestSchedules

Investment Proceeds

Inv #
Name of Invest Source
Amount

Start Month
Start Year
Infusion Month

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

1
Investment Source Name
$0

Jan
2023
1

– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0

2
Investment Source Name
$0

Jan
2023
1

3
Investment Source Name
$0

Jan
2023
1

4
Investment Source Name
$0

Jan
2023
1

5
Investment Source Name
$0

Jan
2023
1

6
Investment Source Name
$0

Jan
2023
1

7
Investment Source Name
$0

Jan
2023
1

8
Investment Source Name
$0

Jan
2023
1

9
Investment Source Name
$0

Jan
2023
1

10
Investment Source Name
$0

Jan
2023
1

11
Investment Source Name
$0

Jan
2023
1

12
Investment Source Name
$0

Jan
2023
1

13
Investment Source Name
$0

Jan
2023
1

14
Investment Source Name
$0

Jan
2023
1

15
Investment Source Name
$0

Jan
2023
1

TOTAL:

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Loan Payback Schedule (Principle + Interest)

Sure Product Consulting: Note: We calculate loan payments beyond the end date of this business plan (5 years into future), in order to populate the Balance Sheet properly. Payments due in year 6 need to appear on the Short-Term Notes Payable line of Balance Sheet for Year 5. The remainder of the not-yet-made loan payments appear on Long-Term Notes Payable line of the Year 5 balance sheet.

Jan-24
Feb-24
Mar-24
Apr-24
May-24
Jun-24
Jul-24
Aug-24
Sep-24
Oct-24
Nov-24

Loan #
Name of Loan Source
Amount
Rate
Periods
Start Month
Start Year
Begin Pay Month
End Pay Month
Pmt Amt (P+I)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72

1
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0
– 0

2
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

3
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

4
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

5
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

6
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

7
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

8
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

9
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

10
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

11
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

12
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

13
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

14
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

15
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

16
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

17
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

18
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

19
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

20
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
– 0

TOTAL:

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Loan – Interest Portion of Loan Payments

Loan #
Name of Loan Source
Amount
Rate
Periods
Start Month
Start Year
Begin Pay Month
End Pay Month
Pmt Amt (P+I)

1
Loan Source Name
$0.00
$0.00
$12.00
Jan
$2,023.00
1
12
–

–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–
–

2
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

3
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

4
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

5
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

6
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

7
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

8
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

9
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

10
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

11
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

12
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

13
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

14
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

15
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

16
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

17
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

18
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

19
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

20
Loan Source Name
$0
0.00%
12
Jan
2023
1
12
–

TOTAL:

Loan Proceeds

Loan #
Name of Loan Source
Amount

Start Month
Start Year
Begin Pay Month

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

1
Loan Source Name
$0

Jan
2023
1

2
Loan Source Name
$0

Jan
2023
1

3
Loan Source Name
$0

Jan
2023
1

4
Loan Source Name
$0

Jan
2023
1

5
Loan Source Name
$0

Jan
2023
1

6
Loan Source Name
$0

Jan
2023
1

7
Loan Source Name
$0

Jan
2023
1

8
Loan Source Name
$0

Jan
2023
1

9
Loan Source Name
$0

Jan
2023
1

10
Loan Source Name
$0

Jan
2023
1

11
Loan Source Name
$0

Jan
2023
1

12
Loan Source Name
$0

Jan
2023
1

13
Loan Source Name
$0

Jan
2023
1

14
Loan Source Name
$0

Jan
2023
1

15
Loan Source Name
$0

Jan
2023
1

16
Loan Source Name
$0

Jan
2023
1

17
Loan Source Name
$0

Jan
2023
1

18
Loan Source Name
$0

Jan
2023
1

19
Loan Source Name
$0

Jan
2023
1

20
Loan Source Name
$0

Jan
2023
1

TOTAL:

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Loan Calculations for Balance Sheet

First Quarter

Second Quarter

Third Quarter

Fourth Quarter

Year 2

Year 3

Year 4

Year 5

Loan #
Name of Loan Source
Amount
Rate
Periods
Start Month
Start Year
Begin Pay Month
Amount

Principle Paid
Due Short
Due Long
Paid
Due Short
Due Long
Paid
Due Short
Due Long
Paid
Due Short
Due Long
Paid
Due Short
Due Long
Paid
Due Short
Due Long
Paid
Due Short
Due Long
Paid
Due Short
Due Long

1
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0

Sure Product Consulting: If received proceeds this quarter, “Due Short” is all the payment of principle (not interest)
due in the next 12 months from disbursement

Sure Product Consulting: “Due Long” is whatever priciple is left: origloan – pricpaid so far – due short. Whatever is due more than 12 months out.

Sure Product Consulting: cummulative principle paid: includes previous quarter’s payments

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

2
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

3
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

4
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

5
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

6
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

7
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

8
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

9
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

10
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

11
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

12
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

13
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

14
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

15
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

16
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

17
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

18
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

19
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

20
Loan Source Name
$0.00
0.00%
12
Jan
2023
1
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

TOTAL:

$0
$0

BETA – Monthly Loan Calculations for Balance Sheet

Loan Calculations for Balance Sheet

Dec-18
Jan-19
Feb-19
Dec-18
Apr-19
May-19
Dec-18
Jul-19
Aug-19
Dec-18
Oct-19
Nov-19
Dec-18
Jan-20
Feb-20
Dec-18
Apr-20
May-20
Dec-18
Jul-20
Aug-20
Dec-18
Oct-20
Nov-20
Dec-18
Jan-21
Feb-21
Dec-18
Apr-21
May-21
Dec-18
Jul-21
Aug-21
Dec-18
Oct-21
Nov-21
Dec-18
Jan-22
Feb-22
Dec-18
Apr-22
May-22
Dec-18
Jul-22
Aug-22
Dec-18
Oct-22
Nov-22
Dec-18
Jan-23
Feb-23
Dec-18
Apr-23
May-23
Dec-18
Jul-23
Aug-23
Dec-18
Oct-23
Nov-23

Loan #
Name of Loan Source
Amount
Rate
Periods
Start Month
Start Year
Begin Pay Month
Last Month Num

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

1
Loan Source Name
$0.00
0.000%
12
Jan
$2,023.00
1
12

Principle Paid
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Due Short
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Due Long
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

TOTAL
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Loan & Investment Schedules for Disbursement & Repayment

image1.gif

image2

image3

image4

image5

image6

image7

image8

image9

image10

image11

image12

image13

image14

image15