Applying Excel - Basic Excel Skills and Depreciation: Exercise (Part 2 of 2) Now change the Cost, Life of the Asset, and Salvage Value for all of the assets listed in the table in your worksheet to match the information below: Asset No. 1-801 1-002 1-003 1-804 1-005 1-006 1-007 Fixed Asset Name Desktop computer Laptop - 13" Laptop - 15" Tablet 4-person Workstation Office chairs (set of 4) 70 Flat Screen TV Straight-Line Double-Declining Straight-Line Double-Declining Total Depreciation Year 1 $ Be sure to also check the Cost in both of your Depreciation Method tables in your worksheet so that it matches the updated information. 1,780 Total Accumulated Depreciation Year 1 $ Required: 2a. Complete the chart below that shows comparisons of the two depreciation methods. (Round your answers to the nearest whole dollar.) Cost $1,600 $1,100 $2,500 $ 500 Intel Noat Rank $3,000 $1,000 $1,750 $ Life of Asset Salvage Value 5 $ 0 5 1,780 $ Total Depreciation Total Depreciation Year 2 Year 3 1,780 Total Accumulated Depreciation Year 2 5 5 10 10 5 Total Not Book

Applying Excel - Basic Excel Skills and Depreciation: Exercise (Part 2 of 2) Now change the Cost, Life of the Asset, and Salvage Value for all of the assets listed in the table in your workshect he match the informetion below: Be sure to also check the Cost in both of your Depreciation Method tables in your worksheet so that it matches the updated informotion. Required: 2a. Complete the chart below that shows comparisons of the fwo depreciation methods. (Round your answers to the nearest whole dollar.)