Microsoft Excel LibreOffice Calc

Delta Air Lines Inc. (DAL)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

Delta Air Lines Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Net fixed asset turnover 1.50 1.52 1.54 1.57 1.54 1.53 1.55 1.55 1.56 1.57 1.59 1.63 1.65 1.68 1.73 1.77 1.81 1.82 1.85 1.84 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 1.26 1.27 1.28 1.29 1.54 1.53 1.55 1.55 1.56 1.57 1.59 1.63 1.65 1.68 1.73 1.77 1.81 1.82 1.85 1.84 — — —
Total asset turnover 0.73 0.73 0.73 0.74 0.80 0.77 0.78 0.77 0.78 0.77 0.77 0.77 0.78 0.78 0.76 0.77 0.76 0.78 0.76 0.75 — — —
Equity turnover 3.07 3.27 3.48 3.25 3.21 3.35 3.35 2.97 2.89 2.96 3.05 3.23 3.17 3.41 3.61 3.75 3.95 4.28 4.51 4.58 — — —

Based on: 10-Q (filing date: 2019-10-10), 10-Q (filing date: 2019-07-11), 10-Q (filing date: 2019-04-10), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-11), 10-Q (filing date: 2018-07-12), 10-Q (filing date: 2018-04-12), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-11), 10-Q (filing date: 2017-07-13), 10-Q (filing date: 2017-04-12), 10-K (filing date: 2017-02-13), 10-Q (filing date: 2016-10-13), 10-Q (filing date: 2016-07-15), 10-Q (filing date: 2016-04-14), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-14), 10-Q (filing date: 2015-07-15), 10-Q (filing date: 2015-04-15), 10-K (filing date: 2015-02-11), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-24).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Delta Air Lines Inc.’s net fixed asset turnover ratio deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Delta Air Lines Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Delta Air Lines Inc.’s total asset turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Delta Air Lines Inc.’s equity turnover ratio deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Net Fixed Asset Turnover

Delta Air Lines Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Operating revenue 12,560  12,536  10,472  10,742  11,953  11,775  9,968  10,245  11,060  10,791  9,148  9,458  10,483  10,447  9,251  9,502  11,107  10,707  9,388  9,647  11,178  10,621  8,916 
Property and equipment, net of accumulated depreciation and amortization 30,796  30,165  29,139  28,335  28,565  28,124  27,096  26,563  25,900  25,367  24,817  24,375  24,105  23,975  23,422  23,039  22,608  22,480  22,023  21,929  21,722  22,048  21,972 
Long-term Activity Ratio
Net fixed asset turnover1 1.50 1.52 1.54 1.57 1.54 1.53 1.55 1.55 1.56 1.57 1.59 1.63 1.65 1.68 1.73 1.77 1.81 1.82 1.85 1.84 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Booking Holdings Inc. 21.16 20.60 20.77 22.14 21.96 22.34 23.02 26.41 26.72 27.01 28.89 30.96 30.59 30.60 31.79 33.57 35.25 35.75 40.22 42.43 — — —
Marriott International Inc. 10.66 10.62 10.59 10.61 10.85 11.21 12.47 12.77 11.87 9.87 8.94 7.31 6.36 14.16 14.15 14.08 14.56 14.41 9.69 9.45 7.72 8.01 8.20
McDonald’s Corp. 0.90 0.89 0.90 0.92 0.94 0.97 0.98 1.02 1.07 1.11 1.15 1.16 1.08 1.10 1.08 1.10 1.10 1.10 1.15 1.12 — — —
Starbucks Corp. 4.21 4.16 4.19 4.17 4.24 4.21 4.23 4.55 4.77 4.81 4.84 4.70 4.71 4.75 4.79 4.69 4.63 4.54 4.45 4.67 — — —

Based on: 10-Q (filing date: 2019-10-10), 10-Q (filing date: 2019-07-11), 10-Q (filing date: 2019-04-10), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-11), 10-Q (filing date: 2018-07-12), 10-Q (filing date: 2018-04-12), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-11), 10-Q (filing date: 2017-07-13), 10-Q (filing date: 2017-04-12), 10-K (filing date: 2017-02-13), 10-Q (filing date: 2016-10-13), 10-Q (filing date: 2016-07-15), 10-Q (filing date: 2016-04-14), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-14), 10-Q (filing date: 2015-07-15), 10-Q (filing date: 2015-04-15), 10-K (filing date: 2015-02-11), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-24).

1 Q3 2019 Calculation
Net fixed asset turnover = (Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019 + Operating revenueQ4 2018) ÷ Property and equipment, net of accumulated depreciation and amortization
= (12,560 + 12,536 + 10,472 + 10,742) ÷ 30,796 = 1.50

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Delta Air Lines Inc.’s net fixed asset turnover ratio deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Delta Air Lines Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Operating revenue 12,560  12,536  10,472  10,742  11,953  11,775  9,968  10,245  11,060  10,791  9,148  9,458  10,483  10,447  9,251  9,502  11,107  10,707  9,388  9,647  11,178  10,621  8,916 
 
Property and equipment, net of accumulated depreciation and amortization 30,796  30,165  29,139  28,335  28,565  28,124  27,096  26,563  25,900  25,367  24,817  24,375  24,105  23,975  23,422  23,039  22,608  22,480  22,023  21,929  21,722  22,048  21,972 
Operating lease right-of-use assets 5,815  5,906  6,036  5,994  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Property and equipment, net of accumulated depreciation and amortization (including operating lease, right-of-use asset) 36,611  36,071  35,175  34,329  28,565  28,124  27,096  26,563  25,900  25,367  24,817  24,375  24,105  23,975  23,422  23,039  22,608  22,480  22,023  21,929  21,722  22,048  21,972 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 1.26 1.27 1.28 1.29 1.54 1.53 1.55 1.55 1.56 1.57 1.59 1.63 1.65 1.68 1.73 1.77 1.81 1.82 1.85 1.84 — — —
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Booking Holdings Inc. 11.35 10.88 10.85 22.14 21.96 22.34 23.02 26.41 26.72 27.01 28.89 30.96 30.59 30.60 31.79 33.57 35.25 35.75 40.22 42.43 — — —
Marriott International Inc. 7.17 7.07 7.06 10.61 10.85 11.21 12.47 12.77 11.87 9.87 8.94 7.31 6.36 14.16 14.15 14.08 14.56 14.41 9.69 9.45 7.72 8.01 8.20
McDonald’s Corp. 0.58 0.58 0.59 0.92 0.94 0.97 0.98 1.02 1.07 1.11 1.15 1.16 1.08 1.10 1.08 1.10 1.10 1.10 1.15 1.12 — — —

Based on: 10-Q (filing date: 2019-10-10), 10-Q (filing date: 2019-07-11), 10-Q (filing date: 2019-04-10), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-11), 10-Q (filing date: 2018-07-12), 10-Q (filing date: 2018-04-12), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-11), 10-Q (filing date: 2017-07-13), 10-Q (filing date: 2017-04-12), 10-K (filing date: 2017-02-13), 10-Q (filing date: 2016-10-13), 10-Q (filing date: 2016-07-15), 10-Q (filing date: 2016-04-14), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-14), 10-Q (filing date: 2015-07-15), 10-Q (filing date: 2015-04-15), 10-K (filing date: 2015-02-11), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-24).

1 Q3 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019 + Operating revenueQ4 2018) ÷ Property and equipment, net of accumulated depreciation and amortization (including operating lease, right-of-use asset)
= (12,560 + 12,536 + 10,472 + 10,742) ÷ 36,611 = 1.26

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Delta Air Lines Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Total Asset Turnover

Delta Air Lines Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Operating revenue 12,560  12,536  10,472  10,742  11,953  11,775  9,968  10,245  11,060  10,791  9,148  9,458  10,483  10,447  9,251  9,502  11,107  10,707  9,388  9,647  11,178  10,621  8,916 
Total assets 63,219  62,518  61,841  60,266  55,003  55,796  54,078  53,292  51,928  51,815  51,459  51,261  50,948  51,634  53,342  53,134  53,646  52,781  53,752  54,121  51,940  52,191  52,167 
Long-term Activity Ratio
Total asset turnover1 0.73 0.73 0.73 0.74 0.80 0.77 0.78 0.77 0.78 0.77 0.77 0.77 0.78 0.78 0.76 0.77 0.76 0.78 0.76 0.75 — — —
Benchmarks
Total Asset Turnover, Competitors2
Booking Holdings Inc. 0.70 0.69 0.65 0.64 0.58 0.54 0.53 0.50 0.47 0.49 0.50 0.54 0.52 0.50 0.52 0.53 0.55 0.52 0.51 0.57 — — —
Marriott International Inc. 0.84 0.83 0.84 0.88 0.90 0.92 0.91 0.96 0.93 0.87 0.79 0.71 0.61 2.25 2.41 2.38 2.33 2.25 2.06 2.01 1.96 1.93 1.93
McDonald’s Corp. 0.46 0.45 0.45 0.64 0.62 0.66 0.66 0.68 0.72 0.74 0.76 0.79 0.77 0.76 0.75 0.67 0.78 0.74 0.83 0.80 — — —
Starbucks Corp. 1.25 1.45 1.27 1.02 1.40 1.34 1.23 1.56 1.54 1.54 1.55 1.49 1.48 1.61 1.52 1.54 1.43 1.45 1.38 1.53 — — —

Based on: 10-Q (filing date: 2019-10-10), 10-Q (filing date: 2019-07-11), 10-Q (filing date: 2019-04-10), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-11), 10-Q (filing date: 2018-07-12), 10-Q (filing date: 2018-04-12), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-11), 10-Q (filing date: 2017-07-13), 10-Q (filing date: 2017-04-12), 10-K (filing date: 2017-02-13), 10-Q (filing date: 2016-10-13), 10-Q (filing date: 2016-07-15), 10-Q (filing date: 2016-04-14), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-14), 10-Q (filing date: 2015-07-15), 10-Q (filing date: 2015-04-15), 10-K (filing date: 2015-02-11), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-24).

1 Q3 2019 Calculation
Total asset turnover = (Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019 + Operating revenueQ4 2018) ÷ Total assets
= (12,560 + 12,536 + 10,472 + 10,742) ÷ 63,219 = 0.73

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Delta Air Lines Inc.’s total asset turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Equity Turnover

Delta Air Lines Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Operating revenue 12,560  12,536  10,472  10,742  11,953  11,775  9,968  10,245  11,060  10,791  9,148  9,458  10,483  10,447  9,251  9,502  11,107  10,707  9,388  9,647  11,178  10,621  8,916 
Stockholders’ equity 15,068  13,958  12,911  13,687  13,704  12,856  12,557  13,910  14,001  13,479  12,945  12,287  12,510  11,810  11,252  10,850  10,345  9,563  9,046  8,813  12,296  12,203  11,641 
Long-term Activity Ratio
Equity turnover1 3.07 3.27 3.48 3.25 3.21 3.35 3.35 2.97 2.89 2.96 3.05 3.23 3.17 3.41 3.61 3.75 3.95 4.28 4.51 4.58 — — —
Benchmarks
Equity Turnover, Competitors2
Booking Holdings Inc. 2.51 2.78 2.09 1.65 1.42 1.31 1.24 1.13 0.95 0.99 1.02 1.09 1.06 1.06 1.05 1.05 1.06 1.03 1.00 0.99 — — —
Marriott International Inc. 24.93 16.66 12.95 9.33 9.18 7.73 6.27 6.14 4.98 4.23 3.65 3.19 2.62 — — — — — — — — — —
McDonald’s Corp. — — — — — — — — — — — — — 39.26 6.56 3.59 3.09 2.46 2.34 2.13 — — —
Starbucks Corp. — — — 21.14 6.04 4.98 3.95 4.11 3.83 3.92 3.74 3.62 3.59 3.96 3.30 3.29 3.15 2.95 2.95 3.12 — — —

Based on: 10-Q (filing date: 2019-10-10), 10-Q (filing date: 2019-07-11), 10-Q (filing date: 2019-04-10), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-11), 10-Q (filing date: 2018-07-12), 10-Q (filing date: 2018-04-12), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-11), 10-Q (filing date: 2017-07-13), 10-Q (filing date: 2017-04-12), 10-K (filing date: 2017-02-13), 10-Q (filing date: 2016-10-13), 10-Q (filing date: 2016-07-15), 10-Q (filing date: 2016-04-14), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-14), 10-Q (filing date: 2015-07-15), 10-Q (filing date: 2015-04-15), 10-K (filing date: 2015-02-11), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-24).

1 Q3 2019 Calculation
Equity turnover = (Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019 + Operating revenueQ4 2018) ÷ Stockholders’ equity
= (12,560 + 12,536 + 10,472 + 10,742) ÷ 15,068 = 3.07

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Delta Air Lines Inc.’s equity turnover ratio deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.