Applying 3 instructions fiels in one Excel sheet

book1.xlsx

Sheet1

Java Beans Coffee Shop
Sales, Revenu, and Income Projections
All Dollar amounts are in Thousands
Parameters
	Location Growth Rate	48
	Same Store Annual Sales Growth	0.045
	COGS as percent of Revenue	0.48
	Fixed Cost per Location	215
Profit Model Calculations
			Projected
		Current Year	Year 1	Year 2	Year 3	Year 4	Year 5
	Locations	156
	Avg Sales per Locations
	Revenue	85644
	Costs of Goods Sold	41115
	Gross Margin
	Fixed Cost - Location	33540
	Fixed Cost - Corporate	24450
	Total Fixed Costs
	Profit