Stock Analysis on Net

Royal Caribbean Cruises Ltd. (NYSE:RCL)

This company has been moved to the archive! The financial data has not been updated since July 29, 2022.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Two-Component Disaggregation of ROE

Royal Caribbean Cruises Ltd., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2022 -131.55% = -13.17% × 9.99
Mar 31, 2022 -132.77% = -16.08% × 8.26
Dec 31, 2021 -103.44% = -16.31% × 6.34
Sep 30, 2021 -81.49% = -16.13% × 5.05
Jun 30, 2021 -65.86% = -15.41% × 4.27
Mar 31, 2021 -59.80% = -15.97% × 3.74
Dec 31, 2020 -66.18% = -17.86% × 3.71
Sep 30, 2020 -49.92% = -13.06% × 3.82
Jun 30, 2020 -21.50% = -5.79% × 3.72
Mar 31, 2020 1.81% = 0.55% × 3.27
Dec 31, 2019 15.45% = 6.20% × 2.49
Sep 30, 2019 16.04% = 6.44% × 2.49
Jun 30, 2019 16.02% = 6.20% × 2.58
Mar 31, 2019 16.35% = 6.41% × 2.55
Dec 31, 2018 16.31% = 6.54% × 2.49
Sep 30, 2018 15.73% = 6.58% × 2.39
Jun 30, 2018 16.02% = 7.17% × 2.23
Mar 31, 2018 15.30% = 6.80% × 2.25
Dec 31, 2017 15.18% = 7.29% × 2.08
Sep 30, 2017 = × 2.12
Jun 30, 2017 = × 2.27
Mar 31, 2017 = × 2.38

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Three-Component Disaggregation of ROE

Royal Caribbean Cruises Ltd., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2022 -131.55% = -95.46% × 0.14 × 9.99
Mar 31, 2022 -132.77% = -207.74% × 0.08 × 8.26
Dec 31, 2021 -103.44% = -343.34% × 0.05 × 6.34
Sep 30, 2021 -81.49% = -902.44% × 0.02 × 5.05
Jun 30, 2021 -65.86% = -5,560.91% × 0.00 × 4.27
Mar 31, 2021 -59.80% = -2,515.12% × 0.01 × 3.74
Dec 31, 2020 -66.18% = -262.47% × 0.07 × 3.71
Sep 30, 2020 -49.92% = -88.60% × 0.15 × 3.82
Jun 30, 2020 -21.50% = -24.36% × 0.24 × 3.72
Mar 31, 2020 1.81% = 1.75% × 0.32 × 3.27
Dec 31, 2019 15.45% = 17.16% × 0.36 × 2.49
Sep 30, 2019 16.04% = 17.85% × 0.36 × 2.49
Jun 30, 2019 16.02% = 17.82% × 0.35 × 2.58
Mar 31, 2019 16.35% = 18.60% × 0.34 × 2.55
Dec 31, 2018 16.31% = 19.08% × 0.34 × 2.49
Sep 30, 2018 15.73% = 19.46% × 0.34 × 2.39
Jun 30, 2018 16.02% = 19.31% × 0.37 × 2.23
Mar 31, 2018 15.30% = 18.52% × 0.37 × 2.25
Dec 31, 2017 15.18% = 18.51% × 0.39 × 2.08
Sep 30, 2017 = × × 2.12
Jun 30, 2017 = × × 2.27
Mar 31, 2017 = × × 2.38

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Five-Component Disaggregation of ROE

Royal Caribbean Cruises Ltd., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Jun 30, 2022 -131.55% = × × -67.81% × 0.14 × 9.99
Mar 31, 2022 -132.77% = × × -156.86% × 0.08 × 8.26
Dec 31, 2021 -103.44% = × × -259.03% × 0.05 × 6.34
Sep 30, 2021 -81.49% = × × -683.09% × 0.02 × 5.05
Jun 30, 2021 -65.86% = × × -4,372.45% × 0.00 × 4.27
Mar 31, 2021 -59.80% = × × -2,045.62% × 0.01 × 3.74
Dec 31, 2020 -66.18% = × × -224.25% × 0.07 × 3.71
Sep 30, 2020 -49.92% = × × -74.41% × 0.15 × 3.82
Jun 30, 2020 -21.50% = × × -17.93% × 0.24 × 3.72
Mar 31, 2020 1.81% = 1.00 × 0.32 × 5.56% × 0.32 × 3.27
Dec 31, 2019 15.45% = 1.00 × 0.82 × 20.89% × 0.36 × 2.49
Sep 30, 2019 16.04% = 1.00 × 0.82 × 21.67% × 0.36 × 2.49
Jun 30, 2019 16.02% = 1.00 × 0.82 × 21.63% × 0.35 × 2.58
Mar 31, 2019 16.35% = 1.00 × 0.83 × 22.29% × 0.34 × 2.55
Dec 31, 2018 16.31% = 1.00 × 0.84 × 22.59% × 0.34 × 2.49
Sep 30, 2018 15.73% = 1.00 × 0.85 × 22.80% × 0.34 × 2.39
Jun 30, 2018 16.02% = 1.00 × 0.85 × 22.58% × 0.37 × 2.23
Mar 31, 2018 15.30% = 1.00 × 0.85 × 21.79% × 0.37 × 2.25
Dec 31, 2017 15.18% = 1.00 × 0.84 × 21.93% × 0.39 × 2.08
Sep 30, 2017 = × × × × 2.12
Jun 30, 2017 = × × × × 2.27
Mar 31, 2017 = × × × × 2.38

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Two-Component Disaggregation of ROA

Royal Caribbean Cruises Ltd., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2022 -13.17% = -95.46% × 0.14
Mar 31, 2022 -16.08% = -207.74% × 0.08
Dec 31, 2021 -16.31% = -343.34% × 0.05
Sep 30, 2021 -16.13% = -902.44% × 0.02
Jun 30, 2021 -15.41% = -5,560.91% × 0.00
Mar 31, 2021 -15.97% = -2,515.12% × 0.01
Dec 31, 2020 -17.86% = -262.47% × 0.07
Sep 30, 2020 -13.06% = -88.60% × 0.15
Jun 30, 2020 -5.79% = -24.36% × 0.24
Mar 31, 2020 0.55% = 1.75% × 0.32
Dec 31, 2019 6.20% = 17.16% × 0.36
Sep 30, 2019 6.44% = 17.85% × 0.36
Jun 30, 2019 6.20% = 17.82% × 0.35
Mar 31, 2019 6.41% = 18.60% × 0.34
Dec 31, 2018 6.54% = 19.08% × 0.34
Sep 30, 2018 6.58% = 19.46% × 0.34
Jun 30, 2018 7.17% = 19.31% × 0.37
Mar 31, 2018 6.80% = 18.52% × 0.37
Dec 31, 2017 7.29% = 18.51% × 0.39
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Four-Component Disaggregation of ROA

Royal Caribbean Cruises Ltd., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Jun 30, 2022 -13.17% = × × -67.81% × 0.14
Mar 31, 2022 -16.08% = × × -156.86% × 0.08
Dec 31, 2021 -16.31% = × × -259.03% × 0.05
Sep 30, 2021 -16.13% = × × -683.09% × 0.02
Jun 30, 2021 -15.41% = × × -4,372.45% × 0.00
Mar 31, 2021 -15.97% = × × -2,045.62% × 0.01
Dec 31, 2020 -17.86% = × × -224.25% × 0.07
Sep 30, 2020 -13.06% = × × -74.41% × 0.15
Jun 30, 2020 -5.79% = × × -17.93% × 0.24
Mar 31, 2020 0.55% = 1.00 × 0.32 × 5.56% × 0.32
Dec 31, 2019 6.20% = 1.00 × 0.82 × 20.89% × 0.36
Sep 30, 2019 6.44% = 1.00 × 0.82 × 21.67% × 0.36
Jun 30, 2019 6.20% = 1.00 × 0.82 × 21.63% × 0.35
Mar 31, 2019 6.41% = 1.00 × 0.83 × 22.29% × 0.34
Dec 31, 2018 6.54% = 1.00 × 0.84 × 22.59% × 0.34
Sep 30, 2018 6.58% = 1.00 × 0.85 × 22.80% × 0.34
Jun 30, 2018 7.17% = 1.00 × 0.85 × 22.58% × 0.37
Mar 31, 2018 6.80% = 1.00 × 0.85 × 21.79% × 0.37
Dec 31, 2017 7.29% = 1.00 × 0.84 × 21.93% × 0.39
Sep 30, 2017 = × × ×
Jun 30, 2017 = × × ×
Mar 31, 2017 = × × ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Disaggregation of Net Profit Margin

Royal Caribbean Cruises Ltd., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Jun 30, 2022 -95.46% = × × -67.81%
Mar 31, 2022 -207.74% = × × -156.86%
Dec 31, 2021 -343.34% = × × -259.03%
Sep 30, 2021 -902.44% = × × -683.09%
Jun 30, 2021 -5,560.91% = × × -4,372.45%
Mar 31, 2021 -2,515.12% = × × -2,045.62%
Dec 31, 2020 -262.47% = × × -224.25%
Sep 30, 2020 -88.60% = × × -74.41%
Jun 30, 2020 -24.36% = × × -17.93%
Mar 31, 2020 1.75% = 1.00 × 0.32 × 5.56%
Dec 31, 2019 17.16% = 1.00 × 0.82 × 20.89%
Sep 30, 2019 17.85% = 1.00 × 0.82 × 21.67%
Jun 30, 2019 17.82% = 1.00 × 0.82 × 21.63%
Mar 31, 2019 18.60% = 1.00 × 0.83 × 22.29%
Dec 31, 2018 19.08% = 1.00 × 0.84 × 22.59%
Sep 30, 2018 19.46% = 1.00 × 0.85 × 22.80%
Jun 30, 2018 19.31% = 1.00 × 0.85 × 22.58%
Mar 31, 2018 18.52% = 1.00 × 0.85 × 21.79%
Dec 31, 2017 18.51% = 1.00 × 0.84 × 21.93%
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).