In: Finance
Brock Florist Company buys a new delivery truck for $29,000. It is classified as a light-duty truck. Brock is in a 30% tax bracket and has a cost of capital of 8%. Assume that Brock will sell its delivery truck after three years of service for $15,000. a. Calculate the NPV of the equipment purchase using a five-year life with straight-line depreciation to zero salvage. b. Calculate the NPV of the equipment purchase using a five-year life and MACRS depreciation. c. Which of the two depreciation methods would Brock prefer?
| 
 Year  | 
 3-year Class  | 
 5-year Class  | 
 7-year Class  | 
| 
 1  | 
 33.33%  | 
 20.00%  | 
 14.29%  | 
| 
 2  | 
 44.45%  | 
 32.00%  | 
 24.49%  | 
| 
 3  | 
 14.81%  | 
 19.20%  | 
 17.49%  | 
| 
 4  | 
 7.41%  | 
 11.52%  | 
 12.49%  | 
| 
 5  | 
 11.52%  | 
 8.93%  | 
|
| 
 6  | 
 5.76%  | 
 8.92%  | 
|
| 
 7  | 
 8.93%  | 
||
| 
 8  | 
 4.46%  | 
| Answer a | ||||||
| Calculation of NPV of the equipment purchase using a five-year life with straight-line depreciation to zero salvage. | ||||||
| Year | 0 | 1 | 2 | 3 | NPV | |
| Purchase cost of new delivery truck | -$29,000.00 | |||||
| Depreciation tax shield | $1,740.00 | $1,740.00 | $1,740.00 | |||
| After tax sale value of delivery truck | $13,980.00 | |||||
| Net Cash flow | -$29,000.00 | $1,740.00 | $1,740.00 | $15,720.00 | ||
| x Discount factor @ 8% | 1 | 0.925925926 | 0.85733882 | 0.793832241 | ||
| Present Value | -$29,000.00 | $1,611.11 | $1,491.77 | $12,479.04 | -$13,418.08 | |
| NPV of the equipment purchase using a five-year life with straight-line depreciation to zero salvage = | -$13,418.08 | |||||
| Working | ||||||
| Depreciation per year using straight line method = $29000/5 years = $5800 | ||||||
| Depreciation tax shield per year = Depreciation per year x Tax rate = $5800 x 30% = $1740 | ||||||
| Calculation of after tax sale value of delivery truck | ||||||
| Sale value | $15,000.00 | |||||
| Less : Book value after 3 years | $11,600.00 | |||||
| Gain on sale | $3,400.00 | |||||
| Tax @ 30% on Gain | $1,020.00 | |||||
| After tax sale value [Sale value - tax] | $13,980.00 | |||||
| Answer b | ||||||
| Calculation of NPV of the equipment purchase using a five-year life and MACRS depreciation | ||||||
| Year | 0 | 1 | 2 | 3 | NPV | |
| Purchase cost of new delivery truck | -$29,000.00 | |||||
| Depreciation tax shield | $1,740.00 | $2,784.00 | $1,670.40 | |||
| After tax sale value of delivery truck | $13,005.60 | |||||
| Net Cash flow | -$29,000.00 | $1,740.00 | $2,784.00 | $14,676.00 | ||
| x Discount factor @ 8% | 1 | 0.925925926 | 0.85733882 | 0.793832241 | ||
| Present Value | -$29,000.00 | $1,611.11 | $2,386.83 | $11,650.28 | -$13,351.78 | |
| NPV of the equipment purchase using a five-year life and MACRS depreciation | -$13,351.78 | |||||
| Working | ||||||
| Calculation of depreciation tax shield | ||||||
| Year | Cost of new delivery truck | 5 Year Class MACRS rates | Depreciation | Depreciation tax shield @ 30% | ||
| 1 | $29,000.00 | 20% | $5,800.00 | $1,740.00 | ||
| 2 | $29,000.00 | 32% | $9,280.00 | $2,784.00 | ||
| 3 | $29,000.00 | 19.20% | $5,568.00 | $1,670.40 | ||
| Calculation of after tax sale value of delivery truck | ||||||
| Sale value | $15,000.00 | |||||
| Less : Book value after 3 years | $8,352.00 | |||||
| Gain on sale | $6,648.00 | |||||
| Tax @ 30% on Gain | $1,994.40 | |||||
| After tax sale value [Sale value - tax] | $13,005.60 | |||||
| Answer c | ||||||
| Brock should prefer MACRS depreciation method as it gives lower net present value of cash flows. | ||||||