Stock Analysis on Net

HCA Healthcare Inc. (NYSE:HCA)

$22.49

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

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

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 Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

HCA Healthcare Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
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 = ×

Based on: 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 data exhibits a clear progression in the profitability and leverage metrics over the observed quarterly periods.

Return on Assets (ROA)
The ROA shows a consistent upward trend starting from 6.06% in March 2017 and reaching a peak of 13.71% by December 2021. From 2017 through 2019, the ROA rose steadily from slightly above 6% to nearly 10%, indicating improved efficiency in asset utilization to generate profits. Despite minor fluctuations around the 6.6% to 7.9% range in 2020, the measure resumed upward momentum in 2021, surpassing previous highs and suggesting strengthened operational performance.
Financial Leverage
The financial leverage ratio is reported only in later periods, specifically from March 2021 onwards, with values at 83.02 in March 2021 and a sharp increase to 191.4 in June 2021. This sizable rise could indicate a heavier reliance on debt or other liabilities to finance assets, reflecting a significant change in the capital structure during this time frame.
Return on Equity (ROE)
The ROE values emerge starting in 2020, with extremely high ratios reported: 656.29% in March 2021 and an exceptional surge to 1860.73% in June 2021. Such abnormally large figures suggest extraordinary circumstances affecting equity returns, potentially driven by a combination of increased leverage and improved net income. However, this level suggests that a small equity base could be amplifying the percentage results, warranting further investigation into balance sheet changes or one-time effects.

Overall, the data reflects increasing profitability metrics evident in the ROA and, later, significantly elevated returns on equity coinciding with a surge in financial leverage. This pattern indicates strategic shifts in financing leading to magnified equity returns, albeit accompanied by a substantial increase in leverage, which could imply increased financial risk.


Three-Component Disaggregation of ROE

HCA Healthcare Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
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 = × ×

Based on: 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 analysis of the quarterly financial data reveals distinct trends across profitability, efficiency, and leverage metrics over the observed periods.

Net Profit Margin (%)

Starting from March 2018, net profit margin showed a generally positive trajectory with some fluctuations. It increased from 5.08% in March 2018, rising steadily to a peak of 11.84% in December 2021. The margin displayed minor declines in some quarters such as June 2019 and March 2020 but maintained an overall upward trend. This indicates progressively improved profitability relative to revenue over the period analyzed.

Asset Turnover (ratio)

The asset turnover ratio remained relatively stable with slight variations. Beginning at 1.19 in March 2018, it experienced a gradual decrease to a low of 1.00 in December 2020. Subsequently, it recovered towards 1.16 by December 2021. The changes suggest fluctuating efficiency in using assets to generate sales, though remaining around the one-to-one ratio benchmark.

Financial Leverage (ratio)

Data on financial leverage is available only for the later periods. It shows a significant increase from 83.02 in March 2021 to 191.4 in June 2021. The subsequent quarters contain missing data hence the trend cannot be conclusively followed beyond this point. The sharp rise indicates a markedly higher use of debt or liabilities relative to equity in the capital structure during this timeframe.

Return on Equity (ROE) (%)

Return on equity figures are reported only starting from March 2021, revealing extraordinarily high values of 656.29% and a peak of 1860.73% in June 2021, with some subsequent missing data. These unusually elevated numbers may reflect non-recurring items, accounting adjustments, or effects of extreme leverage rather than typical operating performance. Further contextual information is required to interpret these values fully.

Overall, the data suggest improving profitability margins and stable asset utilization efficiency in the earlier years, coupled with a notable increase in leverage and very high ROE readings in the most recent periods. The leverage and ROE spikes merit further investigation to assess sustainability and underlying causes.


Five-Component Disaggregation of ROE

HCA Healthcare Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
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 = × × × ×

Based on: 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 financial data reveals several key trends in profitability, efficiency, leverage, and returns over the analyzed periods.

Profitability Metrics

The Tax Burden ratio improved steadily from 0.57 in early 2018 to a more stable range around 0.77-0.78 from 2019 through early 2022, indicating a relatively consistent effective tax rate during these years.

The Interest Burden ratio showed a gradual increase from 0.7 in the first quarter of 2018 to approximately 0.85 by the end of 2021 and early 2022, signaling a reduction in interest expense relative to earnings before interest and taxes, or improved interest coverage over time.

The EBIT Margin exhibited some fluctuations but generally maintained a range between approximately 12.5% and 14% during 2017 to 2019. Subsequently, it dipped to about 11-12% during parts of 2020, likely reflecting operational challenges, but then increased markedly to a peak of over 17% by late 2021, before slightly retreating to around 17.5% in early 2022. This suggests improved operating profitability in the later periods.

Efficiency Indicators

Asset Turnover remained relatively stable near 1.19 during 2017 and early 2018, followed by a decline to just above 1.0 through 2020. The ratio then rebounded to about 1.16 by the end of 2021, indicating some recovery in the efficiency of asset use to generate sales after a period of slower turnover.

Leverage and Return on Equity

Financial Leverage data is limited but shows a substantial increase from 83.02 in early 2021 to 191.4 in mid-2021. This drastic rise could reflect an increase in debt or other liabilities relative to equity during that period.

Return on Equity (ROE) values reported are extremely elevated, at 656.29% in early 2021 and soaring to 1860.73% by mid-2021. These outlier figures coincide with the large leverage increase observed, implying the company might have experienced significant financial structuring changes that amplified equity returns, though such extreme values may warrant further investigation for accuracy or underlying contributing factors.

Overall, the company demonstrated improving operational profitability and interest coverage, some volatility in operating efficiency, and sharp fluctuations in leverage and equity returns in the most recent periods. These patterns reflect a combination of operational resilience and potentially significant financial strategy shifts during the evaluated timeline.


Two-Component Disaggregation of ROA

HCA Healthcare Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
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 = ×

Based on: 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 analysis of the quarterly financial metrics reveals distinct patterns and trends over the period spanning from the first quarter of 2017 through the first quarter of 2022.

Net Profit Margin
The net profit margin data begins from the first quarter of 2018, showing a generally positive and upward trend. Initially recorded at 5.08%, it increased steadily with minor fluctuations through subsequent quarters. A noticeable growth occurred from the end of 2019 onwards, with values rising from 6.83% to a peak of 11.84% in the fourth quarter of 2021. The margin slightly declined to 11.4% in the first quarter of 2022 but remained significantly higher than earlier years, indicating improving profitability over time.
Asset Turnover
Asset turnover ratios, available from the first quarter of 2018, exhibit relative stability with modest variations. Starting at 1.19 in early 2018, the ratio fluctuated slightly, declining to a low of 1.00 in the fourth quarter of 2020, suggesting a temporary decrease in how effectively assets generated revenue. However, it recovered in subsequent quarters, reaching around 1.14 by the first quarter of 2022. Overall, the asset turnover remains near the 1.1 to 1.2 range, reflecting consistent asset utilization efficiency.
Return on Assets (ROA)
The return on assets demonstrates a clear upward trajectory over the period analyzed. Beginning at 6.06% in the first quarter of 2018, ROA increased steadily, reaching 9.66% by the end of 2018. After a slight dip during 2020, with values around the 6.66% to 6.86% range, the ratio surged again from late 2020 through 2021. It peaked at 13.71% in the fourth quarter of 2021 before a minor decrease to 13.04% in the first quarter of 2022. This trend suggests marked improvements in the profitability generated from the company’s asset base.

In summary, the profitability measures, including net profit margin and return on assets, have experienced considerable improvement, particularly from 2019 onward. Asset turnover has remained relatively stable, with some temporary reductions that were later recovered. These patterns collectively imply enhanced operational efficiency and stronger profit generation capability during the analyzed timeframe.


Four-Component Disaggregation of ROA

HCA Healthcare Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
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 = × × ×

Based on: 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).


Tax Burden
The tax burden ratio data begins from the first quarter of 2018, showing a generally increasing trend until the end of 2018, peaking at around 0.80. Thereafter, it stabilizes around 0.77 to 0.78, maintaining this level through early 2022, indicating consistent tax efficiency over the period.
Interest Burden
The interest burden ratio starts at 0.70 in early 2018, remaining relatively stable up to early 2020, with slight fluctuations between 0.69 and 0.73. From mid-2020 onwards, there is a noticeable upward trend, reaching 0.85 by early 2022, suggesting improved interest expense management or reduced interest costs relative to operating income.
EBIT Margin
The EBIT margin exhibits modest growth from 12.71% in the first quarter of 2018 to a low around 11.16% in the first quarter of 2020, potentially reflecting operational pressures. It then progressively improves, peaking at 18.10% in the fourth quarter of 2021 before slightly declining to 17.52% by early 2022. This overall increase indicates enhanced profitability and operational efficiency.
Asset Turnover
Asset turnover ratios show moderate fluctuations throughout the period, starting near 1.19 in early 2018 and experiencing a decline to about 1.00 by mid-2020. Subsequently, a recovery trend is visible, with ratios rising back above 1.10 by the end of 2021 and stabilizing around 1.14 in early 2022. This pattern suggests a temporary decrease in asset utilization, followed by improvement in asset efficiency in later periods.
Return on Assets (ROA)
Return on assets displays notable growth over the period analyzed. Beginning at approximately 6.06% in early 2018, ROA rises steadily to a peak exceeding 13% towards the end of 2021, before experiencing a slight decrease to 13.04% in early 2022. This upward trend is indicative of increased overall profitability relative to asset base, supported by improved operational margins and asset use efficiency.

Disaggregation of Net Profit Margin

HCA Healthcare Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
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 = × ×

Based on: 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).


Tax Burden
The tax burden ratio shows a gradual increase from 0.57 in March 2018 to a peak around 0.8 in March 2019. Subsequently, it stabilizes, fluctuating narrowly between 0.76 and 0.78 through to March 2022. This indicates an initial rise in the proportion of earnings retained after tax, followed by a period of consistent tax impact on profitability.
Interest Burden
The interest burden ratio exhibits a modest upward trend, starting from 0.7 in March 2018 and gradually increasing to 0.85 by March 2022. The ratio remains relatively stable in the earlier periods and then accelerates from around mid-2020, suggesting a reduction in interest expenses relative to earnings before interest and taxes over time.
EBIT Margin
The EBIT margin fluctuates moderately in the initial periods, with values hovering around 13% to 14% between March 2018 and March 2021. A notable increase occurs from mid-2021 onward, reaching a high of 18.1% in December 2021 before slightly declining to 17.52% in March 2022. This indicates an enhancement in operational efficiency and profitability before interest and taxes in recent periods.
Net Profit Margin
The net profit margin demonstrates a clear upward trajectory over the period analyzed. Starting at just above 5% in early 2018, it experiences steady growth, particularly from 2020 onwards, reaching a peak of 11.84% in December 2021, with a slight decrease to 11.4% by March 2022. This improvement reflects enhancing overall profitability after all expenses, including taxes and interest.