In: Accounting
Problem 13-20 Net Present Value Analysis; Uncertain Cash Flows [LO13-2, LO13-4] “I’m not sure we should lay out $350,000 for that automated welding machine,” said Jim Alder, president of the Superior Equipment Company. “That’s a lot of money, and it would cost us $94,000 for software and installation, and another $60,000 per year just to maintain the thing. In addition, the manufacturer admits it would cost $57,000 more at the end of three years to replace worn-out parts.” “I admit it’s a lot of money,” said Franci Rogers, the controller. “But you know the turnover problem we’ve had with the welding crew. This machine would replace six welders at a cost savings of $124,000 per year. And we would save another $8,500 per year in reduced material waste. When you figure that the automated welder would last for six years, I’m sure the return would be greater than our 15% required rate of return.” “I’m still not convinced,” countered Mr. Alder. “We can only get $22,000 scrap value out of our old welding equipment if we sell it now, and in six years the new machine will only be worth $40,000 for parts. But have your people work up the figures and we’ll talk about them at the executive committee meeting tomorrow.” Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Compute the annual net cost savings promised by the automated welding machine. 2a. Using the data from (1) above and other data from the problem, compute the automated welding machine’s net present value. 2b. Would you recommend purchasing the automated welding machine? 3. Assume that management can identify several intangible benefits associated with the automated welding machine, including greater flexibility in shifting from one type of product to another, improved quality of output, and faster delivery as a result of reduced throughput time. What minimum dollar value per year would management have to attach to these intangible benefits in order to make the new welding machine an acceptable investment?
Compute the annual net cost savings promised by the automated welding machine.
|
Using the data from (1) above and other data from the problem, compute the automated welding machine’s net present value. (Enter negative amount with a minus sign. Round your final answer to the nearest whole dollar amount.)
|
Assume that management can identify several intangible benefits associated with the automated welding machine, including greater flexibility in shifting from one type of product to another, improved quality of output, and faster delivery as a result of reduced throughput time. What minimum dollar value per year would management have to attach to these intangible benefits in order to make the new welding machine an acceptable investment? (Round your final answer to the nearest whole dollar amount.)
Show less
|
Solution 1: | |
Computation of annual cost saving promised by Welding machine | |
Particulars | Amount |
Cost saving due to repalcement of welders | $1,24,000.00 |
Cost reduction in material waste | $8,500.00 |
Additional annual cost of maintenance | -$60,000.00 |
Total net annual cost saving promised by welding machine | $72,500.00 |
Solution 2a: | ||||
Computation of NPV - Replacement proposal of Welding Machine - Superior Equipment Company | ||||
Particulars | Period | Amount | PV Factor | Present Value |
Cash Outflows: | ||||
Cost of Welding machine | 0 | $3,50,000 | 1 | $3,50,000 |
software and installation cost | 0 | $94,000 | 1 | $94,000 |
Sale value of old equipment | 0 | -$22,000 | 1 | -$22,000 |
Replacement cost of worn out parts | 3 | $57,000 | 0.658 | $37,506 |
Present value of cash outflows (A) | $4,59,506 | |||
Cash Inflows: | ||||
Annual net cost savings | 1-6 | $72,500 | 3.784 | $2,74,340 |
Salvage value of new machine | 6 | $40,000 | 0.432 | $17,280 |
Present value of cash Inflows (B) | $2,91,620 | |||
NPV (B-A) | -$1,67,886 |
Solution 2b: As NPV is negative, it is not recommeded to purchase automatic welding machine. |
Solution 3: Present value of intangible benefit required to make NPV positive = 167,886 Minimum dollar value to be attached to intangible benefits in order to make new welding machine an acceptable investment = Required present value / Cumulative PV Factor at 15% for 6 periods = $167886 / 3.784 = $44,367 |