i have posted the pictures above and i belive most of the math in the charts i have done is correct but i am struggling to complete questions 9-12

Shaw WE Dette 28-0. Sort Select Yes 1 AutoSave ORE BESS: Project2_FIN4424 Template (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Times New Roman 11 K A Custom Conditioning Pasta B $% % Formatasabi *823 Cell Style Open recovered workbooks? Your recent charges were saved. Do you want to continue woning where you to 363 A E 1 0 Year 1 2 Units Sales Year 2 Yes Yeard Yeats 50.000 65000 90.000 120.000 130.000 4 Equipment Cost 25.000.000 5 Salvage value 1.500.000 6 7 Uits Price 320 8 Variable cost per un 130 9 Fixed costs per year) 2.500.000 10 11 Taste 21.00 12 NWC box) 17.00% 13 Required retum 15.0ON 14 Required Payback Pernod years) 15 16 MACRS Schedule Year 1 Year 2 Year) Year 4 Years Year 173-year 33.33% 4425 14814 7415 20.00% 32.00% 19.2046 11.52N 11.524 576 19 7 year 14.29% 24.4996 17.4944 1249 8999 8929 20 21 22 23 Pro Formal Statement 24 Year Year! Yext 2 Year 3 Your Year 25 Reven 16,000,000 20.800.000 200,000 38,400,000 41.000.000 26 Variable costa 7.500.000 9,750,000 13.500.000 16.000.000 19.500.000 27 Fixed costs 2.360,000 2.500,000 1,500,000 2.500.000 2.500.000 28 Depreciation 5000 . 300.000 2.880,000 DOO 29 ERIT 1.000.000 550.000 2,000,000 15.020,000 16.720,000 10 Taxes 155) 210,000 500 1000 209.200 3511 31 Net income 700.000 41400 2002 Cover Task 1-Stock value Task 2 - WACC Task 3.Capital Budgeting + Yen Yest 8.93% TIN Home Insert Draw Page Layout Project FIN4424 Template View Tell me Formulas Data Review Times New Roman A A Share Co Custom . Paste GA- 2 let De EM 27.0. D $ - % ) Sort Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you loom? Find Seed Yes 1 G 5.000.000 1000,000 10.000 790.000 5.790,000 D 8.000000 550.000 115.500 35500 5.434,500 E EXO DO xo. 16 120.000 11.119.000 000 15.000.000 3.154200 DO 14.745.89 F 16,720,000 3:51 13.2010 TO 100 Year Year! Year? 2.720.000 2516000 116.0001 2.720.000 (3.720,000) Year3 3.536.000 X0600 (1.360.000) Your 495.000 6.52 000 (1.632.000 Yes 6.528.000 200 1,500,000 A 28 Depreciation 29 EBIT a Taxes (214) 31 Net income 32 OCT 33 34 35 Net Working Capital 36 Year 37 Initial NWC 38 Ending NWC 39 NWC cash flow 40 41 Selvage Valur 42 Market value of salvaje 43 Book Value of salvage 44 Taxes on sale (215) 45 Aftertax savage value 46 47 Project Cash Flows 48 Year 49 OCF 50 Change in NC 51 Capital gending 52 Total cash ifow 53 Cumulative cash flow 54 PV of the Cash Flows 55 Cumulative cash flow considering SG 57 58 Chestion Cover Task 1-Stock Year Year 5.290.000 0.720,000) Year 3,414.500 03.316.000) 11.120.000 49,000) Yeard 14.145,00 52000) 3.217,600 5.000.000) 3.070,000 5.000.000 1.930,000) 5000,000) 2.869.365 05.000.000) (22.330,435) 4,598 500 17031500) 3,703,970 1.26.465) 1.000 (1007 4.092331 (14.314,014) 16 17.072.000) 14400 1467400 10.564.200 Rowed for NPV, RR. Pty des 792.00 Row sad for Regular aquestion 5271444 4613,061 Row used for discounted pack questi 4.98554 15,530) Task 2 - WACO Task 3-Capital Budgeting SIE Ready DOP Com Conforating watt OM 0.4 Styles Sort Find Select F Year 4 14,745 800 16,32,000) Home insert Draw Page Layout Formulas Data Review View Tell me Times New Roman 11 A A Percentage R OA $ % Open recovered workbooks? Your recent changes were saved Do you want to continue working where you left off? 371 A 0 E 4 Year Yeuro Year Year 49 OCE 5,790,000 8,434300 11,120.000 50 Change in NWC (3,720,0001 03.336,000) (4896.000) 51 Capital spending 25000/000 52 Total cash flow (25,000,000 3,070,000 49.500 6,224,000 53 Cumulative cash flow S000.000 XP 90.000 (17.01 (10.8075001 54 PV of the Cash Flows 125,000,000 2.669,565 3,703.970 4,092.381 55 Cumulative cash flow considering PV 05,000,000) (22.330.455) (15.626,465 (14314084) 56 57 58 Cuestions 59 Payback Period 60 Decision 51 62 Question 63 Discounted Payback Period 54 Decision 65 66 56 Question to 67 NPV 68 Decision G Years 16.01.10 m2.000) 1457400 1457400 10.5000 Row used for NIP, Profitability Index 3. Rowed for Regular payback qilis $32244 530) Row used for dette ayhack question 3.217.00 3.59.00) 4.698,554 19.235 530) 70 Option 11 71 ERR 72 Decision 73 74 en 12 75 Profitability Index 76 Decision? 22 TR Cwesti 13 Cover + Task 1-Stock value Tusk 3.capital Budgeting Task 2 - WACC Ready