Stock Analysis on Net

IQVIA Holdings Inc. (NYSE:IQV)

$22.49

This company has been moved to the archive! The financial data has not been updated since November 1, 2023.

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

IQVIA Holdings Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2022 = ×
Dec 31, 2021 = ×
Dec 31, 2020 = ×
Dec 31, 2019 = ×
Dec 31, 2018 = ×

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


Return on Assets (ROA)
The return on assets exhibits an upward trend over the analyzed period. Starting at 1.15% in 2018, it declined slightly to 0.82% in 2019 but recovered to 1.14% in 2020. From 2020 onwards, there was a significant increase, reaching 3.91% in 2021 and further ascending to 4.31% in 2022. This indicates improved efficiency in asset utilization to generate profits.
Financial Leverage
Financial leverage shows a steady increase throughout the five-year span. Beginning at a ratio of 3.36 in 2018, it rose progressively to 3.87 in 2019, then to 4.09 in 2020 and 2021, maintaining level at 4.09 before increasing again to 4.39 in 2022. This suggests a growing reliance on debt financing, which may impact the company’s risk profile.
Return on Equity (ROE)
Return on equity demonstrates a marked improvement. From a low base of 3.86% in 2018, the metric declined to 3.18% in 2019 but rebounded to 4.65% in 2020. A significant escalation occurred in 2021 with ROE reaching 15.99%, followed by a further increase to 18.92% in 2022. The sharp rise in ROE reflects enhanced profitability relative to shareholders' equity, potentially driven by operational effectiveness combined with increased financial leverage.

Three-Component Disaggregation of ROE

IQVIA Holdings Inc., decomposition of ROE

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

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


The financial data reveals several notable trends across the analyzed periods.

Net Profit Margin
The net profit margin experienced a decline from 2.49% in 2018 to 1.72% in 2019, followed by a recovery to 2.46% in 2020. A significant improvement is observed thereafter, reaching 6.96% in 2021 and further increasing to 7.57% in 2022. This pattern indicates an initial decrease in profitability, followed by a strong upward trend in profit efficiency relative to revenue in recent years.
Asset Turnover
Asset turnover demonstrated relative stability over the period, fluctuating slightly from 0.46 in 2018 to 0.48 in 2019 and returning to 0.46 in 2020. An upward trend emerges in 2021 and 2022, with the ratio increasing to 0.56 and 0.57, respectively. This suggests a gradual improvement in the company's efficiency in generating sales from its assets.
Financial Leverage
Financial leverage has shown a consistent increase over the years, starting at 3.36 in 2018 and rising to 3.87 in 2019, then to 4.09 in 2020 and 2021, and further to 4.39 in 2022. This emphasizes a growing reliance on debt in the company's capital structure, potentially amplifying returns but also increasing financial risk.
Return on Equity (ROE)
Return on equity presents a marked upward trajectory, with a slight decline from 3.86% in 2018 to 3.18% in 2019, followed by an increase to 4.65% in 2020. A significant jump is observed in 2021, rising to 15.99%, and continuing upward to 18.92% in 2022. This increase reflects enhanced profitability and effective use of equity, likely influenced by improved profit margins and greater financial leverage.

Overall, the data indicates that while profitability was relatively modest in the earlier years, there has been a substantial improvement in recent periods. The company has leveraged increased financial leverage and improved asset utilization to enhance returns to equity holders. Nonetheless, the rising financial leverage suggests a higher risk profile that should be monitored carefully.


Five-Component Disaggregation of ROE

IQVIA Holdings Inc., decomposition of ROE

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

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


The financial data indicates several notable trends over the five-year period under review.

Tax Burden
The tax burden ratio exhibits some variability, starting at 0.81 in 2018 and declining sharply to 0.62 in 2019. It increased again to 0.79 in 2020, peaked at 0.86 in 2021, and then slightly decreased to 0.81 in 2022, suggesting fluctuating effective tax rates impacting net profitability.
Interest Burden
The interest burden remained relatively stable with a slight decline from 0.43 in 2018 to 0.41 in 2019. From 2020 onwards, a marked improvement is observed, increasing to 0.46 and then substantially to 0.75 in 2021 and 0.76 in 2022, indicating improved efficiency in managing interest expenses relative to earnings before interest and taxes.
EBIT Margin
EBIT margin shows a consistent upward trend over the period. It started at 7.03% in 2018 and remained fairly steady through 2020. A significant increase occurred from 2020 onwards, reaching 10.84% in 2021 and further rising to 12.26% in 2022, highlighting enhanced operational profitability and improved cost management.
Asset Turnover
Asset turnover ratios reflect a moderate increase, beginning at 0.46 in 2018, slightly rising to 0.48 in 2019, then stabilizing at 0.46 in 2020 before advancing to 0.56 in 2021 and 0.57 in 2022. This indicates a gradual improvement in the company's efficiency in generating sales from its assets.
Financial Leverage
Financial leverage rose steadily from 3.36 in 2018 to 3.87 in 2019, then to 4.09 in 2020 and 2021, followed by another increase to 4.39 in 2022. This pattern reflects growing reliance on debt or other liabilities relative to equity, which may enhance returns but also increases financial risk.
Return on Equity (ROE)
ROE experienced notable growth over the period. After a decline from 3.86% in 2018 to 3.18% in 2019, it rose to 4.65% in 2020 and then surged to 15.99% in 2021, reaching 18.92% in 2022. This strong upward trajectory indicates significantly improved profitability relative to shareholder equity, likely driven by combined effects of better operational margins, asset turnover, and increased financial leverage.

Two-Component Disaggregation of ROA

IQVIA Holdings Inc., decomposition of ROA

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

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


Net Profit Margin
The net profit margin exhibits a fluctuating but overall upward trend from 2018 through 2022. It started at 2.49% in 2018, decreased to 1.72% in 2019, and rebounded to 2.46% in 2020. A significant increase occurred in 2021, with the margin rising to 6.96%, followed by a modest increase to 7.57% in 2022. This indicates improving profitability efficiency over the analysed period, especially in the recent two years.
Asset Turnover
Asset turnover has remained relatively stable with a slight upward trend over the five-year span. Beginning at 0.46 in 2018, it increased marginally to 0.48 in 2019, returned to 0.46 in 2020, and then improved to 0.56 in 2021 and 0.57 in 2022. This suggests a gradual enhancement in the efficiency of asset use to generate revenue.
Return on Assets (ROA)
Return on assets shows a pattern closely aligned with that of net profit margin. The ROA started at 1.15% in 2018, declined to 0.82% in 2019, then returned to 1.14% in 2020. It experienced a marked increase in 2021 to 3.91% and further improved to 4.31% in 2022. This reflects a growing effectiveness in generating profits from the company’s asset base, notably accelerating in the last two years.

Four-Component Disaggregation of ROA

IQVIA Holdings Inc., decomposition of ROA

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

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


Tax Burden
The tax burden ratio demonstrates some fluctuation over the observed period, starting at 0.81 in 2018 and dropping to a low of 0.62 in 2019. It then increases again, reaching 0.86 in 2021 before slightly decreasing to 0.81 in 2022. This pattern suggests variability in the effective tax rates impacting net profitability, with a notable dip in 2019.
Interest Burden
The interest burden ratio remained relatively stable around the low 0.40s in 2018 and 2019, with a slight increase to 0.46 in 2020. A marked improvement is visible in 2021 and 2022 where the ratio rises to approximately 0.75 and 0.76 respectively. This indicates a reduced interest expense burden relative to earnings before interest and taxes, potentially reflecting lower interest costs or improved operational earnings.
EBIT Margin
The EBIT margin shows a consistent upward trend from 7.03% in 2018 to 12.26% in 2022. While margins were relatively stable between 2018 and 2020, there is a sharp increase from 2020 onwards, culminating in the highest margin in 2022. This suggests an improvement in operational efficiency or pricing power over the more recent years.
Asset Turnover
Asset turnover ratios exhibit minor fluctuations, beginning at 0.46 in 2018, peaking slightly to 0.48 in 2019, dipping back to 0.46 in 2020, and increasing further to 0.56 in 2021 and 0.57 in 2022. The gradual rise post-2020 reflects improved asset utilization to generate sales.
Return on Assets (ROA)
ROA displays a significant growth trajectory, starting from 1.15% in 2018, dropping to 0.82% in 2019, then ascending slightly to 1.14% in 2020. From 2020 onwards, ROA climbs sharply to 3.91% in 2021 and 4.31% in 2022. This upward trend indicates enhanced overall profitability relative to asset base, combining the effects of improved EBIT margin and asset turnover, alongside reduced burdens.

Disaggregation of Net Profit Margin

IQVIA Holdings Inc., decomposition of net profit margin ratio

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

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


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

Tax Burden
The tax burden ratio demonstrated variability during the period, decreasing significantly from 0.81 in 2018 to a low of 0.62 in 2019, indicating a lower proportion of pre-tax income paid in taxes that year. Subsequently, it rose again to 0.79 in 2020 and peaked at 0.86 in 2021, before declining slightly to 0.81 in 2022. Overall, this reflects fluctuating effective tax rates affecting net profitability.
Interest Burden
The interest burden ratio showed a gradual decline from 0.43 in 2018 to 0.41 in 2019, indicating a slight reduction in interest expense relative to operating profit. However, the ratio improved markedly to 0.46 in 2020 and then sharply rose to 0.75 in 2021 and 0.76 in 2022. This indicates that interest expenses became less significant as a cost relative to operating profit in the latter years.
EBIT Margin
The EBIT margin remained relatively stable around the 7% mark from 2018 through 2020, with a minor dip from 7.03% in 2018 to 6.75% in 2020. However, there was a substantial improvement beginning in 2021 when the margin increased to 10.84%, followed by further growth to 12.26% in 2022. This upward trend indicates enhanced operational efficiency or improved pricing power leading to stronger earnings before interest and taxes.
Net Profit Margin
The net profit margin exhibited a similar pattern, declining from 2.49% in 2018 to 1.72% in 2019, before recovering to 2.46% in 2020. From 2020 onwards, a pronounced increase took place, with net margins rising to 6.96% in 2021 and 7.57% in 2022. This development suggests improved overall profitability, likely influenced by higher operational profits combined with manageable tax and interest expenses.

In summary, the financial ratios indicate a period of relatively weak profitability in 2019 and 2020, followed by a significant recovery and strengthening in 2021 and 2022. The higher EBIT and net profit margins, together with improved interest burden ratios, point towards effective cost control, stronger operational performance, and favorable financing conditions in recent years.