B6 Excel for Accounting Chapter 6: Depreciation Schedule Extend Your Skills BAG.4 Complete a Depreciation Schedule for Bill's Babe In this exercise, you will complete a depreciation schedule for Bill's Bakery. You will use the techniques from this chapter to enter fixed-asset data in an Excel table, calculate depreciation expense, and analyze the table data. A primary goal is to ensure that the depreciation schedule can be easily understood by the end user. Use this information (provided as of 8/31/2015) to create the depreciation schedule as of 8/31/2016 for Bill's Bakery using appropriate headers and a table in which all pertinent infor mation is displayed. Fixed Asset Cost Date of Acquisition 9/1/2013 Salvage Value $200 Useful Life (years) Accumulated Depreciation $1,000 Office Furniture $3,700 Oven 10 3/1/2012 9/1/2014 $12,400 $24,000 $2,400 $0 $3,500 $2,000 Equipment Balls Bakery uses the straight-line method of depreciation. In addition to the fixed assets shown, Bakery acquired a new refrigerator on 3/1/2016. It cost $7,700, has an estimated seven year useful life, and has an estimated salvage value of $700. create the table so there is a column for each item (note that some figures may appear one in your 8/31/2016 table than they do in the 8/31/2013 e than they do in the 8/31/2015 chart). Include columns for the annual and year-end book value. Use a function to calculate depreciation expense, rences when calculating the year-end book value. Sort the table by deprecia, tion expense in descending order. Filter the table to display only assets for w le table to display only assets for which the estimated cater than $0. Last, use Quick Analysis to apply data bars to the figures in the depreciation expense and year-end book value and structured references when calculating the year- salvage value is greater than $0. Last, use Quick Accumulated Depreciation column. EA6-E2 Complete