|
Valoración de DCF Flex Lng Ltd. (FLNG)
BM | Energy | Oil & Gas Midstream | NYSE
|
- ✓ 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
FLEX LNG Ltd. (FLNG) Bundle
¿Busca evaluar el valor intrínseco de Flex Lng Ltd.? Nuestra calculadora FLNG DCF integra datos del mundo real con características integrales de personalización, lo que le permite refinar sus pronósticos y mejorar sus estrategias de inversión.
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 | 120.0 | 164.5 | 343.4 | 347.9 | 371.0 | 505.5 | 688.9 | 938.6 | 1,278.9 | 1,742.7 |
Revenue Growth, % | 0 | 37.09 | 108.83 | 1.3 | 6.64 | 36.26 | 36.26 | 36.26 | 36.26 | 36.26 |
EBITDA | 83.8 | 117.5 | 271.0 | 337.0 | 302.2 | 402.9 | 548.9 | 748.0 | 1,019.2 | 1,388.7 |
EBITDA, % | 69.81 | 71.42 | 78.9 | 96.85 | 81.45 | 79.69 | 79.69 | 79.69 | 79.69 | 79.69 |
Depreciation | 28.7 | 41.8 | 69.8 | 72.2 | 73.4 | 111.5 | 151.9 | 207.0 | 282.1 | 384.3 |
Depreciation, % | 23.96 | 25.44 | 20.33 | 20.76 | 19.77 | 22.05 | 22.05 | 22.05 | 22.05 | 22.05 |
EBIT | 55.0 | 75.6 | 201.2 | 264.7 | 228.8 | 291.4 | 397.0 | 541.0 | 737.1 | 1,004.4 |
EBIT, % | 45.85 | 45.98 | 58.57 | 76.09 | 61.68 | 57.63 | 57.63 | 57.63 | 57.63 | 57.63 |
Total Cash | 129.0 | 128.9 | 200.7 | 332.3 | 410.4 | 437.1 | 595.6 | 811.5 | 1,105.8 | 1,506.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 9.3 | 13.9 | 14.8 | 4.9 | 19.9 | 27.6 | 37.6 | 51.2 | 69.8 | 95.1 |
Account Receivables, % | 7.77 | 8.44 | 4.3 | 1.4 | 5.37 | 5.46 | 5.46 | 5.46 | 5.46 | 5.46 |
Inventories | 2.7 | 3.7 | 6.5 | 5.3 | 5.1 | 9.3 | 12.7 | 17.3 | 23.6 | 32.2 |
Inventories, % | 2.24 | 2.22 | 1.88 | 1.51 | 1.37 | 1.84 | 1.84 | 1.84 | 1.84 | 1.84 |
Accounts Payable | .6 | 3.4 | 2.0 | 1.8 | 3.5 | 4.6 | 6.3 | 8.6 | 11.7 | 16.0 |
Accounts Payable, % | 0.48513 | 2.05 | 0.58699 | 0.51564 | 0.9455 | 0.91683 | 0.91683 | 0.91683 | 0.91683 | 0.91683 |
Capital Expenditure | -291.5 | -691.4 | -265.9 | .0 | .0 | -280.5 | -382.2 | -520.8 | -709.6 | -966.9 |
Capital Expenditure, % | -243.02 | -420.39 | -77.43 | -0.00143712 | -0.000539051593 | -55.49 | -55.49 | -55.49 | -55.49 | -55.49 |
Tax Rate, % | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 | 0.06493669 |
EBITAT | 54.4 | 74.8 | 201.0 | 264.6 | 228.7 | 290.0 | 395.2 | 538.5 | 733.8 | 999.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -219.8 | -577.4 | -.1 | 347.7 | 288.9 | 110.3 | 153.2 | 208.8 | 284.5 | 387.6 |
WACC, % | 6.71 | 6.71 | 6.74 | 6.74 | 6.74 | 6.73 | 6.73 | 6.73 | 6.73 | 6.73 |
PV UFCF | ||||||||||
SUM PV UFCF | 908.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 395 | |||||||||
Terminal Value | 8,359 | |||||||||
Present Terminal Value | 6,035 | |||||||||
Enterprise Value | 6,944 | |||||||||
Net Debt | 1,402 | |||||||||
Equity Value | 5,542 | |||||||||
Diluted Shares Outstanding, MM | 54 | |||||||||
Equity Value Per Share | 102.66 |
What You Will Get
- Real FLEX LNG Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on FLEX LNG’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive LNG Market Data: Gain access to reliable historical performance metrics and future growth forecasts for FLEX LNG Ltd. (FLNG).
- Adjustable Financial Assumptions: Modify highlighted fields such as discount rates, revenue growth, and operational margins.
- Real-Time Financial Metrics: Instant updates on DCF, Net Present Value (NPV), and cash flow projections.
- User-Friendly Visualization: Intuitive charts and summaries to clearly present your investment analysis outcomes.
- Designed for All Skill Levels: A straightforward, accessible format tailored for investors, financial analysts, and industry consultants.
How It Works
- 1. Access the Template: Download and open the Excel file featuring FLEX LNG Ltd.'s (FLNG) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation scenarios.
- 5. Present with Confidence: Deliver professional valuation insights to inform your investment decisions.
Why Choose FLEX LNG Ltd. (FLNG)?
- Reliability: Trustworthy data derived from real FLEX LNG financials.
- Customizability: Tailored for users to adjust and explore various input scenarios.
- Efficiency: Eliminate the complexity of creating a financial model from the ground up.
- High-Quality: Crafted with the precision and usability expected by industry professionals.
- Accessible: Intuitive interface designed for users of all financial backgrounds.
Who Should Use FLEX LNG Ltd. (FLNG)?
- Individual Investors: Gain insights to make informed decisions about buying or selling FLEX LNG Ltd. (FLNG) shares.
- Financial Analysts: Enhance valuation processes with comprehensive financial models specific to FLEX LNG Ltd. (FLNG).
- Consultants: Provide clients with accurate and timely valuation insights regarding FLEX LNG Ltd. (FLNG).
- Business Owners: Learn how companies like FLEX LNG Ltd. (FLNG) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-world data and scenarios related to FLEX LNG Ltd. (FLNG).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled FLEX LNG Ltd. (FLNG) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for FLEX LNG Ltd. (FLNG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.