Stock Analysis on Net

Royal Caribbean Cruises Ltd. (NYSE:RCL)

$22.49

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

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

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

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×

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).


The analysis of the financial ratios over the observed periods reveals notable trends with respect to the company's profitability and leverage.

Return on Assets (ROA)
The ROA exhibited relatively stable and positive values from March 2018 through December 2019, fluctuating in a narrow band around 6 to 7 percent, indicating consistent asset profitability in this period. However, starting in March 2020, a sharp and sustained decline occurred, plummeting to 0.55% and quickly turning negative from June 2020 onwards. The downward trajectory continued with ROA hitting a trough near -17.86% by December 2020 and remained deeply negative across subsequent quarters until June 2022, though showing some slight improvement from the lowest point.
Financial Leverage
Financial leverage showed a gradual but steady increase from 2.23 times in mid-2018 to about 2.58 times in mid-2019, suggesting a moderate increase in debt relative to equity. Post-March 2020, there was a pronounced escalation in leverage, rising sharply from 3.27 times to nearly 10 times by June 2022. This significant increase indicates a substantial rise in financing through debt or other liabilities during the period marked by decreasing profitability.
Return on Equity (ROE)
The ROE paralleled the trend observed in ROA, maintaining a strong and steady range between approximately 15% and 16.5% from early 2018 until the end of 2019, reflecting effective use of equity to generate net income. Beginning in the first quarter of 2020, ROE experienced an unprecedented collapse to 1.81% and rapidly deteriorated into significantly negative figures, reaching a nadir of approximately -132.77% by the first quarter of 2022. This severe negative return on equity implies substantial losses relative to shareholders' equity, coinciding with the period of increasing financial leverage.

In summary, the company maintained stable profitability and moderate leverage through 2018 and 2019. From early 2020, coinciding with external disruptions, there was a stark deterioration in profitability metrics (ROA and ROE), coupled with a sharp rise in financial leverage. The negative returns and increased debt levels suggest considerable financial stress and challenges in generating profits from both assets and equity during the recent quarters analyzed.


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 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
Sep 30, 2018 = × ×
Jun 30, 2018 = × ×
Mar 31, 2018 = × ×

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).


The analysis of quarterly financial ratios reveals significant shifts over the observed periods, highlighting both operational and financial challenges followed by some signs of gradual improvement.

Net Profit Margin
The net profit margin demonstrated stability from early 2018 through 2019, maintaining levels around 17-19%. However, from March 2020 onwards, there was a steep decline, plunging into substantially negative territory. The worst margin occurred in the first half of 2021, reaching values below -5,000%, indicating severe losses relative to revenues. Following this period, there was some recovery evident by 2022, though margins remained negative, settling closer to -95.46% by mid-2022, signaling ongoing profitability challenges but at relatively moderated losses compared to the peak downturn.
Asset Turnover
Asset turnover ratios were relatively consistent across 2018 and 2019, fluctuating slightly around 0.34 to 0.37. This consistency suggests stable efficiency in generating revenue from assets. Starting in 2020, asset turnover sharply declined, bottoming out near 0.00 in mid-2021, reflecting a significant decrease in asset utilization efficiency. By 2022, a gradual improvement trend emerged, with turnover ratios increasing to about 0.14 by mid-year, indicating a slow recovery in generating sales from asset base.
Financial Leverage
Financial leverage exhibited a steady upward trend throughout the entire timeframe. Starting from approximately 2.25 in early 2018, it increased moderately until early 2020, when it rose more sharply. By mid-2022, leverage reached nearly 10.0, indicating a substantial increase in debt relative to equity. This rising leverage suggests growing financial risk and a reliance on additional financing, potentially to cover operational deficits or fund restructuring efforts during the challenging periods.
Return on Equity (ROE)
ROE remained stable and positive, around 15-16%, through 2018 and 2019, reflecting consistent profitability for shareholders. From March 2020, however, it experienced a dramatic decline, turning negative and worsening progressively through 2021. The deepest negative returns were observed by late 2021, indicating significant erosion of shareholder value. A slight rebound was noticed in 2022 but ROE remained deeply negative, near -130%, underscoring continued difficulty in generating positive returns despite some operational recovery.

Overall, the financial ratios reflect the severe impact of adverse events beginning in early 2020, leading to diminished profitability, reduced operational efficiency, and increased financial leverage. Recent quarters show some early signs of operational recovery and better asset utilization, but profitability and returns to equity holders remain significantly strained. The substantial increase in financial leverage poses additional concerns regarding financial risk and long-term sustainability.


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 = × × × ×
Mar 31, 2022 = × × × ×
Dec 31, 2021 = × × × ×
Sep 30, 2021 = × × × ×
Jun 30, 2021 = × × × ×
Mar 31, 2021 = × × × ×
Dec 31, 2020 = × × × ×
Sep 30, 2020 = × × × ×
Jun 30, 2020 = × × × ×
Mar 31, 2020 = × × × ×
Dec 31, 2019 = × × × ×
Sep 30, 2019 = × × × ×
Jun 30, 2019 = × × × ×
Mar 31, 2019 = × × × ×
Dec 31, 2018 = × × × ×
Sep 30, 2018 = × × × ×
Jun 30, 2018 = × × × ×
Mar 31, 2018 = × × × ×

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).


The quarterly financial data reveals several distinct trends in the company's financial performance over the observed periods. Key profitability and efficiency metrics indicate a period of stable operations followed by significant challenges beginning in early 2020.

Tax Burden
The tax burden ratio remained consistently at 1 across all available periods, indicating that there were no variations in the effective tax rate or that taxes were neutral in influencing profitability during the entire timeframe.
Interest Burden
The interest burden ratio showed a slight decline from approximately 0.85 in early 2018 to about 0.82 by the end of 2019. However, from the first quarter of 2020 onwards, the values are missing, which may suggest disruptions in interest expense reporting or changing financial conditions.
EBIT Margin
The EBIT margin was relatively stable, fluctuating between approximately 20.9% and 22.8% from 2018 through 2019, reflecting healthy operational profitability. Starting in March 2020, there was an abrupt and severe deterioration in EBIT margin, plunging to -17.93% and subsequently worsening dramatically to as low as -4,372.45% in June 2021. After this low point, the margin improved somewhat but remained deeply negative through mid-2022, indicative of sustained operational losses or extraordinary expenses likely linked to external economic or industry-specific shocks.
Asset Turnover
The asset turnover ratio demonstrated a gradual decline from a range near 0.34-0.37 in 2018 and 2019 down to very low levels starting in 2020, hitting a minimum around 0.01 in early 2021. This trend implies substantially reduced efficiency in generating revenues from assets during the crisis period. Some modest recovery is observable by mid-2022, rising to 0.14, yet still below pre-2020 levels.
Financial Leverage
The financial leverage ratio was relatively stable around 2.2 to 2.6 from 2018 through 2019 but increased sharply beginning in early 2020. This upward trend continued over subsequent quarters, reaching nearly 10 by mid-2022. The steady increase suggests that the company has taken on significantly more debt relative to equity, possibly to manage liquidity needs or to stabilize operations amid adverse conditions.
Return on Equity (ROE)
ROE was consistently positive and stable between approximately 15% and 16.4% in 2018 and 2019, underlying satisfactory returns on shareholder investments. Beginning in the first quarter of 2020, ROE plunged dramatically into negative territory, reaching -132.77% in early 2022. This indicates substantial losses eroding shareholder value during this period, reflecting a severe downturn in financial performance.

Overall, the data reveals a stable and profitable operational phase through 2019, followed by a sharp financial crisis starting in early 2020, characterized by deteriorated profitability, efficiency, and returns, alongside increased financial leverage. Partial recovery signs emerge toward mid-2022 but remain far below historical performance levels.


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 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×

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).


The financial data reveals significant fluctuations and distinct trends in key profitability and efficiency metrics over the observed periods.

Net Profit Margin
From March 2018 through December 2019, the net profit margin remained relatively stable, fluctuating slightly between approximately 17% and 19%, indicating consistent profitability during this timeframe. Starting in March 2020, there is a pronounced and severe decline, with margins turning sharply negative. The margin reached extremely large negative values, peaking in December 2020 at -262.47% and continuing to worsen until June 2021, where it plummeted to -5560.91%. After this nadir, the loss margin improved but remained deeply negative through mid-2022, reflecting ongoing challenges in profitability.
Asset Turnover
Asset turnover ratios generally showed a narrow range but downward trend from early 2018 up to early 2020, moving from about 0.37 to a lower 0.32 ratio. Following this period, asset turnover sharply declined, reaching near zero by mid-2021, reflecting significantly reduced efficiency in utilizing assets to generate revenue. A gradual, albeit modest, recovery in asset turnover is visible from late 2021 into mid-2022, with the ratio increasing from virtually zero to 0.14, signaling some improvement in operational performance.
Return on Assets (ROA)
ROA exhibited a stable and positive pattern during the initial periods through 2019, ranging between about 6.2% and 7.17%. However, coinciding with the decrease in net profit margin and asset turnover from 2020 onwards, ROA moved into negative territory starting in March 2020. The decline deepened abruptly, reaching a low of -17.86% in December 2020. Despite some fluctuations, ROA remained negative through mid-2022, though there was a slight improvement from the worst values, indicating sustained difficulty in generating returns from company assets during this period.

Overall, the data shows that the company experienced stable profitability and asset efficiency before 2020, followed by a sharp deterioration coinciding with external environmental or industry challenges. Despite some preliminary recovery signs in mid-2021 and onward, profitability and asset utilization metrics remain substantially impaired as of mid-2022.


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 = × × ×
Mar 31, 2022 = × × ×
Dec 31, 2021 = × × ×
Sep 30, 2021 = × × ×
Jun 30, 2021 = × × ×
Mar 31, 2021 = × × ×
Dec 31, 2020 = × × ×
Sep 30, 2020 = × × ×
Jun 30, 2020 = × × ×
Mar 31, 2020 = × × ×
Dec 31, 2019 = × × ×
Sep 30, 2019 = × × ×
Jun 30, 2019 = × × ×
Mar 31, 2019 = × × ×
Dec 31, 2018 = × × ×
Sep 30, 2018 = × × ×
Jun 30, 2018 = × × ×
Mar 31, 2018 = × × ×

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).


The analysis of the financial ratios over the observed periods reveals notable trends and shifts in operational efficiency, profitability, and asset utilization.

Tax Burden
The tax burden ratio remains constant at 1 throughout the available data, suggesting no effective tax expense or a neutral tax impact on earnings during these periods.
Interest Burden
Interest burden shows a slight declining trend from 0.85 in early 2018 to 0.82 by the end of 2019, indicating marginally increasing interest expense relative to earnings before interest and taxes. There is a significant drop to 0.32 at March 31, 2020, suggesting a sharp rise in interest costs or financial restructuring at that point. Subsequent data for interest burden is not available for analysis.
EBIT Margin
The EBIT margin exhibits stability around the 20-23% range from early 2018 through 2019, reflecting consistent operational profitability. However, beginning in the first quarter of 2020, there is a drastic decline, plunging to negative values with substantial losses reaching as low as -4372.45% in the second quarter of 2021. Although the margin improves somewhat thereafter, it remains deeply negative through mid-2022. This pattern indicates severe operational disruptions, likely tied to extraordinary circumstances impacting earnings before interest and taxes.
Asset Turnover
Asset turnover ratios display relative stability at approximately 0.34 to 0.37 during 2018 and 2019, reflecting consistent efficiency in generating revenue from assets. From 2020 onward, there is a sharp decline to as low as 0.01 in the first quarter of 2021, followed by a gradual recovery to 0.14 by mid-2022. These movements point to reduced asset utilization during periods of operational difficulty, recovering slowly over time.
Return on Assets (ROA)
The ROA follows a positive and steady trend around 6% to 7% in 2018 and 2019, indicating healthy profitability relative to asset base. Beginning in 2020, it turns negative, falling to -16% or worse, consistent with the negative EBIT margin trend. Slight fluctuations are observed thereafter but the ratio remains negative through mid-2022, signifying sustained asset value erosion and impaired profitability during this timeframe.

In summary, the data illustrates a period of strong financial performance up until the end of 2019, followed by a severe downturn starting in early 2020. The impairment is characterized by sharp declines in profitability and asset utilization, which persist with gradual signs of improvement by mid-2022. The trends suggest the occurrence of significant adverse events affecting operational and financial results, with gradual attempts at recovery visible in later periods.


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 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
Sep 30, 2018 = × ×
Jun 30, 2018 = × ×
Mar 31, 2018 = × ×

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).


The analysis of the quarterly financial ratios indicates distinct patterns and significant fluctuations over the observed periods.

Tax Burden
The Tax Burden ratio remains consistently at 1 across all quarters from the start through mid-2022, indicating no apparent impact from taxes on earnings or a stable tax environment during this timeframe.
Interest Burden

This ratio shows a slight declining trend from 0.85 in early 2018 to 0.82 by late 2019, suggesting a marginal increase in interest expenses relative to earnings before interest and taxes. In the first quarter of 2020, the ratio drops markedly to 0.32, pointing to a significant rise in interest burden or interest expense possibly due to increased financing costs or debt levels. No data is available beyond that quarter to assess further changes.

EBIT Margin

This margin demonstrates stable performance hovering around 21-23% from early 2018 through the end of 2019, reflecting consistent operational profitability. However, a dramatic decline begins by March 2020 with the margin plummeting to 5.56%, then deteriorating sharply into negative territory with progressively worsening losses through 2020 and 2021. The margin reaches extreme negative values exceeding -2000% in early 2021, signaling severe operational challenges. Although the margin improves slightly by 2022, it remains deeply negative, implying continuing struggles with earnings before interest and taxes.

Net Profit Margin

The Net Profit Margin mirrors the EBIT margin trend, maintaining a healthy range around 18-19% from 2018 through 2019. Starting from the first quarter of 2020, the margin drastically declines into negative figures, hitting severe lows beyond -5000% in early 2021. While some recovery is evident by mid-2022, profitability remains significantly below historical levels. This pattern indicates substantial net losses likely driven by either operational disruption, increased costs, or impaired revenues.

Overall, the data reflects a stable and profitable environment during 2018 and 2019, followed by a sharp downturn beginning in early 2020. This downturn severely impacts operational earnings and net profitability, with limited signs of full recovery by mid-2022. The increased interest burden in early 2020 may have contributed to higher financial expenses during this period.