PLEASE SHOW ALL THE WORK IN EXCEL VERSION. PASTE AND COPY. SHOW HOW EXACTLY THE TABLE SHOULD LOOK!!!! THANKS

Reinforce Your Skills EA6-R1 Complete a Depreciation Schedule for Linen Wholesalers In this exercise, you will create a depreciation schedule for Linen Wholesalers using an Excel table. You will then sort, filter, and analyze the data. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year. Fixed Asset Date of Acquisition 1/1/2015 1/1/2010 1/1/2012 cost Salvage Value Useful Life years) Office Tables Furniture Warehouse Machinery Accumulated Depreciation $0 $3,000 $4,000 $1,400 $200 $6,000 $0 $17,500 $1,500 12 16 Linen Wholesalers also acquired office equipment on 1/1/2016. The office equipment had a cost of $4,200, an estimated salvage value of $700, and an estimated useful life of seven years. 1. Open a Blank Workbook and save the file in your Chapter 06 folder as: EA6-R1-Depreciation-[YourName] 2. Type Linen Wholesalers in cell A1 and Depreciation Schedule in cell A2. 3. Enter the fixed asset data in the range A4:F7. Include the Accumulated Depreciation header but exclude its amounts. Also exclude the newly acquired asset for now