Chapter 4 Assignments 1 Modify What SUP's Straight-Line Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_SLN_student_name.xls worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The asset to be depreciated is a forge purchased on January 1, 2018, for $85,000. It has an estimated salvage value of $4,000 and is to be depreciated over 3 years using the straight-line method. Update the summary worksheet to include information on this new asset. (Be careful to note the date this asset was acquired.) Save the file as ch4-02_SLN_student_name (replacing student_name with your name). Print the newly completed worksheet for Asset 1003 and the modified Summary worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. ch4-01 Read-Only- Excel Page Layout Formudas DataRevieHepTell me what you want to do ome A Cut r me Conditional format as Format Painte 1 What SUT, Inc. Equipmest Depreciation Summary Dabe Deprec. 2017 A.2018 Acc. 2019 Acc20202020 Acc. 202 2021 Ace. S0 5050500%0 10 Total DOLL Book Antiqua-112-. K A. | | General . tp wrap Text Paste 6 Copy Format Painter Clipboard G11 Asset 5 Date acquired 6 Cost 7 Depreciation method 8 Salvage value 9 Estimated useful life 10 Display Racks 1/1/2017 S 25,000.00 S/L Year 2017 2018 2019 Expense Depreciation 12 13 15 2021 18 27 28 30 Summary Asset 1001 O Type here to search