EA6-E3 COMPLETE A DEPRECIATION SCHEDULE FOR WOODWORKERS CORP. In this exercise, you will complete a depreciation schedule for Woodworkers Corp. 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 4/30/2025) to create a depreciation schedule as of 4/30/2026 for Woodworkers Corp. using appropriate headers and a table in which all pertinent information is displayed: 3 G5 4 Fixed Asset Home Insert Draw Page Layout Formulas Tell me A % Conditional Formatting Format as Table Clipboard Font Alignment Number Cell Styles Comments Share Cells Editing Add-ins fx =DDB([@Cost],[@[Salvage Value]], [@[Useful Life (years)]], 15) A B C D E F G H 1 Woodworkers Corp 2 Depreciation Schedule Date of Acquisition 5 Manufactoring Equipme 6 Office Equipment Cost 5/1/18 $ 5/1/20 $ 7 Office Furniture 5/1/23 $ Fixed Asset Date of Acquisition Cost Salvage Value Useful Life (years) Accumulated Depreciation 8 Lobby Furniture 5/1/25 $ 9 Total Salvage Useful Life Value (years) 44,000 $ 8,000 24,000 $ 1,500 5,000 $ 500 15,000 $ 1,000 $ 88,000 $ 11,000 Accumulated Depreciation Year-End Depreciation Expense Book Value 20.00 $ 10.00 6.00 15.00 23,962 $ 1,007 $ 20,038 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! EA $ 270 $ 270 $ 14,730 12.75 #NUM! #NU #NUM! ABC 10 Office Equipment 5/1/2020 $24,000 $1,500 10 $16,135.68 11 Depreciation Expense 12 Manufacturing 13 5/1/2018 $44,000 $8,000 20 $22,954.94 Equipment 14 Lobby Furniture 15 Office Furniture 5/1/2023 $5,000 $500 6 $2,777.78 16 Office Furniture 17 18 Office Equipment Woodworkers Corp. uses the double-declining balance method of depreciation. In addition to the fixed assets shown, Woodworkers Corp. acquired new lobby furniture on 5/1/2025. The lobby furniture cost $15,000, has an estimated fifteen-year useful life, and has an estimated salvage value of $1,000. Create the table so there is a column for each item (note that some figures may appear different in your 4/30/2026 table than they do in the 4/30/2025 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 accumulated depreciation in ascending order. Filter the table to display only assets for which the date of acquisition is after 1/1/2019. Last, use Quick Analysis to create a bar chart displaying the annual depreciation for each of the displayed fixed assets. 29 30 31 32 33 34 35 19 20 Manufactoring Equipment 21 $ 22 23 $200 $400 $600 $800 $1,000 $1,200 Depreciation Expense 24 25 26 27 28