Stock Analysis on Net
Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

듀퐁 분석: ROE, ROA및 순이익률의 세분화 
분기별 데이터

Microsoft Excel

분해 ROE 는 순이익을 주주 자본으로 나눈 값을 구성 요소 비율의 곱으로 표현하는 것을 포함합니다.

ROE 두 가지 구성 요소로 세분화

Cisco Systems Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2024. 1. 27. 29.06% = 13.29% × 2.19
2023. 10. 28. 30.04% = 13.75% × 2.18
2023. 7. 29. 28.44% = 12.38% × 2.30
2023. 4. 29. 27.12% = 11.76% × 2.31
2023. 1. 28. 27.25% = 11.79% × 2.31
2022. 10. 29. 28.56% = 12.36% × 2.31
2022. 7. 30. 29.70% = 12.57% × 2.36
2022. 4. 30. 29.72% = 12.94% × 2.30
2022. 1. 29. 29.94% = 12.54% × 2.39
2021. 10. 30. 26.69% = 11.87% × 2.25
2021. 7. 31. 25.66% = 10.86% × 2.36
2021. 5. 1. 25.41% = 10.88% × 2.34
2021. 1. 23. 25.89% = 10.60% × 2.44
2020. 10. 24. 27.42% = 11.01% × 2.49
2020. 7. 25. 29.57% = 11.82% × 2.50
2020. 4. 25. 30.20% = 11.80% × 2.56
2020. 1. 25. 31.11% = 12.22% × 2.54
2019. 10. 26. 31.95% = 11.89% × 2.69
2019. 7. 27. 34.62% = 11.88% × 2.91
2019. 4. 27. 35.91% = 13.59% × 2.64
2019. 1. 26. 31.54% = 12.56% × 2.51
2018. 10. 27. 2.88% = 1.20% × 2.40
2018. 7. 28. 0.25% = 0.10% × 2.52
2018. 4. 28. — = — × 2.44
2018. 1. 27. — = — × 2.53
2017. 10. 28. — = — × 1.99

보고서 기준: 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), 10-K (보고 날짜: 2020-07-25), 10-Q (보고 날짜: 2020-04-25), 10-Q (보고 날짜: 2020-01-25), 10-Q (보고 날짜: 2019-10-26), 10-K (보고 날짜: 2019-07-27), 10-Q (보고 날짜: 2019-04-27), 10-Q (보고 날짜: 2019-01-26), 10-Q (보고 날짜: 2018-10-27), 10-K (보고 날짜: 2018-07-28), 10-Q (보고 날짜: 2018-04-28), 10-Q (보고 날짜: 2018-01-27), 10-Q (보고 날짜: 2017-10-28).

2024년 2 분기에 주주자본이익률(ROE)이 하락한 주된 이유는 자산수익률(ROA)로 측정한 수익성 감소입니다.

ROE 세 가지 구성 요소로 세분화

Cisco Systems Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률 × 자산 회전율 × 재무 레버리지 비율
2024. 1. 27. 29.06% = 23.49% × 0.57 × 2.19
2023. 10. 28. 30.04% = 23.40% × 0.59 × 2.18
2023. 7. 29. 28.44% = 22.13% × 0.56 × 2.30
2023. 4. 29. 27.12% = 20.89% × 0.56 × 2.31
2023. 1. 28. 27.25% = 21.26% × 0.55 × 2.31
2022. 10. 29. 28.56% = 22.00% × 0.56 × 2.31
2022. 7. 30. 29.70% = 22.91% × 0.55 × 2.36
2022. 4. 30. 29.72% = 23.28% × 0.56 × 2.30
2022. 1. 29. 29.94% = 22.94% × 0.55 × 2.39
2021. 10. 30. 26.69% = 22.44% × 0.53 × 2.25
2021. 7. 31. 25.66% = 21.26% × 0.51 × 2.36
2021. 5. 1. 25.41% = 20.92% × 0.52 × 2.34
2021. 1. 23. 25.89% = 21.09% × 0.50 × 2.44
2020. 10. 24. 27.42% = 21.76% × 0.51 × 2.49
2020. 7. 25. 29.57% = 22.75% × 0.52 × 2.50
2020. 4. 25. 30.20% = 21.32% × 0.55 × 2.56
2020. 1. 25. 31.11% = 21.44% × 0.57 × 2.54
2019. 10. 26. 31.95% = 21.15% × 0.56 × 2.69
2019. 7. 27. 34.62% = 22.39% × 0.53 × 2.91
2019. 4. 27. 35.91% = 25.76% × 0.53 × 2.64
2019. 1. 26. 31.54% = 25.31% × 0.50 × 2.51
2018. 10. 27. 2.88% = 2.52% × 0.48 × 2.40
2018. 7. 28. 0.25% = 0.22% × 0.45 × 2.52
2018. 4. 28. — = — × — × 2.44
2018. 1. 27. — = — × — × 2.53
2017. 10. 28. — = — × — × 1.99

보고서 기준: 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), 10-K (보고 날짜: 2020-07-25), 10-Q (보고 날짜: 2020-04-25), 10-Q (보고 날짜: 2020-01-25), 10-Q (보고 날짜: 2019-10-26), 10-K (보고 날짜: 2019-07-27), 10-Q (보고 날짜: 2019-04-27), 10-Q (보고 날짜: 2019-01-26), 10-Q (보고 날짜: 2018-10-27), 10-K (보고 날짜: 2018-07-28), 10-Q (보고 날짜: 2018-04-28), 10-Q (보고 날짜: 2018-01-27), 10-Q (보고 날짜: 2017-10-28).

2024년 2 분기 주주자본비율(ROE)이 감소한 가장 큰 이유는 자산회전율로 측정한 효율성의 감소입니다.

ROE를 5개 구성 요소로 세분화

Cisco Systems Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율 × 재무 레버리지 비율
2024. 1. 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. 7. 29. 28.44% = 0.82 × 0.97 × 27.62% × 0.56 × 2.30
2023. 4. 29. 27.12% = 0.80 × 0.97 × 26.73% × 0.56 × 2.31
2023. 1. 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. 7. 30. 29.70% = 0.82 × 0.98 × 28.78% × 0.55 × 2.36
2022. 4. 30. 29.72% = 0.81 × 0.98 × 29.39% × 0.56 × 2.30
2022. 1. 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. 7. 31. 25.66% = 0.80 × 0.97 × 27.49% × 0.51 × 2.36
2021. 5. 1. 25.41% = 0.80 × 0.97 × 27.20% × 0.52 × 2.34
2021. 1. 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
2020. 7. 25. 29.57% = 0.80 × 0.96 × 29.52% × 0.52 × 2.50
2020. 4. 25. 30.20% = 0.75 × 0.96 × 29.73% × 0.55 × 2.56
2020. 1. 25. 31.11% = 0.76 × 0.95 × 29.66% × 0.57 × 2.54
2019. 10. 26. 31.95% = 0.77 × 0.95 × 29.17% × 0.56 × 2.69
2019. 7. 27. 34.62% = 0.80 × 0.94 × 29.73% × 0.53 × 2.91
2019. 4. 27. 35.91% = 0.91 × 0.94 × 29.89% × 0.53 × 2.64
2019. 1. 26. 31.54% = 0.91 × 0.94 × 29.52% × 0.50 × 2.51
2018. 10. 27. 2.88% = 0.09 × 0.94 × 29.67% × 0.48 × 2.40
2018. 7. 28. 0.25% = 0.01 × 0.93 × 28.34% × 0.45 × 2.52
2018. 4. 28. — = — × — × — × — × 2.44
2018. 1. 27. — = — × — × — × — × 2.53
2017. 10. 28. — = — × — × — × — × 1.99

보고서 기준: 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), 10-K (보고 날짜: 2020-07-25), 10-Q (보고 날짜: 2020-04-25), 10-Q (보고 날짜: 2020-01-25), 10-Q (보고 날짜: 2019-10-26), 10-K (보고 날짜: 2019-07-27), 10-Q (보고 날짜: 2019-04-27), 10-Q (보고 날짜: 2019-01-26), 10-Q (보고 날짜: 2018-10-27), 10-K (보고 날짜: 2018-07-28), 10-Q (보고 날짜: 2018-04-28), 10-Q (보고 날짜: 2018-01-27), 10-Q (보고 날짜: 2017-10-28).

2024년 2 분기 주주자본비율(ROE)이 감소한 가장 큰 이유는 자산회전율로 측정한 효율성의 감소입니다.

ROA 두 가지 구성 요소로 세분화

Cisco Systems Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률 × 자산 회전율
2024. 1. 27. 13.29% = 23.49% × 0.57
2023. 10. 28. 13.75% = 23.40% × 0.59
2023. 7. 29. 12.38% = 22.13% × 0.56
2023. 4. 29. 11.76% = 20.89% × 0.56
2023. 1. 28. 11.79% = 21.26% × 0.55
2022. 10. 29. 12.36% = 22.00% × 0.56
2022. 7. 30. 12.57% = 22.91% × 0.55
2022. 4. 30. 12.94% = 23.28% × 0.56
2022. 1. 29. 12.54% = 22.94% × 0.55
2021. 10. 30. 11.87% = 22.44% × 0.53
2021. 7. 31. 10.86% = 21.26% × 0.51
2021. 5. 1. 10.88% = 20.92% × 0.52
2021. 1. 23. 10.60% = 21.09% × 0.50
2020. 10. 24. 11.01% = 21.76% × 0.51
2020. 7. 25. 11.82% = 22.75% × 0.52
2020. 4. 25. 11.80% = 21.32% × 0.55
2020. 1. 25. 12.22% = 21.44% × 0.57
2019. 10. 26. 11.89% = 21.15% × 0.56
2019. 7. 27. 11.88% = 22.39% × 0.53
2019. 4. 27. 13.59% = 25.76% × 0.53
2019. 1. 26. 12.56% = 25.31% × 0.50
2018. 10. 27. 1.20% = 2.52% × 0.48
2018. 7. 28. 0.10% = 0.22% × 0.45
2018. 4. 28. — = — × —
2018. 1. 27. — = — × —
2017. 10. 28. — = — × —

보고서 기준: 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), 10-K (보고 날짜: 2020-07-25), 10-Q (보고 날짜: 2020-04-25), 10-Q (보고 날짜: 2020-01-25), 10-Q (보고 날짜: 2019-10-26), 10-K (보고 날짜: 2019-07-27), 10-Q (보고 날짜: 2019-04-27), 10-Q (보고 날짜: 2019-01-26), 10-Q (보고 날짜: 2018-10-27), 10-K (보고 날짜: 2018-07-28), 10-Q (보고 날짜: 2018-04-28), 10-Q (보고 날짜: 2018-01-27), 10-Q (보고 날짜: 2017-10-28).

2024년 2 분기 자산회전율(ROA)이 감소한 가장 큰 이유는 자산회전율 감소입니다.

ROA를 4개의 구성 요소로 세분화

Cisco Systems Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율
2024. 1. 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. 7. 29. 12.38% = 0.82 × 0.97 × 27.62% × 0.56
2023. 4. 29. 11.76% = 0.80 × 0.97 × 26.73% × 0.56
2023. 1. 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. 7. 30. 12.57% = 0.82 × 0.98 × 28.78% × 0.55
2022. 4. 30. 12.94% = 0.81 × 0.98 × 29.39% × 0.56
2022. 1. 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. 7. 31. 10.86% = 0.80 × 0.97 × 27.49% × 0.51
2021. 5. 1. 10.88% = 0.80 × 0.97 × 27.20% × 0.52
2021. 1. 23. 10.60% = 0.80 × 0.96 × 27.40% × 0.50
2020. 10. 24. 11.01% = 0.81 × 0.96 × 28.05% × 0.51
2020. 7. 25. 11.82% = 0.80 × 0.96 × 29.52% × 0.52
2020. 4. 25. 11.80% = 0.75 × 0.96 × 29.73% × 0.55
2020. 1. 25. 12.22% = 0.76 × 0.95 × 29.66% × 0.57
2019. 10. 26. 11.89% = 0.77 × 0.95 × 29.17% × 0.56
2019. 7. 27. 11.88% = 0.80 × 0.94 × 29.73% × 0.53
2019. 4. 27. 13.59% = 0.91 × 0.94 × 29.89% × 0.53
2019. 1. 26. 12.56% = 0.91 × 0.94 × 29.52% × 0.50
2018. 10. 27. 1.20% = 0.09 × 0.94 × 29.67% × 0.48
2018. 7. 28. 0.10% = 0.01 × 0.93 × 28.34% × 0.45
2018. 4. 28. — = — × — × — × —
2018. 1. 27. — = — × — × — × —
2017. 10. 28. — = — × — × — × —

보고서 기준: 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), 10-K (보고 날짜: 2020-07-25), 10-Q (보고 날짜: 2020-04-25), 10-Q (보고 날짜: 2020-01-25), 10-Q (보고 날짜: 2019-10-26), 10-K (보고 날짜: 2019-07-27), 10-Q (보고 날짜: 2019-04-27), 10-Q (보고 날짜: 2019-01-26), 10-Q (보고 날짜: 2018-10-27), 10-K (보고 날짜: 2018-07-28), 10-Q (보고 날짜: 2018-04-28), 10-Q (보고 날짜: 2018-01-27), 10-Q (보고 날짜: 2017-10-28).

2024년 2 분기 자산회전율(ROA)이 감소한 주된 이유는 자산회전율로 측정한 효율성 감소입니다.

순이익률 세분화

Cisco Systems Inc., 순이익률 분해(분기별 데이터)

Microsoft Excel
순이익률 = 세금 부담 × 이자 부담 × EBIT 마진
2024. 1. 27. 23.49% = 0.84 × 0.97 × 28.80%
2023. 10. 28. 23.40% = 0.83 × 0.97 × 28.82%
2023. 7. 29. 22.13% = 0.82 × 0.97 × 27.62%
2023. 4. 29. 20.89% = 0.80 × 0.97 × 26.73%
2023. 1. 28. 21.26% = 0.80 × 0.97 × 27.27%
2022. 10. 29. 22.00% = 0.80 × 0.97 × 28.05%
2022. 7. 30. 22.91% = 0.82 × 0.98 × 28.78%
2022. 4. 30. 23.28% = 0.81 × 0.98 × 29.39%
2022. 1. 29. 22.94% = 0.81 × 0.97 × 29.04%
2021. 10. 30. 22.44% = 0.80 × 0.97 × 28.84%
2021. 7. 31. 21.26% = 0.80 × 0.97 × 27.49%
2021. 5. 1. 20.92% = 0.80 × 0.97 × 27.20%
2021. 1. 23. 21.09% = 0.80 × 0.96 × 27.40%
2020. 10. 24. 21.76% = 0.81 × 0.96 × 28.05%
2020. 7. 25. 22.75% = 0.80 × 0.96 × 29.52%
2020. 4. 25. 21.32% = 0.75 × 0.96 × 29.73%
2020. 1. 25. 21.44% = 0.76 × 0.95 × 29.66%
2019. 10. 26. 21.15% = 0.77 × 0.95 × 29.17%
2019. 7. 27. 22.39% = 0.80 × 0.94 × 29.73%
2019. 4. 27. 25.76% = 0.91 × 0.94 × 29.89%
2019. 1. 26. 25.31% = 0.91 × 0.94 × 29.52%
2018. 10. 27. 2.52% = 0.09 × 0.94 × 29.67%
2018. 7. 28. 0.22% = 0.01 × 0.93 × 28.34%
2018. 4. 28. — = — × — × —
2018. 1. 27. — = — × — × —
2017. 10. 28. — = — × — × —

보고서 기준: 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), 10-K (보고 날짜: 2020-07-25), 10-Q (보고 날짜: 2020-04-25), 10-Q (보고 날짜: 2020-01-25), 10-Q (보고 날짜: 2019-10-26), 10-K (보고 날짜: 2019-07-27), 10-Q (보고 날짜: 2019-04-27), 10-Q (보고 날짜: 2019-01-26), 10-Q (보고 날짜: 2018-10-27), 10-K (보고 날짜: 2018-07-28), 10-Q (보고 날짜: 2018-04-28), 10-Q (보고 날짜: 2018-01-27), 10-Q (보고 날짜: 2017-10-28).

2024년 2 분기 대비 순이익률 증가의 주요 원인은 조세부담률로 측정되는 세금의 효과가 증가했기 때문이다.