In: Accounting
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.
Forecast for assumption 1 (low fuel prices):
Probability |
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 |
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?
e. Yes—The combined expected value of the outcomes is positive.
f. Quite sensitive when that many gallons are used per year.