Question: In this Applying Excel exercise you will practice using cell referencing, the Min function, and formulas to calculate depreciation expense using the Straight-Line, Double-Declining-Balance and
In this Applying Excel exercise you will practice using cell referencing, the Min function, and formulas to calculate depreciation expense using the Straight-Line, Double-Declining-Balance and Activity-Based methods. You will also be introduced to the 'Chart' tools within Excel. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video.Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Original Cost $ 115,200 Estimated Residual Value $ 28,800 Estimated Useful Years 6 Estimated Units 26,000 Actual Units: Year 1 2,600 Year 2 4,680 Year 3 5,720 Year 4 6,240 Year 5 5,200 Year 6 4,160 28,600 Required: Use your spreadsheet to recalculate Depreciation Expense, Accumulated Depreciation, and the Book Value for Year 6 under each method. Note your revised values below. Prepare the journal entry to record depreciation in Year 6 for each of the methods. What general conclusion can you draw regarding the comparison of the three methods
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
