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