FOR REY WRITER

bus599spreadsheet.xls

Home >Business & Finance homework help >Management homework help >FOR REY WRITER

WelcomeDemo


	Welcome!
	Thank you for trying out Business Plan Financials from Planning Shop. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, The Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. Note that this demo copy of Business Plan Financials is deliberately feature-limited. We restrict you to just one product, one capital investment, one loan and 5 capital expenditures. If you purchase the Business Plan Financials, you get access to up to 10 products, 60 capital expenditures, 15 capital investments, and 20 loans. Also, the watermark that appears and prints on each page willbe removed. To use the Business Plan Financials workbook, first go to the Planning Shop tab of the Excel Ribbon.
	Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically calculated for you.
	While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
	For more in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the Planning Shop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
	Version 2.7 Copyright © 2003-2012 Planning Shop

Warning


	W A R N I N G !
	IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED.
	Excel 2007 for Windows: To enable macros: 1. Click the "Options" button in the Security Warning that appears at the top of this page.
	2. A "Security Alert - Macros & Active X" window should appear. 3. Select the "Enable this content" radio button 4. Click the "OK" button. Your workbook should be ready to use now. If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2007 on Windows - Enabling Macros"
	Excel 2010 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
	If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 and Excel 2013 on Windows - Enabling Macros"
	Excel 2013 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
	If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 & Excel 2013 on Windows - Enabling Macros"
	Excel 2010 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use.
	Excel 2008 for Mac: Excel 2008 for Mac does not support Macros or Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version of Business Plan Financials from PlanningShop.
Excel 2007 on Windows - Enabling Macros
		1. From the Windows Ribbon, Select the circular "Windows" button in the upper left. 2. From the drop-down menu that appears, press the Excel Options button in the lower right.
		3. From the "Excel Options" pop-up, select Trust Center on the left side. 4. Select Trust Center Settings…. In the lower right.
		5. In the "Trust Center" pop-up, select "Macro Settings" on the left side. 6. Then, select the Disable all macros except digitally signed macros. (This works because the Planning Shop signs all its workbooks with digital certificates.) 7. Press OK twice.
Excel 2010 and Excel 2013 on Windows - Enabling Macros
		Note: The procedure is exactly the same for Excel 2010 and Excel 2013, even though the Excel 2013 has a slightly different look than these screenshots. 1. In the upper left corner of the Excel Ribbon, press the "File" tab.
		2. Select Options, in the lower left corner.
		3. Select Trust Center from the Lower Left. 4. Click the "Trust Center Settings…" button in the lower right
		5. Select "Macros Settings" from the left side menu 6. Select the "Disable all macros except digitally signed macros" radio button. 7. Click "OK" twice

&CYour Company Name

ERASE ME WelcomeMac


	Welcome to the Mac Version of Business Plan Financials
	Thank you for purchasing Planning Shop's Business Plan Financials. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, The Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. First, a few tips to get you started: You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIGINAL_PlanningShop_BusinessPlanFinancialsMac(2.7)" file in your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy. You installed the Mac version of the Business Plan Financials product, which does not have the Planning Shop tab available in the Excel Ribbon (unlike the Windows version). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
	Start with the "Setup" worksheet. Enter your data, and then work your way through the workbook, one worksheet at a time, by clicking the next worksheet to the right. There are 23 worksheets/charts in this workbook. The last one (furthest to the right) is "NS5Yr." Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically calculated for you.
	While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
	For more in-depth help and assistance, refer to the Business Plan Financials Help" PDF file in your PlanningShop folder. The document contains step-by-step instructions and includes a "Frequently Asked Questions" section. To get started, find the Excel worksheet listing (each worksheet is listed on a tab) along the bottom of the Excel window. Click on the "Setup" tab to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
	Version 2.7 Copyright © 2003-2012 Planning Shop

Welcome


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

MacVsWindows


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

Setup


Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
UPSCALE BEVERAGE
What month will you officially start your company?		January	$0.00
$40,908.00			$0.00
$2,015.00		2016
SALES ASSUMPTIONS
$70.00		Ten
	Ten
$30.00
Most businesses sell at least some of their products/services on credit (e.g., "net 30" as opposed to cash). What percentage of your sales will be made on credit?		25%
For sales you make on credit, what terms will you extend? In other30 words, how many days will pass from the date of sale to when you expect to be paid?		30
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
Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)?		$36
With health insurance and other benefits costing more each year, your plan should account for annual increases. How much do you estimate your benefit costs will increase each year?		5.00%
If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by?		3.50%
Approximately what percentage of each employee's salary or wages do you plan to set aside for payroll taxes?		15.00%
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of business? This will be the opening balance in your Cash Flow Statements.		$5,000
At approximately what rate do you expect to be taxed on your net income?		25.00%
If you will use an interest-bearing account for your banking, at what rate will you accrue interest?		1.00%

&CSetup & Assumptions

Page &P of &N

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.

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

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

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

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

If, for instance, your terms will be "Net 30," put 30 here. You may enter any number of days between 0 and 120.

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.

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.

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

SalesProj


Sales Projections			2016													2017													2018					2019					2020
	Assumptions		January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Product Line 1
Unit Volume		2.00%	1000	1020	1040	1061	1082	1104	1126	1149	1172	1195	1219	1243	13412	1268	1294	1319	1346	1373	1400	1428	1457	1486	1516	1546	1577	17010	4922	5224	5543	5883	21573	6243	6625	7030	7461	27359	34698
Unit Price		2.50%	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500		$1,538	$1,538	$1,538	$1,538	$1,538	$1,538	$1,538	$1,538	$1,538	$1,538	$1,538	$1,538		$1,576	$1,576	$1,576	$1,576		$1,615	$1,615	$1,615	$1,615		$1,656
Gross Sales			$1,500,000	$1,530,000	$1,560,600	$1,591,812	$1,623,648	$1,656,121	$1,689,244	$1,723,029	$1,757,489	$1,792,639	$1,828,492	$1,865,061	$20,118,135	$1,949,922	$1,988,920	$2,028,699	$2,069,273	$2,110,658	$2,152,871	$2,195,929	$2,239,847	$2,284,644	$2,330,337	$2,376,944	$2,424,483	$26,152,526	$7,757,491	$8,232,312	$8,736,195	$9,270,920	$33,996,919	$10,084,334	$10,701,576	$11,356,598	$12,051,713	$44,194,222	$57,450,183
(Commissions)	50.00%	15.00%	$112,500	$114,750	$117,045	$119,386	$121,774	$124,209	$126,693	$129,227	$131,812	$134,448	$137,137	$139,880	$1,508,860	$146,244	$149,169	$152,152	$155,195	$158,299	$161,465	$164,695	$167,989	$171,348	$174,775	$178,271	$181,836	$1,961,439	$581,812	$617,423	$655,215	$695,319	$2,549,769	$756,325	$802,618	$851,745	$903,878	$3,314,567	$4,308,764
(Returns and Allowances)		3.00%	$45,000.00	$45,900	$46,818.00	$47,754.36	$48,709.45	$49,683.64	$50,677.31	$51,690.86	$52,724.67	$53,779.17	$54,854.75	$55,951.84	$603,544	$58,497.65	$59,667.61	$60,860.96	$62,078.18	$63,319.74	$64,586.14	$65,877.86	$67,195.42	$68,539.32	$69,910.11	$71,308.31	$72,734.48	$784,576	$232,724.74	$246,969.36	$262,085.86	$278,127.61	$1,019,908	$302,530.03	$321,047.29	$340,697.95	$361,551.39	$1,325,827	$1,723,505.49
Net Sales			$1,342,500	$1,369,350	$1,396,737	$1,424,672	$1,453,165	$1,482,228	$1,511,873	$1,542,111	$1,572,953	$1,604,412	$1,636,500	$1,669,230	$18,005,730	$1,745,180	$1,780,084	$1,815,685	$1,851,999	$1,889,039	$1,926,820	$1,965,356	$2,004,663	$2,044,756	$2,085,652	$2,127,365	$2,169,912	$23,406,510	$6,942,955	$7,367,919	$7,818,895	$8,297,474	$30,427,243	$9,025,479	$9,577,911	$10,164,155	$10,786,283	$39,553,828	$51,417,914
(Cost of Goods Sold)		50.00%	$750,000.00	$765,000	$780,300	$795,906	$811,824	$828,061	$844,622	$861,514	$878,745	$896,319	$914,246	$932,531	$10,059,067	$974,961	$994,460	$1,014,349	$1,034,636	$1,055,329	$1,076,436	$1,097,964	$1,119,924	$1,142,322	$1,165,169	$1,188,472	$1,212,241	$13,076,263	$3,878,746	$4,116,156	$4,368,098	$4,635,460	$16,998,460	$5,042,167	$5,350,788	$5,678,299	$6,025,856	$22,097,111	$28,725,091
GROSS PROFIT			$592,500	$604,350	$616,437	$628,766	$641,341	$654,168	$667,251	$680,596	$694,208	$708,092	$722,254	$736,699	$7,946,663	$770,219	$785,623	$801,336	$817,363	$833,710	$850,384	$867,392	$884,740	$902,434	$920,483	$938,893	$957,671	$10,330,248	$3,064,209	$3,251,763	$3,450,797	$3,662,014	$13,428,783	$3,983,312	$4,227,123	$4,485,856	$4,760,427	$17,456,718	$22,692,822
Product Line 2
Unit Volume		2.00%	2000	2040	2081	2122	2165	2208	2252	2297	2343	2390	2438	2487	26824	2536.5	2587	2639	2692	2746	2800	2856	2914	2972	3031	3092	3154	34020	9845	10448	11087	11766	43145	12486	13250	14061	14922	54718	69396
Unit Price		2.50%	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700	$2,700		$2,768	$2,768	$2,768	$2,768	$2,768	$2,768	$2,768	$2,768	$2,768	$2,768	$2,768	$2,768		$2,837	$2,837	$2,837	$2,837		$2,908	$2,908	$2,908	$2,908		$2,980
Gross Sales			$5,400,000	$5,508,000	$5,618,160	$5,730,523	$5,845,134	$5,962,036	$6,081,277	$6,202,903	$6,326,961	$6,453,500	$6,582,570	$6,714,221	$72,425,285	$7,019,718	$7,160,113	$7,303,315	$7,449,381	$7,598,369	$7,750,336	$7,905,343	$8,063,450	$8,224,719	$8,389,213	$8,556,997	$8,728,137	$94,149,092	$27,926,969	$29,636,323	$31,450,303	$33,375,313	$122,388,909	$36,303,603	$38,525,674	$40,883,754	$43,386,166	$159,099,198	$206,820,658
(Commissions)	50.00%	15.00%	$0	$413,100	$421,362	$429,789	$438,385	$447,153	$456,096	$465,218	$474,522	$484,012	$493,693	$503,567	$0	$526,479	$537,008	$547,749	$558,704	$569,878	$581,275	$592,901	$604,759	$616,854	$629,191	$641,775	$654,610	$7,061,182	$2,094,523	$2,222,724	$2,358,773	$2,503,149	$9,179,168	$2,722,770	$2,889,426	$3,066,282	$3,253,962	$11,932,440	$15,511,549
(Returns and Allowances)		3.00%	$162,000	$165,240	$168,545	$171,916	$175,354	$178,861	$182,438	$186,087	$189,809	$193,605	$197,477	$201,427	$2,172,759	$210,592	$214,803	$219,099	$223,481	$227,951	$232,510	$237,160	$241,903	$246,742	$251,676	$256,710	$261,844	$2,824,473	$837,809	$889,090	$943,509	$1,001,259	$3,671,667	$1,089,108	$1,155,770	$1,226,513	$1,301,585	$4,772,976	$6,204,620
Net Sales			$0	$4,929,660	$5,028,253	$5,128,818	$5,231,395	$5,336,023	$5,442,743	$5,551,598	$5,662,630	$5,775,882	$5,891,400	$6,009,228	$0	$6,282,648	$6,408,301	$6,536,467	$6,667,196	$6,800,540	$6,936,551	$7,075,282	$7,216,788	$7,361,123	$7,508,346	$7,658,513	$7,811,683	$84,263,437	$24,994,637	$26,524,509	$28,148,021	$29,870,905	$109,538,073	$32,491,725	$34,480,478	$36,590,960	$38,830,619	$142,393,782	$185,104,489
(Cost of Goods Sold)		50.00%	$2,700,000	$2,754,000	$2,809,080	$2,865,262	$2,922,567	$2,981,018	$3,040,639	$3,101,451	$3,163,480	$3,226,750	$3,291,285	$3,357,111	$36,212,642	$3,509,859	$3,580,056	$3,651,657	$3,724,691	$3,799,184	$3,875,168	$3,952,671	$4,031,725	$4,112,359	$4,194,607	$4,278,499	$4,364,069	$47,074,546	$13,963,485	$14,818,162	$15,725,152	$16,687,657	$61,194,454	$18,151,802	$19,262,837	$20,441,877	$21,693,083	$79,549,599	$103,410,329
GROSS PROFIT			$0	$2,175,660	$2,219,173	$2,263,557	$2,308,828	$2,355,004	$2,402,104	$2,450,147	$2,499,149	$2,549,132	$2,600,115	$2,652,117	$0	$2,772,789	$2,828,245	$2,884,809	$2,942,506	$3,001,356	$3,061,383	$3,122,610	$3,185,063	$3,248,764	$3,313,739	$3,380,014	$3,447,614	$37,188,891	$11,031,153	$11,706,348	$12,422,870	$13,183,249	$48,343,619	$14,339,923	$15,217,641	$16,149,083	$17,137,536	$62,844,183	$81,694,160
Product Line 3
Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 4
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 5
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 6
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 7
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 8
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 9
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 10
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	0	0	0	0	0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0		$0	$0	$0	$0		$0
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Totals for All Product Lines
Total Unit Volume			3000	3060	3121	3184	3247	3312	3378	3446	3515	3585	3657	3730	40236	3805	3881	3958	4038	4118	4201	4285	4370	4458	4547	4638	4731	51029	14767	15671	16630	17648	64718	18729	19875	21091	22382	82077	104094
Total Gross Sales			$6,900,000	$7,038,000	$7,178,760	$7,322,335	$7,468,782	$7,618,158	$7,770,521	$7,925,931	$8,084,450	$8,246,139	$8,411,061	$8,579,283	$92,543,419	$8,969,640	$9,149,033	$9,332,014	$9,518,654	$9,709,027	$9,903,207	$10,101,272	$10,303,297	$10,509,363	$10,719,550	$10,933,941	$11,152,620	$120,301,618	$35,684,461	$37,868,635	$40,186,499	$42,646,234	$156,385,828	$46,387,938	$49,227,250	$52,240,352	$55,437,879	$203,293,419	$264,270,841
(Total Commissions)			$0	$527,850	$538,407	$549,175	$560,159	$571,362	$582,789	$594,445	$606,334	$618,460	$630,830	$643,446	$0	$672,723	$686,177	$699,901	$713,899	$728,177	$742,741	$757,595	$772,747	$788,202	$803,966	$820,046	$836,447	$9,022,621	$2,676,335	$2,840,148	$3,013,987	$3,198,468	$11,728,937	$3,479,095	$3,692,044	$3,918,026	$4,157,841	$15,247,006	$19,820,313
(Total Returns and Allowances)			$207,000	$211,140	$215,363	$219,670	$224,063	$228,545	$233,116	$237,778	$242,533	$247,384	$252,332	$257,378	$2,776,303	$269,089	$274,471	$279,960	$285,560	$291,271	$297,096	$303,038	$309,099	$315,281	$321,587	$328,018	$334,579	$3,609,049	$1,070,534	$1,136,059	$1,205,595	$1,279,387	$4,691,575	$1,391,638	$1,476,818	$1,567,211	$1,663,136	$6,098,803	$7,928,125
Total Net Sales			$0	$6,299,010	$6,424,990	$6,553,490	$6,684,560	$6,818,251	$6,954,616	$7,093,708	$7,235,583	$7,380,294	$7,527,900	$7,678,458	$0	$8,027,828	$8,188,384	$8,352,152	$8,519,195	$8,689,579	$8,863,371	$9,040,638	$9,221,451	$9,405,880	$9,593,997	$9,785,877	$9,981,595	$107,669,948	$31,937,592	$33,892,428	$35,966,916	$38,168,379	$139,965,316	$41,517,204	$44,058,389	$46,755,115	$49,616,902	$181,947,610	$236,522,403
(Total Cost of Goods Sold)			$3,450,000	$3,519,000	$3,589,380	$3,661,168	$3,734,391	$3,809,079	$3,885,260	$3,962,966	$4,042,225	$4,123,069	$4,205,531	$4,289,641	$46,271,710	$4,484,820	$4,574,516	$4,666,007	$4,759,327	$4,854,513	$4,951,604	$5,050,636	$5,151,649	$5,254,681	$5,359,775	$5,466,971	$5,576,310	$60,150,809	$17,842,230	$18,934,318	$20,093,249	$21,323,117	$78,192,914	$23,193,969	$24,613,625	$26,120,176	$27,718,940	$101,646,710	$132,135,421
TOTAL GROSS PROFIT			$0	$2,780,010	$2,835,610	$2,892,322	$2,950,169	$3,009,172	$3,069,356	$3,130,743	$3,193,358	$3,257,225	$3,322,369	$3,388,817	$0	$3,543,008	$3,613,868	$3,686,145	$3,759,868	$3,835,066	$3,911,767	$3,990,002	$4,069,802	$4,151,198	$4,234,222	$4,318,907	$4,405,285	$47,519,139	$14,095,362	$14,958,111	$15,873,667	$16,845,262	$61,772,402	$18,323,235	$19,444,764	$20,634,939	$21,897,962	$80,300,901	$104,386,982

&CSales Projections

Page &P of &N

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

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.

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.

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

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

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?

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

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.

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.

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.

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.

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"

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.

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.

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

Inventory


Inventory	2016													2017													2018					2019					2020
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	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	$750,000	$765,000	$780,300	$795,906	$811,824	$828,061	$844,622	$861,514	$878,745	$896,319	$914,246	$932,531	$10,059,067	$974,961	$994,460	$1,014,349	$1,034,636	$1,055,329	$1,076,436	$1,097,964	$1,119,924	$1,142,322	$1,165,169	$1,188,472	$1,212,241	$13,076,263	$3,878,746	$4,116,156	$4,368,098	$4,635,460	$16,998,460	$5,042,167	$5,350,788	$5,678,299	$6,025,856	$22,097,111	$28,725,091
Social media advertising	$50	$51	$52	$53	$54	$55	$56	$57	$59	$60	$61	$62	$671	$65	$66	$68	$69	$70	$72	$73	$75	$76	$78	$79	$81	$872	$259	$274	$291	$309	$1,133	$336	$357	$379	$402	$1,473	$1,915
Sale Agents	$15	$15	$16	$16	$16	$17	$17	$17	$18	$18	$18	$19	$201	$19	$20	$20	$21	$21	$22	$22	$22	$23	$23	$24	$24	$262	$78	$82	$87	$93	$340	$101	$107	$114	$121	$442	$575
Free samples	$70	$71	$73	$74	$76	$77	$79	$80	$82	$84	$85	$87	$939	$91	$93	$95	$97	$98	$100	$102	$105	$107	$109	$111	$113	$1,220	$362	$384	$408	$433	$1,587	$471	$499	$530	$562	$2,062	$2,681
Infomercial	$100	$102	$104	$106	$108	$110	$113	$115	$117	$120	$122	$124	$1,341	$130	$133	$135	$138	$141	$144	$146	$149	$152	$155	$158	$162	$1,744	$517	$549	$582	$618	$2,266	$672	$713	$757	$803	$2,946	$3,830
Total Inventory Expense	$235	$240	$244	$249	$254	$259	$265	$270	$275	$281	$286	$292	$3,152	$305	$312	$318	$324	$331	$337	$344	$351	$358	$365	$372	$380	$4,097	$1,215	$1,290	$1,369	$1,452	$5,326	$1,580	$1,677	$1,779	$1,888	$6,924	$9,001
Product Line 2
Cost of Goods Sold	$2,700,000	$2,754,000	$2,809,080	$2,865,262	$2,922,567	$2,981,018	$3,040,639	$3,101,451	$3,163,480	$3,226,750	$3,291,285	$3,357,111	$36,212,642	$3,509,859	$3,580,056	$3,651,657	$3,724,691	$3,799,184	$3,875,168	$3,952,671	$4,031,725	$4,112,359	$4,194,607	$4,278,499	$4,364,069	$47,074,546	$13,963,485	$14,818,162	$15,725,152	$16,687,657	$61,194,454	$18,151,802	$19,262,837	$20,441,877	$21,693,083	$79,549,599	$103,410,329
Social media advertising	$0	$48	$49	$50	$51	$52	$53	$54	$55	$56	$57	$59	$584	$61	$62	$64	$65	$66	$68	$69	$70	$72	$73	$75	$76	$820	$243	$258	$274	$291	$1,067	$316	$336	$356	$378	$1,386	$1,802
Sale Agents	$0	$25	$26	$26	$27	$27	$28	$28	$29	$29	$30	$30	$304	$32	$32	$33	$34	$34	$35	$36	$37	$37	$38	$39	$40	$427	$127	$135	$143	$151	$556	$165	$175	$186	$197	$722	$939
Free samples	$0	$45	$46	$47	$48	$49	$50	$51	$52	$53	$54	$55	$548	$57	$58	$60	$61	$62	$63	$65	$66	$67	$69	$70	$71	$769	$228	$242	$257	$273	$1,000	$297	$315	$334	$354	$1,300	$1,690
Infomercial	$0	$120	$122	$125	$127	$130	$132	$135	$138	$141	$143	$146	$1,460	$153	$156	$159	$162	$166	$169	$172	$176	$179	$183	$186	$190	$2,051	$608	$646	$685	$727	$2,666	$791	$839	$891	$945	$3,466	$4,506
Total Inventory Expense	$0	$238	$243	$248	$253	$258	$263	$268	$273	$279	$284	$290	$2,896	$303	$309	$316	$322	$328	$335	$342	$348	$355	$362	$370	$377	$4,068	$1,207	$1,281	$1,359	$1,442	$5,288	$1,569	$1,665	$1,767	$1,875	$6,875	$8,937
Product Line 3
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 4
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Product Line 5
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	$235	$478	$487	$497	$507	$517	$527	$538	$549	$560	$571	$582	$6,048	$609	$621	$633	$646	$659	$672	$686	$699	$713	$728	$742	$757	$8,165	$2,422	$2,570	$2,728	$2,895	$10,615	$3,149	$3,341	$3,546	$3,763	$13,798	$17,937

Page &P of &N

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.

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.

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

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"

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.

CapEx


Capital Purchases
Item	Cost	Purchase Date		Years of Service	Salvage Value
						Reminder: All purchases must be on or after your business start date of:
Facilities		Month	Year			December-2011
office lease	$300	Jan	2016	1	$0	0
shop lease	$250	Jan	2016	1	$0	0
warehouse	$240	Jan	2016	1	$0	0
	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)		Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Equipment
two computers	$500	Jan	2016	1	$30	0
blending machine	$320	Jan	2016	1	$12	0
juice extra	$240	Jan	2016	1	$10	0
computer software	$100	Jan	2016	1	$8	0
phones	$50	Jan	2016	1	$5	0
fax	$60	Jan	2016	1	$4	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Item Name (change name here)	$0	Jan	2016	1	$0	0
Computer Hardware/Software
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Telecommunications
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Item Name (change name here)	$0	Jan	2013	1	$0	0
Land
Item Name (change name here)	$0	Jan	2013	Land is a non-depreciable asset		0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0
Item Name (change name here)	$0	Jan	2013			0

&CCapital Purchases

Page &P of &N

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

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.

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

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.

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

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.

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.

Equipment includes machinery, furniture, vehicles, etc.

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

Land purchases are not depreciable.

Telecommunications includes phone systems, fax machines, etc.

StaffBudj


Staffing Budget	2016													2017													2018					2019					2020
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	TOTAL
Management
# Salaried Employees	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00		500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00	500.00		500.00	500.00	500.00	500.00		500.00	500.00	500.00	500.00		500.00
Avg Salary per employee	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$3,000	$259	$259	$259	$259	$259	$259	$259	$259	$259	$259	$259	$259	$3,105	$803	$803	$803	$803	$3,214	$832	$832	$832	$832	$3,326	$3,443
Benefits (across all employees)	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$208,333	$2,500,000	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$218,750	$2,625,000	$689,063	$689,063	$689,063	$689,063	$2,756,250	$723,516	$723,516	$723,516	$723,516	$2,894,063	$3,038,766
Payroll Taxes (across all employees)	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$18,750	$225,000	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$19,406	$232,875	$60,256	$60,256	$60,256	$60,256	$241,026	$62,365	$62,365	$62,365	$62,365	$249,462	$258,193
Total Costs	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$352,083	$4,225,000	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$367,531	$4,410,375	$1,151,028	$1,151,028	$1,151,028	$1,151,028	$4,604,113	$1,201,650	$1,201,650	$1,201,650	$1,201,650	$4,806,601	$5,018,243
Administrative/Support
# Salaried Employees	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00		400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00	400.00		400.00	400.00	400.00	400.00		400.00	400.00	400.00	400.00		400.00
Avg Salary per employee	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400	$207	$207	$207	$207	$207	$207	$207	$207	$207	$207	$207	$207	$2,484	$643	$643	$643	$643	$2,571	$665	$665	$665	$665	$2,661	$2,754
Benefits (across all employees)	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$166,667	$2,000,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$175,000	$2,100,000	$551,250	$551,250	$551,250	$551,250	$2,205,000	$578,813	$578,813	$578,813	$578,813	$2,315,250	$2,431,013
Payroll Taxes (across all employees)	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$144,000	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$12,420	$149,040	$38,564	$38,564	$38,564	$38,564	$154,256	$39,914	$39,914	$39,914	$39,914	$159,655	$165,243
Total Costs	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$258,667	$3,104,000	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$270,220	$3,242,640	$846,908	$846,908	$846,908	$846,908	$3,387,632	$884,819	$884,819	$884,819	$884,819	$3,539,275	$3,697,878
Sales/Marketing	$380.00
# Salaried Employees	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00		180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00	180.00		180.00	180.00	180.00	180.00		180.00	180.00	180.00	180.00		180.00
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$900,000	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$945,000	$248,063	$248,063	$248,063	$248,063	$992,250	$260,466	$260,466	$260,466	$260,466	$1,041,863	$1,093,956
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	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$75,000	$900,000	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$78,750	$945,000	$248,063	$248,063	$248,063	$248,063	$992,250	$260,466	$260,466	$260,466	$260,466	$1,041,863	$1,093,956
Operations/Production
# Salaried Employees	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00		350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00	350.00		350.00	350.00	350.00	350.00		350.00	350.00	350.00	350.00		350.00
Avg Salary per employee	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$155	$155	$155	$155	$155	$155	$155	$155	$155	$155	$155	$155	$1,863	$482	$482	$482	$482	$1,928	$499	$499	$499	$499	$1,996	$2,066
Benefits (across all employees)	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$145,833	$1,750,000	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$153,125	$1,837,500	$482,344	$482,344	$482,344	$482,344	$1,929,375	$506,461	$506,461	$506,461	$506,461	$2,025,844	$2,127,136
Payroll Taxes (across all employees)	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$7,875	$94,500	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$8,151	$97,808	$25,308	$25,308	$25,308	$25,308	$101,231	$26,193	$26,193	$26,193	$26,193	$104,774	$108,441
Total Costs	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$206,208	$2,474,500	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$215,613	$2,587,358	$676,369	$676,369	$676,369	$676,369	$2,705,478	$707,277	$707,277	$707,277	$707,277	$2,829,110	$2,958,516
Other
# Salaried Employees	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00		300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00	300.00		300.00	300.00	300.00	300.00		300.00	300.00	300.00	300.00		300.00
Avg Salary per employee	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200	$104	$104	$104	$104	$104	$104	$104	$104	$104	$104	$104	$104	$1,242	$321	$321	$321	$321	$1,285	$333	$333	$333	$333	$1,330	$1,377
Benefits (across all employees)	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$125,000	$1,500,000	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$131,250	$1,575,000	$413,438	$413,438	$413,438	$413,438	$1,653,750	$434,109	$434,109	$434,109	$434,109	$1,736,438	$1,823,259
Payroll Taxes (across all employees)	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$4,500	$54,000	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$4,658	$55,890	$14,462	$14,462	$14,462	$14,462	$57,846	$14,968	$14,968	$14,968	$14,968	$59,871	$61,966
Total Costs	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$159,500	$54,000	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$166,958	$2,003,490	$524,309	$524,309	$524,309	$524,309	$2,097,237	$548,862	$548,862	$548,862	$548,862	$2,195,447	$2,298,334
Part-Time / Hourly Employees
# Part-Time Employees	50	50	50	50	50	50	50	50	50	50	50	50		50	50	50	50	50	50	50	50	50	50	50	50		50	50	50	50		50	50	50	50		50
Avg. Hours per Hourly Employee	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0		4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0	4.0		12.0	12.0	12.0	12.0		12.0	12.0	$12.00	$12.00		48.0
Avg Hourly Rate	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00		$5.18	$5.18	$5.18	$5.18	$5.18	$5.18	$5.18	$5.18	$5.18	$5.18	$5.18	$5.18		$5.36	$5.36	$5.36	$5.36		$5.54	$5.54	$5.54	$5.54		$5.74
Calculated Wages Per Hourly Employee	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$240	$21	$21	$21	$21	$21	$21	$21	$21	$21	$21	$21	$21	$248	$64	$64	$64	$64	$257	$67	$67	$67	$67	$266	$275
Wages	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$12,000	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$12,420	$3,214	$3,214	$3,214	$3,214	$12,855	$3,326	$3,326	$3,326	$3,326	$13,305	$1,580
Benefits (across all employees)	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$158	$158	$158	$158	$158	$158	$158	$158	$158	$158	$158	$158	$1,890	$496	$496	$496	$496	$1,985	$521	$521	$521	$521	$2,084	$2,188
Payroll Taxes (across all employees)	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$155	$155	$155	$155	$155	$155	$155	$155	$155	$155	$155	$155	$1,863	$482	$482	$482	$482	$1,928	$499	$499	$499	$499	$1,996	$2,066
Total Costs	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$1,300	$15,600	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$1,348	$16,173	$4,192	$4,192	$4,192	$4,192	$16,767	$4,346	$4,346	$4,346	$4,346	$17,384	$5,834
TOTAL
# Full Time Employees	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730		1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730	1,730		1,730	1,730	1,730	1,730		1,730	1,730	1,730	1,730		1,730
# Part-Time Employees	50	50	50	50	50	50	50	50	50	50	50	50		50	50	50	50	50	50	50	50	50	50	50	50		50	50	50	50		50	50	50	50		50
Salary/Wages	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$3,462,000	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$3,583,170	$927,145	$927,145	$927,145	$927,145	$3,708,581	$959,595	$959,595	$959,595	$959,595	$3,838,381	$3,960,535
Benefits	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$8,651,800	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$9,084,390	$2,384,652	$2,384,652	$2,384,652	$2,384,652	$9,538,610	$2,503,885	$2,503,885	$2,503,885	$2,503,885	$10,015,540	$10,516,317
Payroll Taxes	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$519,300	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$537,476	$139,072	$139,072	$139,072	$139,072	$556,287	$143,939	$143,939	$143,939	$143,939	$575,757	$595,909
GRAND TOTAL COSTS	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$1,052,758	$12,633,100	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$1,100,420	$13,205,036	$3,450,869	$3,450,869	$3,450,869	$3,450,869	$13,803,478	$3,607,420	$3,607,420	$3,607,420	$3,607,420	$14,429,678	$15,072,760

&CStaffing Budget

Page &P of &N

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

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

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

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

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

This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.

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

MktBudj

	For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates from PlanningShop.
Marketing Budget	2016													2017													2018					2019					2020
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Professional Assistance
Marketing/PR Consultants	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$600	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$600	$150	$150	$150	$150	$600	$150	$150	$150	$150	$600	$600
Advertising Agencies	$30	$30	$30	$30	$30	$30	$30	$30	$30	$30	$30	$30	$360	$30	$30	$30	$30	$30	$30	$30	$30	$30	$30	$30	$30	$360	$90	$90	$90	$90	$360	$90	$90	$90	$90	$360	$360
Social Media Specialists	$18	$18	$18	$18	$18	$18	$18	$18	$18	$18	$18	$18	$216	$18	$18	$18	$18	$18	$18	$18	$18	$18	$18	$18	$18	$216	$54	$54	$54	$54	$216	$54	$54	$54	$54	$216	$216
SEO Specialist	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$240	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$240	$60	$60	$60	$60	$240	$60	$60	$60	$60	$240	$240
Graphic/Web Design	$25	$25	$25	$25	$25	$25	$25	$25	$25	$25	$25	$25	$300	$25	$25	$25	$25	$25	$25	$25	$25	$25	$25	$25	$25	$300	$75	$75	$75	$75	$300	$75	$75	$75	$75	$300	$300
Brochures/Leaflets/Flyers	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$120	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$120	$30	$30	$30	$30	$120	$30	$30	$30	$30	$120	$120
Signs/Billboards	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$240	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$20	$240	$60	$60	$60	$60	$240	$60	$60	$60	$60	$240	$240
Merchandising Displays	$26	$26	$26	$26	$26	$26	$26	$26	$26	$26	$26	$26	$312	$26	$26	$26	$26	$26	$26	$26	$26	$26	$26	$26	$26	$312	$78	$78	$78	$78	$312	$78	$78	$78	$78	$312	$312
Sampling/Premiums	$12	$12	$12	$12	$12	$12	$12	$12	$12	$12	$12	$12	$144	$12	$12	$12	$12	$12	$12	$12	$12	$12	$12	$12	$12	$144	$36	$36	$36	$36	$144	$36	$36	$36	$36	$144	$144
Media Advertising
Print (newspaper, etc.)	$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
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	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400	$600	$600	$600	$600	$2,400	$600	$600	$600	$600	$2,400	$2,400
Other Media	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200	$1,800	$1,800	$1,800	$1,800	$7,200	$1,800	$1,800	$1,800	$1,800	$7,200	$7,200
Phone Directories	$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
Advertising Specialties	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200	$1,800	$1,800	$1,800	$1,800	$7,200	$1,800	$1,800	$1,800	$1,800	$7,200	$7,200
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	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$450	$450	$450	$450	$1,800	$450	$450	$450	$450	$1,800	$1,800
Development/Programming	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$1,440	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$1,440	$360	$360	$360	$360	$1,440	$360	$360	$360	$360	$1,440	$1,440
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	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$150	$1,800	$450	$450	$450	$450	$1,800	$450	$450	$450	$450	$1,800	$1,800
Travel/Shipping	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$10,800	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$10,800	$2,700	$2,700	$2,700	$2,700	$10,800	$2,700	$2,700	$2,700	$2,700	$10,800	$10,800
Exhibits/Signs	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$12,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$12,000	$3,000	$3,000	$3,000	$3,000	$12,000	$3,000	$3,000	$3,000	$3,000	$12,000	$12,000
Public Relations/Materials	$40	$40	$40	$40	$40	$40	$40	$40	$40	$40	$40	$40	$480	$40	$40	$40	$40	$40	$40	$40	$40	$40	$40	$40	$40	$480	$120	$120	$120	$120	$480	$120	$120	$120	$120	$480	$480
Informal Marketing / Networking	$60	$60	$60	$60	$60	$60	$60	$60	$60	$60	$60	$60	$720	$60	$60	$60	$60	$60	$60	$60	$60	$60	$60	$60	$60	$720	$180	$180	$180	$180	$720	$180	$180	$180	$180	$720	$720
Memberships/Meetings	$55	$55	$55	$55	$55	$55	$55	$55	$55	$55	$55	$55	$660	$55	$55	$55	$55	$55	$55	$55	$55	$55	$55	$55	$55	$660	$165	$165	$165	$165	$660	$165	$165	$165	$165	$660	$660
Entertainment	$35	$35	$35	$35	$35	$35	$35	$35	$35	$35	$35	$35	$420	$35	$35	$35	$35	$35	$35	$35	$35	$35	$35	$35	$35	$420	$105	$105	$105	$105	$420	$105	$105	$105	$105	$420	$420
Other	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$600	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$50	$600	$150	$150	$150	$150	$600	$150	$150	$150	$150	$600	$600
GRAND TOTAL COSTS	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$69,252	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$69,252	$17,313	$17,313	$17,313	$17,313	$69,252	$17,313	$17,313	$17,313	$17,313	$69,252	$69,252

&CMarketing Budget

Page &P of &N

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

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

ProSvs


Professional Services	2016	2017	2018	2019	2020
General
Attorneys	$300	$300	$300	$300	$300
Accountants	$150	$150	$150	$150	$150
Management consultants	$200	$200	$200	$200	$200
Industry specialists	$200	$200	$200	$200	$200
Technology consultants	$200	$200	$200	$200	$200
Other (change title here)	$150	$150	$150	$150	$150
Other (change title here)	$100	$100	$100	$100	$100
Total Costs	$1,300	$1,300	$1,300	$1,300	$1,300
GRAND TOTAL COSTS	$1,300	$1,300	$1,300	$1,300	$1,300

&CProfessional Services Budget

Page &P of &N

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

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

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

CapInvest


Capital Investments and Loans
Item	Amount	Date		Loan Period	Interest Rate
				$500.00	$2.50	Reminder: All invesments & loans must be on or after your business start date of:
Equity Capital Investments		Month	Year			December-2011
Ordinally share capital	$5,000	Jan	2016	Capital investments are not paid back on a loan schedule.		$0.00
Preference shares	$3,000	Jan	2016			$0.00
Debentures	$2,000	Jan	2016			$0.00
						$5,000.00
						$5,000.00
						$5,000.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
Total Capital Investments	$10,000
Loans
Citi Bank	$120	Jan	2016	12	0.00%	$0.00
Standard Chartered	$500	Jan	2016	12	0.00%	$0.00
Morgan and Chase	$400	Jan	2016	12	0.00%	$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$0.00
						$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 Loans	$1,020
TOTAL INVESTMENTS AND LOANS	$11,020

&CCapital Investments and Loans

Page &P of &N

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

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.

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.

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.

Enter the year you will receive the investment cash.

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.

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

Enter the loan's annual interest rate.

Loan period is in NUMBER OF MONTHS

Enter the loan's annual interest rate.

IncSt


Income Statements	2016														2017														2018						2019						2020
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
INCOME
Gross Sales	$6,900,000	$7,038,000	$7,178,760	$7,322,335	$7,468,782	$7,618,158	$7,770,521	$7,925,931	$8,084,450	$8,246,139	$8,411,061	$8,579,283	$92,543,419		$8,969,640	$9,149,032.89	$9,332,014	$9,518,654	$9,709,027	$9,903,207	$10,101,272	$10,303,297	$10,509,363	$10,719,550	$10,933,941	$11,152,620	$120,301,618		$35,684,461	$37,868,635	$40,186,499	$42,646,234	$156,385,828		$46,387,938	$49,227,250	$52,240,352	$55,437,879	$203,293,419		$264,270,841
(Commissions)	$0	$527,850	$538,407	$549,175	$560,159	$571,362	$582,789	$594,445	$606,334	$618,460	$630,830	$643,446	$32,500,400	$37,308,224	$672,723	$686,177.47	$699,901	$713,899	$728,177	$742,741	$757,595	$772,747	$788,202	$803,966	$820,046	$836,447	$9,022,621		$2,676,335	$2,840,148	$3,013,987	$3,198,468	$11,728,937		$3,479,095	$3,692,044	$3,918,026	$4,157,841	$15,247,006		$19,820,313
(Returns and allowances)	$207,000	$211,140	$215,363	$219,670	$224,063	$228,545	$233,116	$237,778	$242,533	$247,384	$252,332	$257,378	$2,776,303		$269,089	$274,470.99	$279,960	$285,560	$291,271	$297,096	$303,038	$309,099	$315,281	$321,587	$328,018	$334,579	$3,609,049		$1,070,534	$1,136,059	$1,205,595	$1,279,387	$4,691,575		$1,391,638	$1,476,818	$1,567,211	$1,663,136	$6,098,803		$7,928,125
Net Sales	$0	$6,299,010	$6,424,990	$6,553,490	$6,684,560	$6,818,251	$6,954,616	$7,093,708	$7,235,583	$7,380,294	$7,527,900	$7,678,458	$35,415,600		$8,027,828	$8,188,384.44	$8,352,152	$8,519,195	$8,689,579	$8,863,371	$9,040,638	$9,221,451	$9,405,880	$9,593,997	$9,785,877	$9,981,595	$107,669,948		$31,937,592	$33,892,428	$35,966,916	$38,168,379	$139,965,316		$41,517,204	$44,058,389	$46,755,115	$49,616,902	$181,947,610		$236,522,403
(Cost of Goods)	$3,450,000	$3,519,000	$3,589,380	$3,661,168	$3,734,391	$3,809,079	$3,885,260	$3,962,966	$4,042,225	$4,123,069	$4,205,531	$4,289,641	$46,271,710		$4,484,820	$4,574,516.45	$4,666,007	$4,759,327	$4,854,513	$4,951,604	$5,050,636	$5,151,649	$5,254,681	$5,359,775	$5,466,971	$5,576,310	$60,150,809		$17,842,230	$18,934,318	$20,093,249	$21,323,117	$78,192,914		$23,193,969	$24,613,625	$26,120,176	$27,718,940	$101,646,710		$132,135,421
GROSS PROFIT	$0	$2,780,010	$2,835,610	$2,892,322	$2,950,169	$3,009,172	$3,069,356	$3,130,743	$3,193,358	$3,257,225	$3,322,369	$3,388,817	$51,654,525		$3,543,008	$3,613,867.99	$3,686,145	$3,759,868	$3,835,066	$3,911,767	$3,990,002	$4,069,802	$4,151,198	$4,234,222	$4,318,907	$4,405,285	$47,519,139		$14,095,362	$14,958,111	$15,873,667	$16,845,262	$61,772,402		$18,323,235	$19,444,764	$20,634,939	$21,897,962	$80,300,901		$104,386,982
EXPENSES - General and Administrative
Salaries and wages	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$288,500	$3,462,000		$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$298,598	$3,583,170		$927,145	$927,145	$927,145	$927,145	$3,708,581		$959,595	$959,595	$959,595	$959,595	$3,838,381		$3,960,535
Employee benefits	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$720,983	$8,651,800		$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$757,033	$9,084,390		$2,384,652	$2,384,652	$2,384,652	$2,384,652	$9,538,610		$2,503,885	$2,503,885	$2,503,885	$2,503,885	$10,015,540		$10,516,317
Payroll taxes	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$43,275	$519,300		$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$44,790	$537,476		$139,072	$139,072	$139,072	$139,072	$556,287		$143,939	$143,939	$143,939	$143,939	$575,757		$595,909
Professional services	$108	$108	$108	$108	$108	$108	$108	$108	$108	$108	$108	$108	$1,300		$108	$108	$108	$108	$108	$108	$108	$108	$108	$108	$108	$108	$1,300		$325	$325	$325	$325	$1,300		$325	$325	$325	$325	$1,300		$1,300
Marketing and advertising	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$69,252		$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$5,771	$69,252		$17,313	$17,313	$17,313	$17,313	$69,252		$17,313	$17,313	$17,313	$17,313	$69,252		$69,252
Rent	$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
Equipment rental	$700	$700	$700	$700	$700	$700	$700	$700	$700	$700	$700	$700	$8,400		$700	$700	$700	$700	$700	$700	$700	$700	$700	$700	$700	$700	$8,400		$2,100	$2,100	$2,100	$2,100	$8,400		$2,100	$2,100	$2,100	$2,100	$8,400		$8,400
Maintenance	$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
Depreciation	$560	$20	$100	$200	$300	$150	$140	$180	$220	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250
Insurance	$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
Telephone service	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200		$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200		$1,800	$1,800	$1,800	$1,800	$7,200		$1,800	$1,800	$1,800	$1,800	$7,200		$7,200
Utilities	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400		$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400		$600	$600	$600	$600	$2,400		$600	$600	$600	$600	$2,400		$2,400
Office supplies	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200		$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200		$1,800	$1,800	$1,800	$1,800	$7,200		$1,800	$1,800	$1,800	$1,800	$7,200		$7,200
Postage and shipping	$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
Travel	$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
Entertainment	$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
Interest on loans	$100	$120	$100	$150	$200	$140	$130	$0	$0	$0	$0	$0	$940		$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
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	$1,064,298	$1,063,778	$1,063,838	$1,063,988	$1,064,138	$1,063,928	$1,063,908	$1,063,818	$1,063,858	$1,063,888	$1,063,888	$1,063,888	$12,764,842		$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$1,111,549	$13,335,838		$3,483,757	$3,483,757	$3,483,757	$3,483,757	$13,934,280		$3,640,308	$3,640,308	$3,640,308	$3,640,308	$14,560,480		$15,203,562
Net income before taxes	$1,840,095	$1,716,232	$1,771,773	$1,828,335	$1,886,031	$1,945,245	$2,005,448	$2,066,925	$2,129,500	$2,193,337	$2,258,482	$2,324,929	$22,067,684		$2,431,459	$2,502,319	$2,574,596	$2,648,319	$2,723,517	$2,800,218	$2,878,453	$2,958,253	$3,039,649	$3,122,673	$3,207,358	$3,293,736	$34,183,302		$10,611,605	$11,474,353	$12,389,910	$13,361,505	$47,838,122		$14,682,928	$15,804,456	$16,994,631	$18,257,655	$65,740,420		$89,183,420
Provision for taxes on income	$2,959,207	$429,058	$442,943	$457,084	$471,508	$486,311	$501,362	$516,731	$532,375	$548,334	$564,620	$581,232	$35,483,568		$607,865	$625,580	$643,649	$662,080	$680,879	$700,054	$719,613	$739,563	$759,912	$780,668	$801,839	$823,434	$8,545,825		$2,652,901	$2,868,588	$3,097,477	$3,340,376	$11,959,531		$3,670,732	$3,951,114	$4,248,658	$4,564,414	$16,435,105		$22,295,855
NET PROFIT	$5,875,140	$1,287,174	$1,328,829	$1,371,251	$1,414,523	$1,458,933	$1,504,086	$1,550,194	$1,597,125	$1,645,003	$1,693,861	$1,743,697	$70,447,836		$1,823,594	$1,876,739	$1,930,947	$1,986,239	$2,042,638	$2,100,163	$2,158,840	$2,218,690	$2,279,737	$2,342,005	$2,405,518	$2,470,302	$25,637,476		$7,958,703	$8,605,765	$9,292,432	$10,021,129	$35,878,592		$11,012,196	$11,853,342	$12,745,974	$13,693,241	$49,305,315		$66,887,565

&CIncome Statements

Page &P of &N

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

CshFlw


Cash Flow	2016													2017													2018						2019					2020
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	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	$5,175,000	$5,278,500	$5,384,070	$5,491,751	$5,601,586	$5,713,618	$5,827,891	$5,944,448	$6,063,337	$6,184,604	$6,308,296	$6,434,462	$69,407,564	$6,727,230	$6,861,775	$6,999,010	$7,138,990	$7,281,770	$7,427,406	$7,575,954	$7,727,473	$7,882,022	$8,039,663	$8,200,456	$8,364,465	$90,226,213	$26,763,345	$28,401,476	$30,139,874	$31,984,675	$117,289,371		$34,790,953	$36,920,438	$39,180,264	$41,578,410	$152,470,064	$198,203,131
Collections	$0	$1,725,000	$1,759,500	$1,794,690	$1,830,584	$1,867,195	$1,904,539	$1,942,630	$1,981,483	$2,021,112	$2,061,535	$2,102,765	$20,991,034	$2,144,821	$2,242,410	$2,287,258	$2,333,003	$2,379,663	$2,427,257	$2,475,802	$2,525,318	$2,575,824	$2,627,341	$2,679,888	$2,733,485	$29,432,070	$8,735,565	$9,285,144	$9,853,469	$10,456,581	$38,330,759		$11,285,176	$12,070,203	$12,808,996	$13,593,009	$49,757,384	$65,181,891
Total Cash from Sales	$5,175,000	$7,003,500	$7,143,570	$7,286,441	$7,432,170	$7,580,814	$7,732,430	$7,887,079	$8,044,820	$8,205,716	$8,369,831	$8,537,227	$90,398,598	$8,872,051	$9,104,185	$9,286,268	$9,471,994	$9,661,434	$9,854,662	$10,051,756	$10,252,791	$10,457,846	$10,667,003	$10,880,343	$11,097,950	$119,658,283	$35,498,911	$37,686,621	$39,993,343	$42,441,256	$155,620,130		$46,076,129	$48,990,641	$51,989,260	$55,171,419	$202,227,449	$263,385,022
Income from Financing
Interest Income	$1,200	$900	$700	$800	$750	$600	$700	$800	$850	$650	$750	$350	$9,050	$700	$800	$850	$650	$750	$350	$15,750	$107,768	$114,726	$121,807	$129,086	$136,180	$629,417	$478,647	$544,073	$614,606	$688,435	$2,325,761		$768,509	$860,428	$962,540	$1,074,818	$3,666,296	$6,444,213
Loan Proceeds	$1,020	$150	$120	$140	$100	$90	$50	$70	$60	$180	$50	$40	$2,070	$80	$70	$80	$60	$50	$40	$30	$20	$10	$15	$20	$30	$505	$315	$250	$400	$450	$1,415		$400	$260	$270	$200	$1,130	$5,466,541
Equity Capital Investments	$10,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$10,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$200	$250	$350	$400	$110	$130	$150	$180	$200	$180	$130	$140	$140	$120	$200	$5,454,565
Total Cash from Financing	$12,220	$1,050	$820	$940	$850	$690	$750	$870	$910	$830	$800	$390	$21,120	$780	$870	$930	$710	$800	$390	$15,780	$107,788	$114,736	$122,022	$129,356	$136,560	$630,722	$479,072	$544,453	$615,156	$689,065	$2,327,746		$769,039	$860,828	$962,950	$1,075,138	$3,667,956	$17,365,319
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	$120	$130	$110	$360	$500	$600	$450	$250	$1,800		$120	$150	$400	$350	$1,020	$4,565,525
TOTAL CASH RECEIPTS	$5,187,220	$7,004,550	$7,144,390	$7,287,381	$7,433,020	$7,581,504	$7,733,180	$7,887,949	$8,045,730	$8,206,546	$8,370,631	$8,537,617	$90,419,718	$8,872,831	$9,105,055	$9,287,198	$9,472,704	$9,662,234	$9,855,052	$10,067,536	$10,360,578	$10,572,582	$10,789,145	$11,009,829	$11,234,621	$120,289,365	$35,978,482	$38,231,673	$40,608,950	$43,130,571	$157,949,677		$46,845,288	$49,851,619	$52,952,611	$56,246,907	$205,896,425	$285,315,866
CASH DISBURSEMENTS
Inventory	$235	$478	$487	$497	$507	$517	$527	$538	$549	$560	$571	$582	$6,048	$609	$621	$633	$646	$659	$672	$686	$699	$713	$728	$742	$757	$8,165	$2,422	$2,570	$2,728	$2,895	$10,615		$3,149	$3,341	$3,546	$3,763	$13,798	$17,365,319
Operating Expenses	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$1,063,638	$12,763,652	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$1,111,299	$13,335,588	$3,483,507	$3,483,507	$3,483,507	$3,483,507	$13,934,030		$3,640,058	$3,640,058	$3,640,058	$3,640,058	$14,560,230	$15,203,312
Commissions/Returns & Allowances	$40	$738,990	$753,770	$768,845	$784,222	$799,907	$815,905	$832,223	$848,867	$865,845	$883,161	$900,825	$8,992,599	$941,812	$960,648	$979,861	$999,459	$1,019,448	$1,039,837	$1,060,634	$1,081,846	$1,103,483	$1,125,553	$1,148,064	$1,171,025	$12,631,670	$3,746,868	$3,976,207	$4,219,582	$4,477,855	$16,420,512		$4,870,733	$5,168,861	$5,485,237	$5,820,977	$21,345,809	$27,748,438
Capital Purchases	$2,060	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$2,060	$0	$0	$0	$0	$0	$0	$0	$0	$0	$45,000	$2,500	$5,400	$11,400,200	$354,565	$4,521,253	$2,506,575	$3,355,636	$1,531,323		$5,355,236	$3,524,255	$2,541,452	$1,122,451	$12,543,394	$3,524,525
Loan Payments	$85	$85	$85	$85	$85	$85	$85	$85	$85	$85	$85	$85	$1,020	$0	$0	$0	$0	$0	$0	$0	$0	$0	$2,000	$5,200	$425,550	$32,554	$6,542	$12,224	$2,112,450	$2,205,125	$4,336,341		$866,543	$655,313	$335,332	$636,223	$5,553,333	$14,222,550
Income Tax Payments	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$120	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$10	$120	$30	$30	$30	$30	$120		$30	$30	$30	$30	$120	$120
Investor Dividend Payments	$5	$5	$5	$5	$5	$5	$5	$5	$5	$5	$5	$5	$60	$5	$5	$5	$5	$5	$5	$5	$5	$5	$5	$5	$5	$60	$15	$15	$15	$15	$60		$15	$15	$15	$15	$60	$60
Owner's Draw	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$180	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$15	$180	$45	$45	$45	$45	$180		$45	$45	$45	$45	$180	$180
TOTAL CASH DISBURSEMENTS	$15	$1,803,220	$1,818,010	$1,833,095	$1,848,482	$1,864,176	$1,880,185	$1,896,513	$1,913,169	$1,930,157	$1,947,485	$1,965,160	$20,699,666	$2,053,750	$2,072,598	$2,091,824	$2,111,434	$2,131,436	$2,151,838	$2,172,648	$2,193,874	$2,215,525	$2,284,609	$2,267,835	$2,714,061	$26,461,433	$7,593,995	$11,995,851	$12,324,932	$13,525,108	$45,439,886		$14,735,809	$12,991,918	$12,005,714	$11,223,562	$50,957,003	$60,672,063
NET CASH FLOW	$5,187,205	$5,201,330	$5,326,380	$5,454,287	$5,584,539	$5,717,327	$5,852,995	$5,991,435	$6,132,561	$6,276,390	$6,423,146	$6,572,458	$69,720,052	$6,819,081	$7,032,456	$7,195,375	$7,361,270	$7,530,798	$7,703,214	$7,894,887	$8,166,704	$8,357,057	$8,504,536	$8,741,994	$8,520,560	$93,827,932	$28,384,488	$26,235,822	$28,284,017	$29,605,464	$112,509,790		$32,109,479	$36,859,701	$40,946,896	$45,023,345	$154,939,422	$224,643,803
Opening Cash Balance	$5,000	$5,192,205	$10,393,535	$15,719,915	$21,174,201	$26,758,740	$32,476,067	$38,329,062	$44,320,498	$50,453,059	$56,729,449	$63,152,594		$69,725,052	$76,544,133	$83,576,589	$90,771,964	$98,133,234	$105,664,032	$113,367,246	$121,262,134	$129,428,837	$137,785,894	$146,290,430	$155,032,425		$163,552,985	$191,937,472	$218,173,294	$246,457,311			$276,062,775	$308,172,254	$345,031,956	$385,978,852		$431,002,197
Cash Receipts	$5,187,220	$7,004,550	$7,144,390	$7,287,381	$7,433,020	$7,581,504	$7,733,180	$7,887,949	$8,045,730	$8,206,546	$8,370,631	$8,537,617		$8,872,831	$9,105,055	$9,287,198	$9,472,704	$9,662,234	$9,855,052	$10,067,536	$10,360,578	$10,572,582	$10,789,145	$11,009,829	$11,234,621		$35,978,482	$38,231,673	$40,608,950	$43,130,571			$46,845,288	$49,851,619	$52,952,611	$56,246,907		$285,315,866
Cash Disbursements	$15	$1,803,220	$1,818,010	$1,833,095	$1,848,482	$1,864,176	$1,880,185	$1,896,513	$1,913,169	$1,930,157	$1,947,485	$1,965,160		$2,053,750	$2,072,598	$2,091,824	$2,111,434	$2,131,436	$2,151,838	$2,172,648	$2,193,874	$2,215,525	$2,284,609	$2,267,835	$2,714,061		$7,593,995	$11,995,851	$12,324,932	$13,525,108			$14,735,809	$12,991,918	$12,005,714	$11,223,562		$60,672,063
ENDING CASH BALANCE	$5,192,205	$10,393,535	$15,719,915	$21,174,201	$26,758,740	$32,476,067	$38,329,062	$44,320,498	$50,453,059	$56,729,449	$63,152,594	$69,725,052	$69,725,052	$76,544,133	$83,576,589	$90,771,964	$98,133,234	$105,664,032	$113,367,246	$121,262,134	$129,428,837	$137,785,894	$146,290,430	$155,032,425	$163,552,985	$163,552,985	$191,937,472	$218,173,294	$246,457,311	$276,062,775	$276,062,775		$308,172,254	$345,031,956	$385,978,852	$431,002,197	$431,002,197	$656,320,094

&CCash Flow Statements

Page &P of &N

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

This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.

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

BalSht


Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet
UPSCALE BEVERAGE				UPSCALE BEVERAGE				UPSCALE BEVERAGE				UPSCALE BEVERAGE				UPSCALE BEVERAGE				UPSCALE BEVERAGE				UPSCALE BEVERAGE				UPSCALE BEVERAGE
First Quarter				Second Quarter				Third Quarter				Fourth Quarter				2017				2018				2019				2020
2016				2016				2016				2016
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	$15,719,915			Cash	$32,476,067			Cash	$50,453,059			Cash	$69,725,052			Cash	$163,552,985			Cash	$276,062,775			Cash	$431,002,197			Cash	$656,320,094
Accounts Receivable	$1,794,690			Accounts Receivable	$1,904,539			Accounts Receivable	$2,021,112			Accounts Receivable	$2,144,821			Accounts Receivable	$2,788,155			Accounts Receivable	$3,553,853			Accounts Receivable	$4,619,823			Accounts Receivable	$5,505,643
Inventory	-$10,557,180			Inventory	-$21,760,296			Inventory	-$33,649,133			Inventory	-$46,265,662			Inventory	-$106,408,305			Inventory	-$184,590,604			Inventory	-$286,223,516			Inventory	-$418,340,999
Other Current Assets	$10,000			Other Current Assets	$150,000			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		$6,967,425		Total Current Assets		$12,770,310		Total Current Assets		$18,825,038		Total Current Assets		$25,604,211		Total Current Assets		$59,932,835		Total Current Assets		$95,026,023		Total Current Assets		$149,398,505		Total Current Assets		$243,484,737
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	$790			Facilities	$790			Facilities	$790			Facilities	$790			Facilities	$790			Facilities	$790			Facilities	$790			Facilities	$790
Equipment	$1,270			Equipment	$1,270			Equipment	$1,270			Equipment	$1,270			Equipment	$1,270			Equipment	$1,270			Equipment	$1,270			Equipment	$1,270
Computers & Telecommunications	$0			Computers & Telecommunications	$0			Computers & Telecommunications	$0			Computers & Telecommunications	$0			Computers & Telecommunications	$0			Computers & Telecommunications	$0			Computers & Telecommunications	$0			Computers & Telecommunications	$0
(Less Accumlated Depreciation)	$680			(Less Accumlated Depreciation)	$1,330			(Less Accumlated Depreciation)	$1,870			(Less Accumlated Depreciation)	$2,620			(Less Accumlated Depreciation)	$2,870			(Less Accumlated Depreciation)	$3,120			(Less Accumlated Depreciation)	$3,370			(Less Accumlated Depreciation)	$3,620
Total Fixed Assets		$1,380		Total Fixed Assets		$730		Total Fixed Assets		$190		Total Fixed Assets		-$560		Total Fixed Assets		-$810		Total Fixed Assets		-$1,060		Total Fixed Assets		-$1,310		Total Fixed Assets		-$1,560
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			$6,968,805	TOTAL ASSETS			$12,771,040	TOTAL ASSETS			$18,825,228	TOTAL ASSETS			$25,603,651	TOTAL ASSETS			$59,932,025	TOTAL ASSETS			$95,024,963	TOTAL ASSETS			$149,397,195	TOTAL ASSETS			$243,486,237
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	$765			Short-Term Notes Payable	$510			Short-Term Notes Payable	$255			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0
Income Taxes Due	$3,831,179			Income Taxes Due	$5,246,051			Income Taxes Due	$6,796,489			Income Taxes Due	$35,483,448			Income Taxes Due	$44,029,153			Income Taxes Due	$55,988,564			Income Taxes Due	$72,423,549			Income Taxes Due	$94,719,284
Other Current Liabilities	$400			Other Current Liabilities	$450			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		$3,832,344		Total Current Liabilities		$5,247,011		Total Current Liabilities		$6,796,744		Total Current Liabilities		$35,483,448		Total Current Liabilities		$44,029,153		Total Current Liabilities		$55,988,564		Total Current Liabilities		$72,423,549		Total Current Liabilities		$94,719,284
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	$500			Long-Term Notes Payable	$300			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0
Other Long-Term Liabilities	$400			Other Long-Term Liabilities	$800			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		$900		Total Long-Term Liabilities		$1,100		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0		Total Long-Term Liabilities		$0
NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH
Paid-In Capital	$15,000			Paid-In Capital	$15,000			Paid-In Capital	$15,000			Paid-In Capital	$15,000			Paid-In Capital	$15,400			Paid-In Capital	$15,600			Paid-In Capital	$15,800			Paid-In Capital	$5,470,365
Retained Earnings	$3,120,561			Retained Earnings	$7,507,929			Retained Earnings	$12,013,484			Retained Earnings	-$9,894,797			Retained Earnings	$15,887,471			Retained Earnings	$39,020,799			Retained Earnings	$76,957,846			Retained Earnings	$0
Total Net Worth		$3,135,561		Total Net Worth		$7,522,929		Total Net Worth		$12,028,484		Total Net Worth		-$9,879,797		Total Net Worth		$15,902,871		Total Net Worth		$39,036,399		Total Net Worth		$76,973,646		Total Net Worth		$0
TOTAL LIABILITIES AND NET WORTH			$6,968,805	TOTAL LIABILITIES AND NET WORTH			$12,771,040	TOTAL LIABILITIES AND NET WORTH			$18,825,228	TOTAL LIABILITIES AND NET WORTH			$25,603,651	TOTAL LIABILITIES AND NET WORTH			$59,932,025	TOTAL LIABILITIES AND NET WORTH			$95,024,963	TOTAL LIABILITIES AND NET WORTH			$149,397,195	TOTAL LIABILITIES AND NET WORTH			$0

&CBalance Sheet

Page &P of &N

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

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

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

BrkEvn


	Break-even Estimates
	Year 1 (2016-2017)
	January	$2,535,554
	February	$2,693,108
	March	$2,693,260
	April	$2,693,640
	May	$2,694,019
	June	$2,693,488
	July	$2,693,437
	August	$2,693,209
	September	$2,693,311
	October	$2,693,386
	November	$2,693,386
	December	$2,693,386
	Monthly Average	$2,680,265
	Year 2 (2017-2018)
	January	$2,814,048
	February	$2,814,048
	March	$2,814,048
	April	$2,814,048
	May	$2,814,048
	June	$2,814,048
	July	$2,814,048
	August	$2,814,048
	September	$2,814,048
	October	$2,814,048
	November	$2,814,048
	December	$2,814,048
	Monthly Average	$2,814,048
	Year 3 (2018-2019)
	1st Quarter	$8,819,639
	2nd Quarter	$8,819,639
	3rd Quarter	$8,819,639
	4th Quarter	$8,819,639
	Quarterly Average	$8,819,639
	Year 4 (2019-2020)
	1st Quarter	$9,215,969
	2nd Quarter	$9,215,969
	3rd Quarter	$9,215,969
	4th Quarter	$9,215,969
	Quarterly Average	$9,215,969
	Year 5 (2020-2021)
	Annual Average	$38,490,031

&CBreak-even Estimates

Page &P of &N

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.

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

Ratios


Key Ratios
Year 1 (2016-2017)	Working Capital	Current Ratio	Quick Ratio	Cash Turnover	Debt to Equity	Return on Investment	Return on Sales	Return on Assets	Net Sales
1st Quarter	$4,000	6.00	7.00	6.00	5.00	8%	25%	54%	$0.00
2nd Quarter	$1,500	5.00	6.00	5.00	9.00	8%	28%	44%	$20,056,300.81
3rd Quarter	$2,000	3.00	5.00	4.00	8.00	7%	29%	33%	$21,283,906.87
4th Quarter	$1,400	4.00	7.00	5.00	7.00	5%	30%	26%	$22,586,652.24
Year 2 (2017-2018)	$5,000	4.00	8.00	4.00	8.00	6%	32%	57%	$107,669,947.88
Year 3 (2018-2019)	$3,000	5.00	5.00	6.00	6.00	8%	34%	50%	$139,965,316.12
Year 4 (2019-2020)	$3,000	6.00	6.00	8.00	8.00	6%	36%	44%	$181,947,610.28
Year 5 (2020-2021)	$6,000	7.00	7.00	5.00	7.00	8%	38%	37%	$236,522,402.88

&CKey Ratios

Page &P of &N

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.

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.

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.

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.

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.

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.

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.

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!

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

1YrAtGl

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

Gross Sales

Gross Profit

Net Profit

Year 1: Financials at-a-Glance (2013-2014)

$6,900,000.00

$0.00

$5,875,139.67

$7,038,000.00

$2,780,010.00

$1,287,174.25

$7,178,760.00

$2,835,610.20

$1,328,829.40

$7,322,335.20

$2,892,322.40

$1,371,251.05

$7,468,781.90

$2,950,168.85

$1,414,523.39

$7,618,157.54

$3,009,172.23

$1,458,933.42

$7,770,520.69

$3,069,355.67

$1,504,086.01

$7,925,931.11

$3,130,742.79

$1,550,193.84

$8,084,449.73

$3,193,357.64

$1,597,124.98

$8,246,138.72

$3,257,224.80

$1,645,002.85

$8,411,061.50

$3,322,369.29

$1,693,861.22

$8,579,282.73

$3,388,816.68

$1,743,696.76

NSYr1

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

Product Line 1

Product Line 2

Product Line 3

Product Line 4

Product Line 5

Product Line 6

Product Line 7

Product Line 8

Product Line 9

Product Line 10

Year 1: Net Sales (2013-2014)

$1,342,500.00

$0.00

$1,369,350.00

$4,929,660.00

$0.00

$1,396,737.00

$5,028,253.20

$0.00

$1,424,671.74

$5,128,818.26

$0.00

$1,453,165.17

$5,231,394.63

$0.00

$1,482,228.48

$5,336,022.52

$0.00

$1,511,873.05

$5,442,742.97

$0.00

$1,542,110.51

$5,551,597.83

$0.00

$1,572,952.72

$5,662,629.79

$0.00

$1,604,411.77

$5,775,882.38

$0.00

$1,636,500.01

$5,891,400.03

$0.00

$1,669,230.01

$6,009,228.03

$0.00

1YrCshFlw

January	$5,192,205.00
February	$10,393,534.63
March	$15,719,914.91
April	$21,174,201.45
May	$26,758,739.97
June	$32,476,067.32
July	$38,329,062.47
August	$44,320,497.57
September	$50,453,059.03
October	$56,729,448.57
November	$63,152,594.35
December	$69,725,052.11

Net Cash Flow

Ending Cash Balance

Year 1: Cash Flow (2013-2014)

$5,187,205.00

$5,201,329.63

$5,326,380.28

$5,454,286.54

$5,584,538.52

$5,717,327.35

$5,852,995.15

$5,991,435.10

$6,132,561.46

$6,276,389.54

$6,423,145.78

$6,572,457.75

2ndYrCshFlw

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

Net Cash Flow

Ending Cash Balance

Year 2: Cash Flow (2014-2015)

$6,819,080.77

$76,544,132.88

$7,032,456.30

$83,576,589.18

$7,195,374.60

$90,771,963.78

$7,361,270.07

$98,133,233.85

$7,530,797.85

$105,664,031.70

$7,703,214.39

$113,367,246.09

$7,894,887.46

$121,262,133.55

$8,166,703.74

$129,428,837.29

$8,357,057.06

$137,785,894.35

$8,504,536.11

$146,290,430.46

$8,741,994.46

$155,032,424.92

$8,520,559.68

$163,552,984.59

5YrAtGl

$2,016.00	$2,016.00	$2,016.00
$2,017.00	$2,017.00	$2,017.00
$2,018.00	$2,018.00	$2,018.00
$2,019.00	$2,019.00	$2,019.00
$2,020.00	$2,020.00	$2,020.00

Gross Sales

Gross Profit

Net Profit

5-Year Financials at-a-Glance

$92,543,419.12

$51,654,525.00

$70,447,836.00

$120,301,617.74

$47,519,139.01

$25,637,476.13

$156,385,828.07

$61,772,402.09

$35,878,591.87

$203,293,419.31

$80,300,900.63

$49,305,315.13

$264,270,841.20

$104,386,982.27

$66,887,565.06

NS5Yr

$2,016.00	$2,016.00	$2,016.00	$2,016.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
$2,017.00	$2,017.00	$2,017.00	$2,017.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
$2,018.00	$2,018.00	$2,018.00	$2,018.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
$2,019.00	$2,019.00	$2,019.00	$2,019.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
$2,020.00	$2,020.00	$2,020.00	$2,020.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Product Line 1

Product Line 2

Product Line 3

Product Line 4

Product Line 5

Product Line 6

Product Line 7

Product Line 8

Product Line 9

Product Line 10

5-Year Net Sales

$18,005,730.46

$0.00

$23,406,510.41

$84,263,437.47

$0.00

$30,427,242.63

$109,538,073.48

$0.00

$39,553,828.32

$142,393,781.96

$0.00

$51,417,913.67

$185,104,489.21

$0.00

About


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

www.planningshop.com

License


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

Config

CONFIG WORKSHEET

Startup Year

Jan

Plan Years:

2016

Feb

2016

Version:

Startup Month

Mar

2017

2.8

January

Apr

2018

7/21/09

Startup Month Abbrev

May

2019

Jan

Jun

2020

Start Date:

Jul

2021

O/S Type

Dec-11

Aug

Windows

Sep

Oct

Nov

Dec

CREDIT MULTIPLIER

Number of Products

Multiple

With "Credit Sales"

One

0.00

Two

1.00

0.25

Three

Four

Five

Six

Working Capital Calc

Seven

$3,135,081

Eight

$7,523,299

Nine

$12,028,294

Ten

-$9,879,237

$15,903,681

$39,037,459

$76,974,956

Chart Titles

Year 1 String

2016-2017

Year 1: Financials at-a-Glance (2016-2017)

Year 2 String

2017-2018

Year 1: Net Sales (2016-2017)

Year 3 String

2018-2019

Year 1: Cash Flow (2016-2017)

Year 4 String

2019-2020

Year 2: Cash Flow (2017-2018)

Year 5 String

2020-2021

DOUBLE LIST FOR Months on top of worksheets

January

February

March

April

May

June

July

August

September

October

November

December

January

February

March

April

May

June

July

August

September

October

November

December

Start Month

From Setup

January

February

March

April

May

June

July

August

September

October

November

December

Match Position in Doublelist

Adjust index to 1-12

Abbrev

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

To-Do List

Changing this changes ALL months on CapEX and CapInvest to new value, even ieach row's purchase date istill remains in the future. This is the same behavior as in 2.5, but might want to correct it.

Changing the Year Titles on SaleProj and all other worksheets, for fiscal years that straddle two calendar years (example: Year 1: 2012-2013

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

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

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

Adding "Reset_XXX" subroutines for ALL the worksheets

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

&CYour Company Name

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.

Plan Years is used in drop-downs for purchase and loan dates on CapInvest and CapEx worksheets.

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

Used by Ratios worksheet

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


	Depreciation Schedule from CapEx Worksheet
													Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16
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	office lease	$300.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ 25	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Facilities	shop lease	$250.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ 21	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Facilities	warehouse	$240.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ 20	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Facilities	$0.00	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Equip	two computers	$500.00	$30.00	1	12	Jan	2016	1	12	Nov-12	$ 39	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Equip	blending machine	$320.00	$12.00	1	12	Jan	2016	1	12	Nov-12	$ 26	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Equip	juice extra	$240.00	$10.00	1	12	Jan	2016	1	12	Nov-12	$ 19	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Equip	computer software	$100.00	$8.00	1	12	Jan	2016	1	12	Nov-12	$ 8	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Equip	phones	$50.00	$5.00	1	12	Jan	2016	1	12	Nov-12	$ 4	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Equip	fax	$60.00	$4.00	1	12	Jan	2016	1	12	Nov-12	$ 5	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
21	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
22	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
23	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
24	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
25	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
26	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
27	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
28	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
29	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
30	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2016	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
31	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
32	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
33	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
34	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
35	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
36	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
37	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
38	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
39	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
40	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
41	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
42	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
43	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
44	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
45	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
46	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
47	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
48	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
49	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
50	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12	$ - 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
51	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
52	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
53	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
54	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
55	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
56	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
57	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
58	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
59	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
60	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-12
		TOTAL											$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
		Land											-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Facilities											790	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Equip											1,270	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Comp											-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL											2,060	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL NON-DEPRECIABLE CAPITAL ASSETS											2,060	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-

&CDepreciation Schedule

Page &P of &N

This goes into Income statement under "non-depreciable capital purchases"

This goes into Cash Flow statement.

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?)

If "today's" month is one in this asset is dep'd over,

This goes into Cash Flow statement.

This goes into Income statement under "non-depreciable capital purchases"

LoanInvestSchedules


	Investment Proceeds									Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds
										Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16
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	Ordinally share capital	$5,000			Jan	2016	1			5,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	Preference shares	$3,000			Jan	2016	1			3,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
3	Debentures	$2,000			Jan	2016	1			2,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
4	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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	$0.00	$0			$0.00	0	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:	$10,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)
										Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16	Dec-16	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17
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	Citi Bank	$120	0.00%	12	Jan	2016	1	12	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 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	Standard Chartered	$500	0.00%	12	Jan	2016	1	12	41.67	41.67	41.67	41.67	41.67	41.67	41.67	41.67	41.67	41.67	41.67	41.67	41.67	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
3	Morgan and Chase	$400	0.00%	12	Jan	2016	1	12	33.33	33.33	33.33	33.33	33.33	33.33	33.33	33.33	33.33	33.33	33.33	33.33	33.33	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 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	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
5	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
6	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
7	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
8	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
9	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
10	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
11	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
12	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
13	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
14	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
15	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
16	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
17	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
18	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
19	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
20	0	$0	0.00%	0	0	0	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	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
									TOTAL:	$85	$85	$85	$85	$85	$85	$85	$85	$85	$85	$85	$85	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	Loan - Interest Portion of Loan Payments									Loan - Interest Portion of Loan Payments												Loan - Interest Portion of Loan Payments												Loan - Interest Portion of Loan Payments												Loan - Interest Portion of Loan Payments												Loan - Interest Portion of Loan Payments												Loan - Interest Portion of Loan Payments
										Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16	Dec-16	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17
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	Citi Bank	$120.00	$0.00	$12.00	Jan	$2,016.00	$1.00	$12.00	10.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Standard Chartered	$500	0.00%	12	Jan	2016	1	12	41.67	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Morgan and Chase	$400	0.00%	12	Jan	2016	1	12	33.33	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	0	$0	0.00%	0	0	0	1	- 0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	Loan Proceeds									Loan Proceeds												Loan Proceeds												Loan Proceeds												Loan Proceeds												Loan Proceeds
										Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16
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	Citi Bank	$120			Jan	2016	1			120.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Standard Chartered	$500			Jan	2016	1			500.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Morgan and Chase	$400			Jan	2016	1			400.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	0	$0			0	0	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:	$1,020	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	Citi Bank	$120.00	0.00%	12	Jan	2016	1	$120		$30	$90	$0	$60	$60	$0	$90	$30	$0	$120	$0	$0	$120	$0	$0	$120	$0	$0	$120	$0	$0	$120	$0	$0
2	Standard Chartered	$500.00	0.00%	12	Jan	2016	1	$500		$125	$375	$0	$250	$250	$0	$375	$125	$0	$500	$0	$0	$500	$0	$0	$500	$0	$0	$500	$0	$0	$500	$0	$0
3	Morgan and Chase	$400.00	0.00%	12	Jan	2016	1	$400		$100	$300	$0	$200	$200	-$0	$300	$100	$0	$400	$0	$0	$400	$0	$0	$400	$0	$0	$400	$0	$0	$400	$0	$0
4	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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	$0.00	$0.00	0.00%	- 0	$0.00	0	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:		$765	$0		$510	$0		$255	$0		$0	$0		$0	$0		$0	$0		$0	$0		$0	$0

&CLoan & Investment Schedules for Disbursement & Repayment

Page &P of &N

If received proceeds this quarter, "Due Short" is all the payment of principle (not interest) due in the next 12 months from disbursement

"Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out.

cummulative principle paid: includes previous quarter's payments

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.