Norwegian Cruise Line Holdings Ltd. (NCLH) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Norwegian Cruise Line Holdings Ltd. (NCLH) Bundle
Looking to assess the intrinsic value of Norwegian Cruise Line Holdings Ltd.? Our NCLH (NCLH) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your 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 | 6,462.4 | 1,279.9 | 648.0 | 4,843.8 | 8,549.9 | 9,553.4 | 10,674.7 | 11,927.5 | 13,327.5 | 14,891.7 |
| Revenue Growth, % | 0 | -80.19 | -49.37 | 647.51 | 76.51 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 |
| EBITDA | 1,812.7 | -2,800.1 | -1,794.1 | -729.9 | 1,752.3 | -3,181.7 | -3,555.2 | -3,972.4 | -4,438.7 | -4,959.6 |
| EBITDA, % | 28.05 | -218.78 | -276.88 | -15.07 | 20.5 | -33.3 | -33.3 | -33.3 | -33.3 | -33.3 |
| Depreciation | 644.0 | 734.7 | 753.5 | 803.0 | 870.4 | 3,709.1 | 4,144.5 | 4,630.9 | 5,174.4 | 5,781.7 |
| Depreciation, % | 9.97 | 57.4 | 116.29 | 16.58 | 10.18 | 38.83 | 38.83 | 38.83 | 38.83 | 38.83 |
| EBIT | 1,168.7 | -3,534.8 | -2,547.7 | -1,532.9 | 881.9 | -3,883.4 | -4,339.2 | -4,848.5 | -5,417.6 | -6,053.4 |
| EBIT, % | 18.08 | -276.18 | -393.17 | -31.65 | 10.31 | -40.65 | -40.65 | -40.65 | -40.65 | -40.65 |
| Total Cash | 252.9 | 3,300.5 | 1,746.6 | 947.0 | 402.4 | 4,359.6 | 4,871.3 | 5,443.0 | 6,081.9 | 6,795.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 75.1 | 20.6 | 1,167.5 | 326.3 | 280.3 | 2,154.9 | 2,407.9 | 2,690.5 | 3,006.2 | 3,359.1 |
| Account Receivables, % | 1.16 | 1.61 | 180.17 | 6.74 | 3.28 | 22.56 | 22.56 | 22.56 | 22.56 | 22.56 |
| Inventories | 95.4 | 82.4 | 118.2 | 148.7 | 157.6 | 593.6 | 663.3 | 741.2 | 828.1 | 925.3 |
| Inventories, % | 1.48 | 6.44 | 18.24 | 3.07 | 1.84 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
| Accounts Payable | 100.8 | 83.1 | 233.2 | 228.7 | 174.3 | 970.6 | 1,084.6 | 1,211.9 | 1,354.1 | 1,513.0 |
| Accounts Payable, % | 1.56 | 6.5 | 35.98 | 4.72 | 2.04 | 10.16 | 10.16 | 10.16 | 10.16 | 10.16 |
| Capital Expenditure | -1,637.2 | -946.5 | -752.8 | -1,783.9 | -2,750.4 | -5,126.1 | -5,727.7 | -6,399.9 | -7,151.1 | -7,990.4 |
| Capital Expenditure, % | -25.33 | -73.95 | -116.18 | -36.83 | -32.17 | -53.66 | -53.66 | -53.66 | -53.66 | -53.66 |
| Tax Rate, % | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 |
| EBITAT | 1,192.9 | -3,545.8 | -2,550.6 | -1,528.4 | 898.1 | -3,881.1 | -4,336.6 | -4,845.6 | -5,414.3 | -6,049.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 130.0 | -3,707.8 | -3,582.6 | -1,703.0 | -999.1 | -6,812.4 | -6,128.5 | -6,847.8 | -7,651.5 | -8,549.6 |
| WACC, % | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -26,834.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -8,721 | |||||||||
| Terminal Value | -107,092 | |||||||||
| Present Terminal Value | -66,065 | |||||||||
| Enterprise Value | -92,900 | |||||||||
| Net Debt | 14,324 | |||||||||
| Equity Value | -107,225 | |||||||||
| Diluted Shares Outstanding, MM | 427 | |||||||||
| Equity Value Per Share | -250.88 |
What You Will Get
- Real NCLH Financial Data: Pre-filled with Norwegian Cruise Line's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Norwegian Cruise Line's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life NCLH Financials: Pre-filled historical and projected data for Norwegian Cruise Line Holdings Ltd.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate NCLH’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize NCLH’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Norwegian Cruise Line Holdings Ltd.'s (NCLH) pre-filled financial data and projections.
- Step 3: Adjust key inputs such as passenger growth, operating margins, and fuel costs (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the findings for your investment strategies.
Why Choose This Calculator for Norwegian Cruise Line Holdings Ltd. (NCLH)?
- Accurate Data: Real Norwegian Cruise Line financials provide dependable valuation outcomes.
- Customizable: Modify key factors such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the cruise industry.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately estimate Norwegian Cruise Line Holdings Ltd.'s (NCLH) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to (NCLH).
- Consultants: Quickly adapt the template for valuation reports tailored to clients in the cruise industry.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading cruise line companies.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to the travel and leisure sector.
What the Template Contains
- Pre-Filled Data: Includes Norwegian Cruise Line Holdings Ltd.'s (NCLH) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Norwegian Cruise Line Holdings Ltd.'s (NCLH) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.