In: Finance
Your division is considering two projects with the following cash flows (in millions): 0 1 2 3 Project A -$20 $5 $9 $12 Project B -$13 $8 $7 $3 What are the projects' NPVs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A $ million Project B $ million What are the projects' NPVs assuming the WACC is 10%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A $ million Project B $ million What are the projects' NPVs assuming the WACC is 15%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A $ million Project B $ million What are the projects' IRRs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Project A % Project B % What are the projects' IRRs assuming the WACC is 10%? Round your answer to two decimal places. Do not round your intermediate calculations. Project A % Project B % What are the projects' IRRs assuming the WACC is 15%? Round your answer to two decimal places. Do not round your intermediate calculations. Project A % Project B % If the WACC were 5% and A and B were mutually exclusive, which would you choose? (Hint: The crossover rate is 3.86%.) If the WACC were 10% and A and B were mutually exclusive, which would you choose? (Hint: The crossover rate is 3.86%.) If the WACC were 15% and A and B were mutually exclusive, which would you choose? (Hint: The crossover rate is 3.86%.)
Please refer following images for solutions. Answers are highlighted in blue and formula in orange.
Project NPV, when WACC = 5%
Project NPV, when WACC = 10%
Project NPV, when WACC = 15%
Project IRR is independent of its WACC% and therefore, IRR at 5%, 10% and 15% shall be constant:
A and B were mutually exclusive projects implies that at most only one out of the two projects can be chosen.
From above images, it can be seen that Project B maximises wealth at all three levels of WACC (5%, 10%, 15%) as well as has the higher IRR, and there it should be chosen.