Stock Analysis on Net
Stock Analysis on Net

AmerisourceBergen Corp. (NYSE:ABC)

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

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

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

AmerisourceBergen Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2023 246.27% = 2.76% × 89.18
Mar 31, 2023 573.99% = 2.75% × 208.62
Dec 31, 2022 — = 2.99% × —
Sep 30, 2022 — = 3.00% × —
Jun 30, 2022 821.13% = 3.22% × 254.90
Mar 31, 2022 313.81% = 3.01% × 104.14
Dec 31, 2021 668.28% = 2.80% × 238.37
Sep 30, 2021 689.46% = 2.69% × 256.71
Jun 30, 2021 -9,862.07% = -6.69% × 1,473.34
Mar 31, 2021 — = -7.97% × —
Dec 31, 2020 — = -7.03% × —
Sep 30, 2020 — = -7.70% × —
Jun 30, 2020 40.70% = 3.85% × 10.57
Mar 31, 2020 44.07% = 3.76% × 11.71
Dec 31, 2019 21.98% = 1.62% × 13.54
Sep 30, 2019 29.71% = 2.18% × 13.61
Jun 30, 2019 31.98% = 2.48% × 12.87
Mar 31, 2019 31.83% = 2.40% × 13.29
Dec 31, 2018 39.04% = 3.03% × 12.88
Sep 30, 2018 56.55% = 4.40% × 12.84
Jun 30, 2018 34.88% = 2.82% × 12.37
Mar 31, 2018 26.83% = 2.23% × 12.05
Dec 31, 2017 34.06% = 2.69% × 12.65
Sep 30, 2017 17.66% = 1.03% × 17.11
Jun 30, 2017 — = — × 13.57
Mar 31, 2017 — = — × 13.60
Dec 31, 2016 — = — × 16.03

Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).

The primary reason for the decrease in return on equity ratio (ROE) over Q3 2023 is the decrease in financial leverage ratio.

Three-Component Disaggregation of ROE

AmerisourceBergen Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2023 246.27% = 0.66% × 4.16 × 89.18
Mar 31, 2023 573.99% = 0.65% × 4.21 × 208.62
Dec 31, 2022 — = 0.72% × 4.18 × —
Sep 30, 2022 — = 0.71% × 4.22 × —
Jun 30, 2022 821.13% = 0.78% × 4.13 × 254.90
Mar 31, 2022 313.81% = 0.75% × 4.01 × 104.14
Dec 31, 2021 668.28% = 0.73% × 3.84 × 238.37
Sep 30, 2021 689.46% = 0.72% × 3.73 × 256.71
Jun 30, 2021 -9,862.07% = -1.83% × 3.65 × 1,473.34
Mar 31, 2021 — = -1.91% × 4.18 × —
Dec 31, 2020 — = -1.66% × 4.24 × —
Sep 30, 2020 — = -1.80% × 4.29 × —
Jun 30, 2020 40.70% = 0.84% × 4.57 × 10.57
Mar 31, 2020 44.07% = 0.85% × 4.43 × 11.71
Dec 31, 2019 21.98% = 0.36% × 4.55 × 13.54
Sep 30, 2019 29.71% = 0.48% × 4.58 × 13.61
Jun 30, 2019 31.98% = 0.54% × 4.61 × 12.87
Mar 31, 2019 31.83% = 0.53% × 4.51 × 13.29
Dec 31, 2018 39.04% = 0.69% × 4.40 × 12.88
Sep 30, 2018 56.55% = 0.99% × 4.46 × 12.84
Jun 30, 2018 34.88% = 0.66% × 4.27 × 12.37
Mar 31, 2018 26.83% = 0.54% × 4.15 × 12.05
Dec 31, 2017 34.06% = 0.63% × 4.27 × 12.65
Sep 30, 2017 17.66% = 0.24% × 4.34 × 17.11
Jun 30, 2017 — = — × — × 13.57
Mar 31, 2017 — = — × — × 13.60
Dec 31, 2016 — = — × — × 16.03

Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).

The primary reason for the decrease in return on equity ratio (ROE) over Q3 2023 is the decrease in financial leverage ratio.

Two-Component Disaggregation of ROA

AmerisourceBergen Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2023 2.76% = 0.66% × 4.16
Mar 31, 2023 2.75% = 0.65% × 4.21
Dec 31, 2022 2.99% = 0.72% × 4.18
Sep 30, 2022 3.00% = 0.71% × 4.22
Jun 30, 2022 3.22% = 0.78% × 4.13
Mar 31, 2022 3.01% = 0.75% × 4.01
Dec 31, 2021 2.80% = 0.73% × 3.84
Sep 30, 2021 2.69% = 0.72% × 3.73
Jun 30, 2021 -6.69% = -1.83% × 3.65
Mar 31, 2021 -7.97% = -1.91% × 4.18
Dec 31, 2020 -7.03% = -1.66% × 4.24
Sep 30, 2020 -7.70% = -1.80% × 4.29
Jun 30, 2020 3.85% = 0.84% × 4.57
Mar 31, 2020 3.76% = 0.85% × 4.43
Dec 31, 2019 1.62% = 0.36% × 4.55
Sep 30, 2019 2.18% = 0.48% × 4.58
Jun 30, 2019 2.48% = 0.54% × 4.61
Mar 31, 2019 2.40% = 0.53% × 4.51
Dec 31, 2018 3.03% = 0.69% × 4.40
Sep 30, 2018 4.40% = 0.99% × 4.46
Jun 30, 2018 2.82% = 0.66% × 4.27
Mar 31, 2018 2.23% = 0.54% × 4.15
Dec 31, 2017 2.69% = 0.63% × 4.27
Sep 30, 2017 1.03% = 0.24% × 4.34
Jun 30, 2017 — = — × —
Mar 31, 2017 — = — × —
Dec 31, 2016 — = — × —

Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).

The primary reason for the increase in return on assets ratio (ROA) over Q3 2023 is the increase in profitability measured by net profit margin ratio.