Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Royal Caribbean Cruises Ltd. logo

Royal Caribbean Cruises Ltd.

Sector: Consumer Cyclical   

Industry: Leisure

152.02
 
USD
  
-12.49
  
(-7.59%)
Optionable: Yes  Market Cap: 43,937 M  90-day average vol: 2,140,744

Previous close: 164.51  Open: 163.5  Bid: 152.0  Ask: 152.14
52 week range    
78.35   
   173.37
Last updated: Friday 26th July 2024
56
MarketXLS Rank
60
Value
61
Technical
47
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

RCL Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Basic EPS from continuing operations3.453.035.967.578.68.97-27.05-20.89-8.456.63
Basic EPS total3.453.035.967.578.68.97-27.05-20.89-8.456.63
Basic weighted shares outstanding222 M220 M215 M215 M211 M209 M214 M252 M255 M256 M
Cost of sales5,306 M5,099 M5,016 M4,897 M5,262 M6,063 M2,765 M2,739 M6,616 M7,775 M
Depreciation772 M827 M895 M951 M1,034 M1,246 M1,279 M1,293 M1,407 M1,455 M
Depreciation unreconciled772 M827 M895 M951 M1,034 M1,246 M1,279 M1,293 M1,407 M1,455 M
Diluted EPS total3.433.025.937.538.568.95-27.05-20.89-8.456.31
Diluted normalized net income/share3.433.025.937.538.568.95-27.05-20.89-8.456.31
Diluted weighted shares outstanding223 M221 M216 M216 M212 M210 M214 M252 M255 M283 M
Dividends paid per share2.62.960.78
Earnings from equity interest52 M81 M128 M156 M211 M231 M-213 M-135 M57 M200 M
EarningsFromEquityInterestNetOfTax52 M81 M128 M156 M211 M231 M-213 M-135 M57 M200 M
Fuel947 M796 M714 M681 M711 M698 M371 M385 M
GainOnSaleOfBusiness-22 M
GainOnSaleOfPPE-17 M22 M-69 M
GeneralAndAdministrativeExpense1,049 M1,087 M1,109 M1,186 M1,303 M1,559 M1,200 M1,370 M1,583 M1,792 M
Gross operating profit2,768 M3,200 M3,481 M3,881 M4,232 M4,888 M-556 M-1,207 M2,224 M6,125 M
ImpairmentOfCapitalAssets411 M636 M576 M576 M
Income before tax4,675 M4,574 M4,948 M1,625 M1,816 M1,908 M-2,642 M-5,096 M-2,156 M1,704 M
Income restructuring and M&A4 M8 M-3 M18 M-45 M
Income taxes-41 M-12 M4 M6 M
Interest income10 M12 M21 M30 M33 M27 M21 M17 M36 M36 M
InterestExpenseNonOperating258 M278 M307 M300 M334 M409 M844 M1,292 M1,364 M1,402 M
MinorityInterests-5 M-29 M-22 M-7 M
MiscOtherSpecialCharges70 M-24 M-36 M-5 M11 M-25 M-137 M20 M-119 M-8 M
Net income from total operations764 M666 M1,283 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M1,697 M
NetIncomeCommonStockholders4,675 M4,586 M4,948 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M1,697 M
NetIncomeContinuousOperations764 M666 M1,283 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M1,697 M
NetNonOperatingInterestIncomeExpense-248 M-266 M-287 M-270 M-301 M-382 M-823 M-1,275 M-1,328 M-1,366 M
Normalized income4,656 M4,973 M3,238 M1,056 M1,431 M1,525 M-1,452 M
Operating income942 M875 M1,477 M1,744 M1,895 M2,083 M-4,602 M-3,870 M-766 M2,878 M
Operating income before depreciation (EBITDA)5,706 M5,730 M6,203 M2,922 M3,236 M3,626 M-3,652 M-2,675 M615 M4,561 M
OperatingExpense2,899 M2,921 M3,094 M2,137 M2,337 M2,805 M912 M2,581 M2,990 M3,247 M
Other income net-70 M-57 M-71 M-151 M-222 M-206 M350 M115 M62 M-192 M
OtherCostofRevenue-630 M-612 M-475 M4,897 M5,262 M6,063 M2,765 M2,658 M6,616 M7,775 M
OtherGandA1,049 M1,087 M1,109 M1,186 M1,303 M1,559 M1,200 M1,370 M1,583 M1,792 M
OtherOperatingExpenses1,078 M1,008 M1,090 M1,011 M82 M44 M-10 M-12 M
RentAndLandingFees52 M30 M29 M29 M32 M32 M
RestructringAndMnAIncome4 M8 M-3 M18 M-45 M
SalariesAndWages-1,566 M-82 M-562000.0
Selling Gen & administrative expense1,049 M1,087 M1,109 M1,186 M1,303 M1,559 M1,200 M1,370 M1,583 M1,792 M
Special income/charges-4 M-411 M-8 M3 M-18 M-635 M-576 M-576 M
Total Income available for interest expense (EBIT)4,934 M4,851 M5,256 M1,925 M2,149 M2,316 M-4,931 M-3,968 M-792 M3,106 M
Total common shares outstanding220 M217 M215 M214 M209 M209 M238 M255 M255 M257 M
Total net income764 M666 M1,283 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M1,697 M
Total ordinary shares257 M257 M257 M257 M257 M257 M257 M257 M257 M257 M
Total revenues8,074 M8,299 M8,496 M8,778 M9,494 M10,951 M2,209 M1,532 M8,840 M13,900 M
TotalExpenses8,205 M8,021 M8,109 M7,034 M7,599 M8,868 M3,678 M5,238 M9,606 M11,022 M
TotalRevenue8,074 M8,299 M8,496 M8,778 M9,494 M10,951 M2,209 M1,532 M8,840 M13,900 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University