Excel Practice Exercise 7 Depreciation Schedule (Sum of Year's Digits) Data: Asset # Asset name: Date acquired: Cost: Depreciation method: Salvage (residual) value: Estimated useful life (years): 222 Equipment 1/1/14 $33,000 Sum of the year's digits $3,000 5 Output: (1) Set up an Excel worksheet and include the data above in the Excel worksheet. (2) Set up a Depreciation Schedule as shown below: Year Depreciation Schedule-Sum of the year's digits Current Period End of Period Remaining Years Remaining Annual Accumulated Ending Book Years/Sum of Depreciation Depreciation Value the Years 2014 2015 2016 2017 2018