Question

EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year. Fixed Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $700 10 $6,750 1/1/2009 $8,400 Garage Equipment $11,000 $200 Computers 1/1/2013 $4,000 $0 $2,400 Furniture Resellers also acquired lobby furniture on 1/1/2016. The lobby furniture had a cost of $2,000, an estimated salvage value of $400, and an estimated useful life of eight years. 1. Open a Blank Workbook and save the file in your Chapter 06 folder as: EA6-A2-Depreciation-[YourName] 2. Enter appropriate bank reconciliation headers in the range A1:A2; apply italic formatting. 3. Enter the fixed-asset data in the range A4:F7; for the accumulated depreciation, enter the title but not the dollar amounts.

Answer 1

Depreciation schedule for Furniture Resellers as of le/8, 1/2016 Assets late cost I Depreciation I Net, Block Land purchased closing opening purchase closing openingal (2) 3)-6) Machinery 111|2007 8.200 FI 8,200 6750 - 750 7,500 1700 Garrage/111/2009 11000 11000/8,400 7120019,600 1,400 Equipment wters 11120134.000 4000 2400 800 3200 800 compute iturel 11/2016 - 2000 2000 - 200 200 1800 Depreciation . cost of Assets - salvage P.a. = 7 useful Life cyears