Stock Analysis on Net
Stock Analysis on Net

Carnival Corp. & plc (NYSE:CCL)

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

Microsoft Excel

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

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

Carnival Corp. & plc, ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2024. 2. 29. 6.06% = 0.81% × 7.45
2023. 11. 30. -1.08% = -0.15% × 7.14
2023. 8. 31. -23.33% = -3.26% × 7.15
2023. 5. 31. -59.13% = -6.69% × 8.84
2023. 2. 28. -79.34% = -9.42% × 8.43
2022. 11. 30. -86.24% = -11.78% × 7.32
2022. 8. 31. -84.91% = -13.70% × 6.20
2022. 5. 31. -111.15% = -17.33% × 6.42
2022. 2. 28. -91.35% = -17.68% × 5.17
2021. 11. 30. -78.24% = -17.81% × 4.39
2021. 8. 31. -61.25% = -17.01% × 3.60
2021. 5. 31. -51.05% = -16.57% × 3.08
2021. 2. 28. -57.68% = -19.97% × 2.89
2020. 11. 30. -49.80% = -19.10% × 2.61
2020. 8. 31. -38.92% = -14.94% × 2.61
2020. 5. 31. -14.17% = -5.93% × 2.39
2020. 2. 29. 7.71% = 3.99% × 1.93
2019. 11. 30. 11.79% = 6.64% × 1.78
2019. 8. 31. 12.10% = 6.95% × 1.74
2019. 5. 31. 12.39% = 6.71% × 1.85
2019. 2. 28. 12.78% = 7.05% × 1.81
2018. 11. 30. 12.90% = 7.43% × 1.73
2018. 8. 31. — = — × 1.69
2018. 5. 31. — = — × 1.76
2018. 2. 28. — = — × 1.70

보고서 기준: 10-Q (보고 날짜: 2024-02-29), 10-K (보고 날짜: 2023-11-30), 10-Q (보고 날짜: 2023-08-31), 10-Q (보고 날짜: 2023-05-31), 10-Q (보고 날짜: 2023-02-28), 10-K (보고 날짜: 2022-11-30), 10-Q (보고 날짜: 2022-08-31), 10-Q (보고 날짜: 2022-05-31), 10-Q (보고 날짜: 2022-02-28), 10-K (보고 날짜: 2021-11-30), 10-Q (보고 날짜: 2021-08-31), 10-Q (보고 날짜: 2021-05-31), 10-Q (보고 날짜: 2021-02-28), 10-K (보고 날짜: 2020-11-30), 10-Q (보고 날짜: 2020-08-31), 10-Q (보고 날짜: 2020-05-31), 10-Q (보고 날짜: 2020-02-29), 10-K (보고 날짜: 2019-11-30), 10-Q (보고 날짜: 2019-08-31), 10-Q (보고 날짜: 2019-05-31), 10-Q (보고 날짜: 2019-02-28), 10-K (보고 날짜: 2018-11-30), 10-Q (보고 날짜: 2018-08-31), 10-Q (보고 날짜: 2018-05-31), 10-Q (보고 날짜: 2018-02-28).

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

Carnival Corp. & plc, ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률 × 자산 회전율 × 재무 레버리지 비율
2024. 2. 29. 6.06% = 1.79% × 0.45 × 7.45
2023. 11. 30. -1.08% = -0.34% × 0.44 × 7.14
2023. 8. 31. -23.33% = -8.11% × 0.40 × 7.15
2023. 5. 31. -59.13% = -19.83% × 0.34 × 8.84
2023. 2. 28. -79.34% = -32.68% × 0.29 × 8.43
2022. 11. 30. -86.24% = -50.07% × 0.24 × 7.32
2022. 8. 31. -84.91% = -74.00% × 0.19 × 6.20
2022. 5. 31. -111.15% = -156.78% × 0.11 × 6.42
2022. 2. 28. -91.35% = -268.73% × 0.07 × 5.17
2021. 11. 30. -78.24% = -497.96% × 0.04 × 4.39
2021. 8. 31. -61.25% = -1,385.69% × 0.01 × 3.60
2021. 5. 31. -51.05% = -6,426.76% × 0.00 × 3.08
2021. 2. 28. -57.68% = -1,373.56% × 0.01 × 2.89
2020. 11. 30. -49.80% = -182.95% × 0.10 × 2.61
2020. 8. 31. -38.92% = -73.40% × 0.20 × 2.61
2020. 5. 31. -14.17% = -17.53% × 0.34 × 2.39
2020. 2. 29. 7.71% = 8.94% × 0.45 × 1.93
2019. 11. 30. 11.79% = 14.36% × 0.46 × 1.78
2019. 8. 31. 12.10% = 14.93% × 0.47 × 1.74
2019. 5. 31. 12.39% = 15.08% × 0.44 × 1.85
2019. 2. 28. 12.78% = 16.03% × 0.44 × 1.81
2018. 11. 30. 12.90% = 16.69% × 0.45 × 1.73
2018. 8. 31. — = — × — × 1.69
2018. 5. 31. — = — × — × 1.76
2018. 2. 28. — = — × — × 1.70

보고서 기준: 10-Q (보고 날짜: 2024-02-29), 10-K (보고 날짜: 2023-11-30), 10-Q (보고 날짜: 2023-08-31), 10-Q (보고 날짜: 2023-05-31), 10-Q (보고 날짜: 2023-02-28), 10-K (보고 날짜: 2022-11-30), 10-Q (보고 날짜: 2022-08-31), 10-Q (보고 날짜: 2022-05-31), 10-Q (보고 날짜: 2022-02-28), 10-K (보고 날짜: 2021-11-30), 10-Q (보고 날짜: 2021-08-31), 10-Q (보고 날짜: 2021-05-31), 10-Q (보고 날짜: 2021-02-28), 10-K (보고 날짜: 2020-11-30), 10-Q (보고 날짜: 2020-08-31), 10-Q (보고 날짜: 2020-05-31), 10-Q (보고 날짜: 2020-02-29), 10-K (보고 날짜: 2019-11-30), 10-Q (보고 날짜: 2019-08-31), 10-Q (보고 날짜: 2019-05-31), 10-Q (보고 날짜: 2019-02-28), 10-K (보고 날짜: 2018-11-30), 10-Q (보고 날짜: 2018-08-31), 10-Q (보고 날짜: 2018-05-31), 10-Q (보고 날짜: 2018-02-28).

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

Carnival Corp. & plc, ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율 × 재무 레버리지 비율
2024. 2. 29. 6.06% = 0.99 × 0.17 × 10.67% × 0.45 × 7.45
2023. 11. 30. -1.08% = — × -0.03 × 9.28% × 0.44 × 7.14
2023. 8. 31. -23.33% = — × -3.84 × 2.11% × 0.40 × 7.15
2023. 5. 31. -59.13% = — × — × -8.56% × 0.34 × 8.84
2023. 2. 28. -79.34% = — × — × -20.69% × 0.29 × 8.43
2022. 11. 30. -86.24% = — × — × -36.74% × 0.24 × 7.32
2022. 8. 31. -84.91% = — × — × -58.18% × 0.19 × 6.20
2022. 5. 31. -111.15% = — × — × -131.45% × 0.11 × 6.42
2022. 2. 28. -91.35% = — × — × -224.25% × 0.07 × 5.17
2021. 11. 30. -78.24% = — × — × -415.15% × 0.04 × 4.39
2021. 8. 31. -61.25% = — × — × -1,146.88% × 0.01 × 3.60
2021. 5. 31. -51.05% = — × — × -5,383.10% × 0.00 × 3.08
2021. 2. 28. -57.68% = — × — × -1,228.85% × 0.01 × 2.89
2020. 11. 30. -49.80% = — × — × -167.26% × 0.10 × 2.61
2020. 8. 31. -38.92% = — × — × -67.52% × 0.20 × 2.61
2020. 5. 31. -14.17% = — × — × -15.16% × 0.34 × 2.39
2020. 2. 29. 7.71% = 0.96 × 0.90 × 10.33% × 0.45 × 1.93
2019. 11. 30. 11.79% = 0.98 × 0.94 × 15.69% × 0.46 × 1.78
2019. 8. 31. 12.10% = 0.98 × 0.94 × 16.27% × 0.47 × 1.74
2019. 5. 31. 12.39% = 0.98 × 0.94 × 16.41% × 0.44 × 1.85
2019. 2. 28. 12.78% = 0.98 × 0.94 × 17.34% × 0.44 × 1.81
2018. 11. 30. 12.90% = 0.98 × 0.94 × 18.01% × 0.45 × 1.73
2018. 8. 31. — = — × — × — × — × 1.69
2018. 5. 31. — = — × — × — × — × 1.76
2018. 2. 28. — = — × — × — × — × 1.70

보고서 기준: 10-Q (보고 날짜: 2024-02-29), 10-K (보고 날짜: 2023-11-30), 10-Q (보고 날짜: 2023-08-31), 10-Q (보고 날짜: 2023-05-31), 10-Q (보고 날짜: 2023-02-28), 10-K (보고 날짜: 2022-11-30), 10-Q (보고 날짜: 2022-08-31), 10-Q (보고 날짜: 2022-05-31), 10-Q (보고 날짜: 2022-02-28), 10-K (보고 날짜: 2021-11-30), 10-Q (보고 날짜: 2021-08-31), 10-Q (보고 날짜: 2021-05-31), 10-Q (보고 날짜: 2021-02-28), 10-K (보고 날짜: 2020-11-30), 10-Q (보고 날짜: 2020-08-31), 10-Q (보고 날짜: 2020-05-31), 10-Q (보고 날짜: 2020-02-29), 10-K (보고 날짜: 2019-11-30), 10-Q (보고 날짜: 2019-08-31), 10-Q (보고 날짜: 2019-05-31), 10-Q (보고 날짜: 2019-02-28), 10-K (보고 날짜: 2018-11-30), 10-Q (보고 날짜: 2018-08-31), 10-Q (보고 날짜: 2018-05-31), 10-Q (보고 날짜: 2018-02-28).

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

Carnival Corp. & plc, ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률 × 자산 회전율
2024. 2. 29. 0.81% = 1.79% × 0.45
2023. 11. 30. -0.15% = -0.34% × 0.44
2023. 8. 31. -3.26% = -8.11% × 0.40
2023. 5. 31. -6.69% = -19.83% × 0.34
2023. 2. 28. -9.42% = -32.68% × 0.29
2022. 11. 30. -11.78% = -50.07% × 0.24
2022. 8. 31. -13.70% = -74.00% × 0.19
2022. 5. 31. -17.33% = -156.78% × 0.11
2022. 2. 28. -17.68% = -268.73% × 0.07
2021. 11. 30. -17.81% = -497.96% × 0.04
2021. 8. 31. -17.01% = -1,385.69% × 0.01
2021. 5. 31. -16.57% = -6,426.76% × 0.00
2021. 2. 28. -19.97% = -1,373.56% × 0.01
2020. 11. 30. -19.10% = -182.95% × 0.10
2020. 8. 31. -14.94% = -73.40% × 0.20
2020. 5. 31. -5.93% = -17.53% × 0.34
2020. 2. 29. 3.99% = 8.94% × 0.45
2019. 11. 30. 6.64% = 14.36% × 0.46
2019. 8. 31. 6.95% = 14.93% × 0.47
2019. 5. 31. 6.71% = 15.08% × 0.44
2019. 2. 28. 7.05% = 16.03% × 0.44
2018. 11. 30. 7.43% = 16.69% × 0.45
2018. 8. 31. — = — × —
2018. 5. 31. — = — × —
2018. 2. 28. — = — × —

보고서 기준: 10-Q (보고 날짜: 2024-02-29), 10-K (보고 날짜: 2023-11-30), 10-Q (보고 날짜: 2023-08-31), 10-Q (보고 날짜: 2023-05-31), 10-Q (보고 날짜: 2023-02-28), 10-K (보고 날짜: 2022-11-30), 10-Q (보고 날짜: 2022-08-31), 10-Q (보고 날짜: 2022-05-31), 10-Q (보고 날짜: 2022-02-28), 10-K (보고 날짜: 2021-11-30), 10-Q (보고 날짜: 2021-08-31), 10-Q (보고 날짜: 2021-05-31), 10-Q (보고 날짜: 2021-02-28), 10-K (보고 날짜: 2020-11-30), 10-Q (보고 날짜: 2020-08-31), 10-Q (보고 날짜: 2020-05-31), 10-Q (보고 날짜: 2020-02-29), 10-K (보고 날짜: 2019-11-30), 10-Q (보고 날짜: 2019-08-31), 10-Q (보고 날짜: 2019-05-31), 10-Q (보고 날짜: 2019-02-28), 10-K (보고 날짜: 2018-11-30), 10-Q (보고 날짜: 2018-08-31), 10-Q (보고 날짜: 2018-05-31), 10-Q (보고 날짜: 2018-02-28).

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

Carnival Corp. & plc, ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율
2024. 2. 29. 0.81% = 0.99 × 0.17 × 10.67% × 0.45
2023. 11. 30. -0.15% = — × -0.03 × 9.28% × 0.44
2023. 8. 31. -3.26% = — × -3.84 × 2.11% × 0.40
2023. 5. 31. -6.69% = — × — × -8.56% × 0.34
2023. 2. 28. -9.42% = — × — × -20.69% × 0.29
2022. 11. 30. -11.78% = — × — × -36.74% × 0.24
2022. 8. 31. -13.70% = — × — × -58.18% × 0.19
2022. 5. 31. -17.33% = — × — × -131.45% × 0.11
2022. 2. 28. -17.68% = — × — × -224.25% × 0.07
2021. 11. 30. -17.81% = — × — × -415.15% × 0.04
2021. 8. 31. -17.01% = — × — × -1,146.88% × 0.01
2021. 5. 31. -16.57% = — × — × -5,383.10% × 0.00
2021. 2. 28. -19.97% = — × — × -1,228.85% × 0.01
2020. 11. 30. -19.10% = — × — × -167.26% × 0.10
2020. 8. 31. -14.94% = — × — × -67.52% × 0.20
2020. 5. 31. -5.93% = — × — × -15.16% × 0.34
2020. 2. 29. 3.99% = 0.96 × 0.90 × 10.33% × 0.45
2019. 11. 30. 6.64% = 0.98 × 0.94 × 15.69% × 0.46
2019. 8. 31. 6.95% = 0.98 × 0.94 × 16.27% × 0.47
2019. 5. 31. 6.71% = 0.98 × 0.94 × 16.41% × 0.44
2019. 2. 28. 7.05% = 0.98 × 0.94 × 17.34% × 0.44
2018. 11. 30. 7.43% = 0.98 × 0.94 × 18.01% × 0.45
2018. 8. 31. — = — × — × — × —
2018. 5. 31. — = — × — × — × —
2018. 2. 28. — = — × — × — × —

보고서 기준: 10-Q (보고 날짜: 2024-02-29), 10-K (보고 날짜: 2023-11-30), 10-Q (보고 날짜: 2023-08-31), 10-Q (보고 날짜: 2023-05-31), 10-Q (보고 날짜: 2023-02-28), 10-K (보고 날짜: 2022-11-30), 10-Q (보고 날짜: 2022-08-31), 10-Q (보고 날짜: 2022-05-31), 10-Q (보고 날짜: 2022-02-28), 10-K (보고 날짜: 2021-11-30), 10-Q (보고 날짜: 2021-08-31), 10-Q (보고 날짜: 2021-05-31), 10-Q (보고 날짜: 2021-02-28), 10-K (보고 날짜: 2020-11-30), 10-Q (보고 날짜: 2020-08-31), 10-Q (보고 날짜: 2020-05-31), 10-Q (보고 날짜: 2020-02-29), 10-K (보고 날짜: 2019-11-30), 10-Q (보고 날짜: 2019-08-31), 10-Q (보고 날짜: 2019-05-31), 10-Q (보고 날짜: 2019-02-28), 10-K (보고 날짜: 2018-11-30), 10-Q (보고 날짜: 2018-08-31), 10-Q (보고 날짜: 2018-05-31), 10-Q (보고 날짜: 2018-02-28).

순이익률 세분화

Carnival Corp. & plc, 순이익률 분해(분기별 데이터)

Microsoft Excel
순이익률 = 세금 부담 × 이자 부담 × EBIT 마진
2024. 2. 29. 1.79% = 0.99 × 0.17 × 10.67%
2023. 11. 30. -0.34% = — × -0.03 × 9.28%
2023. 8. 31. -8.11% = — × -3.84 × 2.11%
2023. 5. 31. -19.83% = — × — × -8.56%
2023. 2. 28. -32.68% = — × — × -20.69%
2022. 11. 30. -50.07% = — × — × -36.74%
2022. 8. 31. -74.00% = — × — × -58.18%
2022. 5. 31. -156.78% = — × — × -131.45%
2022. 2. 28. -268.73% = — × — × -224.25%
2021. 11. 30. -497.96% = — × — × -415.15%
2021. 8. 31. -1,385.69% = — × — × -1,146.88%
2021. 5. 31. -6,426.76% = — × — × -5,383.10%
2021. 2. 28. -1,373.56% = — × — × -1,228.85%
2020. 11. 30. -182.95% = — × — × -167.26%
2020. 8. 31. -73.40% = — × — × -67.52%
2020. 5. 31. -17.53% = — × — × -15.16%
2020. 2. 29. 8.94% = 0.96 × 0.90 × 10.33%
2019. 11. 30. 14.36% = 0.98 × 0.94 × 15.69%
2019. 8. 31. 14.93% = 0.98 × 0.94 × 16.27%
2019. 5. 31. 15.08% = 0.98 × 0.94 × 16.41%
2019. 2. 28. 16.03% = 0.98 × 0.94 × 17.34%
2018. 11. 30. 16.69% = 0.98 × 0.94 × 18.01%
2018. 8. 31. — = — × — × —
2018. 5. 31. — = — × — × —
2018. 2. 28. — = — × — × —

보고서 기준: 10-Q (보고 날짜: 2024-02-29), 10-K (보고 날짜: 2023-11-30), 10-Q (보고 날짜: 2023-08-31), 10-Q (보고 날짜: 2023-05-31), 10-Q (보고 날짜: 2023-02-28), 10-K (보고 날짜: 2022-11-30), 10-Q (보고 날짜: 2022-08-31), 10-Q (보고 날짜: 2022-05-31), 10-Q (보고 날짜: 2022-02-28), 10-K (보고 날짜: 2021-11-30), 10-Q (보고 날짜: 2021-08-31), 10-Q (보고 날짜: 2021-05-31), 10-Q (보고 날짜: 2021-02-28), 10-K (보고 날짜: 2020-11-30), 10-Q (보고 날짜: 2020-08-31), 10-Q (보고 날짜: 2020-05-31), 10-Q (보고 날짜: 2020-02-29), 10-K (보고 날짜: 2019-11-30), 10-Q (보고 날짜: 2019-08-31), 10-Q (보고 날짜: 2019-05-31), 10-Q (보고 날짜: 2019-02-28), 10-K (보고 날짜: 2018-11-30), 10-Q (보고 날짜: 2018-08-31), 10-Q (보고 날짜: 2018-05-31), 10-Q (보고 날짜: 2018-02-28).