EA6-E2 Complete a Depreciation Schedule for Main Street Theatre In this exercise, you will complete a depreciation schedule for Main Street Theatre. You will use the techniques from this chapter to enter fixed-asset data in an Excel table, calculate depre- ciation expense, and analyze the table data. A primary goal is to ensure that the depreciation schedule can be easily understood by the end user. Extend your skills 187 Use this information (provided as of 12/31/2015) to create a depreciation schedule as of 12/31/2016 for Main Street Theatre using appropriate headers and a table in which all perti- nent information is displayed. Fixed Asset Cost Date of Acquisition 1/1/2009 Salvage Value $2,000 Useful Life (years) Accumulated Depreciation $14,254.55 $18,000 1/1/2012 $5,000 $500 $4,200 Theatre Equipment Lobby Furniture Carousel Office Furniture 1/1/2002 1/1/2014 $10,000 $3,000 $1,000 $200 $8,473.68 $1,300 Main Street Theatre uses the sum of the years' digits method of depreciation. In addition to fixed assets shown, Main Street Theatre acquired new ticketing equipment on 1/1/2016. The ticketing equipment cost $8,000, has an estimated ten-year useful life, and has an estimated salvage value of $2,000. Create the table so there is a column for each item (note that some figures may appear different in your 12/31/2016 table than they do in the 12/31/2015 chart). Include columns for the annual depreciation expense and year-end book value. Use a function to calculate depreciation expense and structured references when calculating the year-end book value. Sort the table by cost in ascending order. Filter the table to display only assets for which the estimated useful life is less than twelve years. Last, use Quick Analysis to apply an icon set to the figures in the Annual Depreciation Expense column