a. Calculate NPV, IRR, MIRR for the project, given the discount rate of 10%, and the reinvestment rate of 7% b. Sensitivity analysis: Calculate MIRR for Discount rate range (8%, 10%--20%) and Reinvestment rate range (3% SK.. 11%) c. Use conditional formatting to highlight the MIRR that is greater than required rate of return 8 Discount rate 9 Reinvestment rate: 10 12 Year Cash flow 13 0 (82,000.00) 14 1S 45,000.00 5 266,000.00 16 3S 12,000.00 17 4 (19,000.00) 18 19 21 23 25 26 28 31 32 35 MIRR