A B D H Account Number Description Date Placed in Service Estimated Useful Life Acquisition Cost Salvage Value Net Book
Posted: Sun Apr 17, 2022 7:00 pm
the formula and ranges)
• Calculate beginning accumulated
depreciation
• Calculate current year’s depreciation
expense
• Calculated ending accumulated
depreciation
• Calculated net book value at the end of
period (Net book value cannot be less than the
salvage value).
• Add the Total Row to the Depreciation table, show the totals for
acquisition cost,
salvage value, beginning depreciation, current depreciation, ending
accumulated
depreciation, and net book value.
A B D H Account Number Description Date Placed in Service Estimated Useful Life Acquisition Cost Salvage Value Net Book Value Beginning Accumulated Depreciation Current Period Depreciation Ending Accumulated Depreciation 100,00 280.00 150.00 100.00 300.00 11050 11001 11001 11300 11001 11500 11300 11050 11300 11500 11100 11200 11500 Chair Desk Desk Monitor Desk Software Monitor Chair Monitor Software Laptop Workstation Software 2/12/14 10/8/15 6/5/17 2/24/18 4/8/18 7/5/18 7/30/18 6/23/19 11/15/19 1/30/20 5/12/20 3/15/21 6/1/21 6.00 10.00 10.00 4.00 10.00 3.00 4.00 6.00 4.00 3.00 5.00 8.00 3.00 1,000.00 2,000.00 650.00 900.00 1,100.00 900.00 1,200.00 1,300.00 800.00 1,000.00 2,000.00 5,000.00 2,100.00 200.00 100.00 80.00 500.00 600.00 Cross-footing test --> Depreciation by Asset Type: Asset Name Net Book Value Desk Laptop Workstation Chair Software Monitor Total 51 Estimated Useful Life 10.00 5.00 8.00 6.00 3.00 4.00 <---- Cross-footing test