DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data
Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.
Two-Component Disaggregation of ROE
Apple Inc., decomposition of ROE (quarterly data)
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
The primary reason for the decrease in return on equity ratio (ROE) over Q1 2024 is the decrease in financial leverage ratio.
Three-Component Disaggregation of ROE
Apple Inc., decomposition of ROE (quarterly data)
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
The primary reason for the decrease in return on equity ratio (ROE) over Q1 2024 is the decrease in financial leverage ratio.
Two-Component Disaggregation of ROA
Apple Inc., decomposition of ROA (quarterly data)
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-24), 10-Q (reporting date: 2022-06-25), 10-Q (reporting date: 2022-03-26), 10-Q (reporting date: 2021-12-25), 10-K (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-Q (reporting date: 2020-12-26), 10-K (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
The primary reason for the increase in return on assets ratio (ROA) over Q1 2024 is the increase in profitability measured by net profit margin ratio.