In: Finance
Mom’s Cookies, Inc., is considering the purchase of a new cookie oven. The original cost of the old oven was $35,000; it is now five years old, and it has a current market value of $15,000.00. 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 $17,500 and an annual depreciation expense of $3,500. 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 $27,000 and whose estimated salvage value is zero. Expected before-tax cash savings from the new oven are $4,200 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 30 percent tax rate. |
What will the cash flows for this project be? |
re
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |||||||
FCF | $ | $ | $ | $ | $ | $ | $ | |||||||
rev: 04_25_2018_QC_CS-125254
Calculation of cash flows of project | ||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |
Cost of new oven | -$27,000.00 | |||||||
After tax salvage value of old oven | $15,750.00 | |||||||
Cash savings | $4,200.00 | $4,200.00 | $4,200.00 | $4,200.00 | $4,200.00 | $4,200.00 | ||
Tax @ 30% on cash savings | -$1,260.00 | -$1,260.00 | -$1,260.00 | -$1,260.00 | -$1,260.00 | -$1,260.00 | ||
Additional depreciation tax shield | $570.00 | $1,542.00 | $505.20 | -$116.88 | -$116.88 | $466.56 | ||
Cash flows | -$11,250.00 | $3,510.00 | $4,482.00 | $3,445.20 | $2,823.12 | $2,823.12 | $3,406.56 | |
Working | ||||||||
Calculation of depreciation per year on old oven | ||||||||
Depreciation per year = [Cost -salvage value]/useful life = $35000 / 10 years = $3500 | ||||||||
Calculation of depreciation on new oven using 5 year MACRS rates | ||||||||
Year | Cost | Depreciation rates | Depreciation | |||||
1 | 27000 | 20% | 5400 | |||||
2 | 27000 | 32% | 8640 | |||||
3 | 27000 | 19.20% | 5184 | |||||
4 | 27000 | 11.52% | 3110.4 | |||||
5 | 27000 | 11.52% | 3110.4 | |||||
6 | 27000 | 5.76% | 1555.2 | |||||
Calculation of additional depreciation and tax shield | ||||||||
Year | Old Oven | New Oven | Additional Depreciation | Tax shield @ 30% | ||||
1 | 3500 | 5400 | 1900 | 570 | ||||
2 | 3500 | 8640 | 5140 | 1542 | ||||
3 | 3500 | 5184 | 1684 | 505.2 | ||||
4 | 3500 | 3110.4 | -389.6 | -116.88 | ||||
5 | 3500 | 3110.4 | -389.6 | -116.88 | ||||
6 | 1555.2 | 1555.2 | 466.56 | |||||
After tax salvage value of old oven | ||||||||
Sale value of old oven | 15000 | |||||||
Less : Book value of old oven | 17500 | |||||||
Loss on sale | 2500 | |||||||
Tax shield @ 30% on loss | 750 | |||||||
After tax salvage value of old oven | 15750 | |||||||