Management

food_truck_.xls

MainInstructions

	BudgetPlanner13a- Five-Year Forcasting Model
PRIMARY DRIVER PAGE	Instructions
	USE & AGREEMENT
Company Name	Arabian Delights Company
Primary Business	Entrepreneurial Enterprise		Contents
	Worksheet Listing
Main Entry Page	Master Budget	Fixed administrative and products costs, basic assumptions, three years in detail, years 4 & 5 progression
Capital Budget	CapBudget	Fixed assets and intellectual property over 5 years
Sales/Products	Revenue/ Cost Assumptions	Product definitions, sales pricing, direct product costs, labor component
Working Capital		Define cash flow assumptions related to product sales and production
Administrative	Admin, Admin2, Admin3	Administrative Salaries, Marketing, Promotion & Sales Plan, R&D, Custom SG&A for three years
Financing	Finc1, Finc2, Finc345	Defining initial capital, borrowing needs over three years
Reporting	Master1, Master2, Master3, FinSum1, BalSheet	Projected financials, 3 years of detail, 2 five year summaries
Graphics
Valuation
Topical index
Historical Financials	TBA	Balance Sheets, Income Statements, Changes in Equity Past Two Years
Seed Capital	TBA	Seed, Angel,Venture, Exit, Bootstrapping, Dividend Structure, Capital Structure

Entering your company name here will add it to each worksheet and report page.

You will use this page to transfer to the various worksheet pages and print the results. You may also transfer to the indivdual worksheets by clicking on the page description below. Please read the USE & AGREEMENT before starting.

The recipient of this product, BUDGETPLANNER14 understands that this product is the intellectual property of M. David Gorton, [email protected]. The recipient has permission to use this product for educational, and individual use but agrees not to use the product for commercial purposes without the express written consent of the author. The user of this product assumes all risks of using this information and holds the author of this product harmeless for representations using this product or errors of use or errors in this product. It is also assumed that the user of this product has a basic working knowledge of accounting, finance, general business terminology and related issues. BUDGEPLANNER, Copyright 2001 - 2015, M. David Gorton; all rights reserved.

CapBudget – Sets out your capital purchasing for the next 5 years. Fill in data as needed in the year you expect the asset to be acquired. The sheet will calculate the depreciation on a straight-line basis and inserts it where needed.

Instructions BudgetPlanner13a BudgetPlanner13a is an Excel spreadsheet [BudgetPlanner13a.exe] designed to give you five years of financial projections for your organization. The first three years are prepared with monthly detail. The latter two years are more general. A certain amount of data is already loaded for XYZ Company for illustrative and testing purposes. You will need to customize the information to your own organization’s needs. Cells shaded in blue throughout the spreadsheet, require changes in the data. Other cells such as those that are shaded in yellow or contain a formula should not be changed. It is assumed that the user has a basic knowledge of both spreadsheet operations, finance and accounting. The user should also remember to keep the original copy of the spreadsheet intact and back up work as the project progresses. Getting Started – When you open the spreadsheet you will be in the MasterBudget page (there are over 15 linked pages in support). MasterBudget is the main driver page for your assumptions. You will need to fill in the “per month” columns and “inflation” numbers on this page based on your research. The amounts shaded in yellow come from other supporting pages.

Master1 – This is the detailed monthly operating and cashflow report for year 1, based upon all of your other input (this page does not require any input). Master2 – This is the detailed monthly operating and cashflow report for year 2, based upon all of your other input (this page does not require any input). Master3 – This is the detailed monthly operating and cashflow report for year 3, based upon all of your other input (this page does not require any input). FinSum1 - This worksheet gives you a summery of the projected income statements and cash flows, with performance indicators (this page does not require any input). BalSheet – Gives a five year forecast for the balance sheet consistent with all other input data (this page does not require any input).

Admin1 – Provides salary and employee information necessary to complete payroll for year 1. Allows for an advertising and promotion strategy. Part of the administrative salaries can be allocated to production as well. This sheet also allows for the input of R&D costs on a custom basis and up to four lines of custom SG&A. The titling for these accounts is input in MasterBudget. Admin2 – Requires same data as Admin1 for year 2. Admin3 – Requires same data as Admin1 for year 3.

Financing1 – Sets your first year capital injection and allows two long-term loans. Calculates loan payments, and amortizes the loans. Insert the owners’ contribution and the loans, annual interest rates and duration in months. The spreadsheet will calculate a level payment, determine interest and the necessary cash flows. Financing2 – Continues on through year 2 from Financing1. (If there are no new loans, this page does not require any input). Financing345 - Continues on through years 3,4 & 5 from Financing1. (If there are no new loans, this page does not require any input

The Product Assumption Pages, workshees allow you to create a custom revenue patterns, cash flows and product costs for up to four distinct product groups over a 3 year period. Product pricing and direct cost data is entered on Product1, Product2 & Product3.

MasterBudget

Arabian Delights Company			Master Budget Assumptions - Drivers
GENERAL INSTRUCTIONS		Per		Year1	Per	Year2	Per	Year3	Inflate	Year4	Year5
		Month			Month		Month
Sales				$ 113,110		$ 119,060		$ 119,060	10%	130,965	144,062
COGS
Product Costs				39,588		41,671		41,671		45,838	50,422
Labor & Benefits				- 0		- 0		- 0		- 0	- 0
		- 0		- 0	- 0	- 0	- 0	- 0	5%	- 0	- 0
		- 0		- 0	- 0	- 0	- 0	- 0	5%	- 0	- 0
		- 0		- 0	- 0	- 0	- 0	- 0	5%	- 0	- 0
				- 0		- 0		- 0	5%	- 0	- 0
				- 0		- 0		- 0	5%	- 0	- 0
				- 0		- 0		- 0	5%	- 0	- 0
COGS				39,588		41,671		41,671		45,838	50,422
Gross Profit				73,521		77,389		77,389		85,128	93,640
SG&A
Salary				36,360		38,400		42,240	5%	44,352	46,570
PR Taxes & Benefits				4,545		4,800		5,280		5,544	5,821
Advertising & Promotion				- 0		- 0		- 0	5%	- 0	- 0
Phone & Telecommunications		100		1,200	100	1,200	100	1,200	5%	1,260	1,323
Postage		5		60	5	60	5	60	5%	63	66
Depreciation		560		6,714	560	6,714	560	6,714		6,714	6,714
Rent		100		1,200	100	1,200	100	1,200		1,200	1,200
Insurance		50		600	50	600	50	600	5%	630	662
Utilities		800		9,600	800	9,600	800	9,600	5%	10,080	10,584
Office Supplies		15		180	15	180	15	180	5%	189	198
Professional Fees		50		600	50	600	50	600	5%	630	662
State Taxes	2.00%			2,262		2,381		2,381		2,619	2,881
Misc.		50		600	50	600	50	600	5%	630	662
Travel		50		600	50	600	50	600	5%	630	662
Interest				1,785		1,583		1,179		751	297
R&D Expenses				- 0		- 0		- 0	5%	- 0	- 0
Bad Debts				- 0		- 0		- 0		- 0	- 0
				- 0		- 0		- 0	5%	- 0	- 0
Legal				1,000		- 0		- 0	5%	- 0	- 0
Permits				1,000		- 0		- 0	5%	- 0	- 0
				- 0		- 0		- 0	5%	- 0	- 0
Amort Intangibles		- 0		- 0	- 0	- 0	- 0	- 0		- 0	- 0
				68,306		68,518		72,435		75,293	78,301
Operating Income				5,215		8,871		4,954		9,835	15,339
Income Taxes	0.0%			- 0		- 0		- 0		- 0	- 0
Net Income				5,215		8,871		4,954		9,835	15,339
Other:
Deposits

You may leave as is or insert actual year of forecast.

For forecast years 4 and 5 you will choose general growth (or declining) percentage rates in this column.

You may choose a custom title for these fixed monthly production costs.

For forecast years 4 and 5 you will choose general growth (or declining) percentages.

You may choose a custom title for these custom SG&A expenses. Enter data in Admin1,Admin2,Admin3

Choose an estimated tax rate based on a % of sales.

Choose an estimated federal and state income corporate tax rate. SUB-S Corp., Partnerships and Sole Proprietors enter "0".

Enter line item information to create five years of income statements. This also drives cash flow projections. You may only enter information in the blue cells. The remainng information comes from other worksheets.

Enter flat montly amounts in the blue cells in this column.

For forecast years 4 and 5 you will choose general growth (or declining) percentages.

BalSheet

Arabian Delights Company
	PROJECTED BALANCE SHEETS
	Year1	Year2	Year3	Year4	Year5
ASSETS
Cash	4,771	13,819	18,546	27,727	41,958
Accounts Receivable					- 0
Inventory					- 0
Other Current Assets
Current Assets	4,771	13,819	18,546	27,727	41,958
PP&E	46,500	46,500	46,500	46,500	46,500
Accum. Depreciation	(6,714)	(13,429)	(20,143)	(26,857)	(33,571)
Intangibles	- 0	- 0	- 0	- 0	- 0
Accum. Amortization	- 0	- 0	- 0	- 0	- 0
Other Assets	- 0	- 0	- 0	- 0	- 0
Total Assets	44,557	46,890	44,903	47,370	54,886
LIABILITIES
Payables	- 0	- 0	- 0	- 0	- 0
Accruals	- 0
Taxes	- 0
Credit Line	- 0
Current Portion LTD	- 0
Current Liabilities	- 0	- 0	- 0	- 0	- 0
Long Term Debt	29,342	22,805	15,864	8,496	673
Other Liabililities
Total Liabilities	29,342	22,805	15,864	8,496	673
EQUITY
Common Equity	10,000	10,000	10,000	10,000	10,000
Angel/Venture Equity
Retained Earnings	5,215	14,085	19,039	28,873	44,213
Total Equity	15,215	24,085	29,039	38,873	54,213
Total Liabilities & Equity	44,557	46,890	44,903	47,370	54,886

Fin Sum1

Arabian Delights Company	PROJECTED FINANCIAL STATEMENTS
	Year1	Year2	Year3	Year4	Year5
Income Statement
Sales/Units	13,307	14,007	14,007	15,408	16,948
		- 0
Sales	113,110	119,060	119,060	130,965	144,062
Product Costs
Product	39,588	41,671	41,671	45,838	50,422
Labor & Benefits	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
COGS	39,588	41,671	41,671	45,838	50,422
GP	73,521	77,389	77,389	85,128	93,640
SG&A
Salary & Benefits	36,360	38,400	42,240	44,352	46,570
PR Taxes & Benefits	4,545	4,800	5,280	5,544	5,821
Advertising & Promo.	- 0	- 0	- 0	- 0	- 0
Phone & Telecommunications	1,200	1,200	1,200	1,260	1,323
Postage	60	60	60	63	66
Depreciation	6,714	6,714	6,714	6,714	6,714
Rent	1,200	1,200	1,200	1,200	1,200
Insurance	600	600	600	630	662
Utilities	9,600	9,600	9,600	10,080	10,584
Office Supplies	180	180	180	189	198
Professional Fees	600	600	600	630	662
State Taxes	2,262	2,381	2,381	2,619	2,881
Interest	1,785	1,583	1,179	751	297
Misc.	600	600	600	630	662
Travel	600	600	600	630	662
Bad Debts	- 0	- 0	- 0	- 0	- 0
R&D Expenses	- 0	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
Legal	1,000	- 0	- 0	- 0	- 0
Permits	1,000	- 0	- 0	- 0	- 0
0	- 0	- 0	- 0	- 0	- 0
Amort Intangibles	- 0	- 0	- 0	- 0	- 0
Administrative Costs	68,306	68,518	72,435	75,293	78,301
Operating Income	5,215	8,871	4,954	9,835	15,339
Income Taxes	- 0	- 0	- 0	- 0	- 0
Projected Net Income	5,215	8,871	4,954	9,835	15,339
Cash Flow
Beginning Cash	- 0	4,771	13,819	18,546	27,727
Projected Net Income	5,215	8,871	4,954	9,835	15,339
Add Back Depr./Amort.	6,714	6,714	6,714	6,714	6,714
Capital Injection	10,000	- 0	- 0	- 0	- 0
Debt	35,000	- 0
Fixed Assets	(46,500)	- 0	- 0	- 0	- 0
Working Capital	- 0	- 0	- 0
Deposits	- 0	- 0	- 0	- 0	- 0
Organization Costs	- 0	- 0	- 0	- 0	- 0
Debt Service	(5,658)	(6,537)	(6,940)	(7,368)	(7,823)
Net Cash Flow	4,771	9,048	4,728	9,180	14,231
Ending Cash	4,771	13,819	18,546	27,727	41,958
Performance
Gross Profit Margin%	65.0%	65.0%	65.0%	65.0%	65.0%
Admin/Sales	60.4%	57.5%	60.8%	57.5%	54.4%
Operating Inc./Sales	4.6%	7.5%	4.2%	7.5%	10.6%
Average Marketing Cost/Sale	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Master1

Arabian Delights Company				Master Budget by Month Year1
Month	1	2	3	4	5	6	7	8	9	10	11	12	Total	%
Sales/Units	900	933	966	1,000	1,180	1,190	1,300	1,300	1,286	1,186	1,066	1,000	13,307
Sales	7,650	7,931	8,211	8,500	10,030	10,115	11,050	11,050	10,931	10,081	9,061	8,500	113,110	100.0%
Product Costs
Product	2,677	2,776	2,874	2,975	3,510	3,540	3,867	3,867	3,826	3,528	3,171	2,975	39,588	35.0%
Labor & Benefits	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
COGS	2,677	2,776	2,874	2,975	3,510	3,540	3,867	3,867	3,826	3,528	3,171	2,975	39,588	35.0%
GP	4,973	5,155	5,337	5,525	6,520	6,575	7,183	7,183	7,105	6,553	5,890	5,525	73,521	65.0%
Administration
Salary & Benefits	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	36,360	32.1%
PR Taxes & Benefits	379	379	379	379	379	379	379	379	379	379	379	379	4,545	4.0%
Advertising & Promo.	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Phone & Telecommunications	100	100	100	100	100	100	100	100	100	100	100	100	1,200	1.1%
Postage	5	5	5	5	5	5	5	5	5	5	5	5	60	0.1%
Depreciation	560	560	560	560	560	560	560	560	560	560	560	560	6,714	5.9%
Rent	100	100	100	100	100	100	100	100	100	100	100	100	1,200	1.1%
Insurance	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Utilities	800	800	800	800	800	800	800	800	800	800	800	800	9,600	8.5%
Office Supplies	15	15	15	15	15	15	15	15	15	15	15	15	180	0.2%
Professional Fees	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
State Taxes	153	159	164	170	201	202	221	221	219	202	181	170	2,262	2.0%
Interest	- 0	175	172	170	167	165	162	160	157	155	152	149	1,785	1.6%
Misc.	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Travel	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Bad Debts													- 0	0.0%
R&D Expenses	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Legal	1,000	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	1,000	0.9%
Permits	1,000	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	1,000	0.9%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Amort Intangibles	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Administrative Costs	7,341	5,522	5,525	5,528	5,556	5,555	5,572	5,569	5,564	5,544	5,521	5,508	68,306	60.4%
Operating Income	(2,369)	(367)	(188)	(3)	963	1,019	1,611	1,613	1,541	1,008	368	17	5,215	4.6%
Income Taxes												- 0	- 0
Projected Net Income	(2,369)	(367)	(188)	(3)	963	1,019	1,611	1,613	1,541	1,008	368	17	5,215
Cash Flow
Beginning Cash	- 0	(3,309)	(3,618)	(3,751)	(3,701)	(2,688)	(1,621)	35	1,691	3,273	4,318	4,721	- 0
Operating Income	(2,369)	(367)	(188)	(3)	963	1,019	1,611	1,613	1,541	1,008	368	17	5,215
Add Back Depr./Amort.	560	560	560	560	560	560	560	560	560	560	560	560	6,714
Capital	10,000	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	10,000
Debt	35,000												35,000
Fixed Assets	(46,500)	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	(46,500)
Working Capital													- 0
Deposits	- 0												- 0
Intangibles	- 0												- 0
Debt Service	- 0	(502)	(504)	(507)	(509)	(512)	(514)	(517)	(519)	(522)	(525)	(527)	(5,658)
Net Cash Flow	(3,309)	(309)	(132)	50	1,014	1,067	1,656	1,656	1,581	1,046	403	50	4,771
Ending Cash	(3,309)	(3,618)	(3,751)	(3,701)	(2,688)	(1,621)	35	1,691	3,273	4,318	4,721	4,771	4,771

Master2

Arabian Delights Company				Master Budget by Month Year2
Month	1	2	3	4	5	6	7	8	9	10	11	12	Total	%
Sales/Units	1,000	1,033	1,066	1,100	1,180	1,290	1,400	1,400	1,286	1,186	1,066	1,000	14,007
Sales	8,500	8,781	9,061	9,350	10,030	10,965	11,900	11,900	10,931	10,081	9,061	8,500	119,060	100.0%
Product Costs
Product	2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671	35.0%
Labor & Benefits	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
COGS	2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671	35.0%
GP	5,525	5,707	5,890	6,078	6,520	7,127	7,735	7,735	7,105	6,553	5,890	5,525	77,389	65.0%
Administration
Salary & Benefits	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	38,400	32.3%
PR Taxes & Benefits	400	400	400	400	400	400	400	400	400	400	400	400	4,800	4.0%
Advertising & Promo.	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Phone & Telecommunications	100	100	100	100	100	100	100	100	100	100	100	100	1,200	1.0%
Postage	5	5	5	5	5	5	5	5	5	5	5	5	60	0.1%
Depreciation	560	560	560	560	560	560	560	560	560	560	560	560	6,714	5.6%
Rent	100	100	100	100	100	100	100	100	100	100	100	100	1,200	1.0%
Insurance	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Utilities	800	800	800	800	800	800	800	800	800	800	800	800	9,600	8.1%
Office Supplies	15	15	15	15	15	15	15	15	15	15	15	15	180	0.2%
Professional Fees	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
State Taxes	170	176	181	187	201	219	238	238	219	202	181	170	2,381	2.0%
Interest	147	144	141	139	136	133	131	128	125	122	120	117	1,583	1.3%
Misc.	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Travel	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Bad Debts													- 0	0.0%
R&D Expenses	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Legal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Permits	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Amort Intangibles	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Administrative Costs	5,696	5,699	5,702	5,705	5,716	5,732	5,748	5,745	5,723	5,704	5,680	5,666	68,518	57.5%
Operating Income	(171)	8	188	372	803	1,395	1,987	1,990	1,382	849	209	(141)	8,871	7.5%
Income Taxes												- 0	- 0
Projected Net Income	(171)	8	188	372	803	1,395	1,987	1,990	1,382	849	209	(141)	8,871
Cash Flow
Beginning Cash	4,771	4,629	4,664	4,876	5,270	6,092	7,503	9,504	11,504	12,894	13,748	13,960	4,771
Operating Income	(171)	8	188	372	803	1,395	1,987	1,990	1,382	849	209	(141)	8,871
Add Back Depr./Amort.	560	560	560	560	560	560	560	560	560	560	560	560	6,714
Capital	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Debt													- 0
Fixed Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Working Capital													- 0
Deposits													- 0
Intangibles													- 0
Debt Service	(530)	(533)	(535)	(538)	(541)	(543)	(546)	(549)	(552)	(554)	(557)	(560)	(6,537)
Net Cash Flow	(142)	35	212	394	822	1,411	2,000	2,000	1,390	854	212	(142)	9,048
Ending Cash	4,629	4,664	4,876	5,270	6,092	7,503	9,504	11,504	12,894	13,748	13,960	13,819	13,819

Master3

Arabian Delights Company				Master Budget by Month Year3
Month	1	2	3	4	5	6	7	8	9	10	11	12	Total	%
Sales/Units	1,000	1,033	1,066	1,100	1,180	1,290	1,400	1,400	1,286	1,186	1,066	1,000	14,007
Sales	8,500	8,781	9,061	9,350	10,030	10,965	11,900	11,900	10,931	10,081	9,061	8,500	119,060	100.0%
Product Costs
Product	2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671	35.0%
Labor & Benefits	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
COGS	2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671	35.0%
GP	5,525	5,707	5,890	6,078	6,520	7,127	7,735	7,735	7,105	6,553	5,890	5,525	77,389	65.0%
Administration
Salary & Benefits	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	42,240	35.5%
PR Taxes & Benefits	440	440	440	440	440	440	440	440	440	440	440	440	5,280	4.4%
Advertising & Promo.	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Phone & Telecommunications	100	100	100	100	100	100	100	100	100	100	100	100	1,200	1.0%
Postage	5	5	5	5	5	5	5	5	5	5	5	5	60	0.1%
Depreciation	560	560	560	560	560	560	560	560	560	560	560	560	6,714	5.6%
Rent	100	100	100	100	100	100	100	100	100	100	100	100	1,200	1.0%
Insurance	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Utilities	800	800	800	800	800	800	800	800	800	800	800	800	9,600	8.1%
Office Supplies	15	15	15	15	15	15	15	15	15	15	15	15	180	0.2%
Professional Fees	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
State Taxes	170	176	181	187	201	219	238	238	219	202	181	170	2,381	2.0%
Interest	114	111	108	106	103	100	97	94	91	88	85	82	1,179	1.0%
Misc.	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Travel	50	50	50	50	50	50	50	50	50	50	50	50	600	0.5%
Bad Debts													- 0	0.0%
R&D Expenses	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Legal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Permits	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Amort Intangibles	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0.0%
Administrative Costs	6,024	6,026	6,029	6,032	6,043	6,059	6,074	6,072	6,049	6,029	6,006	5,992	72,435	60.8%
Operating Income	(499)	(319)	(139)	45	477	1,069	1,661	1,663	1,056	523	(116)	(467)	4,954	4.2%
Income Taxes												- 0	- 0
Projected Net Income	(499)	(319)	(139)	45	477	1,069	1,661	1,663	1,056	523	(116)	(467)	4,954
Cash Flow
Beginning Cash	13,819	13,317	12,992	12,844	12,878	13,340	14,391	16,032	17,672	18,702	19,196	19,048	13,819
Operating Income	(499)	(319)	(139)	45	477	1,069	1,661	1,663	1,056	523	(116)	(467)	4,954
Add Back Depr./Amort.	560	560	560	560	560	560	560	560	560	560	560	560	6,714
Capital	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Debt													- 0
Fixed Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Working Capital													- 0
Deposits													- 0
Intangibles													- 0
Debt Service	(563)	(565)	(568)	(571)	(574)	(577)	(580)	(583)	(586)	(588)	(591)	(594)	(6,940)
Net Cash Flow	(502)	(325)	(148)	34	462	1,051	1,640	1,640	1,030	494	(148)	(502)	4,728
Ending Cash	13,317	12,992	12,844	12,878	13,340	14,391	16,032	17,672	18,702	19,196	19,048	18,546	18,546

CapBudget

Arabian Delights Company				Life	Monthly
					Depr.
Intangible Costs				Years	Exp.
Trademark/Patent
Patents
			- 0
			- 0			Cost Each
Total			- 0	17	- 0
					Month	1	2	3	4	5	6	7	8	9	10	11	12
Capital Budget YR1
Item	Cost Ea.	Quant.
PRODUCTION
	- 0	1	- 0	5	- 0
	- 0	1	- 0	10	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
					- 0	- 0	0	0	0	0	0	0	0	0	0	0	0
ADMINISTRATIVE		1
	- 0	1	- 0	10	- 0
	- 0	1	- 0	7	- 0
Computer Equip	1,500	1	1,500	3	42	1,500
Truck	40,000	1	40,000	7	476	40,000
Kitchen Equipment	5,000	1	5,000	10	42	5,000
	- 0	1	- 0	5	- 0	- 0
	- 0	1	- 0	5	- 0
		1	- 0	5	560	46,500	0	0	0	0	0	0	0	0	0	0	0
			46,500		560	46,500	0	0	0	0	0	0	0	0	0	0	0
						1	2	3	4	5	6	7	8	9	10	11	12
Capital Budget YR2
Item	Cost Ea.	Quantity
PRODUCTION
	- 0	1	- 0	5	- 0
	- 0	1	- 0	10	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
		1				- 0	0	0	0	0	0	0	0	0	0	0	0
ADMINISTRATIVE		1	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
	- 0	1	- 0	5	- 0
		1	- 0	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
					560
						1	2	3	4	5	6	7	8	9	10	11	12
Capital Budget YR3
Item	Cost Ea.	Quantity
PRODUCTION
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1				- 0	0	0	0	0	0	0	0	0	0	0	0
ADMINISTRATIVE		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
			- 0		- 0	- 0	0	0	0	0	0	0	0	0	0	0	0
					560	- 0	0	0	0	0	0	0	0	0	0	0	0
Capital Budget YR4
Item	Cost Ea.	Quantity
			- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
			- 0		- 0
					560
Capital Budget YR5
Item	Cost Ea.	Quantity
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
		1	- 0	5	- 0
			- 0		- 0
					560

Product1

Arabian Delights Company	Sales/COGS Year1
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Per Serving
Unit Sales			900	933	966	1000	1180	1190	1300	1300	1286	1186	1066	1000	13,307
Inflation
Per Unit Information
Average Price	$ 8.50		7,650	7,931	8,211	8,500	10,030	10,115	11,050	11,050	10,931	10,081	9,061	8,500	113,110
Direct Product Costs
Variable Rate	35.00%
Variable Cost	$ 2.97		2,677	2,776	2,874	2,975	3,510	3,540	3,867	3,867	3,826	3,528	3,171	2,975	39,588
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0.005
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product B
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ 25.00		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	40.00%
Variable Cost	$ 10.00		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 3
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 4
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 5
Unit Sales			0	0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ 15.00		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0.5
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 6
Unit Sales			0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 7
Unit Sales			0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0.25
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Summary
	Unit Sales		900	933	966	1,000	1,180	1,190	1,300	1,300	1,286	1,186	1,066	1,000	13,307
	Sales		7,650	7,931	8,211	8,500	10,030	10,115	11,050	11,050	10,931	10,081	9,061	8,500	113,110
	Product Costs		2,677	2,776	2,874	2,975	3,510	3,540	3,867	3,867	3,826	3,528	3,171	2,975	39,588
	Labor Cost		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

Product2

Arabian Delights Company	Sales/COGS Year2
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Per Serving
Unit Sales			1000	1033	1066	1100	1180	1290	1400	1400	1286	1186	1066	1000	14,007
Inflation
Per Unit Information
Average Price	$ 8.50		8,500	8,781	9,061	9,350	10,030	10,965	11,900	11,900	10,931	10,081	9,061	8,500	119,060
Direct Product Costs
Variable Rate	35.00%
Variable Cost	$ 2.97		2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0.005
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product B
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ 27.00		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	40.00%
Variable Cost	$ 10.80		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 3
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 4
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 5
Unit Sales			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 6
Unit Sales			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 7
Unit Sales			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Summary
	Unit Sales		1,000	1,033	1,066	1,100	1,180	1,290	1,400	1,400	1,286	1,186	1,066	1,000	14,007
	Sales		8,500	8,781	9,061	9,350	10,030	10,965	11,900	11,900	10,931	10,081	9,061	8,500	119,060
	Product Costs		2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671
	Labor Cost		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

Product3

Arabian Delights Company	Sales/COGS Year3
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Per Serving
Unit Sales			1000	1033	1066	1100	1180	1290	1400	1400	1286	1186	1066	1000	14,007
Inflation	2%
Per Unit Information
Average Price	$ 8.50		8,500	8,781	9,061	9,350	10,030	10,965	11,900	11,900	10,931	10,081	9,061	8,500	119,060
Direct Product Costs
Variable Rate	35.00%
Variable Cost	$ 2.97		2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0.005
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product B
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ 30.00		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	40.00%
Variable Cost	$ 12.00		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 3
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 4
Unit Sales															- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	1
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 5
Unit Sales			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0.5
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 6
Unit Sales			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Product 7
Unit Sales			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inflation	0%
Per Unit Information
Average Price	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Direct Product Costs
Variable Rate	0.00%
Variable Cost	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Labor
Hourly Wage	$ - 0
PR Taxes/Ben	$ - 0	12.50%
	$ - 0
Time/Hrs	0
Cost/Unit	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Summary
	Unit Sales		1,000	1,033	1,066	1,100	1,180	1,290	1,400	1,400	1,286	1,186	1,066	1,000	14,007
	Sales		8,500	8,781	9,061	9,350	10,030	10,965	11,900	11,900	10,931	10,081	9,061	8,500	119,060
	Product Costs		2,975	3,073	3,171	3,272	3,510	3,838	4,165	4,165	3,826	3,528	3,171	2,975	41,671
	Labor Cost		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

Admin1

Administrative Costs - YR1
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Salaries
	#
Owner	1		1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	18,180
Assistant	1		1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	18,180
															- 0
Parttime															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
Employee Count	2	Total	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	3,030	36,360
Employee Taxes	12.50%		379	379	379	379	379	379	379	379	379	379	379	379	4,545
Benefits/Emp.	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Total	379	379	379	379	379	379	379	379	379	379	379	379	4,545
Total Labor Costs			3,409	3,409	3,409	3,409	3,409	3,409	3,409	3,409	3,409	3,409	3,409	3,409	40,905
Allocation:
Administrative	100%		1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	18,180
Benefits			189	189	189	189	189	189	189	189	189	189	189	189	2,273
Production			1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	1,515	18,180
Benefits			189	189	189	189	189	189	189	189	189	189	189	189	2,273
Advertising & Promotion
Yellow Pages															- 0
															- 0
Printing															- 0
															- 0
															- 0
Web Page															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
		Total	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Research & Development															- 0
Other SG&A
0															- 0
Legal			1000												1,000
Permits			1000												1,000
0															- 0

A custom name for this account will come from MasterBudget worksheet.

Admin2

Administrative Costs - YR2
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Salaries
	#
Owner	1		1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	19,200
Assistants	1		1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	19,200
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
	2	Total	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	3,200	38,400
Employee Taxes	12.50%		400	400	400	400	400	400	400	400	400	400	400	400	4,800
Benefits/Emp.	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Total	400	400	400	400	400	400	400	400	400	400	400	400	4,800
Total Labor Costs			3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	43,200
Allocation:
Administrative	100%		1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	19,200
Benefits			200	200	200	200	200	200	200	200	200	200	200	200	2,400
Production			1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	1,600	19,200
Benefits			200	200	200	200	200	200	200	200	200	200	200	200	2,400
Advertising & Promotion
Yellow Pages															- 0
0															- 0
Printing															- 0
0															- 0
0															- 0
Web Page															- 0
0															- 0
0															- 0
0															- 0
0															- 0
0															- 0
0															- 0
		Total	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Research & Development															- 0
Other SG&A
0															- 0
Legal															- 0
Permits															- 0
0															- 0

A custom name for this account will come from MasterBudget worksheet.

Admin3

Administrative Costs - YR3
		Month	1	2	3	4	5	6	7	8	9	10	11	12	Total
Salaries
	#
Owner	1		1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	21,120
Assistants	2		1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	21,120
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
															- 0
			- 0												- 0
	3	Total	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	3,520	42,240
Employee Taxes	12.50%		440	440	440	440	440	440	440	440	440	440	440	440	5,280
Benefits/Emp.	$ - 0		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Total	440	440	440	440	440	440	440	440	440	440	440	440	5,280
Total Labor Costs			3,960	3,960	3,960	3,960	3,960	3,960	3,960	3,960	3,960	3,960	3,960	3,960	47,520
Allocation:
Administrative	100%		1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	21,120
Benefits			220	220	220	220	220	220	220	220	220	220	220	220	2,640
Production			1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	1,760	21,120
Benefits			220	220	220	220	220	220	220	220	220	220	220	220	2,640
Advertising & Promotion
Yellow Pages															- 0
0															- 0
Printing															- 0
0															- 0
0															- 0
Web Page															- 0
0															- 0
0															- 0
0															- 0
0															- 0
0															- 0
0															- 0
		Total	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Research & Development															- 0
Other SG&A
0															- 0
Legal															- 0
Permits															- 0
0															- 0

A custom name for this account will come from MasterBudget worksheet.

Finc1

	Financing Plan - Year1
		1	2	3	4	5	6	7	8	9	10	11	12
Capital Injection		10,000
Borrowing1
Amount	$ 35,000
Rate	6.00%
Term/mos.	60	Payment	($676.65)
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	$ 35,000	34,498	33,994	33,488	32,978	32,467	31,952	31,435	30,916	30,394	29,869	29,342
	Principal		(502)	(504)	(507)	(509)	(512)	(514)	(517)	(519)	(522)	(525)	(527)
	Interest		(175)	(172)	(170)	(167)	(165)	(162)	(160)	(157)	(155)	(152)	(149)
	Cashflow		(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)
Borrowing2
Amount	$ - 0
Rate	12.00%
Term/mos.	120	Payment	$0.00
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	$ - 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Principal		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Interest		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Cashflow		- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Financing Summary
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Borrowings	$ 35,000
	Interest		(175)	(172)	(170)	(167)	(165)	(162)	(160)	(157)	(155)	(152)	(149)	(1,785)
	Payments		(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(7,443)

Finc2

	Financing Plan - Year2
		1	2	3	4	5	6	7	8	9	10	11	12
Capital Injection		- 0
Borrowing1
Amount	$ 35,000
Rate	6.00%
Term/mos.	60	Payment	($676.65)
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	28,812	28,279	27,744	27,206	26,666	26,122	25,576	25,027	24,476	23,922	23,365	22,805
	Principal	(530)	(533)	(535)	(538)	(541)	(543)	(546)	(549)	(552)	(554)	(557)	(560)
	Interest	(147)	(144)	(141)	(139)	(136)	(133)	(131)	(128)	(125)	(122)	(120)	(117)
	Cashflow	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)
Borrowing2
Amount	$ - 0
Rate	12.00%
Term/mos.	120	Payment	$0.00
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Principal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Interest	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Cashflow	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Financing Summary
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Interest	(147)	(144)	(141)	(139)	(136)	(133)	(131)	(128)	(125)	(122)	(120)	(117)	(1,583)
	Payments	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(8,120)

Finc345

	Financing Plan - Year3
		1	2	3	4	5	6	7	8	9	10	11	12
Capital Injection			$ - 0
Borrowing1
Amount	$ 35,000
Rate	6.00%
Term/mos.	60	Payment	($676.65)
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	22,242	21,677	21,108	20,537	19,963	19,387	18,807	18,224	17,639	17,050	16,459	15,864
	Principal	(563)	(565)	(568)	(571)	(574)	(577)	(580)	(583)	(586)	(588)	(591)	(594)
	Interest	(114)	(111)	(108)	(106)	(103)	(100)	(97)	(94)	(91)	(88)	(85)	(82)
	Cashflow	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)
Borrowing2
Amount	$ - 0
Rate	12.00%
Term/mos.	120	Payment	$0.00
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Principal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Interest	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Cashflow	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Financing Summary
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Interest	(114)	(111)	(108)	(106)	(103)	(100)	(97)	(94)	(91)	(88)	(85)	(82)	(1,179)
	Payments	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(8,120)
	Financing Plan - Year4
Owner's Capital			$ - 0
Borrowing1
Amount	$ 35,000
Rate	6.00%
Term/mos.	$ 60	Payment	($676.65)
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	15,267	14,667	14,063	13,457	12,848	12,235	11,620	11,001	10,380	9,755	9,127	8,496
	Principal	(597)	(600)	(603)	(606)	(609)	(612)	(615)	(619)	(622)	(625)	(628)	(631)
	Interest	(79)	(76)	(73)	(70)	(67)	(64)	(61)	(58)	(55)	(52)	(49)	(46)
	Cashflow	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)
Borrowing2
Amount	$ - 0
Rate	12.00%
Term/mos.	$ 120	Payment	$0.00
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Principal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Interest	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Cashflow	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Financing Summary
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Interest	(79)	(76)	(73)	(70)	(67)	(64)	(61)	(58)	(55)	(52)	(49)	(46)	(751)
	Payments	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(8,120)
	Financing Plan - Year5
Owner's Capital			$ - 0
Borrowing1
Amount	$ 35,000
Rate	6.00%
Term/mos.	$ 60	Payment	($676.65)
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	7,862	7,225	6,584	5,940	5,293	4,643	3,990	3,333	2,673	2,010	1,343	673
	Principal	(634)	(637)	(641)	(644)	(647)	(650)	(653)	(657)	(660)	(663)	(667)	(670)
	Interest	(42)	(39)	(36)	(33)	(30)	(26)	(23)	(20)	(17)	(13)	(10)	(7)
	Cashflow	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)
Borrowing2
Amount	$ - 0
Rate	12.00%
Term/mos.	$ 120	Payment	$0.00
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Principal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Interest	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Cashflow	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Financing Summary
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Interest	(42)	(39)	(36)	(33)	(30)	(26)	(23)	(20)	(17)	(13)	(10)	(7)	(297)
	Payments	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(8,120)
	Financing Plan - Year6
Owner's Capital			$ - 0
Borrowing1
Amount	$ 35,000
Rate	6.00%
Term/mos.	$ 60	Payment	($676.65)
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	0	(677)	(1,357)	(2,040)	(2,727)	(3,417)	(4,111)	(4,808)	(5,509)	(6,213)	(6,921)	(7,632)
	Principal	(673)	(677)	(680)	(683)	(687)	(690)	(694)	(697)	(701)	(704)	(708)	(711)
	Interest	(3)	(0)	3	7	10	14	17	21	24	28	31	35
	Cashflow	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)
Borrowing2
Amount	$ - 0
Rate	12.00%
Term/mos.	$ 120	Payment	$0.00
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Balance	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Principal	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Interest	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Cashflow	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Financing Summary
	Month	1	2	3	4	5	6	7	8	9	10	11	12
	Interest	(3)	(0)	3	7	10	14	17	21	24	28	31	35	186
	Payments	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(677)	(8,120)
Debt Summary		1	2	3	4	5	6
		29,342	22,805	15,864	8,496	673	(7,632)
			6,537	6,940	7,368	7,823	8,305	(7,632)

Ghantt

Arabian Delights Company
Timeline of Significant Activities*		Months from point of initial funding
Activity	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18
PHASE I - Business Plan
Startup Activities
Key Personnel Hires - Initial Management Team
Product Design and Prototyping -WSU Contract
Prototype Modeling and Testing
Development of Market Activities
Phase II Business Plan
Search for Phase II Funding
Product commercialization activities
*Timelinge starts at point of initial funding