Please answer using formulas and Cell References

IZ 13 14 Given Information:* 15 Answers: (a) Straight-Line Depreciation Year Expense $96,000 $24,000 Accumulated Depreciation Book Value 19 10,000 Original Cost Estimated Residual Value Estimated Useful Years Estimated Units Actual Units: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 3 Adjusting Entry Depreciation Expense Accumulated Depreciation 21 22 23 24 25 26 27 28 29 1,000 1,800 2,200 2,400 2,000 1,600 11,000 (b) Double-Declining-Balance Accumulated Expense Depreciation Book Value Year Depreciation each year Year 3 Adjusting Entry Depreciation Expense Accumulated Depreciation 36 38 39 (c) Activity-Based Depreciation Year Expense Accumulated Depreciation Book Value 43 45 46 47 Year 3 Adjusting Entry Depreciation Expense Accumulated Depreciation 49