Stock Analysis on Net

AT&T Inc. (NYSE:T)

$24.99

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
Mar 31, 2024 = ×
Dec 31, 2023 = ×
Sep 30, 2023 = ×
Jun 30, 2023 = ×
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
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 = ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).


The quarterly financial data reveals significant fluctuations and notable trends in the key performance indicators over the analyzed periods.

Return on Assets (ROA)
ROA initially shows negative values, with a low point of -0.98% around the end of 2020. Subsequently, a steady improvement is observed, culminating in a positive peak at 4.7% by the end of 2021. However, this performance declines sharply again in early 2022, dropping below -2% for several quarters through 2023. Towards the later periods starting in 2024, ROA exhibits a recovery trend, returning to positive values around 2-3% by the end of the observed timeline. This pattern indicates periods of operational challenges followed by phases of recovery and improved asset utilization.
Financial Leverage
The financial leverage ratio maintains a relatively stable yet slightly increasing trend from approximately 3.07 in early 2020 to a peak of 4.13 by late 2022. Post this peak, a gradual decline occurs, settling near 3.78-3.85 in the later quarters through early 2025. The leverage levels suggest a cautious management of debt or financing structure with some buildup in leverage until late 2022 followed by a controlled reduction, possibly reflecting strategic efforts to optimize the capital structure.
Return on Equity (ROE)
The ROE mirrors the volatility seen in ROA with pronounced negative values including a low of -10.9% around late 2023. Prior to this trough, ROE improved from negative territory in 2020 to strong positive readings peaking at about 16.92% at the end of 2021. After the downturn in 2022 and 2023, a recovery phase is evident from 2024 onwards, with ROE values returning to a positive range around 10-13% by early 2025. This cycle reflects the company’s fluctuating ability to generate shareholder returns amid varying operational and financial conditions.

Overall, the data indicates that the company experienced cycles of financial stress and recovery over the course of these quarters. After a challenging period marked by negative returns and rising leverage, the latter quarters show a trend towards stabilization and improvement in profitability and asset efficiency, accompanied by a more prudent financial leverage position.


Three-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2025 = × ×
Dec 31, 2024 = × ×
Sep 30, 2024 = × ×
Jun 30, 2024 = × ×
Mar 31, 2024 = × ×
Dec 31, 2023 = × ×
Sep 30, 2023 = × ×
Jun 30, 2023 = × ×
Mar 31, 2023 = × ×
Dec 31, 2022 = × ×
Sep 30, 2022 = × ×
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 = × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).


The financial data reveals several trends in key performance indicators over multiple quarters. The analysis focuses on net profit margin, asset turnover, financial leverage, and return on equity (ROE).

Net Profit Margin
The net profit margin shows significant volatility across the periods. Starting with negative values in 2020, it gradually improves to positive margins in late 2020 and throughout 2021, peaking around 15.37% in December 2021. Following this peak, a sharp decline is observed in early 2022, with margins turning negative again and reaching lows near -9.29% by late 2022. Beginning in early 2023, margins recover with fluctuating positive values, stabilizing around 8-10% by early 2025. This pattern suggests a period of operational challenges followed by recovery phases.
Asset Turnover
Asset turnover remains relatively stable across the timeline, exhibiting minor fluctuations around 0.30 to 0.33. The ratio dips slightly in mid-2022 to approximately 0.27 but recovers quickly to the range of 0.30-0.31 thereafter. This steadiness indicates consistent efficiency in using assets to generate sales, despite other financial fluctuations.
Financial Leverage
Financial leverage demonstrates a gradual increase from 3.07 in early 2020 to a peak of 4.13 in late 2022, indicating rising reliance on debt or other liabilities relative to equity. Following this peak, leverage declines moderately, settling around 3.7 to 3.8 range by early 2025. The trend suggests strategic adjustment in capital structure, potentially aiming for reduced financial risk after high leverage periods.
Return on Equity (ROE)
ROE follows a pattern similar to net profit margin, with negative returns in early periods transitioning to positive and sometimes robust returns in late 2020 and into 2021, reaching a peak near 16.92% in September 2021. A notable decline and negative values appear in 2022 and early 2023, aligning with the return margin downturn. Subsequently, ROE recovers to moderate positive levels from 2023 onwards, stabilizing around 10-13% towards early 2025. This indicates varying profitability impacting shareholder returns.

In summary, the data reflects a company experiencing fluctuating profitability and returns on equity, with net profit margin and ROE showing strong cyclical behavior. Asset turnover remains consistent, indicating stable operational efficiency, while financial leverage trends suggest a period of elevated debt usage followed by deleveraging efforts. Overall, these patterns highlight periods of financial stress and recovery impacting returns, underpinned by stable asset utilization and adjustments in funding strategy.


Five-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Mar 31, 2025 = × × × ×
Dec 31, 2024 = × × × ×
Sep 30, 2024 = × × × ×
Jun 30, 2024 = × × × ×
Mar 31, 2024 = × × × ×
Dec 31, 2023 = × × × ×
Sep 30, 2023 = × × × ×
Jun 30, 2023 = × × × ×
Mar 31, 2023 = × × × ×
Dec 31, 2022 = × × × ×
Sep 30, 2022 = × × × ×
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 = × × × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).


The financial data reflects several notable trends in key performance ratios over the observed periods.

Tax Burden
The tax burden ratio data is available starting from December 31, 2020. It shows an increasing trend from 0.33 to approximately 0.79 through 2021 and remains relatively stable around 0.77 to 0.8 in subsequent quarters. This indicates a steady proportion of income retained after taxes in recent periods.
Interest Burden
The interest burden ratio exhibits considerable volatility. Initially, it is negative from September 30, 2020, through June 30, 2021, reflecting possibly high interest expenses relative to earnings. However, it improves sharply to around 0.79-0.8 by December 2021, indicating more favorable interest expense management or income from operations. There is a notable dip to significantly negative values toward the end of 2022 but recovers again from the first quarter of 2024 onwards to a more stable range near 0.65 to 0.74.
EBIT Margin
The EBIT margin shows wide fluctuations across the quarters. From about 2% to 6% in late 2020, it spikes substantially in 2021, reaching upwards of 23.9% at year-end, suggesting improved operating efficiency or revenue growth during this year. However, the margin declines sharply going into 2022 and early 2023, even turning negative by December 2023. Starting in early 2024, there is a rebound trend with margins stabilizing around 16% to 20%, indicating a recovery in operational profitability.
Asset Turnover
The asset turnover ratio remains fairly stable, fluctuating slightly between 0.27 and 0.33 throughout the period. This consistency suggests a steady rate of generating revenue from assets without significant improvement or deterioration.
Financial Leverage
Financial leverage shows a gradual increase from approximately 3.07 in early 2020 to a peak above 4.1 near the end of 2022. This indicates a rising use of debt relative to equity over this period. Post-2022, the leverage ratio declines slightly but remains elevated around 3.8 to 3.9, suggesting continued reliance on financial leverage but at a somewhat moderated level compared to the previous peak.
Return on Equity (ROE)
ROE data presents substantial volatility and periods of negative returns, notably declining below zero from September 2020 through early 2023, with the lowest points near -10%. This implies periods of losses or minimal profitability for shareholders during this timeframe. From early 2024, ROE recovers markedly to positive values in the range of roughly 8.85% to 14.0%, reflecting improved returns to equity holders consistent with the observed recovery in EBIT margin and stabilization in financial leverage and interest management.

Overall, the data suggests the company faced operational and financial challenges in 2020 through early 2023, reflected in low or negative profitability and volatile interest burden. Improvements are evident from 2024 onwards, with stronger operating margins, improved interest burden, stable asset utilization, and reduced financial stress, leading to better ROE outcomes.


Two-Component Disaggregation of ROA

AT&T Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
Mar 31, 2024 = ×
Dec 31, 2023 = ×
Sep 30, 2023 = ×
Jun 30, 2023 = ×
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
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 = ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).


The analyzed data reveals notable fluctuations and trends in the financial performance over multiple quarters.

Net Profit Margin (%)

The net profit margin demonstrated variability through the observed periods. Starting with negative values near the end of 2020, a gradual improvement is evident, peaking in late 2021 with margins exceeding 15%. However, this gain reversed sharply during 2022, returning to negative figures reaching nearly -9.3% by the end of that year. Recovery signs are visible in 2023 and beyond, with margins steadily improving to reach positive levels above 8% by early 2025. The pattern implies periods of profitability interspersed with challenges affecting net income relative to revenue.

Asset Turnover (ratio)

Asset turnover ratios remained relatively stable over the analyzed quarters, fluctuating in a narrow range between approximately 0.27 and 0.33. Minor declines were observed mid-2022, but the ratio rebounded slightly in subsequent periods maintaining around 0.3. This stability indicates consistent efficiency in generating revenue from assets despite external or internal economic factors.

Return on Assets (ROA, %)

ROA mirrored the movements in net profit margin, starting with negative returns in early quarters, improving significantly into positive territory around late 2021, peaking at just above 4.7%. A downturn follows in 2022 with negative returns aggregating near -2.8%. Recovery is apparent afterward, with ROA values progressively increasing to nearly 3% by early 2025. The trend highlights fluctuations in profitability relative to asset base efficiency, aligning broadly with profit margin changes but showing more moderate swings.


Four-Component Disaggregation of ROA

AT&T Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Mar 31, 2025 = × × ×
Dec 31, 2024 = × × ×
Sep 30, 2024 = × × ×
Jun 30, 2024 = × × ×
Mar 31, 2024 = × × ×
Dec 31, 2023 = × × ×
Sep 30, 2023 = × × ×
Jun 30, 2023 = × × ×
Mar 31, 2023 = × × ×
Dec 31, 2022 = × × ×
Sep 30, 2022 = × × ×
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 = × × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).


The analysis of the quarterly financial data reveals several noteworthy trends in key financial ratios over the observed periods.

Tax Burden
The tax burden ratio is absent in the earlier quarters but emerges from December 31, 2020, showing a value of 0.33. Subsequently, it increases significantly to approximately 0.79 by March 31, 2021, and remains relatively stable around 0.7 to 0.8 in ensuing quarters. This suggests a sustained tax impact on earnings, with slight fluctuations but an overall high tax burden in the later periods.
Interest Burden
The interest burden ratio presents high volatility. Early in the timeline, during late 2020, this ratio is negative, indicating periods of heavy interest expense affecting earnings before tax. From March 31, 2021, to December 31, 2021, the ratio improves substantially, stabilizing between 0.77 to 0.8. However, there is a pronounced negative spike around Q1 to Q4 of 2022, indicating increased interest expense or financial strain during that period. From early 2024 onward, the ratio returns to a healthier range of approximately 0.65 to 0.74, reflecting improved interest expense management or reduced debt impact.
EBIT Margin
The EBIT margin undergoes significant fluctuations. Starting in the early quarters of 2020 with low single-digit percentages, it climbs sharply to a peak of around 23.9% in December 31, 2021. However, this is followed by a marked decline in 2022 and early 2023, with margins even turning negative in some quarters, reflecting operational challenges or one-time costs. The margin then recovers robustly from late 2023 onwards, hovering around 16% to 20%, indicating improving operational efficiency or cost controls impacting earnings before interest and tax positively.
Asset Turnover
The asset turnover ratio remains relatively stable throughout the observed periods, ranging generally between 0.27 and 0.33. There is a slight dip around mid-2022 to early 2023 but the ratio quickly returns to previous levels. This consistency indicates stable management of asset utilization in generating revenues.
Return on Assets (ROA)
The ROA mirrors the volatility seen in EBIT margin and interest burden. Initial quarters in late 2020 display negative returns, indicating losses or low profitability from asset utilization. A significant improvement is seen towards the end of 2021 reaching over 4.6%, followed by a fall back into negative territory during 2022 and early 2023. From early 2024 onwards, ROA recovers again to a positive range between approximately 2.3% and 3.5%. This pattern suggests cyclical operational performance and profitability challenges interspersed with recovery phases.

In summary, the financial ratios indicate fluctuating operational efficiency and profitability, with evident periods of stress possibly related to interest expenses and tax impacts. Despite these fluctuations, asset turnover remains steady, suggesting consistent asset utilization. The recent quarters show signs of recovery and improved profitability metrics after a challenging period around 2022 and early 2023.


Disaggregation of Net Profit Margin

AT&T Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Mar 31, 2025 = × ×
Dec 31, 2024 = × ×
Sep 30, 2024 = × ×
Jun 30, 2024 = × ×
Mar 31, 2024 = × ×
Dec 31, 2023 = × ×
Sep 30, 2023 = × ×
Jun 30, 2023 = × ×
Mar 31, 2023 = × ×
Dec 31, 2022 = × ×
Sep 30, 2022 = × ×
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 = × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).


The financial data reveals several noteworthy patterns and fluctuations across multiple periods.

Tax Burden
The tax burden ratio exhibits stability from the period starting December 2020 through March 2025, generally ranging from approximately 0.7 to 0.8. Early data points are missing, but from March 2021 onwards, the ratio remains relatively steady, indicating consistent taxation effects on earnings in these quarters.
Interest Burden
The interest burden ratio shows significant volatility and negative values during several quarters starting from September 2020 through December 2022, with extremely negative figures particularly in March 2022 to December 2022. This suggests periods where interest expenses heavily impacted earnings before tax, possibly reflecting increased debt costs or financing issues. In more recent periods from June 2023 to March 2025, the ratio stabilizes around 0.65 to 0.74, pointing to an improved or stabilized interest expense situation relative to operating earnings.
EBIT Margin
The EBIT margin initially appears low and fluctuates from March 2021 through early 2023, with some quarters reflecting margins below 1%, including negative margin in December 2022. A sharp improvement occurs starting March 2021, reaching peaks of approximately 23.9% in December 2021 and maintaining relatively high levels around 18% to 20% in the 2024 periods. However, some quarters such as December 2023 exhibit a sharp dip into negative territory, indicating significant operational challenges or one-time charges affecting earnings before interest and taxes in that quarter.
Net Profit Margin
Net profit margin trends mirror the fluctuations seen in EBIT margin, with several quarters exhibiting negative margins between March 2020 and December 2023, including a pronounced negative margin near -9.29% in December 2023. From March 2021 to December 2021, there is improvement with positive margins above 10%, and similarly in the recent periods from March 2024 through March 2025, margins stabilize between 7% and nearly 10%. The negative margins in several intermediate periods suggest volatile net profitability, likely influenced by interest and tax burdens alongside operational costs.

Overall, the data indicates periods of considerable financial strain characterized by negative interest and net profit margins, interspersed with intervals of strong operational performance and profitability. The stabilization of tax and interest burdens in later periods aligns with improved EBIT and net profit margins, suggesting an ongoing recovery or operational stabilization towards the most recent periods analyzed.