In: Accounting
Kanye Company is evaluating the purchase of a rebuilt spot-welding machine to be used in the manufacture of a new product. The machine will cost $175,000, has an estimated useful life of 7 years, a salvage value of zero, and will increase net annual cash flows by $33,612
What is its approximate internal rate of return?
To compute the internal rate of return we need to calculate | |||||
NPV at 2 discount rate which gives us positive and negative NPV and then we have | |||||
to interpolation method. | |||||
Let us calculate NPV at5 % and 10% discount rate | |||||
10% | 5% | ||||
a | Annual cash flow | $ 33,612.00 | $ 33,612.00 | ||
b | PV Annuity Factor for 7 years | 4.86842 | 5.78637 | ||
c | PV of annual cash flow (a*b) | $ 1,63,637.29 | $ 1,94,491.58 | ||
d | Initial investment | $ 1,75,000.00 | $ 1,75,000.00 | ||
e | NPV (c-d) | $ -11,362.71 | $ 19,491.58 | ||
IRR = 5% + (19491.58/[19491.58+11362.71]) * 5 | |||||
=5 % + 3.159% | |||||
=8.16% (approx) | |||||
=8% (exact IRR using excel function) | |||||