Solve:

1. Profit Margin

2. Return on Equity

3. Return on investment

4. Debt to equity ratio

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