In: Accounting
Waterways puts much emphasis on cash flow when it plans for capital investments. The company chose its discount rate of 8% based on the rate of return it must pay its owners and creditors. Using that rate, Waterways then uses different methods to determine the best decisions for making capital outlays. This year Waterways is considering buying five new backhoes to replace the backhoes it now has. The new backhoes are faster, cost less to run, provide for more accurate trench digging, have comfort features for the operators, and have 1-year maintenance agreements to go with them. The old backhoes are working just fine, but they do require considerable maintenance. The backhoe operators are very familiar with the old backhoes and would need to learn some new skills to use the new backhoes. The following information is available to use in deciding whether to purchase the new backhoes. Old Backhoes New Backhoes Purchase cost when new $88,700 $199,857 Salvage value now $42,100 Investment in major overhaul needed in next year $55,986 Salvage value in 8 years $15,000 $91,000 Remaining life 8 years 8 years Net cash flow generated each year $30,100 $43,700 Click here to view PV table. (a) Evaluate in the following ways whether to purchase the new equipment or overhaul the old equipment. (Hint: For the old machine, the initial investment is the cost of the overhaul. For the new machine, subtract the salvage value of the old machine to determine the initial cost of the investment.) (1) Using the net present value method for buying new or keeping the old. (For calculation purposes, use 5 decimal places as displayed in the factor table provided. If the net present value is negative, use either a negative sign preceding the number eg -45 or parentheses eg (45). Round final answer to 0 decimal places, e.g. 5,275.) New Backhoes Old Backhoes Net Present Value $ $ Waterways should equipment. (2) Using the payback method for each choice. (Hint: For the old machine, evaluate the payback of an overhaul.) (Round answers to 2 decimal places, e.g. 1.25) New Backhoes Old Backhoes Payback Period years years Waterways should equipment. (3) Comparing the profitability index for each choice. (Round answers to 2 decimal places, e.g. 1.25) New Backhoes Old Backhoes Profitability Index Waterways should equipment. Calculate the internal rate of return factor for the new and old blackhoes. (Round answers to 5 decimal places, e.g. 5.27647.) New Backhoes Old Backhoes IRR Factor (4) Comparing the internal rate of return for each choice to the required 8% discount rate. Waterways should equipment.
1.
New Backhoes | Old backhoes | |
Net present Value | $ 1,42,535.74 | $ 1,25,091.91 |
Waterways should purchase new equipment |
Working:
New Backhoes | Old backhoes | |
A) Annual Cash inflows | $ 43,700.00 | $ 30,100.00 |
B) Project Life (n yrs) | 8 | 8 |
C) Present Value Annuity Factor [PVAF(8%,n yrs)] | 5.74664 | 5.74664 |
D) Present Value of Annual Cash Inflows (C*A) | 2,51,128 | 1,72,974 |
E) Salvage Value | 91,000 | 15,000 |
F) Present Value Factor [PVF(8%,n yrs)] | 0.54027 | 0.54027 |
G) Present Value of Salvage Value (E*F) | 49,165 | 8,104 |
H) Total Present Value of cash inflows (D+G) | 3,00,293 | 1,81,078 |
I) Initial Investment | 1,57,757 | 55,986 |
J) Net Present Value (H-I) | $ 1,42,535.74 | $ 1,25,091.91 |
2.
New Backhoes | Old backhoes | |
i) Initial Investment | $ 1,57,757.00 | $ 55,986.00 |
ii) Annual Cash inflows | $ 43,700.00 | $ 30,100.00 |
iii) Payback period | 3.61000 | 1.86000 |
Waterways should overhaul old equipment |
3.
New Backhoes | Old backhoes | |
a) Total Present Value of cash inflows | $ 3,00,292.74 | $ 1,81,077.91 |
b) Initial Investment | $ 1,57,757.00 | $ 55,986.00 |
c) Profitability Index (a/b) | 1.90 | 3.23 |
Waterways should overhaul old equipment |
New Backhoes | Old backhoes | |
i) Initial Investment | $ 1,57,757.00 | $ 55,986.00 |
ii) Annual Cash inflows | $ 43,700.00 | $ 30,100.00 |
iii) IRR Factor | 3.61000 | 1.86000 |
4. Waterways should overhaul old equipment