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.

Analysis of Short-term (Operating) Activity Ratios

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

Short-term Activity Ratios (Summary)

Royal Caribbean Cruises Ltd., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Turnover Ratios
Inventory turnover
Receivables turnover
Payables turnover
Working capital turnover
Average No. Days
Average inventory processing period
Add: Average receivable collection period
Operating cycle
Less: Average payables payment period
Cash conversion cycle

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


The financial ratios and related operational metrics indicate significant shifts over the analyzed period, reflecting notable changes in the company's operational efficiency and cash flow management.

Inventory Turnover
The inventory turnover ratio has exhibited a downward trend from 43.96 in 2017 to 17.69 in 2021. This decline suggests a slowing rate at which inventory is sold or used, potentially indicating slower sales or overstocking in later years.
Receivables Turnover
The receivables turnover ratio initially increased from 27.55 in 2017 to a peak of 35.81 in 2019, denoting improved collection efficiency. However, a dramatic decline occurred from 2020 onwards, falling to 3.75 by 2021. This implies a significant delay in collecting customer receivables, which could affect liquidity negatively.
Payables Turnover
The payables turnover ratio decreased steadily from 13.6 in 2017 to 4.87 in 2021, indicating that the company is taking longer to pay its suppliers over time. This trend might be a strategic effort to conserve cash but could also strain supplier relationships.
Average Inventory Processing Period
The average inventory processing period has lengthened from 8 days in 2017 to 21 days in 2021, consistent with the decreasing inventory turnover ratio and suggesting slower movement of inventory through the system.
Average Receivable Collection Period
There is a substantial increase in the average receivable collection period from 13 days in 2017 to 97 days in 2021. This extended period represents a significant slowdown in cash inflows from customers, increasing the risk of cash flow challenges and potentially indicating difficulties in credit management or customer payment behavior changes.
Operating Cycle
The operating cycle, representing the total time from inventory purchase to cash collection, nearly sextupled from 21 days in 2017 to 118 days in 2021. This extension highlights a lengthening operational process and capital tied up in working capital.
Average Payables Payment Period
This metric increased from 27 days in 2017 to 75 days in 2021, aligning with the decline in payables turnover. The company appears to be extending its payment terms, possibly to improve short-term liquidity, but this could have repercussions on supplier relations.
Cash Conversion Cycle
The cash conversion cycle shifted from negative values in the initial years (e.g., -6 days in 2017) to positive and increasing values, reaching 43 days in 2021. A negative cash conversion cycle typically indicates that the company is collecting cash faster than it pays its bills. The transition to a positive and growing cash conversion cycle suggests that the lag between cash outflows and inflows has increased, which may pressure working capital and cash reserves.

Overall, the trends depict a deterioration in operational efficiency and working capital management from 2019 onward. The increasing durations in inventory holding, receivables collection, and payables payment have cumulatively extended the operating and cash conversion cycles. This situation may reflect challenges posed by external factors impacting business performance or internal operational inefficiencies, both of which warrant attention to restore liquidity and optimize working capital use.


Turnover Ratios


Average No. Days


Inventory Turnover

Royal Caribbean Cruises Ltd., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Cruise operating expenses
Inventories
Short-term Activity Ratio
Inventory turnover1
Benchmarks
Inventory Turnover, Competitors2
Chipotle Mexican Grill Inc.
McDonald’s Corp.
Starbucks Corp.
Inventory Turnover, Sector
Consumer Services
Inventory Turnover, Industry
Consumer Discretionary

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

1 2021 Calculation
Inventory turnover = Cruise operating expenses ÷ Inventories
= ÷ =

2 Click competitor name to see calculations.


Cruise Operating Expenses
The cruise operating expenses displayed an overall upward trend from 2017 to 2019, increasing from approximately $4.90 billion to about $6.06 billion. This suggests rising costs associated with cruise operations during this period. However, there was a sharp decrease in 2020 and 2021, with expenses falling to roughly $2.77 billion and $2.66 billion respectively. This decline could be reflective of operational adjustments or cost-saving measures, potentially driven by external factors affecting the industry.
Inventories
Inventory levels increased from 2017 to 2019, rising from $111 million to $162 million, indicating accumulation or stockpiling during these years. In 2020, inventories decreased to approximately $119 million, possibly due to reduced operations or supply chain adjustments. By the end of 2021, inventories had risen again to about $150 million, suggesting a partial recovery or replenishment of stock levels.
Inventory Turnover
Inventory turnover exhibited a decreasing trend over the observed period. Starting at a high ratio of 43.96 in 2017, the turnover declined to 34.27 in 2018 and rebounded slightly to 37.4 in 2019. However, significant declines occurred in 2020 and 2021, with ratios dropping to 23.29 and then to 17.69. The decreasing turnover ratios indicate that inventory is being held longer before being used or sold, which may signal slowing demand, operational disruptions, or changes in inventory management efficiency.

Receivables Turnover

Royal Caribbean Cruises Ltd., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Revenues
Trade and other receivables, net of allowances
Short-term Activity Ratio
Receivables turnover1
Benchmarks
Receivables Turnover, Competitors2
Airbnb Inc.
Booking Holdings Inc.
Chipotle Mexican Grill Inc.
DoorDash, Inc.
McDonald’s Corp.
Starbucks Corp.
Receivables Turnover, Sector
Consumer Services
Receivables Turnover, Industry
Consumer Discretionary

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

1 2021 Calculation
Receivables turnover = Revenues ÷ Trade and other receivables, net of allowances
= ÷ =

2 Click competitor name to see calculations.


Revenues
Revenues showed a general upward trend from 2017 through 2019, increasing from approximately 8.78 billion US dollars to over 10.95 billion US dollars. However, there was a dramatic decline in 2020 to about 2.21 billion US dollars, which continued to decrease further in 2021 to approximately 1.53 billion US dollars. This sharp decrease reflects a significant disruption in the business environment beginning in 2020.
Trade and other receivables, net of allowances
The net trade and other receivables remained relatively stable from 2017 to 2020, fluctuating within the range of 284 million to 325 million US dollars. In 2021, there was a notable increase to approximately 408 million US dollars, marking a departure from the previous stability and suggesting changes in credit extended to customers or collection patterns during that period.
Receivables turnover
The receivables turnover ratio demonstrated an increasing trend from 27.55 in 2017 to a peak of 35.81 in 2019, indicating improving efficiency in collecting receivables. However, this ratio deteriorated sharply in 2020 to 7.77 and further declined to 3.75 in 2021. This decline indicates challenges in receivables collection efficiency, likely correlated with the revenue decrease and changing credit management conditions during those years.

Payables Turnover

Royal Caribbean Cruises Ltd., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Cruise operating expenses
Accounts payable
Short-term Activity Ratio
Payables turnover1
Benchmarks
Payables Turnover, Competitors2
Airbnb Inc.
Booking Holdings Inc.
Chipotle Mexican Grill Inc.
DoorDash, Inc.
McDonald’s Corp.
Starbucks Corp.
Payables Turnover, Sector
Consumer Services
Payables Turnover, Industry
Consumer Discretionary

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

1 2021 Calculation
Payables turnover = Cruise operating expenses ÷ Accounts payable
= ÷ =

2 Click competitor name to see calculations.


Cruise Operating Expenses
The cruise operating expenses exhibited an overall increasing trend from 2017 to 2019, rising from approximately 4.90 billion to 6.06 billion US dollars. However, a significant decline is observed in 2020, where expenses decreased sharply to about 2.77 billion, likely reflecting operational impacts during that period. This downward trend continued into 2021, with expenses further decreasing slightly to around 2.66 billion.
Accounts Payable
Accounts payable showed a fluctuating pattern over the five-year period. Starting at around 360 million in 2017, it increased to approximately 563.7 million by the end of 2019. In 2020, a noticeable decline occurred, with accounts payable dropping to about 353 million, before rising again in 2021 to approximately 546 million. This pattern indicates variability likely linked to changes in operational and purchasing activities.
Payables Turnover Ratio
The payables turnover ratio demonstrated a steady decline over the period from 13.6 in 2017 to 4.87 in 2021. This trend suggests a slowing in the rate at which the company settles its accounts payable, indicating that payables are being held longer over time. The most marked decreases occurred post-2019, aligned with the evident operational disruptions and reduced expenses seen in the other metrics.

Working Capital Turnover

Royal Caribbean Cruises Ltd., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Current assets
Less: Current liabilities
Working capital
 
Revenues
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Airbnb Inc.
Booking Holdings Inc.
Chipotle Mexican Grill Inc.
DoorDash, Inc.
McDonald’s Corp.
Starbucks Corp.
Working Capital Turnover, Sector
Consumer Services
Working Capital Turnover, Industry
Consumer Discretionary

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

1 2021 Calculation
Working capital turnover = Revenues ÷ Working capital
= ÷ =

2 Click competitor name to see calculations.


The annual financial data reveals several important trends related to the company's working capital and revenues over the period from 2017 to 2021.

Working Capital
The working capital figures exhibit a consistently negative balance throughout the entire period analyzed. This negative working capital intensifies from 2017 to 2019, reaching its lowest point in 2019 at approximately -6.79 billion US dollars. In 2020, there is a significant improvement as the negative working capital narrows drastically to around -225 million US dollars, which could be related to a reduction in operational scale or cost control measures. However, in 2021, the working capital again deteriorates, expanding negatively to approximately -3.69 billion US dollars, indicating possible ongoing liquidity challenges.
Revenues
Revenues show a generally increasing trend from 2017 through 2019, rising from roughly 8.78 billion US dollars to nearly 10.95 billion US dollars. This upward trajectory suggests growth in business operations or market demand during these years. However, there is a marked decline in revenues in 2020, falling sharply to approximately 2.21 billion US dollars, reflecting a significant reduction in sales or operational revenue. The decline continues in 2021, with revenues further decreasing to about 1.53 billion US dollars, pointing to a sustained period of financial contraction which may be associated with external market conditions or industry disruptions.
Working Capital Turnover
There is no data available for working capital turnover, so no analysis can be conducted on this ratio to assess how efficiently the company is managing working capital relative to its revenues.

In summary, the data highlights a period of growth up to 2019 followed by a severe downturn in 2020 and 2021. The substantial decline in revenues, coupled with fluctuating but persistently negative working capital, suggests challenges in maintaining operational liquidity and generating sales during the latter years of the timeframe. The recovery in working capital in 2020, despite the revenue shock, may indicate temporary adjustments, but the return to a large negative working capital in 2021 raises concerns about ongoing financial stability.


Average Inventory Processing Period

Royal Caribbean Cruises Ltd., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Inventory turnover
Short-term Activity Ratio (no. days)
Average inventory processing period1
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Chipotle Mexican Grill Inc.
McDonald’s Corp.
Starbucks Corp.
Average Inventory Processing Period, Sector
Consumer Services
Average Inventory Processing Period, Industry
Consumer Discretionary

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

1 2021 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ =

2 Click competitor name to see calculations.


The financial data reveals notable trends in inventory management over the five-year period ending December 31, 2021. The inventory turnover ratio demonstrates a clear downward trajectory, decreasing from 43.96 in 2017 to 17.69 in 2021. This significant decline suggests that the company has been turning over its inventory less frequently as time progressed.

Correspondingly, the average inventory processing period, measured in the number of days, exhibits an opposing upward trend. Beginning at 8 days in 2017, it rises to 21 days by the end of 2021. This indicates that inventory is being held for longer periods before being sold or used.

Inventory Turnover
Decreased from 43.96 in 2017 to 17.69 in 2021, reflecting slower inventory movement.
Average Inventory Processing Period
Increased from 8 days in 2017 to 21 days in 2021, indicating extended inventory holding times.

The inverse relationship between these two metrics is consistent with standard inventory management principles, where a lower turnover ratio typically corresponds with a longer processing period. The data suggests a gradual decline in operational efficiency related to inventory management during the period analyzed, which may warrant further investigation to identify underlying causes such as changes in demand, supply chain disruptions, or strategic shifts in inventory policy.


Average Receivable Collection Period

Royal Caribbean Cruises Ltd., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Receivables turnover
Short-term Activity Ratio (no. days)
Average receivable collection period1
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Airbnb Inc.
Booking Holdings Inc.
Chipotle Mexican Grill Inc.
DoorDash, Inc.
McDonald’s Corp.
Starbucks Corp.
Average Receivable Collection Period, Sector
Consumer Services
Average Receivable Collection Period, Industry
Consumer Discretionary

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

1 2021 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ =

2 Click competitor name to see calculations.


Receivables Turnover
The receivables turnover ratio showed a generally strong performance from 2017 through 2019, increasing from 27.55 to 35.81. This upward trend indicates improving efficiency in collecting receivables during these years. However, there was a sharp decline in 2020 and a further decrease in 2021, falling to 7.77 and then 3.75, respectively. This reversal suggests significant challenges in receivables collection during this period.
Average Receivable Collection Period
The average receivable collection period decreased from 13 days in 2017 to 10 days in 2019, reflecting quicker collection of receivables and improved liquidity management. Nevertheless, there was a notable increase in 2020 to 47 days and an even more pronounced rise in 2021 to 97 days. These increases indicate a substantial slowdown in the collection process, correlating with the decline in receivables turnover observed in the same period.
Overall Analysis
The data reveals a period of improving receivables management and liquidity from 2017 to 2019, followed by significant deterioration in 2020 and 2021. The sharp decline in receivables turnover and the corresponding rise in the average collection period in the latter years may point to operational disruptions or external factors adversely affecting the company's ability to collect payments efficiently.

Operating Cycle

Royal Caribbean Cruises Ltd., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Average inventory processing period
Average receivable collection period
Short-term Activity Ratio
Operating cycle1
Benchmarks
Operating Cycle, Competitors2
Chipotle Mexican Grill Inc.
McDonald’s Corp.
Starbucks Corp.
Operating Cycle, Sector
Consumer Services
Operating Cycle, Industry
Consumer Discretionary

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

1 2021 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= + =

2 Click competitor name to see calculations.


Inventory Processing Period
The average inventory processing period exhibited a general increasing trend over the analyzed period. It started at 8 days in 2017, rose slightly to 11 days in 2018, then declined marginally to 10 days in 2019. However, a notable extension occurred in 2020 and 2021, increasing to 16 days and then 21 days, respectively. This suggests a lengthening duration for inventory turnover, particularly pronounced during and after 2020.
Receivable Collection Period
The average receivable collection period remained relatively stable and low from 2017 through 2019, fluctuating between 10 and 13 days. A significant increase occurred in 2020, when the period expanded sharply to 47 days, followed by a further rise to 97 days in 2021. This indicates a substantial slowdown in the collection of receivables during the latter years, potentially reflecting credit management challenges or external factors affecting customer payments.
Operating Cycle
The operating cycle mirrored the trends seen in the inventory processing and receivables collection periods. The cycle was relatively consistent and brief, ranging from 20 to 23 days between 2017 and 2019. It expanded considerably in 2020 to 63 days, and nearly doubled again to 118 days in 2021. This sharp increase reflects the cumulative effect of prolonged inventory turnover and receivables collection, indicating that the overall time to convert operations into cash has lengthened significantly.

Average Payables Payment Period

Royal Caribbean Cruises Ltd., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Payables turnover
Short-term Activity Ratio (no. days)
Average payables payment period1
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Airbnb Inc.
Booking Holdings Inc.
Chipotle Mexican Grill Inc.
DoorDash, Inc.
McDonald’s Corp.
Starbucks Corp.
Average Payables Payment Period, Sector
Consumer Services
Average Payables Payment Period, Industry
Consumer Discretionary

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

1 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ =

2 Click competitor name to see calculations.


The analysis of the payables turnover ratio and the average payables payment period over the five-year period reveals several notable trends and changes.

Payables Turnover Ratio
The payables turnover ratio exhibited a declining trend from 13.6 in 2017 to 4.87 in 2021. This gradual decrease indicates that the company took longer to pay its suppliers over time, as a lower turnover ratio signifies fewer payments made relative to accounts payable. Particularly, the most significant drop occurred between 2019 and 2021, reflecting a more extended credit period with suppliers during or following the onset of the COVID-19 pandemic.
Average Payables Payment Period
The average payables payment period, measured in days, increased consistently from 27 days in 2017 to 75 days in 2021. This substantial increase demonstrates that the company progressively extended the duration it took to settle its payables. The rise was especially pronounced after 2019, where the payment period lengthened from 34 days to 75 days by the end of 2021, aligning with the drop in payables turnover and suggesting an intentional or necessary delay in payment to preserve liquidity or manage cash flows amid challenging economic conditions.

In summary, the patterns indicate a clear shift towards lengthening payables period and reduced turnover of payables, potentially reflecting financial strategy adjustments in response to external pressures or internal cash management requirements over the observed period.


Cash Conversion Cycle

Royal Caribbean Cruises Ltd., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Average inventory processing period
Average receivable collection period
Average payables payment period
Short-term Activity Ratio
Cash conversion cycle1
Benchmarks
Cash Conversion Cycle, Competitors2
Chipotle Mexican Grill Inc.
McDonald’s Corp.
Starbucks Corp.
Cash Conversion Cycle, Sector
Consumer Services
Cash Conversion Cycle, Industry
Consumer Discretionary

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

1 2021 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= + =

2 Click competitor name to see calculations.


Inventory Processing Period
The average inventory processing period increased steadily from 8 days in 2017 to 21 days in 2021, indicating that the company took progressively longer to process its inventory over the analyzed years.
Receivable Collection Period
The average receivable collection period showed a fluctuating but overall increasing trend. It decreased slightly from 13 days in 2017 to 10 days in 2019 but then surged substantially to 47 days in 2020 and almost doubled again to 97 days in 2021, signaling a significant slowdown in collecting receivables.
Payables Payment Period
The average payables payment period increased consistently from 27 days in 2017 to 75 days in 2021, reflecting an extended time taken to pay suppliers. This gradual lengthening may suggest strategic cash management or potential liquidity challenges.
Cash Conversion Cycle
The cash conversion cycle, which measures the net time between cash outflows and inflows, shifted from negative values in the range of -6 to -14 days during 2017–2019 to positive values rising to 43 days by 2021. This change indicates that the company moved from a position where it was effectively financing operations through supplier credit to one where cash is tied up longer in the operating cycle.