Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

$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

Comcast Corp., 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).


Return on Assets (ROA)
Over the observed periods starting from March 31, 2020, the Return on Assets shows some fluctuations with an overall positive trajectory. Initially, data is absent for the earlier quarters of 2020, but the values beginning December 31, 2020, indicate an increase from 3.85% to a peak of 5.26% in September 2022. A notable dip to 2.12% occurs by December 2022, followed by a recovery trend reaching up to 6.08% by June 30, 2024. Following this peak, ROA slightly declines yet remains relatively stable above 5.4%, ending at 5.87% in March 31, 2025. This suggests enhanced efficiency in asset utilization over time despite some short-term volatility.
Financial Leverage
The Financial Leverage ratio reveals a gradual decrease from 3.22 in March 31, 2020 to a lower point near 2.87 by December 31, 2021, indicating a reduction in reliance on debt or financial obligations relative to equity. Post-2021, the ratio trends upward once again, peaking at 3.20 by June 30, 2024, before a minor decline to 3.09 at the end of the period examined on March 31, 2025. This oscillation reflects changes in the company’s capital structure, moving from deleveraging to slight increased leverage, then stabilizing towards the end.
Return on Equity (ROE)
Return on Equity data begins in December 31, 2020, with initial values of 11.66%, and shows a consistent growth phase reaching as high as 15.35% by September 30, 2022. This growth is interrupted by a significant decline down to approximately 6.63% by June 30, 2023, indicating a temporary reduction in profitability or efficiency in generating shareholder returns. After this dip, the ROE rises sharply, hitting a peak of 18.92% by June 30, 2024, before slightly retreating to 18.13% at the end of the reporting period. The pattern reveals strong overall growth in equity returns over the medium term, interspersed with a period of lower performance.
Summary Insights
The company's financial metrics denote evolving operational efficiency and capital structure adjustments. Return on Assets improved substantially after an initial phase of incomplete data, suggesting enhanced overall asset utilization. The Financial Leverage ratio's fluctuation points to strategic adjustments in financing, possibly balancing between debt reduction and capital expansion phases. Return on Equity follows a generally upward trend with a notable short-term decline, implying variability in profitability or equity efficiency but demonstrating strong recovery and growth over the longer term. Collectively, these trends imply an operational and financial evolution, with some periods of volatility but an overarching positive trajectory in returns to investors and asset management.

Three-Component Disaggregation of ROE

Comcast Corp., 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 distinct trends across key performance metrics over multiple quarters. The analysis below summarizes these patterns.

Net Profit Margin (%)
The net profit margin exhibits variability within the period analyzed. Starting from approximately 10.17% in early 2020, it demonstrated an upward movement reaching a peak near 12.73% by the end of 2020. This was followed by a decline to around 4.42%-5.4% during 2022, indicating a period of reduced profitability. Subsequently, the margin recovered substantially, ascending to levels surpassing 12% in the most recent quarters, indicating renewed profit efficiency.
Asset Turnover (ratio)
Asset turnover reflects a consistent upward trajectory from approximately 0.38 in early 2020 to about 0.48 by late 2022, indicating improved utilization of assets to generate sales. This metric plateaued thereafter, maintaining a steady ratio of about 0.46 across subsequent quarters through early 2025, suggesting stabilized asset efficiency.
Financial Leverage (ratio)
Financial leverage experienced a slight downward trend from 3.22 in early 2020 to around 2.87 by the end of 2021, implying a modest reduction in reliance on debt financing. However, a reversal occurred with leverage increasing to approximately 3.18 in the early quarters of 2022, followed by fluctuations between roughly 3.09 and 3.20 through 2025. This pattern indicates a return to higher leverage levels with moderate variability but remains within a narrow range.
Return on Equity (ROE) (%)
ROE shows considerable fluctuation within the observed timeframe. It increased from about 11.66% at the beginning of the period in 2020 to above 15% near the end of 2021, reflecting improved profitability and efficiency in equity use. This was followed by a noticeable decline to around 6.63%-7.74% in 2022, coinciding with the dip in net profit margin. Thereafter, ROE surged significantly, peaking near 18.92% in mid-2024 before slightly decreasing to approximately 18.13% in early 2025. This demonstrates a strong recovery and enhanced equity returns in the latter phases of the dataset.

Five-Component Disaggregation of ROE

Comcast Corp., 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 indicates several noteworthy trends and fluctuations across the periods analyzed.

Tax Burden
The tax burden ratio, available from the period ending March 31, 2020, exhibits some initial stability around 0.72 to 0.76 up to December 31, 2021. A decline is observed during 2022, dropping to approximately 0.55–0.57, followed by a recovery and gradual increase in 2023 and 2024, reaching a notably higher level of 0.85–0.86 by early 2025. This suggests shifting tax expense relative to pre-tax income over these periods.
Interest Burden
The interest burden ratio begins around 0.75 in early 2020, improving steadily to about 0.82 by the end of 2021 and maintaining a generally stable range between 0.81 and 0.84 thereafter. There is a slight declining trend towards late 2024 and early 2025, indicating subtle changes in interest costs relative to operating income.
EBIT Margin
EBIT margin shows a strong upward trend from approximately 17.85% in early 2020 to a peak exceeding 21% by the end of 2020. A notable decrease occurs in 2022, reaching lows near 11%, followed by a recovery to above 20% in 2023. Subsequently, there is a gradual decline through 2024 and into early 2025, settling near 18%. This fluctuation signifies volatility in earnings before interest and taxes as a percentage of revenue.
Asset Turnover
Asset turnover displays a consistent upward movement from 0.38 in early 2020, rising steadily to about 0.48 by the end of 2021. Afterward, it stabilizes around 0.46 through 2023 and 2024, maintaining this level into early 2025. The data implies an initial improvement in efficiency in utilizing assets to generate sales, followed by a plateau.
Financial Leverage
Financial leverage ratios show a downward trend from 3.22 in Q1 2020 to around 2.87 by the end of 2021, indicating decreasing reliance on debt. This trend reverses in 2022 with an increase to approximately 3.18, stabilizing around 3.1–3.2 during 2023 and 2024, and slightly tapering off towards 3.09 by early 2025. This reflects varying capital structure strategies over time.
Return on Equity (ROE)
ROE increases from approximately 11.66% in early 2020, peaking at over 15% by late 2021. It sharply declines to the 6.6–7.7% range during 2022, then rebounds strongly in 2023, reaching above 18%. The level remains elevated but exhibiting minor fluctuations through 2024, ending around 18.1% in early 2025. The ROE trend closely follows the EBIT margin pattern, showing sensitivity to profitability changes and financial leverage dynamics.

In summary, the analyzed periods reveal an overall pattern of profitability and efficiency improvements up to 2021, followed by significant setbacks in 2022 and a robust recovery in 2023. Asset utilization and financial leverage reflect strategic adjustments, while the tax and interest burdens demonstrate variability that influences net returns over time.


Two-Component Disaggregation of ROA

Comcast Corp., 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).


Net Profit Margin
The net profit margin demonstrates variability over the observed periods. Starting at 10.17% in the first quarter of 2020, it generally increased to reach a peak of approximately 12.73% by the end of 2020. Following this peak, the margin slightly declined but remained mostly stable around 11.5%-12.2% through mid-2022. A notable dip occurred in the fourth quarter of 2022, dropping to around 4.46%, followed by a recovery and increase to a higher stability range between 12.4% and 13.1% from early 2023 through the first quarter of 2025. This pattern suggests periods of both significant profitability enhancement as well as short-term pressure impacting profit margins.
Asset Turnover
The asset turnover ratio shows a steady and gradual increase initially, moving from 0.38 in March 2020 to a peak of 0.48 in December 2022. After reaching this level, the ratio stabilizes and remains virtually constant at 0.46 from early 2023 through the first quarter of 2025. This indicates an improvement in the efficiency with which assets are used to generate sales until late 2022, followed by a consistent use of assets thereafter, showing an established operational efficiency level.
Return on Assets (ROA)
The return on assets exhibits a correlated trend with both net profit margin and asset turnover as expected. The ROA starts at 3.85% at the beginning of 2020 and increases steadily to a peak of about 5.26% by late 2021. A sharp decline is observed in the fourth quarter of 2022, reducing the ROA to roughly 2.09%, followed by a recovery phase reaching levels above 5.8% during 2023. From 2023 onwards until early 2025, ROA remains stable in the 5.4%-6.1% range, suggesting that the company regained its asset profitability and maintained it consistently over the recent quarters.

Four-Component Disaggregation of ROA

Comcast Corp., 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).


Tax Burden
The tax burden ratio exhibits fluctuations over the observed periods. Starting from 0.76 in March 2021, it generally hovers around 0.72 to 0.75 through 2022. Notably, it declines sharply in December 2022 to 0.55, maintaining this lower level through mid-2023. Subsequently, it rises again, reaching 0.86 by the first quarter of 2025. This variation indicates changes in the effective tax rate impacting net income relative to earnings before tax.
Interest Burden
The interest burden ratio shows a moderate upward trend from 0.75 in March 2021 to a peak near 0.84 in June 2023, reflecting a slight improvement in earnings before interest and tax relative to earnings before tax. Following this, the ratio stabilizes around 0.82 to 0.83 until the end of the observed period, suggesting consistent interest expense management relative to earnings.
EBIT Margin
The EBIT margin demonstrates variability across the quarters. It increased from approximately 17.85% in March 2021 to over 21% by December 2021, indicating improved operational profitability. However, it then declined sharply to around 11% in late 2022, potentially reflecting operational challenges or increased costs. The margin recovered towards 20% in 2023 but showed a gradual decline thereafter, ending near 18% in the first quarter of 2025. This pattern suggests periods of both enhanced and constrained operational efficiency.
Asset Turnover
Asset turnover displays a consistent upward movement from 0.38 in March 2021 to a plateau of approximately 0.46 starting in late 2021 and maintained through the end of the data series. The steady rise reflects improved efficiency in generating revenue from assets, with stabilization indicating a mature operational asset base and stable revenue generation.
Return on Assets (ROA)
ROA mirrors the mixed trends seen in other metrics. Starting around 3.85% in early 2021, it increases to over 5.2% by late 2021, declines sharply to near 2.1% in late 2022, then rebounds strongly to around 5.8% through most of 2023 and 2024. It experiences a slight decrease but remains above 5% at the end of the period. The ROA movements correlate with fluctuations in profitability and asset utilization, indicating varying success in generating net income from assets through different quarters.

Disaggregation of Net Profit Margin

Comcast Corp., 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 notable trends concerning the tax burden, interest burden, EBIT margin, and net profit margin over multiple quarters from 2020 through 2025.

Tax Burden
The tax burden ratio exhibits fluctuations over the observed periods. Starting at approximately 0.76 in early 2020, it slightly decreased to about 0.72-0.73 during 2020-2021, followed by a significant decline to around 0.55-0.57 from late 2021 to early 2023. Subsequently, it rose back, reaching peaks of approximately 0.74-0.75 in late 2023 and remaining stable in 2024 before increasing sharply to 0.85-0.86 by early 2025. This pattern suggests variability in tax expenses relative to pre-tax profits, with potential impacts from tax policy changes or adjustments in tax planning strategies.
Interest Burden
The interest burden ratio shows an initial improvement from 0.75 to approximately 0.82 between early 2020 and late 2021, indicating a reduction in interest expenses relative to operating profit. Post-2021, the ratio declines to around 0.71-0.74, suggesting some increase in interest expense burden, before increasing again to levels near 0.83-0.84 in 2023. It remains relatively stable near 0.81-0.83 through 2024 and slightly decreases towards early 2025. Overall, the interest burden reflects moderate volatility but stays within a narrow range, implying consistency in debt servicing costs relative to EBIT.
EBIT Margin
The EBIT margin demonstrates considerable volatility over the quarters. It rises from below 18% in early 2020 to a peak exceeding 21% by late 2020, indicating improved operational profitability. However, a marked decline follows, reaching a low near 11% during late 2021 to early 2023. After this trough, margins recover strongly, climbing back to approximately 20-20.5% in 2023, but experience a gradual decline through 2024 and into early 2025, settling near 18%. This variability suggests fluctuations in operating efficiency or revenue and cost dynamics possibly linked to market conditions or strategic initiatives affecting core business profitability.
Net Profit Margin
Net profit margin follows a pattern somewhat aligned with EBIT margin, albeit with greater fluctuations. It increases from about 10% in early 2020 to nearly 13% by late 2020 and early 2021, reflecting improved bottom-line profitability. Then, it dips significantly to around 4.4-5.4% during late 2021 to early 2023, indicating a period of reduced net earnings relative to revenue. A robust recovery occurs afterwards, with margins rebounding to about 12-13% through late 2023 and early 2024. Some minor variation occurs leading into 2025, with net margins remaining strong but showing slight declines. These changes point to varying influences on net earnings, such as tax effects, interest expenses, or non-operating items influencing overall profitability.

In summary, the data portrays a cycle of strong operational and net profitability in early phases, interrupted by a period of margin contraction in 2021-2023, followed by recovery and moderate margins stabilization. The tax burden shows significant variability that may influence net margin trends, while the interest burden remains relatively consistent, suggesting stable financing costs. These patterns reflect dynamic financial performance with notable sensitivity to external and internal factors impacting costs, taxation, and operational efficiency.