Assumption: All assets are depreciated using the straight-line method. All assets receive a full years depreciation in the acquisition year (even if owned for only one day in the acquisition year).

What are the excel formulas used to calculate: (Please specify the formula and ranges)

Calculate beginning accumulated depreciation Calculate current years 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