Question 3 Note: No template is provided for this question. Set up your own calculations on the Q3 worksheet to answer each part of the question. Make sure your work is clean and clear (e.g., use input cells for parameters of interest, clearly label any tables or calculations, etc.). Points may be taken off for work that is messy, unclear, or unlabeled. IMPORTANT: Use cell references to your Q3 worksheet in order to fill in your final answers below. Your manager has asked you to evaluate two projects (cash flows shown below). Assume the appropriate discount rate is 12.00%. Year Project A 0 1 Project B (3,500) 1,260 1,225 1,120 700 (3,000) 1,200 1,500 1,020 150 2 3 4 5 180 700 a) What is the net present value and internal rate of return for each project? NPV of Project A ($) NPV of Project B ($) IRR of Project A (%) IRR of Project B (%) b) Which project is preferred based on NPV? Which project is preferred based on IRR? Best project based on NPV? (no answer check provided) Best project based on IRR? (no answer check provided) c) Calculate the NPV of each project across various discount rates from 0% to 20%. What is the crossover rate? Crossover rate (%) d) Suppose that future cash flows can be reinvested at 9.00%. What is the modified IRR of each Project? MIRR of Project A (%) c) Calculate the NPV of each project across various discount rates from 0% to 20%. What is the crossover rate? Crossover rate (%) d) Suppose that future cash flows can be reinvested at 9.00%. What is the modified IRR of each Project? MIRR of Project A (%) MIRR of Project B (%)