Stock Analysis on Net
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

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

Royal Caribbean Cruises Ltd., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2021 -103.44% = -16.31% × 6.34
Dec 31, 2020 -66.18% = -17.86% × 3.71
Dec 31, 2019 15.45% = 6.20% × 2.49
Dec 31, 2018 16.31% = 6.54% × 2.49
Dec 31, 2017 15.18% = 7.29% × 2.08

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Three-Component Disaggregation of ROE

Royal Caribbean Cruises Ltd., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 -103.44% = -343.34% × 0.05 × 6.34
Dec 31, 2020 -66.18% = -262.47% × 0.07 × 3.71
Dec 31, 2019 15.45% = 17.16% × 0.36 × 2.49
Dec 31, 2018 16.31% = 19.08% × 0.34 × 2.49
Dec 31, 2017 15.18% = 18.51% × 0.39 × 2.08

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Five-Component Disaggregation of ROE

Royal Caribbean Cruises Ltd., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 -103.44% = — × — × -261.98% × 0.05 × 6.34
Dec 31, 2020 -66.18% = — × — × -224.93% × 0.07 × 3.71
Dec 31, 2019 15.45% = 0.98 × 0.82 × 21.19% × 0.36 × 2.49
Dec 31, 2018 16.31% = 0.99 × 0.85 × 22.81% × 0.34 × 2.49
Dec 31, 2017 15.18% = 0.99 × 0.85 × 22.14% × 0.39 × 2.08

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Two-Component Disaggregation of ROA

Royal Caribbean Cruises Ltd., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2021 -16.31% = -343.34% × 0.05
Dec 31, 2020 -17.86% = -262.47% × 0.07
Dec 31, 2019 6.20% = 17.16% × 0.36
Dec 31, 2018 6.54% = 19.08% × 0.34
Dec 31, 2017 7.29% = 18.51% × 0.39

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Four-Component Disaggregation of ROA

Royal Caribbean Cruises Ltd., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2021 -16.31% = — × — × -261.98% × 0.05
Dec 31, 2020 -17.86% = — × — × -224.93% × 0.07
Dec 31, 2019 6.20% = 0.98 × 0.82 × 21.19% × 0.36
Dec 31, 2018 6.54% = 0.99 × 0.85 × 22.81% × 0.34
Dec 31, 2017 7.29% = 0.99 × 0.85 × 22.14% × 0.39

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Disaggregation of Net Profit Margin

Royal Caribbean Cruises Ltd., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2021 -343.34% = — × — × -261.98%
Dec 31, 2020 -262.47% = — × — × -224.93%
Dec 31, 2019 17.16% = 0.98 × 0.82 × 21.19%
Dec 31, 2018 19.08% = 0.99 × 0.85 × 22.81%
Dec 31, 2017 18.51% = 0.99 × 0.85 × 22.14%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).