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
Lowe’s Cos. Inc., decomposition of ROE (quarterly data)
Based on: 10-K (reporting date: 2024-02-02), 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04).
Three-Component Disaggregation of ROE
Lowe’s Cos. Inc., decomposition of ROE (quarterly data)
Based on: 10-K (reporting date: 2024-02-02), 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04).
Two-Component Disaggregation of ROA
Lowe’s Cos. Inc., decomposition of ROA (quarterly data)
Based on: 10-K (reporting date: 2024-02-02), 10-Q (reporting date: 2023-11-03), 10-Q (reporting date: 2023-08-04), 10-Q (reporting date: 2023-05-05), 10-K (reporting date: 2023-02-03), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-Q (reporting date: 2022-04-29), 10-K (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-05-01), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-11-01), 10-Q (reporting date: 2019-08-02), 10-Q (reporting date: 2019-05-03), 10-K (reporting date: 2019-02-01), 10-Q (reporting date: 2018-11-02), 10-Q (reporting date: 2018-08-03), 10-Q (reporting date: 2018-05-04).
The primary reason for the increase in return on assets ratio (ROA) over Q4 2024 is the increase in profitability measured by net profit margin ratio.