Applying instructions in Excel sheet
azo_xe99mbook1.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 |