Develop a proforma Income Statement for your Clothing line?
Omar93
BUS203-ECCPizzaIncomeStatementExample.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) |
