In: Finance
Your division is considering two projects with the following cash flows (in millions):
Project A: Cash Flow 0= -$17, CF1= $8, CF2= $8, CF3= $3
Project B: Cash Flow 0= -$26, CF1= $13, CF2= $10, CF3= $9
a) What are the projects' NPVs assuming the WACC is 5%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places.
What are the projects' NPVs assuming the WACC is 10%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places.
What are the projects' NPVs assuming the WACC is 15%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places.
b) What are the projects' IRRs assuming the WACC is 5%? Do not round intermediate calculations. Round your answer to two decimal places.
What are the projects' IRRs assuming the WACC is 10%? Do not round intermediate calculations. Round your answer to two decimal places.
What are the projects' IRRs assuming the WACC is 15%? Do not round intermediate calculations. Round your answer to two decimal places.
c) If the WACC was 5% and A and B were mutually exclusive, which project would you choose? (Hint: The crossover rate is 20.19%.)
If the WACC was 10% and A and B were mutually exclusive, which project would you choose? (Hint: The crossover rate is 20.19%.)
If the WACC was 15% and A and B were mutually exclusive, which project would you choose? (Hint: The crossover rate is 20.19%.)
For part c, select the project which has higher NPV. However, only a project with positive NPV be selected because only a project with positive NPV would add value to the firm.