Stock Analysis on Net
Stock Analysis on Net

Royal Caribbean Cruises Ltd. (NYSE:RCL)

この会社は アーカイブに移動しました! 2022年7月29日以降、財務データは更新されていません。

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

Microsoft Excel

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

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

Royal Caribbean Cruises Ltd.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/06/30 -131.55% = -13.17% × 9.99
2022/03/31 -132.77% = -16.08% × 8.26
2021/12/31 -103.44% = -16.31% × 6.34
2021/09/30 -81.49% = -16.13% × 5.05
2021/06/30 -65.86% = -15.41% × 4.27
2021/03/31 -59.80% = -15.97% × 3.74
2020/12/31 -66.18% = -17.86% × 3.71
2020/09/30 -49.92% = -13.06% × 3.82
2020/06/30 -21.50% = -5.79% × 3.72
2020/03/31 1.81% = 0.55% × 3.27
2019/12/31 15.45% = 6.20% × 2.49
2019/09/30 16.04% = 6.44% × 2.49
2019/06/30 16.02% = 6.20% × 2.58
2019/03/31 16.35% = 6.41% × 2.55
2018/12/31 16.31% = 6.54% × 2.49
2018/09/30 15.73% = 6.58% × 2.39
2018/06/30 16.02% = 7.17% × 2.23
2018/03/31 15.30% = 6.80% × 2.25
2017/12/31 15.18% = 7.29% × 2.08
2017/09/30 — = — × 2.12
2017/06/30 — = — × 2.27
2017/03/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を3つの要素に分解

Royal Caribbean Cruises Ltd.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/06/30 -131.55% = -95.46% × 0.14 × 9.99
2022/03/31 -132.77% = -207.74% × 0.08 × 8.26
2021/12/31 -103.44% = -343.34% × 0.05 × 6.34
2021/09/30 -81.49% = -902.44% × 0.02 × 5.05
2021/06/30 -65.86% = -5,560.91% × 0.00 × 4.27
2021/03/31 -59.80% = -2,515.12% × 0.01 × 3.74
2020/12/31 -66.18% = -262.47% × 0.07 × 3.71
2020/09/30 -49.92% = -88.60% × 0.15 × 3.82
2020/06/30 -21.50% = -24.36% × 0.24 × 3.72
2020/03/31 1.81% = 1.75% × 0.32 × 3.27
2019/12/31 15.45% = 17.16% × 0.36 × 2.49
2019/09/30 16.04% = 17.85% × 0.36 × 2.49
2019/06/30 16.02% = 17.82% × 0.35 × 2.58
2019/03/31 16.35% = 18.60% × 0.34 × 2.55
2018/12/31 16.31% = 19.08% × 0.34 × 2.49
2018/09/30 15.73% = 19.46% × 0.34 × 2.39
2018/06/30 16.02% = 19.31% × 0.37 × 2.23
2018/03/31 15.30% = 18.52% × 0.37 × 2.25
2017/12/31 15.18% = 18.51% × 0.39 × 2.08
2017/09/30 — = — × — × 2.12
2017/06/30 — = — × — × 2.27
2017/03/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/06/30 -131.55% = — × — × -67.81% × 0.14 × 9.99
2022/03/31 -132.77% = — × — × -156.86% × 0.08 × 8.26
2021/12/31 -103.44% = — × — × -259.03% × 0.05 × 6.34
2021/09/30 -81.49% = — × — × -683.09% × 0.02 × 5.05
2021/06/30 -65.86% = — × — × -4,372.45% × 0.00 × 4.27
2021/03/31 -59.80% = — × — × -2,045.62% × 0.01 × 3.74
2020/12/31 -66.18% = — × — × -224.25% × 0.07 × 3.71
2020/09/30 -49.92% = — × — × -74.41% × 0.15 × 3.82
2020/06/30 -21.50% = — × — × -17.93% × 0.24 × 3.72
2020/03/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/09/30 16.04% = 1.00 × 0.82 × 21.67% × 0.36 × 2.49
2019/06/30 16.02% = 1.00 × 0.82 × 21.63% × 0.35 × 2.58
2019/03/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/09/30 15.73% = 1.00 × 0.85 × 22.80% × 0.34 × 2.39
2018/06/30 16.02% = 1.00 × 0.85 × 22.58% × 0.37 × 2.23
2018/03/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/09/30 — = — × — × — × — × 2.12
2017/06/30 — = — × — × — × — × 2.27
2017/03/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を2つのコンポーネントに分解

Royal Caribbean Cruises Ltd.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/06/30 -13.17% = -95.46% × 0.14
2022/03/31 -16.08% = -207.74% × 0.08
2021/12/31 -16.31% = -343.34% × 0.05
2021/09/30 -16.13% = -902.44% × 0.02
2021/06/30 -15.41% = -5,560.91% × 0.00
2021/03/31 -15.97% = -2,515.12% × 0.01
2020/12/31 -17.86% = -262.47% × 0.07
2020/09/30 -13.06% = -88.60% × 0.15
2020/06/30 -5.79% = -24.36% × 0.24
2020/03/31 0.55% = 1.75% × 0.32
2019/12/31 6.20% = 17.16% × 0.36
2019/09/30 6.44% = 17.85% × 0.36
2019/06/30 6.20% = 17.82% × 0.35
2019/03/31 6.41% = 18.60% × 0.34
2018/12/31 6.54% = 19.08% × 0.34
2018/09/30 6.58% = 19.46% × 0.34
2018/06/30 7.17% = 19.31% × 0.37
2018/03/31 6.80% = 18.52% × 0.37
2017/12/31 7.29% = 18.51% × 0.39
2017/09/30 — = — × —
2017/06/30 — = — × —
2017/03/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/06/30 -13.17% = — × — × -67.81% × 0.14
2022/03/31 -16.08% = — × — × -156.86% × 0.08
2021/12/31 -16.31% = — × — × -259.03% × 0.05
2021/09/30 -16.13% = — × — × -683.09% × 0.02
2021/06/30 -15.41% = — × — × -4,372.45% × 0.00
2021/03/31 -15.97% = — × — × -2,045.62% × 0.01
2020/12/31 -17.86% = — × — × -224.25% × 0.07
2020/09/30 -13.06% = — × — × -74.41% × 0.15
2020/06/30 -5.79% = — × — × -17.93% × 0.24
2020/03/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/09/30 6.44% = 1.00 × 0.82 × 21.67% × 0.36
2019/06/30 6.20% = 1.00 × 0.82 × 21.63% × 0.35
2019/03/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/09/30 6.58% = 1.00 × 0.85 × 22.80% × 0.34
2018/06/30 7.17% = 1.00 × 0.85 × 22.58% × 0.37
2018/03/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/09/30 — = — × — × — × —
2017/06/30 — = — × — × — × —
2017/03/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/06/30 -95.46% = — × — × -67.81%
2022/03/31 -207.74% = — × — × -156.86%
2021/12/31 -343.34% = — × — × -259.03%
2021/09/30 -902.44% = — × — × -683.09%
2021/06/30 -5,560.91% = — × — × -4,372.45%
2021/03/31 -2,515.12% = — × — × -2,045.62%
2020/12/31 -262.47% = — × — × -224.25%
2020/09/30 -88.60% = — × — × -74.41%
2020/06/30 -24.36% = — × — × -17.93%
2020/03/31 1.75% = 1.00 × 0.32 × 5.56%
2019/12/31 17.16% = 1.00 × 0.82 × 20.89%
2019/09/30 17.85% = 1.00 × 0.82 × 21.67%
2019/06/30 17.82% = 1.00 × 0.82 × 21.63%
2019/03/31 18.60% = 1.00 × 0.83 × 22.29%
2018/12/31 19.08% = 1.00 × 0.84 × 22.59%
2018/09/30 19.46% = 1.00 × 0.85 × 22.80%
2018/06/30 19.31% = 1.00 × 0.85 × 22.58%
2018/03/31 18.52% = 1.00 × 0.85 × 21.79%
2017/12/31 18.51% = 1.00 × 0.84 × 21.93%
2017/09/30 — = — × — × —
2017/06/30 — = — × — × —
2017/03/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).