How should this be completed in Excel ?

Suomen 57 10. Start Protected View Home File Page Layout Data Review View O PROTECTED VIEW Be carefulfiles from the Internet can contains. Unless you need to edit alerto stay in Protected View Enable Editing A1 Using the straight-line method of depreciation, calculate the depreciation expense, accumulated depreciation bala H Using the straight-line method of depreciation, calculate the depreciation expense, accumulated depreciation balance, and book value for each of the four years of the van's useful life. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 2 Instruction tab you will be marked wrong.) Depreciation Accumulated expense depreciation 4 Book value 5 6 7 3 Year Start 2017 2018 2019 2000 10 11 12 13 15 16 17 19 220 10/25/21 Home Page Layout Formulas Date Review View O PROTECTED VIEW Beches from the emet can contain views. Unless you need to edit alerto stay in Protected View Fredding M 4 years A1 X Plant Assets, Natural Resources, & Intangibles H 1 Plar Amets, Natural Resources, & Intangibles 2 Compute depreciation using straight-line method with residual value 3 4 The following is given for Favorite purchase of a used van for use in its business on January 1, 2017 5 6 Van's purchase price $ 17.000 7 Van's residual value $ 1,400 8 Van's useful life 9 Expected miles in 2017 16,000 10 Expected miles in 2018 19,000 11 Expected miles in 2019 17,000 12 Expected miles in 2020 48,000 13 Total expected miles 100,000 14 15 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 18 Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from 17 the Instruction tab you will be marked wrong. 18 19 Requirement Using the straight-line method of depreciation, calculate the depreciation expense, accumulated depreciation balance, and 20 book value for each of the four years of the van's useful life. 21 Enter all amounts as positive values. Do not use a minus signor parentheses for any values to be subtracted. 22 100 23 INSTRUCTIONS ENTERANSWERS 8 ES R