Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance Investment And Advisory Applications

Authors: Jesse McDougall, Patrick Boyle

1st Edition

1530116597, 9781530116591

More Books

Students also viewed these Finance questions