AutoSave OFF BE SU Depreciation Assignment - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me View X Calibri (Body) V 11 AA = = ab Wrap Text Currency Update Apple ID Settings Some account services will not be available until you sign in again. U verele Sort & Find & Format v Filter Select Paste A + 3 Merge & Center $ % ) * .00 .00 0 Ideas Conditional Format Cell Formatting as Table Styles H3 fx A B D E F G H 1 K N o P O R S T 1 2020 L L M 2018 Annual Book Depreciation Value 2017 Annual Book Depreciation Value Purchase date Item 2016 Annual Book Depreciation Value Salvage Straight Value line rate Depreciation method Cost 2019 Annual Book Depreciation Value Useful Life Annual Book Depreciation Value 2 Jan 1 2017 6 3 4 Truck Double declining balance Sold 6/1/2020 for $21,000 (DDB) Combine 150% declining balance Tractor DDB Planter 150% declining balance Pickup DDB July 15 2016 May 1 2016 March 1 2016 Sept 1 2017 5 7 10 7 $42,780 $8,500 16.67% $420,000 $187,000 14.29% $102,500 $55,000 10.00% $32,553 $7,500 14.29% $45,195 $12,100 14.29% Total Annual Depreciation 6 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 72 Question 1 Question 2 Question 3 + 0 + 100%