In: Finance
Strong Metals Inc. purchased a new stamping machine at the beginning of the year at a cost of $1,330,000. The estimated residual value was $70,000. Assume that the estimated useful life was five years and the estimated productive life of the machine was 300,000 units. Actual annual production was as follows:
Year | Units |
1 | 70,000 |
2 | 67,000 |
3 | 50,000 |
4 | 73,000 |
5 | 40,000 |
Required:
1. Complete a separate depreciation schedule for each of the alternative methods.
a. Straight-line.
b. Units-of-production.
c. Double-declining-balance.
a. | Year end | Cost | Depreciation expense | Accumulated Depreciation expense | Book Value |
1 | $ 13,30,000.00 | $ 2,52,000.00 | $ 2,52,000.00 | $ 10,78,000.00 | |
2 | $ 13,30,000.00 | $ 2,52,000.00 | $ 5,04,000.00 | $ 8,26,000.00 | |
3 | $ 13,30,000.00 | $ 2,52,000.00 | $ 7,56,000.00 | $ 5,74,000.00 | |
4 | $ 13,30,000.00 | $ 2,52,000.00 | $ 10,08,000.00 | $ 3,22,000.00 | |
5 | $ 13,30,000.00 | $ 2,52,000.00 | $ 12,60,000.00 | $ 70,000.00 | |
Working: | |||||
Straight line depreciation | = | (Cost - Salvage value)/Useful Life | |||
= | (1330000-70000)/5 | ||||
= | $ 2,52,000 | ||||
b. | Year end | Cost | Depreciation expense | Accumulated Depreciation expense | Book Value |
1 | $ 13,30,000.00 | $ 2,94,000.00 | $ 2,94,000.00 | $ 10,36,000.00 | |
2 | $ 13,30,000.00 | $ 2,81,400.00 | $ 5,75,400.00 | $ 7,54,600.00 | |
3 | $ 13,30,000.00 | $ 2,10,000.00 | $ 7,85,400.00 | $ 5,44,600.00 | |
4 | $ 13,30,000.00 | $ 3,06,600.00 | $ 10,92,000.00 | $ 2,38,000.00 | |
5 | $ 13,30,000.00 | $ 1,68,000.00 | $ 12,60,000.00 | $ 70,000.00 | |
Working: | |||||
Depreciation rate per unit | = | (Cost - Salvage value)/Useful Life | |||
= | (1330000-70000)/300000 | ||||
= | $ 4.20 | per unit | |||
Year | Units produced | Depreciation rate per unit | Depreciation expense | ||
1 | 70,000 | $ 4.20 | $ 2,94,000.00 | ||
2 | 67,000 | $ 4.20 | $ 2,81,400.00 | ||
3 | 50,000 | $ 4.20 | $ 2,10,000.00 | ||
4 | 73,000 | $ 4.20 | $ 3,06,600.00 | ||
5 | 40,000 | $ 4.20 | $ 1,68,000.00 | ||
c. | Year | Beginning book value | Depreciation expense | Accumulated Depreciation expense | Ending Book Value |
a | b=a*40% | c | d=a-b | ||
1 | $ 13,30,000.00 | $ 5,32,000.00 | $ 5,32,000.00 | $ 7,98,000.00 | |
2 | $ 7,98,000.00 | $ 3,19,200.00 | $ 8,51,200.00 | $ 4,78,800.00 | |
3 | $ 4,78,800.00 | $ 1,91,520.00 | $ 10,42,720.00 | $ 2,87,280.00 | |
4 | $ 2,87,280.00 | $ 1,14,912.00 | $ 11,57,632.00 | $ 1,72,368.00 | |
5 | $ 1,72,368.00 | $ 68,947.20 | $ 12,26,579.20 | $ 1,03,420.80 | |
Working; | |||||
Straight line depreciation rate | = | 1/5 | |||
= | 20% | ||||
Double declining rate | = | 40% |