Question
Please show all work on excel You just got hired by McKinsey & Company as a financial consultant and theyre paying you an egregious amount
Please show all work on excel
You just got hired by McKinsey & Company as a financial consultant and theyre paying you an egregious amount of money. Accordingly, they have you working on the tough projects like this one
Consider the following two mutually exclusive projects available to the firm. Free cash flows for Projects A and B are provided below. Assume the two projects have essentially the same level of riskiness, and your prior analysis indicates that the appropriate risk-adjusted hurdle rate (i.e., the WACC) is 7.45% for both projects. Perform the analysis below and make a recommendation as to which project to pursue.
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
Project A | -$3,200 | $700 | $700 | $700 | $700 | $700 | $700 |
Project B | -$600 | $58 | $58 | $695 |
a. Compute the crossover rate for the two mutually exclusive projects and compare this rate to the projects WACC. Before performing any further analysis, can you predict whether the NPV and the IRR will produce consistent recommendations for which of the two projects should be selected? Briefly explain why or why not.
b. Compute the NPV for both projects using the crossover rate as the discount rate. What do you find?
C. Compute the NPV for each project (using the WACC of 7.45% as the discount rate). Based on NPV, which project should be selected?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started