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 8.00%. Project A Year 0 1 2 3 4 5 (7,000) 2,520 2,450 2,240 1,400 1,400 Project B (6,500) 2,600 3,250 2,210 325 390 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 (%) Sorry, try again Sorry, try again Sorry, try again 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 6.00%. What is the modified IRR of each Project? MIRR of Project A (%) MIRR of Project B (%) Instructions and Answers 5. Fanations 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 8.00%. Project A Year 0 1 2 3 4 5 (7,000) 2,520 2,450 2,240 1,400 1,400 Project B (6,500) 2,600 3,250 2,210 325 390 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 (%) Sorry, try again Sorry, try again Sorry, try again 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 6.00%. What is the modified IRR of each Project? MIRR of Project A (%) MIRR of Project B (%) Instructions and Answers 5. Fanations