Question

In: Accounting

Comprehensive Problem 2. Kennedy Trucking Company (investment decision based on probability analysis) (LO13-1) Five years ago,...

Comprehensive Problem 2.

Kennedy Trucking Company (investment decision based on probability analysis) (LO13-1) Five years ago, Kennedy Trucking Company was considering the purchase of 60 new diesel trucks that were 15 percent more fuel-efficient than the ones the firm is now using. Mr. Hoffman, the president, had found that the company uses an average of 10 million gallons of diesel fuel per year at a price of $1.25 per gallon. If he can cut fuel consumption by 15 percent, he will save $1,875,000 per year (1,500,000 gallons times $1.25).

Mr. Hoffman assumed that the price of diesel fuel is an external market force that he cannot control and that any increased costs of fuel will be passed on to the shipper through higher rates endorsed by the Interstate Commerce Commission. If this is true, then fuel efficiency would save more money as the price of diesel fuel rises (at $1.35 per gallon, he would save $2,025,000 in total if he buys the new trucks). Mr. Hoffman has come up with two possible forecasts shown next—each of which he feels has about a 50 percent chance of coming true. Under assumption number 1, diesel prices will stay relatively low; under assumption number 2, diesel prices will rise considerably. Sixty new trucks will cost Kennedy Trucking $5 million. Under a special provision from the Interstate Commerce Commission, the allowable depreciation will be
25 percent in year 1, 38 percent in year 2, and 37 percent in year 3. The firm has a tax rate of
40 percent and a cost of capital of 10 percent.

  1. First, compute the yearly expected price of diesel fuel for both assumption 1 (relatively low prices) and assumption 2 (high prices) from the forecasts that follow.

         Forecast for assumption 1 (low fuel prices):

Probability
(same for each year)

Price of Diesel Fuel per Gallon

Year 1

Year 2

Year 3

.1

$ .80

$ .90

$1.00

.2

  1.00

  1.10

  1.10

.3

  1.10

  1.20

  1.30

.2

  1.30

  1.45

  1.45

.2

  1.40

  1.55

  1.60

Forecast for assumption 2 (high fuel prices):

Probability
(same for each year)

Price of Diesel Fuel per Gallon

Year 1

Year 2

Year 3

.1

$1.20

$1.50

$1.70

.3

  1.30

  1.70

  2.00

.4

  1.80

  2.30

  2.50

.2

  2.20

  2.50

  2.80

         b.      What will be the dollar savings in diesel expenses each year for assumption 1 and for assumption 2?

         c.      Find the increased cash flow after taxes for both forecasts.

         d.      Compute the net present value of the truck purchases for each fuel forecast assumption and the combined net present value (that is, weigh the NPV by .5).

         e.      If you were Mr. Hoffman, would you go ahead with this capital investment?

         f.       How sensitive to fuel prices is this capital investment?

Solutions

Expert Solution

e. Yes—The combined expected value of the outcomes is positive.

f. Quite sensitive when that many gallons are used per year.


Related Solutions

Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
Problem 13-23 (REV) Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for...
Problem 13-23 (REV) Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 24% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 18% each of the last three years. He has computed the cost and revenue estimates for each product as follows:    Product A Product B   Initial investment:   Cost of equipment (zero...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
Problem 13-25 Net Present Value Analysis of a Lease or Buy Decision [LO13-2] The Riteway Ad...
Problem 13-25 Net Present Value Analysis of a Lease or Buy Decision [LO13-2] The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its cars from a dealer and then sold the cars after three years of use. The company’s present fleet of cars is three years old and will be sold very shortly. To provide a replacement fleet, the company is considering two alternatives: Purchase alternative: The company can purchase the...
Problem 13-25 Net Present Value Analysis of a Lease or Buy Decision [LO13-2] The Riteway Ad...
Problem 13-25 Net Present Value Analysis of a Lease or Buy Decision [LO13-2] The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its cars from a dealer and then sold the cars after three years of use. The company’s present fleet of cars is three years old and will be sold very shortly. To provide a replacement fleet, the company is considering two alternatives: Purchase alternative: The company can purchase the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT