Question (W7)

AnotherStudentsSampleExcel.xlsm

Home >Business & Finance homework help >Management homework help >Question (W7)

Warning


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

Your Company Name

Welcome

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

Setup

Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Not-Too-Sweet
What month will you officially start your company?		April

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

Setup & Assumptions

SalesProj

Sales Projections Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.			2023-2024														2024-2025														2025-2026						2026-2027						2027-2028
	Assumptions		April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Chocolate Covered Almonds Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.
Unit Volume		2.00% Author: MONTHLY VOLUME GROWTH RATE The Worksheets automatically increase the volume in each month on this line using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	1600 Author: Enter the number of units you expect to sell during this month. If you are running a service-based company charging on an hourly basis, enter the number of billable hours you expect you and your employees to work during this month. If you will be selling your service on a per-project basis, enter the number of projects you expect to sell during this period.	1632 Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	1665	1698	1732	1767	1800	1836	1873	1910	1948	1987	21448		3000	3060	3121	3184	3247	3312	3378	3446	3515	3585	3657	3730	40236		11644 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	12357	13113	13916	51029		14767	15671	16630	17648	64718		82077
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.50 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$6.50 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50			$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00			$7.18	$7.18	$7.18	$7.18			$7.35	$7.35	$7.35	$7.35			$7.54
Gross Sales			$10,400	$10,608	$10,820	$11,037	$11,257	$11,482	$11,700	$11,934	$12,173	$12,416	$12,664	$12,917.75	$139,409		$21,000	$21,420	$21,848	$22,285	$22,731	$23,186	$23,649	$24,122	$24,605	$25,097	$25,599	$26,111	$281,654		$83,546	$88,659	$94,086	$99,845	$366,135		$108,605	$115,252	$122,307	$129,793	$475,957		$618,719
(Commissions)	0.00% Author: COMMISSIONED SALES What percentage of this product line's sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?			Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	0.00% Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		2.00% Author: RETURNS AND ALLOWANCES A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate--but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales.	$208.00	$212	$216.40	$220.73	$225.15	$229.65	$234.00	$238.68	$243.45	$248.32	$253.29	$258.35	$2,788		$420.00	$428.40	$436.97	$445.71	$454.62	$463.71	$472.99	$482.45	$492.10	$501.94	$511.98	$522.22	$5,633		$1,670.91	$1,773.18	$1,881.72	$1,996.89	$7,323		$2,172.10	$2,305.05	$2,446.13	$2,595.86	$9,519		$12,374.38
Net Sales			$10,192	$10,396	$10,604	$10,816	$11,032	$11,253	$11,466	$11,695	$11,929	$12,168	$12,411	$12,659	$136,621		$20,580	$20,992	$21,411	$21,840	$22,276	$22,722	$23,176	$23,640	$24,113	$24,595	$25,087	$25,589	$276,021		$81,875	$86,886	$92,204	$97,848	$358,813		$106,433	$112,947	$119,861	$127,197	$466,438		$606,345
(Cost of Goods Sold)		50.00% Author: COST OF GOODS Approximately what percentage of your product's sale price will be spent on manufacturing? If you are a reseller or retailer, what percentage of your product's sale price will be spent on buying the product from your distributor? A service business may not need to track cost of goods, in which case you can set this number to zero.	$5,200.00	$5,304	$5,410	$5,518	$5,629	$5,741	$5,850	$5,967	$6,086	$6,208	$6,332	$6,459	$69,705		$10,500	$10,710	$10,924	$11,143	$11,366	$11,593	$11,825	$12,061	$12,302	$12,548	$12,799	$13,055	$140,827		$41,773	$44,330	$47,043	$49,922	$183,068		$54,302	$57,626	$61,153	$64,896	$237,978		$309,360
GROSS PROFIT			$4,992	$5,092	$5,194	$5,298	$5,404	$5,512	$5,616	$5,728	$5,843	$5,960	$6,079	$6,201	$66,917		$10,080	$10,282	$10,487	$10,697	$10,911	$11,129	$11,352	$11,579	$11,810	$12,047	$12,287	$12,533	$135,194		$40,102	$42,556	$45,161	$47,925	$175,745		$52,130	$55,321	$58,707	$62,301	$228,459		$296,985
Chocolate Covered Hazelnuts Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume		5.00%	1800	1890	1985	2084	2188	2297	2600	2730	2867	3010	3160	3318	29928		3484	3658	3841	4033	4235	4447	4669	4903	5148	5405	5675	5959	55459		19726 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	22835	26435	30601	99597		35425	41009	47473	54955	178862		321210
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$6.80 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$6.80 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80			$7.20	$7.20	$7.20	$7.20	$7.20	$7.20	$7.20	$7.20	$7.20	$7.20	$7.20	$7.20			$7.38	$7.38	$7.38	$7.38			$7.56	$7.56	$7.56	$7.56			$7.75
Gross Sales			$12,240	$12,852	$13,495	$14,169	$14,878	$15,622	$17,680	$18,564	$19,492	$20,467	$21,490	$22,565	$203,513		$25,087	$26,341	$27,658	$29,041	$30,493	$32,018	$33,618	$35,299	$37,064	$38,918	$40,863	$42,907	$399,306		$145,577	$168,523	$195,087	$225,837	$735,024		$267,971	$310,210	$359,107	$415,711	$1,352,998		$2,490,535
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		2.00%	$245	$257	$270	$283	$298	$312	$354	$371	$390	$409	$430	$451	$4,070		$502	$527	$553	$581	$610	$640	$672	$706	$741	$778	$817	$858	$7,986		$2,912	$3,370	$3,902	$4,517	$14,700		$5,359	$6,204	$7,182	$8,314	$27,060		$49,811
Net Sales			$11,995	$12,595	$13,225	$13,886	$14,580	$15,309	$17,326	$18,193	$19,102	$20,057	$21,060	$22,113	$199,443		$24,585	$25,814	$27,105	$28,460	$29,883	$31,377	$32,946	$34,593	$36,323	$38,139	$40,046	$42,048	$391,320		$142,665	$165,153	$191,185	$221,321	$720,324		$262,611	$304,006	$351,925	$407,397	$1,325,938		$2,440,724
(Cost of Goods Sold)		50.00%	$6,120	$6,426	$6,747	$7,085	$7,439	$7,811	$8,840	$9,282	$9,746	$10,233	$10,745	$11,282	$101,757		$12,543	$13,170	$13,829	$14,520	$15,246	$16,009	$16,809	$17,650	$18,532	$19,459	$20,432	$21,453	$199,653		$72,788	$84,262	$97,543	$112,919	$367,512		$133,985	$155,105	$179,553	$207,855	$676,499		$1,245,268
GROSS PROFIT			$5,875	$6,169	$6,477	$6,801	$7,141	$7,498	$8,486	$8,911	$9,356	$9,824	$10,315	$10,831	$97,686		$12,042	$12,644	$13,276	$13,940	$14,637	$15,368	$16,137	$16,944	$17,791	$18,680	$19,614	$20,595	$191,667		$69,877	$80,891	$93,642	$108,402	$352,812		$128,626	$148,901	$172,371	$199,541	$649,439		$1,195,457
Chocolate Covered Walnuts Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume		2.00%	1650	1683	1717	1751	1786	1822	2000	2040	2081	2122	2165	2208	23025		2500	2550	2601	2653	2706	2760	2815	2872	2929	2988	3047	3108	33530		9703 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	10297	10928	11596	42524		12306	13059	13859	14707	53931		68398
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$6.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$6.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00			$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50			$6.66	$6.66	$6.66	$6.66			$6.83	$6.83	$6.83	$6.83			$7.00
Gross Sales			$9,900	$10,098	$10,300	$10,506	$10,716	$10,930	$12,000	$12,240	$12,485	$12,734	$12,989	$13,249	$138,148		$16,250	$16,575	$16,907	$17,245	$17,590	$17,941	$18,300	$18,666	$19,039	$19,420	$19,809	$20,205	$217,946		$64,648	$68,605	$72,805	$77,261	$283,319		$84,039	$89,183	$94,642	$100,435	$368,300		$478,771
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		2.00%	$198	$202	$206	$210	$214	$219	$240	$245	$250	$255	$260	$265	$2,763		$325	$332	$338	$345	$352	$359	$366	$373	$381	$388	$396	$404	$4,359		$1,293	$1,372	$1,456	$1,545	$5,666		$1,681	$1,784	$1,893	$2,009	$7,366		$9,575
Net Sales			$9,702	$9,896	$10,094	$10,296	$10,502	$10,712	$11,760	$11,995	$12,235	$12,480	$12,729	$12,984	$135,385		$15,925	$16,244	$16,568	$16,900	$17,238	$17,582	$17,934	$18,293	$18,659	$19,032	$19,412	$19,801	$213,588		$63,355	$67,233	$71,348	$75,716	$277,653		$82,359	$87,400	$92,749	$98,426	$360,934		$469,195
(Cost of Goods Sold)		50.00%	$4,950	$5,049	$5,150	$5,253	$5,358	$5,465	$6,000	$6,120	$6,242	$6,367	$6,495	$6,624	$69,074		$8,125	$8,288	$8,453	$8,622	$8,795	$8,971	$9,150	$9,333	$9,520	$9,710	$9,904	$10,102	$108,973		$32,324	$34,303	$36,402	$38,630	$141,660		$42,020	$44,592	$47,321	$50,217	$184,150		$239,385
GROSS PROFIT			$4,752	$4,847	$4,944	$5,043	$5,144	$5,247	$5,760	$5,875	$5,993	$6,113	$6,235	$6,360	$66,311		$7,800	$7,956	$8,115	$8,277	$8,443	$8,612	$8,784	$8,960	$9,139	$9,322	$9,508	$9,698	$104,614		$31,031	$32,931	$34,946	$37,085	$135,993		$40,339	$42,808	$45,428	$48,209	$176,784		$229,810
Chocolate Covered Blueberries Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	1680	1714	1748	1783	1818	1855	2000	2040	2081	2122	2165	2208	23214		2600	2652	2705	2759	2814	2871	2928	2987	3046	3107	3169	3233	34871		10091 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	10709	11365	12060	44225		12798	13582	14413	15295	56089	71134
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$6.50 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$6.50 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50			$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00			$7.18	$7.18	$7.18	$7.18			$7.35	$7.35	$7.35	$7.35			$7.54
Gross Sales			$10,920	$11,138	$11,361	$11,588	$11,820	$12,057	$13,000	$13,260	$13,525	$13,796	$14,072	$14,353	$150,890		$18,200	$18,564	$18,935	$19,314	$19,700	$20,094	$20,496	$20,906	$21,324	$21,751	$22,186	$22,629	$244,100		$72,406	$76,838	$81,541	$86,532	$317,317		$94,124	$99,885	$105,999	$112,487	$412,496		$536,223
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		2.00%	$218	$223	$227	$232	$236	$241	$260	$265	$271	$276	$281	$287	$3,018		$364	$371	$379	$386	$394	$402	$410	$418	$426	$435	$444	$453	$4,882		$1,448	$1,537	$1,631	$1,731	$6,346		$1,882	$1,998	$2,120	$2,250	$8,250		$10,724
Net Sales			$10,702	$10,916	$11,134	$11,357	$11,584	$11,815	$12,740	$12,995	$13,255	$13,520	$13,790	$14,066	$147,872		$17,836	$18,193	$18,557	$18,928	$19,306	$19,692	$20,086	$20,488	$20,898	$21,316	$21,742	$22,177	$239,218		$70,958	$75,301	$79,910	$84,801	$310,971		$92,242	$97,888	$103,879	$110,237	$404,246		$525,499
(Cost of Goods Sold)		50.00%	$5,460	$5,569	$5,681	$5,794	$5,910	$6,028	$6,500	$6,630	$6,763	$6,898	$7,036	$7,177	$75,445		$9,100	$9,282	$9,468	$9,657	$9,850	$10,047	$10,248	$10,453	$10,662	$10,875	$11,093	$11,315	$122,050		$36,203	$38,419	$40,771	$43,266	$158,659		$47,062	$49,943	$53,000	$56,244	$206,248		$268,112
GROSS PROFIT			$5,242	$5,346	$5,453	$5,562	$5,674	$5,787	$6,240	$6,365	$6,492	$6,622	$6,754	$6,889	$72,427		$8,736	$8,911	$9,089	$9,271	$9,456	$9,645	$9,838	$10,035	$10,236	$10,440	$10,649	$10,862	$117,168		$34,755	$36,882	$39,140	$41,535	$152,312		$45,180	$47,945	$50,880	$53,994	$197,998		$257,387
Chocolate Covered Apples Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	1600	1632	1665	1698	1732	1767	1802	1838	1875	1912	1950	1989	21459		2000	2040	2081	2122	2165	2208	2252	2297	2343	2390	2438	2487	26824		7763 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	8238	8742	9277	34020		9845	10448	11087	11766	43145	54718
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$6.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$6.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00			$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50			$6.66	$6.66	$6.66	$6.66			$6.83	$6.83	$6.83	$6.83			$7.00
Gross Sales			$9,600	$9,792	$9,988	$10,188	$10,391	$10,599	$10,811	$11,027	$11,248	$11,473	$11,702	$11,936	$128,756		$13,000	$13,260	$13,525	$13,796	$14,072	$14,353	$14,640	$14,933	$15,232	$15,536	$15,847	$16,164	$174,357		$51,719	$54,884	$58,244	$61,809	$226,655		$67,232	$71,347	$75,714	$80,348	$294,640		$383,017
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		2.00%	$192	$196	$200	$204	$208	$212	$216	$221	$225	$229	$234	$239	$2,575		$260	$265	$271	$276	$281	$287	$293	$299	$305	$311	$317	$323	$3,487		$1,034	$1,098	$1,165	$1,236	$4,533		$1,345	$1,427	$1,514	$1,607	$5,893		$7,660
Net Sales			$9,408	$9,596	$9,788	$9,984	$10,184	$10,387	$10,595	$10,807	$11,023	$11,243	$11,468	$11,698	$126,181		$12,740	$12,995	$13,255	$13,520	$13,790	$14,066	$14,347	$14,634	$14,927	$15,225	$15,530	$15,841	$170,870		$50,684	$53,787	$57,079	$60,572	$222,122		$65,887	$69,920	$74,199	$78,741	$288,747		$375,356
(Cost of Goods Sold)		50.00%	$4,800	$4,896	$4,994	$5,094	$5,196	$5,300	$5,406	$5,514	$5,624	$5,736	$5,851	$5,968	$64,378		$6,500	$6,630	$6,763	$6,898	$7,036	$7,177	$7,320	$7,466	$7,616	$7,768	$7,923	$8,082	$87,179		$25,859	$27,442	$29,122	$30,904	$113,328		$33,616	$35,673	$37,857	$40,174	$147,320		$191,508
GROSS PROFIT			$4,608	$4,700	$4,794	$4,890	$4,988	$5,088	$5,189	$5,293	$5,399	$5,507	$5,617	$5,729	$61,803		$6,240	$6,365	$6,492	$6,622	$6,754	$6,889	$7,027	$7,168	$7,311	$7,457	$7,607	$7,759	$83,691		$24,825	$26,344	$27,957	$29,668	$108,795		$32,271	$34,246	$36,343	$38,567	$141,427		$183,848
Chocolate Covered Pineapples Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	1580	1612	1644	1677	1710	1744	2000	2040	2081	2122	2165	2208	22583		2600	2652	2705	2759	2814	2871	2928	2987	3046	3107	3169	3233	34871		10091 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	10709	11365	12060	44225		12798	13582	14413	15295	56089	71134
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$6.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$6.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00			$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50	$6.50			$6.66	$6.66	$6.66	$6.66			$6.83	$6.83	$6.83	$6.83			$7.00
Gross Sales			$9,480	$9,670	$9,863	$10,060	$10,261	$10,467	$12,000	$12,240	$12,485	$12,734	$12,989	$13,249	$135,498		$16,900	$17,238	$17,583	$17,934	$18,293	$18,659	$19,032	$19,413	$19,801	$20,197	$20,601	$21,013	$226,664		$67,234	$71,350	$75,717	$80,351	$294,652		$87,401	$92,751	$98,428	$104,452	$383,032		$497,922
(Commissions)	0.00%	0.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		2.00%	$190	$193	$197	$201	$205	$209	$240	$245	$250	$255	$260	$265	$2,710		$338	$345	$352	$359	$366	$373	$381	$388	$396	$404	$412	$420	$4,533		$1,345	$1,427	$1,514	$1,607	$5,893		$1,748	$1,855	$1,969	$2,089	$7,661		$9,958
Net Sales			$9,290	$9,476	$9,666	$9,859	$10,056	$10,257	$11,760	$11,995	$12,235	$12,480	$12,729	$12,984	$132,788		$16,562	$16,893	$17,231	$17,576	$17,927	$18,286	$18,652	$19,025	$19,405	$19,793	$20,189	$20,593	$222,131		$65,890	$69,923	$74,202	$78,744	$288,759		$85,653	$90,896	$96,459	$102,363	$375,371		$487,963
(Cost of Goods Sold)		50.00%	$4,740	$4,835	$4,931	$5,030	$5,131	$5,233	$6,000	$6,120	$6,242	$6,367	$6,495	$6,624	$67,749		$8,450	$8,619	$8,791	$8,967	$9,147	$9,329	$9,516	$9,706	$9,901	$10,099	$10,301	$10,507	$113,332		$33,617	$35,675	$37,858	$40,176	$147,326		$43,701	$46,375	$49,214	$52,226	$191,516		$248,961
GROSS PROFIT			$4,550	$4,641	$4,734	$4,829	$4,925	$5,024	$5,760	$5,875	$5,993	$6,113	$6,235	$6,360	$65,039		$8,112	$8,274	$8,440	$8,609	$8,781	$8,956	$9,135	$9,318	$9,505	$9,695	$9,888	$10,086	$108,799		$32,272	$34,248	$36,344	$38,569	$141,433		$41,953	$44,520	$47,245	$50,137	$183,855		$239,002
Product Line 7 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 8 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 9 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 10 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
																															Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Unit Volume		2.00%	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0		0 Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50% Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	$0.00 Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.	$0.00 Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.																											Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00	$0.00	$0.00	$0.00			$0.00
Gross Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Totals for All Product Lines
Total Unit Volume			9910	10162	10422	10690	10966	11251	12202	12524	12856	13199	13554	13920	141657		16184	16612	17054	17511	17982	18469	18971	19491	20028	20583	21157	21750	225793		69019	75145	81946	89511	315621		97940	107350	117875	129667	452832		668671
Total Gross Sales			$62,540	$64,158	$65,827	$67,548	$69,324	$71,157	$77,191	$79,265	$81,408	$83,621	$85,907	$88,270	$896,215		$110,437	$113,398	$116,456	$119,615	$122,878	$126,251	$129,736	$133,340	$137,065	$140,919	$144,905	$149,029	$1,544,028		$485,130	$528,860	$577,479	$631,635	$2,223,103		$709,372	$778,628	$856,196	$943,226	$3,287,423		$5,005,186
(Total Commissions)			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
(Total Returns and Allowances)			$1,251	$1,283	$1,317	$1,351	$1,386	$1,423	$1,544	$1,585	$1,628	$1,672	$1,718	$1,765	$17,924		$2,209	$2,268	$2,329	$2,392	$2,458	$2,525	$2,595	$2,667	$2,741	$2,818	$2,898	$2,981	$30,881		$9,703	$10,577	$11,550	$12,633	$44,462		$14,187	$15,573	$17,124	$18,865	$65,748		$100,104
Total Net Sales			$61,289	$62,875	$64,510	$66,197	$67,938	$69,734	$75,647	$77,680	$79,779	$81,948	$84,189	$86,504	$878,291		$108,228	$111,130	$114,127	$117,223	$120,421	$123,726	$127,142	$130,673	$134,324	$138,100	$142,006	$146,048	$1,513,148		$475,427	$518,283	$565,929	$619,002	$2,178,641		$695,185	$763,056	$839,072	$924,362	$3,221,674		$4,905,083
(Total Cost of Goods Sold)			$31,270	$32,079	$32,913	$33,774	$34,662	$35,578	$38,596	$39,633	$40,704	$41,810	$42,953	$44,135	$448,108		$55,218	$56,699	$58,228	$59,807	$61,439	$63,125	$64,868	$66,670	$68,533	$70,459	$72,452	$74,514	$772,014		$242,565	$264,430	$288,739	$315,817	$1,111,552		$354,686	$389,314	$428,098	$471,613	$1,643,711		$2,502,593
TOTAL GROSS PROFIT			$30,019	$30,796	$31,597	$32,423	$33,276	$34,155	$37,052	$38,047	$39,076	$40,138	$41,235	$42,369	$430,183		$53,010	$54,431	$55,899	$57,415	$58,982	$60,600	$62,273	$64,003	$65,791	$67,641	$69,554	$71,534	$741,134		$232,862	$253,853	$277,190	$303,185	$1,067,089		$340,499	$373,742	$410,974	$452,749	$1,577,963		$2,402,489

Sales Projections

Inventory

Inventory Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.	2023-2024														2024-2025														2025-2026						2026-2027						2027-2028
	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Chocolate Covered Almonds
Cost of Goods Sold	$5,200 Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.	$5,304	$5,410	$5,518	$5,629	$5,741	$5,850	$5,967	$6,086	$6,208	$6,332	$6,459	$69,705		$10,500	$10,710	$10,924	$11,143	$11,366	$11,593	$11,825	$12,061	$12,302	$12,548	$12,799	$13,055	$140,827		$41,773	$44,330	$47,043	$49,922	$183,068		$54,302	$57,626	$61,153	$64,896	$237,978		$309,360
Ingredients	$3,200 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$3,264	$3,329	$3,396	$3,464	$3,533	$3,600	$3,672	$3,745	$3,820	$3,897	$10,500	$49,421		$6,750	$6,885	$7,023	$7,163	$7,306	$7,453	$7,602	$7,754	$7,909	$8,067	$8,228	$8,393	$90,532		$26,854	$28,498	$30,242	$32,093	$117,686		$34,909	$37,045	$39,313	$41,719	$152,986		$198,874
Bags	$400	$408	$416	$424	$433	$442	$450	$459	$468	$478	$487	$497	$5,362		$750	$765	$780	$796	$812	$828	$845	$862	$879	$896	$914	$933	$10,059		$2,984	$3,166	$3,360	$3,566	$13,076		$3,879	$4,116	$4,368	$4,635	$16,998		$22,097
Cartons	$1,600	$1,632	$1,665	$1,698	$1,732	$1,767	$1,800	$1,836	$1,873	$1,910	$1,948	$1,987	$21,448		$3,000	$3,060	$3,121	$3,184	$3,247	$3,312	$3,378	$3,446	$3,515	$3,585	$3,657	$3,730	$40,236		$11,935	$12,666	$13,441	$14,264	$52,305		$15,515	$16,465	$17,472	$18,542	$67,994		$88,388
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	$5,200 Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)	$5,304	$5,410	$5,518	$5,629	$5,741	$5,850	$5,967	$6,086	$6,208	$6,332	$12,984	$76,230		$10,500	$10,710	$10,924	$11,143	$11,366	$11,593	$11,825	$12,061	$12,302	$12,548	$12,799	$13,055	$140,827		$41,773	$44,330	$47,043	$49,922	$183,068		$54,302	$57,626	$61,153	$64,896	$237,978		$309,360
Chocolate Covered Hazelnuts Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$6,120	$6,426	$6,747	$7,085	$7,439	$7,811	$8,840	$9,282	$9,746	$10,233	$10,745	$11,282	$101,757		$12,543	$13,170	$13,829	$14,520	$15,246	$16,009	$16,809	$17,650	$18,532	$19,459	$20,432	$21,453	$199,653		$72,788	$84,262	$97,543	$112,919	$367,512		$133,985	$155,105	$179,553	$207,855	$676,499		$1,245,268
Ingredients	$3,870 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$4,064	$4,267	$4,480	$4,704	$4,939	$5,590	$5,870	$6,163	$6,471	$6,795	$12,543	$69,755		$8,187	$8,597	$9,027	$9,478	$9,952	$10,449	$10,972	$11,520	$12,097	$12,701	$13,336	$14,003	$130,320		$47,511	$55,000	$63,670	$73,706	$239,887		$87,456	$101,242	$117,200	$135,674	$441,572		$812,825
Bags	$450	$473	$496	$521	$547	$574	$650	$683	$717	$752	$790	$830	$7,482		$871	$915	$960	$1,008	$1,059	$1,112	$1,167	$1,226	$1,287	$1,351	$1,419	$1,490	$13,864		$5,054	$5,851	$6,773	$7,841	$25,520		$9,304	$10,770	$12,468	$14,433	$46,976		$86,471
Cartons	$1,800	$1,890	$1,985	$2,084	$2,188	$2,297	$2,600	$2,730	$2,867	$3,010	$3,160	$3,318	$29,928		$3,484	$3,658	$3,841	$4,033	$4,235	$4,447	$4,669	$4,902	$5,147	$5,405	$5,675	$5,959	$55,455		$20,218	$23,404	$27,093	$31,364	$102,079		$37,216	$43,082	$49,872	$57,733	$187,903		$345,883
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	$6,120	$6,426	$6,747	$7,085	$7,439	$7,811	$8,840	$9,282	$9,746	$10,233	$10,745	$16,691	$107,165		$12,542	$13,170	$13,828	$14,519	$15,245	$16,008	$16,808	$17,648	$18,531	$19,457	$20,430	$21,452	$199,639		$72,783	$84,256	$97,536	$112,911	$367,486		$133,976	$155,094	$179,541	$207,841	$676,451		$1,245,179
Chocolate Covered Walnuts Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$4,950	$5,049	$5,150	$5,253	$5,358	$5,465	$6,000	$6,120	$6,242	$6,367	$6,495	$6,624	$69,074		$8,125	$8,288	$8,453	$8,622	$8,795	$8,971	$9,150	$9,333	$9,520	$9,710	$9,904	$10,102	$108,973		$32,324	$34,303	$36,402	$38,630	$141,660		$42,020	$44,592	$47,321	$50,217	$184,150		$239,385
Ingredients	$3,300 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$3,366	$3,433	$3,502	$3,572	$3,643	$4,000	$4,080	$4,162	$4,245	$4,330	$8,125	$49,758		$5,000	$5,100	$5,202	$5,306	$5,412	$5,520	$5,631	$5,743	$5,858	$5,975	$6,095	$6,217	$67,060		$19,892	$21,109	$22,401	$23,773	$87,175		$25,858	$27,441	$29,121	$30,903	$113,323		$147,314
Bags	$413	$421	$429	$438	$447	$455	$500	$510	$520	$531	$541	$552	$5,756		$625	$638	$650	$663	$677	$690	$704	$718	$732	$747	$762	$777	$8,383		$2,486	$2,639	$2,800	$2,972	$10,897		$3,232	$3,430	$3,640	$3,863	$14,165		$18,414
Cartons	$1,238	$1,262	$1,287	$1,313	$1,340	$1,366	$1,500	$1,530	$1,561	$1,592	$1,624	$1,656	$17,268		$2,500	$2,550	$2,601	$2,653	$2,706	$2,760	$2,815	$2,872	$2,929	$2,988	$3,047	$3,108	$33,530		$9,946	$10,555	$11,201	$11,886	$43,588		$12,929	$13,721	$14,560	$15,452	$56,662		$73,657
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	$4,950	$5,049	$5,150	$5,253	$5,358	$5,465	$6,000	$6,120	$6,242	$6,367	$6,495	$10,333	$72,783		$8,125	$8,288	$8,453	$8,622	$8,795	$8,971	$9,150	$9,333	$9,520	$9,710	$9,904	$10,102	$108,973		$32,324	$34,303	$36,402	$38,630	$141,660		$42,020	$44,592	$47,321	$50,217	$184,150		$239,385
Chocolate Covered Blueberries Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$5,460	$5,569	$5,681	$5,794	$5,910	$6,028	$6,500	$6,630	$6,763	$6,898	$7,036	$7,177	$75,445		$9,100	$9,282	$9,468	$9,657	$9,850	$10,047	$10,248	$10,453	$10,662	$10,875	$11,093	$11,315	$122,050		$36,203	$38,419	$40,771	$43,266	$158,659		$47,062	$49,943	$53,000	$56,244	$206,248		$268,112
Ingredients	$3,360 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$3,428	$3,497	$3,566	$3,638	$3,711	$4,001	$4,081	$4,163	$4,246	$4,331	$4,417	$46,438		$5,850	$5,967	$6,086	$6,208	$6,332	$6,459	$6,588	$6,720	$6,854	$6,991	$7,131	$7,274	$78,461		$23,273	$24,698	$26,210	$27,814	$101,995		$30,254	$32,106	$34,071	$36,157	$132,588		$172,357
Bags	$420	$429	$437	$446	$455	$464	$500	$510	$520	$531	$541	$552	$5,805		$650	$663	$676	$690	$704	$718	$732	$747	$762	$777	$792	$808	$8,718		$2,586	$2,744	$2,912	$3,090	$11,333		$3,362	$3,567	$3,786	$4,017	$14,732		$19,151
Cartons	$1,680	$1,714	$1,748	$1,783	$1,818	$1,855	$2,000	$2,040	$2,081	$2,122	$2,165	$2,208	$23,214		$2,600	$2,652	$2,705	$2,759	$2,814	$2,871	$2,928	$2,987	$3,046	$3,107	$3,169	$3,233	$34,871		$10,344	$10,977	$11,649	$12,362	$45,331		$13,446	$14,269	$15,143	$16,070	$58,928		$76,603
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	$5,460	$5,570	$5,682	$5,795	$5,911	$6,029	$6,501	$6,631	$6,764	$6,899	$7,037	$7,178	$75,456		$9,100	$9,282	$9,468	$9,657	$9,850	$10,047	$10,248	$10,453	$10,662	$10,875	$11,093	$11,315	$122,050		$36,203	$38,419	$40,771	$43,266	$158,659		$47,062	$49,943	$53,000	$56,244	$206,248		$268,112
Chocolate Covered Apples Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$4,800	$4,896	$4,994	$5,094	$5,196	$5,300	$5,406	$5,514	$5,624	$5,736	$5,851	$5,968	$64,378		$6,500	$6,630	$6,763	$6,898	$7,036	$7,177	$7,320	$7,466	$7,616	$7,768	$7,923	$8,082	$87,179		$25,859	$27,442	$29,122	$30,904	$113,328		$33,616	$35,673	$37,857	$40,174	$147,320		$191,508
Ingredients	$3,200 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$3,264	$3,329	$3,396	$3,464	$3,533	$3,604	$3,676	$3,749	$3,824	$3,901	$3,979	$42,919		$4,000	$4,080	$4,162	$4,245	$4,330	$4,416	$4,505	$4,595	$4,687	$4,780	$4,876	$4,973	$53,648		$15,913	$16,887	$17,921	$19,018	$69,740		$20,687	$21,953	$23,297	$24,722	$90,658		$117,851
Bags	$400	$408	$416	$424	$433	$442	$450	$459	$469	$478	$488	$497	$5,365		$500	$510	$520	$531	$541	$552	$563	$574	$586	$598	$609	$622	$6,706		$1,989	$2,111	$2,240	$2,377	$8,718		$2,586	$2,744	$2,912	$3,090	$11,332		$14,731
Cartons	$1,200	$1,224	$1,248	$1,273	$1,299	$1,325	$1,351	$1,378	$1,406	$1,434	$1,463	$1,492	$16,095		$2,000	$2,040	$2,081	$2,122	$2,165	$2,208	$2,252	$2,297	$2,343	$2,390	$2,438	$2,487	$26,824		$7,957	$8,444	$8,961	$9,509	$34,870		$10,343	$10,976	$11,648	$12,361	$45,329		$58,926
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	$4,800	$4,896	$4,994	$5,094	$5,196	$5,300	$5,406	$5,514	$5,624	$5,736	$5,851	$5,968	$64,378		$6,500	$6,630	$6,763	$6,898	$7,036	$7,177	$7,320	$7,466	$7,616	$7,768	$7,923	$8,082	$87,179		$25,859	$27,442	$29,122	$30,904	$113,328		$33,616	$35,673	$37,857	$40,174	$147,320		$191,508
Chocolate Covered Pineapples Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$4,740	$4,835	$4,931	$5,030	$5,131	$5,233	$6,000	$6,120	$6,242	$6,367	$6,495	$6,624	$67,749		$8,450	$8,619	$8,791	$8,967	$9,147	$9,329	$9,516	$9,706	$9,901	$10,099	$10,301	$10,507	$113,332		$33,617	$35,675	$37,858	$40,176	$147,326		$43,701	$46,375	$49,214	$52,226	$191,516		$248,961
Ingredients	$3,160 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$3,224	$3,288	$3,354	$3,421	$3,490	$4,001	$4,081	$4,163	$4,246	$4,331	$4,417	$45,177		$5,200	$5,304	$5,410	$5,518	$5,629	$5,741	$5,856	$5,973	$6,093	$6,214	$6,339	$6,466	$69,743		$20,687	$21,954	$23,297	$24,723	$90,662		$26,893	$28,539	$30,285	$32,139	$117,856		$153,207
Bags	$395	$403	$411	$419	$428	$436	$500	$510	$520	$531	$541	$552	$5,646		$650	$663	$676	$690	$704	$718	$732	$747	$762	$777	$792	$808	$8,718		$2,586	$2,744	$2,912	$3,090	$11,333		$3,362	$3,567	$3,786	$4,017	$14,732		$19,151
Cartons	$1,185	$1,209	$1,233	$1,258	$1,283	$1,308	$1,500	$1,530	$1,561	$1,592	$1,624	$1,656	$16,937		$2,600	$2,652	$2,705	$2,759	$2,814	$2,871	$2,928	$2,987	$3,046	$3,107	$3,169	$3,233	$34,871		$10,344	$10,977	$11,649	$12,362	$45,331		$13,446	$14,269	$15,143	$16,070	$58,928		$76,603
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	$4,740	$4,836	$4,932	$5,031	$5,132	$5,234	$6,001	$6,121	$6,243	$6,368	$6,496	$6,626	$67,760		$8,450	$8,619	$8,791	$8,967	$9,147	$9,329	$9,516	$9,706	$9,901	$10,099	$10,301	$10,507	$113,332		$33,617	$35,675	$37,858	$40,176	$147,326		$43,701	$46,375	$49,214	$52,226	$191,516		$248,961
Product Line 7 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 8 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 9 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
	Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 10 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GRAND TOTAL INVENTORY	$31,270	$32,081	$32,915	$33,776	$34,664	$35,580	$38,598	$39,635	$40,706	$41,812	$42,956	$59,780	$463,772		$55,217	$56,698	$58,227	$59,806	$61,438	$63,124	$64,867	$66,669	$68,531	$70,458	$72,451	$74,513	$772,000		$242,560	$264,424	$288,732	$315,809	$1,111,525		$354,677	$389,303	$428,085	$471,598	$1,643,663		$2,502,504

CapEx

Capital Purchases Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.									3/31/19
Item	Cost	Purchase Date		Years of Service	Salvage Value
							Reminder: All purchases must be on or after your business start date of:
Facilities Author: Facilities include, land, buildings, building upgrades, fixtures, etc. NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.		Month	Year				March-2019
Item Name (change name here)	$0 Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.	Apr Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	2023 Author: Enter the year you will purchase the item(s).	1 Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.	$0 Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Equipment Author: Equipment includes machinery, furniture, vehicles, etc.
Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.	Author: Facilities include, land, buildings, building upgrades, fixtures, etc. NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.	Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.	Packaging machine	$10,000	Apr	2023	5	$1,500
Procduction machine	$10,000	Apr	2023	5	$1,500
Van #1	$15,000	Apr	2023	5	$1,000
Van #2	$15,000	Apr	2023	5	$1,000
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Computer Hardware/Software Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.
		Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	Computer #1	$1,500	Apr	2023	2	$200
Computer #2	$1,500	Apr	2023	2	$200
Computer #3	$1,500	Apr	2023	2	$200
Software	$400	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Telecommunications Author: Telecommunications includes phone systems, fax machines, etc.
			Author: Enter the year you will purchase the item(s).	Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.	Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.	Phone system	$960	Apr	2023	1	$100
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Item Name (change name here)	$0	Apr	2023	1	$0
Land Author: Land purchases are not depreciable.
Item Name (change name here)	$0	Apr	2023	Land is a non-depreciable asset
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023
Item Name (change name here)	$0	Apr	2023

Capital Purchases

StaffBudj

Staffing Budget Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.	2023-2024													2024-2025													2025-2026					2026-2027					2027-2028
	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	TOTAL
Management
# Salaried Employees	1.0 Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees".	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0		2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0		2.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	2.0	2.0	2.0		2.0	2.0	2.0	2.0		2.0
Avg Salary per employee	$5,000 Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$60,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$6,000	$72,000	$18,630	$18,630	$18,630	$18,630	$74,520	$19,282	$19,282	$19,282	$19,282	$77,128	$79,828
Benefits (across all employees)	$417 Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$5,000	$875	$875	$875	$875	$875	$875	$875	$875	$875	$875	$875	$875	$10,500	$2,756	$2,756	$2,756	$2,756	$11,025	$2,894	$2,894	$2,894	$2,894	$11,576	$12,155
Payroll Taxes (across all employees)	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$21,600	$5,589	$5,589	$5,589	$5,589	$22,356	$5,785	$5,785	$5,785	$5,785	$23,138	$23,948
Total Costs	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$6,167	$74,000	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$14,675	$176,100	$45,605	$45,605	$45,605	$45,605	$182,421	$47,243	$47,243	$47,243	$47,243	$188,971	$195,759
Administrative/Support
# Salaried Employees	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0		1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0		1.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	1.0	1.0	1.0		1.0	1.0	1.0	1.0		1.0
Avg Salary per employee	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$24,000	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$24,840	$6,427	$6,427	$6,427	$6,427	$25,709	$6,652	$6,652	$6,652	$6,652	$26,609	$27,541
Benefits (across all employees)	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$5,000	$438	$438	$438	$438	$438	$438	$438	$438	$438	$438	$438	$438	$5,250	$1,378	$1,378	$1,378	$1,378	$5,513	$1,447	$1,447	$1,447	$1,447	$5,788	$6,078
Payroll Taxes (across all employees)	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$3,600	$311	$311	$311	$311	$311	$311	$311	$311	$311	$311	$311	$311	$3,726	$964	$964	$964	$964	$3,856	$998	$998	$998	$998	$3,991	$4,131
Total Costs	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$2,717	$32,600	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$2,818	$33,816	$8,770	$8,770	$8,770	$8,770	$35,078	$9,097	$9,097	$9,097	$9,097	$36,389	$37,749
Sales/Marketing
# Salaried Employees	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.										Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Operations/Production
# Salaried Employees	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.0	2.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 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	4.0	4.0	4.0		4.0	4.0	4.0	4.0		4.0
Avg Salary per employee	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$24,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$3,000	$36,000	$9,315	$9,315	$9,315	$9,315	$37,260	$9,641	$9,641	$9,641	$9,641	$38,564	$39,914
Benefits (across all employees)	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$10,000	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$21,000	$5,513	$5,513	$5,513	$5,513	$22,050	$5,788	$5,788	$5,788	$5,788	$23,153	$24,310
Payroll Taxes (across all employees)	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$7,200	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$1,800	$21,600	$5,589	$5,589	$5,589	$5,589	$22,356	$5,785	$5,785	$5,785	$5,785	$23,138	$23,948
Total Costs	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$5,433	$65,200	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$15,550	$186,600	$48,362	$48,362	$48,362	$48,362	$193,446	$50,137	$50,137	$50,137	$50,137	$200,547	$207,914
Other
# Salaried Employees	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0.0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.0	0.0	0.0		0.0	0.0	0.0	0.0		0.0
Avg Salary per employee	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Part-Time / Hourly Employees
# Part-Time Employees	2	2	2	2	2	2	2	2	2	2	2	2		2	2	2	2	2	2	2	2	2	2	2	2		2 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees".	Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).									Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.								Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	2	2	2	2	2	2	2	2
Avg. Hours per Hourly Employee	30	30	30	30	30	30	30	30	30	30	30	30		30	30	30	30	30	30	30	30	30	30	30	30		90	90	90	90		90	90	90	90		360
Avg Hourly Rate	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00		$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00		$16.56	$16.56	$16.56	$16.56		$17.14	$17.14	$17.14	$17.14		$17.74
Calculated Wages Per Hourly Employee	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,400	$480	$480	$480	$480	$480	$480	$480	$480	$480	$480	$480	$480	$5,760	$1,490	$1,490	$1,490	$1,490	$5,962	$1,543	$1,543	$1,543	$1,543	$6,170	$6,386
Wages	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$10,800	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$11,520	$2,981	$2,981	$2,981	$2,981	$11,923	$3,085	$3,085	$3,085	$3,085	$12,341	$12,772
Benefits (across all employees)	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$200	$2,400	$210	$210	$210	$210	$210	$210	$210	$210	$210	$210	$210	$210	$2,520	$662	$662	$662	$662	$2,646	$695	$695	$695	$695	$2,778	$2,917
Payroll Taxes (across all employees)	$135	$135	$135	$135	$135	$135	$135	$135	$135	$135	$135	$135	$1,620	$144	$144	$144	$144	$144	$144	$144	$144	$144	$144	$144	$144	$1,728	$447	$447	$447	$447	$1,788	$463	$463	$463	$463	$1,851	$1,916
Total Costs	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$1,235	$14,820	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$1,314	$15,768	$4,089	$4,089	$4,089	$4,089	$16,358	$4,242	$4,242	$4,242	$4,242	$16,970	$17,606
TOTAL
# Full Time Employees	$4	$4	$4	$4	$4	$4	$4	$4	$4	$4	$4	$4		$7	$7	$7	$7	$7	$7	$7	$7	$7	$7	$7	$7		$7	$7	$7	$7		$7	$7	$7	$7		$7
# Part-Time Employees	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2		$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2		$2	$2	$2	$2		$2	$2	$2	$2		$2
Salary/Wages	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$142,800	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$324,360	$83,928	$83,928	$83,928	$83,928	$335,713	$86,866	$86,866	$86,866	$86,866	$347,463	$359,624
Benefits	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$22,400	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$39,270	$10,308	$10,308	$10,308	$10,308	$41,234	$10,824	$10,824	$10,824	$10,824	$43,295	$45,460
Payroll Taxes	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$21,420	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$48,654	$12,589	$12,589	$12,589	$12,589	$50,357	$13,030	$13,030	$13,030	$13,030	$52,119	$53,944
GRAND TOTAL COSTS	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$15,552	$186,620	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$34,357	$412,284	$106,826	$106,826	$106,826	$106,826	$427,303	$110,719	$110,719	$110,719	$110,719	$442,877	$459,027

Staffing Budget

MktBudj

	For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates from PlanningShop.
Marketing Budget Author: For information about this worksheet, see Chapter 10, "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies	2023-2024														2024-2025														2025-2026						2026-2027						2027-2028
	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Professional Assistance
Marketing/PR Consultants	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Advertising Agencies	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Social Media Specialists	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
SEO Specialist	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Graphic/Web Design	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Brochures/Leaflets/Flyers	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Signs/Billboards	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Merchandising Displays	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Sampling/Premiums	$0	$0	$0	$0	$0	$0	$1,000	$0	$0	$0	$0	$1,000	$2,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
Media Advertising
Print (newspaper, etc.)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Television and Radio	$1,000	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,250		$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$750	$9,000		$2,250	$2,250	$2,250	$2,250	$9,000		$2,250	$2,250	$2,250	$2,250	$9,000		$9,000
Online Author: Includes AdWords, banner ads, social media ads, etc.	Author: For information about this worksheet, see Chapter 10, "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies	$750	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,700		$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,400		$1,350	$1,350	$1,350	$1,350	$5,400		$1,350	$1,350	$1,350	$1,350	$5,400		$5,400
Other Media	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Phone Directories	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Advertising Specialties	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Direct Mail	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Website
Development/Programming	$4,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$4,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
Maintenance and Hosting	$140	$140	$140	$140	$140	$140	$140	$140	$140	$140	$140	$140	$1,680		$140	$140	$140	$140	$140	$140	$140	$140	$140	$140	$140	$140	$1,680		$420	$420	$420	$420	$1,680		$420	$420	$420	$420	$1,680		$1,680
Trade Shows
Fees and Setup	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Travel/Shipping	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Exhibits/Signs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Public Relations/Materials	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Informal Marketing / Networking
Memberships/Meetings	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Entertainment	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Other	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GRAND TOTAL COSTS	$5,890	$1,340	$1,340	$1,340	$1,340	$1,340	$2,340	$1,340	$1,340	$1,340	$1,340	$2,340	$22,630		$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$16,080		$4,020	$4,020	$4,020	$4,020	$16,080		$4,020	$4,020	$4,020	$4,020	$16,080		$16,080

Marketing Budget

ProSvs

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

Professional Services Budget

CapInvest

Capital Investments and Loans Author: This worksheet will help you manage loans and investments in your business.
Item	Amount	Date		Loan Period Sure Product Consulting: Loan period is in NUMBER OF MONTHS	Interest Rate
							Reminder: All invesments & loans must be on or after your business start date of:
Equity Capital Investments Author: Equity capital investments can come from a number of sources, including venture capitalists, angel investors, and family members. Generally, these investors are purchasing a percentage of (or shares in) your company. They expect to reap the rewards of your business' success through periodic dividend payments (a share of the profits) and/or when the company is sold.				Sure Product Consulting: Loan period is in NUMBER OF MONTHS	Month	Year		March-2019
Gift	$50,000 Author: Enter the amount that will be invested in your business from this source. If this investor will inject cash into your business more than one time, use separate lines for each investment.	Apr Author: Enter the month that you will receive the investment cash. Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	2023 Author: Enter the year you will receive the investment cash.	Capital investments are not paid back on a loan schedule.
Venture Capitalist (10%)	$50,000	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Investment Source Name	$0	Apr	2023
Total Capital Investments	$100,000
Loans Author: Unlike equity capital inventments, lenders are typically not interested in purchasing shares in your company--they simply want to be paid back on a fixed schedule, with interest. Lenders can include banks and family members.
Friends and Family	$30,000	Apr	2023	24 Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.	5.00% Author: Enter the loan's annual interest rate.
First Horizon Bank	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Apr	2023	12	0.00% Author: Enter the loan's annual interest rate.
Total Loans	$30,000
TOTAL INVESTMENTS AND LOANS	$130,000

Capital Investments and Loans

IncSt

Income Statements Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.	2023-2024													2024-2025													2025-2026					2026-2027					2027-2028
	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
INCOME
Gross Sales	$62,540	$64,158	$65,827	$67,548	$69,324	$71,157	$77,191	$79,265	$81,408	$83,621	$85,907	$88,270	$896,215	$110,437	$113,397.92	$116,456	$119,615	$122,878	$126,251	$129,736	$133,340	$137,065	$140,919	$144,905	$149,029	$1,544,028	$485,130	$528,860	$577,479	$631,635	$2,223,103	$709,372	$778,628	$856,196	$943,226	$3,287,423	$5,005,186
(Commissions)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0.00	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and allowances)	$1,251	$1,283	$1,317	$1,351	$1,386	$1,423	$1,544	$1,585	$1,628	$1,672	$1,718	$1,765	$17,924	$2,209	$2,267.96	$2,329	$2,392	$2,458	$2,525	$2,595	$2,667	$2,741	$2,818	$2,898	$2,981	$30,881	$9,703	$10,577	$11,550	$12,633	$44,462	$14,187	$15,573	$17,124	$18,865	$65,748	$100,104
Net Sales	$61,289	$62,875	$64,510	$66,197	$67,938	$69,734	$75,647	$77,680	$79,779	$81,948	$84,189	$86,504	$878,291	$108,228	$111,129.96	$114,127	$117,223	$120,421	$123,726	$127,142	$130,673	$134,324	$138,100	$142,006	$146,048	$1,513,148	$475,427	$518,283	$565,929	$619,002	$2,178,641	$695,185	$763,056	$839,072	$924,362	$3,221,674	$4,905,083
(Cost of Goods)	$31,270	$32,079	$32,913	$33,774	$34,662	$35,578	$38,596	$39,633	$40,704	$41,810	$42,953	$44,135	$448,108	$55,218	$56,698.96	$58,228	$59,807	$61,439	$63,125	$64,868	$66,670	$68,533	$70,459	$72,452	$74,514	$772,014	$242,565	$264,430	$288,739	$315,817	$1,111,552	$354,686	$389,314	$428,098	$471,613	$1,643,711	$2,502,593
GROSS PROFIT	$30,019	$30,796	$31,597	$32,423	$33,276	$34,155	$37,052	$38,047	$39,076	$40,138	$41,235	$42,369	$430,183	$53,010	$54,431.00	$55,899	$57,415	$58,982	$60,600	$62,273	$64,003	$65,791	$67,641	$69,554	$71,534	$741,134	$232,862	$253,853	$277,190	$303,185	$1,067,089	$340,499	$373,742	$410,974	$452,749	$1,577,963	$2,402,489
EXPENSES - General and Administrative
Salaries and wages	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$11,900	$142,800	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$27,030	$324,360	$83,928	$83,928	$83,928	$83,928	$335,713	$86,866	$86,866	$86,866	$86,866	$347,463	$359,624
Employee benefits	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$1,867	$22,400	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$3,273	$39,270	$10,308	$10,308	$10,308	$10,308	$41,234	$10,824	$10,824	$10,824	$10,824	$43,295	$45,460
Payroll taxes	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$1,785	$21,420	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$4,055	$48,654	$12,589	$12,589	$12,589	$12,589	$50,357	$13,030	$13,030	$13,030	$13,030	$52,119	$53,944
Professional services	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$1,458	$17,500	$625	$625	$625	$625	$625	$625	$625	$625	$625	$625	$625	$625	$7,500	$1,875	$1,875	$1,875	$1,875	$7,500	$1,875	$1,875	$1,875	$1,875	$7,500	$7,500
Marketing and advertising	$5,890	$1,340	$1,340	$1,340	$1,340	$1,340	$2,340	$1,340	$1,340	$1,340	$1,340	$2,340	$22,630	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$1,340	$16,080	$4,020	$4,020	$4,020	$4,020	$16,080	$4,020	$4,020	$4,020	$4,020	$16,080	$16,080
Rent	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$96,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$8,000	$96,000	$24,000	$24,000	$24,000	$24,000	$96,000	$24,000	$24,000	$24,000	$24,000	$96,000	$96,000
Equipment rental	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Maintenance	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$900	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$900	$225	$225	$225	$225	$900	$225	$225	$225	$225	$900	$900
Depreciation	$913	$913	$913	$913	$913	$913	$913	$913	$913	$913	$913	$913	$10,950	$913	$913	$913	$913	$913	$913	$913	$913	$913	$913	$913	$913	$10,950	$2,250	$2,250	$2,250	$2,250	$9,000	$2,250	$2,250	$2,250	$2,250	$9,000	$9,000
Insurance	$275	$275	$275	$275	$275	$275	$275	$275	$275	$275	$275	$275	$3,300	$275	$275	$275	$275	$275	$275	$275	$275	$275	$275	$275	$275	$3,300	$825	$825	$825	$825	$3,300	$825	$825	$825	$825	$3,300	$3,300
Telephone service	$80	$80	$80	$80	$80	$80	$80	$80	$80	$80	$80	$80	$960	$80	$80	$80	$80	$80	$80	$80	$80	$80	$80	$80	$80	$960	$240	$240	$240	$240	$960	$240	$240	$240	$240	$960	$960
Utilities	$930	$930	$930	$930	$930	$930	$930	$930	$930	$930	$930	$930	$11,160	$930	$930	$930	$930	$930	$930	$930	$930	$930	$930	$930	$930	$11,160	$2,790	$2,790	$2,790	$2,790	$11,160	$2,790	$2,790	$2,790	$2,790	$11,160	$11,160
Office supplies	$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
Postage and shipping	$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
Travel	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Entertainment	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Interest on loans	$125	$120	$115	$110	$105	$100	$95	$90	$85	$80	$74	$69	$1,168	$64	$59	$54	$48	$43	$38	$32	$27	$22	$16	$11	$5	$420	$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	$33,418	$28,863	$28,858	$28,853	$28,848	$28,842	$29,837	$28,832	$28,827	$28,822	$28,817	$29,812	$352,628	$46,779	$46,773	$46,768	$46,763	$46,758	$46,752	$46,747	$46,742	$46,736	$46,731	$46,725	$46,720	$560,994	$143,411	$143,411	$143,411	$143,411	$573,643	$147,304	$147,304	$147,304	$147,304	$589,217	$605,367
Net income before taxes and interest	-$3,398	$1,933	$2,739	$3,571	$4,428	$5,313	$7,214	$9,215	$10,248	$11,316	$12,418	$12,558	$77,556	$6,231	$7,658	$9,131	$10,652	$12,224	$13,848	$15,527	$17,261	$19,055	$20,910	$22,829	$24,814	$180,140	$89,452	$110,442	$133,779	$159,774	$493,447	$193,194	$226,437	$263,670	$305,444	$988,746	$1,797,122
Interest Income	$58	$59	$57	$59	$63	$62	$67	$74	$78	$87	$96	$89	$849	$89	$95	$92	$100	$109	$111	$123	$136	$142	$158	$176	$186	$1,518	$696	$886	$1,134	$1,446	$4,163	$1,838	$2,315	$2,885	$3,559	$10,598	$30,727
Provision for taxes on income	$0	$498	$699	$907	$1,123	$1,344	$1,820	$2,322	$2,582	$2,851	$3,129	$3,162	$19,389	$1,580	$1,938	$2,306	$2,688	$3,083	$3,490	$3,912	$4,349	$4,799	$5,267	$5,751	$6,250	$45,035	$22,537	$27,832	$33,728	$40,305	$124,402	$48,758	$57,188	$66,639	$77,251	$249,836	$456,962
NET PROFIT	-$3,340	$1,494	$2,097	$2,722	$3,368	$4,031	$5,461	$6,967	$7,745	$8,552	$9,386	$9,485	$59,015	$4,740	$5,814	$6,917	$8,064	$9,250	$10,469	$11,737	$13,048	$14,398	$15,801	$17,254	$18,750	$136,623	$67,611	$83,496	$101,185	$120,915	$373,207	$146,274	$171,564	$199,916	$231,753	$749,508	$1,370,887

Income Statements

CshFlw

Cash Flow Author: For information about this worksheet, see "Cash-Flow Projections" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.	2023-2024														2024-2025														2025-2026						2026-2027						2027-2028
	April	May	June	July	August	September	October	November	December	January	February	March	TOTAL		April	May	June	July	August	September	October	November	December	January	February	March	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	$46,905	$48,119	$49,370	$50,661	$51,993	$53,368	$57,893	$59,449	$61,056	$62,715	$64,430	$66,202	$672,161		$82,827	$85,048	$87,342	$89,711	$92,159	$94,688	$97,302	$100,005	$102,799	$105,689	$108,678	$111,771	$1,158,021		$363,847	$396,645	$433,109	$473,726	$1,667,327		$532,029	$583,971	$642,147	$707,420	$2,465,567		$3,753,890
Collections	$0	$15,635	$16,040	$16,457	$16,887	$17,331	$17,789	$19,298	$19,816	$20,352	$20,905	$21,477	$201,986		$22,067	$27,609	$28,349	$29,114	$29,904	$30,720	$31,563	$32,434	$33,335	$34,266	$35,230	$36,226	$370,817		$118,112	$128,571	$140,318	$153,396	$540,397		$170,865	$188,886	$207,585	$228,554	$795,890		$1,225,624
Total Cash from Sales	$46,905	$63,754	$65,410	$67,118	$68,880	$70,699	$75,683	$78,747	$80,872	$83,067	$85,335	$87,679	$874,148		$104,895	$112,658	$115,692	$118,825	$122,063	$125,408	$128,865	$132,439	$136,134	$139,955	$143,908	$147,998	$1,528,839		$481,960	$525,216	$573,427	$627,122	$2,207,724		$702,894	$772,857	$849,732	$935,974	$3,261,457		$4,979,514
Income from Financing
Interest Income	$58 Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.	$59	$57	$59	$63	$62	$67	$74	$78	$87	$96	$89	$849		$89	$95	$92	$100	$109	$111	$123	$136	$142	$158	$176	$186	$1,518		$696	$886	$1,134	$1,446	$4,163		$1,838	$2,315	$2,885	$3,559	$10,598		$30,727
Loan Proceeds	$30,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$30,000		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Equity Capital Investments	$100,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$100,000		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Cash from Financing	$130,058	$59	$57	$59	$63	$62	$67	$74	$78	$87	$96	$89	$130,849		$89	$95	$92	$100	$109	$111	$123	$136	$142	$158	$176	$186	$1,518		$696	$886	$1,134	$1,446	$4,163		$1,838	$2,315	$2,885	$3,559	$10,598		$30,727
Other Cash Receipts	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
TOTAL CASH RECEIPTS	$176,963	$63,813	$65,467	$67,177	$68,943	$70,761	$75,749	$78,821	$80,950	$83,154	$85,432	$87,768	$1,004,997		$104,984	$112,752	$115,784	$118,925	$122,172	$125,518	$128,988	$132,575	$136,276	$140,113	$144,084	$148,184	$1,530,356		$482,656	$526,102	$574,561	$628,568	$2,211,887		$704,732	$775,172	$852,618	$939,533	$3,272,055		$5,010,241
CASH DISBURSEMENTS
Inventory	$31,270	$32,081	$32,915	$33,776	$34,664	$35,580	$38,598	$39,635	$40,706	$41,812	$42,956	$59,780	$463,772		$55,217	$56,698	$58,227	$59,806	$61,438	$63,124	$64,867	$66,669	$68,531	$70,458	$72,451	$74,513	$772,000		$242,560	$264,424	$288,732	$315,809	$1,111,525		$354,677	$389,303	$428,085	$471,598	$1,643,663		$2,502,504
Operating Expenses	$32,380	$27,830	$27,830	$27,830	$27,830	$27,830	$28,830	$27,830	$27,830	$27,830	$27,830	$28,830	$340,510		$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$45,802	$549,624		$141,161	$141,161	$141,161	$141,161	$564,643		$145,054	$145,054	$145,054	$145,054	$580,217		$596,367
Commissions/Returns & Allowances	$1,251	$1,283	$1,317	$1,351	$1,386	$1,423	$1,544	$1,585	$1,628	$1,672	$1,718	$1,765	$17,924		$2,209	$2,268	$2,329	$2,392	$2,458	$2,525	$2,595	$2,667	$2,741	$2,818	$2,898	$2,981	$30,881		$9,703	$10,577	$11,550	$12,633	$44,462		$14,187	$15,573	$17,124	$18,865	$65,748		$100,104
Capital Purchases	$55,860	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$55,860		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Loan Payments	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$15,794		$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$15,794		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Income Tax Payments	$0 Author: Note that on your Income Statements, we've generated an estimate for income taxes. This line on the Cash Flow statement is where you should reflect the actual payments you intend to make on a regular basis (probably quarterly).	Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.	$0	$4,847	$0	$0	$4,847	$0	$0	$4,847	$0	$0	$4,848	$19,389		$0	$0	$11,259	$0	$0	$11,259	$0	$0	$11,259	$0	$0	$11,258	$45,035		$33,774	$33,774	$33,774	$33,774	$135,096		$33,774	$33,774	$33,774	$33,774	$135,096		$135,096
Investor Dividend Payments	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Owner's Draw	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
TOTAL CASH DISBURSEMENTS	$122,077	$62,510	$68,225	$64,273	$65,196	$70,997	$70,288	$70,366	$76,327	$72,631	$73,820	$96,540	$913,249		$104,544	$106,084	$118,933	$109,317	$111,014	$124,026	$114,580	$116,454	$129,650	$120,394	$122,467	$135,869	$1,413,333		$427,197	$449,936	$475,217	$503,377	$1,855,726		$547,692	$583,704	$624,037	$669,291	$2,424,725		$3,334,071
NET CASH FLOW	$54,886	$1,303	-$2,758	$2,904	$3,746	-$236	$5,462	$8,455	$4,623	$10,523	$11,612	-$8,772	$91,747		$440	$6,668	-$3,149	$9,609	$11,158	$1,492	$14,408	$16,121	$6,626	$19,719	$21,617	$12,314	$117,023		$55,459	$76,166	$99,344	$125,191	$356,160		$157,040	$191,468	$228,580	$270,242	$847,330		$1,676,170
Opening Cash Balance	$15,000	$69,886	$71,189	$68,431	$71,335	$75,081	$74,846	$80,307	$88,762	$93,385	$103,907	$115,519			$106,747	$107,187	$113,856	$110,706	$120,315	$131,473	$132,965	$147,373	$163,495	$170,120	$189,839	$211,456			$223,771	$279,230	$355,396	$454,740			$579,931	$736,971	$928,439	$1,157,019			$1,427,261
Cash Receipts	$176,963	$63,813	$65,467	$67,177	$68,943	$70,761	$75,749	$78,821	$80,950	$83,154	$85,432	$87,768			$104,984	$112,752	$115,784	$118,925	$122,172	$125,518	$128,988	$132,575	$136,276	$140,113	$144,084	$148,184			$482,656	$526,102	$574,561	$628,568			$704,732	$775,172	$852,618	$939,533			$5,010,241
Cash Disbursements	$122,077	$62,510	$68,225	$64,273	$65,196	$70,997	$70,288	$70,366	$76,327	$72,631	$73,820	$96,540			$104,544	$106,084	$118,933	$109,317	$111,014	$124,026	$114,580	$116,454	$129,650	$120,394	$122,467	$135,869			$427,197	$449,936	$475,217	$503,377			$547,692	$583,704	$624,037	$669,291			$3,334,071
ENDING CASH BALANCE	$69,886	$71,189	$68,431	$71,335	$75,081	$74,846	$80,307	$88,762	$93,385	$103,907	$115,519	$106,747	$106,747		$107,187	$113,856	$110,706	$120,315	$131,473	$132,965	$147,373	$163,495	$170,120	$189,839	$211,456	$223,771	$223,771		$279,230	$355,396	$454,740	$579,931	$579,931		$736,971	$928,439	$1,157,019	$1,427,261	$1,427,261		$3,103,431

Cash Flow Statements

BalSht

Balance Sheet Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet
Not-Too-Sweet				Not-Too-Sweet				Not-Too-Sweet				Not-Too-Sweet				Not-Too-Sweet				Not-Too-Sweet				Not-Too-Sweet				Not-Too-Sweet
First Quarter				Second Quarter				Third Quarter				Fourth Quarter				2024-2025				2025-2026				2026-2027				2027-2028
2023-2024				2023-2024				2023-2024				2023-2024
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	$68,431			Cash	$74,846			Cash	$93,385			Cash	$106,747			Cash	$223,771			Cash	$579,931			Cash	$1,427,261			Cash	$3,103,431
Accounts Receivable	$16,457			Accounts Receivable	$17,789			Accounts Receivable	$20,352			Accounts Receivable	$22,067			Accounts Receivable	$37,257			Accounts Receivable	$52,636			Accounts Receivable	$78,602			Accounts Receivable	$104,275
Inventory	$3			Inventory	$9			Inventory	$15			Inventory	$15,665			Inventory	$15,650			Inventory	$15,624			Inventory	$15,576			Inventory	$15,487
Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0
Total Current Assets		$84,891		Total Current Assets		$92,644		Total Current Assets		$113,752		Total Current Assets		$144,479		Total Current Assets		$276,678		Total Current Assets		$648,192		Total Current Assets		$1,521,439		Total Current Assets		$3,223,193
Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets
Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0
Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0
Equipment	$50,000			Equipment	$50,000			Equipment	$50,000			Equipment	$50,000			Equipment	$50,000			Equipment	$50,000			Equipment	$50,000			Equipment	$50,000
Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860			Computers & Telecommunications	$5,860
(Less Accumlated Depreciation)	$2,738			(Less Accumlated Depreciation)	$5,475			(Less Accumlated Depreciation)	$8,213			(Less Accumlated Depreciation)	$10,950			(Less Accumlated Depreciation)	$21,900			(Less Accumlated Depreciation)	$30,900			(Less Accumlated Depreciation)	$39,900			(Less Accumlated Depreciation)	$48,900
Total Fixed Assets		$53,123		Total Fixed Assets		$50,385		Total Fixed Assets		$47,648		Total Fixed Assets		$44,910		Total Fixed Assets		$33,960		Total Fixed Assets		$24,960		Total Fixed Assets		$15,960		Total Fixed Assets		$6,960
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			$138,013	TOTAL ASSETS			$143,029	TOTAL ASSETS			$161,399	TOTAL ASSETS			$189,389	TOTAL ASSETS			$310,638	TOTAL ASSETS			$673,152	TOTAL ASSETS			$1,537,399	TOTAL ASSETS			$3,230,153
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	$14,809 Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year			Short-Term Notes Payable	$14,995			Short-Term Notes Payable	$15,184			Short-Term Notes Payable	$15,374			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0			Short-Term Notes Payable	$0
Income Taxes Due	-$3,650 Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you've said you will actually pay (as entered on your Cash Flow statements).			Income Taxes Due	-$5,123			Income Taxes Due	-$3,246			Income Taxes Due	-$0			Income Taxes Due	$0			Income Taxes Due	-$10,693			Income Taxes Due	$104,047			Income Taxes Due	$425,913
Other Current Liabilities	$0			Other Current Liabilities	$0			Other Current Liabilities	$0			Other Current Liabilities	$0			Other Current Liabilities	$0			Other Current Liabilities	$0			Other Current Liabilities	$0			Other Current Liabilities	$0
Total Current Liabilities		$11,160		Total Current Liabilities		$9,872		Total Current Liabilities		$11,938		Total Current Liabilities		$15,374		Total Current Liabilities		$0		Total Current Liabilities		-$10,693		Total Current Liabilities		$104,047		Total Current Liabilities		$425,913
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	$11,602			Long-Term Notes Payable	$7,783			Long-Term Notes Payable	$3,916			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0			Long-Term Notes Payable	$0
Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0			Other Long-Term Liabilities	$0
Total Long-Term Liabilities		$11,602		Total Long-Term Liabilities		$7,783		Total Long-Term Liabilities		$3,916		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	$115,000			Paid-In Capital	$115,000			Paid-In Capital	$115,000			Paid-In Capital	$115,000			Paid-In Capital	$115,000			Paid-In Capital	$115,000			Paid-In Capital	$115,000			Paid-In Capital	$115,000
Retained Earnings	$252			Retained Earnings	$10,373			Retained Earnings	$30,546			Retained Earnings	$59,015			Retained Earnings	$195,638			Retained Earnings	$568,845			Retained Earnings	$1,318,353			Retained Earnings	$2,689,240
Total Net Worth		$115,252		Total Net Worth		$125,373		Total Net Worth		$145,546		Total Net Worth		$174,015		Total Net Worth		$310,638		Total Net Worth		$683,845		Total Net Worth		$1,433,353		Total Net Worth		$2,804,240
TOTAL LIABILITIES AND NET WORTH			$138,013	TOTAL LIABILITIES AND NET WORTH			$143,029	TOTAL LIABILITIES AND NET WORTH			$161,399	TOTAL LIABILITIES AND NET WORTH			$189,389	TOTAL LIABILITIES AND NET WORTH			$310,638	TOTAL LIABILITIES AND NET WORTH			$673,152	TOTAL LIABILITIES AND NET WORTH			$1,537,399	TOTAL LIABILITIES AND NET WORTH			$3,230,153

Balance Sheet

BrkEvn

	Break-even Estimates Author: For information about this worksheet, see "Break-Even Analysis" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies. Note that this Worksheet differs from that shown in the book slightly by also factoring the costs of sales commissions and returns/allowances. This gives you a more accurate break-even estimate.
	Year 1 (2023-2024)
	April	$69,620 Author: This is the amount of sales you will need to make each month to break even.
	May	$60,130
	June	$60,120
	July	$60,109
	August	$60,099
	September	$60,088
	October	$62,161
	November	$60,067
	December	$60,057
	January	$60,046
	February	$60,035
	March	$62,108
	Monthly Average	$61,220
	Year 2 (2024-2025)
	April	$97,455
	May	$97,444
	June	$97,434
	July	$97,423
	August	$97,412
	September	$97,401
	October	$97,389
	November	$97,378
	December	$97,367
	January	$97,356
	February	$97,345
	March	$97,333
	Monthly Average	$97,395
	Year 3 (2025-2026)
	1st Quarter	$298,772
	2nd Quarter	$298,772
	3rd Quarter	$298,772
	4th Quarter	$298,772
	Quarterly Average	$298,772
	Year 4 (2026-2027)
	1st Quarter	$306,884
	2nd Quarter	$306,884
	3rd Quarter	$306,884
	4th Quarter	$306,884
	Quarterly Average	$306,884
	Year 5 (2027-2028)
	Annual Average	$1,261,182

Break-even Estimates

Ratios

Key Ratios Author: This sheet provides a mathematical snapshot of your company's performance. These ratios are often used by lenders or investors in determining how well a company is managing its finances.
Year 1 (2023-2024)	Working Capital Author: Working Capital is the amount of readily available funds the company has to cover upcoming expenses. More is better!	Current Ratio Author: This ratio divides your current assets by your current liabilities. In general, it should be greater than 2. If an "N.A." appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.	Quick Ratio Author: Similar to the Current Ratio, but we've subtracted inventory from your assets. A number greater than 1 is desirable. If an "N.A." appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.	Cash Turnover Author: This ratio divides your net sales for the period by your "working capital," (your current assets minus your current liabilities). In other words, it shows by what multiple your sales exceed your working capital. In general, 5 or above is good to aim for, but this can vary based on your industry, etc.	Debt to Equity Author: To calculate your Debt to Equity ratio, we divided your total liabilities by your net worth. A high number (greater than 1), indicates a high debt load relative to your assets. Potential funders may be wary of investing in such a case.	Return on Investment Author: This ratio is achieved by dividing your net worth into your net income for the period. It shows the rate of return you and your investors are receiving on your investments in the company. The higher the better!	Return on Sales Author: This ratio is calculated by dividing your net income for the period by your net sales for the period. The higher the number here, the more profit you are extracting from each sale. Your ideal number will depend greatly on your industry, margins, etc.	Return on Assets Author: Your Return on Assets indicates how much profit you are generating on all the investments you've made in the company's assets. In particular, this will help you (and your investors) determine if you are achieving a good rate-of-return on your investments. This will depend greatly on your industry.	Net Sales
1st Quarter	$73,731	7.61	7.61	2.56	0.20	1%	1%	1%	$188,674.23
2nd Quarter	$82,771	9.38	9.38	2.46	0.14	11%	7%	9%	$203,868.59
3rd Quarter	$101,814	9.53	9.53	2.29	0.11	18%	11%	17%	$233,106.87
4th Quarter	$129,105	9.40	8.38	1.96	0.09	21%	14%	19%	$252,641.31
Year 2 (2024-2025)	$276,678	724,944.29	683,937.71	5.47	0.00	58%	12%	58%	$1,513,147.73
Year 3 (2025-2026)	$658,885	-60.62	-59.16	3.31	-0.02	72%	23%	73%	$2,178,641.05
Year 4 (2026-2027)	$1,417,393	14.62	14.47	2.27	0.07	69%	31%	64%	$3,221,674.43
Year 5 (2027-2028)	$2,797,280	7.57	7.53	1.75	0.15	64%	37%	56%	$4,905,082.60

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2023-2024) Gross Sales Apr il May June July August September October November December January February March 62540 64158 65826.720000000001 67548.092400000009 69324.134148000012 71156.950725960007 77191.15922493441 79265.382409433092 81407.610057621758 83620.528258774182 85906.943123949677 88269.786501428651 Gross Profit April May June July August September October November December January February March 30019.199999999997 30795.839999999997 31596.825600000004 32423.084351999998 33275.58439104 34155.336348460805 37051.756427968518 38047.383556527879 39075.652827658443 40137.853564211611 41235.332699495841 42369.497520685756 Net Profit April May June July August September October November December January February March -3340.1099514100215 1494.4334094529079 2097.1879648334716 2722.4490612091568 3367.9325217278601 4031.3841512167328 5460.9105626049932 6966.7269277456107 7744.6478425444438 8551.7179082072726 9385.9426967472355 9484.9689848661801

NSYr1

Year 1: Net Sales (2023-2024) Chocolate Covered Almonds April May June July August September October November December January February March 10192 10395.84 10603.756799999999 10815.831936 11032.14857472 11252.791546214401 11466 11695.32 11929.2264 12167.810928000001 12411.167146560001 12659.390489491201 Chocolate Covered Hazelnuts April May June July August September October November December January February March 11995.2 12594.96 13224.708000000001 13885.943399999998 14580.24057 15309.252598500003 17326.400000000001 18192.72 19102.356 20057.4738 21060.34749 22113.364864500003 Chocolate Covered Walnuts April May June July August September October November December January February March 9702 9896.0400000000009 10093.960800000001 10295.840016000002 10501.756816320001 10711.791952646401 11760 11995.2 12235.104000000001 12479.80608 12729.4022016 12983.990245632 Chocolate Covered Blueberries April May June July August September October November December January February March 10701.6 10915.632000000001 11133.94464 11356.623532800002 11583.756003456001 11815.4311235251 21 12740 12994.8 13254.696 13519.789920000001 13790.1857184 14065.989432767999 Chocolate Covered Apples 9408 9596.16 9788.0832000000009 9983.8448639999988 10183.521761280001 10387.192196505601 10594.936040435714 10806.834761244427 11022.971456469315 11243.430885598702 11468.299503310678 11697.66549337689 Chocolate Covered Pineapples 9290.4 9476.2080000000005 9665.7321599999996 9859.0468032000008 10056.227739264001 10257.35229404928 11760 11995.2 12235.104000000001 12479.80608 12729.4022016 12983.990245632 Product Line 7 Product Line 8 Product Line 9 Product Line 10

1YrCshFlw

Year 1: Cash Flow (2023-2024) Net Cash Flow April May June July August September October November December January February March 54886.248356567929 1302.7730968650721 -2758.2519325542089 2904.2272136453248 3746.1437292037444 -235.53021368906775 5461.8865802163928 8454.508730591755 4622.584150067225 10522.831457786247 11611.561305604395 -8771.5959688214207 Ending Cash Balance 69886.248356567929 71189.021453433001 68430.769520878792 71334.996734524102 75081.140463727847 74845.610250038793 80307.496830255201 88762.00556084697 93384.589710914195 103907.42116870046 115518.98247430485 106747.38650548342

2ndYrCshFlw

Year 2: Cash Flow (2024-2025) Net Cash Flow April May June July August September October November December January February March 439.86425521457568 6668.2680404564308 -3149.3420693471562 9608.542280710928 11158.210947668747 1492.2813279595284 14407.849286140321 16121.473113210057 6625.801218402019 19718.974517740702 21617.109800627688 12314.429778156831 Ending Cash Balance April May June July August September October November December January February March 107187.25076069799 113855.51880115444 110706.1767318073 120314.71901251824 131472.929960187 132965.21128814653 147373.06057428685 163494.53368749688 170120.3349058989 189839.30942363961 211456.4192242673 223770.8490024241

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 896215.3068501018 1544028.2915396041 2223103.1152023859 3287422.8894486823 5005186.326220219 Gross Profit 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 430183.34728804883 741133.57993900997 1067089.4952971451 1577962.9869353676 2402489.4365857053 Net Profit 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 59015.41683425731 136622.54951382152 373207.00512141432 749507.71723218204 1370886.9388418526

NS5Yr

5-Year Net Sales

Chocolate Covered Almonds 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 136621.28382098561 276020.80660485919 358812.65118277608 466437.73066398309 606344.72020369524 Chocolate Covered Hazelnuts 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 199442.96672299999 391320.3045790632 720323.92059119837 1325938.2263182348 2440724.4154393678 Chocolate Covered Walnuts 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 135384.8921121984 213587.5289204267 277652.64674857666 360933.9582518916 469195.31920524029 Chocolate Covered Blueberries 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 147872.44837094913 239218.0323908779 310970.96435840591 404246.03324211872 525498.75750986917 Chocolate Covered Apples 126180.94016222133 170870.02313634136 222122.11739886145 288747.16660151345 375356.25536419248 Chocolate Covered Pineapples 132788.46952374527 222131.03007724378 288758.75261851982 375371.31658196734 487963.13197345007 Product Line 7 Product Line 8 Product Line 9 Product Line 10

License

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

About

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

http://www.planningshop.com/

Config

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

Startup Year

2023
Sure Product Consulting: Sure Product Consulting: How does this get set? Headings on each worksheet are driven from it, but this does not seem to be connected t the Setup worksheet "what year wll your business start" question.

Version:

Startup Month

3.0

April

8/1/13

Startup Month Abbrev

Apr

Start Date:

Mar-19

CREDIT MULTIPLIER

Multiple

With "Credit Sales"

0.00

1.00

0.25

Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet

$73,731

$82,771

$101,814

$129,105

$276,678

$658,885

$1,417,393

$2,797,280

Chart Titles

Year 1 String

2023-2024

Year 1: Financials at-a-Glance (2023-2024)

Year 2 String

2024-2025

Year 1: Net Sales (2023-2024)

Year 3 String

2025-2026

Year 1: Cash Flow (2023-2024)

Year 4 String

2026-2027

Year 2: Cash Flow (2024-2025)

Year 5 String

2027-2028

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

April

May

June

July

August

September

October

November

December

January

February

March

Match Position in Doublelist

Adjust index to 1-12

Abbrev

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

To-Do List

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

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

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

Adding "Reset_XXX" subroutines for ALL the worksheets

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

Your Company Name

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

DepnSchedule

Sure Product Consulting: Is this depreciation schedule correct? If only one year of service, nothing is depreciated. If more than one year, we don't depreciate anything for year 1 it seems (or does that show up as an expense?)	Depreciation Schedule from CapEx Worksheet
														Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24
Item#	Category	Item Name	Purch Value	Salvage Value	Yrs of Service	Mos of Service	Month Purchased	Year Purchased	Purchase Month	End Month	End Date	Depn Amt montly		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
1	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	- Sure Product Consulting: If "today's" month is one in this asset is dep'd over,	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Equip	Packaging machine	$10,000.00	$1,500.00	5	60	Apr	2023	1	60	Feb-24	$ 142		142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142
12	Equip	Procduction machine	$10,000.00	$1,500.00	5	60	Apr	2023	1	60	Feb-24	$ 142		142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142	142
13	Equip	Van #1	$15,000.00	$1,000.00	5	60	Apr	2023	1	60	Feb-24	$ 233		233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233
14	Equip	Van #2	$15,000.00	$1,000.00	5	60	Apr	2023	1	60	Feb-24	$ 233		233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233	233
15	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
21	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
22	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
23	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
24	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
25	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
26	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
27	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
28	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
29	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
30	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
31	Comp	Computer #1	$1,500.00	$200.00	2	24	Apr	2023	1	24	Feb-21	$ 54		54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
32	Comp	Computer #2	$1,500.00	$200.00	2	24	Apr	2023	1	24	Feb-21	$ 54		54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
33	Comp	Computer #3	$1,500.00	$200.00	2	24	Apr	2023	1	24	Feb-21	$ 54		54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	54	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
34	Comp	Software	$400.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ 33		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
35	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
36	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
37	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
38	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
39	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
40	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
41	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
42	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
43	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
44	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
45	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
46	Comp	Phone system	$960.00	$100.00	1	12	Apr	2023	1	12	Feb-20	$ 72		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
47	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
48	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
49	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
50	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
51	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
52	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
53	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
54	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
55	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
56	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
57	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
58	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
59	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
60	Land	Item Name (change name here)	$0.00	$0.00	1	12	Apr	2023	1	12	Feb-20
		TOTAL												$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 912	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750	$ 750
		Land												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Facilities												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Equip												50,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Comp												5,860	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL Author: This goes into Cash Flow statement.											Author: This goes into Cash Flow statement.	55,860	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL NON-DEPRECIABLE CAPITAL ASSETS Author: This goes into Income statement under "non-depreciable capital purchases"											Author: This goes into Income statement under "non-depreciable capital purchases"	Author: This goes into Cash Flow statement.	Author: This goes into Income statement under "non-depreciable capital purchases"												1,360	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-

Depreciation Schedule

LoanInvestSchedules

	Investment Proceeds										Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds
											Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24
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	Gift	$50,000			Apr	2023	1				50,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	Venture Capitalist (10%)	$50,000			Apr	2023	1				50,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
3	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
4	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
5	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
6	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
7	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
8	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
9	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
10	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
11	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
12	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
13	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
14	Investment Source Name	$0			Apr	2023	1				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
15	Investment Source Name	$0			Apr	2023	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:		$100,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)
											Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24 Sure Product Consulting: Note: We calculate loan payments beyond the end date of this business plan (5 years into future), in order to populate the Balance Sheet properly. Payments due in year 6 need to appear on the Short-Term Notes Payable line of Balance Sheet for Year 5. The remainder of the not-yet-made loan payments appear on Long-Term Notes Payable line of the Year 5 balance sheet.	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25
Loan #	Name of Loan Source	Amount	Rate	Periods	Start Month	Start Year	Begin Pay Month	End Pay Month	Pmt Amt (P+I)		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70	71	72
1	Friends and Family	$30,000	5.00%	24	Apr	2023	1	24	1,316.14		1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	1,316.14	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 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	First Horizon Bank	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
3	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
4	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
5	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
6	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
7	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
8	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
9	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
10	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
11	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
12	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
13	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
14	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
15	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
16	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
17	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
18	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
19	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
20	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	- 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
									TOTAL:		$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$1,316	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
											Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25
Loan #	Name of Loan Source	Amount	Rate	Periods	Start Month	Start Year	Begin Pay Month	End Pay Month	Pmt Amt (P+I)		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70	71	72
1	Friends and Family	$30,000.00	$0.05	$24.00	Apr	$2,023.00	1	24	1,316.14		125.00	120.04	115.05	110.05	105.02	99.98	94.91	89.82	84.71	79.58	74.43	69.25	64.06	58.84	53.60	48.34	43.06	37.76	32.43	27.08	21.71	16.32	10.90	5.46	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	First Horizon Bank	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0	0.00%	12	Apr	2023	1	12	-		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:		$125	$120	$115	$110	$105	$100	$95	$90	$85	$80	$74	$69	$64	$59	$54	$48	$43	$38	$32	$27	$22	$16	$11	$5	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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
											Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24
Loan #	Name of Loan Source	Amount			Start Month	Start Year	Begin Pay Month				1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
1	Friends and Family	$30,000			Apr	2023	1				30,000.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	First Horizon Bank	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0			Apr	2023	1				-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:		$30,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	Loan Calculations for Balance Sheet										Loan Calculations for Balance Sheet												Loan Calculations for Balance Sheet
											First Quarter			Second Quarter			Third Quarter			Fourth Quarter			Year 2			Year 3			Year 4			Year 5
Loan #	Name of Loan Source	Amount	Rate	Periods	Start Month	Start Year	Begin Pay Month	Amount			Principle Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long
1	Friends and Family	$30,000.00	5.00%	24	Apr	2023	1	$30,000			$3,588	$14,809 Sure Product Consulting: If received proceeds this quarter, "Due Short" is all the payment of principle (not interest) due in the next 12 months from disbursement	$11,602 Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out.	$7,222 Sure Product Consulting: cummulative principle paid: includes previous quarter's payments	$14,995	$7,783	$10,901	$15,184	$3,916	$14,626	$15,374	$0	$30,000	$0	$0	$30,000	$0	$0	$30,000	$0	$0	$30,000	$0	$0
2	First Horizon Bank	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
3	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
4	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
5	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
6	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
7	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
8	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
9	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
10	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
11	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
12	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
13	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
14	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
15	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
16	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
17	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
18	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
19	Loan Source Name	$0.00	0.00%	12	Apr	2023	1	$0			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
20	Loan Source Name	$0.00	0.00%	12	Apr	2023	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:			$14,809	$11,602		$14,995	$7,783		$15,184	$3,916		$15,374	$0		$0	$0		$0	$0		$0	$0		$0	$0
	BETA - Monthly Loan Calculations for Balance Sheet										Loan Calculations for Balance Sheet												Loan Calculations for Balance Sheet
											Mar-19	Apr-19	May-19	Mar-19	Jul-19	Aug-19	Mar-19	Oct-19	Nov-19	Mar-19	Jan-20	Feb-20	Mar-19	Apr-20	May-20	Mar-19	Jul-20	Aug-20	Mar-19	Oct-20	Nov-20	Mar-19	Jan-21	Feb-21	Mar-19	Apr-21	May-21	Mar-19	Jul-21	Aug-21	Mar-19	Oct-21	Nov-21	Mar-19	Jan-22	Feb-22	Mar-19	Apr-22	May-22	Mar-19	Jul-22	Aug-22	Mar-19	Oct-22	Nov-22	Mar-19	Jan-23	Feb-23	Mar-19	Apr-23	May-23	Mar-19	Jul-23	Aug-23	Mar-19	Oct-23	Nov-23	Mar-19	Jan-24	Feb-24
Loan #	Name of Loan Source	Amount	Rate	Periods	Start Month	Start Year	Begin Pay Month	Last Month Num			1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
1	Friends and Family	$30,000.00	5.000%	24	Apr	$2,023.00	1	24		Principle Paid	$1,191.14	$2,387.25	$3,588.34	$4,794.43	$6,005.55	$7,221.71	$8,442.94	$9,669.26	$10,900.69	$12,137.26	$13,378.97	$14,625.86	$15,877.94	$17,135.24	$18,397.78	$19,665.58	$20,938.66	$22,217.04	$23,500.76	$24,789.82	$26,084.25	$27,384.08	$28,689.32	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00
										Due Short	$14,686.80	$14,747.99	$14,809.44	$14,871.15	$14,933.11	$14,995.33	$15,057.81	$15,120.55	$15,183.56	$15,246.82	$15,310.35	$15,374.14	$14,122.06	$12,864.76	$11,602.22	$10,334.42	$9,061.34	$7,782.96	$6,499.24	$5,210.18	$3,915.75	$2,615.92	$1,310.68	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
										Due Long	$14,122.06	$12,864.76	$11,602.22	$10,334.42	$9,061.34	$7,782.96	$6,499.24	$5,210.18	$3,915.75	$2,615.92	$1,310.68	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$0.00	-$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	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000	$30,000

Question (W7)

Warning

Welcome

Setup

SalesProj

Inventory

CapEx

StaffBudj

MktBudj

ProSvs

CapInvest

IncSt

CshFlw

BalSht

BrkEvn

Ratios

1YrAtGl

NSYr1

1YrCshFlw

2ndYrCshFlw

5YrAtGl

NS5Yr

License

About

Config

DepnSchedule

LoanInvestSchedules

image1.gif

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.jpeg

image11.jpeg

image12.jpeg

image13.png

image14.png

image15.jpeg