Royal Caribbean Cruises Ltd. (RCL) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Royal Caribbean Cruises Ltd. (RCL) Bundle
Looking to assess the intrinsic value of Royal Caribbean Cruises Ltd.? Our RCL DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and make more informed investment choices.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 10,950.7 | 2,208.8 | 1,532.1 | 8,840.5 | 13,900.0 | 15,525.1 | 17,340.2 | 19,367.5 | 21,631.8 | 24,160.9 |
| Revenue Growth, % | 0 | -79.83 | -30.64 | 477.01 | 57.23 | 11.69 | 11.69 | 11.69 | 11.69 | 11.69 |
| EBITDA | 3,328.6 | -3,686.6 | -2,724.7 | 586.1 | 4,561.0 | -4,041.5 | -4,514.0 | -5,041.8 | -5,631.2 | -6,289.6 |
| EBITDA, % | 30.4 | -166.9 | -177.84 | 6.63 | 32.81 | -26.03 | -26.03 | -26.03 | -26.03 | -26.03 |
| Depreciation | 1,231.9 | 1,264.6 | 1,277.5 | 1,389.6 | 1,455.0 | 5,529.1 | 6,175.5 | 6,897.5 | 7,703.9 | 8,604.6 |
| Depreciation, % | 11.25 | 57.25 | 83.38 | 15.72 | 10.47 | 35.61 | 35.61 | 35.61 | 35.61 | 35.61 |
| EBIT | 2,096.8 | -4,951.2 | -4,002.2 | -803.5 | 3,106.0 | -5,203.9 | -5,812.3 | -6,491.8 | -7,250.8 | -8,098.5 |
| EBIT, % | 19.15 | -224.16 | -261.22 | -9.09 | 22.35 | -33.52 | -33.52 | -33.52 | -33.52 | -33.52 |
| Total Cash | 243.7 | 3,684.5 | 2,701.8 | 1,935.0 | 497.0 | 7,069.8 | 7,896.4 | 8,819.5 | 9,850.7 | 11,002.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 305.8 | 284.1 | 408.1 | 531.1 | 405.0 | 1,590.1 | 1,776.0 | 1,983.7 | 2,215.6 | 2,474.6 |
| Account Receivables, % | 2.79 | 12.86 | 26.63 | 6.01 | 2.91 | 10.24 | 10.24 | 10.24 | 10.24 | 10.24 |
| Inventories | 162.1 | 118.7 | 150.2 | 224.0 | 248.0 | 651.4 | 727.5 | 812.6 | 907.6 | 1,013.7 |
| Inventories, % | 1.48 | 5.37 | 9.8 | 2.53 | 1.78 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 |
| Accounts Payable | 563.7 | 353.4 | 546.0 | 646.7 | 792.0 | 2,167.2 | 2,420.6 | 2,703.6 | 3,019.7 | 3,372.7 |
| Accounts Payable, % | 5.15 | 16 | 35.64 | 7.32 | 5.7 | 13.96 | 13.96 | 13.96 | 13.96 | 13.96 |
| Capital Expenditure | -3,024.7 | -1,965.1 | -2,229.7 | -2,710.1 | -3,897.0 | -8,547.5 | -9,546.8 | -10,663.0 | -11,909.6 | -13,302.0 |
| Capital Expenditure, % | -27.62 | -88.97 | -145.53 | -30.65 | -28.04 | -55.06 | -55.06 | -55.06 | -55.06 | -55.06 |
| Tax Rate, % | 0.4108 | 0.4108 | 0.4108 | 0.4108 | 0.4108 | 0.4108 | 0.4108 | 0.4108 | 0.4108 | 0.4108 |
| EBITAT | 1,643.1 | -5,576.6 | -5,000.4 | -782.6 | 3,093.2 | -4,947.3 | -5,525.7 | -6,171.8 | -6,893.4 | -7,699.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -53.9 | -6,422.3 | -5,915.5 | -2,199.1 | 898.6 | -8,179.0 | -8,905.7 | -9,947.0 | -11,109.9 | -12,408.8 |
| WACC, % | 13.76 | 14.11 | 14.11 | 14.07 | 14.1 | 14.03 | 14.03 | 14.03 | 14.03 | 14.03 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -33,736.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -12,657 | |||||||||
| Terminal Value | -105,203 | |||||||||
| Present Terminal Value | -54,565 | |||||||||
| Enterprise Value | -88,301 | |||||||||
| Net Debt | 21,633 | |||||||||
| Equity Value | -109,934 | |||||||||
| Diluted Shares Outstanding, MM | 283 | |||||||||
| Equity Value Per Share | -388.46 |
What You Will Get
- Real RCL Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Royal Caribbean’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Revenue Assumptions: Adjust key inputs such as ticket sales growth, onboard spending, and operational costs.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics.
- Industry-Leading Precision: Utilizes Royal Caribbean's (RCL) actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Evaluate various scenarios and assess their impacts with ease.
- Efficiency Booster: Skip the complexities of creating detailed valuation models from the ground up.
How It Works
- 1. Open the Template: Download and open the Excel file containing Royal Caribbean Cruises Ltd.'s (RCL) preloaded data.
- 2. Edit Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Test Scenarios: Evaluate multiple forecasts to explore various valuation outcomes.
- 5. Use with Confidence: Present professional valuation insights to bolster your decision-making.
Why Choose This Calculator?
- Accuracy: Up-to-date Royal Caribbean financials ensure precise data.
- Flexibility: Tailored for users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Cruise Enthusiasts: Discover the latest trends and offerings from Royal Caribbean Cruises Ltd. (RCL).
- Travel Agents: Enhance your knowledge of cruise packages and itineraries to better serve clients.
- Investors: Evaluate investment opportunities and analyze financial performance for Royal Caribbean Cruises Ltd. (RCL).
- Market Analysts: Utilize industry data to assess market trends and forecasts related to the cruise sector.
- Tourism Professionals: Understand how major players like Royal Caribbean Cruises Ltd. (RCL) impact the travel industry.
What the Template Contains
- Pre-Filled DCF Model: Royal Caribbean Cruises Ltd. (RCL)’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Royal Caribbean’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.