Stock Analysis on Net
Stock Analysis on Net

Royal Caribbean Cruises Ltd. (NYSE:RCL)

이 회사는 아카이브로 이동되었습니다! 재무 데이터는 2022년 7월 29일 이후로 업데이트되지 않았습니다.

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

Microsoft Excel

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

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

Royal Caribbean Cruises Ltd., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2022. 6. 30. -131.55% = -13.17% × 9.99
2022. 3. 31. -132.77% = -16.08% × 8.26
2021. 12. 31. -103.44% = -16.31% × 6.34
2021. 9. 30. -81.49% = -16.13% × 5.05
2021. 6. 30. -65.86% = -15.41% × 4.27
2021. 3. 31. -59.80% = -15.97% × 3.74
2020. 12. 31. -66.18% = -17.86% × 3.71
2020. 9. 30. -49.92% = -13.06% × 3.82
2020. 6. 30. -21.50% = -5.79% × 3.72
2020. 3. 31. 1.81% = 0.55% × 3.27
2019. 12. 31. 15.45% = 6.20% × 2.49
2019. 9. 30. 16.04% = 6.44% × 2.49
2019. 6. 30. 16.02% = 6.20% × 2.58
2019. 3. 31. 16.35% = 6.41% × 2.55
2018. 12. 31. 16.31% = 6.54% × 2.49
2018. 9. 30. 15.73% = 6.58% × 2.39
2018. 6. 30. 16.02% = 7.17% × 2.23
2018. 3. 31. 15.30% = 6.80% × 2.25
2017. 12. 31. 15.18% = 7.29% × 2.08
2017. 9. 30. — = — × 2.12
2017. 6. 30. — = — × 2.27
2017. 3. 31. — = — × 2.38

보고서 기준: 10-Q (보고 날짜: 2022-06-30), 10-Q (보고 날짜: 2022-03-31), 10-K (보고 날짜: 2021-12-31), 10-Q (보고 날짜: 2021-09-30), 10-Q (보고 날짜: 2021-06-30), 10-Q (보고 날짜: 2021-03-31), 10-K (보고 날짜: 2020-12-31), 10-Q (보고 날짜: 2020-09-30), 10-Q (보고 날짜: 2020-06-30), 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31).

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

Royal Caribbean Cruises Ltd., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률 × 자산 회전율 × 재무 레버리지 비율
2022. 6. 30. -131.55% = -95.46% × 0.14 × 9.99
2022. 3. 31. -132.77% = -207.74% × 0.08 × 8.26
2021. 12. 31. -103.44% = -343.34% × 0.05 × 6.34
2021. 9. 30. -81.49% = -902.44% × 0.02 × 5.05
2021. 6. 30. -65.86% = -5,560.91% × 0.00 × 4.27
2021. 3. 31. -59.80% = -2,515.12% × 0.01 × 3.74
2020. 12. 31. -66.18% = -262.47% × 0.07 × 3.71
2020. 9. 30. -49.92% = -88.60% × 0.15 × 3.82
2020. 6. 30. -21.50% = -24.36% × 0.24 × 3.72
2020. 3. 31. 1.81% = 1.75% × 0.32 × 3.27
2019. 12. 31. 15.45% = 17.16% × 0.36 × 2.49
2019. 9. 30. 16.04% = 17.85% × 0.36 × 2.49
2019. 6. 30. 16.02% = 17.82% × 0.35 × 2.58
2019. 3. 31. 16.35% = 18.60% × 0.34 × 2.55
2018. 12. 31. 16.31% = 19.08% × 0.34 × 2.49
2018. 9. 30. 15.73% = 19.46% × 0.34 × 2.39
2018. 6. 30. 16.02% = 19.31% × 0.37 × 2.23
2018. 3. 31. 15.30% = 18.52% × 0.37 × 2.25
2017. 12. 31. 15.18% = 18.51% × 0.39 × 2.08
2017. 9. 30. — = — × — × 2.12
2017. 6. 30. — = — × — × 2.27
2017. 3. 31. — = — × — × 2.38

보고서 기준: 10-Q (보고 날짜: 2022-06-30), 10-Q (보고 날짜: 2022-03-31), 10-K (보고 날짜: 2021-12-31), 10-Q (보고 날짜: 2021-09-30), 10-Q (보고 날짜: 2021-06-30), 10-Q (보고 날짜: 2021-03-31), 10-K (보고 날짜: 2020-12-31), 10-Q (보고 날짜: 2020-09-30), 10-Q (보고 날짜: 2020-06-30), 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31).

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

Royal Caribbean Cruises Ltd., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율 × 재무 레버리지 비율
2022. 6. 30. -131.55% = — × — × -67.81% × 0.14 × 9.99
2022. 3. 31. -132.77% = — × — × -156.86% × 0.08 × 8.26
2021. 12. 31. -103.44% = — × — × -259.03% × 0.05 × 6.34
2021. 9. 30. -81.49% = — × — × -683.09% × 0.02 × 5.05
2021. 6. 30. -65.86% = — × — × -4,372.45% × 0.00 × 4.27
2021. 3. 31. -59.80% = — × — × -2,045.62% × 0.01 × 3.74
2020. 12. 31. -66.18% = — × — × -224.25% × 0.07 × 3.71
2020. 9. 30. -49.92% = — × — × -74.41% × 0.15 × 3.82
2020. 6. 30. -21.50% = — × — × -17.93% × 0.24 × 3.72
2020. 3. 31. 1.81% = 1.00 × 0.32 × 5.56% × 0.32 × 3.27
2019. 12. 31. 15.45% = 1.00 × 0.82 × 20.89% × 0.36 × 2.49
2019. 9. 30. 16.04% = 1.00 × 0.82 × 21.67% × 0.36 × 2.49
2019. 6. 30. 16.02% = 1.00 × 0.82 × 21.63% × 0.35 × 2.58
2019. 3. 31. 16.35% = 1.00 × 0.83 × 22.29% × 0.34 × 2.55
2018. 12. 31. 16.31% = 1.00 × 0.84 × 22.59% × 0.34 × 2.49
2018. 9. 30. 15.73% = 1.00 × 0.85 × 22.80% × 0.34 × 2.39
2018. 6. 30. 16.02% = 1.00 × 0.85 × 22.58% × 0.37 × 2.23
2018. 3. 31. 15.30% = 1.00 × 0.85 × 21.79% × 0.37 × 2.25
2017. 12. 31. 15.18% = 1.00 × 0.84 × 21.93% × 0.39 × 2.08
2017. 9. 30. — = — × — × — × — × 2.12
2017. 6. 30. — = — × — × — × — × 2.27
2017. 3. 31. — = — × — × — × — × 2.38

보고서 기준: 10-Q (보고 날짜: 2022-06-30), 10-Q (보고 날짜: 2022-03-31), 10-K (보고 날짜: 2021-12-31), 10-Q (보고 날짜: 2021-09-30), 10-Q (보고 날짜: 2021-06-30), 10-Q (보고 날짜: 2021-03-31), 10-K (보고 날짜: 2020-12-31), 10-Q (보고 날짜: 2020-09-30), 10-Q (보고 날짜: 2020-06-30), 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31).

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

Royal Caribbean Cruises Ltd., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률 × 자산 회전율
2022. 6. 30. -13.17% = -95.46% × 0.14
2022. 3. 31. -16.08% = -207.74% × 0.08
2021. 12. 31. -16.31% = -343.34% × 0.05
2021. 9. 30. -16.13% = -902.44% × 0.02
2021. 6. 30. -15.41% = -5,560.91% × 0.00
2021. 3. 31. -15.97% = -2,515.12% × 0.01
2020. 12. 31. -17.86% = -262.47% × 0.07
2020. 9. 30. -13.06% = -88.60% × 0.15
2020. 6. 30. -5.79% = -24.36% × 0.24
2020. 3. 31. 0.55% = 1.75% × 0.32
2019. 12. 31. 6.20% = 17.16% × 0.36
2019. 9. 30. 6.44% = 17.85% × 0.36
2019. 6. 30. 6.20% = 17.82% × 0.35
2019. 3. 31. 6.41% = 18.60% × 0.34
2018. 12. 31. 6.54% = 19.08% × 0.34
2018. 9. 30. 6.58% = 19.46% × 0.34
2018. 6. 30. 7.17% = 19.31% × 0.37
2018. 3. 31. 6.80% = 18.52% × 0.37
2017. 12. 31. 7.29% = 18.51% × 0.39
2017. 9. 30. — = — × —
2017. 6. 30. — = — × —
2017. 3. 31. — = — × —

보고서 기준: 10-Q (보고 날짜: 2022-06-30), 10-Q (보고 날짜: 2022-03-31), 10-K (보고 날짜: 2021-12-31), 10-Q (보고 날짜: 2021-09-30), 10-Q (보고 날짜: 2021-06-30), 10-Q (보고 날짜: 2021-03-31), 10-K (보고 날짜: 2020-12-31), 10-Q (보고 날짜: 2020-09-30), 10-Q (보고 날짜: 2020-06-30), 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31).

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

Royal Caribbean Cruises Ltd., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율
2022. 6. 30. -13.17% = — × — × -67.81% × 0.14
2022. 3. 31. -16.08% = — × — × -156.86% × 0.08
2021. 12. 31. -16.31% = — × — × -259.03% × 0.05
2021. 9. 30. -16.13% = — × — × -683.09% × 0.02
2021. 6. 30. -15.41% = — × — × -4,372.45% × 0.00
2021. 3. 31. -15.97% = — × — × -2,045.62% × 0.01
2020. 12. 31. -17.86% = — × — × -224.25% × 0.07
2020. 9. 30. -13.06% = — × — × -74.41% × 0.15
2020. 6. 30. -5.79% = — × — × -17.93% × 0.24
2020. 3. 31. 0.55% = 1.00 × 0.32 × 5.56% × 0.32
2019. 12. 31. 6.20% = 1.00 × 0.82 × 20.89% × 0.36
2019. 9. 30. 6.44% = 1.00 × 0.82 × 21.67% × 0.36
2019. 6. 30. 6.20% = 1.00 × 0.82 × 21.63% × 0.35
2019. 3. 31. 6.41% = 1.00 × 0.83 × 22.29% × 0.34
2018. 12. 31. 6.54% = 1.00 × 0.84 × 22.59% × 0.34
2018. 9. 30. 6.58% = 1.00 × 0.85 × 22.80% × 0.34
2018. 6. 30. 7.17% = 1.00 × 0.85 × 22.58% × 0.37
2018. 3. 31. 6.80% = 1.00 × 0.85 × 21.79% × 0.37
2017. 12. 31. 7.29% = 1.00 × 0.84 × 21.93% × 0.39
2017. 9. 30. — = — × — × — × —
2017. 6. 30. — = — × — × — × —
2017. 3. 31. — = — × — × — × —

보고서 기준: 10-Q (보고 날짜: 2022-06-30), 10-Q (보고 날짜: 2022-03-31), 10-K (보고 날짜: 2021-12-31), 10-Q (보고 날짜: 2021-09-30), 10-Q (보고 날짜: 2021-06-30), 10-Q (보고 날짜: 2021-03-31), 10-K (보고 날짜: 2020-12-31), 10-Q (보고 날짜: 2020-09-30), 10-Q (보고 날짜: 2020-06-30), 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31).

순이익률 세분화

Royal Caribbean Cruises Ltd., 순이익률 분해(분기별 데이터)

Microsoft Excel
순이익률 = 세금 부담 × 이자 부담 × EBIT 마진
2022. 6. 30. -95.46% = — × — × -67.81%
2022. 3. 31. -207.74% = — × — × -156.86%
2021. 12. 31. -343.34% = — × — × -259.03%
2021. 9. 30. -902.44% = — × — × -683.09%
2021. 6. 30. -5,560.91% = — × — × -4,372.45%
2021. 3. 31. -2,515.12% = — × — × -2,045.62%
2020. 12. 31. -262.47% = — × — × -224.25%
2020. 9. 30. -88.60% = — × — × -74.41%
2020. 6. 30. -24.36% = — × — × -17.93%
2020. 3. 31. 1.75% = 1.00 × 0.32 × 5.56%
2019. 12. 31. 17.16% = 1.00 × 0.82 × 20.89%
2019. 9. 30. 17.85% = 1.00 × 0.82 × 21.67%
2019. 6. 30. 17.82% = 1.00 × 0.82 × 21.63%
2019. 3. 31. 18.60% = 1.00 × 0.83 × 22.29%
2018. 12. 31. 19.08% = 1.00 × 0.84 × 22.59%
2018. 9. 30. 19.46% = 1.00 × 0.85 × 22.80%
2018. 6. 30. 19.31% = 1.00 × 0.85 × 22.58%
2018. 3. 31. 18.52% = 1.00 × 0.85 × 21.79%
2017. 12. 31. 18.51% = 1.00 × 0.84 × 21.93%
2017. 9. 30. — = — × — × —
2017. 6. 30. — = — × — × —
2017. 3. 31. — = — × — × —

보고서 기준: 10-Q (보고 날짜: 2022-06-30), 10-Q (보고 날짜: 2022-03-31), 10-K (보고 날짜: 2021-12-31), 10-Q (보고 날짜: 2021-09-30), 10-Q (보고 날짜: 2021-06-30), 10-Q (보고 날짜: 2021-03-31), 10-K (보고 날짜: 2020-12-31), 10-Q (보고 날짜: 2020-09-30), 10-Q (보고 날짜: 2020-06-30), 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31).