In: Accounting
X Company is considering replacing one of its machines in order to save operating costs. Operating costs with the current machine are $68,000 per year; operating costs with the new machine are expected to be $38,450 per year. The new machine will cost $156,000 and will last for five years, at which time it can be sold for $3,000. The current machine will also last for five more years but will not be worth anything at that time. It cost $45,000 four years ago, but its current disposal value is only $6,000. Assuming a discount rate of 8%, what is the incremental net present value of replacing the current machine?
b. Assume the following two changes: 1) both machines will last for six more years, 2) the salvage value of the new machine after six years will be zero. If X Company replaces the current equipment, what is the approximate internal rate of return?
New Machine Cost | 156000 | |||||||
Curent cost of old machine | 6000 | |||||||
Net outflow | 150000 | (156000-6000) | ||||||
Operating Cost with curent Machine | 68000 | |||||||
Operating Cost with new machine | 38450 | |||||||
Annual Net Saving | 29550 | (68000-38450) | ||||||
Expected Life | 5 | years | ||||||
Salavage Value new machine | 3000 | |||||||
Cost of capital | 8% | |||||||
A | ||||||||
a | b | c=a*b | ||||||
Year | Amount | PV Factor@8% | Present Value | |||||
0 | -150000 | 1 | (150,000) | |||||
1 to 5 | 29550 | 3.9927 | =PV(8%,5,-1,0,0) | Present value annuity @8% for 5years | 117,985 | |||
5 | 3000 | 0.6806 | =(1/1.08)^5 | Present value @8% for 5th year | 2,042 | |||
NPV | (29,974) | |||||||
Since incremental NPV is negative machine should not be replaced. | ||||||||
B | ||||||||
a | b | c=a*b | ||||||
Year | Amount | PV Factor@8% | Present Value | |||||
0 | -150000 | 1 | (150,000) | |||||
1 to 6 | 29550 | 4.6229 | =PV(8%,6,-1,0,0) | Present value annuity @8% for 6years | 136,606 | |||
NPV | (13,394) | |||||||
Since incremental NPV is negative machine should not be replaced. | ||||||||
IRR Calculation | ||||||||
Year | Cashflow | |||||||
0 | -150000 | |||||||
1 | 29550 | |||||||
2 | 29550 | |||||||
3 | 29550 | |||||||
4 | 29550 | |||||||
5 | 29550 | |||||||
6 | 29550 | |||||||
IRR | 5% | =IRR(C325:C331) | ||||||