Question

In: Accounting

(Related to Checkpoint​ 12.2)  ​(Replacement project cash​ flows)  ​Madrano's Wholesale Fruit Company located in​ McAllen, Texas...

(Related to Checkpoint​ 12.2)  ​(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 ​$320,000 on eight rigs. The new trucks will be kept for 5 ​years, during which time they will be depreciated toward a ​$41,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 ​$18,000 ​(because the tractors have a current book value of​ zero, the selling price is fully taxable at the​ firm's 25 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 ​$205,000 per year in diesel​ fuel, whereas the​ new, more efficient fleet will use only ​$170,000.

In​ addition, the new fleet will be covered under​ warranty, so the maintenance costs per year are expected to be only ​$13,000 compared to ​$33,000 for the existing fleet.

a.  What are the differential operating cash flow savings per year during years 1 through 5 for the new​ fleet?

b.  What is the initial cash outlay required to replace the existing fleet with the newer​ tractors?

c.  What does the timeline for the replacement project cash flows for years 0 through 5 look​ like?

d.  If Madrano requires a discount rate of 7 percent for new​ investments, should the fleet be​ replaced?

Solutions

Expert Solution

Answer (a)

Particulars Old Fleet New Fleet Saving
Fuel Cost per year $2,05,000 $1,70,000 $ 35,000
Maintenance Cost per year $ 33,000 $ 13,000 $ 20,000
Total $ 2,38,000 $ 1,83,000 $ 55,000

Therefore differential operating cash outflow savings per year during years 1 through 5 for the new fleet is $ 55,000

Answer (b)

Initial Cash Outlay required to replace the existing machine with new tractors will be computed as below:

= Gross Investment in New Tractors - (Sale Proceeds realised from sale of old fleet - Tax Payable)

= $3,20,000 - ($18000 - [25% * $18000])

= $ 3,20,000 - ( $ 13,500)

= $ 3,06,500

Answer (c)

Timeline for the replacement project cash flows for years 0 through 5 look​ like as below :

Particulars Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Initial Outlay - $ 3,06,500 0 0 0 0 0
Savings in operation Expenses $ 55,000 $ 55,000 $ 55,000 $ 55,000 $ 55,000
Less : Tax payable on savings @ 25% $ 13,750 $ 13,750 $ 13,750 $ 13,750 $ 13,750
Add: Salvage Value of New Fleet $ 41,000
Less: Tax Payable on Dispossal $ 10,250
Add: Depreciation $ 55,800 $ 55,800 $ 55,800 $ 55,800 $ 55,800
Net Cash Flow - $ 3,06,500 $ 97,050 $ 97,050 $ 97,050 $ 97,050 $1,27,800

Answer (d)

To evaluate the project viability using a discount rate of 7% we need to calculate the NPV of the above computed cash flows. If, it is positive then only the new fleet be acquired and old fleet be discarded.

NPV = - $ 3,06,500 + $97,050/(1.07) + $97,050/(1.07)2 + $97,050/(1.07)3+ $97,050/(1.07)4 + $1,27,800 / 1.07)5

= $ 1,05,933.16

Since, the NPV is positive the ​Madrano's Wholesale Fruit Company located in​ McAllen should purchase the new fllet and doscard the old fleet

+


Related Solutions

(Related to Checkpoint​ 12.2)  ​(Replacement project cash​ flows)  ​Madrano's Wholesale Fruit Company located in​ McAllen, Texas...
(Related to Checkpoint​ 12.2)  ​(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 ​$440 comma 000 on eight rigs. The new trucks will be kept for 5 ​years, during which time they will be depreciated toward a ​$39 comma...
(Replacement project cash? flows) Madrano's Wholesale Fruit Company located in? McAllen, Texas is considering the purchase...
(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...
 ​(Replacement project cash​ flows)  ​Madrano's Wholesale Fruit Company located in​ McAllen, Texas is considering the purchase...
 ​(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 ​$320,000 on eight rigs. The new trucks will be kept for 5 ​years, during which time they will be depreciated toward a ​$42,000 salvage value using​ straight-line depreciation. The rigs...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 12 comma 00012,000 of these per year for 1010 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$130130 each with variable costs of ​$4545 for each one​ produced, and annual fixed costs associated with...
Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product...
Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 8 comma 000 of these per year for 10 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$120 each with variable costs of ​$25 for each one​ produced, and annual fixed costs associated with...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 9 000 of these per year for 10 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$80 each with variable costs of ​$35 for each one​ produced an annual fixed cost associated with production...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product...
​(Related to Checkpoint​ 12.1)  ​(Calculating project cash flows and​ NPV)  You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 9 comma 000 of these per year for 10 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$130 each with variable costs of ​$30 for each one​ produced, and annual fixed costs associated with...
​(Related to Checkpoint​ 12.1)(Calculating project cash flows and​ NPV)You are considering expanding your product line that...
​(Related to Checkpoint​ 12.1)(Calculating project cash flows and​ NPV)You are considering expanding your product line that currently consists of skateboards to include​ gas-powered skateboards, and you feel you can sell 11,000 of these per year for 10 years​ (after which time this project is expected to shut down with​ solar-powered skateboards taking​ over). The gas skateboards would sell for ​$110 each with variable costs of ​$35 for each one​ produced, and annual fixed costs associated with production would be ​$180,000....
(Related to Checkpoint​ 6.6)   ​(Present value of annuities and complex cash flows​) You are given three...
(Related to Checkpoint​ 6.6)   ​(Present value of annuities and complex cash flows​) You are given three investment alternatives to analyze. The cash flows from these three investments are as​ follows: Investment Alternatives End of Year A B C 1 ​$ 15,000 ​$ 15,000 2    15,000 3    15,000 4    15,000 5    15,000 ​$ 15,000    6    15,000 75,000 7 15,000 8 15,000 9 15,000 10 15,000 15,000 Assuming an annual discount rate of 23 ​percent, find the present value of each investment....
​(Related to Checkpoint​ 6.6)   ​(Present value of annuities and complex cash flows​) You are given three...
​(Related to Checkpoint​ 6.6)   ​(Present value of annuities and complex cash flows​) You are given three investment alternatives to analyze. The cash flows from these three investments are as​ follows: Investment Alternatives End of Year A B C 1 ​$ 16,000 ​$ 16,000 2    16,000 3    16,000 4    16,000 5    16,000 ​$ 16,000    6    16,000 80,000 7 16,000 8 16,000 9 16,000 10 16,000 16,000 Assuming an annual discount rate of 22 ​percent, find the present value of each investment....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT