In: Finance
9)
A firm with a WACC of 10% is considering the following mutually exclusive projects:
| 0 | 1 | 2 | 3 | 4 | 5 |
| Project 1 | -$200 | $70 | $70 | $70 | $165 | $165 |
| Project 2 | -$550 | $300 | $300 | $130 | $130 | $130 |
Which project would you recommend?
Select the correct answer.
|
|||
|
|||
|
|||
|
|||
|
| Project 1 | ||||||
| Discount rate | 10.000% | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | -200 | 70 | 70 | 70 | 165 | 165 |
| Discounting factor | 1.000 | 1.100 | 1.210 | 1.331 | 1.464 | 1.611 |
| Discounted cash flows project | -200.000 | 63.636 | 57.851 | 52.592 | 112.697 | 102.452 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Project 1 = | 189.23 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| IRR is the rate at which NPV =0 | ||||||
| IRR | 36.20% | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | -200.000 | 70.000 | 70.000 | 70.000 | 165.000 | 165.000 |
| Discounting factor | 1.000 | 1.362 | 1.855 | 2.526 | 3.441 | 4.686 |
| Discounted cash flows project | -200.000 | 51.396 | 37.737 | 27.707 | 47.952 | 35.208 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Project 1 = | 0.000 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| IRR= | 36.20% | |||||
| Project 2 | ||||||
| Discount rate | 10.000% | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | -550 | 300 | 300 | 130 | 130 | 130 |
| Discounting factor | 1.000 | 1.100 | 1.210 | 1.331 | 1.464 | 1.611 |
| Discounted cash flows project | -550.000 | 272.727 | 247.934 | 97.671 | 88.792 | 80.720 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Project 2 = | 237.84 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| Project 2 | ||||||
| IRR is the rate at which NPV =0 | ||||||
| IRR | 29.77% | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | -550.000 | 300.000 | 300.000 | 130.000 | 130.000 | 130.000 |
| Discounting factor | 1.000 | 1.298 | 1.684 | 2.185 | 2.836 | 3.680 |
| Discounted cash flows project | -550.000 | 231.184 | 178.153 | 59.491 | 45.844 | 35.328 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Project 2 = | 0.000 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| IRR= | 29.77% | |||||
