In: Finance
Problem 13-28 Net Present Value Analysis [LO13-2]
Bilboa Freightlines, S.A., of Panama, has a small truck that it uses for intracity deliveries. The truck is worn out and must be either overhauled or replaced with a new truck. The company has assembled the following information:
Present Truck |
New Truck |
|||||
Purchase cost new | $ | 34,000 | $ | 44,000 | ||
Remaining book value | $ | 21,000 | - | |||
Overhaul needed now | $ | 20,000 | - | |||
Annual cash operating costs | $ | 16,500 | $ | 15,000 | ||
Salvage value-now | $ | 10,000 | - | |||
Salvage value-five years from now | $ | 9,000 | $ | 9,000 | ||
If the company keeps and overhauls its present delivery truck, then the truck will be usable for five more years. If a new truck is purchased, it will be used for five years, after which it will be traded in on another truck. The new truck would be diesel-operated, resulting in a substantial reduction in annual operating costs, as shown above.
The company computes depreciation on a straight-line basis. All investment projects are evaluated using a 6% discount rate.
Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.
Required:
1. What is the net present value of the “keep the old truck” alternative?
2. What is the net present value of the “purchase the new truck” alternative?
3. Should Bilboa Freightlines keep the old truck or purchase the new one?
1.Net present value of the “keep the old truck” alternative | ||||||||||
Initial Cost: | ||||||||||
A | Opportunity cost of not selling | $10,000 | ||||||||
B | Overhaul needed | $20,000 | ||||||||
C=A+B | Total initial cost | $30,000 | ||||||||
D | Present value of annual cash operating cost | $69,504 | (Using PV function of excel with Rate=6%, Nper=5,Pmt=-16500) | |||||||
E | Present value of Salvage value after 5 years | $ 6,725 | (9000/(1.06^5) | |||||||
F=C+D-E | Net Present Value | $92,779 | ||||||||
2.Net present value of the “Purchase new truck” alternative | ||||||||||
Initial Cost: | ||||||||||
A | Purchase cost now | $44,000 | ||||||||
B | Present value of annual cash operating cost | $63,185 | (Using PV function of excel with Rate=6%, Nper=5,Pmt=-15000) | |||||||
C | Present value of Salvage value after 5 years | $ 6,725 | (9000/(1.06^5) | |||||||
D=A+B-C | Net Present Value | $100,460 | ||||||||
3.Should Bilboa Freightlines keep the old truck or purchase the new one? | ||||||||||
Bilboa Freightlines should keep the old Truck | ||||||||||