You will use the attached worksheet to complete a depreciation schedule. You will need to enter the fixed-asset data below, calculate depreciation expense, and analyze the table data. (Chapter 6) The information provided is as of 1/31/2019, create the depreciation schedule as of January 31, 2020.

Fixed Asset	Date of Acquisition	Cost	Salvage Value	Useful Life (years)	Accumulated Depreciation
Automobile	1/31/2014	$32,000	$2,000	10	$15,000
Store Fixtures	1/31/2018	$11,300	$1,300	5	$ 2,000
Office Equipment	1/31/2015	$ 6,900	$ 900	6	$ 4,000

CraftWorld uses the straight-line method of depreciation. In addition to the fixed assets shown, the company acquired new furniture on 1/31/2019. It cost $3,100, has an estimated four-year useful life, and an estimated salvage value of $300.

Enter the data from the table above into the template (note that some figures may appear different in your 1/31/2020 table than in the 1/31/2019 chart). Select the range A4:H7 and format it as a table using Orange, Table Style Medium 3. Use Depreciation_Schedule2020 as the table name. Use the appropriate function and structured references to calculate depreciation expense. Use structured references when calculating the accumulated depreciation and year-end book value. All dollar amounts should be formatted using the Accounting Number format with no decimals.

Sort the table by accumulated depreciation in ascending order and include a total row to sum each column (except for Useful Life; display the average for that column). Filter the table to display only assets for which the cost is greater than $5,000. Last, use Quick Analysis to apply Blue Gradient data bars to the figures in the Salvage Value column. (Hint: Chapter 4.)

Create a 3-D pie chart showing the Year-End Book Values of the Fixed Assets and title the chart, CraftWorld Year-End Book Values 2020.