Try another version of this question
Looking to expand its operation, Nisha's Canning Co. invested in new testing equipment for its operation on January 3, 2017 , for a total purchase price of $38,000
They expected the equipment would be able to test cans for 5 years, or a total of 6,620 tests. Nisha's Canning Co. estimated the residual value of the equipment to be $5,600
Nisha's Canning Co. used the equipment as follows:
Year 1 430 tests
Year 2 1,960 tests
Year 3 2,270 tests
Year 4 1,150 tests
Year 5 810 tests
Prepare a schedule of depreciation expense, accumulated depreciation, and book value per year for the equipment under the three depreciation methods.
Note: Input rates as the decimal value.
Depreciation for the Year | ||||||
---|---|---|---|---|---|---|
Date | Asset Cost | Depreciable Cost | Depreciation Rate | Depreciation Expense | Accumulated Depreciation | Book Value |
01/03/17 | $38,000 | $38,000 | ||||
12/31/17 | ||||||
12/31/18 | ||||||
12/31/19 | ||||||
12/31/20 | ||||||
12/31/21 |
Depreciation for the Year | ||||||
---|---|---|---|---|---|---|
Date | Asset Cost | Depreciation per Unit | Number of Units | Depreciation Expense | Accumulated Depreciation | Book Value |
01/03/17 | $38,000 | $38,000 | ||||
12/31/17 | ||||||
12/31/18 | ||||||
12/31/19 | ||||||
12/31/20 | ||||||
12/31/21 |
Depreciation for the Year | ||||||
---|---|---|---|---|---|---|
Date | Asset Cost | Book Value | DDB Rate | Depreciation Expense | Accumulated Depreciation | Book Value |
01/03/17 | $38,000 | $38,000 | ||||
12/31/17 | ||||||
12/31/18 | ||||||
12/31/19 | ||||||
12/31/20 | ||||||
12/31/21 |
Depreciation for the Year | ||||||
---|---|---|---|---|---|---|
Date | Asset Cost | Depreciable Cost | Depreciation Rate | Depreciation Expense | Accumulated Depreciation | Book Value |
01/03/17 | $38,000 | $38,000 | ||||
12/31/17 | 32,400.00 | 0.20 | 6,480.00 | 6,480.00 | 31,520.00 | |
12/31/18 | 32,400.00 | 0.20 | 6,480.00 | 12,960.00 | 25,040.00 | |
12/31/19 | 32,400.00 | 0.20 | 6,480.00 | 19,440.00 | 18,560.00 | |
12/31/20 | 32,400.00 | 0.20 | 6,480.00 | 25,920.00 | 12,080.00 | |
12/31/21 | 32,400.00 | 0.20 | 6,480.00 | 32,400.00 | 5,600.00 |
Depreciation for the Year | ||||||
---|---|---|---|---|---|---|
Date | Asset Cost | Depreciation per Unit | Number of Units | Depreciation Expense | Accumulated Depreciation | Book Value |
01/03/17 | $38,000 | $38,000 | ||||
12/31/17 | 4.89 | 430.00 | 2,104.53 | 2,104.53 | 35,895.47 | |
12/31/18 | 4.89 | 1,960.00 | 9,592.75 | 11,697.28 | 26,302.72 | |
12/31/19 | 4.89 | 2,270.00 | 11,109.97 | 22,807.25 | 15,192.75 | |
12/31/20 | 4.89 | 1,150.00 | 5,628.40 | 28,435.65 | 9,564.35 | |
12/31/21 | 4.89 | 810.00 | 3,964.35 | 32,400.00 | 5,600.00 |
Depreciation for the Year | ||||||
---|---|---|---|---|---|---|
Date | Asset Cost | Book Value | DDB Rate | Depreciation Expense | Accumulated Depreciation | Book Value |
01/03/17 | $38,000 | $38,000 | ||||
12/31/17 | 38,000.00 | 0.40 | 15,200.00 | 15,200.00 | 22,800.00 | |
12/31/18 | 22,800.00 | 0.40 | 9,120.00 | 24,320.00 | 13,680.00 | |
12/31/19 | 13,680.00 | 0.40 | 5,472.00 | 29,792.00 | 8,208.00 | |
12/31/20 | 8,208.00 | 2,608.00 | 32,400.00 | 5,600.00 | ||
12/31/21 |