In: Finance
A company has to buy a new gadget maker and must choose between 2 options.
The first gadget maker costs $400,000, and will need maintenance of $225,000 at the end of the fifth year. The salvage value after 10 years will be $175,000.
The second option costs $250,000 and will require annual maintenance of $30,000 each year for 10 years. At the end of 10 years, the salvage value will be $75,000.
Which gadget maker should the firm select if interest is 8.5% compounded annually?
*Can you please show formulas used.
| Calculation of Present Worth of Gadgets | ||||||
| Year | First Gadget | Second Gadget | ||||
| Cash Flows | Discount Factor @8.5% | Discounted Cash Flows | Cash Flows | Discount Factor @8.5% | Discounted Cash Flows | |
| A | B | C = 1/(1+8.5%)^A | D = B*C | E | F = 1/(1+8.5%)^A | G = E*F | 
| 0 | -400000 | 1 | -400000 | -250000 | 1 | -250000 | 
| 1 | 0 | 0.921658986 | 0 | -30000 | 0.921658986 | -27649.76959 | 
| 2 | 0 | 0.849455287 | 0 | -30000 | 0.849455287 | -25483.6586 | 
| 3 | 0 | 0.782908098 | 0 | -30000 | 0.782908098 | -23487.24295 | 
| 4 | 0 | 0.721574284 | 0 | -30000 | 0.721574284 | -21647.22853 | 
| 5 | -225000 | 0.665045423 | -149635.2202 | -30000 | 0.665045423 | -19951.3627 | 
| 6 | 0 | 0.612945091 | 0 | -30000 | 0.612945091 | -18388.35272 | 
| 7 | 0 | 0.564926351 | 0 | -30000 | 0.564926351 | -16947.79052 | 
| 8 | 0 | 0.520669448 | 0 | -30000 | 0.520669448 | -15620.08343 | 
| 9 | 0 | 0.479879675 | 0 | -30000 | 0.479879675 | -14396.39026 | 
| 10 | 175000 | 0.442285415 | 77399.94763 | 45000 | 0.442285415 | 19902.84368 | 
| PW | -472235.2726 | -413669.0356 | ||||
| PW of First Gadget is -$472,235.27 | ||||||
| PW of Second Gadget is -$413,669.04 | ||||||
| Therefore, it is better to choose second gadget since PW of second gadget is lower than PW of first gadget |