In: Finance
(Replacement project cash? flows) Madrano's Wholesale Fruit Company located in? McAllen, Texas is considering the purchase of a new fleet of tractors to be used in the delivery of fruits and vegetables grown in the Rio Grande Valley of Texas. If it goes through with the? purchase, it will spend ?$360,000 on eight rigs. The new trucks will be kept for 5 ?years, during which time they will be depreciated toward a ?$39,000 salvage value using? straight-line depreciation. The rigs are expected to have a market value in 5 years equal to their salvage value. The new tractors will be used to replace the? company's older fleet of eight trucks which are fully depreciated but can be sold for an estimated ?$22,000 ?(because the tractors have a current book value of? zero, the selling price is fully taxable at the? firm's 29 percent tax? rate). The existing tractor fleet is expected to be useable for 5 more years after which time they will have no salvage value. The existing fleet of tractors uses ?$210,000 per year in diesel? fuel, whereas the? new, more efficient fleet will use only ?$120,000.In? addition, the new fleet will be covered under? warranty, so the maintenance costs per year are expected to be only?$11,000 compared to $30,000 for the existing fleet.
a.??The differential operating cash flow savings per year during years 1 through 4 for the new fleet are $___.?(Round to the nearest? dollar.)
The terminal cash flow of the new fleet is ?$____.?(Round to the nearest? dollar.)
b.??The initial cash outlay required to replace the existing fleet with the newer tractors is ?$____.(Round to the nearest? dollar.)
c.?Is the timeline below an accurate representation of the replacement project cash flows for years 0 through 5?? True or False.(Select from the? drop-down menu.)
d.??Assuming Madrano requires a discount rate of 13?% for new? investments, the fleet ? (Select the best choice? below.)
A.should not be purchased because the NPV is negative $ 14,470?,making it an unacceptable investment for the company.
B.should be purchased because the NPV is $ 14,470?,making it a worthwhile investment for the company.
a.Operating Cash Flows per Year for the existing fleet:
Fuel net of tax= 210,000(1-.29) = 149,100
Maintenance Costs net of tax= 30,000(1-.29) = 21,300
Total Cost per year net of tax= 247,000(1-.29) = 170,400
New Fleet:
Fuel = 120,000(1-.29) = 85,200
Maintenance Cost = 11,000 (1-.29) = 7,810
Tax Saving on Depreciation = 64,200*29% = (18,618)
Total Cost net of tax = 74,392
Differential operating cash flow savings per year for New Fleet = 170,400 – 74,392 = $96,008
Working Note:
Depreciation = (360,000-39000)/5 = 64,200
All costs have been taken net of sax since tax will be saved on all costs incurred
Terminal Cash Flow = Salvage Value = 39,000
b. Initial Cash Outlay Required = Cost of New Fleet – Salvage Value of Old net of Tax
=360,000-22000(1-.29)
=$344,380
c.True
The timeline for the replacement project cash flows for years 0 through 5 looks? like recovery in the form of annuity as there will be equal amount of savings in Cash Flows each year
d. NPV = Present Value of Cash Inflows – Present Value of Cash Outflows
= 96,008*PVAF(13%, 5 years) + 39,000*PVF(13%, 5years) – 344,380
=96,008*3.517 + 39,000*0.543 – 344,380
=+14,457 (approx)
B.should be purchased because the NPV is $ 14,470?,making it a worthwhile investment for the company.