Assignment 3 Part 1: Operation, Technology, and Management Plan (70 points)

profileKristin Velix
CopyofPlanningShop_BizPlanFin3.1STRAYERBUS599.xlsm
Home>Business & Finance homework help>Management homework help>Assignment 3 Part 1: Operation, Technology, and Management Plan (70 points)

Warning

W A R N I N G !
IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED.
Excel 2010 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 and Excel 2013 on Windows - Enabling Macros"
Excel 2013& 2016 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 & Excel 2013 on Windows - Enabling Macros"
Excel 2011 & 2016 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use.
Excel 2013 and Excel 2016 on Windows - Enabling Macros
Note: The procedure is exactly the same for Excel 2013 & 2016, even though the two versions look slightly different. 1. In the upper left corner of the Excel Ribbon, press the "File" tab.
2. Select Options, in the lower left corner.
3. Select Trust Center from the Lower Left. 4. Click the "Trust Center Settings…" button in the lower right
5. Select "Macros Settings" from the left side menu 6. Select the "Disable all macros except digitally signed macros" radio button. 7. Click "OK" twice

Your Company Name

Welcome

Welcome to Business Plan Financials!
Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. First, a few tips to get you started: SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIG_PlanningShop_BizPlanFin(2.8)" file in your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy. NAVIGATING THE WORKSHEETS You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a "PlanningShop" tab, that contains controls to let you navigate between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2013 and Excel 2016, but the functionality is the same.
Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel.
Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac:
In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
HOW TO FILL IN THE WORKSHEETS Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically calculated for you.
While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
FOR MORE HELP For more in-depth help and assistance,please refer to the companion PDF entitled "Business Plan Financials Help". It contains extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the PlanningShop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365
2. Microsoft Windows 8 or later with Microsoft Excel 2013
Mac
4 Mac OS X with Microsoft Excel 2016
5. Mac OS X with Microsoft Excel for Mac 2011
Version 3.1 Copyright © 2003-2017 PlanningShop

Setup

Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Your Company Name
What month will you officially start your company? October ERROR: Some capital purchases are before your start date. Please Fix (CapEx worksheet).
What year will you officially start your company? 2019
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? Four
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? 55%
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 Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)? $18,770
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? 3.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? 18.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. $16,500
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? 20.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.50%
Author: If you're not sure what percentage to enter here, leave it at the default (1.00%).

Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.
Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.
Author: If you're not sure what percentage to enter here, leave it at the default (15%).
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.		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
Assumptions October November December January February March April May June July August September TOTAL October November December January February March April May June July August September TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
In House Lemon Lime
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 5.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.		 10000
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.		 10500
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.		 11025 11576 12155 12763 13401 14071 14775 15513 16289 17103 159171 17959 18856 19799 20789 21829 22920 24066 25270 26533 27860 29253 30715 285849 101671
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 117697 136249 157726 513343 182587 211367 244684 283252 921891 1655583
Unit Price 7.00%
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.		 $4.99
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.		 $4.99
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.		 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.71 $5.71 $5.71 $5.71 $6.11 $6.11 $6.11 $6.11 $6.54
Gross Sales $49,900 $52,395 $55,015 $57,765 $60,654 $63,686 $66,871 $70,214 $73,725 $77,411 $81,282 $85,345.93 $794,265 $95,886 $100,680 $105,714 $111,000 $116,550 $122,378 $128,497 $134,921 $141,668 $148,751 $156,188 $163,998 $1,526,232 $580,853 $672,410 $778,399 $901,094 $2,932,756 $1,116,148 $1,292,081 $1,495,745 $1,731,512 $5,635,485 $10,828,958
(Commissions) 25.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?		 $1,871 $1,965 $2,063 $2,166 $2,275 $2,388 $2,508 $2,633 $2,765 $2,903 $3,048 $3,200 $29,785 $3,596 $3,776 $3,964 $4,163 $4,371 $4,589 $4,819 $5,060 $5,313 $5,578 $5,857 $6,150 $57,234 $21,782 $25,215 $29,190 $33,791 $109,978 $41,856 $48,453 $56,090 $64,932 $211,331 $406,086
(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.		 $1,497.00 $1,572 $1,650.44 $1,732.96 $1,819.61 $1,910.59 $2,006.12 $2,106.43 $2,211.75 $2,322.34 $2,438.46 $2,560.38 $23,828 $2,876.58 $3,020.41 $3,171.43 $3,330.01 $3,496.51 $3,671.33 $3,854.90 $4,047.64 $4,250.03 $4,462.53 $4,685.65 $4,919.94 $45,787 $17,425.60 $20,172.30 $23,351.96 $27,032.82 $87,983 $33,484.44 $38,762.42 $44,872.35 $51,945.35 $169,065 $324,868.75
Net Sales $46,532 $48,858 $51,301 $53,866 $56,560 $59,388 $62,357 $65,475 $68,749 $72,186 $75,795 $79,585 $740,652 $89,414 $93,885 $98,579 $103,508 $108,683 $114,117 $119,823 $125,814 $132,105 $138,710 $145,646 $152,928 $1,423,211 $541,646 $627,022 $725,857 $840,270 $2,734,795 $1,040,808 $1,204,865 $1,394,782 $1,614,635 $5,255,090 $10,098,004
(Cost of Goods Sold) 30.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.		 $14,970.00 $15,719 $16,504 $17,330 $18,196 $19,106 $20,061 $21,064 $22,118 $23,223 $24,385 $25,604 $238,279 $28,766 $30,204 $31,714 $33,300 $34,965 $36,713 $38,549 $40,476 $42,500 $44,625 $46,857 $49,199 $457,870 $174,256 $201,723 $233,520 $270,328 $879,827 $334,844 $387,624 $448,723 $519,454 $1,690,646 $3,248,687
GROSS PROFIT $31,562 $33,140 $34,797 $36,537 $38,364 $40,282 $42,296 $44,411 $46,631 $48,963 $51,411 $53,981 $502,372 $60,648 $63,680 $66,864 $70,208 $73,718 $77,404 $81,274 $85,338 $89,605 $94,085 $98,789 $103,729 $965,342 $367,390 $425,299 $492,337 $569,942 $1,854,968 $705,964 $817,241 $946,059 $1,095,181 $3,564,444 $6,849,316
In House Orange Juice
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume 5.00% 10000 10500 11025 11576 12155 12763 13401 14071 14775 15513 16289 17103 159171 17959 18856 19799 20789 21829 22920 24066 25270 26533 27860 29253 30715 285849 101671
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 117697 136249 157726 513343 182587 211367 244684 283252 921891 1655583
Unit Price 7.00%
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.		 $4.99
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.		 $4.99
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.		 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $4.99 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.34 $5.71 $5.71 $5.71 $5.71 $6.11 $6.11 $6.11 $6.11 $6.54
Gross Sales $49,900 $52,395 $55,015 $57,765 $60,654 $63,686 $66,871 $70,214 $73,725 $77,411 $81,282 $85,346 $794,265 $95,886 $100,680 $105,714 $111,000 $116,550 $122,378 $128,497 $134,921 $141,668 $148,751 $156,188 $163,998 $1,526,232 $580,853 $672,410 $778,399 $901,094 $2,932,756 $1,116,148 $1,292,081 $1,495,745 $1,731,512 $5,635,485 $10,828,958
(Commissions) 25.00% 15.00% $1,871 $1,965 $2,063 $2,166 $2,275 $2,388 $2,508 $2,633 $2,765 $2,903 $3,048 $3,200 $29,785 $3,596 $3,776 $3,964 $4,163 $4,371 $4,589 $4,819 $5,060 $5,313 $5,578 $5,857 $6,150 $57,234 $21,782 $25,215 $29,190 $33,791 $109,978 $41,856 $48,453 $56,090 $64,932 $211,331 $406,086
(Returns and Allowances) 3.00% $1,497 $1,572 $1,650 $1,733 $1,820 $1,911 $2,006 $2,106 $2,212 $2,322 $2,438 $2,560 $23,828 $2,877 $3,020 $3,171 $3,330 $3,497 $3,671 $3,855 $4,048 $4,250 $4,463 $4,686 $4,920 $45,787 $17,426 $20,172 $23,352 $27,033 $87,983 $33,484 $38,762 $44,872 $51,945 $169,065 $324,869
Net Sales $46,532 $48,858 $51,301 $53,866 $56,560 $59,388 $62,357 $65,475 $68,749 $72,186 $75,795 $79,585 $740,652 $89,414 $93,885 $98,579 $103,508 $108,683 $114,117 $119,823 $125,814 $132,105 $138,710 $145,646 $152,928 $1,423,211 $541,646 $627,022 $725,857 $840,270 $2,734,795 $1,040,808 $1,204,865 $1,394,782 $1,614,635 $5,255,090 $10,098,004
(Cost of Goods Sold) 30.00% $14,970 $15,719 $16,504 $17,330 $18,196 $19,106 $20,061 $21,064 $22,118 $23,223 $24,385 $25,604 $238,279 $28,766 $30,204 $31,714 $33,300 $34,965 $36,713 $38,549 $40,476 $42,500 $44,625 $46,857 $49,199 $457,870 $174,256 $201,723 $233,520 $270,328 $879,827 $334,844 $387,624 $448,723 $519,454 $1,690,646 $3,248,687
GROSS PROFIT $31,562 $33,140 $34,797 $36,537 $38,364 $40,282 $42,296 $44,411 $46,631 $48,963 $51,411 $53,981 $502,372 $60,648 $63,680 $66,864 $70,208 $73,718 $77,404 $81,274 $85,338 $89,605 $94,085 $98,789 $103,729 $965,342 $367,390 $425,299 $492,337 $569,942 $1,854,968 $705,964 $817,241 $946,059 $1,095,181 $3,564,444 $6,849,316
Store Lemon Lime
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume 5.00% 25000 26250 27563 28941 30388 31907 33502 35178 36936 38783 40722 42758 397928 44896 47141 49498 51973 54572 57300 60165 63174 66332 69649 73132 76788 714622 254178
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 294243 340623 394314 1283358 456468 528418 611710 708131 2304727 4138958
Unit Price 7.00%
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.		 $3.99
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.		 $3.99
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.		 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.57 $4.57 $4.57 $4.57 $4.89 $4.89 $4.89 $4.89 $5.23
Gross Sales $99,750 $104,738 $109,974 $115,473 $121,247 $127,309 $133,675 $140,358 $147,376 $154,745 $162,482 $170,606 $1,587,733 $191,676 $201,260 $211,323 $221,889 $232,984 $244,633 $256,864 $269,708 $283,193 $297,353 $312,220 $327,831 $3,050,935 $1,161,124 $1,344,147 $1,556,018 $1,801,285 $5,862,574 $2,231,177 $2,582,867 $2,989,991 $3,461,288 $11,265,324 $21,647,066
(Commissions) 25.00% 15.00% $3,741 $3,928 $4,124 $4,330 $4,547 $4,774 $5,013 $5,263 $5,527 $5,803 $6,093 $6,398 $59,540 $7,188 $7,547 $7,925 $8,321 $8,737 $9,174 $9,632 $10,114 $10,620 $11,151 $11,708 $12,294 $114,410 $43,542 $50,405 $58,351 $67,548 $219,847 $83,669 $96,858 $112,125 $129,798 $422,450 $811,765
(Returns and Allowances) 3.00% $2,993 $3,142 $3,299 $3,464 $3,637 $3,819 $4,010 $4,211 $4,421 $4,642 $4,874 $5,118 $47,632 $5,750 $6,038 $6,340 $6,657 $6,990 $7,339 $7,706 $8,091 $8,496 $8,921 $9,367 $9,835 $91,528 $34,834 $40,324 $46,681 $54,039 $175,877 $66,935 $77,486 $89,700 $103,839 $337,960 $649,412
Net Sales $93,017 $97,668 $102,551 $107,679 $113,063 $118,716 $124,652 $130,884 $137,428 $144,300 $151,515 $159,090 $1,480,561 $178,738 $187,675 $197,059 $206,912 $217,257 $228,120 $239,526 $251,502 $264,078 $277,281 $291,146 $305,703 $2,844,997 $1,082,748 $1,253,417 $1,450,986 $1,679,698 $5,466,850 $2,080,573 $2,408,523 $2,788,167 $3,227,651 $10,504,914 $20,185,889
(Cost of Goods Sold) 30.00% $29,925 $31,421 $32,992 $34,642 $36,374 $38,193 $40,102 $42,107 $44,213 $46,423 $48,745 $51,182 $476,320 $57,503 $60,378 $63,397 $66,567 $69,895 $73,390 $77,059 $80,912 $84,958 $89,206 $93,666 $98,349 $915,280 $348,337 $403,244 $466,805 $540,385 $1,758,772 $669,353 $774,860 $896,997 $1,038,387 $3,379,597 $6,494,120
GROSS PROFIT $63,092 $66,246 $69,559 $73,037 $76,689 $80,523 $84,549 $88,777 $93,215 $97,876 $102,770 $107,909 $1,004,241 $121,235 $127,297 $133,662 $140,345 $147,362 $154,730 $162,467 $170,590 $179,120 $188,076 $197,479 $207,353 $1,929,716 $734,411 $850,173 $984,181 $1,139,313 $3,708,078 $1,411,220 $1,633,663 $1,891,169 $2,189,265 $7,125,317 $13,691,769
Store Orange
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 5.00% 15000 15750 16538 17364 18233 19144 20101 21107 22162 23270 24433 25655 238757 26938 28285 29699 31184 32743 34380 36099 37904 39799 41789 43879 46073 428773 152507
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 176546 204374 236588 770015 273881 317051 367026 424879 1382836 2483375
Unit Price 7.00%
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.		 $3.99
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.		 $3.99
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.		 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $3.99 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.27 $4.57 $4.57 $4.57 $4.57 $4.89 $4.89 $4.89 $4.89 $5.23
Gross Sales $59,850 $62,843 $65,985 $69,284 $72,748 $76,385 $80,205 $84,215 $88,426 $92,847 $97,489 $102,364 $952,640 $115,006 $120,756 $126,794 $133,134 $139,790 $146,780 $154,119 $161,825 $169,916 $178,412 $187,332 $196,699 $1,830,561 $696,675 $806,488 $933,611 $1,080,771 $3,517,544 $1,338,706 $1,549,720 $1,793,995 $2,076,773 $6,759,194 $12,988,240
(Commissions) 25.00% 15.00% $2,244 $2,357 $2,474 $2,598 $2,728 $2,864 $3,008 $3,158 $3,316 $3,482 $3,656 $3,839 $35,724 $4,313 $4,528 $4,755 $4,993 $5,242 $5,504 $5,779 $6,068 $6,372 $6,690 $7,025 $7,376 $68,646 $26,125 $30,243 $35,010 $40,529 $131,908 $50,201 $58,115 $67,275 $77,879 $253,470 $487,059
(Returns and Allowances) 3.00% $1,796 $1,885 $1,980 $2,079 $2,182 $2,292 $2,406 $2,526 $2,653 $2,785 $2,925 $3,071 $28,579 $3,450 $3,623 $3,804 $3,994 $4,194 $4,403 $4,624 $4,855 $5,097 $5,352 $5,620 $5,901 $54,917 $20,900 $24,195 $28,008 $32,423 $105,526 $40,161 $46,492 $53,820 $62,303 $202,776 $389,647
Net Sales $55,810 $58,601 $61,531 $64,607 $67,838 $71,229 $74,791 $78,530 $82,457 $86,580 $90,909 $95,454 $888,337 $107,243 $112,605 $118,235 $124,147 $130,354 $136,872 $143,716 $150,901 $158,447 $166,369 $174,687 $183,422 $1,706,998 $649,649 $752,050 $870,592 $1,007,819 $3,280,110 $1,248,344 $1,445,114 $1,672,900 $1,936,591 $6,302,949 $12,111,533
(Cost of Goods Sold) 30.00% $17,955 $18,853 $19,795 $20,785 $21,824 $22,916 $24,061 $25,264 $26,528 $27,854 $29,247 $30,709 $285,792 $34,502 $36,227 $38,038 $39,940 $41,937 $44,034 $46,236 $48,547 $50,975 $53,523 $56,200 $59,010 $549,168 $209,002 $241,946 $280,083 $324,231 $1,055,263 $401,612 $464,916 $538,198 $623,032 $2,027,758 $3,896,472
GROSS PROFIT $37,855 $39,748 $41,735 $43,822 $46,013 $48,314 $50,729 $53,266 $55,929 $58,726 $61,662 $64,745 $602,545 $72,741 $76,378 $80,197 $84,207 $88,417 $92,838 $97,480 $102,354 $107,472 $112,845 $118,488 $124,412 $1,157,830 $440,647 $510,104 $590,509 $683,588 $2,224,847 $846,732 $980,198 $1,134,702 $1,313,559 $4,275,190 $8,215,062
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.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.
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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 60000 63000 66150 69458 72930 76577 80406 84426 88647 93080 97734 102620 955028 107751 113139 118796 124736 130972 137521 144397 151617 159198 167158 175516 184291 1715092 610028 706183 817495 946353 3080059 1095522 1268204 1468104 1699514 5531344 9933499
Total Gross Sales $259,400 $272,370 $285,989 $300,288 $315,302 $331,067 $347,621 $365,002 $383,252 $402,415 $422,535 $443,662 $4,128,903 $498,454 $523,377 $549,546 $577,023 $605,874 $636,168 $667,976 $701,375 $736,444 $773,266 $811,930 $852,526 $7,933,960 $3,019,505 $3,495,455 $4,046,426 $4,684,244 $15,245,630 $5,802,180 $6,716,748 $7,775,476 $9,001,085 $29,295,488 $56,293,222
(Total Commissions) $9,728 $10,214 $10,725 $11,261 $11,824 $12,415 $13,036 $13,688 $14,372 $15,091 $15,845 $16,637 $154,834 $18,692 $19,627 $20,608 $21,638 $22,720 $23,856 $25,049 $26,302 $27,617 $28,997 $30,447 $31,970 $297,524 $113,231 $131,080 $151,741 $175,659 $571,711 $217,582 $251,878 $291,580 $337,541 $1,098,581 $2,110,996
(Total Returns and Allowances) $7,782 $8,171 $8,580 $9,009 $9,459 $9,932 $10,429 $10,950 $11,498 $12,072 $12,676 $13,310 $123,867 $14,954 $15,701 $16,486 $17,311 $18,176 $19,085 $20,039 $21,041 $22,093 $23,198 $24,358 $25,576 $238,019 $90,585 $104,864 $121,393 $140,527 $457,369 $174,065 $201,502 $233,264 $270,033 $878,865 $1,688,797
Total Net Sales $241,891 $253,985 $266,684 $280,018 $294,019 $308,720 $324,156 $340,364 $357,382 $375,252 $394,014 $413,715 $3,850,202 $464,809 $488,049 $512,452 $538,074 $564,978 $593,227 $622,888 $654,032 $686,734 $721,071 $757,124 $794,980 $7,398,418 $2,815,689 $3,259,512 $3,773,292 $4,368,057 $14,216,550 $5,410,532 $6,263,368 $7,250,631 $8,393,512 $27,318,043 $52,493,429
(Total Cost of Goods Sold) $77,820 $81,711 $85,797 $90,086 $94,591 $99,320 $104,286 $109,501 $114,976 $120,724 $126,761 $133,099 $1,238,671 $149,536 $157,013 $164,864 $173,107 $181,762 $190,850 $200,393 $210,413 $220,933 $231,980 $243,579 $255,758 $2,380,188 $905,852 $1,048,636 $1,213,928 $1,405,273 $4,573,689 $1,740,654 $2,015,024 $2,332,643 $2,700,325 $8,788,646 $16,887,967
TOTAL GROSS PROFIT $164,071 $172,274 $180,888 $189,932 $199,429 $209,400 $219,870 $230,864 $242,407 $254,527 $267,254 $280,616 $2,611,531 $315,272 $331,036 $347,588 $364,967 $383,215 $402,376 $422,495 $443,620 $465,801 $489,091 $513,545 $539,223 $5,018,230 $1,909,837 $2,210,875 $2,559,364 $2,962,784 $9,642,861 $3,669,879 $4,248,343 $4,917,988 $5,693,186 $18,529,396 $35,605,463

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.		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
October November December January February March April May June July August September TOTAL October November December January February March April May June July August September TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
In House Lemon Lime
Cost of Goods Sold $14,970
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.		 $15,719 $16,504 $17,330 $18,196 $19,106 $20,061 $21,064 $22,118 $23,223 $24,385 $25,604 $238,279 $28,766 $30,204 $31,714 $33,300 $34,965 $36,713 $38,549 $40,476 $42,500 $44,625 $46,857 $49,199 $457,870 $174,256 $201,723 $233,520 $270,328 $879,827 $334,844 $387,624 $448,723 $519,454 $1,690,646 $3,248,687
Ingredients $30,689
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.		 $16,504 $17,330 $18,196 $19,106 $20,061 $21,064 $22,118 $23,223 $24,385 $25,604 $28,766 $267,045 $30,204 $31,714 $33,300 $34,965 $36,713 $38,549 $40,476 $42,500 $44,625 $46,857 $49,199 $51,659 $480,763 $182,969 $211,809 $245,196 $283,845 $923,818 $351,587 $407,005 $471,160 $545,426 $1,775,178 $3,411,122
Bottles/Caps $45,659 $47,941 $50,338 $52,855 $55,498 $58,273 $61,187 $64,246 $67,458 $70,831 $74,373 $78,092 $726,752 $87,736 $92,123 $96,729 $101,565 $106,643 $111,976 $117,574 $123,453 $129,626 $136,107 $142,912 $150,058 $1,396,502 $531,481 $615,255 $712,235 $824,501 $2,683,472 $1,021,275 $1,182,254 $1,368,607 $1,584,333 $5,156,469 $9,908,497
Labels $91,317 $95,883 $100,677 $105,711 $110,996 $116,546 $122,374 $128,492 $134,917 $141,663 $148,746 $156,183 $1,453,504 $175,472 $184,245 $193,458 $203,130 $213,287 $223,951 $235,149 $246,906 $259,252 $272,214 $285,825 $300,116 $2,793,005 $1,062,961 $1,230,511 $1,424,470 $1,649,002 $5,366,944 $2,042,551 $2,364,508 $2,737,213 $3,168,666 $10,312,938 $19,816,994
Cartons $182,634 $191,766 $201,354 $211,422 $221,993 $233,092 $244,747 $256,984 $269,834 $283,325 $297,492 $312,366 $2,907,008 $350,943 $368,491 $386,915 $406,261 $426,574 $447,903 $470,298 $493,813 $518,503 $544,428 $571,650 $600,232 $5,586,009 $2,125,923 $2,461,021 $2,848,940 $3,298,004 $10,733,887 $4,085,101 $4,729,015 $5,474,426 $6,337,333 $20,625,876 $39,633,987
Total Inventory Expense $350,298
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.) 		$352,094 $369,699 $388,184 $407,593 $427,973 $449,372 $471,840 $495,432 $520,204 $546,214 $575,407 $5,354,310 $644,355 $676,573 $710,401 $745,921 $783,217 $822,378 $863,497 $906,672 $952,006 $999,606 $1,049,586 $1,102,066 $10,256,280 $3,903,333 $4,518,596 $5,230,840 $6,055,351 $19,708,121 $7,500,514 $8,682,782 $10,051,406 $11,635,759 $37,870,461 $72,770,600
In House Orange Juice
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 $14,970 $15,719 $16,504 $17,330 $18,196 $19,106 $20,061 $21,064 $22,118 $23,223 $24,385 $25,604 $238,279 $28,766 $30,204 $31,714 $33,300 $34,965 $36,713 $38,549 $40,476 $42,500 $44,625 $46,857 $49,199 $457,870 $174,256 $201,723 $233,520 $270,328 $879,827 $334,844 $387,624 $448,723 $519,454 $1,690,646 $3,248,687
Ingredients $30,689
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.		 $16,504 $17,330 $18,196 $19,106 $20,061 $21,064 $22,118 $23,223 $24,385 $25,604 $28,766 $267,045 $30,204 $31,714 $33,300 $34,965 $36,713 $38,549 $40,476 $42,500 $44,625 $46,857 $49,199 $51,659 $480,763 $182,969 $211,809 $245,196 $283,845 $923,818 $351,587 $407,005 $471,160 $545,426 $1,775,178 $3,411,122
Bottles/Caps $45,659 $47,941 $50,338 $52,855 $55,498 $58,273 $61,187 $64,246 $67,458 $70,831 $74,373 $78,092 $726,752 $87,736 $92,123 $96,729 $101,565 $106,643 $111,976 $117,574 $123,453 $129,626 $136,107 $142,912 $150,058 $1,396,502 $531,481 $615,255 $712,235 $824,501 $2,683,472 $1,021,275 $1,182,254 $1,368,607 $1,584,333 $5,156,469 $9,908,497
Labels $91,317 $95,883 $100,677 $105,711 $110,996 $116,546 $122,374 $128,492 $134,917 $141,663 $148,746 $156,183 $1,453,504 $175,472 $184,245 $193,458 $203,130 $213,287 $223,951 $235,149 $246,906 $259,252 $272,214 $285,825 $300,116 $2,793,005 $1,062,961 $1,230,511 $1,424,470 $1,649,002 $5,366,944 $2,042,551 $2,364,508 $2,737,213 $3,168,666 $10,312,938 $19,816,994
Cartons $182,634 $191,766 $201,354 $211,422 $221,993 $233,092 $244,747 $256,984 $269,834 $283,325 $297,492 $312,366 $2,907,008 $350,943 $368,491 $386,915 $406,261 $426,574 $447,903 $470,298 $493,813 $518,503 $544,428 $571,650 $600,232 $5,586,009 $2,125,923 $2,461,021 $2,848,940 $3,298,004 $10,733,887 $4,085,101 $4,729,015 $5,474,426 $6,337,333 $20,625,876 $39,633,987
Total Inventory Expense $350,298 $352,094 $369,699 $388,184 $407,593 $427,973 $449,372 $471,840 $495,432 $520,204 $546,214 $575,407 $5,354,310 $644,355 $676,573 $710,401 $745,921 $783,217 $822,378 $863,497 $906,672 $952,006 $999,606 $1,049,586 $1,102,066 $10,256,280 $3,903,333 $4,518,596 $5,230,840 $6,055,351 $19,708,121 $7,500,514 $8,682,782 $10,051,406 $11,635,759 $37,870,461 $72,770,600
Store Lemon Lime
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 $29,925 $31,421 $32,992 $34,642 $36,374 $38,193 $40,102 $42,107 $44,213 $46,423 $48,745 $51,182 $476,320 $57,503 $60,378 $63,397 $66,567 $69,895 $73,390 $77,059 $80,912 $84,958 $89,206 $93,666 $98,349 $915,280 $348,337 $403,244 $466,805 $540,385 $1,758,772 $669,353 $774,860 $896,997 $1,038,387 $3,379,597 $6,494,120
Ingredients $61,346
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.		 $32,992 $34,642 $36,374 $38,193 $40,102 $42,107 $44,213 $46,423 $48,745 $51,182 $57,503 $533,823 $60,378 $63,397 $66,567 $69,895 $73,390 $77,059 $80,912 $84,958 $89,206 $93,666 $98,349 $103,267 $961,044 $365,754 $423,406 $490,146 $567,405 $1,846,711 $702,821 $813,603 $941,847 $1,090,306 $3,548,577 $6,818,826
Bottles/Caps $91,271 $95,835 $100,627 $105,658 $110,941 $116,488 $122,312 $128,428 $134,849 $141,592 $148,671 $156,105 $1,452,776 $175,384 $184,153 $193,361 $203,029 $213,180 $223,839 $235,031 $246,783 $259,122 $272,078 $285,682 $299,966 $2,791,605 $1,062,429 $1,229,894 $1,423,756 $1,648,176 $5,364,255 $2,041,527 $2,363,323 $2,735,842 $3,167,079 $10,307,771 $19,807,065
Labels $182,543 $191,670 $201,253 $211,316 $221,882 $232,976 $244,624 $256,856 $269,698 $283,183 $297,342 $312,210 $2,905,552 $350,768 $368,306 $386,721 $406,057 $426,360 $447,678 $470,062 $493,565 $518,243 $544,156 $571,363 $599,931 $5,583,211 $2,124,858 $2,459,788 $2,847,512 $3,296,351 $10,728,510 $4,083,055 $4,726,646 $5,471,684 $6,334,158 $20,615,542 $39,614,131
Cartons $365,085 $383,339 $402,506 $422,632 $443,763 $465,951 $489,249 $513,711 $539,397 $566,367 $594,685 $624,419 $5,811,104 $701,535 $736,612 $773,442 $812,114 $852,720 $895,356 $940,124 $987,130 $1,036,487 $1,088,311 $1,142,727 $1,199,863 $11,166,422 $4,249,715 $4,919,576 $5,695,025 $6,592,703 $21,457,019 $8,166,109 $9,453,292 $10,943,367 $12,668,316 $41,231,084 $79,228,261
Total Inventory Expense $700,245 $703,836 $739,028 $775,979 $814,778 $855,517 $898,293 $943,208 $990,368 $1,039,886 $1,091,881 $1,150,237 $10,703,255 $1,288,064 $1,352,468 $1,420,091 $1,491,095 $1,565,650 $1,643,933 $1,726,129 $1,812,436 $1,903,058 $1,998,210 $2,098,121 $2,203,027 $20,502,282 $7,802,756 $9,032,665 $10,456,439 $12,104,635 $39,396,494 $14,993,512 $17,356,864 $20,092,740 $23,259,858 $75,702,975 $145,468,283
Store Orange
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 $17,955 $18,853 $19,795 $20,785 $21,824 $22,916 $24,061 $25,264 $26,528 $27,854 $29,247 $30,709 $285,792 $34,502 $36,227 $38,038 $39,940 $41,937 $44,034 $46,236 $48,547 $50,975 $53,523 $56,200 $59,010 $549,168 $209,002 $241,946 $280,083 $324,231 $1,055,263 $401,612 $464,916 $538,198 $623,032 $2,027,758 $3,896,472
Ingredients $36,808
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.		 $38,648 $40,581 $42,610 $44,740 $46,977 $49,326 $51,792 $54,382 $57,101 $59,956 $62,954 $585,874 $70,729 $74,265 $77,978 $81,877 $85,971 $90,270 $94,783 $99,522 $104,498 $109,723 $115,209 $120,970 $1,125,795 $428,455 $495,990 $574,171 $664,674 $2,163,290 $823,304 $953,078 $1,103,307 $1,277,215 $4,156,904 $7,987,767
Bottles/Caps $54,763 $57,501 $60,376 $63,395 $66,564 $69,893 $73,387 $77,057 $80,910 $84,955 $89,203 $93,663 $871,666 $105,230 $110,492 $116,016 $121,817 $127,908 $134,303 $141,019 $148,070 $155,473 $163,247 $171,409 $179,979 $1,674,963 $637,457 $737,936 $854,254 $988,905 $3,218,553 $1,224,916 $1,417,994 $1,641,505 $1,900,247 $6,184,663 $11,884,239
Labels $109,526 $115,002 $120,752 $126,789 $133,129 $139,785 $146,775 $154,113 $161,819 $169,910 $178,405 $187,326 $1,743,331 $210,461 $220,984 $232,033 $243,634 $255,816 $268,607 $282,037 $296,139 $310,946 $326,493 $342,818 $359,959 $3,349,927 $1,274,915 $1,475,873 $1,708,507 $1,977,811 $6,437,106 $2,449,833 $2,835,988 $3,283,010 $3,800,495 $12,369,325 $23,768,478
Cartons $219,051 $230,004 $241,504 $253,579 $266,258 $279,571 $293,549 $308,227 $323,638 $339,820 $356,811 $374,652 $3,486,662 $420,921 $441,967 $464,065 $487,269 $511,632 $537,214 $564,074 $592,278 $621,892 $652,987 $685,636 $719,918 $6,699,853 $2,549,829 $2,951,746 $3,417,015 $3,955,622 $12,874,212 $4,899,666 $5,671,975 $6,566,020 $7,600,989 $24,738,651 $47,536,957
Total Inventory Expense $420,147 $441,154 $463,212 $486,373 $510,691 $536,226 $563,037 $591,189 $620,748 $651,786 $684,375 $718,594 $6,687,533 $807,340 $847,707 $890,093 $934,597 $981,327 $1,030,394 $1,081,913 $1,136,009 $1,192,809 $1,252,450 $1,315,072 $1,380,826 $12,850,538 $4,890,656 $5,661,545 $6,553,946 $7,587,012 $24,693,160 $9,397,719 $10,879,035 $12,593,842 $14,578,947 $47,449,543 $91,177,441
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 $1,820,988 $1,849,179 $1,941,638 $2,038,720 $2,140,656 $2,247,689 $2,360,073 $2,478,077 $2,601,981 $2,732,080 $2,868,684 $3,019,644 $28,099,408 $3,384,115 $3,553,320 $3,730,986 $3,917,536 $4,113,412 $4,319,083 $4,535,037 $4,761,789 $4,999,878 $5,249,872 $5,512,366 $5,787,984 $53,865,379 $20,500,078 $23,731,403 $27,472,065 $31,802,350 $103,505,896 $39,392,259 $45,601,464 $52,789,394 $61,110,322 $198,893,439 $382,186,923

CapEx

Capital Purchases
Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.		 9/30/15
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 September-2015
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.		 Oct
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.		 2019
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.		 Will need additional purchases to meet production goals as they rise, we will also need additional computer equipment.
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Oct 2019 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.		 NAB MIXERS $30,000 Oct 2019 5 $5,000
BOTTLING MACHINE $11,000 Oct 2019 5 $2,000
VEHICLES $40,000 Oct 2019 5 $6,000
COMPUTERS $11,000 Oct 2019 5 $1,600
GRAPHIC SOFTWARE $5 Oct 2019 5 $0
REFRIGERATERS $15,000 Oct 2019 5 $2,500
Item Name (change name here) $0 Oct 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 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.		 QUICKBOOKS $2,244 Oct 2019 5 $0
INVENTORY COUNT $1,299 Oct 2019 5 $0
WINDOWS 10 $440 Oct 2019 5 $0
DESIGN SOFTWARE $500 Oct 2019 5 $0
SHIPPING SOFTWARE $60 Oct 2019 5 $0
Item Name (change name here) $0 Oct 2019 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 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.		 TELEPHONE SYSTEM $1,200 Oct 2019 5 $200
HEADSETS $115 Oct 2019 5 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Land
Author: Land purchases are not depreciable.
Item Name (change name here) $0 Oct 2019 Land is a non-depreciable asset
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017

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.		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
October November December January February March April May June July August September TOTAL October November December January February March April May June July August September TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL TOTAL
Management
Kristin Velix ( CEO / President) 2.0
Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees". 		2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0
Avg Salary per employee $0
Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).		 $0 $0 $0 $0 $0 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $25,002 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $4,313 $51,754 $13,391 $13,391 $13,391 $13,391 $53,566 $13,860 $13,860 $13,860 $13,860 $55,440 $57,381
Benefits (across all employees) $3,128
Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.		 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $37,540 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $38,666 $9,957 $9,957 $9,957 $9,957 $39,826 $10,255 $10,255 $10,255 $10,255 $41,021 $42,252
Payroll Taxes (across all employees) $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $9,001 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $1,553 $18,631 $4,821 $4,821 $4,821 $4,821 $19,284 $4,990 $4,990 $4,990 $4,990 $19,959 $20,657
Total Costs $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $12,962 $12,962 $12,962 $12,962 $12,962 $12,962 $96,545 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $13,400 $160,806 $41,560 $41,560 $41,560 $41,560 $166,241 $42,965 $42,965 $42,965 $42,965 $171,860 $177,670
Administrative/Support
1 Stephen Jobs ( Part Time ) 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
Avg Salary per employee $867 $867 $867 $867 $867 $867 $867 $867 $867 $867 $867 $867 $10,404 $897 $897 $897 $897 $897 $897 $897 $897 $897 $897 $897 $897 $10,768 $2,786 $2,786 $2,786 $2,786 $11,145 $2,884 $2,884 $2,884 $2,884 $11,535 $11,939
Benefits (across all employees) $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $1,564 $18,770 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $1,611 $19,333 $4,978 $4,978 $4,978 $4,978 $19,913 $5,128 $5,128 $5,128 $5,128 $20,510 $21,126
Payroll Taxes (across all employees) $156 $156 $156 $156 $156 $156 $156 $156 $156 $156 $156 $156 $1,873 $162 $162 $162 $162 $162 $162 $162 $162 $162 $162 $162 $162 $1,938 $502 $502 $502 $502 $2,006 $519 $519 $519 $519 $2,076 $2,149
Total Costs $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $2,587 $31,047 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $2,670 $32,040 $8,266 $8,266 $8,266 $8,266 $33,064 $8,530 $8,530 $8,530 $8,530 $34,122 $35,214
Sales/Marketing
Melinda Cates ( Creator and Master Mixer ) 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!
Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0
Avg Salary per employee $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $39,996 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $3,450 $41,396 $10,711 $10,711 $10,711 $10,711 $42,845 $11,086 $11,086 $11,086 $11,086 $44,344 $45,896
Benefits (across all employees) $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $3,128 $37,540 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $3,222 $38,666 $9,957 $9,957 $9,957 $9,957 $39,826 $10,255 $10,255 $10,255 $10,255 $41,021 $42,252
Payroll Taxes (across all employees) $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $14,399 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $1,242 $14,903 $3,856 $3,856 $3,856 $3,856 $15,424 $3,991 $3,991 $3,991 $3,991 $15,964 $16,523
Total Costs $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $10,994 $131,931 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $11,363 $136,360 $35,235 $35,235 $35,235 $35,235 $140,940 $36,418 $36,418 $36,418 $36,418 $145,673 $150,567
Operations/Production
Ian Glass ( Volunteer ) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Avg Salary per employee $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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
Other
# of Full Time Employees 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Avg Salary per employee $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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
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
Part-Time / Hourly Employees
# Part-Time Employees 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
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!		 1 1 1 1 1 1 1 1
Avg. Hours per Hourly Employee 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 60 60 60 60 60 60 60 60 240
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 $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 $2,754
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 $2,754
Benefits (across all employees) $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $36 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $37 $10 $10 $10 $10 $38 $10 $10 $10 $10 $39 $41
Payroll Taxes (across all employees) $36 $36 $36 $36 $36 $36 $36 $36 $36 $36 $36 $36 $432 $37 $37 $37 $37 $37 $37 $37 $37 $37 $37 $37 $37 $447 $116 $116 $116 $116 $463 $120 $120 $120 $120 $479 $496
Total Costs $239 $239 $239 $239 $239 $239 $239 $239 $239 $239 $239 $239 $2,868 $247 $247 $247 $247 $247 $247 $247 $247 $247 $247 $247 $247 $2,968 $768 $768 $768 $768 $3,072 $795 $795 $795 $795 $3,179 $3,290
TOTAL
# Full Time Employees $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 $2 $2 $2
# Part-Time Employees $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1
Salary/Wages $7,733 $7,733 $7,733 $7,733 $7,733 $7,733 $16,067 $16,067 $16,067 $16,067 $16,067 $16,067 $142,800 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $199,552 $51,634 $51,634 $51,634 $51,634 $206,536 $53,441 $53,441 $53,441 $53,441 $213,765 $221,247
Benefits $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $93,886 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $472,956 $24,901 $24,901 $24,901 $24,901 $99,604 $25,648 $25,648 $25,648 $25,648 $102,592 $105,670
Payroll Taxes $1,392 $1,392 $1,392 $1,392 $1,392 $1,392 $2,892 $2,892 $2,892 $2,892 $2,892 $2,892 $25,704 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $35,919 $9,294 $9,294 $9,294 $9,294 $37,177 $9,619 $9,619 $9,619 $9,619 $38,478 $39,824
GRAND TOTAL COSTS $16,949 $16,949 $16,949 $16,949 $16,949 $16,949 $26,783 $26,783 $26,783 $26,783 $26,783 $26,783 $262,390 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $27,681 $708,428 $85,829 $85,829 $85,829 $85,829 $343,317 $88,709 $88,709 $88,709 $88,709 $354,835 $366,741
Future Personnel:
Production line foreman
2 to 3 shifts of employee's as we grow
Projection line workforce
Maintenance Workforce
2 more nurse practioners

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		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
October November December January February March April May June July August September TOTAL October November December January February March April May June July August September TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
Professional Assistance
Marketing/PR Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising Agencies $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Social Media Specialists $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
SEO Specialist $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Graphic/Web Design $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Brochures/Leaflets/Flyers $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $6,000
Signs/Billboards $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,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 $6,000 $6,000 $6,000 $6,000 $24,000 $6,000 $6,000 $6,000 $6,000 $24,000 $24,000
Merchandising Displays $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sampling/Premiums $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Media Advertising
Print (newspaper, etc.) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Television and Radio $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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		 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000
Other Media . . . . . . . . . . . . $0 . . . . . . . . . . . . $0 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
Phone Directories $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising Specialties $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Direct Mail $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Website
Development/Programming $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
Maintenance and Hosting $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
Trade Shows
Fees and Setup $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Travel/Shipping $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Exhibits/Signs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Public Relations/Materials $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $6,000
Informal Marketing / Networking
Memberships/Meetings $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
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
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GRAND TOTAL COSTS $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

Marketing Budget

ProSvs

Professional Services
Author: For information about this worksheet, see Chapter 13, "Management & Organization" in Successful Business Plan: Secrets & Strategies.		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
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 $0 $0 $0 $0 $0
Industry specialists $2,000 $2,000 $2,000 $2,000 $2,000
Technology consultants $0 $0 $0 $0 $0
Mary Cates, JD First Year $10,000 $0 $0 $0 $0
Other (change title here) $0 $0 $0 $0 $0
Total Costs $15,500 $5,500 $5,500 $5,500 $5,500
GRAND TOTAL COSTS $15,500 $5,500 $5,500 $5,500 $5,500

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 September-2015
Melinda Cates $40,000
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.		 Oct
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.		 2019
Author: Enter the year you will receive the investment cash.		 Capital investments are not paid back on a loan schedule.
Glass Bottles $3,000 Oct 2019
Metal Caps $300 Oct 2019
Cardboard Cartons $500 Oct 2019
NAB Ingredients $600 Oct 2019
Labels $840 Oct 2019
Kristin Velix $200,000 Oct 2019
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Total Capital Investments $245,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 Oct 2019 12
Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.		 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Total Loans $20,000
TOTAL INVESTMENTS AND LOANS $265,240

Capital Investments and Loans

IncSt

Income Statements
Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
October November December January February March April May June July August September TOTAL October November December January February March April May June July August September TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
INCOME
Gross Sales $259,400 $272,370 $285,989 $300,288 $315,302 $331,067 $347,621 $365,002 $383,252 $402,415 $422,535 $443,662 $4,128,903 $498,454 $523,377.00 $549,546 $577,023 $605,874 $636,168 $667,976 $701,375 $736,444 $773,266 $811,930 $852,526 $7,933,960 $3,019,505 $3,495,455 $4,046,426 $4,684,244 $15,245,630 $5,802,180 $6,716,748 $7,775,476 $9,001,085 $29,295,488 $56,293,222
(Commissions) $9,728 $10,214 $10,725 $11,261 $11,824 $12,415 $13,036 $13,688 $14,372 $15,091 $15,845 $16,637 $154,834 $18,692 $19,626.64 $20,608 $21,638 $22,720 $23,856 $25,049 $26,302 $27,617 $28,997 $30,447 $31,970 $297,524 $113,231 $131,080 $151,741 $175,659 $571,711 $217,582 $251,878 $291,580 $337,541 $1,098,581 $2,110,996
(Returns and allowances) $7,782 $8,171 $8,580 $9,009 $9,459 $9,932 $10,429 $10,950 $11,498 $12,072 $12,676 $13,310 $123,867 $14,954 $15,701.31 $16,486 $17,311 $18,176 $19,085 $20,039 $21,041 $22,093 $23,198 $24,358 $25,576 $238,019 $90,585 $104,864 $121,393 $140,527 $457,369 $174,065 $201,502 $233,264 $270,033 $878,865 $1,688,797
Net Sales $241,891 $253,985 $266,684 $280,018 $294,019 $308,720 $324,156 $340,364 $357,382 $375,252 $394,014 $413,715 $3,850,202 $464,809 $488,049.06 $512,452 $538,074 $564,978 $593,227 $622,888 $654,032 $686,734 $721,071 $757,124 $794,980 $7,398,418 $2,815,689 $3,259,512 $3,773,292 $4,368,057 $14,216,550 $5,410,532 $6,263,368 $7,250,631 $8,393,512 $27,318,043 $52,493,429
(Cost of Goods) $77,820 $81,711 $85,797 $90,086 $94,591 $99,320 $104,286 $109,501 $114,976 $120,724 $126,761 $133,099 $1,238,671 $149,536 $157,013.10 $164,864 $173,107 $181,762 $190,850 $200,393 $210,413 $220,933 $231,980 $243,579 $255,758 $2,380,188 $905,852 $1,048,636 $1,213,928 $1,405,273 $4,573,689 $1,740,654 $2,015,024 $2,332,643 $2,700,325 $8,788,646 $16,887,967
GROSS PROFIT $164,071 $172,274 $180,888 $189,932 $199,429 $209,400 $219,870 $230,864 $242,407 $254,527 $267,254 $280,616 $2,611,531 $315,272 $331,035.96 $347,588 $364,967 $383,215 $402,376 $422,495 $443,620 $465,801 $489,091 $513,545 $539,223 $5,018,230 $1,909,837 $2,210,875 $2,559,364 $2,962,784 $9,642,861 $3,669,879 $4,248,343 $4,917,988 $5,693,186 $18,529,396 $35,605,463
EXPENSES - General and Administrative
Salaries and wages $7,733 $7,733 $7,733 $7,733 $7,733 $7,733 $16,067 $16,067 $16,067 $16,067 $16,067 $16,067 $142,800 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $16,629 $199,552 $51,634 $51,634 $51,634 $51,634 $206,536 $53,441 $53,441 $53,441 $53,441 $213,765 $221,247
Employee benefits $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $7,824 $93,886 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $8,059 $96,703 $24,901 $24,901 $24,901 $24,901 $99,604 $25,648 $25,648 $25,648 $25,648 $102,592 $105,670
Payroll taxes $1,392 $1,392 $1,392 $1,392 $1,392 $1,392 $2,892 $2,892 $2,892 $2,892 $2,892 $2,892 $25,704 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $2,993 $35,919 $9,294 $9,294 $9,294 $9,294 $37,177 $9,619 $9,619 $9,619 $9,619 $38,478 $39,824
Professional services $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $15,500 $458 $458 $458 $458 $458 $458 $458 $458 $458 $458 $458 $458 $5,500 $1,375 $1,375 $1,375 $1,375 $5,500 $1,375 $1,375 $1,375 $1,375 $5,500 $5,500
Marketing and advertising $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000 $6,000 $6,000 $6,000 $6,000 $24,000 $4,000 $4,000 $4,000 $4,000 $16,000 $10,000
Rent $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $180,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $180,000 $45,000 $45,000 $45,000 $45,000 $180,000 $45,000 $45,000 $45,000 $45,000 $180,000 $180,000
Equipment rental $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000 $3,000 $3,000 $3,000 $3,000 $12,000 $3,000 $3,000 $3,000 $3,000 $12,000 $12,000
Maintenance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $6,000
Depreciation $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $19,113 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $1,593 $19,113 $4,778 $4,778 $4,778 $4,778 $19,113 $4,778 $4,778 $4,778 $4,778 $19,113 $19,113
Insurance $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $62,076 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $5,173 $62,076 $15,519 $15,519 $15,519 $15,519 $62,076 $15,519 $15,519 $15,519 $15,519 $62,076 $62,076
Telephone service $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
Utilities $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $36,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $36,000 $9,000 $9,000 $9,000 $9,000 $36,000 $9,000 $9,000 $9,000 $9,000 $36,000 $36,000
Office supplies $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000
Postage and shipping $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000
Travel $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,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 $6,000 $6,000 $6,000 $6,000 $24,000 $6,000 $6,000 $6,000 $6,000 $24,000 $24,000
Entertainment $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000
Interest on loans $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Printing services $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $1,500 $1,500 $1,500 $1,500 $6,000 $6,000
TOTAL EXPENSES $51,406 $51,406 $51,406 $51,406 $51,406 $51,406 $61,240 $61,240 $61,240 $61,240 $61,240 $61,240 $675,879 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $61,305 $735,663 $182,201 $182,201 $182,201 $182,201 $728,805 $183,081 $183,081 $183,081 $183,081 $732,323 $738,230
Net income before taxes and interest $112,664 $120,868 $129,482 $138,526 $148,023 $157,994 $158,630 $169,623 $181,167 $193,287 $206,013 $219,376 $1,935,652 $253,967 $269,731 $286,283 $303,662 $321,910 $341,071 $361,190 $382,315 $404,496 $427,786 $452,240 $477,917 $4,282,567 $1,727,636 $2,028,674 $2,377,163 $2,780,583 $8,914,056 $3,486,798 $4,065,262 $4,734,907 $5,510,105 $17,797,073 $34,867,233
Interest Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Provision for taxes on income $22,533 $24,174 $25,896 $27,705 $29,605 $31,599 $31,726 $33,925 $36,233 $38,657 $41,203 $43,875 $387,130 $50,793 $53,946 $57,257 $60,732 $64,382 $68,214 $72,238 $76,463 $80,899 $85,557 $90,448 $95,583 $856,513 $345,527 $405,735 $475,433 $556,117 $1,782,811 $697,360 $813,052 $946,981 $1,102,021 $3,559,415 $6,973,447
NET PROFIT $90,131 $96,694 $103,585 $110,821 $118,418 $126,395 $126,904 $135,699 $144,933 $154,630 $164,811 $175,501 $1,548,522 $203,174 $215,785 $229,026 $242,930 $257,528 $272,857 $288,952 $305,852 $323,596 $342,229 $361,792 $382,334 $3,426,054 $1,382,109 $1,622,939 $1,901,730 $2,224,466 $7,131,245 $2,789,438 $3,252,210 $3,787,926 $4,408,084 $14,237,658 $27,893,787

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.		 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
October November December January February March April May June July August September TOTAL October November December January February March April May June July August September 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 $116,730 $122,567 $128,695 $135,130 $141,886 $148,980 $156,429 $164,251 $172,463 $181,087 $190,141 $199,648 $1,858,006 $224,304 $235,520 $247,296 $259,660 $272,643 $286,276 $300,589 $315,619 $331,400 $347,970 $365,368 $383,637 $3,570,282 $1,358,777 $1,572,955 $1,820,892 $2,107,910 $6,860,533 $2,610,981 $3,022,537 $3,498,964 $4,050,488 $13,182,970 $25,331,950
Collections $0 $142,670 $149,804 $157,294 $165,158 $173,416 $182,087 $191,191 $200,751 $210,789 $221,328 $232,394 $2,026,882 $244,014 $274,150 $287,857 $302,250 $317,363 $333,231 $349,892 $367,387 $385,756 $405,044 $425,296 $446,561 $4,138,803 $1,576,041 $1,835,243 $2,124,523 $2,459,401 $7,995,208 $2,986,244 $3,526,541 $4,082,412 $4,725,902 $15,321,098 $30,031,365
Total Cash from Sales $116,730 $265,237 $278,498 $292,423 $307,044 $322,397 $338,516 $355,442 $373,214 $391,875 $411,469 $432,042 $3,884,889 $468,319 $509,670 $535,153 $561,911 $590,006 $619,506 $650,482 $683,006 $717,156 $753,014 $790,665 $830,198 $7,709,085 $2,934,819 $3,408,197 $3,945,415 $4,567,311 $14,855,741 $5,597,225 $6,549,077 $7,581,376 $8,776,390 $28,504,067 $55,363,315
Income from Financing
Interest Income $0
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
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 $245,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $245,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 $265,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $265,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
Other Cash Receipts $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $450,000 $5,400,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $6,480,000 $1,620,000 $1,620,000 $1,620,000 $1,620,000 $6,480,000 $1,620,000 $1,620,000 $1,620,000 $1,620,000 $6,480,000 $6,480,000
TOTAL CASH RECEIPTS $831,970 $715,237 $728,498 $742,423 $757,044 $772,397 $788,516 $805,442 $823,214 $841,875 $861,469 $882,042 $9,550,129 $1,008,319 $1,049,670 $1,075,153 $1,101,911 $1,130,006 $1,159,506 $1,190,482 $1,223,006 $1,257,156 $1,293,014 $1,330,665 $1,370,198 $14,189,085 $4,554,819 $5,028,197 $5,565,415 $6,187,311 $21,335,741 $7,217,225 $8,169,077 $9,201,376 $10,396,390 $34,984,067 $61,843,315
CASH DISBURSEMENTS
Inventory $1,820,988 $1,849,179 $1,941,638 $2,038,720 $2,140,656 $2,247,689 $2,360,073 $2,478,077 $2,601,981 $2,732,080 $2,868,684 $3,019,644 $28,099,408 $3,384,115 $3,553,320 $3,730,986 $3,917,536 $4,113,412 $4,319,083 $4,535,037 $4,761,789 $4,999,878 $5,249,872 $5,512,366 $5,787,984 $53,865,379 $20,500,078 $23,731,403 $27,472,065 $31,802,350 $103,505,896 $39,392,259 $45,601,464 $52,789,394 $61,110,322 $198,893,439 $382,186,923
Operating Expenses $49,813 $49,813 $49,813 $49,813 $49,813 $49,813 $59,648 $59,648 $59,648 $59,648 $59,648 $59,648 $656,766 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $59,713 $716,550 $379,806 $379,806 $379,806 $379,806 $1,519,224 $379,806 $379,806 $379,806 $379,806 $1,519,224 $719,117
Commissions/Returns & Allowances $17,510 $18,385 $19,304 $20,269 $21,283 $22,347 $23,464 $24,638 $25,870 $27,163 $28,521 $29,947 $278,701 $33,646 $35,328 $37,094 $38,949 $40,897 $42,941 $45,088 $47,343 $49,710 $52,195 $54,805 $57,546 $535,542 $203,817 $235,943 $273,134 $316,186 $1,029,080 $391,647 $453,380 $524,845 $607,573 $1,977,445 $3,799,792
Capital Purchases $112,863 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $112,863 $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 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $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
Income Tax Payments $82,573
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. 		$82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $990,876 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $82,573 $990,876 $247,719 $247,719 $247,719 $247,719 $990,876 $247,719 $247,719 $247,719 $247,719 $990,876 $990,876
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 $2,085,413 $2,001,617 $2,094,995 $2,193,043 $2,295,992 $2,404,089 $2,527,425 $2,646,602 $2,771,737 $2,903,130 $3,041,092 $3,193,478 $30,158,614 $3,560,046 $3,730,934 $3,910,366 $4,098,770 $4,296,594 $4,504,310 $4,722,411 $4,951,417 $5,191,874 $5,444,353 $5,709,457 $5,987,815 $56,108,348 $21,331,420 $24,594,871 $28,372,724 $32,746,061 $107,045,076 $40,411,431 $46,682,369 $53,941,764 $62,345,421 $203,380,984 $387,696,709
NET CASH FLOW -$1,253,443 -$1,286,381 -$1,366,497 -$1,450,619 -$1,538,948 -$1,631,692 -$1,738,908 -$1,841,159 -$1,948,523 -$2,061,255 -$2,179,623 -$2,311,436 -$20,608,485 -$2,551,727 -$2,681,264 -$2,835,213 -$2,996,860 -$3,166,588 -$3,344,803 -$3,531,929 -$3,728,411 -$3,934,718 -$4,151,339 -$4,378,792 -$4,617,617 -$41,919,263 -$16,776,601 -$19,566,674 -$22,807,310 -$26,558,751 -$85,709,335 -$33,194,206 -$38,513,292 -$44,740,388 -$51,949,031 -$168,396,917 -$325,853,394
Opening Cash Balance $16,500 -$1,236,943 -$2,523,324 -$3,889,821 -$5,340,441 -$6,879,388 -$8,511,081 -$10,249,989 -$12,091,149 -$14,039,672 -$16,100,927 -$18,280,550 -$20,591,985 -$23,143,713 -$25,824,977 -$28,660,190 -$31,657,050 -$34,823,638 -$38,168,441 -$41,700,371 -$45,428,782 -$49,363,500 -$53,514,839 -$57,893,631 -$62,511,249 -$79,287,850 -$98,854,523 -$121,661,833 -$148,220,584 -$181,414,790 -$219,928,082 -$264,668,470 -$316,617,501
Cash Receipts $831,970 $715,237 $728,498 $742,423 $757,044 $772,397 $788,516 $805,442 $823,214 $841,875 $861,469 $882,042 $1,008,319 $1,049,670 $1,075,153 $1,101,911 $1,130,006 $1,159,506 $1,190,482 $1,223,006 $1,257,156 $1,293,014 $1,330,665 $1,370,198 $4,554,819 $5,028,197 $5,565,415 $6,187,311 $7,217,225 $8,169,077 $9,201,376 $10,396,390 $61,843,315
Cash Disbursements $2,085,413 $2,001,617 $2,094,995 $2,193,043 $2,295,992 $2,404,089 $2,527,425 $2,646,602 $2,771,737 $2,903,130 $3,041,092 $3,193,478 $3,560,046 $3,730,934 $3,910,366 $4,098,770 $4,296,594 $4,504,310 $4,722,411 $4,951,417 $5,191,874 $5,444,353 $5,709,457 $5,987,815 $21,331,420 $24,594,871 $28,372,724 $32,746,061 $40,411,431 $46,682,369 $53,941,764 $62,345,421 $387,696,709
ENDING CASH BALANCE -$1,236,943 -$2,523,324 -$3,889,821 -$5,340,441 -$6,879,388 -$8,511,081 -$10,249,989 -$12,091,149 -$14,039,672 -$16,100,927 -$18,280,550 -$20,591,985 -$20,591,985 -$23,143,713 -$25,824,977 -$28,660,190 -$31,657,050 -$34,823,638 -$38,168,441 -$41,700,371 -$45,428,782 -$49,363,500 -$53,514,839 -$57,893,631 -$62,511,249 -$62,511,249 -$79,287,850 -$98,854,523 -$121,661,833 -$148,220,584 -$148,220,584 -$181,414,790 -$219,928,082 -$264,668,470 -$316,617,501 -$316,617,501 -$642,470,895

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
Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name
First Quarter Second Quarter Third Quarter Fourth Quarter 2020-2021 2021-2022 2022-2023 2023-2024
2019-2020 2019-2020 2019-2020 2019-2020
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 -$3,889,821 Cash -$8,511,081 Cash -$14,039,672 Cash -$20,591,985 Cash -$62,511,249 Cash -$148,220,584 Cash -$316,617,501 Cash -$642,470,895
Accounts Receivable $157,294 Accounts Receivable $182,087 Accounts Receivable $210,789 Accounts Receivable $244,014 Accounts Receivable $468,889 Accounts Receivable $858,778 Accounts Receivable $1,650,199 Accounts Receivable $2,580,106
Inventory $5,366,478 Inventory $11,509,545 Inventory $18,620,914 Inventory $26,860,737 Inventory $78,345,929 Inventory $177,278,136 Inventory $367,382,929 Inventory $732,681,885
Other Current Assets $112,863 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 $1,746,813 Total Current Assets $3,180,552 Total Current Assets $4,792,031 Total Current Assets $6,512,766 Total Current Assets $16,303,570 Total Current Assets $29,916,331 Total Current Assets $52,415,627 Total Current Assets $92,791,097
Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets
Land $0 Land $0 Land $0 Land $0 Land $0 Land $0 Land $0 Land $0
Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0
Equipment $107,005 Equipment $107,005 Equipment $107,005 Equipment $107,005 Equipment $107,005 Equipment $107,005 Equipment $107,005 Equipment $107,005
Computers & Telecommunications $5,858 Computers & Telecommunications $5,858 Computers & Telecommunications $5,858 Computers & Telecommunications $5,858 Computers & Telecommunications $5,858 Computers & Telecommunications $5,858 Computers & Telecommunications $5,858 Computers & Telecommunications $5,858
(Less Accumlated Depreciation) $4,778 (Less Accumlated Depreciation) $9,556 (Less Accumlated Depreciation) $14,334 (Less Accumlated Depreciation) $19,113 (Less Accumlated Depreciation) $38,225 (Less Accumlated Depreciation) $57,338 (Less Accumlated Depreciation) $76,450 (Less Accumlated Depreciation) $95,563
Total Fixed Assets $108,085 Total Fixed Assets $103,307 Total Fixed Assets $98,528 Total Fixed Assets $93,750 Total Fixed Assets $74,638 Total Fixed Assets $55,525 Total Fixed Assets $36,413 Total Fixed Assets $17,300
Other Assets $112,863 Other Assets $112,863 Other Assets $112,863 Other Assets $112,863 Other Assets $112,863 Other Assets $112,863 Other Assets $112,863 Other Assets $112,863
TOTAL ASSETS $1,967,761 TOTAL ASSETS $3,396,721 TOTAL ASSETS $5,003,422 TOTAL ASSETS $6,719,379 TOTAL ASSETS $16,491,070 TOTAL ASSETS $30,084,719 TOTAL ASSETS $52,564,902 TOTAL ASSETS $92,921,260
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 $15,000
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year 		Short-Term Notes Payable $10,000 Short-Term Notes Payable $5,000 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0
Income Taxes Due -$175,116
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 -$333,927 Income Taxes Due -$479,762 Income Taxes Due -$603,746 Income Taxes Due -$738,108 Income Taxes Due $53,827 Income Taxes Due $2,622,366 Income Taxes Due $8,604,936
Other Current Liabilities $112,863 Other Current Liabilities $112,863 Other Current Liabilities $112,863 Other Current Liabilities $112,863 Other Current Liabilities $112,863 Other Current Liabilities $112,863 Other Current Liabilities $112,863 Other Current Liabilities $112,863
Total Current Liabilities -$47,253 Total Current Liabilities -$211,064 Total Current Liabilities -$361,899 Total Current Liabilities -$490,883 Total Current Liabilities -$625,245 Total Current Liabilities $166,690 Total Current Liabilities $2,735,229 Total Current Liabilities $8,717,799
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 $0 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 Long-Term Notes Payable $0 Long-Term Notes Payable $0
Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000 Other Long-Term Liabilities $440,000
Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000 Total Long-Term Liabilities $440,000
NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH
Paid-In Capital $261,740 Paid-In Capital $261,740 Paid-In Capital $261,740 Paid-In Capital $261,740 Paid-In Capital $261,740 Paid-In Capital $261,740 Paid-In Capital $261,740 Paid-In Capital $261,740
Retained Earnings $1,313,274 Retained Earnings $2,906,045 Retained Earnings $4,663,581 Retained Earnings $6,508,522 Retained Earnings $16,414,575 Retained Earnings $29,216,289 Retained Earnings $49,127,934 Retained Earnings $83,501,720
Total Net Worth $1,575,014 Total Net Worth $3,167,785 Total Net Worth $4,925,321 Total Net Worth $6,770,262 Total Net Worth $16,676,315 Total Net Worth $29,478,029 Total Net Worth $49,389,674 Total Net Worth $83,763,460
TOTAL LIABILITIES AND NET WORTH $1,967,761 TOTAL LIABILITIES AND NET WORTH $3,396,721 TOTAL LIABILITIES AND NET WORTH $5,003,422 TOTAL LIABILITIES AND NET WORTH $6,719,379 TOTAL LIABILITIES AND NET WORTH $16,491,070 TOTAL LIABILITIES AND NET WORTH $30,084,719 TOTAL LIABILITIES AND NET WORTH $52,564,902 TOTAL LIABILITIES AND NET WORTH $92,921,260

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 (2019-2020)
October $81,275
Author: This is the amount of sales you will need to make each month to break even.
November $81,275
December $81,275
January $81,275
February $81,275
March $81,275
April $96,823
May $96,823
June $96,823
July $96,823
August $96,823
September $96,823
Monthly Average $89,049
Year 2 (2020-2021)
October $96,925
November $96,925
December $96,925
January $96,925
February $96,925
March $96,925
April $96,925
May $96,925
June $96,925
July $96,925
August $96,925
September $96,925
Monthly Average $96,925
Year 3 (2021-2022)
1st Quarter $288,065
2nd Quarter $288,065
3rd Quarter $288,065
4th Quarter $288,065
Quarterly Average $288,065
Year 4 (2022-2023)
1st Quarter $289,456
2nd Quarter $289,456
3rd Quarter $289,456
4th Quarter $289,456
Quarterly Average $289,456
Year 5 (2023-2024)
Annual Average $1,167,161

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 (2019-2020) 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 $1,794,066 -36.97 76.60 0.43 0.25 23% 48% 18% $762,559.80
2nd Quarter $3,391,615 -15.07 39.46 0.26 0.07 14% 50% 13% $882,758.29
3rd Quarter $5,153,930 -13.24 38.21 0.20 0.02 10% 50% 10% $1,021,903.07
4th Quarter $7,003,649 -13.27 41.45 0.17 -0.01 9% 52% 9% $1,182,980.54
Year 2 (2020-2021) $16,928,815 -26.08 99.23 0.44 -0.01 26% 58% 26% $7,398,417.70
Year 3 (2021-2022) $29,749,641 179.47 -884.05 0.48 0.02 30% 63% 30% $14,216,549.90
Year 4 (2022-2023) $49,680,398 19.16 -115.15 0.55 0.06 36% 65% 34% $27,318,042.74
Year 5 (2023-2024) $84,073,297 10.64 -73.40 0.62 0.11 42% 66% 38% $52,493,429.46

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2019-2020) Gross Sales Oct ober November December January February March April May June July August September 259400 272370 285988.5 300287.92499999999 315302.32125000004 331067.43731250003 347620.809178125 365001.84963703132 383251.9421188829 402414.53922482702 422535.26618606842 443662.02949537185 Gross Profit October November December January February March April May June July August September 164070.5 172274.02499999999 180887.72625000001 189932.1125625 199428.71819062508 209400.15410015627 219870.16180516407 230863.6698954223 242406.85339019346 254527.1960597031 267253.55586268828 280616.23365582275 Net Profit October November December January February March April May June July August September 90131.476799999989 96694.296799999982 103585.25779999999 110820.76684999999 118418.05135250006 126395.200080 12501 126903.91024413126 135698.71671633783 144933.26351215475 154629.53764776248 164810.62549015062 175500.76772465819

NSYr1

Year 1: Net Sales (2019-2020) In House Lemon Lime October November December January February March April May June July August September 46531.75 48858.337500000001 51301.254375000004 53866.317093750004 56559.632948437502 59387.614595859377 62356.995325652351 65474.845091934985 68748.587346531727 72186.01671385832 75795.317549551226 79585.083427028774 In House Orange Juice October November December January February March April May June July August September 46531.75 48858.337500000001 51301.254375000004 53866.317093750004 56559.632948437502 59387.614595859377 62356.995325652351 65474.845091934985 68748.587346531727 72186.01671385832 75795.317549551226 79585.083427028774 Store Lemon Lime October November December January February March April May June July August September 93016.875 97667.71875 102551.1046875 107678.65992187501 113062.59291796875 118715.7225638672 124651.50869206054 130884.0841266636 137428.28833299677 144299.70274964662 151514.68788712897 159090.4222814854 Store Orange October November December January February March April May June July August September 55810.125 58600.631249999999 61530.662812499999 64607.195953124996 67837.555750781248 71229.433538320329 74790.905215236344 78530.45047599815 82456.972999798061 86579.821649787962 90908.812732277365 95454.253368891237 Product Line 5 Product Line 6 Product Line 7 Product Line 8 Product Line 9 Product Line 10

1YrCshFlw

Year 1: Cash Flow (2019-2020) Net Cash Flow October November December January February March April May June July August September -1253443.4466666668 -1286380.7316666667 -1366497.112916667 -1450619.3132291664 -1538947.6235572915 -1631692.3494018225 -1738908.4315385805 -1841159.4917821772 -1948523.1050379532 -2061254.8989565172 -2179623.2825710094 -2311435.711093239 Ending Cash Balance -1236943.4466666668 -2523324.1783333337 -3889821.2912500007 -5340440.6044791676 -6879388.2280364595 -8511080.5774382818 -10249989.008976862 -12091148 .500759039 -14039671.605796993 -16100926.504753511 -18280549.787324522 -20591985.498417761

2ndYrCshFlw

Year 2: Cash Flow (2020-2021) Net Cash Flow October November December January February March April May June July August September -2551727.1786511941 -2681264.2246030713 -2835213.1603948912 -2996859.5429763026 -3166588.2446867842 -3344803.3814827912 -3531929.2751185969 -3728411.4634361947 -3934717.7611696711 -4151339.3737898218 -4378792.067040978 -4617617.3949546944 Ending Cash Balance October November December January February March April May June July August September -23143712.677068956 -25824976.901672028 -28660190.06206692 -31657049.605043221 -34823637.84973 -38168441.231212795 -41700370.506331392 -45428781.969767593 -49363499.730937265 -53514839.104727089 -57893631.171768069 -62511248.566722766

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 4128902.6194028067 7933960.0007847445 15245629.915862944 29295488.193596337 56293221.942122951 Gross Profit 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2611530.9067722755 5018229.7004963513 9642860.9217833113 18529396.282449685 35605462.878392763 Net Profit 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 1548521.8710178204 3426053.6218370809 7131244.5340010496 14237658.370196253 27893786.640971482

NS5Yr

5-Year Net Sales

In House Lemon Lime 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 740651.75196760427 1423211.4235409233 2734795.0649092356 5255089.9489297476 10098003.585602853 In House Orange Juice 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 740651.75196760427 1423211.4235409233 2734795.0649092356 5255089.9489297476 10098003.585602853 Store Lemon Lime 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 1480561.3679111926 2844996.7835312048 5466849.8542023282 10504914.27666818 20185888.931139965 Store Orange 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 888336.82074671553 1706998.0701187225 3280109.9125213972 6302948.5660009068 12111533.358683977 Product Line 5 Product Line 6 Product Line 7 Product Line 8 Product Line 9 Product Line 10

License

License Agreement
LICENSE AGREEMENT FOR PLANNINGSHOP’S BUSINESS PLAN FINANCIALS This License Agreement is a legal agreement between you (the product purchaser/user) and PlanningShop for the Business Plan Financials product (“Software”) that accompanies this Agreement, including all associated documentation and packaging. By installing and/or using the Software, you accept the terms of this Agreement. PRODUCT LICENSE The Software is protected by intellectual property laws and treaties. It is owned by PlanningShop and licensed to you for your use (not sold). You acknowledge that PlanningShop has conferred to you NO title or ownership of the Software or any of its constituent parts. Re-distribution of the Software or any of constituent its parts, whether in an original or modified form, is strictly forbidden. 1. General License. You may install one copy of the Software on a single computing device for use by a single user. Additional users, whether using the same computing device or a separate device, must purchase additional licenses. Multi-user licenses are available from PlanningShop. A second copy of the Software may be stored on a separate device for the sole purpose of backing up the original copy. You may not copy, distribute, or resell the Software. 2. Unauthorized Use. You may not modify, disassemble, or reverse engineer the Software or its code for any form of distribution. The Software, its content, design and programming are copyrighted by PlanningShop. 3. WARRANTY. THIS SOFTWARE IS PROVIDED AS IS. PLANNINGSHOP AND ITS AFFILIATED PARTIES MAKE NO CLAIMS, PROMISES OR GUARANTEES ABOUT THE ACCURACY, COMPLETENESS, OR ADEQUACY OF THE SOFTWARE FOR ANY PURPOPSE AND EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS, OMISSIONS, FAILURES, OR DEFECTS. NO WARRANTY OF ANY KIND, IMPLIED, EXPRESS OR STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND FREEDOM FROM COMPUTER VIRUS, IS GIVEN IN CONJUNCTION WITH THE SOFTWARE.
4. DAMAGES. IN NO EVENT WILL PLANNINGSHOP BE LIABLE FOR ANY DAMAGES, INCLUDING WITHOUT LIMITATION DIRECT OR INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, LOSSES OR EXPENSES ARISING IN CONNECTION WITH THIS SOFTWARE OR USE THEREOF OR INABILITY TO USE BY ANY PARTY, OR IN CONNECTION WITH ANY FAILURE OF PERFORMANCE, ERROR, OMISSION, DEFECT, OR COMPUTER VIRUS EVEN IF THE PLANNINGSHOP, OR AFFILIATED PARTIES, ARE ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, LOSSES OR EXPENSES. 5. Governing Law. This Agreement shall be treated as though it were executed and performed in Palo Alto, California, and shall be governed by and construed in accordance with the laws of the State of California, USA (without regard to conflict of law principles). All actions shall be subject to the limitations set forth in Section 3 and Section 4. The language in this Agreement shall be interpreted as in accordance with its fair meaning and not strictly for or against either party. All legal proceedings arising out of or in connection with this Agreement shall be brought solely in Palo Alto, California. You expressly submit to the exclusive jurisdiction of said courts and consent to extraterritorial service of process. Should any part of this Agreement be held invalid or unenforceable, that portion shall be construed consistent with applicable law and the remaining portions shall remain in full force and effect. 6. Contact. Should you have any questions concerning this agreement, or if you desire to contact PlanningShop for any reason, you may do so at: PlanningShop, 555 Bryant Street #180, Palo Alto, California, USA, 94301.

About

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

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
2019
Sure Product Consulting: Sure Product Consulting: How does this get set? Headings on each worksheet are driven from it, but this does not seem to be connected t the Setup worksheet "what year wll your business start" question.
Version: Startup Month
3.0 October
8/1/13 Startup Month Abbrev
Oct
Start Date:
Sep-15
CREDIT MULTIPLIER
Multiple With "Credit Sales"
A 0.00 0.00
B 1.00 0.55
Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet
Q1 $1,794,066
Q2 $3,391,615
Q3 $5,153,930
Q4 $7,003,649
Y2 $16,928,815
Y3 $29,749,641
Y4 $49,680,398
Y5 $84,073,297
Chart Titles
Year 1 String 2019-2020 Year 1: Financials at-a-Glance (2019-2020)
Year 2 String 2020-2021 Year 1: Net Sales (2019-2020)
Year 3 String 2021-2022 Year 1: Cash Flow (2019-2020)
Year 4 String 2022-2023 Year 2: Cash Flow (2020-2021)
Year 5 String 2023-2024
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 October November December January February March April May June July August September
Match Position in Doublelist 10 11 12 13 14 15 16 17 18 19 20 21
Adjust index to 1-12 10 11 12 1 2 3 4 5 6 7 8 9
Abbrev Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
To-Do List
Making a "Demo" version of this workbook, with watermark, 1 loan, 1 product line, 1 investment
Adding a Worksheet to do revolving credit calculations. See http://www.vertex42.com/Files/download/line-of-credit.html for a cool line of credit worksheet (it's complicated)
Cleaning up all the dates, lists of months, etc. on the config worksheet
Adding "Reset_XXX" subroutines for ALL the worksheets
Check PrintAreas, footers, headers for New DepnSchedule and New LoanPaymentSchedule

Your Company Name

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

DepnSchedule


Sure Product Consulting: Is this depreciation schedule correct? If only one year of service, nothing is depreciated. If more than one year, we don't depreciate anything for year 1 it seems (or does that show up as an expense?) 		Depreciation Schedule from CapEx Worksheet
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 Jul-20 Aug-20
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 Oct 2019 1 12 Aug-16 $ - 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 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Facilities Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Equip NAB MIXERS $30,000.00 $5,000.00 5 60 Oct 2019 1 60 Aug-20 $ 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417 417
12 Equip BOTTLING MACHINE $11,000.00 $2,000.00 5 60 Oct 2019 1 60 Aug-20 $ 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150
13 Equip VEHICLES $40,000.00 $6,000.00 5 60 Oct 2019 1 60 Aug-20 $ 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567 567
14 Equip COMPUTERS $11,000.00 $1,600.00 5 60 Oct 2019 1 60 Aug-20 $ 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157
15 Equip GRAPHIC SOFTWARE $5.00 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 Equip REFRIGERATERS $15,000.00 $2,500.00 5 60 Oct 2019 1 60 Aug-20 $ 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208 208
17 Equip Item Name (change name here) $0.00 $0.00 1 12 Oct 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
21 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
22 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
23 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
24 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
25 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
26 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
27 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
28 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
29 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
30 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
31 Comp QUICKBOOKS $2,243.99 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37
32 Comp INVENTORY COUNT $1,299.00 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22
33 Comp WINDOWS 10 $439.99 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7
34 Comp DESIGN SOFTWARE $499.99 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8
35 Comp SHIPPING SOFTWARE $59.99 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
36 Comp Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
37 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
38 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
39 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
40 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
41 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
42 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
43 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
44 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
45 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
46 Comp TELEPHONE SYSTEM $1,199.88 $200.00 5 60 Oct 2019 1 60 Aug-20 $ 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17
47 Comp HEADSETS $115.00 $0.00 5 60 Oct 2019 1 60 Aug-20 $ 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 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
48 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
49 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
50 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
51 Land Item Name (change name here) $0.00 $0.00 1 12 Oct 2019 1 12 Aug-16
52 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
53 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
54 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
55 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
56 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
57 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
58 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
59 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
60 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Aug-16
TOTAL $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593 $ 1,593
Land - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Facilities - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Equip 107,005 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Comp 5,858 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL
Author: This goes into Cash Flow statement.
Author: This goes into Cash Flow statement.		 112,863 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
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"		 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Depreciation Schedule

LoanInvestSchedules

Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds
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 Jul-20 Aug-20
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 $40,000 Oct 2019 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
2 Glass Bottles $3,000 Oct 2019 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 Metal Caps $300 Oct 2019 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 Oct 2019 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 Oct 2019 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 Labels $840 Oct 2019 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
7 Kristin Velix $200,000 Oct 2019 1 200,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
8 Investment Source Name $0 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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: $245,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)
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 Jul-20 Aug-20 Sep-20
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.		 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21
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 0.00% 12 Oct 2019 1 12 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 1,666.67 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
2 Loan Source Name $0 0.00% 12 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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 Jan 2017 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: $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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
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 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21
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.00 $12.00 Oct $2,019.00 1 12 1,666.67 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds
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 Jul-20 Aug-20
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 Oct 2019 1 20,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Loan Source Name $0 Jan 2017 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 0.00% 12 Oct 2019 1 $20,000 $5,000 $15,000
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 		$0
Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out. 		$10,000
Sure Product Consulting: cummulative principle paid: includes previous quarter's payments		 $10,000 $0 $15,000 $5,000 $0 $20,000 $0 $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 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
3 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
4 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
5 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
6 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
7 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
8 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
9 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
10 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
11 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
12 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
13 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
14 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
15 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
16 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
17 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
18 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
19 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
20 Loan Source Name $0.00 0.00% 12 Jan 2017 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: $15,000 $0 $10,000 $0 $5,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
BETA - Monthly Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet
Sep-15 Oct-15 Nov-15 Sep-15 Jan-16 Feb-16 Sep-15 Apr-16 May-16 Sep-15 Jul-16 Aug-16 Sep-15 Oct-16 Nov-16 Sep-15 Jan-17 Feb-17 Sep-15 Apr-17 May-17 Sep-15 Jul-17 Aug-17 Sep-15 Oct-17 Nov-17 Sep-15 Jan-18 Feb-18 Sep-15 Apr-18 May-18 Sep-15 Jul-18 Aug-18 Sep-15 Oct-18 Nov-18 Sep-15 Jan-19 Feb-19 Sep-15 Apr-19 May-19 Sep-15 Jul-19 Aug-19 Sep-15 Oct-19 Nov-19 Sep-15 Jan-20 Feb-20 Sep-15 Apr-20 May-20 Sep-15 Jul-20 Aug-20
Loan # Name of Loan Source Amount Rate Periods Start Month Start Year Begin Pay Month Last Month Num 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
1 Friends and Family $20,000.00 0.000% 12 Oct $2,019.00 1 12 Principle Paid $1,666.67 $3,333.33 $5,000.00 $6,666.67 $8,333.33 $10,000.00 $11,666.67 $13,333.33 $15,000.00 $16,666.67 $18,333.33 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00
Due Short $18,333.33 $16,666.67 $15,000.00 $13,333.33 $11,666.67 $10,000.00 $8,333.33 $6,666.67 $5,000.00 $3,333.33 $1,666.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Due Long $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000

Loan & Investment Schedules for Disbursement & Repayment