| Income Statement |
| Cassandra's Pantry |
| | YEAR 1 | | YEAR 2 | | YEAR 3 | | YEAR 4 | | YEAR 5 |
| # of Company Concession Trucks | 1 | | 1 | | 1 | | 2 | | 2 |
| Product Revenue | $ 185,500 | | $ 200,000 | | $ 222,000 | | $ 341,000 | | $ 350,000 |
| Service Revenue | $ 37,100 | | $ 40,000 | | $ 44,400 | | $ 68,200 | | $ 70,000 |
| TOTAL REVENUE | $ 222,600 | | $ 240,000 | | $ 266,400 | | $ 409,200 | | $ 420,000 |
| COST OF GOODS SOLD | $ 75,250 | | $ 85,000 | | $ 98,000 | | $ 180,000 | | $ 200,000 |
| GROSS PROFIT | $ 147,350 | | $ 155,000 | | $ 168,400 | | $ 229,200 | | $ 220,000 |
| OPERATING EXPENSES |
| Vehicle Cost | $ 24,000 | | $ - 0 | | $ - 0 | | $ 28,000 | | $ - 0 |
| Appliances | $ 4,123 | | $ 1,500 | | $ 1,000 | | $ 8,000 | | $ 500 |
| Insurance | $ 3,000 | | $ 3,000 | | $ 3,000 | | $ 6,000 | | $ 6,000 |
| Repairs/Maintenance | $ 10,000 | | $ 4,000 | | $ 4,000 | | $ 6,000 | | $ 5,000 |
| Marketing costs | $ 900 | | $ 5,000 | | $ 1,000 | | $ 5,500 | | $ 1,000 |
| Salaries | $ 104,900 | | $ 110,000 | | $ 110,000 | | $ 130,500 | | $ 145,000 |
| Gas | $ 3,600 | | $ 3,600 | | $ 3,800 | | $ 6,000 | | $ 6,000 |
| Internet | $ 360 | | $ 360 | | $ 360 | | $ 500 | | $ 500 |
| Cell | $ 600 | | $ 600 | | $ 600 | | $ 600 | | $ 600 |
| Licenses/other | $ 2,000 | | $ 2,000 | | $ 2,000 | | $ 4,000 | | $ 4,000 |
| Depreciation | $ 1,000 | | $ 1,000 | | $ 1,000 | | $ 2,000 | | $ 2,000 |
| TOTAL OPERATING EXPENSES | $ 154,483 | | $ 131,060 | | $ 126,760 | | $ 197,100 | | $ 170,600 |
| % of Revenues | 69% | | 54.61% | | 47.58% | | 48% | | 41% |
| OPERATING INCOME | $ (7,133) | | $ 23,940 | | $ 41,640 | | $ 32,100 | | $ 49,400 |
| | -3.85% | | 12% | | 18.76% | | 9.41% | | 14.11% |
| Interest Expense | $ 4,000 | | $ 4,000 | | $ 4,000 | | $ 4,000 | | $ 4,000 |
| Profits Before Taxes | $ (11,133) | | $ 19,940 | | $ 37,640 | | $ 28,100 | | $ 45,400 |
| Income Tax | 0 | | $ - 0 | | $ - 0 | | $ - 0 | | $ - 0 |
| Net Profits | $ (11,133) | | $ 19,940 | | $ 37,640 | | $ 28,100 | | $ 45,400 |
| % of Revenues | -5% | | 8% | | 14% | | 6.87% | | 10.81% |
| Balance Sheets |
| Cassandra's Pantry |
| | YEAR 1 | | YEAR 2 | | YEAR 3 | | YEAR 4 | | YEAR 5 |
| ASSETS |
| CURRENT ASSETS |
| Cash |
| Accounts Receivable |
| Inventories |
| Other Current Assets |
| Total Current Assets |
| PROPERTY/EQUIPMENT |
| Depreciation |
| TOTAL ASSETS |
| LIABILITIES & EQUITY |
| Accounts payable |
| Other |
| Long-term liabilities |
| TOTAL LIABILITIES |
| Ownership Equity |
| Retained earnings |
| TOTAL EQUITY |
| TOTAL LIABILITY + EQUITY |
| Cash Flow Statement |
| Cassandra's Pantry |
| | YEAR 1 | | YEAR 2 | | YEAR 3 | | YEAR 4 | | YEAR 5 |
| OPERATING ACTIVITIES |
| NET Earnings |
| Depreciation |
| AR |
| Inventory |
| Other Current assets |
| Accounts Payable |
| Other Current Liabilities |
| Net Cash Provided/ |
| Used by Operating activities |
| INVESTING ACTIVITIES |
| PROP/EQUIP |
| NET CASH USED IN |
| INVESTING ACTIVITIES |
| FINANCING ACTIVITIES |
| Short Term Debt |
| Current LTD |
| Equity |
| NET CASH PROVIDED/ |
| USED BY FINANCING |
| INCREASE/DECREASE IN |
| CASH |
| CASH AT BEGINNING OF YR |
| CASH AT END OF YR |
casand1
help_please.xlsx
