Plan Assumption and Financials

Week7spreadsheets.xlsm

Home >Business & Finance homework help >Management homework help >Plan Assumption and Financials

Warning


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

Your Company Name

Welcome

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

Setup

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

What year will you officially start your company?		2020
SALES ASSUMPTIONS
The Worksheets can accommodate sales projections for up to 10 major product/service lines. How many major product/service lines do you plan to have for your business?		Four Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.
	Ten
Most businesses sell at least some of their products/services on credit (e.g., "net 30" as opposed to cash). What percentage of your sales will be made on credit?		5% 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.)?		$5,000 Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)?		$1,100 Author: This number should reflect the amount you will spend on ONE PART-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
With health insurance and other benefits costing more each year, your plan should account for annual increases. How much do you estimate your benefit costs will increase each year?		3.00%
If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by?		3.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.		$10,000 Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.
At approximately what rate do you expect to be taxed on your net income?		25.00% Author: If you're not sure what percentage to enter here, leave it at the default (25%).
		Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.	If you will use an interest-bearing account for your banking, at what rate will you accrue interest?			1.00% Author: If you're not sure what percentage to enter here, leave it at the default (1.00%).
		Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.	Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.	Author: If you're not sure what percentage to enter here, leave it at the default (15%).	Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).	Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

Setup & Assumptions

SalesProj

Sales Projections Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.			2020-2021														2021-2022														2022-2023						2023-2024						2024-2025
	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		7.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.	600 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.	642 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.	687	735	786	842	900	963	1031	1103	1180	1263	10733		1351	1446	1547	1655	1771	1895	2028	2170	2322	2484	2658	2844	24173		9784 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	11986	14684	17988	54442		22036	26995	33070	40512	122614		276150
Unit Price		6.00% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$8.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.	$8.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.	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00			$8.48	$8.48	$8.48	$8.48	$8.48	$8.48	$8.48	$8.48	$8.48	$8.48	$8.48	$8.48			$8.99	$8.99	$8.99	$8.99			$9.53	$9.53	$9.53	$9.53			$10.10
Gross Sales			$4,800	$5,136	$5,496	$5,880	$6,292	$6,732	$7,204	$7,708	$8,247	$8,825	$9,442	$10,103.29	$85,865		$11,459	$12,261	$13,120	$14,038	$15,021	$16,072	$17,197	$18,401	$19,689	$21,067	$22,542	$24,120	$204,986		$87,949	$107,741	$131,988	$161,691	$489,369		$209,963	$257,213	$315,098	$386,008	$1,168,282		$2,789,066
(Commissions)	0.00% Author: COMMISSIONED SALES What percentage of this product line's sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?			Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	0.00% Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00% Author: RETURNS AND ALLOWANCES A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate--but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales.	$144.00	$154	$164.87	$176.41	$188.75	$201.97	$216.11	$231.23	$247.42	$264.74	$283.27	$303.10	$2,576		$343.77	$367.84	$393.59	$421.14	$450.62	$482.16	$515.91	$552.03	$590.67	$632.02	$676.26	$723.59	$6,150		$2,638.47	$3,232.24	$3,959.63	$4,850.72	$14,681		$6,298.88	$7,716.40	$9,452.93	$11,580.24	$35,048		$83,671.98
Net Sales			$4,656	$4,982	$5,331	$5,704	$6,103	$6,530	$6,987	$7,477	$8,000	$8,560	$9,159	$9,800	$83,289		$11,115	$11,893	$12,726	$13,617	$14,570	$15,590	$16,681	$17,849	$19,098	$20,435	$21,866	$23,396	$198,837		$85,311	$104,509	$128,028	$156,840	$474,688		$203,664	$249,497	$305,645	$374,428	$1,133,233		$2,705,394
(Cost of Goods Sold)		30.00% Author: COST OF GOODS Approximately what percentage of your product's sale price will be spent on manufacturing? If you are a reseller or retailer, what percentage of your product's sale price will be spent on buying the product from your distributor? A service business may not need to track cost of goods, in which case you can set this number to zero.	$1,440.00	$1,541	$1,649	$1,764	$1,888	$2,020	$2,161	$2,312	$2,474	$2,647	$2,833	$3,031	$25,759		$3,438	$3,678	$3,936	$4,211	$4,506	$4,822	$5,159	$5,520	$5,907	$6,320	$6,763	$7,236	$61,496		$26,385	$32,322	$39,596	$48,507	$146,811		$62,989	$77,164	$94,529	$115,802	$350,485		$836,720
GROSS PROFIT			$3,216	$3,441	$3,682	$3,940	$4,216	$4,511	$4,826	$5,164	$5,526	$5,912	$6,326	$6,769	$57,529		$7,678	$8,215	$8,790	$9,405	$10,064	$10,768	$11,522	$12,329	$13,192	$14,115	$15,103	$16,160	$137,341		$58,926	$72,187	$88,432	$108,333	$327,877		$140,675	$172,333	$211,115	$258,625	$782,749		$1,868,674
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		7.00%	600	642	687	735	786	842	900	963	1031	1103	1180	1263	10733		1351	1446	1547	1655	1771	1895	2028	2170	2322	2484	2658	2844	24173		9784 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	11986	14684	17988	54442		22036	26995	33070	40512	122614		276150
Unit Price		6.00% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$4.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.	$4.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.	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00			$4.24	$4.24	$4.24	$4.24	$4.24	$4.24	$4.24	$4.24	$4.24	$4.24	$4.24	$4.24			$4.49	$4.49	$4.49	$4.49			$4.76	$4.76	$4.76	$4.76			$5.05
Gross Sales			$2,400	$2,568	$2,748	$2,940	$3,146	$3,366	$3,602	$3,854	$4,124	$4,412	$4,721	$5,052	$42,932		$5,730	$6,131	$6,560	$7,019	$7,510	$8,036	$8,599	$9,200	$9,844	$10,534	$11,271	$12,060	$102,493		$43,975	$53,871	$65,994	$80,845	$244,684		$104,981	$128,607	$157,549	$193,004	$584,141		$1,394,533
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$72	$77	$82	$88	$94	$101	$108	$116	$124	$132	$142	$152	$1,288		$172	$184	$197	$211	$225	$241	$258	$276	$295	$316	$338	$362	$3,075		$1,319	$1,616	$1,980	$2,425	$7,341		$3,149	$3,858	$4,726	$5,790	$17,524		$41,836
Net Sales			$2,328	$2,491	$2,665	$2,852	$3,052	$3,265	$3,494	$3,738	$4,000	$4,280	$4,580	$4,900	$41,644		$5,558	$5,947	$6,363	$6,808	$7,285	$7,795	$8,341	$8,924	$9,549	$10,218	$10,933	$11,698	$99,418		$42,655	$52,255	$64,014	$78,420	$237,344		$101,832	$124,749	$152,822	$187,214	$566,617		$1,352,697
(Cost of Goods Sold)		30.00%	$720	$770	$824	$882	$944	$1,010	$1,081	$1,156	$1,237	$1,324	$1,416	$1,515	$12,880		$1,719	$1,839	$1,968	$2,106	$2,253	$2,411	$2,580	$2,760	$2,953	$3,160	$3,381	$3,618	$30,748		$13,192	$16,161	$19,798	$24,254	$73,405		$31,494	$38,582	$47,265	$57,901	$175,242		$418,360
GROSS PROFIT			$1,608	$1,721	$1,841	$1,970	$2,108	$2,255	$2,413	$2,582	$2,763	$2,956	$3,163	$3,385	$28,765		$3,839	$4,108	$4,395	$4,703	$5,032	$5,384	$5,761	$6,164	$6,596	$7,058	$7,552	$8,080	$68,670		$29,463	$36,093	$44,216	$54,166	$163,939		$70,338	$86,166	$105,558	$129,313	$391,374		$934,337
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		7.00%	600	642	687	735	786	842	900	963	1031	1103	1180	1263	10733		1351	1446	1547	1655	1771	1895	2028	2170	2322	2484	2658	2844	24173		9784 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	11986	14684	17988	54442		22036	26995	33070	40512	122614		276150
Unit Price		6.00% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$6.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.	$6.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.	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00			$6.36	$6.36	$6.36	$6.36	$6.36	$6.36	$6.36	$6.36	$6.36	$6.36	$6.36	$6.36			$6.74	$6.74	$6.74	$6.74			$7.15	$7.15	$7.15	$7.15			$7.57
Gross Sales			$3,600	$3,852	$4,122	$4,410	$4,719	$5,049	$5,403	$5,781	$6,185	$6,618	$7,082	$7,577	$64,398		$8,594	$9,196	$9,840	$10,528	$11,265	$12,054	$12,898	$13,801	$14,767	$15,800	$16,906	$18,090	$153,740		$65,962	$80,806	$98,991	$121,268	$367,027		$157,472	$192,910	$236,323	$289,506	$876,211		$2,091,799
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$108	$116	$124	$132	$142	$151	$162	$173	$186	$199	$212	$227	$1,932		$258	$276	$295	$316	$338	$362	$387	$414	$443	$474	$507	$543	$4,612		$1,979	$2,424	$2,970	$3,638	$11,011		$4,724	$5,787	$7,090	$8,685	$26,286		$62,754
Net Sales			$3,492	$3,736	$3,998	$4,278	$4,577	$4,898	$5,241	$5,607	$6,000	$6,420	$6,869	$7,350	$62,466		$8,337	$8,920	$9,544	$10,213	$10,927	$11,692	$12,511	$13,387	$14,324	$15,326	$16,399	$17,547	$149,128		$63,983	$78,382	$96,021	$117,630	$356,016		$152,748	$187,123	$229,233	$280,821	$849,925		$2,029,045
(Cost of Goods Sold)		30.00%	$1,080	$1,156	$1,236	$1,323	$1,416	$1,515	$1,621	$1,734	$1,856	$1,986	$2,125	$2,273	$19,320		$2,578	$2,759	$2,952	$3,159	$3,380	$3,616	$3,869	$4,140	$4,430	$4,740	$5,072	$5,427	$46,122		$19,789	$24,242	$29,697	$36,380	$110,108		$47,242	$57,873	$70,897	$86,852	$262,863		$627,540
GROSS PROFIT			$2,412	$2,581	$2,761	$2,955	$3,162	$3,383	$3,620	$3,873	$4,144	$4,434	$4,745	$5,077	$43,147		$5,758	$6,161	$6,593	$7,054	$7,548	$8,076	$8,642	$9,246	$9,894	$10,586	$11,327	$12,120	$103,006		$44,194	$54,140	$66,324	$81,250	$245,908		$105,506	$129,250	$158,336	$193,969	$587,062		$1,401,506
Product Line 4 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		12.00%	1500	1680	1882	2107	2360	2644	2961	3316	3714	4160	4659	5218	36200		5844	6545	7331	8210	9196	10299	11535	12919	14469	16206	18150	20329	141033		76828 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	107938	151645	213051	549462		299321	420524	590806	830040	2140690	8340077
Unit Price		6.25% 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.	$12.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.	$12.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.	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00			$12.75	$12.75	$12.75	$12.75	$12.75	$12.75	$12.75	$12.75	$12.75	$12.75	$12.75	$12.75			$13.55	$13.55	$13.55	$13.55			$14.39	$14.39	$14.39	$14.39			$15.29
Gross Sales			$18,000	$20,160	$22,579	$25,289	$28,323	$31,722	$35,529	$39,792	$44,567	$49,915	$55,905	$62,614	$434,396		$74,511	$83,452	$93,466	$104,682	$117,244	$131,313	$147,071	$164,719	$184,485	$206,624	$231,418	$259,189	$1,798,173		$1,040,781	$1,462,223	$2,054,318	$2,886,169	$7,443,490		$4,308,288	$6,052,834	$8,503,796	$11,947,221	$30,812,139		$127,546,064
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$540	$605	$677	$759	$850	$952	$1,066	$1,194	$1,337	$1,497	$1,677	$1,878	$13,032		$2,235	$2,504	$2,804	$3,140	$3,517	$3,939	$4,412	$4,942	$5,535	$6,199	$6,943	$7,776	$53,945		$31,223	$43,867	$61,630	$86,585	$223,305		$129,249	$181,585	$255,114	$358,417	$924,364		$3,826,382
Net Sales			$17,460	$19,555	$21,902	$24,530	$27,474	$30,770	$34,463	$38,598	$43,230	$48,418	$54,228	$60,735	$421,365		$72,275	$80,948	$90,662	$101,541	$113,726	$127,374	$142,658	$159,777	$178,951	$200,425	$224,476	$251,413	$1,744,228		$1,009,558	$1,418,356	$1,992,688	$2,799,584	$7,220,186		$4,179,039	$5,871,249	$8,248,682	$11,588,805	$29,887,775		$123,719,682
(Cost of Goods Sold)		30.00%	$5,400	$6,048	$6,774	$7,587	$8,497	$9,517	$10,659	$11,938	$13,370	$14,975	$16,772	$18,784	$130,319		$22,353	$25,036	$28,040	$31,405	$35,173	$39,394	$44,121	$49,416	$55,346	$61,987	$69,426	$77,757	$539,452		$312,234	$438,667	$616,295	$865,851	$2,233,047		$1,292,486	$1,815,850	$2,551,139	$3,584,166	$9,243,642		$38,263,819
GROSS PROFIT			$12,060	$13,507	$15,128	$16,943	$18,977	$21,254	$23,804	$26,661	$29,860	$33,443	$37,457	$41,951	$291,046		$49,922	$55,913	$62,622	$70,137	$78,553	$87,980	$98,537	$110,362	$123,605	$138,438	$155,050	$173,656	$1,204,776		$697,323	$979,689	$1,376,393	$1,933,733	$4,987,139		$2,886,553	$4,055,399	$5,697,543	$8,004,638	$20,644,133		$85,455,863
Product Line 5 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 6 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 7 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 8 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 9 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 10 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.																											Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Totals for All Product Lines
Total Unit Volume			3300	3606	3942	4312	4720	5168	5662	6206	6807	7469	8200	9007	68399		9898	10883	11972	13177	14509	15985	17619	19429	21435	23659	26125	28861	213552		106181	143897	195696	267015	712788		365429	501509	690017	951577	2508532		9168527
Total Gross Sales			$28,800	$31,716	$34,944	$38,519	$42,480	$46,870	$51,737	$57,135	$63,124	$69,771	$77,151	$85,346	$627,592		$100,294	$111,040	$122,985	$136,267	$151,040	$167,475	$185,764	$206,121	$228,786	$254,025	$282,138	$313,458	$2,259,392		$1,238,667	$1,704,641	$2,351,290	$3,249,973	$8,544,571		$4,780,704	$6,631,564	$9,212,765	$12,815,739	$33,440,773		$133,821,462
(Total Commissions)			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$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 Returns and Allowances)			$864	$951	$1,048	$1,156	$1,274	$1,406	$1,552	$1,714	$1,894	$2,093	$2,315	$2,560	$18,828		$3,009	$3,331	$3,690	$4,088	$4,531	$5,024	$5,573	$6,184	$6,864	$7,621	$8,464	$9,404	$67,782		$37,160	$51,139	$70,539	$97,499	$256,337		$143,421	$198,947	$276,383	$384,472	$1,003,223		$4,014,644
Total Net Sales			$27,936	$30,765	$33,896	$37,364	$41,206	$45,464	$50,185	$55,421	$61,230	$67,678	$74,836	$82,786	$608,764		$97,285	$107,709	$119,296	$132,179	$146,509	$162,451	$180,191	$199,937	$221,922	$246,404	$273,674	$304,054	$2,191,611		$1,201,507	$1,653,502	$2,280,752	$3,152,474	$8,288,233		$4,637,283	$6,432,617	$8,936,382	$12,431,267	$32,437,550		$129,806,818
(Total Cost of Goods Sold)			$8,640	$9,515	$10,483	$11,556	$12,744	$14,061	$15,521	$17,140	$18,937	$20,931	$23,145	$25,604	$188,278		$30,088	$33,312	$36,896	$40,880	$45,312	$50,243	$55,729	$61,836	$68,636	$76,207	$84,641	$94,037	$677,818		$371,600	$511,392	$705,387	$974,992	$2,563,371		$1,434,211	$1,989,469	$2,763,830	$3,844,722	$10,032,232		$40,146,439
TOTAL GROSS PROFIT			$19,296	$21,250	$23,413	$25,808	$28,462	$31,403	$34,664	$38,280	$42,293	$46,746	$51,691	$57,182	$420,486		$67,197	$74,397	$82,400	$91,299	$101,197	$112,208	$124,462	$138,101	$153,286	$170,197	$189,032	$210,017	$1,513,793		$829,907	$1,142,109	$1,575,365	$2,177,482	$5,724,862		$3,203,072	$4,443,148	$6,172,553	$8,586,545	$22,405,318		$89,660,379

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.	2020-2021														2021-2022														2022-2023						2023-2024						2024-2025
	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,440 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,541	$1,649	$1,764	$1,888	$2,020	$2,161	$2,312	$2,474	$2,647	$2,833	$3,031	$25,759		$3,438	$3,678	$3,936	$4,211	$4,506	$4,822	$5,159	$5,520	$5,907	$6,320	$6,763	$7,236	$61,496		$26,385	$32,322	$39,596	$48,507	$146,811		$62,989	$77,164	$94,529	$115,802	$350,485		$836,720
Ingredients	$960 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,027	$1,099	$1,176	$1,258	$1,346	$1,441	$1,542	$1,649	$1,765	$1,888	$2,021	$17,173		$2,292	$2,452	$2,624	$2,808	$3,004	$3,214	$3,439	$3,680	$3,938	$4,213	$4,508	$4,824	$40,997		$17,590	$21,548	$26,398	$32,338	$97,874		$41,993	$51,443	$63,020	$77,202	$233,656		$557,813
containers	$280	$300	$321	$343	$367	$393	$420	$450	$481	$515	$551	$589	$5,009		$668	$715	$765	$819	$876	$938	$1,003	$1,073	$1,149	$1,229	$1,315	$1,407	$11,958		$5,130	$6,285	$7,699	$9,432	$28,547		$12,248	$15,004	$18,381	$22,517	$68,150		$162,696
bags	$100	$107	$114	$123	$131	$140	$150	$161	$172	$184	$197	$210	$1,789		$239	$255	$273	$292	$313	$335	$358	$383	$410	$439	$470	$502	$4,271		$1,832	$2,245	$2,750	$3,369	$10,195		$4,374	$5,359	$6,565	$8,042	$24,339		$58,106
plastic ware	$100	$107	$114	$123	$131	$140	$150	$161	$172	$184	$197	$210	$1,789		$239	$255	$273	$292	$313	$335	$358	$383	$410	$439	$470	$502	$4,271		$1,832	$2,245	$2,750	$3,369	$10,195		$4,374	$5,359	$6,565	$8,042	$24,339		$58,106
Total Inventory Expense	$1,440 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.)	$1,541	$1,649	$1,764	$1,888	$2,020	$2,161	$2,312	$2,474	$2,647	$2,833	$3,031	$25,759		$3,438	$3,678	$3,936	$4,211	$4,506	$4,822	$5,159	$5,520	$5,907	$6,320	$6,763	$7,236	$61,496		$26,385	$32,322	$39,596	$48,507	$146,811		$62,989	$77,164	$94,529	$115,802	$350,485		$836,720
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	$720	$770	$824	$882	$944	$1,010	$1,081	$1,156	$1,237	$1,324	$1,416	$1,515	$12,880		$1,719	$1,839	$1,968	$2,106	$2,253	$2,411	$2,580	$2,760	$2,953	$3,160	$3,381	$3,618	$30,748		$13,192	$16,161	$19,798	$24,254	$73,405		$31,494	$38,582	$47,265	$57,901	$175,242		$418,360
Ingredients	$380 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.	$407	$435	$466	$498	$533	$570	$610	$653	$699	$748	$800	$6,798		$907	$971	$1,039	$1,111	$1,189	$1,272	$1,361	$1,457	$1,559	$1,668	$1,785	$1,909	$16,228		$6,963	$8,530	$10,449	$12,801	$38,742		$16,622	$20,363	$24,945	$30,559	$92,489		$220,801
containers	$200	$214	$229	$245	$262	$281	$300	$321	$344	$368	$393	$421	$3,578		$477	$511	$547	$585	$626	$670	$717	$767	$820	$878	$939	$1,005	$8,541		$3,665	$4,489	$5,499	$6,737	$20,390		$8,748	$10,717	$13,129	$16,084	$48,678		$116,211
bags	$70	$75	$80	$86	$92	$98	$105	$112	$120	$129	$138	$147	$1,252		$167	$179	$191	$205	$219	$234	$251	$268	$287	$307	$329	$352	$2,989		$1,283	$1,571	$1,925	$2,358	$7,137		$3,062	$3,751	$4,595	$5,629	$17,037		$40,674
plastic ware	$70	$75	$80	$86	$92	$98	$105	$112	$120	$129	$138	$147	$1,252		$167	$179	$191	$205	$219	$234	$251	$268	$287	$307	$329	$352	$2,989		$1,283	$1,571	$1,925	$2,358	$7,137		$3,062	$3,751	$4,595	$5,629	$17,037		$40,674
Total Inventory Expense	$720	$770	$824	$882	$944	$1,010	$1,081	$1,156	$1,237	$1,324	$1,416	$1,515	$12,880		$1,719	$1,839	$1,968	$2,106	$2,253	$2,411	$2,580	$2,760	$2,953	$3,160	$3,381	$3,618	$30,748		$13,192	$16,161	$19,798	$24,254	$73,405		$31,494	$38,582	$47,265	$57,901	$175,242		$418,360
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	$1,080	$1,156	$1,236	$1,323	$1,416	$1,515	$1,621	$1,734	$1,856	$1,986	$2,125	$2,273	$19,320		$2,578	$2,759	$2,952	$3,159	$3,380	$3,616	$3,869	$4,140	$4,430	$4,740	$5,072	$5,427	$46,122		$19,789	$24,242	$29,697	$36,380	$110,108		$47,242	$57,873	$70,897	$86,852	$262,863		$627,540
Ingredients	$740 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.	$792	$847	$907	$970	$1,038	$1,111	$1,188	$1,271	$1,360	$1,456	$1,558	$13,237		$1,767	$1,890	$2,023	$2,164	$2,316	$2,478	$2,651	$2,837	$3,035	$3,248	$3,475	$3,718	$31,602		$13,559	$16,610	$20,348	$24,927	$75,444		$32,369	$39,654	$48,578	$59,510	$180,110		$429,981
containers	$200	$214	$229	$245	$262	$281	$300	$321	$344	$368	$393	$421	$3,578		$477	$511	$547	$585	$626	$670	$717	$767	$820	$878	$939	$1,005	$8,541		$3,665	$4,489	$5,499	$6,737	$20,390		$8,748	$10,717	$13,129	$16,084	$48,678		$116,211
bags	$70	$75	$80	$86	$92	$98	$105	$112	$120	$129	$138	$147	$1,252		$167	$179	$191	$205	$219	$234	$251	$268	$287	$307	$329	$352	$2,989		$1,283	$1,571	$1,925	$2,358	$7,137		$3,062	$3,751	$4,595	$5,629	$17,037		$40,674
plastic ware	$70	$75	$80	$86	$92	$98	$105	$112	$120	$129	$138	$147	$1,252		$167	$179	$191	$205	$219	$234	$251	$268	$287	$307	$329	$352	$2,989		$1,283	$1,571	$1,925	$2,358	$7,137		$3,062	$3,751	$4,595	$5,629	$17,037		$40,674
Total Inventory Expense	$1,080	$1,156	$1,236	$1,323	$1,416	$1,515	$1,621	$1,734	$1,856	$1,986	$2,125	$2,273	$19,320		$2,578	$2,759	$2,952	$3,159	$3,380	$3,616	$3,869	$4,140	$4,430	$4,740	$5,072	$5,427	$46,122		$19,789	$24,242	$29,697	$36,380	$110,108		$47,242	$57,873	$70,897	$86,852	$262,863		$627,540
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	$5,400	$6,048	$6,774	$7,587	$8,497	$9,517	$10,659	$11,938	$13,370	$14,975	$16,772	$18,784	$130,319		$22,353	$25,036	$28,040	$31,405	$35,173	$39,394	$44,121	$49,416	$55,346	$61,987	$69,426	$77,757	$539,452		$312,234	$438,667	$616,295	$865,851	$2,233,047		$1,292,486	$1,815,850	$2,551,139	$3,584,166	$9,243,642		$38,263,819
Ingredients	$4,463 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.	$4,999	$5,598	$6,270	$7,023	$7,865	$8,809	$9,866	$11,050	$12,376	$13,861	$15,525	$107,706		$18,474	$20,691	$23,174	$25,955	$29,070	$32,558	$36,465	$40,841	$45,742	$51,231	$57,379	$64,264	$445,847		$258,056	$362,550	$509,357	$715,609	$1,845,572		$1,068,216	$1,500,767	$2,108,469	$2,962,247	$7,639,699		$31,624,338
containers	$600	$672	$753	$843	$944	$1,057	$1,184	$1,326	$1,486	$1,664	$1,864	$2,087	$14,480		$2,484	$2,782	$3,116	$3,489	$3,908	$4,377	$4,902	$5,491	$6,150	$6,887	$7,714	$8,640	$59,939		$34,693	$48,741	$68,477	$96,206	$248,116		$143,610	$201,761	$283,460	$398,241	$1,027,071		$4,251,535
bags	$187	$209	$235	$263	$294	$330	$369	$413	$463	$519	$581	$650	$4,513		$774	$867	$971	$1,088	$1,218	$1,364	$1,528	$1,711	$1,917	$2,147	$2,404	$2,693	$18,681		$10,813	$15,191	$21,342	$29,984	$77,330		$44,758	$62,882	$88,345	$124,118	$320,104		$1,325,062
plastic ware	$150	$168	$188	$211	$236	$264	$296	$332	$371	$416	$466	$522	$3,620		$621	$695	$779	$872	$977	$1,094	$1,226	$1,373	$1,537	$1,722	$1,928	$2,160	$14,985		$8,673	$12,185	$17,119	$24,051	$62,029		$35,902	$50,440	$70,865	$99,560	$256,768		$1,062,884
Total Inventory Expense	$5,400	$6,048	$6,774	$7,587	$8,497	$9,517	$10,659	$11,938	$13,370	$14,975	$16,772	$18,784	$130,319		$22,353	$25,036	$28,040	$31,405	$35,173	$39,394	$44,121	$49,416	$55,346	$61,987	$69,426	$77,757	$539,452		$312,234	$438,667	$616,295	$865,851	$2,233,047		$1,292,486	$1,815,850	$2,551,139	$3,584,166	$9,243,642		$38,263,819
Product Line 5 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 6 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 7 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 8 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 9 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
	Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 10 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GRAND TOTAL INVENTORY	$8,640	$9,515	$10,483	$11,556	$12,744	$14,061	$15,521	$17,140	$18,937	$20,931	$23,145	$25,604	$188,278		$30,088	$33,312	$36,896	$40,880	$45,312	$50,243	$55,729	$61,836	$68,636	$76,207	$84,641	$94,037	$677,818		$371,600	$511,392	$705,387	$974,992	$2,563,371		$1,434,211	$1,989,469	$2,763,830	$3,844,722	$10,032,232		$40,146,439

CapEx

Capital Purchases Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.								9/30/16
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-2016
Item Name (change name here)	$0 Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.	Oct Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	2017 Author: Enter the year you will purchase the item(s).	1 Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.	$0 Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Equipment Author: Equipment includes machinery, furniture, vehicles, etc.
food processors	$50 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	2020	5	$10 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.
safety equipment	$700	Oct	2020	5	$140
cooking equipment	$1,000	Oct	2020	5	$200
servingware	$1,200	Oct	2020	3	$400
storage racks and shelves	$2,000	Oct	2020	4	$500
Food truck	$15,000	Oct	2020	5	$3,000
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Computer Hardware/Software Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.
		Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	Author: Enter the year you will purchase the item(s).	Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.	Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.	Author: Equipment includes machinery, furniture, vehicles, etc.	Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.		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.	2 Point of sale systems	$1,000	Oct	2020	5	$200
Big Easy Vegan Cuisine ERP system	$4,000	Oct	2020	5	$800
Computers	$3,500	Oct	2020	5	$700
Power Supply Machine	$1,000	Oct	2020	20	$50
Computer Servers	$5,000	Oct	2020	5	$1,000
Printer	$250	Oct	2020	5	$50
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Telecommunications Author: Telecommunications includes phone systems, fax machines, etc.
3 phones	$300	Oct	2020	5	$60
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Item Name (change name here)	$0	Oct	2017	1	$0
Land Author: Land purchases are not depreciable.
Item Name (change name here)	$0	Oct	2017	Land is a non-depreciable asset
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	2017
Item Name (change name here)	$0	Oct	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.	2020-2021													2021-2022													2022-2023					2023-2024					2024-2025
	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	$3,000 Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$36,000	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$3,090	$37,080	$9,548	$9,548	$9,548	$9,548	$38,192	$9,835	$9,835	$9,835	$9,835	$39,338	$40,518
Benefits (across all employees)	$417 Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$5,000	$429	$429	$429	$429	$429	$429	$429	$429	$429	$429	$429	$429	$5,150	$1,326	$1,326	$1,326	$1,326	$5,305	$1,366	$1,366	$1,366	$1,366	$5,464	$5,628
Payroll Taxes (across all employees)	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,400	$464	$464	$464	$464	$464	$464	$464	$464	$464	$464	$464	$464	$5,562	$1,432	$1,432	$1,432	$1,432	$5,729	$1,475	$1,475	$1,475	$1,475	$5,901	$6,078
Total Costs	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$3,867	$46,400	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$3,983	$47,792	$12,306	$12,306	$12,306	$12,306	$49,226	$12,676	$12,676	$12,676	$12,676	$50,703	$52,224
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!	Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.										Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.0	0.0	0.0		0.0	0.0	0.0	0.0		0.0
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other
# 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	15	15	15	15	15	15	15	15	15	15	15	15		28	28	28	28	28	28	28	28	28	28	28	28		28 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees".	Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).									Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.								Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	28	28	28	28	28	28	28	28
Avg. Hours per Hourly Employee	40	40	40	40	40	40	40	40	40	40	40	40		40	40	40	40	40	40	40	40	40	40	40	40		120	120	120	120		120	120	120	120		480
Avg Hourly Rate	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00		$10.30	$10.30	$10.30	$10.30	$10.30	$10.30	$10.30	$10.30	$10.30	$10.30	$10.30	$10.30		$10.61	$10.61	$10.61	$10.61		$10.93	$10.93	$10.93	$10.93		$11.26
Calculated Wages Per Hourly Employee	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,800	$412	$412	$412	$412	$412	$412	$412	$412	$412	$412	$412	$412	$4,944	$1,273	$1,273	$1,273	$1,273	$5,092	$1,311	$1,311	$1,311	$1,311	$5,245	$5,402
Wages	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$72,000	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$11,536	$138,432	$35,646	$35,646	$35,646	$35,646	$142,585	$36,716	$36,716	$36,716	$36,716	$146,863	$151,268
Benefits (across all employees)	$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,500	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$2,644	$31,724	$8,169	$8,169	$8,169	$8,169	$32,676	$8,414	$8,414	$8,414	$8,414	$33,656	$34,666
Payroll Taxes (across all employees)	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$10,800	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$1,730	$20,765	$5,347	$5,347	$5,347	$5,347	$21,388	$5,507	$5,507	$5,507	$5,507	$22,029	$22,690
Total Costs	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$8,275	$99,300	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$15,910	$190,921	$49,162	$49,162	$49,162	$49,162	$196,648	$50,637	$50,637	$50,637	$50,637	$202,548	$208,624
TOTAL
# Full 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
# Part-Time Employees	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15		$28	$28	$28	$28	$28	$28	$28	$28	$28	$28	$28	$28		$28	$28	$28	$28		$28	$28	$28	$28		$28
Salary/Wages	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$108,000	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$175,512	$45,194	$45,194	$45,194	$45,194	$180,777	$46,550	$46,550	$46,550	$46,550	$186,201	$191,787
Benefits	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$21,500	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$36,874	$9,495	$9,495	$9,495	$9,495	$37,980	$9,780	$9,780	$9,780	$9,780	$39,120	$40,293
Payroll Taxes	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$16,200	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$26,327	$6,779	$6,779	$6,779	$6,779	$27,117	$6,983	$6,983	$6,983	$6,983	$27,930	$28,768
GRAND TOTAL COSTS	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$12,142	$145,700	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$19,893	$238,713	$61,469	$61,469	$61,469	$61,469	$245,874	$63,313	$63,313	$63,313	$63,313	$253,250	$260,848

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	2020-2021														2021-2022														2022-2023						2023-2024						2024-2025
	October	November	December	January	February	March	April	May	June	July	August	September	TOTAL		October	November	December	January	February	March	April	May	June	July	August	September	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Professional Assistance
Marketing/PR Consultants	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Advertising Agencies	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Social Media Specialists	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
SEO Specialist	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Graphic/Web Design	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Brochures/Leaflets/Flyers	$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
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	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,800		$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,800		$1,200	$1,200	$1,200	$1,200	$4,800		$1,200	$1,200	$1,200	$1,200	$4,800		$4,800
Media Advertising
Print (newspaper, etc.)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Television and Radio	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$9,600		$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$9,600		$2,400	$2,400	$2,400	$2,400	$9,600		$2,400	$2,400	$2,400	$2,400	$9,600		$9,600
Online Author: Includes AdWords, banner ads, social media ads, etc.	Author: For information about this worksheet, see Chapter 10, "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$3,600		$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$3,600		$900	$900	$900	$900	$3,600		$900	$900	$900	$900	$3,600		$3,600
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	$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
Website
Development/Programming	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$6,000		$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$6,000		$1,500	$1,500	$1,500	$1,500	$6,000		$1,500	$1,500	$1,500	$1,500	$6,000		$6,000
Maintenance and Hosting	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200		$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200		$300	$300	$300	$300	$1,200		$300	$300	$300	$300	$1,200		$1,200
Trade Shows
Fees and Setup	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$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	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,800		$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,800		$1,200	$1,200	$1,200	$1,200	$4,800		$1,200	$1,200	$1,200	$1,200	$4,800		$4,800
GRAND TOTAL COSTS	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$32,400		$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$32,400		$8,100	$8,100	$8,100	$8,100	$32,400		$8,100	$8,100	$8,100	$8,100	$32,400		$32,400

Marketing Budget

ProSvs

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

Professional Services Budget

CapInvest

Capital Investments and Loans Author: This worksheet will help you manage loans and investments in your business.
Item	Amount	Date		Loan Period Sure Product Consulting: Loan period is in NUMBER OF MONTHS	Interest Rate
							Reminder: All invesments & loans must be on or after your business start date of:
Equity Capital Investments Author: Equity capital investments can come from a number of sources, including venture capitalists, angel investors, and family members. Generally, these investors are purchasing a percentage of (or shares in) your company. They expect to reap the rewards of your business' success through periodic dividend payments (a share of the profits) and/or when the company is sold.				Sure Product Consulting: Loan period is in NUMBER OF MONTHS	Month	Year		September-2016
Personal contribution	$100,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.	2020 Author: Enter the year you will receive the investment cash.	Capital investments are not paid back on a loan schedule.
contribution from friends and family	$20,000	Oct	2020
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Investment Source Name	$0	Oct	2017
Total Capital Investments	$120,000
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.
Short Term Loan	$500,000	Oct	2021	48 Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.	5.50% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Oct	2017	12	0.00% Author: Enter the loan's annual interest rate.
Total Loans	$500,000
TOTAL INVESTMENTS AND LOANS	$620,000

Capital Investments and Loans

IncSt

Income Statements Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.	2020-2021													2021-2022													2022-2023					2023-2024					2024-2025
	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	$28,800	$31,716	$34,944	$38,519	$42,480	$46,870	$51,737	$57,135	$63,124	$69,771	$77,151	$85,346	$627,592	$100,294	$111,039.71	$122,985	$136,267	$151,040	$167,475	$185,764	$206,121	$228,786	$254,025	$282,138	$313,458	$2,259,392	$1,238,667	$1,704,641	$2,351,290	$3,249,973	$8,544,571	$4,780,704	$6,631,564	$9,212,765	$12,815,739	$33,440,773	$133,821,462
(Commissions)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0.00	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and allowances)	$864	$951	$1,048	$1,156	$1,274	$1,406	$1,552	$1,714	$1,894	$2,093	$2,315	$2,560	$18,828	$3,009	$3,331.19	$3,690	$4,088	$4,531	$5,024	$5,573	$6,184	$6,864	$7,621	$8,464	$9,404	$67,782	$37,160	$51,139	$70,539	$97,499	$256,337	$143,421	$198,947	$276,383	$384,472	$1,003,223	$4,014,644
Net Sales	$27,936	$30,765	$33,896	$37,364	$41,206	$45,464	$50,185	$55,421	$61,230	$67,678	$74,836	$82,786	$608,764	$97,285	$107,708.52	$119,296	$132,179	$146,509	$162,451	$180,191	$199,937	$221,922	$246,404	$273,674	$304,054	$2,191,611	$1,201,507	$1,653,502	$2,280,752	$3,152,474	$8,288,233	$4,637,283	$6,432,617	$8,936,382	$12,431,267	$32,437,550	$129,806,818
(Cost of Goods)	$8,640	$9,515	$10,483	$11,556	$12,744	$14,061	$15,521	$17,140	$18,937	$20,931	$23,145	$25,604	$188,278	$30,088	$33,311.91	$36,896	$40,880	$45,312	$50,243	$55,729	$61,836	$68,636	$76,207	$84,641	$94,037	$677,818	$371,600	$511,392	$705,387	$974,992	$2,563,371	$1,434,211	$1,989,469	$2,763,830	$3,844,722	$10,032,232	$40,146,439
GROSS PROFIT	$19,296	$21,250	$23,413	$25,808	$28,462	$31,403	$34,664	$38,280	$42,293	$46,746	$51,691	$57,182	$420,486	$67,197	$74,396.61	$82,400	$91,299	$101,197	$112,208	$124,462	$138,101	$153,286	$170,197	$189,032	$210,017	$1,513,793	$829,907	$1,142,109	$1,575,365	$2,177,482	$5,724,862	$3,203,072	$4,443,148	$6,172,553	$8,586,545	$22,405,318	$89,660,379
EXPENSES - General and Administrative
Salaries and wages	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$9,000	$108,000	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$14,626	$175,512	$45,194	$45,194	$45,194	$45,194	$180,777	$46,550	$46,550	$46,550	$46,550	$186,201	$191,787
Employee benefits	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$1,792	$21,500	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$3,073	$36,874	$9,495	$9,495	$9,495	$9,495	$37,980	$9,780	$9,780	$9,780	$9,780	$39,120	$40,293
Payroll taxes	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$1,350	$16,200	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$2,194	$26,327	$6,779	$6,779	$6,779	$6,779	$27,117	$6,983	$6,983	$6,983	$6,983	$27,930	$28,768
Professional services	$958	$958	$958	$958	$958	$958	$958	$958	$958	$958	$958	$958	$11,500	$958	$958	$958	$958	$958	$958	$958	$958	$958	$958	$958	$958	$11,500	$2,875	$2,875	$2,875	$2,875	$11,500	$2,875	$2,875	$2,875	$2,875	$11,500	$11,500
Marketing and advertising	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$32,400	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$32,400	$8,100	$8,100	$8,100	$8,100	$32,400	$8,100	$8,100	$8,100	$8,100	$32,400	$32,400
Rent	$0	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$60,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$5,500	$66,000	$16,500	$16,500	$16,500	$16,500	$66,000	$16,500	$16,500	$16,500	$16,500	$66,000	$66,000
Equipment rental	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Maintenance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Depreciation	$468	$468	$468	$468	$468	$468	$468	$468	$468	$468	$468	$468	$5,617	$468	$468	$468	$468	$468	$468	$468	$468	$468	$468	$468	$468	$5,617	$1,404	$1,404	$1,404	$1,404	$5,617	$1,338	$1,338	$1,338	$1,338	$5,351	$4,976
Insurance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Telephone service	$0	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,100	$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
Utilities	$0	$850	$850	$850	$850	$850	$850	$850	$850	$850	$850	$850	$9,350	$850	$850	$850	$850	$850	$850	$850	$850	$850	$850	$850	$850	$10,200	$2,550	$2,550	$2,550	$2,550	$10,200	$2,550	$2,550	$2,550	$2,550	$10,200	$10,200
Office supplies	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Postage and shipping	$0	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,100	$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
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$2,292	$2,249	$2,206	$2,163	$2,119	$2,076	$2,032	$1,988	$1,944	$1,899	$1,855	$1,810	$24,632	$5,159	$4,749	$4,332	$3,910	$18,150	$3,482	$3,049	$2,609	$2,163	$11,303	$4,070
Other (change title here)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other (change title here)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
TOTAL EXPENSES	$16,268	$22,818	$22,818	$22,818	$22,818	$22,818	$22,818	$22,818	$22,818	$22,818	$22,818	$22,818	$267,267	$32,861	$32,818	$32,775	$32,732	$32,688	$32,645	$32,601	$32,557	$32,513	$32,469	$32,424	$32,379	$391,462	$98,657	$98,246	$97,830	$97,408	$392,142	$98,758	$98,324	$97,884	$97,438	$392,404	$392,393
Net income before taxes and interest	$3,028	-$1,568	$594	$2,990	$5,643	$8,585	$11,845	$15,462	$19,475	$23,928	$28,873	$34,364	$153,219	$34,336	$41,579	$49,625	$58,567	$68,508	$79,563	$91,861	$105,544	$120,773	$137,728	$156,608	$177,638	$1,122,331	$731,250	$1,043,863	$1,477,534	$2,080,074	$5,332,720	$3,104,314	$4,344,824	$6,074,669	$8,489,107	$22,012,914	$89,267,986
Interest Income	$81	$80	$74	$77	$82	$82	$92	$106	$115	$135	$160	$182	$1,266	$619	$646	$622	$663	$712	$712	$781	$861	$895	$1,002	$1,124	$1,205	$9,843	$4,903	$6,776	$9,457	$13,261	$34,397	$18,963	$26,986	$38,233	$53,983	$138,164	$878,684
Provision for taxes on income	$777	$0	$167	$767	$1,431	$2,167	$2,984	$3,892	$4,898	$6,016	$7,258	$8,636	$38,305	$8,739	$10,556	$12,562	$14,808	$17,305	$20,069	$23,160	$26,601	$30,417	$34,682	$39,433	$44,711	$280,583	$184,038	$262,660	$371,748	$523,334	$1,341,779	$780,819	$1,092,952	$1,528,226	$2,135,772	$5,537,770	$22,536,668
NET PROFIT	$2,332	-$1,488	$501	$2,300	$4,294	$6,500	$8,953	$11,676	$14,693	$18,048	$21,774	$25,909	$116,180	$26,216	$31,669	$37,685	$44,423	$51,916	$60,207	$69,481	$79,804	$91,251	$104,047	$118,299	$134,132	$851,591	$552,115	$787,980	$1,115,244	$1,570,001	$4,025,338	$2,342,457	$3,278,857	$4,584,677	$6,407,317	$16,613,309	$67,610,003

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.	2020-2021														2021-2022														2022-2023						2023-2024						2024-2025
	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	$27,360	$30,130	$33,197	$36,593	$40,356	$44,526	$49,150	$54,278	$59,968	$66,282	$73,293	$81,079	$596,212		$95,279	$105,488	$116,836	$129,454	$143,488	$159,101	$176,476	$195,815	$217,346	$241,324	$268,031	$297,785	$2,146,423		$1,176,733	$1,619,409	$2,233,726	$3,087,474	$8,117,342		$4,541,669	$6,299,986	$8,752,127	$12,174,952	$31,768,734		$127,130,389
Collections	$0	$1,440	$1,586	$1,747	$1,926	$2,124	$2,343	$2,587	$2,857	$3,156	$3,489	$3,858	$27,112		$4,267	$5,015	$5,552	$6,149	$6,813	$7,552	$8,374	$9,288	$10,306	$11,439	$12,701	$14,107	$101,564		$56,962	$77,466	$106,787	$147,521	$388,735		$213,523	$300,731	$417,618	$580,737	$1,512,609		$6,347,079
Total Cash from Sales	$27,360	$31,570	$34,783	$38,340	$42,282	$46,650	$51,493	$56,865	$62,824	$69,438	$76,782	$84,937	$623,324		$99,546	$110,502	$122,388	$135,603	$150,302	$166,653	$184,850	$205,103	$227,652	$252,763	$280,732	$311,892	$2,247,987		$1,233,695	$1,696,875	$2,340,513	$3,234,995	$8,506,077		$4,755,192	$6,600,717	$9,169,745	$12,755,690	$33,281,343		$133,477,468
Income from Financing
Interest Income	$81 Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.	$80	$74	$77	$82	$82	$92	$106	$115	$135	$160	$182	$1,266		$619	$646	$622	$663	$712	$712	$781	$861	$895	$1,002	$1,124	$1,205	$9,843		$4,903	$6,776	$9,457	$13,261	$34,397		$18,963	$26,986	$38,233	$53,983	$138,164		$878,684
Loan Proceeds	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$500,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$500,000		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Equity Capital Investments	$120,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$120,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
Total Cash from Financing	$120,081	$80	$74	$77	$82	$82	$92	$106	$115	$135	$160	$182	$121,266		$500,619	$646	$622	$663	$712	$712	$781	$861	$895	$1,002	$1,124	$1,205	$509,843		$4,903	$6,776	$9,457	$13,261	$34,397		$18,963	$26,986	$38,233	$53,983	$138,164		$878,684
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	$147,441	$31,650	$34,857	$38,417	$42,364	$46,733	$51,586	$56,970	$62,940	$69,574	$76,941	$85,118	$744,590		$600,165	$111,149	$123,009	$136,266	$151,014	$167,366	$185,631	$205,964	$228,547	$253,765	$281,856	$313,098	$2,757,830		$1,238,598	$1,703,651	$2,349,970	$3,248,255	$8,540,475		$4,774,154	$6,627,702	$9,207,979	$12,809,672	$33,419,508		$134,356,152
CASH DISBURSEMENTS
Inventory	$8,640	$9,515	$10,483	$11,556	$12,744	$14,061	$15,521	$17,140	$18,937	$20,931	$23,145	$25,604	$188,278		$30,088	$33,312	$36,896	$40,880	$45,312	$50,243	$55,729	$61,836	$68,636	$76,207	$84,641	$94,037	$677,818		$371,600	$511,392	$705,387	$974,992	$2,563,371		$1,434,211	$1,989,469	$2,763,830	$3,844,722	$10,032,232		$40,146,439
Operating Expenses	$15,800	$22,350	$22,350	$22,350	$22,350	$22,350	$22,350	$22,350	$22,350	$22,350	$22,350	$22,350	$261,650		$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$30,101	$361,213		$92,094	$92,094	$92,094	$92,094	$368,374		$93,938	$93,938	$93,938	$93,938	$375,750		$383,348
Commissions/Returns & Allowances	$864	$951	$1,048	$1,156	$1,274	$1,406	$1,552	$1,714	$1,894	$2,093	$2,315	$2,560	$18,828		$3,009	$3,331	$3,690	$4,088	$4,531	$5,024	$5,573	$6,184	$6,864	$7,621	$8,464	$9,404	$67,782		$37,160	$51,139	$70,539	$97,499	$256,337		$143,421	$198,947	$276,383	$384,472	$1,003,223		$4,014,644
Capital Purchases	$35,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$35,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
Loan Payments	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$139,539		$34,885	$34,885	$34,885	$34,885	$139,539		$34,885	$34,885	$34,885	$34,885	$139,539		$139,539
Income Tax Payments	$0 Author: Note that on your Income Statements, we've generated an estimate for income taxes. This line on the Cash Flow statement is where you should reflect the actual payments you intend to make on a regular basis (probably quarterly).	Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.	$0	$8,150	$0	$0	$8,150	$0	$0	$8,150	$0	$0	$8,149	$32,599		$0	$0	$70,516	$0	$0	$70,516	$0	$0	$70,516	$0	$0	$70,517	$282,065		$184,343	$262,970	$372,063	$523,655	$1,343,031		$781,145	$1,093,284	$1,528,562	$2,136,115	$5,539,106		$22,572,242
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	$60,304	$32,816	$42,032	$35,061	$36,368	$45,967	$39,423	$41,204	$51,331	$45,374	$47,810	$58,663	$536,354		$74,826	$78,372	$152,830	$86,698	$91,573	$167,512	$103,031	$109,749	$187,745	$125,557	$134,835	$215,688	$1,528,416		$720,081	$952,480	$1,274,967	$1,723,124	$4,670,652		$2,487,600	$3,410,523	$4,697,597	$6,494,131	$17,089,850		$67,256,211
NET CASH FLOW	$87,137	-$1,166	-$7,175	$3,356	$5,995	$766	$12,163	$15,766	$11,609	$24,199	$29,132	$26,455	$208,236		$525,339	$32,776	-$29,821	$49,569	$59,441	-$146	$82,599	$96,215	$40,803	$128,207	$147,022	$97,410	$1,229,414		$518,517	$751,171	$1,075,003	$1,525,131	$3,869,822		$2,286,555	$3,217,180	$4,510,382	$6,315,541	$16,329,658		$67,099,941
Opening Cash Balance	$10,000	$97,137	$95,971	$88,796	$92,152	$98,147	$98,912	$111,075	$126,841	$138,450	$162,649	$191,781			$218,236	$743,575	$776,351	$746,530	$796,099	$855,540	$855,394	$937,993	$1,034,208	$1,075,011	$1,203,218	$1,350,240			$1,447,650	$1,966,167	$2,717,338	$3,792,341			$5,317,472	$7,604,027	$10,821,206	$15,331,588			$21,647,130
Cash Receipts	$147,441	$31,650	$34,857	$38,417	$42,364	$46,733	$51,586	$56,970	$62,940	$69,574	$76,941	$85,118			$600,165	$111,149	$123,009	$136,266	$151,014	$167,366	$185,631	$205,964	$228,547	$253,765	$281,856	$313,098			$1,238,598	$1,703,651	$2,349,970	$3,248,255			$4,774,154	$6,627,702	$9,207,979	$12,809,672			$134,356,152
Cash Disbursements	$60,304	$32,816	$42,032	$35,061	$36,368	$45,967	$39,423	$41,204	$51,331	$45,374	$47,810	$58,663			$74,826	$78,372	$152,830	$86,698	$91,573	$167,512	$103,031	$109,749	$187,745	$125,557	$134,835	$215,688			$720,081	$952,480	$1,274,967	$1,723,124			$2,487,600	$3,410,523	$4,697,597	$6,494,131			$67,256,211
ENDING CASH BALANCE	$97,137	$95,971	$88,796	$92,152	$98,147	$98,912	$111,075	$126,841	$138,450	$162,649	$191,781	$218,236	$218,236		$743,575	$776,351	$746,530	$796,099	$855,540	$855,394	$937,993	$1,034,208	$1,075,011	$1,203,218	$1,350,240	$1,447,650	$1,447,650		$1,966,167	$2,717,338	$3,792,341	$5,317,472	$5,317,472		$7,604,027	$10,821,206	$15,331,588	$21,647,130	$21,647,130		$88,747,070

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
Vegan Restaurant				Vegan Restaurant				Vegan Restaurant				Vegan Restaurant				Vegan Restaurant				Vegan Restaurant				Vegan Restaurant				Vegan Restaurant
First Quarter				Second Quarter				Third Quarter				Fourth Quarter				2021-2022				2022-2023				2023-2024				2024-2025
2020-2021				2020-2021				2020-2021				2020-2021
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	$88,796			Cash	$98,912			Cash	$138,450			Cash	$218,236			Cash	$1,447,650			Cash	$5,317,472			Cash	$21,647,130			Cash	$88,747,070
Accounts Receivable	$1,747			Accounts Receivable	$2,343			Accounts Receivable	$3,156			Accounts Receivable	$4,267			Accounts Receivable	$15,673			Accounts Receivable	$54,166			Accounts Receivable	$213,596			Accounts Receivable	$557,589
Inventory	$0			Inventory	$0			Inventory	$0			Inventory	$0			Inventory	$0			Inventory	$0			Inventory	$0			Inventory	$0
Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0
Total Current Assets		$90,543		Total Current Assets		$101,256		Total Current Assets		$141,606		Total Current Assets		$222,503		Total Current Assets		$1,463,323		Total Current Assets		$5,371,638		Total Current Assets		$21,860,725		Total Current Assets		$89,304,660
Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets
Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0
Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0
Equipment	$19,950			Equipment	$19,950			Equipment	$19,950			Equipment	$19,950			Equipment	$19,950			Equipment	$19,950			Equipment	$19,950			Equipment	$19,950
Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050			Computers & Telecommunications	$15,050
(Less Accumlated Depreciation)	$1,404			(Less Accumlated Depreciation)	$2,809			(Less Accumlated Depreciation)	$4,213			(Less Accumlated Depreciation)	$5,617			(Less Accumlated Depreciation)	$11,234			(Less Accumlated Depreciation)	$16,852			(Less Accumlated Depreciation)	$22,202			(Less Accumlated Depreciation)	$27,178
Total Fixed Assets		$33,596		Total Fixed Assets		$32,191		Total Fixed Assets		$30,787		Total Fixed Assets		$29,383		Total Fixed Assets		$23,766		Total Fixed Assets		$18,149		Total Fixed Assets		$12,798		Total Fixed Assets		$7,823
Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0
TOTAL ASSETS			$124,139	TOTAL ASSETS			$133,447	TOTAL ASSETS			$172,393	TOTAL ASSETS			$251,886	TOTAL ASSETS			$1,487,088	TOTAL ASSETS			$5,389,787	TOTAL ASSETS			$21,873,523	TOTAL ASSETS			$89,312,482
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	$0 Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$121,388			Short-Term Notes Payable	$128,236			Short-Term Notes Payable	$135,469			Short-Term Notes Payable	$0
Income Taxes Due	-$7,206 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	-$10,991			Income Taxes Due	-$7,367			Income Taxes Due	$5,706			Income Taxes Due	$4,224			Income Taxes Due	$2,972			Income Taxes Due	$1,636			Income Taxes Due	-$33,939
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		-$7,206		Total Current Liabilities		-$10,991		Total Current Liabilities		-$7,367		Total Current Liabilities		$5,706		Total Current Liabilities		$125,612		Total Current Liabilities		$131,208		Total Current Liabilities		$137,105		Total Current Liabilities		-$33,939
Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities
Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$263,705			Long-Term Notes Payable	$135,469			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		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$263,705		Total Long-Term Liabilities		$135,469		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	$130,000			Paid-In Capital	$130,000			Paid-In Capital	$130,000			Paid-In Capital	$130,000			Paid-In Capital	$130,000			Paid-In Capital	$130,000			Paid-In Capital	$130,000			Paid-In Capital	$130,000
Retained Earnings	$1,344			Retained Earnings	$14,438			Retained Earnings	$49,760			Retained Earnings	$116,180			Retained Earnings	$967,772			Retained Earnings	$4,993,110			Retained Earnings	$21,606,419			Retained Earnings	$89,216,421
Total Net Worth		$131,344		Total Net Worth		$144,438		Total Net Worth		$179,760		Total Net Worth		$246,180		Total Net Worth		$1,097,772		Total Net Worth		$5,123,110		Total Net Worth		$21,736,419		Total Net Worth		$89,346,421
TOTAL LIABILITIES AND NET WORTH			$124,139	TOTAL LIABILITIES AND NET WORTH			$133,447	TOTAL LIABILITIES AND NET WORTH			$172,393	TOTAL LIABILITIES AND NET WORTH			$251,886	TOTAL LIABILITIES AND NET WORTH			$1,487,088	TOTAL LIABILITIES AND NET WORTH			$5,389,787	TOTAL LIABILITIES AND NET WORTH			$21,873,523	TOTAL LIABILITIES AND NET WORTH			$89,312,482

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 (2020-2021)
	October	$24,281 Author: This is the amount of sales you will need to make each month to break even.
	November	$34,057
	December	$34,057
	January	$34,057
	February	$34,057
	March	$34,057
	April	$34,057
	May	$34,057
	June	$34,057
	July	$34,057
	August	$34,057
	September	$34,057
	Monthly Average	$33,242
	Year 2 (2021-2022)
	October	$49,046
	November	$48,982
	December	$48,918
	January	$48,854
	February	$48,789
	March	$48,724
	April	$48,658
	May	$48,593
	June	$48,527
	July	$48,461
	August	$48,394
	September	$48,327
	Monthly Average	$48,689
	Year 3 (2022-2023)
	1st Quarter	$147,249
	2nd Quarter	$146,636
	3rd Quarter	$146,015
	4th Quarter	$145,385
	Quarterly Average	$146,322
	Year 4 (2023-2024)
	1st Quarter	$147,400
	2nd Quarter	$146,752
	3rd Quarter	$146,096
	4th Quarter	$145,430
	Quarterly Average	$146,419
	Year 5 (2024-2025)
	Annual Average	$585,661

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 (2020-2021)	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	$97,749	-12.57	-12.57	0.95	-0.05	2%	2%	2%	$92,596.32
2nd Quarter	$112,247	-9.21	-9.21	1.10	-0.08	12%	14%	13%	$124,032.76
3rd Quarter	$148,973	-19.22	-19.22	1.12	-0.04	26%	28%	27%	$166,835.29
4th Quarter	$216,797	39.00	39.00	1.04	0.02	35%	39%	35%	$225,299.55
Year 2 (2021-2022)	$1,337,711	11.65	11.65	1.64	0.35	102%	51%	75%	$2,191,610.58
Year 3 (2022-2023)	$5,240,431	40.94	40.94	1.58	0.05	104%	64%	99%	$8,288,233.42
Year 4 (2023-2024)	$21,723,621	159.45	159.45	1.49	0.01	101%	68%	101%	$32,437,549.65
Year 5 (2024-2025)	$89,338,599	-2,631.33	-2,631.33	1.45	-0.00	100%	69%	100%	$129,806,817.84

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2020-2021) Gross Sales Oct ober November December January February March April May June July August September 28800 31716.000000000004 34944.12000000001 38519.16840000001 42479.945388000022 46869.708989160026 51736.696133281235 57134.705279276524 63123.74791549136 69770.777128241083 77150.502408923145 85346.300965057555 Gross Profit October November December January February March April May June July August September 19296 21249.720000000005 23412.560400000002 25807.842828000008 28461.563409960014 31402.705022737224 34663.586409298427 38280.252537115273 42292.911103379214 46746.42067592153 51690.836613978514 57182.021646588561 Net Profit October November December January February March April May June July August September 2331.5870833333329 -1488.4682222222177 501.29854795833467 2299.8560097671934 4293.8903547587424 6500.2246504632876 8953.4810625418104 11675.826181931194 14692.569526566182 18047.813798495554 21774.317801180521 25909.227148176768

NSYr1

Year 1: Net Sales (2020-2021) Product Line 1 October November December January February March April May June July August September 4656 4981.92 5330.6544000000004 5703.8002080000006 6103.0662225600008 6530.2808581392019 6987.4005182089459 7476.5185544835731 7999.8748532974241 8559.8660930282458 9159.0567195402218 9800.1906899080386 Product Line 2 October November December January February March April May June July August September 2328 2490.96 2665.3272000000002 2851.9001040000003 3051.5331112800004 3265.1404290696009 3493.7002591044729 3738.2592772417865 3999.9374266487121 4279.9330465141229 4579.5283597701109 4900.0953449540193 Product Line 3 October November December January February March April May June July August September 3492 3736.44 3997.9908000000005 4277.8501560000004 4577.2996669200002 4897.7106436044014 5240.5503886567103 5607.3889158626789 5999.9061399730681 6419.8995697711835 6869.2925396551664 7350.1430174310281 Product Line 4 October November December January February March April May June July August September 17460 19555.200000000004 21901.824000000004 24530.042880000008 27473.648025600014 30770.48578867202 34462.944083312672 38598.497373310187 43230.317058107416 48417.955105080306 54228.109717689949 60735.482883812743 Product Line 5 Product Line 6 Product Line 7 Product Line 8 Product Line 9 Product Line 10

1YrCshFlw

Year 1: Cash Flow (2020-2021) Net Cash Flow October November December January February March April May June July August September 87136.88 -1166.1709999999985 -7174.9107138333347 3355.8194819118071 5995.2455125005436 765.57524278192432 12162.722615071914 15765.965007497376 11608.73779249972 24199.497492912138 29131.534693095484 26454.943491984508 Ending Cash Balance 97136.88 95970.709000000003 88795.798286166668 92151.617768078475 98146.863280579011 98912.438523360936 111075.16113843286 126841.12614593023 138449.86393842997 162649.36143134214 191780.89612443763 218235.83961642213

2ndYrCshFlw

Year 2: Cash Flow (2021-2022) Net Cash Flow October November December January February March April May June July August September 525339.19138962671 32776.419105773602 -29820.977509349294 49568.562965427642 59441.311767058389 -146.47003415494692 82599.180709858323 96215.087486243428 40802.857980270201 128207.16661015904 147021.55116130458 97410.050412661716 Ending Cash Balance October November December January February March April May June July August September 743575.03100604878 776351.45011182234 746530.47260247311 796099.03556790075 855540.34733495908 855393.87730080413 937993.05801066244 1034208.1454969058 1075011.003477176 1203218.1700873349 1350239.7212486393 1447649.7716613011

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 627591.67260743096 2259392.3493661205 8544570.537205074 33440772.830127485 133821461.68831433 Gross Profit 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 420486.42064697878 1513792.874075301 5724862.2599273995 22405317.796185419 89660379.331170619 Net Profit 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 116180.17450293034 851591.41884787125 4025338.3242283706 16613308.626266189 67610002.56555286

NS5Yr

5-Year Net Sales

Product Line 1 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 83288.629117165663 198836.86695098359 474687.84248166764 1133233.2441923229 2705393.8837547805 Product Line 2 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 41644.314558582832 99418.433475491795 237343.92124083382 566616.62209616147 1352696.9418773903 Product Line 3 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 62466.47183787424 149127.65021323768 356015.88186125073 849924.93314424227 2029045.4128160856 Product Line 4 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 421364.50691558537 1744227.6282454235 7220185.7755051721 29887774.845790934 123719681.59921664 Product Line 5 Product Line 6 Product Line 7 Product Line 8 Product Line 9 Product Line 10

License

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

About

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

http://www.planningshop.com/

Config

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

Startup Year

2020
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-16

CREDIT MULTIPLIER

Multiple

With "Credit Sales"

0.00

1.00

0.05

Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet

$97,749

$112,247

$148,973

$216,797

$1,337,711

$5,240,431

$21,723,621

$89,338,599

Chart Titles

Year 1 String

2020-2021

Year 1: Financials at-a-Glance (2020-2021)

Year 2 String

2021-2022

Year 1: Net Sales (2020-2021)

Year 3 String

2022-2023

Year 1: Cash Flow (2020-2021)

Year 4 String

2023-2024

Year 2: Cash Flow (2021-2022)

Year 5 String

2024-2025

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-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
Item#	Category	Item Name	Purch Value	Salvage Value	Yrs of Service	Mos of Service	Month Purchased	Year Purchased	Purchase Month	End Month	End Date	Depn Amt montly		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
1	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	- Sure Product Consulting: If "today's" month is one in this asset is dep'd over,	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Equip	food processors	$50.00	$10.00	5	60	Oct	2020	1	60	Aug-21	$ 1		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
12	Equip	safety equipment	$700.00	$140.00	5	60	Oct	2020	1	60	Aug-21	$ 9		9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9
13	Equip	cooking equipment	$1,000.00	$200.00	5	60	Oct	2020	1	60	Aug-21	$ 13		13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13
14	Equip	servingware	$1,200.00	$400.00	3	36	Oct	2020	1	36	Aug-19	$ 22		22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	22	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Equip	storage racks and shelves	$2,000.00	$500.00	4	48	Oct	2020	1	48	Aug-20	$ 31		31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	31	-	-	-	-	-	-	-	-	-	-	-	-
16	Equip	Food truck	$15,000.00	$3,000.00	5	60	Oct	2020	1	60	Aug-21	$ 200		200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200	200
17	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
21	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
22	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
23	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
24	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
25	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
26	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
27	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
28	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
29	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
30	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
31	Comp	2 Point of sale systems	$1,000.00	$200.00	5	60	Oct	2020	1	60	Aug-21	$ 13		13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13	13
32	Comp	Big Easy Vegan Cuisine ERP system	$4,000.00	$800.00	5	60	Oct	2020	1	60	Aug-21	$ 53		53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53	53
33	Comp	Computers	$3,500.00	$700.00	5	60	Oct	2020	1	60	Aug-21	$ 47		47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47	47
34	Comp	Power Supply Machine	$1,000.00	$50.00	20	240	Oct	2020	1	240	Aug-36	$ 4		4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4
35	Comp	Computer Servers	$5,000.00	$1,000.00	5	60	Oct	2020	1	60	Aug-21	$ 67		67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67	67
36	Comp	Printer	$250.00	$50.00	5	60	Oct	2020	1	60	Aug-21	$ 3		3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
37	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
38	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
39	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
40	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
41	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
42	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
43	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
44	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
45	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
46	Comp	3 phones	$300.00	$60.00	5	60	Oct	2020	1	60	Aug-21	$ 4		4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4
47	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
48	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
49	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
50	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
51	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
52	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
53	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
54	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
55	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
56	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
57	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
58	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
59	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
60	Land	Item Name (change name here)	$0.00	$0.00	1	12	Oct	2017	1	12	Aug-17
		TOTAL												$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 468	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 446	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415	$ 415
		Land												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Facilities												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Equip												19,950	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Comp												15,050	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL Author: This goes into Cash Flow statement.											Author: This goes into Cash Flow statement.	35,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL NON-DEPRECIABLE CAPITAL ASSETS Author: This goes into Income statement under "non-depreciable capital purchases"											Author: This goes into Income statement under "non-depreciable capital purchases"	Author: This goes into Cash Flow statement.	Author: This goes into Income statement under "non-depreciable capital purchases"												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-

Depreciation Schedule

LoanInvestSchedules

	Investment Proceeds										Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds
											Sep-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
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	Personal contribution	$100,000			Oct	2020	1				100,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	contribution from friends and family	$20,000			Oct	2020	1				20,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	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
4	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
5	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
6	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
7	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
8	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
9	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
10	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
11	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
12	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
13	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
14	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
15	Investment Source Name	$0			Oct	2017	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
									TOTAL:		$120,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 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-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	Sep-21 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-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22
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	Short Term Loan	$500,000	5.50%	48	Oct	2021	13	60	11,628.24		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	11,628.24	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
2	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
3	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
4	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
5	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
6	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
7	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
8	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
9	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
10	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
11	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
12	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
13	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
14	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
15	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
16	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
17	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
18	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
19	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
20	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
									TOTAL:		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$11,628	$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-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	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22
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	Short Term Loan	$500,000.00	$0.06	$48.00	Oct	$2,021.00	13	60	11,628.24		-	-	-	-	-	-	-	-	-	-	-	-	2,291.67	2,248.87	2,205.89	2,162.70	2,119.32	2,075.73	2,031.95	1,987.97	1,943.78	1,899.40	1,854.81	1,810.01	1,765.01	1,719.80	1,674.39	1,628.77	1,582.94	1,536.90	1,490.64	1,444.18	1,397.50	1,350.61	1,303.51	1,256.19	1,208.65	1,160.89	1,112.92	1,064.72	1,016.30	967.67	918.81	869.72	820.41	770.87	721.11	671.12	620.90	570.45	519.77	468.85	417.71	366.33	314.71	262.86	210.76	158.43	105.86	53.05	-	-	-	-	-	-	-	-	-	-	-	-
2	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0	0.00%	12	Oct	2017	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$2,292	$2,249	$2,206	$2,163	$2,119	$2,076	$2,032	$1,988	$1,944	$1,899	$1,855	$1,810	$1,765	$1,720	$1,674	$1,629	$1,583	$1,537	$1,491	$1,444	$1,398	$1,351	$1,304	$1,256	$1,209	$1,161	$1,113	$1,065	$1,016	$968	$919	$870	$820	$771	$721	$671	$621	$570	$520	$469	$418	$366	$315	$263	$211	$158	$106	$53	$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-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			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	Short Term Loan	$500,000			Oct	2021	13				-	-	-	-	-	-	-	-	-	-	-	-	500,000.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0			Oct	2017	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$500,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
	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	Short Term Loan	$500,000.00	5.50%	48	Oct	2021	13	$500,000			$0	$0 Sure Product Consulting: If received proceeds this quarter, "Due Short" is all the payment of principle (not interest) due in the next 12 months from disbursement	$0 Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out.	$0 Sure Product Consulting: cummulative principle paid: includes previous quarter's payments	$0	$0	$0	$0	$0	$0	$0	$0	$114,907	$121,388	$263,705	$236,295	$128,236	$135,469	$364,531	$135,469	-$0	$500,000	$0	-$0
2	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
3	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
4	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
5	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
6	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
7	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
8	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
9	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
10	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
11	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
12	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
13	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
14	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
15	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
16	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
17	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
18	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
19	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
20	Loan Source Name	$0.00	0.00%	12	Oct	2017	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
									TOTAL:			$0	$0		$0	$0		$0	$0		$0	$0		$121,388	$263,705		$128,236	$135,469		$135,469	-$0		$0	-$0
	BETA - Monthly Loan Calculations for Balance Sheet										Loan Calculations for Balance Sheet												Loan Calculations for Balance Sheet
											Sep-16	Oct-16	Nov-16	Sep-16	Jan-17	Feb-17	Sep-16	Apr-17	May-17	Sep-16	Jul-17	Aug-17	Sep-16	Oct-17	Nov-17	Sep-16	Jan-18	Feb-18	Sep-16	Apr-18	May-18	Sep-16	Jul-18	Aug-18	Sep-16	Oct-18	Nov-18	Sep-16	Jan-19	Feb-19	Sep-16	Apr-19	May-19	Sep-16	Jul-19	Aug-19	Sep-16	Oct-19	Nov-19	Sep-16	Jan-20	Feb-20	Sep-16	Apr-20	May-20	Sep-16	Jul-20	Aug-20	Sep-16	Oct-20	Nov-20	Sep-16	Jan-21	Feb-21	Sep-16	Apr-21	May-21	Sep-16	Jul-21	Aug-21
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	Short Term Loan	$500,000.00	5.500%	48	Oct	$2,021.00	13	60		Principle Paid	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$9,336.57	$18,715.93	$28,138.29	$37,603.82	$47,112.75	$56,665.25	$66,261.54	$75,901.81	$85,586.26	$95,315.10	$105,088.53	$114,906.76	$124,769.99	$134,678.42	$144,632.27	$154,631.74	$164,677.04	$174,768.38	$184,905.97	$195,090.03	$205,320.76	$215,598.39	$225,923.12	$236,295.17	$246,714.76	$257,182.11	$267,697.43	$278,260.94	$288,872.88	$299,533.45	$310,242.88	$321,001.40	$331,809.23	$342,666.59	$353,573.72	$364,530.83	$375,538.17	$386,595.96	$397,704.43	$408,863.81	$420,074.34	$431,336.25	$442,649.78	$454,015.16	$465,432.64	$476,902.44	$488,424.82	$500,000.00
										Due Short	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$115,433.42	$115,962.49	$116,493.98	$117,027.91	$117,564.29	$118,103.13	$118,644.43	$119,188.22	$119,734.50	$120,283.28	$120,834.58	$121,388.41	$121,944.77	$122,503.68	$123,065.16	$123,629.21	$124,195.84	$124,765.07	$125,336.91	$125,911.37	$126,488.47	$127,068.21	$127,650.60	$128,235.67	$128,823.41	$129,413.85	$130,007.00	$130,602.87	$131,201.46	$131,802.80	$132,406.90	$133,013.76	$133,623.41	$134,235.85	$134,851.10	$135,469.17	$124,461.83	$113,404.04	$102,295.57	$91,136.19	$79,925.66	$68,663.75	$57,350.22	$45,984.84	$34,567.36	$23,097.56	$11,575.18	$0.00
										Due Long	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$375,230.01	$365,321.58	$355,367.73	$345,368.26	$335,322.96	$325,231.62	$315,094.03	$304,909.97	$294,679.24	$284,401.61	$274,076.88	$263,704.83	$253,285.24	$242,817.89	$232,302.57	$221,739.06	$211,127.12	$200,466.55	$189,757.12	$178,998.60	$168,190.77	$157,333.41	$146,426.28	$135,469.17	$124,461.83	$113,404.04	$102,295.57	$91,136.19	$79,925.66	$68,663.75	$57,350.22	$45,984.84	$34,567.36	$23,097.56	$11,575.18	-$0.00	$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00
										TOTAL	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000

Loan & Investment Schedules for Disbursement & Repayment