Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Delta Air Lines Inc. (NYSE:DAL)

This company was transferred to the archive: financial data is no longer updated!

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
Dec 31, 2019 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
Net fixed asset turnover 1.50 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 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 1.27 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 — — —
Total asset turnover 0.73 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 — — —
Equity turnover 3.06 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 — — —

Based on: 10-K (filing date: 2020-02-13), 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).

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 Q2 2019 to Q3 2019 and from Q3 2019 to Q4 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 Q2 2019 to Q3 2019 but then improved from Q3 2019 to Q4 2019 exceeding Q2 2019 level.
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 Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Delta Air Lines Inc.’s equity turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 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
Selected Financial Data (US$ in millions)
Operating revenue 11,439  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 
Property and equipment, net of accumulated depreciation and amortization 31,310  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 
Long-term Activity Ratio
Net fixed asset turnover1 1.50 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 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Booking Holdings Inc. 20.41 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 — — —
McDonald’s Corp. 0.87 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 — — —
Starbucks Corp. 4.12 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

Based on: 10-K (filing date: 2020-02-13), 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).

1 Q4 2019 Calculation
Net fixed asset turnover = (Operating revenueQ4 2019 + Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019) ÷ Property and equipment, net of accumulated depreciation and amortization
= (11,439 + 12,560 + 12,536 + 10,472) ÷ 31,310 = 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 Q2 2019 to Q3 2019 and from Q3 2019 to Q4 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
Dec 31, 2019 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
Selected Financial Data (US$ in millions)
Operating revenue 11,439  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 
 
Property and equipment, net of accumulated depreciation and amortization 31,310  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 
Operating lease right-of-use assets 5,627  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,937  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 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 1.27 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 — — —
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Booking Holdings Inc. 11.09 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 — — —
McDonald’s Corp. 0.56 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 — — —
Starbucks Corp. 4.12 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

Based on: 10-K (filing date: 2020-02-13), 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).

1 Q4 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Operating revenueQ4 2019 + Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019) ÷ Property and equipment, net of accumulated depreciation and amortization (including operating lease, right-of-use asset)
= (11,439 + 12,560 + 12,536 + 10,472) ÷ 36,937 = 1.27

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 Q2 2019 to Q3 2019 but then improved from Q3 2019 to Q4 2019 exceeding Q2 2019 level.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 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
Selected Financial Data (US$ in millions)
Operating revenue 11,439  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 
Total assets 64,532  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 
Long-term Activity Ratio
Total asset turnover1 0.73 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 — — —
Benchmarks
Total Asset Turnover, Competitors2
Booking Holdings Inc. 0.70 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 — — —
McDonald’s Corp. 0.44 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 — — —
Starbucks Corp. 1.38 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

Based on: 10-K (filing date: 2020-02-13), 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).

1 Q4 2019 Calculation
Total asset turnover = (Operating revenueQ4 2019 + Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019) ÷ Total assets
= (11,439 + 12,560 + 12,536 + 10,472) ÷ 64,532 = 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 Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.

Equity Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 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
Selected Financial Data (US$ in millions)
Operating revenue 11,439  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 
Stockholders’ equity 15,358  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 
Long-term Activity Ratio
Equity turnover1 3.06 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 — — —
Benchmarks
Equity Turnover, Competitors2
Booking Holdings Inc. 2.54 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 — — —
McDonald’s Corp. — — — — — — — — — — — — — — 39.26 6.56 3.59 — — —
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

Based on: 10-K (filing date: 2020-02-13), 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).

1 Q4 2019 Calculation
Equity turnover = (Operating revenueQ4 2019 + Operating revenueQ3 2019 + Operating revenueQ2 2019 + Operating revenueQ1 2019) ÷ Stockholders’ equity
= (11,439 + 12,560 + 12,536 + 10,472) ÷ 15,358 = 3.06

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 Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.