Assignment 4: Business Plan--Final

CopyofFizzy2_Assignment3.xlsm

Home >Business & Finance homework help >Operations Management homework help >Assignment 4: Business Plan--Final

Warning

W A R N I N G !

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

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

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

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

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

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

Excel 2013 and Excel 2016 on Windows - Enabling Macros

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

2. Select Options, in the lower left corner.

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

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

Your Company Name

Welcome

Welcome to Business Plan Financials!

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

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

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

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

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

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

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

About Our Support of Mac vs. Windows

PlanningShop supports Business Plan Financials on the following platforms:

Windows

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

2. Microsoft Windows 8 or later with Microsoft Excel 2013

Mac

4 Mac OS X with Microsoft Excel 2016

5. Mac OS X with Microsoft Excel for Mac 2011

Setup

Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Frizzy Bottles
What month will you officially start your company?	October

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?	Two Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.
Ten
Most businesses sell at least some of their products/services on credit (e.g., "net 30" as opposed to cash). What percentage of your sales will be made on credit?	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.)?	$3,000 Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)?	$2,500 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?	4.00%
If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by?	3.00%
Approximately what percentage of each employee's salary or wages do you plan to set aside for payroll taxes?	15.00% Author: If you're not sure what percentage to enter here, leave it at the default (15%).
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of business? This will be the opening balance in your Cash Flow Statements.	$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?	25.00% Author: If you're not sure what percentage to enter here, leave it at the default (25%).
If you will use an interest-bearing account for your banking, at what rate will you accrue interest?	1.00% Author: If you're not sure what percentage to enter here, leave it at the default (1.00%).

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
Product Line 1 Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.
Unit Volume	2.00% Author: MONTHLY VOLUME GROWTH RATE The Worksheets automatically increase the volume in each month on this line using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	7500 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.	7650 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.	7803	7959	8118	8281	8446	8615	8787	8963	9142	9325	100591	9512	9702	9896	10094	10296	10502	10712	10926	11145	11367	11595	11827	127573	36918 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	39178	41576	44121	161794	46822	49687	52729	55956	205194	260235
Unit Price	2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$2.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.	$2.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.	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.05	$2.10	$2.10	$2.10	$2.10	$2.15	$2.15	$2.15	$2.15	$2.21
Gross Sales	$15,000	$15,300	$15,606	$15,918	$16,236	$16,561	$16,892	$17,230	$17,575	$17,926	$18,285	$18,650.61	$201,181	$19,499	$19,889	$20,287	$20,693	$21,107	$21,529	$21,959	$22,398	$22,846	$23,303	$23,769	$24,245	$261,525	$77,575	$82,323	$87,362	$92,709	$339,969	$100,843	$107,016	$113,566	$120,517	$441,942	$574,502
(Commissions)	40.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?	10.00% Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?	$600	$612	$624	$637	$649	$662	$676	$689	$703	$717	$731	$746	$8,047	$780	$796	$811	$828	$844	$861	$878	$896	$914	$932	$951	$970	$10,461	$3,103	$3,293	$3,494	$3,708	$13,599	$4,034	$4,281	$4,543	$4,821	$17,678	$22,980
(Returns and Allowances)	2.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.	$300.00	$306	$312.12	$318.36	$324.73	$331.22	$337.85	$344.61	$351.50	$358.53	$365.70	$373.01	$4,024	$389.98	$397.78	$405.74	$413.85	$422.13	$430.57	$439.19	$447.97	$456.93	$466.07	$475.39	$484.90	$5,231	$1,551.50	$1,646.46	$1,747.24	$1,854.18	$6,799	$2,016.87	$2,140.32	$2,271.32	$2,410.34	$8,839	$11,490.04
Net Sales	$14,100	$14,382	$14,670	$14,963	$15,262	$15,568	$15,879	$16,196	$16,520	$16,851	$17,188	$17,532	$189,110	$18,329	$18,696	$19,070	$19,451	$19,840	$20,237	$20,642	$21,055	$21,476	$21,905	$22,343	$22,790	$245,834	$72,920	$77,384	$82,120	$87,147	$319,571	$94,793	$100,595	$106,752	$113,286	$415,426	$540,032
(Cost of Goods Sold)	10.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.	$1,500.00	$1,530	$1,561	$1,592	$1,624	$1,656	$1,689	$1,723	$1,757	$1,793	$1,828	$1,865	$20,118	$1,950	$1,989	$2,029	$2,069	$2,111	$2,153	$2,196	$2,240	$2,285	$2,330	$2,377	$2,424	$26,153	$7,757	$8,232	$8,736	$9,271	$33,997	$10,084	$10,702	$11,357	$12,052	$44,194	$57,450
GROSS PROFIT	$12,600	$12,852	$13,109	$13,371	$13,639	$13,911	$14,190	$14,473	$14,763	$15,058	$15,359	$15,667	$168,992	$16,379	$16,707	$17,041	$17,382	$17,730	$18,084	$18,446	$18,815	$19,191	$19,575	$19,966	$20,366	$219,681	$65,163	$69,151	$73,384	$77,876	$285,574	$84,708	$89,893	$95,395	$101,234	$371,231	$482,582
Product Line 2 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume	5.00%	6000	6300	6615	6946	7293	7658	8041	8443	8865	9308	9773	10262	95503	10775	11314	11880	12474	13097	13752	14440	15162	15920	16716	17552	18429	171509	61003 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	70618	81750	94635	308006	109552	126820	146810	169951	553134	993350
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.	$5.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.	$5.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.	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.13	$5.25	$5.25	$5.25	$5.25	$5.38	$5.38	$5.38	$5.38	$5.52
Gross Sales	$30,000	$31,500	$33,075	$34,729	$36,465	$38,288	$40,203	$42,213	$44,324	$46,540	$48,867	$51,310	$477,514	$55,223	$57,984	$60,883	$63,927	$67,123	$70,480	$74,004	$77,704	$81,589	$85,668	$89,952	$94,449	$878,985	$320,455	$370,967	$429,441	$497,131	$1,617,994	$589,879	$682,858	$790,494	$915,095	$2,978,326	$5,482,362
(Commissions)	40.00%	10.00%	$1,200	$1,260	$1,323	$1,389	$1,459	$1,532	$1,608	$1,689	$1,773	$1,862	$1,955	$2,052	$19,101	$2,209	$2,319	$2,435	$2,557	$2,685	$2,819	$2,960	$3,108	$3,264	$3,427	$3,598	$3,778	$35,159	$12,818	$14,839	$17,178	$19,885	$64,720	$23,595	$27,314	$31,620	$36,604	$119,133	$219,294
(Returns and Allowances)	2.00%	$600	$630	$662	$695	$729	$766	$804	$844	$886	$931	$977	$1,026	$9,550	$1,104	$1,160	$1,218	$1,279	$1,342	$1,410	$1,480	$1,554	$1,632	$1,713	$1,799	$1,889	$17,580	$6,409	$7,419	$8,589	$9,943	$32,360	$11,798	$13,657	$15,810	$18,302	$59,567	$109,647
Net Sales	$28,200	$29,610	$31,091	$32,645	$34,277	$35,991	$37,791	$39,680	$41,664	$43,747	$45,935	$48,232	$448,863	$51,909	$54,505	$57,230	$60,091	$63,096	$66,251	$69,563	$73,041	$76,694	$80,528	$84,555	$88,782	$826,246	$301,228	$348,709	$403,674	$467,303	$1,520,914	$554,486	$641,887	$743,064	$860,190	$2,799,627	$5,153,421
(Cost of Goods Sold)	8.00%	$2,400	$2,520	$2,646	$2,778	$2,917	$3,063	$3,216	$3,377	$3,546	$3,723	$3,909	$4,105	$38,201	$4,418	$4,639	$4,871	$5,114	$5,370	$5,638	$5,920	$6,216	$6,527	$6,853	$7,196	$7,556	$70,319	$25,636	$29,677	$34,355	$39,770	$129,439	$47,190	$54,629	$63,240	$73,208	$238,266	$438,589
GROSS PROFIT	$25,800	$27,090	$28,445	$29,867	$31,360	$32,928	$34,574	$36,303	$38,118	$40,024	$42,025	$44,127	$410,662	$47,491	$49,866	$52,359	$54,977	$57,726	$60,612	$63,643	$66,825	$70,166	$73,675	$77,359	$81,226	$755,927	$275,591	$319,032	$369,319	$427,533	$1,391,475	$507,296	$587,258	$679,825	$786,982	$2,561,361	$4,714,832
Product Line 3 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume	2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0	0	0	0	0	0	0
Unit Price	2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.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 4 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
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 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"
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"
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"
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"
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"
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"
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
Totals for All Product Lines
Total Unit Volume	13500	13950	14418	14905	15411	15938	16487	17058	17652	18271	18916	19587	196093	20287	21016	21776	22568	23393	24254	25152	26088	27064	28083	29146	30256	299083	97921	109796	123326	138756	469800	156374	176508	199539	225907	758328	1253585
Total Gross Sales	$45,000	$46,800	$48,681	$50,647	$52,702	$54,850	$57,095	$59,443	$61,899	$64,466	$67,152	$69,961	$678,695	$74,722	$77,873	$81,170	$84,620	$88,230	$92,008	$95,963	$100,102	$104,435	$108,972	$113,721	$118,694	$1,140,510	$398,030	$453,290	$516,803	$589,840	$1,957,963	$690,722	$789,874	$904,060	$1,035,613	$3,420,269	$6,056,864
(Total Commissions)	$1,800	$1,872	$1,947	$2,026	$2,108	$2,194	$2,284	$2,378	$2,476	$2,579	$2,686	$2,798	$27,148	$2,989	$3,115	$3,247	$3,385	$3,529	$3,680	$3,839	$4,004	$4,177	$4,359	$4,549	$4,748	$45,620	$15,921	$18,132	$20,672	$23,594	$78,319	$27,629	$31,595	$36,162	$41,425	$136,811	$242,275
(Total Returns and Allowances)	$900	$936	$974	$1,013	$1,054	$1,097	$1,142	$1,189	$1,238	$1,289	$1,343	$1,399	$13,574	$1,494	$1,557	$1,623	$1,692	$1,765	$1,840	$1,919	$2,002	$2,089	$2,179	$2,274	$2,374	$22,810	$7,961	$9,066	$10,336	$11,797	$39,159	$13,814	$15,797	$18,081	$20,712	$68,405	$121,137
Total Net Sales	$42,300	$43,992	$45,760	$47,608	$49,540	$51,559	$53,670	$55,877	$58,185	$60,598	$63,123	$65,763	$637,973	$70,238	$73,201	$76,300	$79,543	$82,936	$86,488	$90,205	$94,096	$98,169	$102,433	$106,898	$111,573	$1,072,079	$374,148	$426,093	$485,794	$554,450	$1,840,485	$649,279	$742,482	$849,816	$973,476	$3,215,052	$5,693,452
(Total Cost of Goods Sold)	$3,900	$4,050	$4,207	$4,370	$4,541	$4,719	$4,905	$5,100	$5,303	$5,516	$5,738	$5,970	$58,319	$6,368	$6,628	$6,899	$7,183	$7,481	$7,791	$8,116	$8,456	$8,812	$9,184	$9,573	$9,980	$96,471	$33,394	$37,910	$43,091	$49,041	$163,436	$57,275	$65,330	$74,596	$85,259	$282,460	$496,039
TOTAL GROSS PROFIT	$38,400	$39,942	$41,554	$43,238	$44,999	$46,839	$48,764	$50,777	$52,881	$55,082	$57,385	$59,793	$579,654	$63,871	$66,573	$69,400	$72,359	$75,456	$78,697	$82,089	$85,640	$89,357	$93,250	$97,325	$101,592	$975,608	$340,754	$388,183	$442,703	$505,408	$1,677,049	$592,004	$677,151	$775,220	$888,216	$2,932,592	$5,197,413

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
Product Line 1
Cost of Goods Sold	$1,500 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.	$1,530	$1,561	$1,592	$1,624	$1,656	$1,689	$1,723	$1,757	$1,793	$1,828	$1,865	$20,118	$1,950	$1,989	$2,029	$2,069	$2,111	$2,153	$2,196	$2,240	$2,285	$2,330	$2,377	$2,424	$26,153	$7,757	$8,232	$8,736	$9,271	$33,997	$10,084	$10,702	$11,357	$12,052	$44,194	$57,450
Ingredients	$300 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.	$1,561	$1,592	$1,624	$1,656	$1,689	$1,723	$1,757	$1,793	$1,828	$1,865	$1,950	$19,338	$1,989	$2,029	$2,069	$2,111	$2,153	$2,196	$2,240	$2,285	$2,330	$2,377	$2,424	$2,473	$26,676	$7,913	$8,397	$8,911	$9,456	$34,677	$10,286	$10,916	$11,584	$12,293	$45,078	$58,599
Bottles/caps	$1,650	$1,683	$1,717	$1,751	$1,786	$1,822	$1,858	$1,895	$1,933	$1,972	$2,011	$2,052	$22,130	$2,145	$2,188	$2,232	$2,276	$2,322	$2,368	$2,416	$2,464	$2,513	$2,563	$2,615	$2,667	$28,768	$8,533	$9,056	$9,610	$10,198	$37,397	$11,093	$11,772	$12,492	$13,257	$48,614	$63,195
Labels	$420	$428	$437	$446	$455	$464	$473	$482	$492	$502	$512	$522	$5,633	$546	$557	$568	$579	$591	$603	$615	$627	$640	$652	$666	$679	$7,323	$2,172	$2,305	$2,446	$2,596	$9,519	$2,824	$2,996	$3,180	$3,374	$12,374	$16,086
Cartons	$250	$255	$260	$265	$271	$276	$282	$287	$293	$299	$305	$311	$3,353	$325	$331	$338	$345	$352	$359	$366	$373	$381	$388	$396	$404	$4,359	$1,293	$1,372	$1,456	$1,545	$5,666	$1,681	$1,784	$1,893	$2,009	$7,366	$9,575
Total Inventory Expense	$2,620 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.)	$3,927	$4,006	$4,086	$4,167	$4,251	$4,336	$4,422	$4,511	$4,601	$4,693	$4,835	$20,118	$5,005	$5,105	$5,207	$5,311	$5,417	$5,526	$5,636	$5,749	$5,864	$5,981	$6,101	$6,223	$67,125	$19,911	$21,130	$22,423	$23,795	$87,259	$25,883	$27,467	$29,149	$30,933	$113,432	$147,455
Product Line 2 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$2,400	$2,520	$2,646	$2,778	$2,917	$3,063	$3,216	$3,377	$3,546	$3,723	$3,909	$4,105	$38,201	$4,418	$4,639	$4,871	$5,114	$5,370	$5,638	$5,920	$6,216	$6,527	$6,853	$7,196	$7,556	$70,319	$25,636	$29,677	$34,355	$39,770	$129,439	$47,190	$54,629	$63,240	$73,208	$238,266	$438,589
Ingredients	$300 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.	$2,646	$2,778	$2,917	$3,063	$3,216	$3,377	$3,546	$3,723	$3,909	$4,105	$4,418	$37,999	$4,639	$4,871	$5,114	$5,370	$5,638	$5,920	$6,216	$6,527	$6,853	$7,196	$7,556	$7,934	$73,835	$26,918	$31,161	$36,073	$41,759	$135,911	$49,550	$57,360	$66,401	$76,868	$250,179	$460,518
Bottles/caps	$1,650	$1,733	$1,819	$1,910	$2,006	$2,106	$2,211	$2,322	$2,438	$2,560	$2,688	$2,822	$26,263	$3,037	$3,189	$3,349	$3,516	$3,692	$3,876	$4,070	$4,274	$4,487	$4,712	$4,947	$5,195	$48,344	$17,625	$20,403	$23,619	$27,342	$88,990	$32,443	$37,557	$43,477	$50,330	$163,808	$301,530
Labels	$420	$441	$463	$486	$511	$536	$563	$591	$621	$652	$684	$718	$6,685	$773	$812	$852	$895	$940	$987	$1,036	$1,088	$1,142	$1,199	$1,259	$1,322	$12,306	$4,486	$5,194	$6,012	$6,960	$22,652	$8,258	$9,560	$11,067	$12,811	$41,697	$76,753
Cartons	$250	$263	$276	$289	$304	$319	$335	$352	$369	$388	$407	$428	$3,979	$460	$483	$507	$533	$559	$587	$617	$648	$680	$714	$750	$787	$7,325	$2,670	$3,091	$3,579	$4,143	$13,483	$4,916	$5,690	$6,587	$7,626	$24,819	$45,686
Total Inventory Expense	$2,620	$5,082	$5,336	$5,603	$5,883	$6,177	$6,486	$6,810	$7,151	$7,508	$7,884	$8,386	$38,201	$8,909	$9,355	$9,822	$10,314	$10,829	$11,371	$11,939	$12,536	$13,163	$13,821	$14,512	$15,238	$141,810	$51,700	$59,849	$69,283	$80,204	$261,036	$95,167	$110,168	$127,533	$147,635	$480,503	$884,488
Product Line 3 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Bottled Water	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 4 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 5 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 6 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 7 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 8 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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"
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 10 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
GRAND TOTAL INVENTORY	$5,240	$9,009	$9,342	$9,689	$10,050	$10,428	$10,822	$11,233	$11,662	$12,110	$12,577	$13,220	$125,381	$13,914	$14,460	$15,029	$15,625	$16,247	$16,896	$17,575	$18,285	$19,027	$19,802	$20,613	$21,461	$208,934	$71,611	$80,979	$91,706	$103,999	$348,295	$121,050	$137,635	$156,682	$178,568	$593,935	$1,031,943

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
Building maintenance	$5,000 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.
Water/sewer	$2,000	Oct	2019	1	$0
Gas	$14,400	Oct	2019	1	$0
Electricity	$6,000	Oct	2019	1	$0
Trash removal	$4,800	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.
2 NAB Mixers	$57,000	Oct	2019	5	$5,000
2 AccutekAccuSnap Capper	$19,200	Oct	2019	5	$4,000
4 vehicles	$40,000	Oct	2019	5	$5,000
Labelling Machinery	$5,400	Oct	2019	3	$1,500
Printers	$6,600	Oct	2019	5	$2,000
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
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	Jan	2017	1	$0
Computer Hardware/Software Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.	Oct	$2,019
3 Computers	$3,600	Oct	2019	5	$1,200
Graphic software	$750	Oct	2019	3	$150
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
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	Jan	2017	1	$0
Telecommunications Author: Telecommunications includes phone systems, fax machines, etc.	Oct	2019
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	Jan	2017	1	$0
Land Author: Land purchases are not depreciable.	Oct	$2,019
Item Name (change name here)	$0	Oct	2019	Land is a non-depreciable asset
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
Item Name (change name here)	$0	Oct	2019
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
# Salaried Employees	1.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".	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	$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	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$55,002	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$9,167	$110,004	$41,252	$41,252	$41,252	$41,252	$165,008	$41,252	$41,252	$41,252	$41,252	$165,008	$165,008
Benefits (across all employees)	$250 Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$3,000	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$260	$3,120	$811	$811	$811	$811	$3,245	$844	$844	$844	$844	$3,375	$3,510
Payroll Taxes (across all employees)	$0	$0	$0	$0	$0	$0	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$8,250	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$1,375	$16,501	$6,188	$6,188	$6,188	$6,188	$24,751	$6,188	$6,188	$6,188	$6,188	$24,751	$24,751
Total Costs	$250	$250	$250	$250	$250	$250	$10,792	$10,792	$10,792	$10,792	$10,792	$10,792	$66,252	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$10,802	$129,625	$48,251	$48,251	$48,251	$48,251	$193,004	$48,283	$48,283	$48,283	$48,283	$193,134	$193,269
Administrative/Support
# Salaried Employees	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
Sales/Marketing
# Salaried Employees	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	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
Operations/Production
# Salaried Employees	5.0	5.0	5.0	5.0	5.0	5.0	5.0	5.0	5.0	5.0	5.0	5.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	10.0	10.0	10.0	10.0	10.0	10.0	10.0	10.0
Avg Salary per employee	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$1,700	$20,400	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$1,751	$21,012	$5,411	$5,411	$5,411	$5,411	$21,642	$5,573	$5,573	$5,573	$5,573	$22,292	$22,960
Benefits (across all employees)	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$15,000	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$2,600	$31,200	$8,112	$8,112	$8,112	$8,112	$32,448	$8,436	$8,436	$8,436	$8,436	$33,746	$35,096
Payroll Taxes (across all employees)	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$1,275	$15,300	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$2,627	$31,518	$8,116	$8,116	$8,116	$8,116	$32,464	$8,359	$8,359	$8,359	$8,359	$33,437	$34,441
Total Costs	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$11,025	$132,300	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$22,737	$272,838	$70,334	$70,334	$70,334	$70,334	$281,335	$72,525	$72,525	$72,525	$72,525	$290,100	$299,140
Other
# Salaried Employees	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Part-Time / Hourly Employees
# Part-Time Employees	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!	1	1	1	1	1	1	1	1
Avg. Hours per Hourly Employee	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	240	240	240	240	240	240	240	240	960
Avg Hourly Rate	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.45	$15.91	$15.91	$15.91	$15.91	$16.39	$16.39	$16.39	$16.39	$16.88
Calculated Wages Per Hourly Employee	$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,400	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$14,832	$3,819	$3,819	$3,819	$3,819	$15,277	$3,934	$3,934	$3,934	$3,934	$15,735	$16,207
Wages	$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,400	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$1,236	$14,832	$3,819	$3,819	$3,819	$3,819	$15,277	$3,934	$3,934	$3,934	$3,934	$15,735	$16,207
Benefits (across all employees)	$208	$208	$208	$208	$208	$208	$208	$208	$208	$208	$208	$208	$2,500	$217	$217	$217	$217	$217	$217	$217	$217	$217	$217	$217	$217	$2,600	$676	$676	$676	$676	$2,704	$703	$703	$703	$703	$2,812	$2,925
Payroll Taxes (across all employees)	$180	$180	$180	$180	$180	$180	$180	$180	$180	$180	$180	$180	$2,160	$185	$185	$185	$185	$185	$185	$185	$185	$185	$185	$185	$185	$2,225	$573	$573	$573	$573	$2,292	$590	$590	$590	$590	$2,360	$2,431
Total Costs	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$1,588	$19,060	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$1,638	$19,657	$5,068	$5,068	$5,068	$5,068	$20,273	$5,227	$5,227	$5,227	$5,227	$20,908	$21,563
TOTAL
# Full Time Employees	$6	$6	$6	$6	$6	$6	$6	$6	$6	$6	$6	$6	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11	$11
# 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	$9,700	$9,700	$9,700	$9,700	$9,700	$9,700	$18,867	$18,867	$18,867	$18,867	$18,867	$18,867	$171,402	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$334,956	$99,177	$99,177	$99,177	$99,177	$396,709	$100,915	$100,915	$100,915	$100,915	$403,660	$410,819
Benefits	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$20,500	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$36,920	$9,599	$9,599	$9,599	$9,599	$38,397	$9,983	$9,983	$9,983	$9,983	$39,933	$41,530
Payroll Taxes	$1,455	$1,455	$1,455	$1,455	$1,455	$1,455	$2,830	$2,830	$2,830	$2,830	$2,830	$2,830	$25,710	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$50,243	$14,877	$14,877	$14,877	$14,877	$59,506	$15,137	$15,137	$15,137	$15,137	$60,549	$61,623
GRAND TOTAL COSTS	$12,863	$12,863	$12,863	$12,863	$12,863	$12,863	$23,405	$23,405	$23,405	$23,405	$23,405	$23,405	$217,612	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$35,177	$422,119	$123,653	$123,653	$123,653	$123,653	$494,612	$126,035	$126,035	$126,035	$126,035	$504,141	$513,972

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	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$9,000
Social Media Specialists	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400	$600	$600	$600	$600	$2,400	$600	$600	$600	$600	$2,400	$2,400
SEO Specialist	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Signs/Billboards	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Merchandising Displays	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Sampling/Premiums	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$450	$450	$450	$450	$1,800	$450	$450	$450	$450	$1,800	$1,800
Media Advertising
Print (newspaper, etc.)	$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,400	$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,400	$3,600	$3,600	$3,600	$3,600	$14,400	$3,600	$3,600	$3,600	$3,600	$14,400	$14,400
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.	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$9,000
Other Media	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Phone Directories	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Maintenance and Hosting	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Trade Shows
Fees and Setup	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Informal Marketing / Networking
Memberships/Meetings	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Entertainment	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$36,600	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$36,600	$9,150	$9,150	$9,150	$9,150	$36,600	$9,150	$9,150	$9,150	$9,150	$36,600	$36,600

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	$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.	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
Ingredients	$600	Oct	2019
Labels	$840	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Investment Source Name	$0	Oct	2019
Total Capital Investments	$45,240
Loans Author: Unlike equity capital inventments, lenders are typically not interested in purchasing shares in your company--they simply want to be paid back on a fixed schedule, with interest. Lenders can include banks and family members.
Friends and Family	$20,000	Oct	2019	24 Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.	5.00% Author: Enter the loan's annual interest rate.
Bank loan	$50,000	Oct	2019	48	2.50% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2019	12	0.00% Author: Enter the loan's annual interest rate.
Total Loans	$70,000
TOTAL INVESTMENTS AND LOANS	$115,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	$45,000	$46,800	$48,681	$50,647	$52,702	$54,850	$57,095	$59,443	$61,899	$64,466	$67,152	$69,961	$678,695	$74,722	$77,872.91	$81,170	$84,620	$88,230	$92,008	$95,963	$100,102	$104,435	$108,972	$113,721	$118,694	$1,140,510	$398,030	$453,290	$516,803	$589,840	$1,957,963	$690,722	$789,874	$904,060	$1,035,613	$3,420,269	$6,056,864
(Commissions)	$1,800	$1,872	$1,947	$2,026	$2,108	$2,194	$2,284	$2,378	$2,476	$2,579	$2,686	$2,798	$27,148	$2,989	$3,114.92	$3,247	$3,385	$3,529	$3,680	$3,839	$4,004	$4,177	$4,359	$4,549	$4,748	$45,620	$15,921	$18,132	$20,672	$23,594	$78,319	$27,629	$31,595	$36,162	$41,425	$136,811	$242,275
(Returns and allowances)	$900	$936	$974	$1,013	$1,054	$1,097	$1,142	$1,189	$1,238	$1,289	$1,343	$1,399	$13,574	$1,494	$1,557.46	$1,623	$1,692	$1,765	$1,840	$1,919	$2,002	$2,089	$2,179	$2,274	$2,374	$22,810	$7,961	$9,066	$10,336	$11,797	$39,159	$13,814	$15,797	$18,081	$20,712	$68,405	$121,137
Net Sales	$42,300	$43,992	$45,760	$47,608	$49,540	$51,559	$53,670	$55,877	$58,185	$60,598	$63,123	$65,763	$637,973	$70,238	$73,200.54	$76,300	$79,543	$82,936	$86,488	$90,205	$94,096	$98,169	$102,433	$106,898	$111,573	$1,072,079	$374,148	$426,093	$485,794	$554,450	$1,840,485	$649,279	$742,482	$849,816	$973,476	$3,215,052	$5,693,452
(Cost of Goods)	$3,900	$4,050	$4,207	$4,370	$4,541	$4,719	$4,905	$5,100	$5,303	$5,516	$5,738	$5,970	$58,319	$6,368	$6,627.62	$6,899	$7,183	$7,481	$7,791	$8,116	$8,456	$8,812	$9,184	$9,573	$9,980	$96,471	$33,394	$37,910	$43,091	$49,041	$163,436	$57,275	$65,330	$74,596	$85,259	$282,460	$496,039
GROSS PROFIT	$38,400	$39,942	$41,554	$43,238	$44,999	$46,839	$48,764	$50,777	$52,881	$55,082	$57,385	$59,793	$579,654	$63,871	$66,572.92	$69,400	$72,359	$75,456	$78,697	$82,089	$85,640	$89,357	$93,250	$97,325	$101,592	$975,608	$340,754	$388,183	$442,703	$505,408	$1,677,049	$592,004	$677,151	$775,220	$888,216	$2,932,592	$5,197,413
EXPENSES - General and Administrative
Salaries and wages	$9,700	$9,700	$9,700	$9,700	$9,700	$9,700	$18,867	$18,867	$18,867	$18,867	$18,867	$18,867	$171,402	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$27,913	$334,956	$99,177	$99,177	$99,177	$99,177	$396,709	$100,915	$100,915	$100,915	$100,915	$403,660	$410,819
Employee benefits	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$1,708	$20,500	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$3,077	$36,920	$9,599	$9,599	$9,599	$9,599	$38,397	$9,983	$9,983	$9,983	$9,983	$39,933	$41,530
Payroll taxes	$1,455	$1,455	$1,455	$1,455	$1,455	$1,455	$2,830	$2,830	$2,830	$2,830	$2,830	$2,830	$25,710	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$4,187	$50,243	$14,877	$14,877	$14,877	$14,877	$59,506	$15,137	$15,137	$15,137	$15,137	$60,549	$61,623
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,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$36,600	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$3,050	$36,600	$9,150	$9,150	$9,150	$9,150	$36,600	$9,150	$9,150	$9,150	$9,150	$36,600	$36,600
Rent	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Equipment rental	$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	$83	$83	$83	$83	$83	$83	$83	$83	$83	$83	$83	$83	$1,000	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$5,000	$1,250	$1,250	$1,250	$1,250	$5,000	$1,250	$1,250	$1,250	$1,250	$5,000	$5,000
Depreciation	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$12,940	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$1,078	$12,940	$3,235	$3,235	$3,235	$3,235	$12,940	$2,860	$2,860	$2,860	$2,860	$11,440	$11,440
Insurance	$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
Telephone service	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$9,000
Utilities	$118	$118	$118	$118	$118	$118	$118	$118	$118	$118	$118	$118	$1,417	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$1,833	$22,000	$5,500	$5,500	$5,500	$5,500	$22,000	$5,500	$5,500	$5,500	$5,500	$22,000	$22,000
Office supplies	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$10,000	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$10,000	$2,500	$2,500	$2,500	$2,500	$10,000	$2,500	$2,500	$2,500	$2,500	$10,000	$10,000
Postage and shipping	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$10,000	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$10,000	$2,500	$2,500	$2,500	$2,500	$10,000	$2,500	$2,500	$2,500	$2,500	$10,000	$10,000
Travel	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Entertainment	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Interest on loans	$188	$182	$177	$171	$166	$160	$155	$149	$144	$138	$133	$127	$1,891	$122	$116	$111	$105	$99	$94	$88	$82	$76	$71	$65	$59	$1,088	$154	$134	$114	$94	$496	$74	$54	$34	$14	$176	$0
Trash removal	$83	$83	$83	$83	$83	$83	$83	$83	$83	$83	$83	$83	$1,000	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,800	$1,200	$1,200	$1,200	$1,200	$4,800	$1,200	$1,200	$1,200	$1,200	$4,800	$4,800
Other (change title here)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
TOTAL EXPENSES	$22,272	$22,267	$22,261	$22,256	$22,251	$22,245	$32,782	$32,776	$32,771	$32,765	$32,760	$32,754	$330,160	$46,052	$46,046	$46,041	$46,035	$46,029	$46,024	$46,018	$46,012	$46,006	$46,001	$45,995	$45,989	$552,247	$156,067	$156,047	$156,027	$156,007	$624,148	$157,995	$157,975	$157,954	$157,934	$631,857	$641,512
Net income before taxes and interest	$16,128	$17,675	$19,292	$20,982	$22,748	$24,594	$15,982	$18,000	$20,111	$22,317	$24,625	$27,039	$249,494	$17,819	$20,527	$23,360	$26,324	$29,426	$32,673	$36,071	$39,628	$43,351	$47,249	$51,330	$55,603	$423,361	$184,688	$232,136	$286,676	$349,401	$1,052,901	$434,009	$519,177	$617,266	$730,283	$2,300,735	$4,555,901
Interest Income	$0	$0	$7	$18	$30	$44	$51	$58	$68	$79	$91	$106	$552	$111	$119	$129	$142	$156	$173	$193	$215	$239	$267	$298	$331	$2,373	$1,338	$1,785	$2,352	$3,057	$8,531	$3,939	$5,016	$6,310	$7,853	$23,118	$70,868
Provision for taxes on income	$4,032	$4,419	$4,825	$5,250	$5,695	$6,160	$4,008	$4,515	$5,045	$5,599	$6,179	$6,786	$62,374	$4,483	$5,161	$5,872	$6,616	$7,396	$8,212	$9,066	$9,961	$10,898	$11,879	$12,907	$13,984	$105,840	$46,506	$58,480	$72,257	$88,115	$265,358	$109,487	$131,048	$155,894	$184,534	$580,963	$1,156,692
NET PROFIT	$12,096	$13,256	$14,474	$15,750	$17,084	$18,479	$12,025	$13,544	$15,134	$16,797	$18,537	$20,359	$187,673	$13,448	$15,484	$17,617	$19,849	$22,187	$24,635	$27,198	$29,882	$32,693	$35,637	$38,721	$41,951	$319,894	$139,519	$175,441	$216,771	$264,344	$796,074	$328,461	$393,145	$467,682	$553,602	$1,742,889	$3,470,077

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	$20,250	$21,060	$21,906	$22,791	$23,716	$24,682	$25,693	$26,749	$27,854	$29,010	$30,218	$31,482	$305,413	$33,625	$35,043	$36,526	$38,079	$39,703	$41,404	$43,183	$45,046	$46,996	$49,037	$51,175	$53,412	$513,230	$179,114	$203,981	$232,561	$265,428	$881,083	$310,825	$355,443	$406,827	$466,026	$1,539,121	$2,725,589
Collections	$0	$24,750	$25,740	$26,775	$27,856	$28,986	$30,167	$31,402	$32,694	$34,044	$35,456	$36,933	$334,804	$38,478	$41,097	$42,830	$44,643	$46,541	$48,526	$50,605	$52,780	$55,056	$57,439	$59,934	$62,547	$600,477	$211,226	$239,179	$272,597	$311,022	$1,034,024	$361,402	$416,253	$476,299	$545,469	$1,799,423	$3,243,531
Total Cash from Sales	$20,250	$45,810	$47,646	$49,566	$51,572	$53,668	$55,860	$58,152	$60,548	$63,054	$65,675	$68,416	$640,217	$72,103	$76,140	$79,357	$82,722	$86,244	$89,930	$93,788	$97,826	$102,052	$106,477	$111,109	$115,959	$1,113,707	$390,340	$443,159	$505,159	$576,450	$1,915,107	$672,227	$771,696	$883,126	$1,011,495	$3,338,544	$5,969,120
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	$7	$18	$30	$44	$51	$58	$68	$79	$91	$106	$552	$111	$119	$129	$142	$156	$173	$193	$215	$239	$267	$298	$331	$2,373	$1,338	$1,785	$2,352	$3,057	$8,531	$3,939	$5,016	$6,310	$7,853	$23,118	$70,868
Loan Proceeds	$70,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$70,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Equity Capital Investments	$45,240	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$45,240	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Cash from Financing	$115,240	$0	$7	$18	$30	$44	$51	$58	$68	$79	$91	$106	$115,792	$111	$119	$129	$142	$156	$173	$193	$215	$239	$267	$298	$331	$2,373	$1,338	$1,785	$2,352	$3,057	$8,531	$3,939	$5,016	$6,310	$7,853	$23,118	$70,868
Other Cash Receipts	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
TOTAL CASH RECEIPTS	$135,490	$45,810	$47,653	$49,584	$51,602	$53,713	$55,911	$58,210	$60,616	$63,133	$65,766	$68,521	$756,009	$72,214	$76,259	$79,486	$82,864	$86,401	$90,104	$93,981	$98,040	$102,292	$106,744	$111,406	$116,290	$1,116,080	$391,677	$444,944	$507,510	$579,507	$1,923,639	$676,166	$776,712	$889,435	$1,019,347	$3,361,661	$6,039,988
CASH DISBURSEMENTS
Inventory	$5,240	$9,009	$9,342	$9,689	$10,050	$10,428	$10,822	$11,233	$11,662	$12,110	$12,577	$13,220	$125,381	$13,914	$14,460	$15,029	$15,625	$16,247	$16,896	$17,575	$18,285	$19,027	$19,802	$20,613	$21,461	$208,934	$71,611	$80,979	$91,706	$103,999	$348,295	$121,050	$137,635	$156,682	$178,568	$593,935	$1,031,943
Operating Expenses	$21,006	$21,006	$21,006	$21,006	$21,006	$21,006	$31,548	$31,548	$31,548	$31,548	$31,548	$31,548	$315,329	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$44,852	$538,219	$152,678	$152,678	$152,678	$152,678	$610,712	$155,060	$155,060	$155,060	$155,060	$620,241	$630,072
Commissions/Returns & Allowances	$2,700	$2,808	$2,921	$3,039	$3,162	$3,291	$3,426	$3,567	$3,714	$3,868	$4,029	$4,198	$40,722	$4,483	$4,672	$4,870	$5,077	$5,294	$5,520	$5,758	$6,006	$6,266	$6,538	$6,823	$7,122	$68,431	$23,882	$27,197	$31,008	$35,390	$117,478	$41,443	$47,392	$54,244	$62,137	$205,216	$363,412
Capital Purchases	$107,750	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$107,750	$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,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$23,678	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$23,678	$3,287	$3,287	$3,287	$3,287	$13,148	$3,287	$3,287	$3,287	$3,287	$13,148	$0
Income Tax Payments	$27,431	$493	$493	$493	$493	$493	$493	$493	$493	$493	$493	$493	$26,938	$493	$493	$493	$493	$493	$493	$493	$493	$493	$493	$493	$493	$0	$1,480	$1,480	$1,480	$1,480	$5,919	$1,480	$1,480	$1,480	$1,480	$5,919	$5,919
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	$166,100	$35,290	$35,735	$36,200	$36,685	$37,192	$48,262	$48,814	$49,391	$49,992	$50,621	$51,433	$645,716	$65,715	$66,450	$67,218	$68,020	$68,858	$69,735	$70,651	$71,609	$72,611	$73,659	$74,754	$75,900	$845,181	$252,938	$265,621	$280,159	$296,834	$1,095,552	$322,321	$344,855	$370,752	$400,532	$1,438,460	$2,031,346
NET CASH FLOW	-$30,610	$10,520	$11,918	$13,384	$14,917	$16,521	$7,648	$9,396	$11,225	$13,140	$15,145	$17,089	$110,293	$6,499	$9,809	$12,268	$14,844	$17,542	$20,369	$23,329	$26,431	$29,680	$33,085	$36,652	$40,390	$270,899	$138,740	$179,323	$227,351	$282,672	$828,086	$353,845	$431,858	$518,683	$618,815	$1,923,201	$4,008,641
Opening Cash Balance	$16,500	-$14,110	-$3,590	$8,328	$21,712	$36,628	$53,149	$60,798	$70,194	$81,419	$94,560	$109,705	$126,793	$133,292	$143,101	$155,369	$170,214	$187,756	$208,124	$231,454	$257,885	$287,565	$320,650	$357,302	$397,692	$536,432	$715,755	$943,106	$1,225,779	$1,579,624	$2,011,482	$2,530,165	$3,148,980
Cash Receipts	$135,490	$45,810	$47,653	$49,584	$51,602	$53,713	$55,911	$58,210	$60,616	$63,133	$65,766	$68,521	$72,214	$76,259	$79,486	$82,864	$86,401	$90,104	$93,981	$98,040	$102,292	$106,744	$111,406	$116,290	$391,677	$444,944	$507,510	$579,507	$676,166	$776,712	$889,435	$1,019,347	$6,039,988
Cash Disbursements	$166,100	$35,290	$35,735	$36,200	$36,685	$37,192	$48,262	$48,814	$49,391	$49,992	$50,621	$51,433	$65,715	$66,450	$67,218	$68,020	$68,858	$69,735	$70,651	$71,609	$72,611	$73,659	$74,754	$75,900	$252,938	$265,621	$280,159	$296,834	$322,321	$344,855	$370,752	$400,532	$2,031,346
ENDING CASH BALANCE	-$14,110	-$3,590	$8,328	$21,712	$36,628	$53,149	$60,798	$70,194	$81,419	$94,560	$109,705	$126,793	$126,793	$133,292	$143,101	$155,369	$170,214	$187,756	$208,124	$231,454	$257,885	$287,565	$320,650	$357,302	$397,692	$397,692	$536,432	$715,755	$943,106	$1,225,779	$1,225,779	$1,579,624	$2,011,482	$2,530,165	$3,148,980	$3,148,980	$7,157,621

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
Frizzy Bottles	Frizzy Bottles	Frizzy Bottles	Frizzy Bottles	Frizzy Bottles	Frizzy Bottles	Frizzy Bottles	Frizzy Bottles
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	$8,328	Cash	$53,149	Cash	$81,419	Cash	$126,793	Cash	$397,692	Cash	$1,225,779	Cash	$3,148,980	Cash	$7,157,621
Accounts Receivable	$26,775	Accounts Receivable	$30,167	Accounts Receivable	$34,044	Accounts Receivable	$38,478	Accounts Receivable	$65,282	Accounts Receivable	$108,137	Accounts Receivable	$189,862	Accounts Receivable	$277,606
Inventory	$11,434	Inventory	$27,971	Inventory	$46,378	Inventory	$67,062	Inventory	$179,525	Inventory	$364,383	Inventory	$675,858	Inventory	$1,211,762
Other Current Assets	$1,000	Other Current Assets	$1,000	Other Current Assets	$1,000	Other Current Assets	$1,000	Other Current Assets	$1,000	Other Current Assets	$1,000	Other Current Assets	$1,000	Other Current Assets	$1,000
Total Current Assets	$47,537	Total Current Assets	$112,287	Total Current Assets	$162,842	Total Current Assets	$233,333	Total Current Assets	$643,499	Total Current Assets	$1,699,299	Total Current Assets	$4,015,700	Total Current Assets	$8,647,990
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	$32,200	Facilities	$32,200	Facilities	$32,200	Facilities	$32,200	Facilities	$32,200	Facilities	$32,200	Facilities	$32,200	Facilities	$32,200
Equipment	$71,200	Equipment	$71,200	Equipment	$71,200	Equipment	$71,200	Equipment	$71,200	Equipment	$71,200	Equipment	$71,200	Equipment	$71,200
Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350	Computers & Telecommunications	$4,350
(Less Accumlated Depreciation)	$3,235	(Less Accumlated Depreciation)	$6,470	(Less Accumlated Depreciation)	$9,705	(Less Accumlated Depreciation)	$12,940	(Less Accumlated Depreciation)	$25,880	(Less Accumlated Depreciation)	$38,820	(Less Accumlated Depreciation)	$50,260	(Less Accumlated Depreciation)	$61,700
Total Fixed Assets	$104,515	Total Fixed Assets	$101,280	Total Fixed Assets	$98,045	Total Fixed Assets	$94,810	Total Fixed Assets	$81,870	Total Fixed Assets	$68,930	Total Fixed Assets	$57,490	Total Fixed Assets	$46,050
Other Assets	$500	Other Assets	$500	Other Assets	$500	Other Assets	$500	Other Assets	$500	Other Assets	$500	Other Assets	$500	Other Assets	$500
TOTAL ASSETS	$152,552	TOTAL ASSETS	$214,067	TOTAL ASSETS	$261,387	TOTAL ASSETS	$328,643	TOTAL ASSETS	$725,869	TOTAL ASSETS	$1,768,729	TOTAL ASSETS	$4,073,690	TOTAL ASSETS	$8,694,540
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	$21,984 Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year	Short-Term Notes Payable	$22,184	Short-Term Notes Payable	$22,386	Short-Term Notes Payable	$22,590	Short-Term Notes Payable	$12,652	Short-Term Notes Payable	$12,972	Short-Term Notes Payable	$0	Short-Term Notes Payable	$0
Income Taxes Due	-$15,142 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	$483	Income Taxes Due	$12,570	Income Taxes Due	$35,436	Income Taxes Due	$141,276	Income Taxes Due	$400,715	Income Taxes Due	$975,759	Income Taxes Due	$2,126,531
Other Current Liabilities	$0	Other Current Liabilities	$0	Other Current Liabilities	$0	Other Current Liabilities	$0	Other Current Liabilities	$0	Other Current Liabilities	$0	Other Current Liabilities	$0	Other Current Liabilities	$0
Total Current Liabilities	$6,842	Total Current Liabilities	$22,666	Total Current Liabilities	$34,956	Total Current Liabilities	$58,026	Total Current Liabilities	$153,928	Total Current Liabilities	$413,687	Total Current Liabilities	$975,759	Total Current Liabilities	$2,126,531
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	$42,643	Long-Term Notes Payable	$37,021	Long-Term Notes Payable	$31,349	Long-Term Notes Payable	$25,624	Long-Term Notes Payable	$12,972	Long-Term Notes Payable	$0	Long-Term Notes Payable	$0	Long-Term Notes Payable	$0
Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0	Other Long-Term Liabilities	$0
Total Long-Term Liabilities	$42,643	Total Long-Term Liabilities	$37,021	Total Long-Term Liabilities	$31,349	Total Long-Term Liabilities	$25,624	Total Long-Term Liabilities	$12,972	Total Long-Term Liabilities	$0	Total Long-Term Liabilities	$0	Total Long-Term Liabilities	$0
NET WORTH	NET WORTH	NET WORTH	NET WORTH	NET WORTH	NET WORTH	NET WORTH	NET WORTH
Paid-In Capital	$61,740	Paid-In Capital	$61,740	Paid-In Capital	$61,740	Paid-In Capital	$61,740	Paid-In Capital	$61,740	Paid-In Capital	$61,740	Paid-In Capital	$61,740	Paid-In Capital	$61,740
Retained Earnings	$41,326	Retained Earnings	$92,639	Retained Earnings	$133,342	Retained Earnings	$183,253	Retained Earnings	$497,228	Retained Earnings	$1,293,302	Retained Earnings	$3,036,192	Retained Earnings	$6,506,268
Total Net Worth	$103,066	Total Net Worth	$154,379	Total Net Worth	$195,082	Total Net Worth	$244,993	Total Net Worth	$558,968	Total Net Worth	$1,355,042	Total Net Worth	$3,097,932	Total Net Worth	$6,568,008
TOTAL LIABILITIES AND NET WORTH	$152,552	TOTAL LIABILITIES AND NET WORTH	$214,067	TOTAL LIABILITIES AND NET WORTH	$261,387	TOTAL LIABILITIES AND NET WORTH	$328,643	TOTAL LIABILITIES AND NET WORTH	$725,869	TOTAL LIABILITIES AND NET WORTH	$1,768,729	TOTAL LIABILITIES AND NET WORTH	$4,073,690	TOTAL LIABILITIES AND NET WORTH	$8,694,540

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	$26,100 Author: This is the amount of sales you will need to make each month to break even.
November	$26,090
December	$26,080
January	$26,070
February	$26,059
March	$26,049
April	$38,382
May	$38,371
June	$38,359
July	$38,347
August	$38,335
September	$38,324
Monthly Average	$32,214
Year 2 (2020-2021)
October	$53,875
November	$53,862
December	$53,848
January	$53,835
February	$53,822
March	$53,809
April	$53,795
May	$53,782
June	$53,769
July	$53,757
August	$53,744
September	$53,731
Monthly Average	$53,802
Year 3 (2021-2022)
1st Quarter	$182,299
2nd Quarter	$182,219
3rd Quarter	$182,143
4th Quarter	$182,069
Quarterly Average	$182,183
Year 4 (2022-2023)
1st Quarter	$184,341
2nd Quarter	$184,272
3rd Quarter	$184,206
4th Quarter	$184,142
Quarterly Average	$184,240
Year 5 (2023-2024)
Annual Average	$747,593

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	$40,694	6.95	5.28	3.24	0.48	52%	40%	35%	$132,052.14
2nd Quarter	$89,621	4.95	3.72	1.66	0.39	44%	46%	32%	$148,706.31
3rd Quarter	$127,886	4.66	3.33	1.31	0.34	28%	32%	21%	$167,730.93
4th Quarter	$175,308	4.02	2.87	1.08	0.34	30%	39%	23%	$189,484.06
Year 2 (2020-2021)	$489,570	4.18	3.01	2.19	0.30	76%	39%	58%	$1,072,079.48
Year 3 (2021-2022)	$1,285,612	4.11	3.23	1.43	0.31	78%	57%	60%	$1,840,485.14
Year 4 (2022-2023)	$3,039,942	4.12	3.42	1.06	0.31	74%	72%	56%	$3,215,052.46
Year 5 (2023-2024)	$6,521,458	4.07	3.50	0.87	0.32	69%	80%	52%	$5,693,452.37

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2019-2020) Gross Sales October November December January February March April May June July August September 45000 46800 48681 50646.87 52701.669900000001 54849.658923000003 57095.305507710007 59443.297694426714 61898.554028705876 64466.23500869015 67151.755103244621 69960.795369409214 Gross Profit October November December January February March April May June July August September 38400 39942 41553.54 43237.945800000001 44998.706466000003 46839.482432820005 48764.114010851408 50776.630316912197 52881.258650386371 55082.434336886836 57384.811062791945 59793.27172517353 Net Profit October November December January February March April May June July August September 12095.845249999998 13256.376068683592 14474.276139410322 15749.996257047535 17083.953620091783 18478.937911259862 12024.749570948836 13544.11745340476 15133.725601945014 16796.954042490273 18537.349155826785 20358.534873415352

NSYr1

Year 1: Net Sales (2019-2020) Product Line 1 October November December January February March April May June July August September 14100 14382 14669.64 14963.032800000001 15262.293455999999 15567.53932512 15878.890111622401 16196.467913854851 16520.397272131948 16850.805217574587 17187.82132192608 17531.577748364602 Product Line 2 October November December January February March April May June July August September 28200 29610 31090.5 32645.024999999998 34277.276250000003 35991.140062500002 37790.697065625005 39680.231918906262 41664.243514851572 43747.455690594157 45934.828475123868 48231.569898880065 Product Line 3 October November December January February March April May June July August September 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 4 October November December January February March April May June July August September 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 -30610.28487018976 10520.215129810233 11918.099375968093 13383.566561698062 14916.729013995326 16520.840793219606 7648.4809910717231 9396.1094857623029 11225.434800183662 13140.400592644022 15145.144857804611 17088.5697143172 Ending Cash Balance -14110.28487018976 -3590.0697403795275 8328.0296355885657 21711.596197286628 36628.325211281954 53149.166004501552 60797.646995573275 70193.756481335586 81419.191281519248 94559.591874163278 109704.73673196789 126793.30644628507

2ndYrCshFlw

Year 2: Cash Flow (2020-2021) Net Cash Flow October November December January February March April May June July August September 6498.8593361502426 9808.9550966368406 12268.267508616336 14844.15369555018 17542.276368324208 20368.57802202717 23329.294858107605 26430.9714012974 29680.475846013607 33085.016168685208 36652.157044272899 40389.837607163267 Ending Cash Balance October November December January February March April May June July August September 133292.1657824353 143101.12087907211 155369.38838768846 170213.54208323863 187755.81845156284 208124.39647359002 231453.69133169763 257884.66273299506 287565.13857900869 320650.15474769392 357302.31179196684 397692.14939913014

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 678695.14153518667 1140510.0808444396 1957962.9111407935 3420268.5792942313 6056864.2253915025 Gross Profit 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 579654.19480182242 975608.16440693557 1677048.7197521615 2932592.133875201 5197413.1972626904 Net Profit 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 187672.88533396204 319893.95294906665 796074.164325463 1742889.3944568555 3470076.6326921359

NS5Yr

5-Year Net Sales

Product Line 1 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 189110.46516659445 245833.74060627553 319571.0399592889 415425.68293839204 540031.71897808614 Product Line 2 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 448862.96787648089 826245.73538749758 1520914.0965130567 2799626.7815981852 5153420.652889926 Product Line 3 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 0 0 0 0 0 Product Line 4 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 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

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"

0.00

1.00

0.55

Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet

$40,694

$89,621

$127,886

$175,308

$489,570

$1,285,612

$3,039,942

$6,521,458

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

Adjust index to 1-12

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	Building maintenance	$5,000.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ 417	-	- Sure Product Consulting: If "today's" month is one in this asset is dep'd over,	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Facilities	Water/sewer	$2,000.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ 167	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Facilities	Gas	$14,400.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ 1,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Facilities	Electricity	$6,000.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ 500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Facilities	Trash removal	$4,800.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ 400	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
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	2 AccutekAccuSnap Capper	$19,200.00	$4,000.00	5	60	Oct	2019	1	60	Aug-20	$ 253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253	253
12	Equip	4 vehicles	$40,000.00	$5,000.00	5	60	Oct	2019	1	60	Aug-20	$ 583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583	583
13	Equip	Labelling Machinery	$5,400.00	$1,500.00	3	36	Oct	2019	1	36	Aug-18	$ 108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	108	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Equip	Printers	$6,600.00	$2,000.00	5	60	Oct	2019	1	60	Aug-20	$ 77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77	77
15	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
21	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
22	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
23	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
24	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
25	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
26	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
27	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
28	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
29	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	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	3 Computers	$3,600.00	$1,200.00	5	60	Oct	2019	1	60	Aug-20	$ 40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40
32	Comp	Graphic software	$750.00	$150.00	3	36	Oct	2019	1	36	Aug-18	$ 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	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
33	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
34	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
35	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
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	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
38	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
39	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
40	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
41	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
42	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
43	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
44	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	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	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
47	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
48	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
49	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	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	Oct	2019	1	12	Aug-16
53	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16
54	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16
55	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16
56	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16
57	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16
58	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	1	12	Aug-16
59	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2019	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,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 1,078	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953	$ 953
Land	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Facilities	32,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Equip	71,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Comp	4,350	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL Author: This goes into Cash Flow statement.	Author: This goes into Cash Flow statement.	107,750	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
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"	32,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-

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	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	Investment Source Name	$0	Oct	2019	1	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
8	Investment Source Name	$0	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	1	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
TOTAL:	$45,240	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Loan Payback Schedule (Principle + Interest)	Loan Payback Schedule (Principle + Interest)	Loan Payback Schedule (Principle + Interest)	Loan Payback Schedule (Principle + Interest)	Loan Payback Schedule (Principle + Interest)	Loan Payback Schedule (Principle + Interest)	Loan Payback Schedule (Principle + Interest)
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	5.00%	24	Oct	2019	1	24	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	877.43	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
2	Bank loan	$50,000	2.50%	48	Oct	2019	1	48	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	1,095.70	- 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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,973	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$1,096	$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.05	$24.00	Oct	$2,019.00	1	24	877.43	83.33	80.02	76.70	73.37	70.02	66.65	63.27	59.88	56.47	53.05	49.62	46.17	42.71	39.23	35.74	32.23	28.71	25.17	21.62	18.05	14.47	10.88	7.27	3.64	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Bank loan	$50,000	2.50%	48	Oct	2019	1	48	1,095.70	104.17	102.10	100.03	97.96	95.88	93.80	91.71	89.62	87.52	85.42	83.31	81.21	79.09	76.97	74.85	72.73	70.59	68.46	66.32	64.17	62.02	59.87	57.71	55.55	53.38	51.21	49.04	46.86	44.67	42.48	40.29	38.09	35.88	33.68	31.46	29.25	27.03	24.80	22.57	20.33	18.09	15.85	13.60	11.34	9.08	6.82	4.55	2.28	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0	0.00%	12	Oct	2019	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL:	$188	$182	$177	$171	$166	$160	$155	$149	$144	$138	$133	$127	$122	$116	$111	$105	$99	$94	$88	$82	$76	$71	$65	$59	$53	$51	$49	$47	$45	$42	$40	$38	$36	$34	$31	$29	$27	$25	$23	$20	$18	$16	$14	$11	$9	$7	$5	$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
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	Bank loan	$50,000	Oct	2019	1	50,000.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0	Oct	2019	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL:	$70,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Loan Calculations for Balance Sheet	Loan Calculations for Balance Sheet	Loan Calculations for Balance Sheet
First Quarter	Second Quarter	Third Quarter	Fourth Quarter	Year 2	Year 3	Year 4	Year 5
Loan #	Name of Loan Source	Amount	Rate	Periods	Start Month	Start Year	Begin Pay Month	Amount	Principle Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long
1	Friends and Family	$20,000.00	5.00%	24	Oct	2019	1	$20,000	$2,392	$9,873 Sure Product Consulting: If received proceeds this quarter, "Due Short" is all the payment of principle (not interest) due in the next 12 months from disbursement	$7,735 Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out.	$4,814 Sure Product Consulting: cummulative principle paid: includes previous quarter's payments	$9,997	$5,189	$7,267	$10,122	$2,610	$9,751	$10,249	-$0	$20,000	$0	-$0	$20,000	$0	-$0	$20,000	$0	-$0	$20,000	$0	-$0
2	Bank loan	$50,000.00	2.50%	48	Oct	2019	1	$50,000	$2,981	$12,111	$34,908	$5,980	$12,187	$31,833	$8,999	$12,263	$28,738	$12,036	$12,340	$25,624	$24,376	$12,652	$12,972	$37,028	$12,972	$0	$50,000	$0	$0	$50,000	$0	$0
3	Loan Source Name	$0.00	0.00%	12	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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	Oct	2019	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:	$21,984	$42,643	$22,184	$37,021	$22,386	$31,349	$22,590	$25,624	$12,652	$12,972	$12,972	$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	5.000%	24	Oct	$2,019.00	1	24	Principle Paid	$794.09	$1,591.50	$2,392.22	$3,196.29	$4,003.70	$4,814.47	$5,628.63	$6,446.18	$7,267.13	$8,091.50	$8,919.31	$9,750.57	$10,585.29	$11,423.49	$12,265.19	$13,110.38	$13,959.11	$14,811.36	$15,667.17	$16,526.55	$17,389.50	$18,256.05	$19,126.21	$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	$9,791.20	$9,832.00	$9,872.96	$9,914.10	$9,955.41	$9,996.89	$10,038.54	$10,080.37	$10,122.37	$10,164.55	$10,206.90	$10,249.43	$9,414.71	$8,576.51	$7,734.81	$6,889.62	$6,040.89	$5,188.64	$4,332.83	$3,473.45	$2,610.50	$1,743.95	$873.79	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$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	$9,414.71	$8,576.51	$7,734.81	$6,889.62	$6,040.89	$5,188.64	$4,332.83	$3,473.45	$2,610.50	$1,743.95	$873.79	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$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