In: Accounting
INTERNAL RATE OF RETURN/PAYBACK METHOD
PART 1: Johnson Drill Bits, Inc. has just purchased a new piece of equipment for $66,350. The machine saves the company $13,500 each year of its 6-year life. There is no salvage value. What is the approximate internal rate of return for this equipment?
PART 2: Catalina Company has just purchased a new piece of equipment for $85,000 that will provide an annual cost savings of $18,000. There is no salvage value. What is the payback period?
Here are some present value tables you can use for this problem:
PRESENT VALUE TABLES
Present Value of $1
Periods |
4% |
6% |
8% |
10% |
12% |
14% |
4 |
.855 |
.792 |
.735 |
.683 |
.636 |
.592 |
5 |
.822 |
.747 |
.681 |
.621 |
.567 |
.519 |
6 |
.790 |
.705 |
.630 |
.564 |
.507 |
.456 |
7 |
.760 |
.665 |
.583 |
.513 |
.452 |
.400 |
8 |
.731 |
.627 |
.540 |
.467 |
.404 |
.351 |
9 |
.703 |
.592 |
.500 |
.424 |
.361 |
.308 |
10 |
.676 |
.558 |
.463 |
.386 |
.322 |
.270 |
Present |
Value |
of |
Annuity |
|||
Periods |
4% |
6% |
8% |
10% |
12% |
14% |
4 |
3.630 |
3.465 |
3.312 |
3.170 |
3.037 |
2.914 |
5 |
4.452 |
4.212 |
3.993 |
3.791 |
3.605 |
3.433 |
6 |
5.242 |
4.917 |
4.623 |
4.355 |
4.111 |
3.889 |
7 |
6.002 |
5.582 |
5.206 |
4.868 |
4.564 |
4.288 |
8 |
6.733 |
6.210 |
5.747 |
5.335 |
4.968 |
4.639 |
9 |
7.435 |
6.802 |
6.247 |
5.759 |
5.328 |
4.946 |
10 |
8.111 |
7.360 |
6.710 |
6.145 |
5.650 |
5.216 |
Part 1
Let us first try to get an approximate
Annuity factor = Initial investment / Annual inflow = 66,350 / 13,500 = 4.915
In 6th year, the nearest to this is 4.917 which is at 6%.
So the answer to this is, IRR = 6.02%. Here is the proof
Year | Cash flow | PV Factor | Present Value |
0 | $ (66,350) | 1 | $ (66,350) |
1 | $ 13,500 | 0.94325 | $ 12,734 |
2 | $ 13,500 | 0.88972 | $ 12,011 |
3 | $ 13,500 | 0.83923 | $ 11,330 |
4 | $ 13,500 | 0.79161 | $ 10,687 |
5 | $ 13,500 | 0.74669 | $ 10,080 |
6 | $ 13,500 | 0.70431 | $ 9,508 |
$ (0) |
Part 2
Payback period = Initial investment / Annual cost saving = 85,000 / 18,000 = 4.72 years