Proforma Income Statement and Cash Flow For a Clothing Line
Omar93
BUS203-ECCPizzaCashFlowStatementExample.xlsx
Sheet1
| ECC Pizza |
| | Cash in Bank | | | Revenue (Large Pie) | | | COGS (Large Pie) | | | Revenue (Medium Pie) | | | COGS (Medium Pie) | | | Loan from Prof Shube | | | Driver Expenses |
| | 75.00 | 1,000.00 | | | 75.00 | | 40.00 | | | | 240.00 | | 140.00 | | | | 50,000.00 | | 150.00 |
| | 50,000.00 | 800.00 | | | 1,500.00 | | 800.00 | | | | | | | | | | 25,000.00 |
| | 1,500.00 | 3,000.00 | | | 7,500.00 | | 4,000.00 |
| | 240.00 | 3,000.00 |
| | 7,500.00 | 4,000.00 |
| | 25,000.00 | 300.00 |
| | | 150.00 |
| | | 150.00 |
| | 71,915.00 | | | | 9,075.00 | | 4,840.00 | | | | 240.00 | | 140.00 | | | | 75,000.00 | | 150.00 |
| | Inventory | | | Purchasing | | | Rent | | | Payroll | | | Utilities | | | Marketing | | | Accounts Payable |
| | 1,000.00 | 40.00 | | 1,000.00 | 1,000.00 | | 800.00 | | | 3,000.00 | | | 300.00 | | | 150.00 | | | 4,000.00 | 4,000.00 |
| | 3,000.00 | 800.00 | | 3,000.00 | 3,000.00 |
| | 4,000.00 | 140.00 | | 4,000.00 | 4,000.00 |
| | | 4,000.00 |
| | 3,020.00 | | | - 0 | | | 800.00 | | | 3,000.00 | | | 300.00 | | | 150.00 | | | | - 0 |
| Income Statement | | | | | | | | | | | | | | | | | | | 1.20 |
| | | | | | January | | February | | | | | | | | | Year 1 Total | | | Year 2 Totaal |
| | Revenue |
| | | Large Pie | | | 9,075.00 | | 10,000.00 | | | | | | | | | 19,075.00 | | | 22,890.00 |
| | | Medium Pie | | | 240.00 | | 400.00 | | | | | | | | | 640.00 | | | 768.00 |
| | Total Revenue | | | | | 9,315.00 | | 10,400.00 | | | | | | | | | 19,715.00 | | | 23,658.00 |
| | Cost of Goods Sold |
| | | Large Pie | | | 4,840.00 | | 6,000.00 | | | | | | | | | 10,840.00 |
| | | Medium Pie | | | 140.00 | | 300.00 | | | | | | | | | 440.00 |
| | Total COGS | | | | | 4,980.00 | | 6,300.00 | | | | | | | | | 11,280.00 |
| | Gross Profit | | | | | 4,335.00 | | 4,100.00 | | | | | | | | | 8,435.00 |
| | Other Expenses |
| | | Rent | | | 800.00 | | 800.00 | | | | | | | | | 1,600.00 |
| | | Payroll | | | 3,000.00 | | 3,000.00 | | | | | | | | | 6,000.00 |
| | | Utilities | | | 300.00 | | 300.00 | | | | | | | | | 600.00 |
| | | Marketing | | | 150.00 | | - 0 | | | | | | | | | 150.00 |
| | | Driver Exp | | | 150.00 | | 150.00 | | | | | | | | | 300.00 |
| | | | | | | | | | | | | | | | | - 0 |
| | Total Other Expenses | | | | | 4,400.00 | | 4,250.00 | | | | | | | | | 8,650.00 |
| | Net Profit (loss) | | | | | (65.00) | | (150.00) | | | | | | | | | (215.00) |
Cash Flows
| Activity | Start-up | January | February | March | April | May | June | July | August | September | October | November | December |
| Beginning Balance | - 0 | 77,825 | 74,625 | 71,325 | 68,275 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 |
| Cash In |
| Owner Investment | 25 |
| Outside Investment | 100,000 |
| Revenue | - 0 | 7,500 | 7,950 | 8,250 | 9,300 |
| Total Cash in + BB | 100,025 | 85,325 | 82,575 | 79,575 | 77,575 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 |
| Cash Out |
| Oven | 2,000 |
| Boxes | 500 | 500 | 550 | 600 | 800 |
| Utensils | 500 |
| Inventory | 1,500 | 4,000 | 4,500 | 4,500 | 4,800 |
| Fridge | 2,000 |
| Rent | 3,000 | 1,500 | 1,500 | 1,500 | 1,500 |
| Leasehold Improvements | 5,000 |
| Furniture | 2,000 |
| Cash reg | 500 |
| Computer | 500 |
| Payroll | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 |
| Utilities | 500 | 500 | 500 | 500 | 500 |
| Marketing | 200 | 200 | 200 | 200 | 200 |
| Total Cash Out | 22,200 | 10,700 | 11,250 | 11,300 | 11,800 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Ending Balance | 77,825 | 74,625 | 71,325 | 68,275 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 | 65,775 |
