Lindblad Expeditions Holdings, Inc. (LIND) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Lindblad Expeditions Holdings, Inc. (LIND) Bundle
Looking to evaluate the intrinsic value of Lindblad Expeditions Holdings, Inc.? Our (LIND) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 343.1 | 82.4 | 147.1 | 421.5 | 569.5 | 765.7 | 1,029.4 | 1,383.8 | 1,860.4 | 2,501.1 |
| Revenue Growth, % | 0 | -76 | 78.62 | 186.53 | 35.12 | 34.44 | 34.44 | 34.44 | 34.44 | 34.44 |
| EBITDA | 61.9 | -61.1 | -57.1 | -19.9 | 54.1 | -138.1 | -185.7 | -249.6 | -335.6 | -451.2 |
| EBITDA, % | 18.03 | -74.21 | -38.79 | -4.73 | 9.5 | -18.04 | -18.04 | -18.04 | -18.04 | -18.04 |
| Depreciation | 25.9 | 32.1 | 39.5 | 44.7 | 46.7 | 141.2 | 189.9 | 255.3 | 343.2 | 461.4 |
| Depreciation, % | 7.54 | 39.02 | 26.88 | 10.59 | 8.2 | 18.45 | 18.45 | 18.45 | 18.45 | 18.45 |
| EBIT | 36.0 | -93.3 | -96.6 | -64.6 | 7.4 | -259.1 | -348.3 | -468.3 | -629.6 | -846.4 |
| EBIT, % | 10.5 | -113.23 | -65.67 | -15.32 | 1.3 | -33.84 | -33.84 | -33.84 | -33.84 | -33.84 |
| Total Cash | 101.6 | 187.5 | 150.8 | 100.8 | 156.8 | 430.4 | 578.6 | 777.9 | 1,045.7 | 1,405.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | 8.3 | 7.6 | 10.6 | 11.9 | 5.4 | 34.7 | 46.7 | 62.7 | 84.3 | 113.4 |
| Inventories, % | 2.43 | 9.28 | 7.17 | 2.83 | 0.9548 | 4.53 | 4.53 | 4.53 | 4.53 | 4.53 |
| Accounts Payable | 14.6 | 5.3 | 9.7 | 16.6 | 16.2 | 36.8 | 49.5 | 66.6 | 89.5 | 120.3 |
| Accounts Payable, % | 4.27 | 6.42 | 6.59 | 3.94 | 2.84 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
| Capital Expenditure | -96.0 | -155.5 | -96.7 | -38.2 | -30.0 | -318.6 | -428.3 | -575.8 | -774.1 | -1,040.6 |
| Capital Expenditure, % | -27.98 | -188.79 | -65.73 | -9.06 | -5.26 | -41.61 | -41.61 | -41.61 | -41.61 | -41.61 |
| Tax Rate, % | -20.89 | -20.89 | -20.89 | -20.89 | -20.89 | -20.89 | -20.89 | -20.89 | -20.89 | -20.89 |
| EBITAT | 28.1 | -84.9 | -95.0 | -68.4 | 9.0 | -242.3 | -325.7 | -437.9 | -588.7 | -791.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -35.7 | -216.9 | -150.6 | -56.5 | 31.7 | -428.2 | -563.4 | -757.4 | -1,018.2 | -1,368.9 |
| WACC, % | 12.27 | 12.74 | 12.99 | 13.05 | 13.05 | 12.82 | 12.82 | 12.82 | 12.82 | 12.82 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,726.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,396 | |||||||||
| Terminal Value | -12,901 | |||||||||
| Present Terminal Value | -7,057 | |||||||||
| Enterprise Value | -9,784 | |||||||||
| Net Debt | 467 | |||||||||
| Equity Value | -10,251 | |||||||||
| Diluted Shares Outstanding, MM | 53 | |||||||||
| Equity Value Per Share | -192.48 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real LIND financials.
- Real-World Data: Historical data and forward-looking estimates (as illustrated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Lindblad Expeditions' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Authentic Financial Data: Gain access to reliable historical data and future forecasts tailored for Lindblad Expeditions Holdings, Inc. (LIND).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help you visualize your valuation insights.
- Designed for All Skill Levels: An accessible layout suitable for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Lindblad Expeditions' preloaded data.
- 2. Adjust Assumptions: Modify key parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Confidence: Share professional valuation insights to enhance your decision-making.
Why Choose This Calculator for Lindblad Expeditions Holdings, Inc. (LIND)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for the travel and expedition sector.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for Lindblad Expeditions.
- Detailed Insights: Automatically computes the intrinsic value and Net Present Value specific to Lindblad Expeditions Holdings, Inc. (LIND).
- Preloaded Data: Features historical and forecasted data relevant to the expedition industry for precise calculations.
- Professional Quality: Perfect for financial analysts, investors, and consultants focused on the travel and tourism market.
Who Should Use Lindblad Expeditions Holdings, Inc. (LIND)?
- Travel Enthusiasts: Explore unique travel experiences with a focus on adventure and conservation.
- Environmental Advocates: Support sustainable tourism practices that protect the planet.
- Adventure Seekers: Discover thrilling expeditions to remote locations around the globe.
- Educators and Students: Learn about marine biology and ecology through immersive travel experiences.
- Investors: Gain insights into the growing market of eco-conscious travel and adventure tourism.
What the Template Contains
- Pre-Filled DCF Model: Lindblad Expeditions' financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Lindblad Expeditions' 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.