Do a Feasibility Study and Industry Analysis for your business idea?
Omar93
BUS203-ProformaIncomestatement.xlsxSheet1
| Year 1 (monthly breakdown) | 5-year span | ||||||||||||||||||||||
| Revenue | January | February | March | April | May | June | July | August | September | October | November | December | Revenue | Y1 | Y2 | Y3 | Y4 | Y5 | TaxRate | ||||
| Gross sales | $ 41,200.00 | $ 41,290.00 | $ 41,360.00 | $ 41,440.00 | $ 41,530.00 | $ 41,610.00 | $ 41,700.00 | $ 41,780.00 | $ 41,860.00 | $ 42,000.00 | $ 42,030.00 | $ 42,200.00 | Gross sales | $ 500,000.00 | $ 600,000.00 | $ 720,000.00 | $ 864,000.00 | $ 1,036,800.00 | 10% | ||||
| less cost of goods sold | $ 28,800.00 | $ 28,860.00 | $ 29,000.00 | $ 29,070.00 | $ 29,090.00 | $ 29,100.00 | $ 29,200.00 | $ 29,250.00 | $ 29,340.00 | $ 29,390.00 | $ 29,400.00 | $ 29,500.00 | less cost of goods sold | $ 350,000.00 | $ 420,000.00 | $ 504,000.00 | $ 604,800.00 | $ 725,760.00 | |||||
| Gros profit | $ 12,400.00 | $ 12,430.00 | $ 12,360.00 | $ 12,370.00 | $ 12,440.00 | $ 12,510.00 | $ 12,500.00 | $ 12,530.00 | $ 12,520.00 | $ 12,610.00 | $ 12,630.00 | $ 12,700.00 | Gros profit | $ 150,000.00 | $ 180,000.00 | $ 216,000.00 | $ 259,200.00 | $ 311,040.00 | |||||
| Operating expenses | Operating expenses | ||||||||||||||||||||||
| Rent | $ 1,000.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | Rent | $ 3,200.00 | $ 3,200.00 | $ 3,200.00 | $ 3,200.00 | $ 3,200.00 | |||||
| Utilities | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | Utilities | $ 600.00 | $ 720.00 | $ 864.00 | $ 1,036.80 | $ 1,244.16 | |||||
| Postage | $ 12.50 | $ 12.53 | $ 12.55 | $ 12.58 | $ 12.00 | $ 12.63 | $ 12.65 | $ 12.00 | $ 12.70 | $ 12.73 | $ 12.75 | $ 12.40 | Postage | $ 150.00 | $ 180.00 | $ 216.00 | $ 259.20 | $ 311.04 | |||||
| Insurance | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | $ 80.00 | Insurance | $ 960.00 | $ 960.00 | $ 960.00 | $ 960.00 | $ 960.00 | |||||
| Advertising | $ 550.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | Advertising | $ 1,100.00 | $ 880.00 | $ 704.00 | $ 563.20 | $ 450.56 | |||||
| Wages | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | $ 250.00 | Wages | $ 3,000.00 | $ 3,600.00 | $ 4,320.00 | $ 5,184.00 | $ 6,220.80 | |||||
| Total expenses | $ 1,942.50 | $ 642.53 | $ 642.55 | $ 642.58 | $ 642.00 | $ 642.63 | $ 642.65 | $ 642.00 | $ 642.70 | $ 642.73 | $ 642.75 | $ 642.40 | Total expenses | $ 9,010.00 | $ 9,540.00 | $ 10,264.00 | $ 11,203.20 | $ 12,386.56 | |||||
| Net income before tax | $ 10,457.50 | $ 11,787.48 | $ 11,717.45 | $ 11,727.42 | $ 11,798.00 | $ 11,867.37 | $ 11,857.35 | $ 11,888.00 | $ 11,877.30 | $ 11,967.27 | $ 11,987.25 | $ 12,057.60 | Net income before tax | $ 140,990.00 | $ 170,460.00 | $ 205,736.00 | $ 247,996.80 | $ 298,653.44 | |||||
| less tax | $ 1,045.75 | $ 1,178.75 | $ 1,171.74 | $ 1,172.74 | $ 1,179.80 | $ 1,186.74 | $ 1,185.73 | $ 1,188.80 | $ 1,187.73 | $ 1,196.73 | $ 1,198.72 | $ 1,205.76 | less tax | $ 14,099.00 | $ 17,046.00 | $ 20,573.60 | $ 24,799.68 | $ 29,865.34 | |||||
| Net income after tax | $ 9,411.75 | $ 10,608.73 | $ 10,545.70 | $ 10,554.68 | $ 10,618.20 | $ 10,680.64 | $ 10,671.61 | $ 10,699.20 | $ 10,689.57 | $ 10,770.55 | $ 10,788.52 | $ 10,851.84 | Net income after tax | $ 126,891.00 | $ 153,414.00 | $ 185,162.40 | $ 223,197.12 | $ 268,788.10 | |||||
| T-Accounts at end of year 1 | |||||||||||||||||||||||
| Revenue | Inventory | Rent | Utilities | ||||||||||||||||||||
| Dr | CR | Dr | CR | Dr | CR | Dr | CR | ||||||||||||||||
| $ 500,000.00 | $ 350,000.00 | $ 3,200.00 | $ 600.00 | ||||||||||||||||||||
| $ 500,000.00 | $ 350,000.00 | $ 3,200.00 | $ 600.00 | ||||||||||||||||||||
| Postage | Insurance | Advertising | wages | ||||||||||||||||||||
| Dr | CR | Dr | CR | Dr | CR | Dr | CR | ||||||||||||||||
| $ 150.00 | $ 960.00 | $ 1,100.00 | $ 3,000.00 | ||||||||||||||||||||
| $ 150.00 | $ 960.00 | $ 1,100.00 | $ 3,000.00 | ||||||||||||||||||||
