In this exercise, you will complete a depreciation schedule for RYT Inc. 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 9/30/2015) to create the depreciation schedule as of 9/30/2016 for RYT Inc. using appropriate headers and a table in which all pertinent information is displayed.

Fixed Asset	Date of Acquisition	Cost	Salvage Value	Useful Life (years)	Accumulated Depreciation
Office Furniture	10/1/2014	$2,800	$400	8	$ 1,225.00
Field Equipment	10/1/2011	$25,000	$1,000	12	$14.953.06
Truck	10/1/2010	$16,500	$1,500	15	$ 9,508.08

RYT Inc. uses the double declining balance* method of depreciation. In addition to the fixed assets shown, RYT Inc. acquired a new automobile on 10/1/2015. It cost $13,000, has an estimated twelve-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 9/30/2016 table than they do in the 9/30/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 accumulated depreciation in ascending order. Filter the table to display only assets for which the cost is greater than $4,000.