Kerron
Company is presented with the following two mutually exclusive
projects. The required return for both projects is 19 percent.
| Year | Project M | Project N |
| 0 | –$140,000 | –$355,000 |
| 1 | 63,500 | 152,500 |
| 2 | 81,500 | 180,000 |
| 3 | 72,500 | 137,500 |
| 4 | 58,500 | 110,000 |
| | ||
| Required: | |
| (a) |
What is the IRR for each project? (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).)
|
| IRR | |
| Project M | % |
| Project N | % |
| | |
| (b) |
What is the NPV for each project? (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).)
|
| NPV | |
| Project M | $ |
| Project N | $ |
| | |
| (c) | Which, if either, of the projects should the company accept? |
| Project M |
Explanation: (a)
| The IRR for each project is: |
| M: | $140,000 = $63,500 / (1 + IRR) + $81,500 / (1 + IRR)2 + $72,500 / (1 + IRR)3 + $58,500 / (1 + IRR)4 |
|
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:
|
| IRR = 34.47% |
| N: | $355,000 = $152,500 / (1 + IRR) + $180,000 / (1 + IRR)2 + $137,500 / (1 + IRR)3 + 110,000 / (1 + IRR)4 |
|
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:
|
| IRR = 24.61% |
|
The IRR decision rule implies we accept project M because the IRR for M is greater than the IRR for N.
|
(b)
| The NPV for each project is: |
| M: | NPV = – $140,000 + $63,500 / 1.19 + $81,500 / 1.192 + $72,500 / 1.193 + $58,500 / 1.194 |
| NPV = $43,108.55 |
| N: | NPV = – $355,000 + $152,500 / 1.19 + $180,000 / 1.192 + $137,500 / 1.193 + $110,000 / 1.194 |
| NPV = $36,709.17 |
|
The NPV criterion implies we accept project M because project M has a higher NPV than project N.
|
(c)
|
Accept project M since the NPV is higher. IRR cannot be used to rank mutually exclusive projects.
|
| Calculator Solution: |
| Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation. |
| Project M | |||
|
CFo
| –$140,000 |
CFo
| –$140,000 |
|
C01
| $63,500 |
C01
| $63,500 |
|
F01
| 1 |
F01
| 1 |
|
C02
| $81,500 |
C02
| $81,500 |
|
F02
| 1 |
F02
| 1 |
|
C03
| $72,500 |
C03
| $72,500 |
|
F03
| 1 |
F03
| 1 |
| C04 | $58,500 | C04 | $58,500 |
| F04 | 1 | F04 | 1 |
| CPT IRR | I = 19 | ||
| 34.47% | NPV CPT | ||
| $43,108.55 | |||
| Project N | |||
|
CFo
| –$355,000 |
CFo
| –$355,000 |
|
C01
| $152,500 |
C01
| $152,500 |
|
F01
| 1 |
F01
| 1 |
|
C02
| $180,000 |
C02
| $180,000 |
|
F02
| 1 |
F02
| 1 |
|
C03
| $137,500 |
C03
| $137,500 |
|
F03
| 1 |
F03
| 1 |
| C04 | $110,000 | C04 | $110,000 |
| F04 | 1 | F04 | 1 |
| CPT IRR | I = 19 | ||
| 24.61% | NPV CPT | ||
| $36,709.17 | |||
No comments:
Post a Comment