Stock Analysis on Net
Stock Analysis on Net

Delta Air Lines Inc. (NYSE:DAL)

This company has been moved to the archive! The financial data has not been updated since July 13, 2022.

Common-Size Balance Sheet: Assets
Quarterly Data

Delta Air Lines Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 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
Cash and cash equivalents 12.33 10.45 10.95 12.07 13.75 11.58 11.54 20.84 15.73 8.68 4.47 3.00 3.21 3.09 2.60 2.51 3.38 2.68 3.40 2.85 4.33 3.71
Short-term investments 2.07 3.05 4.67 6.07 6.47 7.63 8.04 6.38 5.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Accounts receivable, net of an allowance for uncollectible accounts 4.13 4.12 3.32 3.00 3.00 2.51 1.94 1.90 1.90 3.32 4.42 4.49 4.55 5.10 3.84 4.58 4.35 4.75 4.46 4.62 4.18 4.48
Fuel, expendable parts and supplies inventories, net of allowance for obsolescence 2.32 1.75 1.52 1.39 1.33 1.13 1.02 0.94 1.17 1.42 1.94 1.70 1.73 1.73 1.75 2.13 2.85 2.12 2.49 2.19 1.81 1.66
Prepaid expenses and other 2.29 1.94 1.54 1.48 1.56 1.58 1.64 1.59 1.42 1.53 1.96 1.80 1.92 1.72 2.33 3.02 3.12 4.74 4.36 3.99 3.54 3.52
Current assets 23.14% 21.32% 22.00% 24.00% 26.11% 24.43% 24.17% 31.65% 26.18% 14.95% 12.78% 10.98% 11.41% 11.64% 10.52% 12.23% 13.69% 14.28% 14.72% 13.64% 13.85% 13.37%
Property and equipment, net of accumulated depreciation and amortization 40.80 40.74 39.68 38.22 36.53 36.76 36.85 33.64 39.40 46.04 48.52 48.71 48.25 47.12 47.02 51.93 50.41 50.11 49.84 49.88 48.96 48.23
Operating lease right-of-use assets 9.61 10.04 9.99 8.01 7.51 7.63 7.96 7.44 7.82 7.98 8.72 9.20 9.45 9.76 9.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Goodwill 13.04 13.22 13.46 13.40 12.95 13.35 13.55 12.33 13.50 14.19 15.16 15.47 15.65 15.82 16.23 17.81 17.55 18.11 18.38 18.86 18.90 19.03
Identifiable intangibles, net of accumulated amortization 8.02 8.13 8.28 8.25 7.98 8.22 8.35 7.61 8.33 8.76 8.00 7.63 7.72 7.81 8.01 8.79 8.67 8.96 9.10 9.34 9.37 9.43
Equity investments 2.37 2.71 2.36 2.64 2.85 2.64 2.31 1.98 2.26 5.36 3.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deferred income taxes, net 1.63 2.08 1.79 2.49 2.87 3.16 2.76 1.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other noncurrent assets 1.40 1.76 2.45 3.00 3.22 3.82 4.05 3.70 2.52 2.73 2.84 8.01 7.53 7.86 8.27 9.24 9.67 8.55 7.96 8.28 8.92 9.94
Noncurrent assets 76.86% 78.68% 78.00% 76.00% 73.89% 75.57% 75.83% 68.35% 73.82% 85.05% 87.22% 89.02% 88.59% 88.36% 89.48% 87.77% 86.31% 85.72% 85.28% 86.36% 86.15% 86.63%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

The asset composition of the organization underwent a significant structural shift between early 2017 and mid-2022, characterized by a transition from a heavy reliance on noncurrent assets toward an increased liquidity position, particularly during the 2020-2021 period.

Liquidity and Current Asset Trends
A dramatic increase in liquidity is observed starting in March 2020. Cash and cash equivalents, which previously fluctuated between 2.5% and 4.5% of total assets, peaked at 20.84% in September 2020. This was supplemented by the emergence of short-term investments in June 2020, which reached a peak of 8.04% in September 2020. Consequently, total current assets rose from a pre-2020 average of approximately 13% to a peak of 31.65% in September 2020, before stabilizing in the 21% to 26% range through June 2022.
Fixed Asset Dynamics
Property and equipment, net, constituted the largest portion of the asset base, maintaining a range of 47% to 52% from March 2017 through December 2019. A sharp contraction occurred throughout 2020, with this ratio falling to a low of 33.64% by September 2020. While a gradual recovery followed, the proportion reached only 40.80% by June 2022, indicating a long-term shift in the relative weight of fixed assets compared to the total asset base.
Intangible Assets and Goodwill
A consistent downward trend is evident in the proportion of goodwill and identifiable intangibles. Goodwill declined steadily from 19.03% in March 2017 to 13.04% in June 2022. Similarly, identifiable intangibles decreased from 9.43% to 8.02% over the same period. This suggests a gradual reduction in the relative impact of acquired intangible value on the total balance sheet.
Lease Assets and Noncurrent Adjustments
Operating lease right-of-use assets appeared in the records in December 2018 at 9.95% and remained relatively stable, oscillating between 7.44% and 10.04% through June 2022. Conversely, other noncurrent assets saw a substantial decline, dropping from approximately 9% in 2017 to as low as 1.40% by June 2022.
Overall Asset Mix Evolution
The balance sheet shifted from a noncurrent asset dominance of 85% to 89% (2017-2019) to a period of heightened volatility in 2020, where noncurrent assets dropped to 68.35%. By June 2022, the noncurrent asset proportion settled at 76.86%, reflecting a permanent increase in the relative weight of current assets compared to the 2017-2019 baseline.

AI Ask an analyst for more