| 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 | 204 | 252 | 300 | 348 | 396 |
| | Avg Sales per Locations | 549 | 573.705 | 599.521725 | 626.500202625 | 654.6927117431 | 684.1538837716 |
| | Revenue | 85644 | 117035.82 | 151079.47 | 187950.06 | 227833.06 | 270924.94 | 954823.36 |
| | Costs of Goods Sold | 41115 | 56177.19 | 72518.15 | 90216.03 | 109359.87 | 130043.97 | 458315.21 |
| | Gross Margin | 44529 | 60858.63 | 78561.33 | 97734.03 | 118473.19 | 140880.97 | 496508.15 |
| | Fixed Cost - Location | 33540 | 43860 | 54180 | 64500 | 74820 | 85140 | 322500.00 |
| | Fixed Cost - Corporate | 24450 | 24450 | 24450 | 24450 | 24450 | 24450 | 122250.00 |
| | Total Fixed Costs | 57990 | 68310 | 78630 | 88950 | 99270 | 109590 | 444750.00 |
| | Profit | -13461 | -7451.37 | -68.67 | 8784.03 | 19203.19 | 31290.97 | 51758.15 |
azo_xe99m
book1_2_1.xlsx
