Bussiness plan

profilebusslum14
BudgetBUS599.xlsx
Home>Business & Finance homework help>Marketing homework help>Bussiness plan

WelcomeDemo

Welcome!
Thank you for trying out Business Plan Financials from Planning Shop. 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, The Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. Note that this demo copy of Business Plan Financials is deliberately feature-limited. We restrict you to just one product, one capital investment, one loan and 5 capital expenditures. If you purchase the Business Plan Financials, you get access to up to 10 products, 60 capital expenditures, 15 capital investments, and 20 loans. Also, the watermark that appears and prints on each page willbe removed. To use the Business Plan Financials workbook, first go to the Planning Shop tab of the Excel Ribbon.
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 in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the Planning Shop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
Version 2.7 Copyright © 2003-2012 Planning Shop

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 2007 for Windows: To enable macros: 1. Click the "Options" button in the Security Warning that appears at the top of this page.
2. A "Security Alert - Macros & Active X" window should appear. 3. Select the "Enable this content" radio button 4. Click the "OK" button. Your workbook should be ready to use now. If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2007 on Windows - Enabling Macros"
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 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 2010 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use.
Excel 2008 for Mac: Excel 2008 for Mac does not support Macros or Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version of Business Plan Financials from PlanningShop.
Excel 2007 on Windows - Enabling Macros
1. From the Windows Ribbon, Select the circular "Windows" button in the upper left. 2. From the drop-down menu that appears, press the Excel Options button in the lower right.
3. From the "Excel Options" pop-up, select Trust Center on the left side. 4. Select Trust Center Settings…. In the lower right.
5. In the "Trust Center" pop-up, select "Macro Settings" on the left side. 6. Then, select the Disable all macros except digitally signed macros. (This works because the Planning Shop signs all its workbooks with digital certificates.) 7. Press OK twice.
Excel 2010 and Excel 2013 on Windows - Enabling Macros
Note: The procedure is exactly the same for Excel 2010 and Excel 2013, even though the Excel 2013 has a slightly different look than these screenshots. 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

ERASE ME WelcomeMac

Welcome to the Mac Version of Business Plan Financials
Thank you for purchasing Planning Shop's Business Plan Financials. 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, The 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: 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 "ORIGINAL_PlanningShop_BusinessPlanFinancialsMac(2.7)" 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. You installed the Mac version of the Business Plan Financials product, which does not have the Planning Shop tab available in the Excel Ribbon (unlike the Windows version). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
Start with the "Setup" worksheet. Enter your data, and then work your way through the workbook, one worksheet at a time, by clicking the next worksheet to the right. There are 23 worksheets/charts in this workbook. The last one (furthest to the right) is "NS5Yr." 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 in-depth help and assistance, refer to the Business Plan Financials Help" PDF file in your PlanningShop folder. The document contains step-by-step instructions and includes a "Frequently Asked Questions" section. To get started, find the Excel worksheet listing (each worksheet is listed on a tab) along the bottom of the Excel window. Click on the "Setup" tab to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
Version 2.7 Copyright © 2003-2012 Planning Shop

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 2007, Excel 2010, Excel 2013, but the functionality is the same.
Excel 2007 for Windows:
Excel 2010 for Windows:
Excel 2013 for Windows:
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, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain 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.
Version 2.8 Copyright © 2003-2014 PlanningShop

MacVsWindows

About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows 8 with Microsoft Excel 2013
2. Microsoft Windows 7 with Microsoft Excel 2010 .�
3. Microsoft Windows 7 with Microsoft Excel 2007
4. Microsoft Windows Vista with Microsoft Excel 2007
Mac
5. Mac OS X Lion (10.7) with Microsoft Excel 2011
If you use Windows (#1 - #3 above), then you need to install PlanningShop_BizPlanFin(2.8).exe.
If you use Mac (#4 above), you need to install PlanningShop_BizPlanFinMac(2.8).dmg
Differences between Mac and Windows
Both the Mac and Windows versions of PlanningShop's Business Plan Financials product will produce high quality, detailed financial information for your business plan. However, there are some slight differences between the functionality in Mac and Windows. These differences don't affect the data in your business plan, but they do affect the user-friendliness of the Business Plan Financials workbook. We did our very best to make the Windows and Mac versions as similar as possible. However, Microsoft does not support customization of the Excel toolbar on Mac. Therefore, while we made every effort to preserve as much functionality as possible on the Mac, there were a few things we were not able to do:
1) There is no PlanningShop Toolbar in the Business Plan Financials for Mac. Instead, you will need to navigate between worksheets and charts using the Excel worksheet tabs (along the bottom edge of the workbook).
2) Business Plan Financials Help is not available directly from Excel. Instead, you should open the BizPlanFin_Help(2.7).PDF file that was copied to your Mac alongside the PlanningShop_BizPlanFinMac(2.8).XLS or PlanningShop_BizPlanFinMac(2.8).XLSM file.
We are as disappointed as you are that we can't provide the same level of functionality in Mac as we do for Windows. We very much hope that Microsoft will remedy the situation in the next release of Excel for Mac, and that we'll then be able to offer identical functionality.
Moving your Business Plan Financials workbook between Mac and Windows
We advise you to completely edit your Business Plan Financials workbook on either Mac or Windows, and to not switch between the two platforms. If you switch between platforms, you may find that the Planning Shop toolbar, menus, online help, and macros permanently disappear.

Setup

Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Fruitfit Company
What month will you officially start your company? August
What year will you officially start your company? 2018
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? Two
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? 30
Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter any number of days between 0 and 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.)? $36
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%).

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.		 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 any number of days between 0 and 120.
Author: If you're not sure what percentage to enter here, leave it at the default (15%).
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).
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.

Setup & Assumptions

SalesProj

Sales Projections
Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.		 2018 2019 2020 2021 2022
Assumptions August September October November December January February March April May June July TOTAL August September October November December January February March April May June July TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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.		 250000
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.		 255000
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.		 260100 265302 270608 276020 281541 287171 292915 298773 304749 310844 3353022 317060 323402 329870 336467 343196 350060 357062 364203 371487 378917 386495 394225 4252443 1230615
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 1305939 1385873 1470699 5393126 1560718 1656246 1757622 1865202 6839788 8674505
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.
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.		 $2
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.		 $2
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.		 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2
Gross Sales $500,000 $510,000 $520,200 $530,604 $541,216 $552,040 $563,081 $574,343 $585,830 $597,546 $609,497 $621,687 $6,706,045 $649,974 $662,973 $676,233 $689,758 $703,553 $717,624 $731,976 $746,616 $761,548 $776,779 $792,315 $808,161 $8,717,509 $2,585,830 $2,744,104 $2,912,065 $3,090,307 $11,332,306 $3,361,445 $3,567,192 $3,785,533 $4,017,238 $14,731,407 $19,150,061
(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?
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.		 15.00%
Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?		 $37,500 $38,250 $39,015 $39,795 $40,591 $41,403 $42,231 $43,076 $43,937 $44,816 $45,712 $46,627 $502,953 $48,748 $49,723 $50,717 $51,732 $52,766 $53,822 $54,898 $55,996 $57,116 $58,258 $59,424 $60,612 $653,813 $193,937 $205,808 $218,405 $231,773 $849,923 $252,108 $267,539 $283,915 $301,293 $1,104,856 $1,436,255
(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.		 $15,000.00 $15,300 $15,606.00 $15,918.12 $16,236.48 $16,561.21 $16,892.44 $17,230.29 $17,574.89 $17,926.39 $18,284.92 $18,650.61 $201,181 $19,499.22 $19,889.20 $20,286.99 $20,692.73 $21,106.58 $21,528.71 $21,959.29 $22,398.47 $22,846.44 $23,303.37 $23,769.44 $24,244.83 $261,525 $77,574.91 $82,323.12 $87,361.95 $92,709.20 $339,969 $100,843.34 $107,015.76 $113,565.98 $120,517.13 $441,942 $574,501.83
Net Sales $447,500 $456,450 $465,579 $474,891 $484,388 $494,076 $503,958 $514,037 $524,318 $534,804 $545,500 $556,410 $6,001,910 $581,727 $593,361 $605,228 $617,333 $629,680 $642,273 $655,119 $668,221 $681,585 $695,217 $709,122 $723,304 $7,802,170 $2,314,318 $2,455,973 $2,606,298 $2,765,825 $10,142,414 $3,008,493 $3,192,637 $3,388,052 $3,595,428 $13,184,609 $17,139,305
(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.		 $250,000.00 $255,000 $260,100 $265,302 $270,608 $276,020 $281,541 $287,171 $292,915 $298,773 $304,749 $310,844 $3,353,022 $324,987 $331,487 $338,116 $344,879 $351,776 $358,812 $365,988 $373,308 $380,774 $388,390 $396,157 $404,080 $4,358,754 $1,292,915 $1,372,052 $1,456,033 $1,545,153 $5,666,153 $1,680,722 $1,783,596 $1,892,766 $2,008,619 $7,365,704 $9,575,030
GROSS PROFIT $197,500 $201,450 $205,479 $209,589 $213,780 $218,056 $222,417 $226,865 $231,403 $236,031 $240,751 $245,566 $2,648,888 $256,740 $261,874 $267,112 $272,454 $277,903 $283,461 $289,131 $294,913 $300,811 $306,828 $312,964 $319,224 $3,443,416 $1,021,403 $1,083,921 $1,150,266 $1,220,671 $4,476,261 $1,327,771 $1,409,041 $1,495,285 $1,586,809 $5,818,906 $7,564,274
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 2.00% 200000 204000 208080 212242 216486 220816 225232 229737 234332 239019 243799 248675 2682418 253648.4 258721 263896 269174 274557 280048 285649 291362 297189 303133 309196 315380 3401955 984492
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 1044751 1108698 1176559 4314501 1248574 1324997 1406097 1492162 5471830 6939604
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.		 $2
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.		 $2
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.		 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2
Gross Sales $400,000 $408,000 $416,160 $424,483 $432,973 $441,632 $450,465 $459,474 $468,664 $478,037 $487,598 $497,350 $5,364,836 $519,979 $530,379 $540,986 $551,806 $562,842 $574,099 $585,581 $597,293 $609,238 $621,423 $633,852 $646,529 $6,974,007 $2,068,664 $2,195,283 $2,329,652 $2,472,245 $9,065,845 $2,689,156 $2,853,754 $3,028,426 $3,213,790 $11,785,126 $15,320,049
(Commissions) 50.00% 15.00% $30,000 $30,600 $31,212 $31,836 $32,473 $33,122 $33,785 $34,461 $35,150 $35,853 $36,570 $37,301 $402,363 $38,998 $39,778 $40,574 $41,385 $42,213 $43,057 $43,919 $44,797 $45,693 $46,607 $47,539 $48,490 $523,051 $155,150 $164,646 $174,724 $185,418 $679,938 $201,687 $214,032 $227,132 $241,034 $883,884 $1,149,004
(Returns and Allowances) 3.00% $12,000 $12,240 $12,485 $12,734 $12,989 $13,249 $13,514 $13,784 $14,060 $14,341 $14,628 $14,920 $160,945 $15,599 $15,911 $16,230 $16,554 $16,885 $17,223 $17,567 $17,919 $18,277 $18,643 $19,016 $19,396 $209,220 $62,060 $65,858 $69,890 $74,167 $271,975 $80,675 $85,613 $90,853 $96,414 $353,554 $459,601
Net Sales $358,000 $365,160 $372,463 $379,912 $387,511 $395,261 $403,166 $411,229 $419,454 $427,843 $436,400 $445,128 $4,801,528 $465,381 $474,689 $484,183 $493,866 $503,744 $513,819 $524,095 $534,577 $545,268 $556,174 $567,297 $578,643 $6,241,736 $1,851,455 $1,964,778 $2,085,039 $2,212,660 $8,113,931 $2,406,794 $2,554,110 $2,710,441 $2,876,342 $10,547,688 $13,711,444
(Cost of Goods Sold) 50.00% $200,000 $204,000 $208,080 $212,242 $216,486 $220,816 $225,232 $229,737 $234,332 $239,019 $243,799 $248,675 $2,682,418 $259,990 $265,189 $270,493 $275,903 $281,421 $287,049 $292,790 $298,646 $304,619 $310,712 $316,926 $323,264 $3,487,003 $1,034,332 $1,097,642 $1,164,826 $1,236,123 $4,532,923 $1,344,578 $1,426,877 $1,514,213 $1,606,895 $5,892,563 $7,660,024
GROSS PROFIT $158,000 $161,160 $164,383 $167,671 $171,024 $174,445 $177,934 $181,492 $185,122 $188,825 $192,601 $196,453 $2,119,110 $205,392 $209,500 $213,690 $217,963 $222,323 $226,769 $231,304 $235,931 $240,649 $245,462 $250,371 $255,379 $2,754,733 $817,122 $867,137 $920,213 $976,537 $3,581,009 $1,062,217 $1,127,233 $1,196,228 $1,269,447 $4,655,125 $6,051,419
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 & 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 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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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 $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 $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 $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 $0 $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 $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 $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 & 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"

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 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 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
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
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.
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross 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 $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 $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 $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 $0 $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 $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 $0 $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 450000 459000 468180 477544 487094 496836 506773 516909 527247 537792 548547 559518 6035440 570709 582123 593765 605641 617754 630109 642711 655565 668676 682050 695691 709605 7654398 2215108 2350690 2494571 2647259 9707627 2809292 2981243 3163719 3357364 12311618 15614109
Total Gross Sales $900,000 $918,000 $936,360 $955,087 $974,189 $993,673 $1,013,546 $1,033,817 $1,054,493 $1,075,583 $1,097,095 $1,119,037 $12,070,881 $1,169,953 $1,193,352 $1,217,219 $1,241,564 $1,266,395 $1,291,723 $1,317,557 $1,343,908 $1,370,786 $1,398,202 $1,426,166 $1,454,690 $15,691,515 $4,654,495 $4,939,387 $5,241,717 $5,562,552 $20,398,151 $6,050,601 $6,420,946 $6,813,959 $7,231,028 $26,516,533 $34,470,110
(Total Commissions) $67,500 $68,850 $70,227 $71,632 $73,064 $74,525 $76,016 $77,536 $79,087 $80,669 $82,282 $83,928 $905,316 $87,746 $89,501 $91,291 $93,117 $94,980 $96,879 $98,817 $100,793 $102,809 $104,865 $106,962 $109,102 $1,176,864 $349,087 $370,454 $393,129 $417,191 $1,529,861 $453,795 $481,571 $511,047 $542,327 $1,988,740 $2,585,258
(Total Returns and Allowances) $27,000 $27,540 $28,091 $28,653 $29,226 $29,810 $30,406 $31,015 $31,635 $32,267 $32,913 $33,571 $362,126 $35,099 $35,801 $36,517 $37,247 $37,992 $38,752 $39,527 $40,317 $41,124 $41,946 $42,785 $43,641 $470,745 $139,635 $148,182 $157,252 $166,877 $611,945 $181,518 $192,628 $204,419 $216,931 $795,496 $1,034,103
Total Net Sales $805,500 $821,610 $838,042 $854,803 $871,899 $889,337 $907,124 $925,266 $943,772 $962,647 $981,900 $1,001,538 $10,803,438 $1,047,108 $1,068,050 $1,089,411 $1,111,199 $1,133,423 $1,156,092 $1,179,214 $1,202,798 $1,226,854 $1,251,391 $1,276,419 $1,301,947 $14,043,906 $4,165,773 $4,420,752 $4,691,337 $4,978,484 $18,256,346 $5,415,287 $5,746,746 $6,098,493 $6,471,770 $23,732,297 $30,850,748
(Total Cost of Goods Sold) $450,000 $459,000 $468,180 $477,544 $487,094 $496,836 $506,773 $516,909 $527,247 $537,792 $548,547 $559,518 $6,035,440 $584,977 $596,676 $608,610 $620,782 $633,197 $645,861 $658,779 $671,954 $685,393 $699,101 $713,083 $727,345 $7,845,758 $2,327,247 $2,469,694 $2,620,859 $2,781,276 $10,199,076 $3,025,300 $3,210,473 $3,406,979 $3,615,514 $13,258,266 $17,235,055
TOTAL GROSS PROFIT $355,500 $362,610 $369,862 $377,259 $384,805 $392,501 $400,351 $408,358 $416,525 $424,855 $433,353 $442,020 $4,767,998 $462,131 $471,374 $480,802 $490,418 $500,226 $510,230 $520,435 $530,844 $541,461 $552,290 $563,336 $574,602 $6,198,149 $1,838,525 $1,951,058 $2,070,478 $2,197,208 $8,057,270 $2,389,987 $2,536,274 $2,691,514 $2,856,256 $10,474,031 $13,615,693

Sales Projections

Inventory

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.		 2018 2019 2020 2021 2022
August September October November December January February March April May June July TOTAL August September October November December January February March April May June July TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
Product Line 1
Cost of Goods Sold $250,000
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.		 $255,000 $260,100 $265,302 $270,608 $276,020 $281,541 $287,171 $292,915 $298,773 $304,749 $310,844 $3,353,022 $324,987 $331,487 $338,116 $344,879 $351,776 $358,812 $365,988 $373,308 $380,774 $388,390 $396,157 $404,080 $4,358,754 $1,292,915 $1,372,052 $1,456,033 $1,545,153 $5,666,153 $1,680,722 $1,783,596 $1,892,766 $2,008,619 $7,365,704 $9,575,030
Ingredients $500
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.		 $510 $520 $531 $541 $552 $563 $574 $586 $598 $609 $622 $6,706 $650 $663 $676 $690 $704 $718 $732 $747 $762 $777 $792 $808 $8,718 $2,586 $2,744 $2,912 $3,090 $11,332 $3,361 $3,567 $3,786 $4,017 $14,731 $19,150
Bottles/caps $750 $765 $780 $796 $812 $828 $845 $862 $879 $896 $914 $933 $10,059 $975 $994 $1,014 $1,035 $1,055 $1,076 $1,098 $1,120 $1,142 $1,165 $1,188 $1,212 $13,076 $3,879 $4,116 $4,368 $4,635 $16,998 $5,042 $5,351 $5,678 $6,026 $22,097 $28,725
Labels $250 $255 $260 $265 $271 $276 $282 $287 $293 $299 $305 $311 $3,353 $325 $331 $338 $345 $352 $359 $366 $373 $381 $388 $396 $404 $4,359 $1,293 $1,372 $1,456 $1,545 $5,666 $1,681 $1,784 $1,893 $2,009 $7,366 $9,575
Cartons $500 $510 $520 $531 $541 $552 $563 $574 $586 $598 $609 $622 $6,706 $650 $663 $676 $690 $704 $718 $732 $747 $762 $777 $792 $808 $8,718 $2,586 $2,744 $2,912 $3,090 $11,332 $3,361 $3,567 $3,786 $4,017 $14,731 $19,150
Total Inventory Expense $2,000
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.) 		$2,040 $2,081 $2,122 $2,165 $2,208 $2,252 $2,297 $2,343 $2,390 $2,438 $2,487 $26,824 $2,600 $2,652 $2,705 $2,759 $2,814 $2,870 $2,928 $2,986 $3,046 $3,107 $3,169 $3,233 $34,870 $10,343 $10,976 $11,648 $12,361 $45,329 $13,446 $14,269 $15,142 $16,069 $58,926 $76,600
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 $200,000 $204,000 $208,080 $212,242 $216,486 $220,816 $225,232 $229,737 $234,332 $239,019 $243,799 $248,675 $2,682,418 $259,990 $265,189 $270,493 $275,903 $281,421 $287,049 $292,790 $298,646 $304,619 $310,712 $316,926 $323,264 $3,487,003 $1,034,332 $1,097,642 $1,164,826 $1,236,123 $4,532,923 $1,344,578 $1,426,877 $1,514,213 $1,606,895 $5,892,563 $7,660,024
Ingredients $500
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.		 $510 $520 $531 $541 $552 $563 $574 $586 $598 $609 $622 $6,706 $650 $663 $676 $690 $704 $718 $732 $747 $762 $777 $792 $808 $8,718 $2,586 $2,744 $2,912 $3,090 $11,332 $3,361 $3,567 $3,786 $4,017 $14,731 $19,150
Bottles/caps $750 $765 $780 $796 $812 $828 $845 $862 $879 $896 $914 $933 $10,059 $975 $994 $1,014 $1,035 $1,055 $1,076 $1,098 $1,120 $1,142 $1,165 $1,188 $1,212 $13,076 $3,879 $4,116 $4,368 $4,635 $16,998 $5,042 $5,351 $5,678 $6,026 $22,097 $28,725
Labels $250 $255 $260 $265 $271 $276 $282 $287 $293 $299 $305 $311 $3,353 $325 $331 $338 $345 $352 $359 $366 $373 $381 $388 $396 $404 $4,359 $1,293 $1,372 $1,456 $1,545 $5,666 $1,681 $1,784 $1,893 $2,009 $7,366 $9,575
Cartons $500 $510 $520 $531 $541 $552 $563 $574 $586 $598 $609 $622 $6,706 $650 $663 $676 $690 $704 $718 $732 $747 $762 $777 $792 $808 $8,718 $2,586 $2,744 $2,912 $3,090 $11,332 $3,361 $3,567 $3,786 $4,017 $14,731 $19,150
Total Inventory Expense $2,000 $2,040 $2,081 $2,122 $2,165 $2,208 $2,252 $2,297 $2,343 $2,390 $2,438 $2,487 $26,824 $2,600 $2,652 $2,705 $2,759 $2,814 $2,870 $2,928 $2,986 $3,046 $3,107 $3,169 $3,233 $34,870 $10,343 $10,976 $11,648 $12,361 $45,329 $13,446 $14,269 $15,142 $16,069 $58,926 $76,600
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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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.
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.
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 $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 $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 $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 $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 $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"

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.
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.
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.		 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 $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.
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.)
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"
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 $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 $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 $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 $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 $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"

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.
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.		 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 $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.
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"
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"
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.
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.
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"
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 $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 $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 $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 $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 $0 $0 $0 $0 $0 $0
GRAND TOTAL INVENTORY $4,000 $4,080 $4,162 $4,245 $4,330 $4,416 $4,505 $4,595 $4,687 $4,780 $4,876 $4,973 $53,648 $5,200 $5,304 $5,410 $5,518 $5,628 $5,741 $5,856 $5,973 $6,092 $6,214 $6,339 $6,465 $69,740 $20,687 $21,953 $23,297 $24,722 $90,658 $26,892 $28,538 $30,284 $32,138 $117,851 $153,200

CapEx

Capital Purchases
Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.
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 July-2014
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.		 Aug
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.		 2018
Author: Enter the year you will purchase the item(s).		 1
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.		 $0
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 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 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: 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.
Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.		 treating water $500 Aug 2018 1 $0
compounding ingredients $750 Aug 2018 1 $0
carbonating product $250 Aug 2018 1 $0
filling product $500 Aug 2018 1 $0
packaging $500 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Computer Hardware/Software
Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.

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.		 Major $10,000 Aug 2018 1 $0
Minor $5,000 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Telecommunications
Author: Telecommunications includes phone systems, fax machines, etc.

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.		 media and network equipment $5,000 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Item Name (change name here) $0 Aug 2018 1 $0
Land
Author: Land purchases are not depreciable.
Direct costs $10,000 Aug 2018 Land is a non-depreciable asset
Purchase cost $60,000 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018
Item Name (change name here) $0 Aug 2018

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.		 2018 2019 2020 2021 2022
August September October November December January February March April May June July TOTAL August September October November December January February March April May June July TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL TOTAL
Management
# Salaried Employees 10.00
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". 		10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
Avg Salary per employee $5,000
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).		 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $60,000 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $62,100 $16,068 $16,068 $16,068 $16,068 $64,274 $16,631 $16,631 $16,631 $16,631 $66,523 $68,851
Benefits (across all employees) $4,167
Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.		 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $50,000 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $52,500 $13,781 $13,781 $13,781 $13,781 $55,125 $14,470 $14,470 $14,470 $14,470 $57,881 $60,775
Payroll Taxes (across all employees) $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $90,000 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $7,763 $93,150 $24,103 $24,103 $24,103 $24,103 $96,410 $24,946 $24,946 $24,946 $24,946 $99,785 $103,277
Total Costs $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $61,667 $740,000 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $63,888 $766,650 $198,568 $198,568 $198,568 $198,568 $794,270 $205,724 $205,724 $205,724 $205,724 $822,897 $852,566
Administrative/Support
# Salaried Employees 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00
Avg Salary per employee $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $84,000 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $7,245 $86,940 $22,496 $22,496 $22,496 $22,496 $89,983 $23,283 $23,283 $23,283 $23,283 $93,132 $96,392
Benefits (across all employees) $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $25,000 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $26,250 $6,891 $6,891 $6,891 $6,891 $27,563 $7,235 $7,235 $7,235 $7,235 $28,941 $30,388
Payroll Taxes (across all employees) $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $5,250 $63,000 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $5,434 $65,205 $16,872 $16,872 $16,872 $16,872 $67,487 $17,462 $17,462 $17,462 $17,462 $69,849 $72,294
Total Costs $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $42,333 $508,000 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $43,846 $526,155 $136,241 $136,241 $136,241 $136,241 $544,964 $141,113 $141,113 $141,113 $141,113 $564,451 $584,641
Sales/Marketing
# Salaried Employees 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
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!		 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Avg Salary per employee $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $60,000 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $62,100 $16,068 $16,068 $16,068 $16,068 $64,274 $16,631 $16,631 $16,631 $16,631 $66,523 $68,851
Benefits (across all employees) $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $15,000 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $1,313 $15,750 $4,134 $4,134 $4,134 $4,134 $16,538 $4,341 $4,341 $4,341 $4,341 $17,364 $18,233
Payroll Taxes (across all employees) $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $27,000 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $27,945 $7,231 $7,231 $7,231 $7,231 $28,923 $7,484 $7,484 $7,484 $7,484 $29,935 $30,983
Total Costs $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $18,500 $222,000 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $19,166 $229,995 $59,570 $59,570 $59,570 $59,570 $238,281 $61,717 $61,717 $61,717 $61,717 $246,869 $255,770
Operations/Production
# Salaried Employees 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00
Avg Salary per employee $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $2,070 $24,840 $6,427 $6,427 $6,427 $6,427 $25,709 $6,652 $6,652 $6,652 $6,652 $26,609 $27,541
Benefits (across all employees) $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $100,000 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $8,750 $105,000 $27,563 $27,563 $27,563 $27,563 $110,250 $28,941 $28,941 $28,941 $28,941 $115,763 $121,551
Payroll Taxes (across all employees) $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $72,000 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $6,210 $74,520 $19,282 $19,282 $19,282 $19,282 $77,128 $19,957 $19,957 $19,957 $19,957 $79,828 $82,622
Total Costs $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $54,333 $652,000 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $56,360 $676,320 $175,392 $175,392 $175,392 $175,392 $701,566 $181,944 $181,944 $181,944 $181,944 $727,775 $754,983
Other
# Salaried Employees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
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 $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 $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 $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 $0 $0 $0 $0 $0 $0
Part-Time / Hourly Employees
# Part-Time Employees 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!
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".
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).
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!
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 5 5 5 5 5 5 5 5
Avg. Hours per Hourly Employee 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 12.0 12.0 12.0 12.0 12.0 12.0 $12.00 $12.00 48.0
Avg Hourly Rate $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.35 $10.71 $10.71 $10.71 $10.71 $11.09 $11.09 $11.09 $11.09 $11.48
Calculated Wages Per Hourly Employee $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $480 $41 $41 $41 $41 $41 $41 $41 $41 $41 $41 $41 $41 $497 $129 $129 $129 $129 $514 $133 $133 $133 $133 $532 $551
Wages $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $207 $207 $207 $207 $207 $207 $207 $207 $207 $207 $207 $207 $2,484 $643 $643 $643 $643 $2,571 $665 $665 $665 $665 $2,661 $6,321
Benefits (across all employees) $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $180 $16 $16 $16 $16 $16 $16 $16 $16 $16 $16 $16 $16 $189 $50 $50 $50 $50 $198 $52 $52 $52 $52 $208 $219
Payroll Taxes (across all employees) $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $360 $31 $31 $31 $31 $31 $31 $31 $31 $31 $31 $31 $31 $373 $96 $96 $96 $96 $386 $100 $100 $100 $100 $399 $413
Total Costs $245 $245 $245 $245 $245 $245 $245 $245 $245 $245 $245 $245 $2,940 $254 $254 $254 $254 $254 $254 $254 $254 $254 $254 $254 $254 $3,046 $789 $789 $789 $789 $3,155 $817 $817 $817 $817 $3,268 $6,953
TOTAL
# Full Time Employees 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38 38
# Part-Time Employees 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
Salary/Wages $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $1,682,400 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $1,741,284 $450,557 $450,557 $450,557 $450,557 $1,802,229 $466,327 $466,327 $466,327 $466,327 $1,865,307 $1,934,159
Benefits $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $190,180 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $199,689 $52,418 $52,418 $52,418 $52,418 $209,673 $55,039 $55,039 $55,039 $55,039 $220,157 $231,165
Payroll Taxes $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $252,360 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $261,193 $67,584 $67,584 $67,584 $67,584 $270,334 $69,949 $69,949 $69,949 $69,949 $279,796 $289,589
GRAND TOTAL COSTS $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $177,078 $2,124,940 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $183,514 $2,202,166 $570,559 $570,559 $570,559 $570,559 $2,282,237 $591,315 $591,315 $591,315 $591,315 $2,365,260 $2,454,913

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		 2018 2019 2020 2021 2022
August September October November December January February March April May June July TOTAL August September October November December January February March April May June July TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
Professional Assistance
Marketing/PR Consultants $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $900 $900 $900 $900 $3,600 $900 $900 $900 $900 $3,600 $3,600
Advertising Agencies $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $900 $900 $900 $900 $3,600 $900 $900 $900 $900 $3,600 $3,600
Social Media Specialists $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $600 $600 $600 $600 $2,400 $600 $600 $600 $600 $2,400 $2,400
SEO Specialist $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800
Graphic/Web Design $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800
Brochures/Leaflets/Flyers $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $2,040 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $2,040 $510 $510 $510 $510 $2,040 $510 $510 $510 $510 $2,040 $2,040
Signs/Billboards $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $1,080 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $1,080 $270 $270 $270 $270 $1,080 $270 $270 $270 $270 $1,080 $1,080
Merchandising Displays $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600 $150 $150 $150 $150 $600 $150 $150 $150 $150 $600 $600
Sampling/Premiums $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800
Media Advertising
Print (newspaper, etc.) $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600 $150 $150 $150 $150 $600 $150 $150 $150 $150 $600 $600
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 $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		 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800
Other Media $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $840 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $840 $210 $210 $210 $210 $840 $210 $210 $210 $210 $840 $840
Phone Directories $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $1,080 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $90 $1,080 $270 $270 $270 $270 $1,080 $270 $270 $270 $270 $1,080 $1,080
Advertising Specialties $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $1,440 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $1,440 $360 $360 $360 $360 $1,440 $360 $360 $360 $360 $1,440 $1,440
Direct Mail $110 $110 $110 $110 $110 $110 $110 $110 $110 $110 $110 $110 $1,320 $110 $110 $110 $110 $110 $110 $110 $110 $110 $110 $110 $110 $1,320 $330 $330 $330 $330 $1,320 $330 $330 $330 $330 $1,320 $1,320
Website
Development/Programming $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $4,800 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $4,800 $1,200 $1,200 $1,200 $1,200 $4,800 $1,200 $1,200 $1,200 $1,200 $4,800 $4,800
Maintenance and Hosting $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200 $300 $300 $300 $300 $1,200 $300 $300 $300 $300 $1,200 $1,200
Trade Shows
Fees and Setup $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $600 $600 $600 $600 $2,400 $600 $600 $600 $600 $2,400 $2,400
Travel/Shipping $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200 $300 $300 $300 $300 $1,200 $300 $300 $300 $300 $1,200 $1,200
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 $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 $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 $0 $0 $0 $0 $0 $0
Entertainment $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800
Other $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $900 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $900 $225 $225 $225 $225 $900 $225 $225 $225 $225 $900 $900
GRAND TOTAL COSTS $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $38,100 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $38,100 $9,525 $9,525 $9,525 $9,525 $38,100 $9,525 $9,525 $9,525 $9,525 $38,100 $38,100

Marketing Budget

ProSvs

Professional Services
Author: For information about this worksheet, see Chapter 13, "Management & Organization" in Successful Business Plan: Secrets & Strategies.		 2018 2019 2020 2021 2022
General
Author: For professional services related to marketing, use the Marketing Budget spreadsheets.
Attorneys $2,000
Author: The number you enter here will be equally divided among the 12 months of the year on your Income Statement.		 $2,000 $2,000 $2,000 $2,000
Accountants $1,500 $1,500 $1,500 $1,500 $1,500
Management consultants $2,000 $2,000 $2,000 $2,000 $2,000
Industry specialists $2,000 $2,000 $2,000 $2,000 $2,000
Technology consultants $1,500 $1,500 $1,500 $1,500 $1,500
Other (change title here) $0 $0 $0 $0 $0
Other (change title here) $0 $0 $0 $0 $0
Total Costs $9,000 $9,000 $9,000 $9,000 $9,000
GRAND TOTAL COSTS $9,000 $9,000 $9,000 $9,000 $9,000

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 July-2014
Melinda Cates $840
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.		 Aug
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.		 2018
Author: Enter the year you will receive the investment cash.		 Capital investments are not paid back on a loan schedule.
Glass Bottles $3,000 Aug 2018
Labels $300 Aug 2018
Cardboard Cartons $500 Aug 2018
NAB Ingredients $600 Aug 2018
Metal Caps $40,000 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Investment Source Name $0 Aug 2018
Total Capital Investments $45,240
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.
Friends and Family $20,000 Aug 2018 24
Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.		 5.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Aug 2018 12 0.00%
Author: Enter the loan's annual interest rate.
Total Loans $20,000
TOTAL INVESTMENTS AND LOANS $65,240

Capital Investments and Loans

IncSt

Income Statements
Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.		 2018 2019 2020 2021 2022
August September October November December January February March April May June July TOTAL August September October November December January February March April May June July TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
INCOME
Gross Sales $900,000 $918,000 $936,360 $955,087 $974,189 $993,673 $1,013,546 $1,033,817 $1,054,493 $1,075,583 $1,097,095 $1,119,037 $12,070,881 $1,169,953 $1,193,352.12 $1,217,219 $1,241,564 $1,266,395 $1,291,723 $1,317,557 $1,343,908 $1,370,786 $1,398,202 $1,426,166 $1,454,690 $15,691,515 $4,654,495 $4,939,387 $5,241,717 $5,562,552 $20,398,151 $6,050,601 $6,420,946 $6,813,959 $7,231,028 $26,516,533 $34,470,110
(Commissions) $67,500 $68,850 $70,227 $71,632 $73,064 $74,525 $76,016 $77,536 $79,087 $80,669 $82,282 $83,928 $905,316 $87,746 $89,501.41 $91,291 $93,117 $94,980 $96,879 $98,817 $100,793 $102,809 $104,865 $106,962 $109,102 $1,176,864 $349,087 $370,454 $393,129 $417,191 $1,529,861 $453,795 $481,571 $511,047 $542,327 $1,988,740 $2,585,258
(Returns and allowances) $27,000 $27,540 $28,091 $28,653 $29,226 $29,810 $30,406 $31,015 $31,635 $32,267 $32,913 $33,571 $362,126 $35,099 $35,800.56 $36,517 $37,247 $37,992 $38,752 $39,527 $40,317 $41,124 $41,946 $42,785 $43,641 $470,745 $139,635 $148,182 $157,252 $166,877 $611,945 $181,518 $192,628 $204,419 $216,931 $795,496 $1,034,103
Net Sales $805,500 $821,610 $838,042 $854,803 $871,899 $889,337 $907,124 $925,266 $943,772 $962,647 $981,900 $1,001,538 $10,803,438 $1,047,108 $1,068,050.14 $1,089,411 $1,111,199 $1,133,423 $1,156,092 $1,179,214 $1,202,798 $1,226,854 $1,251,391 $1,276,419 $1,301,947 $14,043,906 $4,165,773 $4,420,752 $4,691,337 $4,978,484 $18,256,346 $5,415,287 $5,746,746 $6,098,493 $6,471,770 $23,732,297 $30,850,748
(Cost of Goods) $450,000 $459,000 $468,180 $477,544 $487,094 $496,836 $506,773 $516,909 $527,247 $537,792 $548,547 $559,518 $6,035,440 $584,977 $596,676.06 $608,610 $620,782 $633,197 $645,861 $658,779 $671,954 $685,393 $699,101 $713,083 $727,345 $7,845,758 $2,327,247 $2,469,694 $2,620,859 $2,781,276 $10,199,076 $3,025,300 $3,210,473 $3,406,979 $3,615,514 $13,258,266 $17,235,055
GROSS PROFIT $355,500 $362,610 $369,862 $377,259 $384,805 $392,501 $400,351 $408,358 $416,525 $424,855 $433,353 $442,020 $4,767,998 $462,131 $471,374.09 $480,802 $490,418 $500,226 $510,230 $520,435 $530,844 $541,461 $552,290 $563,336 $574,602 $6,198,149 $1,838,525 $1,951,058 $2,070,478 $2,197,208 $8,057,270 $2,389,987 $2,536,274 $2,691,514 $2,856,256 $10,474,031 $13,615,693
EXPENSES - General and Administrative
Salaries and wages $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $140,200 $1,682,400 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $145,107 $1,741,284 $450,557 $450,557 $450,557 $450,557 $1,802,229 $466,327 $466,327 $466,327 $466,327 $1,865,307 $1,934,159
Employee benefits $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $15,848 $190,180 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $16,641 $199,689 $52,418 $52,418 $52,418 $52,418 $209,673 $55,039 $55,039 $55,039 $55,039 $220,157 $231,165
Payroll taxes $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $21,030 $252,360 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $21,766 $261,193 $67,584 $67,584 $67,584 $67,584 $270,334 $69,949 $69,949 $69,949 $69,949 $279,796 $289,589
Professional services $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $9,000 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $9,000 $2,250 $2,250 $2,250 $2,250 $9,000 $2,250 $2,250 $2,250 $2,250 $9,000 $9,000
Marketing and advertising $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $38,100 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $3,175 $38,100 $9,525 $9,525 $9,525 $9,525 $38,100 $9,525 $9,525 $9,525 $9,525 $38,100 $38,100
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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $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 $0 $0 $0 $0 $0 $0
Interest on loans $83 $80 $77 $73 $70 $67 $63 $60 $56 $53 $50 $46 $779 $43 $39 $36 $32 $29 $25 $22 $18 $14 $11 $7 $4 $280 $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 $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 $0 $0 $0 $0 $0 $0
TOTAL EXPENSES $181,087 $181,083 $181,080 $181,077 $181,073 $181,070 $181,067 $181,063 $181,060 $181,056 $181,053 $181,050 $2,172,819 $187,482 $187,478 $187,475 $187,471 $187,468 $187,464 $187,460 $187,457 $187,453 $187,450 $187,446 $187,442 $2,249,545 $582,334 $582,334 $582,334 $582,334 $2,329,337 $603,090 $603,090 $603,090 $603,090 $2,412,360 $2,502,013
Net income before taxes $174,413 $181,527 $188,782 $196,183 $203,731 $211,431 $219,284 $227,295 $235,465 $243,799 $252,300 $260,970 $2,595,179 $274,650 $283,896 $293,327 $302,947 $312,758 $322,766 $332,975 $343,387 $354,007 $364,840 $375,890 $387,160 $3,948,603 $1,256,191 $1,368,724 $1,488,144 $1,614,874 $5,727,933 $1,786,897 $1,933,184 $2,088,424 $2,253,166 $8,061,670 $11,113,680
Provision for taxes on income $43,603 $45,382 $47,196 $49,046 $50,933 $52,858 $54,821 $56,824 $58,866 $60,950 $63,075 $65,243 $648,795 $68,662 $70,974 $73,332 $75,737 $78,190 $80,692 $83,244 $85,847 $88,502 $91,210 $93,972 $96,790 $987,151 $314,048 $342,181 $372,036 $403,718 $1,431,983 $446,724 $483,296 $522,106 $563,291 $2,015,418 $2,778,420
NET PROFIT $130,810 $136,145 $141,587 $147,137 $152,798 $158,573 $164,463 $170,471 $176,599 $182,849 $189,225 $195,728 $1,946,385 $205,987 $212,922 $219,995 $227,210 $234,569 $242,075 $249,731 $257,540 $265,506 $273,630 $281,917 $290,370 $2,961,452 $942,143 $1,026,543 $1,116,108 $1,211,155 $4,295,950 $1,340,173 $1,449,888 $1,566,318 $1,689,874 $6,046,253 $8,335,260

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.		 2018 2019 2020 2021 2022
August September October November December January February March April May June July TOTAL August September October November December January February March April May June July TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
CASH RECEIPTS
Income from Sales
Cash Sales $675,000 $688,500 $702,270 $716,315 $730,642 $745,255 $760,160 $775,363 $790,870 $806,687 $822,821 $839,278 $9,053,161 $877,465 $895,014 $912,914 $931,173 $949,796 $968,792 $988,168 $1,007,931 $1,028,090 $1,048,652 $1,069,625 $1,091,017 $11,768,637 $3,490,871 $3,704,540 $3,931,288 $4,171,914 $15,298,614 $4,537,950 $4,815,709 $5,110,469 $5,423,271 $19,887,400 $25,852,582
Collections $0 $225,000 $229,500 $234,090 $238,772 $243,547 $248,418 $253,387 $258,454 $263,623 $268,896 $274,274 $2,737,961 $279,759 $292,488 $298,338 $304,305 $310,391 $316,599 $322,931 $329,389 $335,977 $342,697 $349,551 $356,542 $3,838,966 $1,139,422 $1,211,106 $1,285,235 $1,363,902 $4,999,664 $1,471,979 $1,574,374 $1,670,739 $1,773,001 $6,490,094 $8,501,986
Total Cash from Sales $675,000 $913,500 $931,770 $950,405 $969,414 $988,802 $1,008,578 $1,028,749 $1,049,324 $1,070,311 $1,091,717 $1,113,551 $11,791,122 $1,157,224 $1,187,502 $1,211,252 $1,235,477 $1,260,187 $1,285,391 $1,311,099 $1,337,321 $1,364,067 $1,391,348 $1,419,175 $1,447,559 $15,607,602 $4,630,293 $4,915,646 $5,216,523 $5,535,816 $20,298,278 $6,009,930 $6,390,084 $6,781,208 $7,196,272 $26,377,493 $34,354,568
Income from Financing
Interest Income $273
Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. 		$836 $1,377 $1,931 $2,500 $3,084 $3,683 $4,298 $4,928 $5,574 $6,237 $6,917 $41,638 $7,623 $8,353 $9,102 $9,869 $10,655 $11,460 $12,285 $13,130 $13,996 $14,882 $15,791 $16,720 $143,865 $59,049 $68,679 $79,002 $90,061 $296,791 $102,148 $115,114 $128,982 $143,809 $490,053 $857,475
Loan Proceeds $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,000 $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 $45,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $45,240 $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 $65,513 $836 $1,377 $1,931 $2,500 $3,084 $3,683 $4,298 $4,928 $5,574 $6,237 $6,917 $106,878 $7,623 $8,353 $9,102 $9,869 $10,655 $11,460 $12,285 $13,130 $13,996 $14,882 $15,791 $16,720 $143,865 $59,049 $68,679 $79,002 $90,061 $296,791 $102,148 $115,114 $128,982 $143,809 $490,053 $857,475
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 $0 $0 $0 $0 $0 $0
TOTAL CASH RECEIPTS $740,513 $914,336 $933,147 $952,337 $971,914 $991,886 $1,012,261 $1,033,047 $1,054,252 $1,075,885 $1,097,954 $1,120,468 $11,897,999 $1,164,847 $1,195,856 $1,220,354 $1,245,346 $1,270,842 $1,296,851 $1,323,383 $1,350,451 $1,378,063 $1,406,231 $1,434,966 $1,464,279 $15,751,467 $4,689,342 $4,984,325 $5,295,525 $5,625,877 $20,595,068 $6,112,078 $6,505,197 $6,910,190 $7,340,081 $26,867,546 $35,212,043
CASH DISBURSEMENTS
Inventory $4,000 $4,080 $4,162 $4,245 $4,330 $4,416 $4,505 $4,595 $4,687 $4,780 $4,876 $4,973 $53,648 $5,200 $5,304 $5,410 $5,518 $5,628 $5,741 $5,856 $5,973 $6,092 $6,214 $6,339 $6,465 $69,740 $20,687 $21,953 $23,297 $24,722 $90,658 $26,892 $28,538 $30,284 $32,138 $117,851 $153,200
Operating Expenses $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $181,003 $2,172,040 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $187,439 $2,249,266 $582,334 $582,334 $582,334 $582,334 $2,329,337 $603,090 $603,090 $603,090 $603,090 $2,412,360 $2,502,013
Commissions/Returns & Allowances $94,500 $96,390 $98,318 $100,284 $102,290 $104,336 $106,422 $108,551 $110,722 $112,936 $115,195 $117,499 $1,267,442 $122,845 $125,302 $127,808 $130,364 $132,971 $135,631 $138,344 $141,110 $143,933 $146,811 $149,747 $152,742 $1,647,609 $488,722 $518,636 $550,380 $584,068 $2,141,806 $635,313 $674,199 $715,466 $759,258 $2,784,236 $3,619,362
Capital Purchases $92,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $92,500 $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 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $10,529 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $10,529 $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 $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 $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 $0 $0 $0 $0 $0 $0
TOTAL CASH DISBURSEMENTS $372,881 $282,351 $284,360 $286,410 $288,500 $290,633 $292,808 $295,026 $297,289 $299,597 $301,952 $304,353 $3,596,160 $316,361 $318,922 $321,534 $324,198 $326,916 $329,688 $332,516 $335,400 $338,341 $341,342 $344,402 $347,524 $3,977,144 $1,091,743 $1,122,923 $1,156,011 $1,191,125 $4,561,801 $1,265,295 $1,305,827 $1,348,840 $1,394,486 $5,314,447 $6,274,575
NET CASH FLOW $367,632 $631,986 $648,787 $665,927 $683,413 $701,253 $719,453 $738,021 $756,963 $776,288 $796,002 $816,115 $8,301,839 $848,486 $876,934 $898,820 $921,148 $943,925 $967,163 $990,868 $1,015,051 $1,039,722 $1,064,889 $1,090,564 $1,116,755 $11,774,324 $3,597,599 $3,861,402 $4,139,514 $4,434,752 $16,033,267 $4,846,783 $5,199,370 $5,561,350 $5,945,595 $21,553,099 $28,937,468
Opening Cash Balance $5,000 $372,632 $1,004,618 $1,653,404 $2,319,331 $3,002,744 $3,703,997 $4,423,451 $5,161,471 $5,918,434 $6,694,722 $7,490,725 $8,306,839 $9,155,325 $10,032,259 $10,931,079 $11,852,227 $12,796,152 $13,763,315 $14,754,183 $15,769,234 $16,808,955 $17,873,844 $18,964,408 $20,081,163 $23,678,762 $27,540,164 $31,679,678 $36,114,430 $40,961,213 $46,160,584 $51,721,934 $57,667,529
Cash Receipts $740,513 $914,336 $933,147 $952,337 $971,914 $991,886 $1,012,261 $1,033,047 $1,054,252 $1,075,885 $1,097,954 $1,120,468 $1,164,847 $1,195,856 $1,220,354 $1,245,346 $1,270,842 $1,296,851 $1,323,383 $1,350,451 $1,378,063 $1,406,231 $1,434,966 $1,464,279 $4,689,342 $4,984,325 $5,295,525 $5,625,877 $6,112,078 $6,505,197 $6,910,190 $7,340,081 $35,212,043
Cash Disbursements $372,881 $282,351 $284,360 $286,410 $288,500 $290,633 $292,808 $295,026 $297,289 $299,597 $301,952 $304,353 $316,361 $318,922 $321,534 $324,198 $326,916 $329,688 $332,516 $335,400 $338,341 $341,342 $344,402 $347,524 $1,091,743 $1,122,923 $1,156,011 $1,191,125 $1,265,295 $1,305,827 $1,348,840 $1,394,486 $6,274,575
ENDING CASH BALANCE $372,632 $1,004,618 $1,653,404 $2,319,331 $3,002,744 $3,703,997 $4,423,451 $5,161,471 $5,918,434 $6,694,722 $7,490,725 $8,306,839 $8,306,839 $9,155,325 $10,032,259 $10,931,079 $11,852,227 $12,796,152 $13,763,315 $14,754,183 $15,769,234 $16,808,955 $17,873,844 $18,964,408 $20,081,163 $20,081,163 $23,678,762 $27,540,164 $31,679,678 $36,114,430 $36,114,430 $40,961,213 $46,160,584 $51,721,934 $57,667,529 $57,667,529 $86,604,997

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 Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet
Fruitfit Company Fruitfit Company Fruitfit Company Fruitfit Company Fruitfit Company Fruitfit Company Fruitfit Company Fruitfit Company
First Quarter Second Quarter Third Quarter Fourth Quarter 2019 2020 2021 2022
2018 2018 2018 2018
ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS
Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets
Cash $1,653,404 Cash $3,703,997 Cash $5,918,434 Cash $8,306,839 Cash $20,081,163 Cash $36,114,430 Cash $57,667,529 Cash $86,604,997
Accounts Receivable $234,090 Accounts Receivable $248,418 Accounts Receivable $263,623 Accounts Receivable $279,759 Accounts Receivable $363,672 Accounts Receivable $463,546 Accounts Receivable $602,586 Accounts Receivable $718,127
Inventory -$1,364,938 Inventory -$2,813,422 Inventory -$4,350,564 Inventory -$5,981,792 Inventory -$13,757,810 Inventory -$23,866,227 Inventory -$37,006,642 Inventory -$54,088,497
Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0
Total Current Assets $522,556 Total Current Assets $1,138,994 Total Current Assets $1,831,494 Total Current Assets $2,604,807 Total Current Assets $6,687,026 Total Current Assets $12,711,749 Total Current Assets $21,263,473 Total Current Assets $33,234,628
Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets
Land $70,000 Land $70,000 Land $70,000 Land $70,000 Land $70,000 Land $70,000 Land $70,000 Land $70,000
Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0
Equipment $2,500 Equipment $2,500 Equipment $2,500 Equipment $2,500 Equipment $2,500 Equipment $2,500 Equipment $2,500 Equipment $2,500
Computers & Telecommunications $20,000 Computers & Telecommunications $20,000 Computers & Telecommunications $20,000 Computers & Telecommunications $20,000 Computers & Telecommunications $20,000 Computers & Telecommunications $20,000 Computers & Telecommunications $20,000 Computers & Telecommunications $20,000
(Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0
Total Fixed Assets $92,500 Total Fixed Assets $92,500 Total Fixed Assets $92,500 Total Fixed Assets $92,500 Total Fixed Assets $92,500 Total Fixed Assets $92,500 Total Fixed Assets $92,500 Total Fixed Assets $92,500
Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0
TOTAL ASSETS $615,056 TOTAL ASSETS $1,231,494 TOTAL ASSETS $1,923,994 TOTAL ASSETS $2,697,307 TOTAL ASSETS $6,779,526 TOTAL ASSETS $12,804,249 TOTAL ASSETS $21,355,973 TOTAL ASSETS $33,327,128
LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES
Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities
Short-Term Notes Payable $9,873
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year 		Short-Term Notes Payable $9,997 Short-Term Notes Payable $10,122 Short-Term Notes Payable $10,249 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0
Income Taxes Due $136,181
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 $289,017 Income Taxes Due $459,528 Income Taxes Due $648,795 Income Taxes Due $1,635,946 Income Taxes Due $3,067,929 Income Taxes Due $5,083,347 Income Taxes Due $7,861,767
Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0
Total Current Liabilities $146,053 Total Current Liabilities $299,014 Total Current Liabilities $469,650 Total Current Liabilities $659,044 Total Current Liabilities $1,635,946 Total Current Liabilities $3,067,929 Total Current Liabilities $5,083,347 Total Current Liabilities $7,861,767
Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities
Long-Term Notes Payable $7,735 Long-Term Notes Payable $5,189 Long-Term Notes Payable $2,610 Long-Term Notes Payable -$0 Long-Term Notes Payable -$0 Long-Term Notes Payable -$0 Long-Term Notes Payable -$0 Long-Term Notes Payable -$0
Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0
Total Long-Term Liabilities $7,735 Total Long-Term Liabilities $5,189 Total Long-Term Liabilities $2,610 Total Long-Term Liabilities -$0 Total Long-Term Liabilities -$0 Total Long-Term Liabilities -$0 Total Long-Term Liabilities -$0 Total Long-Term Liabilities -$0
NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH
Paid-In Capital $50,240 Paid-In Capital $50,240 Paid-In Capital $50,240 Paid-In Capital $50,240 Paid-In Capital $50,240 Paid-In Capital $50,240 Paid-In Capital $50,240 Paid-In Capital $50,240
Retained Earnings $411,027 Retained Earnings $877,051 Retained Earnings $1,401,493 Retained Earnings $1,988,022 Retained Earnings $5,093,340 Retained Earnings $9,686,081 Retained Earnings $16,222,386 Retained Earnings $25,415,122
Total Net Worth $461,267 Total Net Worth $927,291 Total Net Worth $1,451,733 Total Net Worth $2,038,262 Total Net Worth $5,143,580 Total Net Worth $9,736,321 Total Net Worth $16,272,626 Total Net Worth $25,465,362
TOTAL LIABILITIES AND NET WORTH $615,056 TOTAL LIABILITIES AND NET WORTH $1,231,494 TOTAL LIABILITIES AND NET WORTH $1,923,994 TOTAL LIABILITIES AND NET WORTH $2,697,307 TOTAL LIABILITIES AND NET WORTH $6,779,526 TOTAL LIABILITIES AND NET WORTH $12,804,249 TOTAL LIABILITIES AND NET WORTH $21,355,973 TOTAL LIABILITIES AND NET WORTH $33,327,128

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 (2018-2019)
August $458,447
Author: This is the amount of sales you will need to make each month to break even.
September $458,439
October $458,430
November $458,422
December $458,414
January $458,405
February $458,396
March $458,388
April $458,379
May $458,371
June $458,362
July $458,353
Monthly Average $458,401
Year 2 (2019-2020)
August $474,637
September $474,628
October $474,619
November $474,610
December $474,601
January $474,592
February $474,583
March $474,574
April $474,565
May $474,556
June $474,547
July $474,538
Monthly Average $474,588
Year 3 (2020-2021)
1st Quarter $1,474,264
2nd Quarter $1,474,264
3rd Quarter $1,474,264
4th Quarter $1,474,264
Quarterly Average $1,474,264
Year 4 (2021-2022)
1st Quarter $1,526,810
2nd Quarter $1,526,810
3rd Quarter $1,526,810
4th Quarter $1,526,810
Quarterly Average $1,526,810
Year 5 (2022-2023)
Annual Average $6,334,211

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 (2018-2019) 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 $376,502 3.58 12.92 6.55 0.33 118% 22% 89% $2,465,152.20
2nd Quarter $839,980 3.81 13.22 3.11 0.33 66% 23% 50% $2,616,039.24
3rd Quarter $1,361,843 3.90 13.16 2.04 0.33 47% 25% 35% $2,776,161.77
4th Quarter $1,945,762 3.95 13.03 1.51 0.32 37% 26% 28% $2,946,085.07
Year 2 (2019-2020) $5,051,080 4.09 12.50 2.78 0.32 77% 28% 58% $14,043,906.25
Year 3 (2020-2021) $9,643,821 4.14 11.92 1.89 0.32 59% 31% 45% $18,256,345.58
Year 4 (2021-2022) $16,180,126 4.18 11.46 1.47 0.31 50% 34% 38% $23,732,296.99
Year 5 (2022-2023) $25,372,862 4.23 11.11 1.22 0.31 44% 36% 33% $30,850,748.20

Key Ratios

Chart1

Year 1: Financials at-a-Glance (2018-2019) Gross Sales August September October November December January February March April May June July 900000 918000 936360 955087.2 974188.9439999999 993672.72288000002 1013546.1773375999 1033817.1008843519 1054493.442902039 1075583.3117600798 1097094.9779952816 1119036.8775551871 Gross Profit August September October November December January February March April May June July 355500 362610 369862.19999999995 377259.4439999999 384804.63288000005 392500.7255376 400350.74004835193 408357.754849319 416524.90994630544 424855.40814523154 433352.51630813628 442019.56663429888 Net Profit August September October November December January February March April May June July 130809.99999999999 136144.98154519169 141586.62343015501 147137.05869797233 152798.46305190571 158573.05570859698 164463.10026833345 170470.90560271745 176598.82676008952 182849.26588906065 189224.67318051483 195727.54782845103

Chart2

Year 1: Net Sales (2018-2019) Product Line 1 August September October November December January February March April May June July 447500 456450 465579 474890.58 484388.39159999997 494076.15943199996 503957.68262063997 514036.83627305267 524317.57299851382 534803.92445848405 545500.00294765376 556410.00300660683 Product Line 2 August September October November December January February March April May June July 358000 365160 372463.2 379912.46400000004 387510.71327999997 395260.92754559999 403166.14609651198 411229.46901844227 419454.05839881115 427843.1395667874 436400.00235812314 445128.0024052856 Product Line 3 August September October November December January February March April May June July Product Line 4 August September October November December January February March April May June July Product Line 5 Product Line 6 Product Line 7 Product Line 8 Product Line 9 Product Line 10

Chart3

Year 1: Cash Flow (2018-2019) Net Cash Flow August September October November December January February March April May June July 367631.83823771193 631985.72310290998 648786.52837216249 665926.81732247258 683413.382517108 701253.15237300948 719453.19387786719 738020.71536153625 756963.06932288408 776287.75531317038 796002.42287709925 816114.8745526881 Ending Cash Balance 372631.83823771193 1004617.5613406218 1653404.0897127842 2319330.9070352567 3002744.2895523645 3703997.4419253739 4423450.6358032404 5161471.3511647768 5918434.4204876609 6694722.1758008311 7490724.5986779 295 8306839.473230619

Chart4

Year 2: Cash Flow (2019-2020) Net Cash Flow August September October November December January February March April May June July 848486.00635210064 876933.61896406522 898819.94376084721 921147.61809724616 943925.47198325687 967162.5120315915 990867.92498973361 1015051.0813426361 1039721.5389874744 1064889.0469818912 1090563.5493672085 1116755.1890681034 Ending Cash Balance August September October November December January February March April May June July 9155325.4795827195 10032259.098546784 10931079.04230763 11852226.660404876 12796152.132388132 13763314.644419724 14754182.569409458 15769233.650752094 16808955.189739566 17873844.236721456 18964407.786088664 20081162.975156769

Chart5

5-Year Financials at-a-Glance

Gross Sales 2018 2019 2020 2021 2022 12070880.75531454 15691515.357847368 20398151.486763112 26516532.953514367 34470109.722005479 Gross Profit 2018 2019 2020 2021 2022 4767997.8983492441 6198148.5663497103 8057269.8372714296 10474030.516638175 13615693.340192165 Net Profit 2018 2019 2020 2021 2022 1946384.5019629898 2961452.4462569617 4295949.8297035722 6046252.798727382 8335260.0995265115

Chart6

5-Year Net Sales

Product Line 1 2018 2019 2020 2021 2022 6001910.1533369515 7802170.1362629961 10142414.211473878 13184609.440775195 17139304.556219388 Product Line 2 2018 2019 2020 2021 2022 4801528.1226695618 6241736.1090103993 8113931.3691791072 10547687.552620163 13711443.644975515 Product Line 3 2018 2019 2020 2021 2022 Product Line 4 2018 2019 2020 2021 2022 Product Line 5 Product Line 6 Product Line 7 Product Line 8 Product Line 9 Product Line 10

About

About Business Plan Financials
PlanningShop
Business Plan Financials
Version 2.8
SUBJECT TO END-USER LICENSE AGREEMENT
Copyright 2003-2014 PlanningShop. All rights reserved.
www.planningshop.com
http://www.planningshop.com/

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.

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 Aug 1 Plan Years:
Sure Product Consulting: Plan Years is used in drop-downs for purchase and loan dates on CapInvest and CapEx worksheets.
2018
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.		 Sep 2 2018 0
Version: Startup Month Oct 3 2019 12
2.8 August Nov 4 2020 24
7/21/09 Startup Month Abbrev Dec 5 2021 36
Aug Jan 6 2022 48
Start Date: Feb 7 2023
O/S Type Jul-14 Mar 8
Windows Apr 9
May 10
Jun 11
Jul 12
CREDIT MULTIPLIER
Number of Products Multiple With "Credit Sales"
One A 0.00 0.00
Two B 1.00 0.25
Three
Four
Five
Six Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet

Sure Product Consulting: Plan Years is used in drop-downs for purchase and loan dates on CapInvest and CapEx worksheets.		 Seven Q1 $376,502
Eight Q2 $839,980
Nine Q3 $1,361,843
Ten Q4 $1,945,762
Y2 $5,051,080
Y3 $9,643,821
Y4 $16,180,126
Y5 $25,372,862
Chart Titles
Year 1 String 2018-2019 Year 1: Financials at-a-Glance (2018-2019)
Year 2 String 2019-2020 Year 1: Net Sales (2018-2019)
Year 3 String 2020-2021 Year 1: Cash Flow (2018-2019)
Year 4 String 2021-2022 Year 2: Cash Flow (2019-2020)
Year 5 String 2022-2023
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 August September October November December January February March April May June July
Match Position in Doublelist 8 9 10 11 12 13 14 15 16 17 18 19
Adjust index to 1-12 8 9 10 11 12 1 2 3 4 5 6 7
Abbrev Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
To-Do List
Changing this changes ALL months on CapEX and CapInvest to new value, even ieach row's purchase date istill remains in the future. This is the same behavior as in 2.5, but might want to correct it.
Changing the Year Titles on SaleProj and all other worksheets, for fiscal years that straddle two calendar years (example: Year 1: 2012-2013
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
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19
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 Aug 2018 1 12 Jun-15 $ - 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 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Facilities Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Equip treating water $500.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 42 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Equip compounding ingredients $750.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 63 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Equip carbonating product $250.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 21 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Equip filling product $500.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 42 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Equip packaging $500.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 42 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
21 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
22 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
23 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
24 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
25 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
26 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
27 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
28 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
29 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
30 Equip Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
31 Comp Major $10,000.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 833 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
32 Comp Minor $5,000.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 417 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
33 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
34 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
35 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
36 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
37 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
38 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
39 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
40 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
41 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
42 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
43 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
44 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
45 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
46 Comp media and network equipment $5,000.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ 417 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
47 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
48 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
49 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
50 Comp Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
51 Land Direct costs $10,000.00 $0.00 1 12 Aug 2018 1 12 Jun-15
52 Land Purchase cost $60,000.00 $0.00 1 12 Aug 2018 1 12 Jun-15
53 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
54 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
55 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
56 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
57 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
58 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
59 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
60 Land Item Name (change name here) $0.00 $0.00 1 12 Aug 2018 1 12 Jun-15
TOTAL $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Land 70,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Facilities - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Equip 2,500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Comp 20,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL
Author: This goes into Cash Flow statement.
Author: This goes into Cash Flow statement.		 92,500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL NON-DEPRECIABLE CAPITAL ASSETS
Author: This goes into Income statement under "non-depreciable capital purchases"
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"		 92,500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Depreciation Schedule

LoanInvestSchedules

Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19
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 Melinda Cates $840 Aug 2018 1 840.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 - 0 - 0 - 0 - 0 - 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 Glass Bottles $3,000 Aug 2018 1 3,000.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 - 0 - 0 - 0 - 0 - 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 Labels $300 Aug 2018 1 300.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 - 0 - 0 - 0 - 0 - 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 Cardboard Cartons $500 Aug 2018 1 500.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 - 0 - 0 - 0 - 0 - 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 NAB Ingredients $600 Aug 2018 1 600.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 - 0 - 0 - 0 - 0 - 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 Metal Caps $40,000 Aug 2018 1 40,000.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 - 0 - 0 - 0 - 0 - 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 Investment Source Name $0 Aug 2018 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
8 Investment Source Name $0 Aug 2018 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
9 Investment Source Name $0 Aug 2018 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
10 Investment Source Name $0 Aug 2018 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
11 Investment Source Name $0 Aug 2018 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
12 Investment Source Name $0 Aug 2018 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
13 Investment Source Name $0 Aug 2018 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
14 Investment Source Name $0 Aug 2018 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
15 Investment Source Name $0 Aug 2018 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
TOTAL: $45,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest)
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19
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.		 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20
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 Friends and Family $20,000 5.00% 24 Aug 2018 1 24 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 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 Aug 2018 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
3 Loan Source Name $0 0.00% 12 Aug 2018 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
4 Loan Source Name $0 0.00% 12 Aug 2018 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
5 Loan Source Name $0 0.00% 12 Aug 2018 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
6 Loan Source Name $0 0.00% 12 Aug 2018 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
7 Loan Source Name $0 0.00% 12 Aug 2018 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
8 Loan Source Name $0 0.00% 12 Aug 2018 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
9 Loan Source Name $0 0.00% 12 Aug 2018 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
10 Loan Source Name $0 0.00% 12 Aug 2018 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
11 Loan Source Name $0 0.00% 12 Aug 2018 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
12 Loan Source Name $0 0.00% 12 Aug 2018 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
13 Loan Source Name $0 0.00% 12 Aug 2018 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
14 Loan Source Name $0 0.00% 12 Aug 2018 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
15 Loan Source Name $0 0.00% 12 Aug 2018 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
16 Loan Source Name $0 0.00% 12 Aug 2018 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
17 Loan Source Name $0 0.00% 12 Aug 2018 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
18 Loan Source Name $0 0.00% 12 Aug 2018 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
19 Loan Source Name $0 0.00% 12 Aug 2018 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
20 Loan Source Name $0 0.00% 12 Aug 2018 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
TOTAL: $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 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
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 Friends and Family $20,000.00 $0.05 $24.00 Aug $2,018.00 $1.00 $24.00 877.43 83.33 80.02 76.70 73.37 70.02 66.65 63.27 59.88 56.47 53.05 49.62 46.17 42.71 39.23 35.74 32.23 28.71 25.17 21.62 18.05 14.47 10.88 7.27 3.64 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Loan Source Name $0 0.00% 12 Aug 2018 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL: $83 $80 $77 $73 $70 $67 $63 $60 $56 $53 $50 $46 $43 $39 $36 $32 $29 $25 $22 $18 $14 $11 $7 $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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds
Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19
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 Friends and Family $20,000 Aug 2018 1 20,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Loan Source Name $0 Aug 2018 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL: $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 Loan Calculations for Balance Sheet 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 Friends and Family $20,000.00 5.00% 24 Aug 2018 1 $20,000 $2,392 $9,873
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 		$7,735
Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out. 		$4,814
Sure Product Consulting: cummulative principle paid: includes previous quarter's payments		 $9,997 $5,189 $7,267 $10,122 $2,610 $9,751 $10,249 -$0 $20,000 $0 -$0 $20,000 $0 -$0 $20,000 $0 -$0 $20,000 $0 -$0
2 Loan Source Name $0.00 0.00% 12 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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 Aug 2018 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: $9,873 $7,735 $9,997 $5,189 $10,122 $2,610 $10,249 -$0 $0 -$0 $0 -$0 $0 -$0 $0 -$0

Loan & Investment Schedules for Disbursement & Repayment