In: Finance
For two mutually exclusive machines, which machine will you select if the MARR is 12% based on the concept of IRR?
| Years | CF for Machine A | CF for Machine B |
| 0 | $ (120,000) | $ (148,000) |
| 1 | $ 32,000 | $ 46,000 |
| 2 | $ 35,000 | $ 49,000 |
| 3 | $ 38,000 | $ 52,000 |
| 4 | $ 41,000 | $ 52,000 |
| 5 | $ 44,000 | $ (52,000) |
| 6 | $ (24,000) | $ 55,000 |
| 7 | $ 47,000 | $ 55,000 |
| 8 | $ (21,000) | $ (21,000) |
|
Machine A |
||
|
Machine B |
||
|
Both need to be rejected. |
||
|
Both are equally good. |
| Answer Machine B Can be selected as it is giving more NPV | |||||
| Explanation | |||||
| Year | Discount factor at 12% | Machine A | Discounted Cash flows | Machine B | Discounted Cash flows |
| 0 | 1.00000 | (120,000) | (120,000) | (148,000) | (148,000) |
| 1 | 0.89286 | 32,000 | 28,572 | 46,000 | 41,072 |
| 2 | 0.79719 | 35,000 | 27,902 | 49,000 | 39,062 |
| 3 | 0.71178 | 38,000 | 27,048 | 52,000 | 37,013 |
| 4 | 0.63552 | 41,000 | 26,056 | 52,000 | 33,047 |
| 5 | 0.56743 | 44,000 | 24,967 | (52,000) | (29,506) |
| 6 | 0.50663 | (24,000) | (12,159) | 55,000 | 27,865 |
| 7 | 0.45235 | 47,000 | 21,260 | 55,000 | 24,879 |
| 8 | 0.40388 | (21,000) | (8,481) | (21,000) | (8,481) |
| Net present value | 15,164 | 16,950 | |||