The Excel file associated with this exercise includes data for Delta Air Lines, Inc., as reported in its Form $10-$K reports over a $10-$year

period. The percent depreciated of depreciable fixed assets measures the age of the assets compared to useful life. A company that has

made substantial investments in new fixed assets will have a lower ratio compared to a company with fixed assets nearing the end of

their useful life. In this exercise, we review the trend of percent depreciated of gross property and equipment for Delta Airlines over a $10-$

year period.

Required

Download the following Excel file: Delta Air Lines, Inc.

Compute the ratio of accumulated depreciation to gross property and equipment for each year. Assume all assets are depreciable.

Prepare the following three charts in Excel.

Chart $1$: A bar chart showing accumulated depreciation and gross property and equipment per year over the $10-$year period.

Chart $2$: A line chart showing property and equipment additions over the $10-$year period, with the earliest year on the left hand

side. Hint: To reverse the order of the years, right$-$click inside the horizontal axis. A Format Axis sidebar will appear. Open the bar chart

icon tab. Click Categories in reverse order under Axis options.

Chart $3$: A line chart showing the ratio of accumulated depreciation to gross property and equipment over the $10-$year period.

Answer the following questions based on your visualizations.

a$.$ In Chart $1,$ in what year$($s$)$ was the trend of increasing values not evident in the chart?

b$.$ In Chart $2,$ what year$($s$)$ showed a drop in property and equipment additions?

c$.$ In Chart $2,$ what year showed the most significant change?

Year:

d$.$ Select the best answer that describes the trends shown in Chart $3.$

e$.$ Select the best answer that is the likely cause of the increase shown in Year $10$ in Chart $3.$