DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data
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 (quarterly data)
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
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).