Stock Analysis on Net
Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

デュポンの分析: ROE、ROA、純利益率の内訳 
四半期データ

Microsoft Excel

ROE分解では、純利益を株主資本で割ったものを構成比率の積として表します。

ROEを2つのコンポーネントに分解

Cisco Systems Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2025/07/26 21.73% = 8.32% × 2.61
2025/04/26 21.32% = 8.17% × 2.61
2025/01/25 20.18% = 7.57% × 2.67
2024/10/26 20.75% = 7.62% × 2.72
2024/07/27 22.70% = 8.29% × 2.74
2024/04/27 26.47% = 9.85% × 2.69
2024/01/27 29.06% = 13.29% × 2.19
2023/10/28 30.04% = 13.75% × 2.18
2023/07/29 28.44% = 12.38% × 2.30
2023/04/29 27.12% = 11.76% × 2.31
2023/01/28 27.25% = 11.79% × 2.31
2022/10/29 28.56% = 12.36% × 2.31
2022/07/30 29.70% = 12.57% × 2.36
2022/04/30 29.72% = 12.94% × 2.30
2022/01/29 29.94% = 12.54% × 2.39
2021/10/30 26.69% = 11.87% × 2.25
2021/07/31 25.66% = 10.86% × 2.36
2021/05/01 25.41% = 10.88% × 2.34
2021/01/23 25.89% = 10.60% × 2.44
2020/10/24 27.42% = 11.01% × 2.49

レポートに基づく: 10-K (報告日: 2025-07-26), 10-Q (報告日: 2025-04-26), 10-Q (報告日: 2025-01-25), 10-Q (報告日: 2024-10-26), 10-K (報告日: 2024-07-27), 10-Q (報告日: 2024-04-27), 10-Q (報告日: 2024-01-27), 10-Q (報告日: 2023-10-28), 10-K (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-Q (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-K (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-Q (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-K (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-Q (報告日: 2021-01-23), 10-Q (報告日: 2020-10-24).

ROEを3つの要素に分解

Cisco Systems Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2025/07/26 21.73% = 17.97% × 0.46 × 2.61
2025/04/26 21.32% = 17.60% × 0.46 × 2.61
2025/01/25 20.18% = 16.96% × 0.45 × 2.67
2024/10/26 20.75% = 17.73% × 0.43 × 2.72
2024/07/27 22.70% = 19.18% × 0.43 × 2.74
2024/04/27 26.47% = 21.88% × 0.45 × 2.69
2024/01/27 29.06% = 23.49% × 0.57 × 2.19
2023/10/28 30.04% = 23.40% × 0.59 × 2.18
2023/07/29 28.44% = 22.13% × 0.56 × 2.30
2023/04/29 27.12% = 20.89% × 0.56 × 2.31
2023/01/28 27.25% = 21.26% × 0.55 × 2.31
2022/10/29 28.56% = 22.00% × 0.56 × 2.31
2022/07/30 29.70% = 22.91% × 0.55 × 2.36
2022/04/30 29.72% = 23.28% × 0.56 × 2.30
2022/01/29 29.94% = 22.94% × 0.55 × 2.39
2021/10/30 26.69% = 22.44% × 0.53 × 2.25
2021/07/31 25.66% = 21.26% × 0.51 × 2.36
2021/05/01 25.41% = 20.92% × 0.52 × 2.34
2021/01/23 25.89% = 21.09% × 0.50 × 2.44
2020/10/24 27.42% = 21.76% × 0.51 × 2.49

レポートに基づく: 10-K (報告日: 2025-07-26), 10-Q (報告日: 2025-04-26), 10-Q (報告日: 2025-01-25), 10-Q (報告日: 2024-10-26), 10-K (報告日: 2024-07-27), 10-Q (報告日: 2024-04-27), 10-Q (報告日: 2024-01-27), 10-Q (報告日: 2023-10-28), 10-K (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-Q (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-K (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-Q (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-K (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-Q (報告日: 2021-01-23), 10-Q (報告日: 2020-10-24).

ROEを5つの要素に分解

Cisco Systems Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担率 × 利息負担率 × EBITマージン率 × 資産回転率 × 財務レバレッジ比率
2025/07/26 21.73% = 0.92 × 0.87 × 22.40% × 0.46 × 2.61
2025/04/26 21.32% = 0.93 × 0.86 × 21.83% × 0.46 × 2.61
2025/01/25 20.18% = 0.94 × 0.86 × 21.01% × 0.45 × 2.67
2024/10/26 20.75% = 0.93 × 0.88 × 21.47% × 0.43 × 2.72
2024/07/27 22.70% = 0.84 × 0.92 × 24.61% × 0.43 × 2.74
2024/04/27 26.47% = 0.85 × 0.95 × 27.11% × 0.45 × 2.69
2024/01/27 29.06% = 0.84 × 0.97 × 28.80% × 0.57 × 2.19
2023/10/28 30.04% = 0.83 × 0.97 × 28.82% × 0.59 × 2.18
2023/07/29 28.44% = 0.82 × 0.97 × 27.62% × 0.56 × 2.30
2023/04/29 27.12% = 0.80 × 0.97 × 26.73% × 0.56 × 2.31
2023/01/28 27.25% = 0.80 × 0.97 × 27.27% × 0.55 × 2.31
2022/10/29 28.56% = 0.80 × 0.97 × 28.05% × 0.56 × 2.31
2022/07/30 29.70% = 0.82 × 0.98 × 28.78% × 0.55 × 2.36
2022/04/30 29.72% = 0.81 × 0.98 × 29.39% × 0.56 × 2.30
2022/01/29 29.94% = 0.81 × 0.97 × 29.04% × 0.55 × 2.39
2021/10/30 26.69% = 0.80 × 0.97 × 28.84% × 0.53 × 2.25
2021/07/31 25.66% = 0.80 × 0.97 × 27.49% × 0.51 × 2.36
2021/05/01 25.41% = 0.80 × 0.97 × 27.20% × 0.52 × 2.34
2021/01/23 25.89% = 0.80 × 0.96 × 27.40% × 0.50 × 2.44
2020/10/24 27.42% = 0.81 × 0.96 × 28.05% × 0.51 × 2.49

レポートに基づく: 10-K (報告日: 2025-07-26), 10-Q (報告日: 2025-04-26), 10-Q (報告日: 2025-01-25), 10-Q (報告日: 2024-10-26), 10-K (報告日: 2024-07-27), 10-Q (報告日: 2024-04-27), 10-Q (報告日: 2024-01-27), 10-Q (報告日: 2023-10-28), 10-K (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-Q (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-K (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-Q (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-K (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-Q (報告日: 2021-01-23), 10-Q (報告日: 2020-10-24).

ROAを2つのコンポーネントに分解

Cisco Systems Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2025/07/26 8.32% = 17.97% × 0.46
2025/04/26 8.17% = 17.60% × 0.46
2025/01/25 7.57% = 16.96% × 0.45
2024/10/26 7.62% = 17.73% × 0.43
2024/07/27 8.29% = 19.18% × 0.43
2024/04/27 9.85% = 21.88% × 0.45
2024/01/27 13.29% = 23.49% × 0.57
2023/10/28 13.75% = 23.40% × 0.59
2023/07/29 12.38% = 22.13% × 0.56
2023/04/29 11.76% = 20.89% × 0.56
2023/01/28 11.79% = 21.26% × 0.55
2022/10/29 12.36% = 22.00% × 0.56
2022/07/30 12.57% = 22.91% × 0.55
2022/04/30 12.94% = 23.28% × 0.56
2022/01/29 12.54% = 22.94% × 0.55
2021/10/30 11.87% = 22.44% × 0.53
2021/07/31 10.86% = 21.26% × 0.51
2021/05/01 10.88% = 20.92% × 0.52
2021/01/23 10.60% = 21.09% × 0.50
2020/10/24 11.01% = 21.76% × 0.51

レポートに基づく: 10-K (報告日: 2025-07-26), 10-Q (報告日: 2025-04-26), 10-Q (報告日: 2025-01-25), 10-Q (報告日: 2024-10-26), 10-K (報告日: 2024-07-27), 10-Q (報告日: 2024-04-27), 10-Q (報告日: 2024-01-27), 10-Q (報告日: 2023-10-28), 10-K (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-Q (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-K (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-Q (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-K (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-Q (報告日: 2021-01-23), 10-Q (報告日: 2020-10-24).

ROAを4つの要素に分解

Cisco Systems Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担率 × 利息負担率 × EBITマージン率 × 資産回転率
2025/07/26 8.32% = 0.92 × 0.87 × 22.40% × 0.46
2025/04/26 8.17% = 0.93 × 0.86 × 21.83% × 0.46
2025/01/25 7.57% = 0.94 × 0.86 × 21.01% × 0.45
2024/10/26 7.62% = 0.93 × 0.88 × 21.47% × 0.43
2024/07/27 8.29% = 0.84 × 0.92 × 24.61% × 0.43
2024/04/27 9.85% = 0.85 × 0.95 × 27.11% × 0.45
2024/01/27 13.29% = 0.84 × 0.97 × 28.80% × 0.57
2023/10/28 13.75% = 0.83 × 0.97 × 28.82% × 0.59
2023/07/29 12.38% = 0.82 × 0.97 × 27.62% × 0.56
2023/04/29 11.76% = 0.80 × 0.97 × 26.73% × 0.56
2023/01/28 11.79% = 0.80 × 0.97 × 27.27% × 0.55
2022/10/29 12.36% = 0.80 × 0.97 × 28.05% × 0.56
2022/07/30 12.57% = 0.82 × 0.98 × 28.78% × 0.55
2022/04/30 12.94% = 0.81 × 0.98 × 29.39% × 0.56
2022/01/29 12.54% = 0.81 × 0.97 × 29.04% × 0.55
2021/10/30 11.87% = 0.80 × 0.97 × 28.84% × 0.53
2021/07/31 10.86% = 0.80 × 0.97 × 27.49% × 0.51
2021/05/01 10.88% = 0.80 × 0.97 × 27.20% × 0.52
2021/01/23 10.60% = 0.80 × 0.96 × 27.40% × 0.50
2020/10/24 11.01% = 0.81 × 0.96 × 28.05% × 0.51

レポートに基づく: 10-K (報告日: 2025-07-26), 10-Q (報告日: 2025-04-26), 10-Q (報告日: 2025-01-25), 10-Q (報告日: 2024-10-26), 10-K (報告日: 2024-07-27), 10-Q (報告日: 2024-04-27), 10-Q (報告日: 2024-01-27), 10-Q (報告日: 2023-10-28), 10-K (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-Q (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-K (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-Q (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-K (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-Q (報告日: 2021-01-23), 10-Q (報告日: 2020-10-24).

当期純利益率の分解

Cisco Systems Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担率 × 利息負担率 × EBITマージン率
2025/07/26 17.97% = 0.92 × 0.87 × 22.40%
2025/04/26 17.60% = 0.93 × 0.86 × 21.83%
2025/01/25 16.96% = 0.94 × 0.86 × 21.01%
2024/10/26 17.73% = 0.93 × 0.88 × 21.47%
2024/07/27 19.18% = 0.84 × 0.92 × 24.61%
2024/04/27 21.88% = 0.85 × 0.95 × 27.11%
2024/01/27 23.49% = 0.84 × 0.97 × 28.80%
2023/10/28 23.40% = 0.83 × 0.97 × 28.82%
2023/07/29 22.13% = 0.82 × 0.97 × 27.62%
2023/04/29 20.89% = 0.80 × 0.97 × 26.73%
2023/01/28 21.26% = 0.80 × 0.97 × 27.27%
2022/10/29 22.00% = 0.80 × 0.97 × 28.05%
2022/07/30 22.91% = 0.82 × 0.98 × 28.78%
2022/04/30 23.28% = 0.81 × 0.98 × 29.39%
2022/01/29 22.94% = 0.81 × 0.97 × 29.04%
2021/10/30 22.44% = 0.80 × 0.97 × 28.84%
2021/07/31 21.26% = 0.80 × 0.97 × 27.49%
2021/05/01 20.92% = 0.80 × 0.97 × 27.20%
2021/01/23 21.09% = 0.80 × 0.96 × 27.40%
2020/10/24 21.76% = 0.81 × 0.96 × 28.05%

レポートに基づく: 10-K (報告日: 2025-07-26), 10-Q (報告日: 2025-04-26), 10-Q (報告日: 2025-01-25), 10-Q (報告日: 2024-10-26), 10-K (報告日: 2024-07-27), 10-Q (報告日: 2024-04-27), 10-Q (報告日: 2024-01-27), 10-Q (報告日: 2023-10-28), 10-K (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-Q (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-K (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-Q (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-K (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-Q (報告日: 2021-01-23), 10-Q (報告日: 2020-10-24).