Please show all work on excel You just got hired by McKinsey & Company as a financial
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 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 |
g. What is the discounted payback for each project, and which project should be selected according to this criterion?
H. Recognizing that these projects are mutually exclusive and repeatable, compute the equivalent annual annuity (EAA) for each and indicate which project should be selected based on EAA.