In: Finance
The Bigbee Bottling Company is contemplating the replacement of one of its bottling machines with a newer and more efficient one. The old machine has a book value of $625,000 and a remaining useful life of 5 years. The firm does not expect to realize any return from scrapping the old machine in 5 years, but it can sell it now to another firm in the industry for $265,000. The old machine is being depreciated by $125,000 per year, using the straight-line method.
The new machine has a purchase price of $1,125,000, an estimated useful life and MACRS class life of 5 years, and an estimated salvage value of $125,000. The applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. It is expected to economize on electric power usage, labor, and repair costs, as well as to reduce the number of defective bottles. In total, an annual savings of $205,000 will be realized if the new machine is installed. The company's marginal tax rate is 35%, and it has a 12% WACC.
| Year | Depreciation Allowance, New | Depreciation Allowance, Old | Change in Depreciation | 
| 1 | $ | $ | $ | 
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | 
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 
| $ | $ | $ | $ | $ | 
please help! Thank you!
a)
Gain /(loss) on sale of old machine =Sale value -book value
= 265000 - 625000
= - 360000
Tax saving due to loss= -360000* 35%= -126000
After tax cash flow from sale of old machine = sale value - Tax saving
= 265000 - (- 126000)
= 265000 + 126000
= 391000
| Purchase cost of new machine | -1125000 | 
| After tax cash flow from sale of old machine | 391000 | 
| Initial outlay | - 734000 | 
b)
| Year | Depreciation Allowance, New [A] | Depreciation Allowance, Old [B] | Change in Depreciation[A-B] | 
| 1 | 1125000*32%= 360000 | 125000 | 235000 | 
| 2 | 1125000*19%= 213750 | 125000 | 88750 | 
| 3 | 1125000*12%= 135000 | 125000 | 10000 | 
| 4 | 1125000*11%= 123750 | 125000 | -1250 | 
| 5 | 1125000*6%= 67500 | 125000 | -57500 | 
| Total | 900000 | 625000 | 
c)
| 1 | 2 | 3 | 4 | 5 | |
| Annual saving | 205000 | 205000 | 205000 | 205000 | 205000 | 
| less:Incremental depreciation | -235000 | -88750 | -10000 | 1250 | 57500 | 
| Income before tax | -30000 | 116250 | 195000 | 206250 | 262500 | 
| less:Tax [Income before tax *35%] | 10500 | -40687.5 | -68250 | -72187.5 | 91875 | 
| Net Income | -19500 | 75562.5 | 126750 | 134062.5 | 170625 | 
| Add:depreciation (being non cash) | 235000 | 88750 | 10000 | -1250 | -57500 | 
| After tax sale value on old machine | 160000 | ||||
| Incremental cash flow | 215500 | 164313 | 136750 | 132813 | 273125 | 
Working :
Book value of new machine at end of year 5 =cost -accumulated depreciation
= 1125000 -900000
= 225000
Loss on sale = 125000 -225000 = -100000
Tax saving due to loss on sale = -100000*35%=-35000
After tax sale value =sale value -tax saving
= 125000 - (-35000)
= 125000 +35000
= 160000