86 Excel for Accounting Chapter 6: Depreciation Schedule Extend Your Skills EA6-E1 Complete a Depreciation Schedule for Bill's Bakery 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 $3,700 Office Furniture Oven Equipment 10 3/1/2012 9/1/2014 $12,400 $24,000 $2,400 $0 $3,500 $2,000 12 Bill's Bakery uses the straight-line method of depreciation. In addition to the fixed assets shown, Bill's 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 different in your 8/31/2016 table than they do in the 8/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 deprecia- tion expense in descending order. Filter the table to display only assets for which the estimated salvage value is greater than $0. Last, use Quick Analysis to apply data bars to the figures in the Accumulated Depreciation column