FLEX LNG Ltd. (FLNG) 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
FLEX LNG Ltd. (FLNG) Bundle
Looking to assess the intrinsic value of FLEX LNG Ltd.? Our FLNG DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your 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 | 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.