Two documents have to be submitted : 1.
Excel file with three tabs: Balance Sheet, Income statement , and Ratio tab. Simply recreate the ratios calculated on the Royal carribbean file.
Document and Entity Information Document and Entity Information - USD ($) $ in Billions12 Months Ended Dec. 31, 2018Feb. 14, 2019Jun. 30, 2018 Document and Entity Information Entity Registrant NameROYAL CARIBBEAN CRUISES LTD Entity Central Index Key884,887 Document Type10-K Document Period End DateDec. 31, 2018 Amendment Flagfalse Current Fiscal Year End Date--12-31 Entity Well-known Seasoned IssuerYes Entity Voluntary FilersNo Entity Current Reporting StatusYes Entity Filer CategoryLarge Accelerated Filer Entity Emerging Growth Companyfalse Entity Shell Companyfalse Entity Small Businessfalse Entity Public Float$ 18.5 Entity Common Stock, Shares Outstanding209,186,598 Document Fiscal Year Focus2,018 Document Fiscal Period FocusFY CONSOLIDATED STATEMENTS OF COMP CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) - USD ($) $ in Thousands12 Months Ended Dec. 31, 20182018 VerticalDec. 31, 20172017 VerticalTrend a.k.a. Common SizeHorizontal Total revenues$ 9,493,849100%$ 8,777,845100%8% Cruise operating expenses: Total cruise operating expenses5,262,20755%4,896,57956%7% Marketing, selling and administrative expenses1,303,14414%1,186,01614%10% Depreciation and amortization expenses1,033,69711%951,19411%9% Operating Income1,894,80120%1,744,05620%9% Other income (expense):0%0% Interest income32,8000%30,1010%9% Interest expense, net of interest capitalized(333,672)-4%(299,982)-3%11% Equity investment income210,7562%156,2472%35% Other income (expense)11,1070%(5,289)-0%-310% Total other income (expense)(79,009)-1%(118,923)-1%-34% Net Income1,815,79219%1,625,13319%12% Earnings per Share: Basic (in dollars per share)$ 8.60$ 7.57 Diluted (in dollars per share)$ 8.56$ 7.53 CONSOLIDATED BALANCE SHEETS CONSOLIDATED BALANCE SHEETS - USD ($) $ in ThousandsDec. 31, 2018VerticalDec. 31, 2017VerticalTrend Current assets20182017 Cash and cash equivalents$ 287,8521%$ 120,1121%140% Trade and other receivables, net324,5071%318,6411%2% Inventories153,5731%111,3930%38% Prepaid expenses and other assets456,5472%258,1711%77% Derivative financial instruments19,5650%99,3200%-80% Total current assets1,242,0444%907,6374%37% Property and equipment, net23,466,16385%19,735,18088%19% Goodwill1,378,3535%288,5121%378% Other assets1,611,7106%1,429,5976%13% Total assets27,698,270100%22,360,926100%24% Current liabilities Current portion of long-term debt1,646,8416%1,188,5145%39% Commercial paper775,4883%00% Accounts payable488,2122%360,1132%36% Accrued interest74,5500%47,4690%57% Accrued expenses and other liabilities899,7613%903,0224%-0% Derivative financial instruments78,4760%47,4640%65% Customer deposits3,148,83711%2,308,29110%36% Total current liabilities7,112,16526%4,854,87322%46% Long-term debt8,355,37030%6,350,93728%32% Other long-term liabilities583,2542%452,8132%29% Total liabilities16,050,78958%11,658,62352%38% Commitments and contingencies Redeemable noncontrolling interest542,0202%00% Shareholders' equity0%0% Preferred stock ($0.01 par value; 20,000,000 shares authorized; none outstanding)00%00% Common stock ($0.01 par value; 500,000,000 shares authorized; 235,847,683 and 235,198,901 shares issued, December 31, 2018 and December 31, 2017, respectively)2,3580%2,3520%0% Paid-in capital3,420,90012%3,390,11715%1% Retained earnings10,263,28237%9,022,40540%14% Accumulated other comprehensive loss(627,734)-2%(334,265)-1%88% Treasury stock (26,830,765 and 21,861,308 common shares at cost, December 31, 2018 and December 31, 2017, respectively)(1,953,345)-7%(1,378,306)-6%42% Total shareholders' equity11,105,46140%10,702,30348%4% Total liabilities, redeemable noncontrolling interest and shareholders’ equity$ 27,698,270100%$ 22,360,926100%24% CONSOLIDATED STATEMENTS OF CASH CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($) $ in Thousands12 Months Ended Dec. 31, 2018Dec. 31, 2017Dec. 31, 2016 Statement of Cash Flows [Abstract] Net Income$ 1,815,792$ 1,625,133$ 1,283,388 Adjustments: Depreciation and amortization1,033,697951,194894,915 Impairment losses33,65100 Net deferred income tax (benefit) expense(2,679)1,7302,608 Loss (gain) on derivative instruments not designated as hedges61,148(61,704)45,670 Share-based compensation expense46,06169,45932,659 Equity investment income(210,756)(156,247)(128,350) Amortization of debt issuance costs41,97845,94352,795 Gain on sale of property and equipment0(30,902)0 Gain on sale of unconsolidated affiliate(13,680)00 Recognition of deferred gain(21,794)00 Changes in operating assets and liabilities: (Increase) decrease in trade and other receivables, net(9,573)(32,043)4,759 (Increase) decrease in inventories(23,849)2,424(1,679) (Increase) decrease in prepaid expenses and other assets(71,770)20,85911,519 Increase in accounts payable91,73736,78029,564 Increase in accrued interest18,7731,3037,841 Increase in accrued expenses and other liabilities42,93734,21520,718 Increase in customer deposits385,990274,705188,632 Dividends received from unconsolidated affiliates243,101109,67775,942 Other, net18,375(17,960)(4,291) Net cash provided by operating activities3,479,1392,874,5662,516,690 Investing Activities Purchases of property and equipment(3,660,028)(564,138)(2,494,363) Cash received on settlement of derivative financial instruments76,52963,224110,637 Cash paid on settlement of derivative financial instruments(98,074)0(323,839) Investments in and loans to unconsolidated affiliates(27,172)(10,396)(9,155) Cash received on loans to unconsolidated affiliates124,23862,30338,213 Proceeds from the sale of property and equipment0230,0000 Proceeds from the sale of unconsolidated affiliate13,21500 Acquisition of Silversea Cruises, net of cash acquired(916,135)00 Other, net(1,731)5,415(46,385) Net cash used in investing activities(4,489,158)(213,592)(2,724,892) Financing Activities Debt proceeds8,590,7405,866,9667,338,560 Debt issuance costs(81,959)(51,590)(88,241) Repayments of debt(6,963,511)(7,835,087)(6,365,570) Proceeds from issuance of commercial paper notes4,730,28600 Repayments of commercial paper notes(3,965,450)00 Purchase of treasury stock(575,039)(224,998)(299,960) Dividends paid(527,494)(437,455)(346,487) Proceeds from exercise of common stock options4,2642,5252,258 Other, net(13,764)3,8433,249 Net cash provided by (used in) financing activities1,198,073(2,675,796)243,809 Effect of exchange rate changes on cash(20,314)2,331(24,569) Net increase (decrease) in cash and cash equivalents167,740(12,491)11,038 Cash and cash equivalents at beginning of year120,112132,603121,565 Cash and cash equivalents at end of year287,852120,112132,603 Cash paid during the year for: Interest, net of amount capitalized252,466249,615256,775 Non-Cash Investing Activities Contingent consideration for the acquisition of Silversea Cruises44,00000 Purchases of property and equipment included in accounts payable and accrued expenses and other liabilities0139,6440 Notes receivable issued upon sale of property and equipment$ 0$ 20,409213,042 Divestiture of Pullmantur Holdings$ 26,000 Ratios Current RatioCurrent Assets/Current LiabilitiesDebt RatioTotal Liabilities / Total Assets 17%58% Quick RatioQuick Assets/Current LiabilitiesInterest Coverage RatioIncome before interest and taxes / interest expense 9%5.68(I used operating income) remember to correct for the negative sign Working CapitalCurrent assets - current liabilitiesOperating Expense RatioOperating expenses / Net sales (5,870,121)55% Net Cash from Operating ActivitiesFrom the cash flow statementNet income as a % of salesNet income / net sales 3,479,139(a.k.a. profit margin)19%19% CFOA to Current Liabilities49%EPSfound on income statement $ 8.60 A/R Turnover RateNet Sales / Avg A/RAvg A/R321574Return on AssetsNet income / avg total assetsAvg total assets25029598 29.57% Days to collect A/R365/ A/R turnoverReturn on EquityNet income / avg owners equityAvg equity10903882 12.363216436217% Free Cash Flow(1,537,513) Carnival Corporation & PLC Cons Carnival Corporation & PLC Consolidated Statements of Income - USD ($)12 Months Ended Nov. 30, 2018Nov. 30, 2017Nov. 30, 2016 Revenues Revenues$ 18,881$ 17,510$ 16,389 Cruise Selling and administrative2,4502,2652,197 Depreciation and amortization2,0171,8461,738 Goodwill and trademark impairment0890 Operating costs and expenses15,55614,70113,318 Operating Income3,3252,8093,071 Nonoperating Income (Expense) Interest income1496 Interest expense, net of capitalized interest(194)(198)(223) Gains (losses) on fuel derivatives, net5935(47) Other income, net31121 Nonoperating Income (Expense)(118)(143)(243) Income Before Income Taxes3,2072,6662,828 Income Tax Expense, Net(54)(60)49 Net Income$ 3,152$ 2,606$ 2,779 Earnings Per Share Basic (USD per share)$ 4.45$ 3.61$ 3.73 Diluted (USD per share)4.443.593.72 Dividends Declared Per Share (USD per share)$ 1.95$ 1.60$ 1.35 Carnival Corporation & PLC Co_3 Carnival Corporation & PLC Consolidated Balance Sheets - USD ($) $ in MillionsNov. 30, 2018Nov. 30, 2017 Current Assets Cash and cash equivalents$ 982$ 395 Trade and other receivables, net358312 Inventories450387 Prepaid expenses and other436502 Total current assets2,2251,596 Property and Equipment, Net35,33634,430 Goodwill2,9252,967 Other Intangibles1,1761,200 Other Assets738585 Assets42,40140,778 Current Liabilities Short-term borrowings848485 Current portion of long-term debt1,5781,717 Accounts payable730762 Accrued liabilities and other1,6541,877 Customer deposits4,3953,958 Total current liabilities9,2048,800 Long-Term Debt7,8976,993 Other Long-Term Liabilities856769 Commitments and Contingencies Shareholders' Equity Additional paid-in capital8,7568,690 Retained earnings25,06623,292 Accumulated other comprehensive loss(1,949)(1,782) Treasury stock, 129 shares at 2018 and 122 shares at 2017 of Carnival Corporation and 48 shares at 2018 and 32 shares at 2017 of Carnival plc, at cost(7,795)(6,349) Total shareholders' equity24,44324,216 Liabilities and Shareholders' Equity42,40140,778 Carnival Corporation & PLC Co_2 Carnival Corporation & PLC Consolidated Statements of Comprehensive Income - USD ($) $ in Millions12 Months Ended Nov. 30, 2018Nov. 30, 2017Nov. 30, 2016 Statement of Comprehensive Income [Abstract] Net Income$ 3,152$ 2,606$ 2,779 Items Included in Other Comprehensive (Loss) Income Change in foreign currency translation adjustment(199)590(675) Other3282(38) Other Comprehensive (Loss) Income(167)672(713) Total Comprehensive Income$ 2,986$ 3,278$ 2,066 Carnival Corporation & PLC Co_5 Carnival Corporation & PLC Consolidated Statements of Cash Flows - USD ($) $ in Millions12 Months Ended Nov. 30, 2018Nov. 30, 2017Nov. 30, 2016 OPERATING ACTIVITIES Net Income$ 3,152$ 2,606$ 2,779 Adjustments to reconcile net income to net cash provided by operating activities Depreciation and amortization2,0171,8461,738 Impairments163920 (Gains) losses on fuel derivatives, net(59)(35)47 Share-based compensation656355 Other, net(6)5171 Adjustments to reconcile net income to net cash provided by operating activities5,1864,9234,690 Changes in operating assets and liabilities Receivables(58)6(22) Inventories(67)(49)1 Prepaid expenses and other74(13)11 Accounts payable(24)21109 Accrued and other liabilities(100)73(21) Customer deposits539361366 Net cash provided by operating activities5,5495,3225,134 INVESTING ACTIVITIES Purchases of property and equipment(3,749)(2,944)(3,062) Proceeds from sales of ships389026 Payments of fuel derivative settlements(39)(203)(291) Other, net(102)584 Net cash used in investing activities(3,502)(3,089)(3,323) FINANCING ACTIVITIES Proceeds from (repayments of) short-term borrowings, net417(29)447 Principal repayments of long-term debt(1,556)(1,227)(1,278) Proceeds from issuance of long-term debt2,5424671,542 Dividends paid(1,355)(1,087)(977) Purchases of treasury stock(1,468)(552)(2,340) Sales of treasury stock0040 Other, net(39)(24)(25) Net cash used in financing activities(1,460)(2,452)(2,591) Effect of exchange rate changes on cash and cash equivalents(1)11(12) Net increase (decrease) in cash and cash equivalents587(208)(792) Cash and cash equivalents at beginning of year3956031,395 Cash and cash equivalents at end of year$ 982$ 395$ 603