DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.
Two-Component Disaggregation of ROE
Cisco Systems Inc., decomposition of ROE
Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).
The primary reason for the decrease in return on equity ratio (ROE) over 2024 year is the decrease in profitability measured by return on assets ratio (ROA).
Three-Component Disaggregation of ROE
Cisco Systems Inc., decomposition of ROE
Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).
The primary reason for the decrease in return on equity ratio (ROE) over 2024 year is the decrease in efficiency measured by asset turnover ratio.
Five-Component Disaggregation of ROE
Cisco Systems Inc., decomposition of ROE
Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).
The primary reason for the decrease in return on equity ratio (ROE) over 2024 year is the decrease in efficiency measured by asset turnover ratio.
Two-Component Disaggregation of ROA
Cisco Systems Inc., decomposition of ROA
Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).
The primary reason for the decrease in return on assets ratio (ROA) over 2024 year is the decrease in asset turnover ratio.
Four-Component Disaggregation of ROA
Cisco Systems Inc., decomposition of ROA
Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).
The primary reason for the decrease in return on assets ratio (ROA) over 2024 year is the decrease in efficiency measured by asset turnover ratio.
Disaggregation of Net Profit Margin
Cisco Systems Inc., decomposition of net profit margin ratio
Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).
The primary reason for the decrease in net profit margin ratio over 2024 year is the decrease in operating profitability measured by EBIT margin ratio.