Stock Analysis on Net

AT&T Inc. (NYSE:T)

$24.99

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

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


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

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2024 = ×
Dec 31, 2023 = ×
Dec 31, 2022 = ×
Dec 31, 2021 = ×
Dec 31, 2020 = ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Return on Assets (ROA)
The return on assets exhibits notable volatility over the analyzed period. Initially, it was negative at -0.98% in 2020, indicating inefficiency in asset utilization. It then improved significantly to 3.64% in 2021, suggesting better asset productivity. However, in 2022, the ROA declined sharply to -2.12%, reflecting a downturn in asset profitability. The subsequent years saw recovery, with ROA rising to 3.54% in 2023 and slightly declining to 2.77% in 2024, maintaining a positive but somewhat lower level of asset returns compared to 2021.
Financial Leverage
Financial leverage increased from 3.25 in 2020 to a peak of 4.13 in 2022, indicating a rising use of debt or other financing sources relative to equity. This upward trend suggests growing reliance on borrowed funds or liabilities up to 2022. Following this peak, leverage decreased in subsequent years, moving to 3.94 in 2023 and further to 3.78 in 2024, pointing to a moderate reduction in leverage while still maintaining a higher level compared to 2020 and 2021.
Return on Equity (ROE)
The return on equity demonstrates considerable fluctuations, starting with a negative return of -3.2% in 2020. A noteworthy increase occurred in 2021, reaching 12.07%, indicating improved profitability from shareholder investments. This was followed by a sharp decline to -8.74% in 2022, reflecting a significant loss or decreased equity efficiency. The company then experienced recovery with ROE climbing to 13.94% in 2023, the highest value in the period. In 2024, the ROE decreased to 10.49%, still maintaining a positive and favorable level compared to earlier years.
Summary
The company’s financial performance over the period is characterized by volatility in profitability metrics—both ROA and ROE show multiple swings between negative and positive values, indicating fluctuating operational and financial effectiveness. Financial leverage increased until 2022, suggesting greater use of debt financing, before a reduction in the following years. This pattern may correlate with variations in profitability, as increased leverage typically amplifies returns and losses. Overall, despite periods of negative returns, the most recent years demonstrate positive recovery in profitability alongside a moderation in financial leverage.

Three-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2024 = × ×
Dec 31, 2023 = × ×
Dec 31, 2022 = × ×
Dec 31, 2021 = × ×
Dec 31, 2020 = × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


The analysis of the annual financial ratios reveals a fluctuating performance over the five-year period. The net profit margin shows considerable volatility, shifting from a negative margin of -3.01% in 2020 to a positive 11.89% in 2021. This is followed by another decline to -7.06% in 2022, before improving again to 11.76% in 2023 and decreasing slightly to 8.95% in 2024. Such swings indicate periods of profitability interspersed with losses, suggesting variability in operating efficiency or external market conditions.

The asset turnover ratio remains relatively stable throughout the period, hovering around 0.30 to 0.33. This consistency suggests that asset utilization efficiency has not experienced significant changes, indicating steady management of asset use in generating revenue.

Financial leverage exhibits an increasing trend from 3.25 in 2020 to a peak of 4.13 in 2022, which indicates a higher proportion of debt relative to equity during this period. Subsequently, leverage decreases to 3.94 in 2023 and further to 3.78 in 2024, signifying a reduction in debt reliance or an increase in equity base in recent years.

Return on equity (ROE) mirrors the pattern observed in net profit margin closely with negative returns of -3.2% in 2020 and -8.74% in 2022, and positive returns of 12.07% in 2021 and a peak of 13.94% in 2023. In 2024, ROE declines moderately to 10.49%. This fluctuation indicates variability in overall profitability relative to shareholder equity, influenced by the company’s earnings performance and its financial structure.

Summary
Overall, the company exhibits volatile profitability with alternating positive and negative net profit margins and ROE values over the five-year horizon.
Asset efficiency remains stable, highlighting consistent revenue generation from assets.
Financial leverage increased initially, potentially implying increased debt use, then decreased, signaling a possible strategic shift towards a more balanced capital structure.
The trends suggest the company faces cyclical or operational challenges impacting profitability but maintains consistent asset utilization and adjusts its financial leverage to optimize returns.

Five-Component Disaggregation of ROE

AT&T Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2024 = × × × ×
Dec 31, 2023 = × × × ×
Dec 31, 2022 = × × × ×
Dec 31, 2021 = × × × ×
Dec 31, 2020 = × × × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


The financial data over the observed periods reveals several noteworthy trends and fluctuations in the company's financial performance and structure.

Tax Burden
The tax burden ratio shows a declining trend, decreasing from 0.79 in 2021 to 0.71 in 2024. This indicates that the company is retaining a larger portion of its pre-tax earnings over time, potentially due to more effective tax management or changes in tax regulations.
Interest Burden
The interest burden exhibits high volatility, with negative values observed in 2020 and 2022 (-1.13 and -3.48 respectively), and positive values around 0.69 to 0.79 in other years. This suggests periods of significant interest expense impacting earnings, followed by phases of relative improvement, indicating fluctuating debt servicing costs or financing structures.
EBIT Margin
The EBIT margin demonstrates substantial variability. It is relatively low in 2020 (2.16%) and 2022 (1.13%), but markedly higher in 2021 (19.21%), 2023 (20.69%), and remains elevated in 2024 (18.11%). This reflects periods of strong operational profitability interspersed with times of subdued earnings efficiency.
Asset Turnover
Asset turnover maintains a relatively stable pattern, slightly declining from 0.33 in 2020 to 0.3 in 2022 and 2023, with a small rebound to 0.31 in 2024. This consistency implies steady efficiency in utilizing assets to generate revenue over the years.
Financial Leverage
The financial leverage ratio increased from 3.25 in 2020 to a peak of 4.13 in 2022, before decreasing to 3.78 by 2024. This suggests a rise in reliance on debt financing up to 2022, followed by a moderate reduction, highlighting efforts to manage the debt level relative to equity.
Return on Equity (ROE)
ROE exhibits significant fluctuations, recording negative returns in 2020 (-3.2%) and 2022 (-8.74%), contrasted with strong positive returns in 2021 (12.07%), 2023 (13.94%), and a moderate positive return in 2024 (10.49%). This pattern reflects variable profitability and effectiveness in generating returns for shareholders across the periods.

Overall, the data portrays a company facing intermittent financial challenges, especially in terms of interest burden and return on equity, but showing resilience with periods of improved operational profitability and attempts to optimize its financial leverage and taxation impact.


Two-Component Disaggregation of ROA

AT&T Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2024 = ×
Dec 31, 2023 = ×
Dec 31, 2022 = ×
Dec 31, 2021 = ×
Dec 31, 2020 = ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Net Profit Margin
The net profit margin exhibited notable volatility over the observed periods. In 2020, the margin was negative at -3.01%, indicating a loss position. This shifted to a positive margin of 11.89% in 2021, reflecting a significant improvement in profitability. However, 2022 saw another decline into negative territory at -7.06%, followed by a recovery to 11.76% in 2023. In the most recent period, the margin decreased slightly to 8.95%, remaining positive but below the peak levels of 2021 and 2023. This pattern suggests fluctuating profitability with some level of instability in earnings performance.
Asset Turnover
The asset turnover ratio demonstrated a relatively steady trend over the five-year span. Starting at 0.33 in 2020, it gradually decreased to 0.31 in 2021, followed by a decline to 0.30 in 2022 and 2023. In 2024, there was a slight increase back to 0.31. This consistency in asset utilization efficiency indicates that the company's ability to generate sales from its assets remains relatively stable with minor fluctuations.
Return on Assets (ROA)
Return on assets mirrored the fluctuations observed in net profit margin, showing inconsistency across periods. The ROA was negative at -0.98% in 2020, turned positive to 3.64% in 2021, then declined again to -2.12% in 2022. It rebounded to 3.54% in 2023 before decreasing to 2.77% in 2024. Although the ROA remained positive in the last three years, the variation highlights uneven effectiveness in generating returns from asset investments.

Four-Component Disaggregation of ROA

AT&T Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2024 = × × ×
Dec 31, 2023 = × × ×
Dec 31, 2022 = × × ×
Dec 31, 2021 = × × ×
Dec 31, 2020 = × × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


The financial data reveals several notable trends in operational efficiency and profitability ratios over the five-year period.

Tax Burden
The tax burden ratio shows a gradual decline from 0.79 in 2021 to 0.71 in 2024, indicating a decreasing proportion of earnings paid as taxes. The available data points suggest improved tax efficiency over time, which could positively influence net profitability.
Interest Burden
The interest burden ratio exhibits significant volatility. It fell sharply to -1.13 in 2020 and further dipped to -3.48 in 2022, implying negative operational results or extraordinary financial expenses during these years. However, the ratio recovered in subsequent years, ascending to 0.69 in 2024, which suggests improving earnings before interest and taxes relative to operating profit and a reduction in financial strain.
EBIT Margin
The EBIT margin shows substantial fluctuations, with low margins of around 1% observed in 2020 and 2022 contrasted by strong margins exceeding 18% in 2023 and 2024. This pattern points to periods of operational difficulties followed by marked improvements in core profitability.
Asset Turnover
The asset turnover ratio remains relatively stable and modest, hovering between 0.30 and 0.33. This stability indicates consistent efficiency in using assets to generate revenue, albeit at a comparatively low turnover rate.
Return on Assets (ROA)
The ROA pattern mirrors the volatility observed in other metrics. Negative returns in 2020 and 2022 (-0.98% and -2.12%, respectively) contrast with positive returns above 2.7% in 2021, 2023, and 2024. This suggests that the company experienced profitability challenges in certain years but overall has maintained the ability to generate some profit from its asset base.

In summary, the data indicate a business experiencing episodic operational and financial challenges evidenced by negative and volatile interest burden and ROA figures. However, improvements in EBIT margin and tax burden ratios in recent years point to a recovery or enhanced efficiency, while asset utilization remains stable. Continued focus on managing financial costs and improving operational profitability may support sustained positive returns moving forward.


Disaggregation of Net Profit Margin

AT&T Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2024 = × ×
Dec 31, 2023 = × ×
Dec 31, 2022 = × ×
Dec 31, 2021 = × ×
Dec 31, 2020 = × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Tax Burden
The tax burden ratio exhibits a decreasing trend over the observed periods with values of 0.79 in 2021, 0.77 in 2023, and further decline to 0.71 in 2024. This indicates a progressively lower proportion of earnings being paid as taxes, which could potentially enhance net profitability.
Interest Burden
The interest burden ratio shows significant fluctuations throughout the periods. It started with a negative value of -1.13 in 2020, improved to 0.79 in 2021, dropped sharply to -3.48 in 2022, and then stabilized around 0.74 in 2023 and 0.69 in 2024. These swings indicate volatility in the company's earnings before interest and taxes (EBIT) relative to operating income, reflecting varying interest expenses or other financial factors impacting operating profitability.
EBIT Margin
The EBIT margin percentage also demonstrates considerable variability. Starting at a low 2.16% in 2020, it surged to 19.21% in 2021, sharply dipped to 1.13% in 2022, then rebounded to 20.69% in 2023, followed by a slight decrease to 18.11% in 2024. This pattern points to inconsistent operating profitability with notable recoveries after substantial declines.
Net Profit Margin
The net profit margin mirrors similar volatility as the EBIT margin, moving from a negative -3.01% in 2020 to a positive 11.89% in 2021, then back down to -7.06% in 2022. It rebounded once again to 11.76% in 2023 before settling at 8.95% in 2024. The alternating negative and positive margins indicate periods of losses interspersed with profitable years, demonstrating profitability challenges and recovery phases.