The attached Excel template already solved Part 1. You need to duplicate the solution to Part 1 and conduct the sensitivity analysis of NPV and IRR to changes in the product price.

Part 1 (Base case, P-$535) Part 2 Best Case P-540) $ Equipment Pretaxulvage value $ $ 43.300.000 500.000 13,500,000 6500,000 720,000 200.000 3 Equipment Pretaulvage value Marketing study Marketing study 3 200,000 16.00 125,000 95,000 75,000 165,000 To 125,000 95,000 Salud Sanofold POA |Lotukarur Depreciation rate 155,000 95.000 30,000 30,000 95.000 30,000 14.25% 17. 12. V 2 17. SORT V6 540 $ $ 3 3 5 Price lyc IFC Price of old PDA Price reduction of PMA VC of old PDA 14 640.000 Sales (unit) sales ad PDA (unit) Lotul (unit Depreciation rate Price lyc IFC Price od PO Price reduction of old PDA Cold PDA Tarate Wat wel Required retum 6400,00 $ $ SIZ 215 $ 215 20 123 215 20 VWC (of Required retum 50,000 $ 10,125.000 San New Lot Los revenue Niet 2.925,000 $ -115 -11 GTS,000 $ -115 -5.950.000 70,775,000 $ GATS,000 $ Sol New Lot Lover Notes $ GONZ5,000 $ SOS,000 $ 40125.00 VC WC $ 20,900.000$ 16300,000 |Lat: u) Total VC 2,100,000 $ 4350,000 29,750,000 $ 3600,000 $27,300,000 $ LEO 31,950,000 $ 27,300,000 $ $ 20.300.000 $ 16,500.00 Total VC $ $ JVC Foad.co Dep COT Tax IN Dep Oo 29, 730.000 6400,000 6,216,150 17960$ 3771159 1487432$ G216150 20,403,62 $ 70,775,000 $ GAS,000 $ SOS.000 $ 40.125.000 31,350,000 27300,000 20000000 16.500,000 G400.000 G400.000 6400,000 200 10,653 150 5411 21,771,0 $ 20 $ 1.001,0 $ 13.00 77089 2001 17,199,762 $ 20,092 $ 105 10,653 150 7150 5,433,130 27252,912 STATUS 19,725,712 $ 14,423,50G VC Fedconte Dep COT N Dep 00 $ NWC $ 101650W 12,065,000 $ 14,155,000 $ 14,155,000 13.000 -2,090,000 70.000 WWC Det End WWCO 13,375,000 $ 10165,000 3210 12.065.00 -12.065,000 NWCO 10.10 Net $ $ 25,762,912 5 2 427,62S 22,985,712 5 250G Neto Sala ovo equipment $ Sava | V of equipment $ 9,70USD 673,00 Salvere 5 7172019 Salvage Time Cashow -23300,000 The Cho 0 1 25,762,912 22,985,712 MLER 27.515 NPV 37,316, ILL.CZ NPV