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

129.21
 
USD
  
1.57
  
(1.23%)
Optionable: Yes  Market Cap: 32,492 M  90-day average vol: 2,826,273

Previous close: 127.64  Open: 128.0  Bid: 128.66  Ask: 129.21
52 week range    
59.37   
   141.70
Peers   
CCL / 
CUK / 
NCLH / 
MAR / 
DIS / 
Last updated: Monday 22nd April 2024
40
MarketXLS Rank
25
Value
61
Technical
36
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 ($)

CCL

25 B-2.321.52

CUK

DIS

263 B131.2142.51

IHG

MAR

53 B113.5166.04

NCLH

9 B-221.95
Financials

RCL Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Basic EPS from continuing operations2.163.453.035.967.578.68.97-27.05-20.89-8.45
Basic EPS total2.163.453.035.967.578.68.97-27.05-20.89-8.45
Basic weighted shares outstanding220 M222 M220 M215 M215 M211 M209 M214 M252 M255 M
Cost of sales5,305 M5,306 M5,099 M5,016 M4,897 M5,262 M6,063 M2,765 M2,658 M6,614 M
Depreciation755 M772 M827 M895 M951 M1,034 M1,246 M1,279 M
Depreciation unreconciled755 M772 M827 M895 M951 M1,034 M1,246 M1,279 M1,293 M1,407 M
DepreciationAndAmortization-1,293 M-1,407 M
Diluted EPS total2.143.433.025.937.538.568.95-27.05-20.89-8.45
Diluted normalized net income/share2.143.433.025.937.538.568.95-27.05-20.89-8.45
Diluted weighted shares outstanding221 M223 M221 M216 M216 M212 M210 M214 M252 M255 M
Dividends paid per share2.62.960.78
Earnings from equity interest52 M81 M128 M156 M211 M231 M-213 M
EarningsFromEquityInterestNetOfTax52 M81 M128 M156 M211 M231 M-213 M
Fuel924 M947 M796 M714 M681 M711 M698 M371 M-385 M-1,073 M
GainOnSaleOfBusiness-22 M
GainOnSaleOfPPE-17 M22 M-69 M
GainOnSaleOfSecurity-135 M57 M
GeneralAndAdministrativeExpense1,045 M1,049 M1,087 M1,109 M1,186 M1,303 M1,559 M1,200 M
Gross operating profit2,655 M2,768 M3,200 M3,481 M3,881 M4,232 M4,888 M-556 M-1,125 M2,226 M
ImpairmentOfCapitalAssets411 M636 M
Income before tax4,240 M4,675 M4,574 M4,948 M1,625 M1,816 M1,908 M-2,642 M-5,260 M-2,155 M
Income restructuring and M&A57 M4 M8 M-3 M18 M-45 M
Income taxes-2 M-41 M-12 M
Interest income14 M10 M12 M21 M30 M33 M27 M21 M17 M36 M
InterestExpenseNonOperating332 M258 M278 M307 M300 M334 M409 M844 M1,292 M1,364 M
MinorityInterests-5 M-29 M-22 M
MiscOtherSpecialCharges-6 M70 M-24 M-36 M-5 M11 M-25 M-137 M20 M-120 M
Net income from total operations474 M764 M666 M1,283 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M
NetIncomeCommonStockholders4,240 M4,675 M4,586 M4,948 M1,625 M1,811 M1,879 M-2,665 M-5,260 M-2,155 M
NetIncomeContinuousOperations474 M764 M666 M1,283 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M
NetNonOperatingInterestIncomeExpense-319 M-248 M-266 M-287 M-270 M-301 M-382 M-823 M-1,275 M-1,328 M
Normalized income4,295 M4,656 M4,973 M3,238 M1,056 M1,431 M1,525 M-1,452 M-4,026 M-1,702 M
Operating income798 M942 M875 M1,477 M1,744 M1,895 M2,083 M-4,602 M-3,788 M-764 M
Operating income before depreciation (EBITDA)5,327 M5,706 M5,730 M6,203 M2,922 M3,236 M3,626 M-363 M-2,263 M779 M
OperatingExpense2,986 M2,899 M2,921 M3,094 M2,137 M2,337 M2,805 M912 M-2,663 M2,989 M
Other income net6 M-70 M-57 M-71 M-151 M-222 M-206 M350 M197 M64 M
OtherCostofRevenue-572 M-630 M-612 M-475 M4,897 M5,262 M6,063 M2,765 M2,658 M6,614 M
OtherGandA1,045 M1,049 M1,087 M1,109 M1,186 M1,303 M1,559 M1,200 M
OtherOperatingExpenses1,186 M1,078 M1,008 M1,090 M1,011 M82 M
RentAndLandingFees58 M52 M30 M29 M29 M32 M32 M
RestructringAndMnAIncome57 M4 M8 M-3 M18 M-45 M
SalariesAndWages-1,566 M
Selling Gen & administrative expense1,045 M1,049 M1,087 M1,109 M1,186 M1,303 M1,559 M1,200 M1,370 M1,583 M
Special income/charges-57 M-4 M-411 M-8 M3 M-18 M-635 M-82 M-562000.0
Total Income available for interest expense (EBIT)4,573 M4,934 M4,851 M5,256 M1,925 M2,149 M2,316 M-1,798 M-3,805 M-791 M
Total common shares outstanding221 M220 M217 M215 M214 M209 M209 M238 M255 M255 M
Total net income474 M764 M666 M1,283 M1,625 M1,811 M1,879 M-5,797 M-5,260 M-2,156 M
Total ordinary shares257 M257 M257 M257 M257 M257 M257 M257 M257 M257 M
Total revenues7,960 M8,074 M8,299 M8,496 M8,778 M9,494 M10,951 M2,209 M1,532 M8,841 M
TotalExpenses8,291 M8,205 M8,021 M8,109 M7,034 M7,599 M8,868 M3,678 M5,238 M9,603 M
TotalRevenue7,960 M8,074 M8,299 M8,496 M8,778 M9,494 M10,951 M2,209 M1,532 M8,841 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