In: Finance
Mom’s Cookies, Inc., is considering the purchase of a new cookie oven. The original cost of the old oven was $42,000; it is now five years old, and it has a current market value of $18,500. The old oven is being depreciated over a 10-year life toward a zero estimated salvage value on a straight-line basis, resulting in a current book value of $21,000 and an annual depreciation expense of $4,200. The old oven can be used for six more years but has no market value after its depreciable life is over. Management is contemplating the purchase of a new oven whose cost is $25,000 and whose estimated salvage value is zero. Expected before-tax cash savings from the new oven are $3,700 a year over its full MACRS depreciable life. Depreciation is computed using MACRS over a 5-year life, and the cost of capital is 10 percent. Assume a 34 percent tax rate.
What will the cash flows for this project be? (Note that the $42,000 cost of the old oven is depreciated over ten years at $4,200 per year. The half-year convention is not used for the old oven. Negative amounts should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places.)
| Calculation of cash flows of the project | |||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Investment in new oven | -$25,000.00 | ||||||||
| After tax sale value of old oven | $19,350.00 | ||||||||
| Before tax cash savings | $3,700.00 | $3,700.00 | $3,700.00 | $3,700.00 | $3,700.00 | $3,700.00 | |||
| Tax @ 34% on cash savings | -$1,258.00 | -$1,258.00 | -$1,258.00 | -$1,258.00 | -$1,258.00 | -$1,258.00 | |||
| Depreciation tax shield | $272.00 | $1,292.00 | $204.00 | -$448.80 | -$448.80 | $489.60 | |||
| Cash flows of project | -$5,650.00 | $2,714.00 | $3,734.00 | $2,646.00 | $1,993.20 | $1,993.20 | $2,931.60 | ||
| Working | |||||||||
| Calculation of depreciation on New Oven using 5 Year MACRS rates | |||||||||
| Year | Depreciable value | Depreciation rates | Depreciation | ||||||
| 1 | $25,000.00 | 20% | $5,000.00 | ||||||
| 2 | $25,000.00 | 32% | $8,000.00 | ||||||
| 3 | $25,000.00 | 19.20% | $4,800.00 | ||||||
| 4 | $25,000.00 | 11.52% | $2,880.00 | ||||||
| 5 | $25,000.00 | 11.52% | $2,880.00 | ||||||
| 6 | $25,000.00 | 5.76% | $1,440.00 | ||||||
| Calculation of additional depreciation and depreciation tax shield on additional depreciation | |||||||||
| Year | Depreciation - New Oven | Depreciation - Old Oven | Additional depreciation | Tax shield @ 34% | |||||
| 1 | $5,000.00 | $4,200.00 | $800.00 | $272.00 | |||||
| 2 | $8,000.00 | $4,200.00 | $3,800.00 | $1,292.00 | |||||
| 3 | $4,800.00 | $4,200.00 | $600.00 | $204.00 | |||||
| 4 | $2,880.00 | $4,200.00 | -$1,320.00 | -$448.80 | |||||
| 5 | $2,880.00 | $4,200.00 | -$1,320.00 | -$448.80 | |||||
| 6 | $1,440.00 | $1,440.00 | $489.60 | ||||||
| Calculation of after tax sale value of old oven | |||||||||
| Sale value of old oven | $18,500.00 | ||||||||
| Less : Book value | $21,000.00 | ||||||||
| Loss on sale | -$2,500.00 | ||||||||
| Tax benefit @ 34% of loss | $850.00 | ||||||||
| After tax sale value of old oven | $19,350.00 | ||||||||