Make a balance sheet from this income statement:
File Edit View Insert Format Tools Data Window Help 74% 150 Sun 5:12 PM Q OF O.. AutoSave . OFF econ project Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 12 A A = E = ap Wrap Text v General Insert v 2 NAY- O. Delete v Paste OvAv Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Ideas Format DV Sensitivity Formatting as Table Styles Filter Select 196 + X V fx B C D E F G H J K 74 75 Year 5 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Overall 76 Revenue 77 Vespa Hybrid 50 HP: 3,039$ 6,078,000.00 $ 9,117,000.00 $ 8,281,275.00 $ 6,078,000.00 29,554,275 78 Vespa Deluxe Hybrid 125 HP: 4,644$ 8,127,000.00 $ 11,610,000 $ 11,610,000 $ 8,127,000 $ 39,474,000 79 Scooter Premium Hybrid 125 HP: 6,520$ 8,476,000.00 $ 9,780,000 $ 9,780,000 $ 8,476,000.00 $ 36,512,000 80 Cost Of Goods Sold 9,072,400 $ 12,202,800 $ 11,868,510 $ 9,072,400 $ 42,216,110 81 Total Revenue: 13,608,600 $ 18,304,200 $ 17,802,765 $ 13,608,600 $ 63,324,165 Operating Expenses: 83 Legal Services 250,000 $ 250,000 $ 250,000 $ 250,000 $ 1,000,000 Advertising 250,000 $ 250,000 $ 250,000 $ 250,000 $ 1,000,000 85 Website marketing 20,000 $ 20,000 $ 20,000 $ 20,000 $ 80,000 86 Payroll 150,000 $ 150,000 $ 150,000 $ 150,000 $ 600,000 87 Electricity 35,000 35,000 35,000 $ 35,000 $ 140,000 88 Insurance 30,000 $ 30,000 $ 80,000 $ 30,000 $ 120,000 89 Rent Expenses 75,000 $ 75,000 $ 75,000 $ 300,000 90 Building and Equipment 200,000 200,000 200,000 $ 200,000 $ 800,000 91 Market Research 5,000 5,000 $ 5,000 $ 5,000 $ 20,000 Search engine listings and optimization 250,000 250,000 250,000 $ 250,000 $ 1,000,000 93 Design of marketing materials 10,000 $ 10,000 $ 10,000 $ 10,000 $ 40,000 94 Product design 150,000 $ 150,000 $ 150,000 $ 150,000 $ 600,000 95 Product Launch expenses 350,000 $ 350,000.00 $ 700,000 96 Product prototype and testing 350,000 $ 350,000.00 $ 700,000 97 CEO 50,000 $ 50,000 $ 50,000 $ 50,000 $ 200,000 98 CFO 40,000 40,000 $ 40,000 $ 40,000 $ 160,000 99 Finance Manager 30,000 $ 30,000 $ 10,000 30,000 $ 120,000 100 Engineering Manager 35,000 35,000 35,000 $ 35,000 $ 140,000 101 Office Manager(Lead Manager) 20,000 20,000 $ 20,000 $ 20,000 30,000 102 Employees 1,500,000 1,500,000 1,500,000 $ 1,500,000 6,000,000 103 Wages & Salaries 1,675,000 $ 1,675,000 $ 1,675,000 $ 1,675,000 $ 6,700,000 104 TotalExpenses: 3,800,000 $ 3,100,000 3,100,000 $ 3,800,000 $ 13,800,000 105 EBITDA 9,808,600 $ 15,204,200 $ 14,702,765 $ 9,808,600 $ 49,524,165 106 Income tax (14%) 1,373,204 2,128,588 $ 2,058,387 $ 1,373,204 6,933,383 107 Net Profit/Loss 11,181,804 $ 17,332,788 $ 16,761,152 $ 11,181,804 $ 56,457,548 108 Start-up budget Income Statement Year 1,2,3 Cash Flow Year 1,2,3 Ratios + Ready " - + 100% MAR W X
