|
Valoración de DCF Golar LNG Limited (GLNG)
BM | Energy | Oil & Gas Midstream | NASDAQ
|
- ✓ 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
Golar LNG Limited (GLNG) Bundle
¡Simplifique la valoración Golar LNG Limited (GLNG) con esta calculadora DCF personalizable! Con el Real Golar LNG Limited (GLNG) financieras y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Golar LNG Limited (GLNG) en minutos.
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 | 448.8 | 438.6 | 451.8 | 267.7 | 298.4 | 277.1 | 257.4 | 239.0 | 222.0 | 206.1 |
Revenue Growth, % | 0 | -2.25 | 2.99 | -40.73 | 11.46 | -7.13 | -7.13 | -7.13 | -7.13 | -7.13 |
EBITDA | 140.6 | 193.1 | 29.5 | 1,077.1 | 53.2 | 110.7 | 102.8 | 95.5 | 88.7 | 82.3 |
EBITDA, % | 31.33 | 44.02 | 6.54 | 402.31 | 17.83 | 39.94 | 39.94 | 39.94 | 39.94 | 39.94 |
Depreciation | 113.0 | 107.9 | 55.4 | 51.7 | 50.3 | 54.4 | 50.6 | 46.9 | 43.6 | 40.5 |
Depreciation, % | 25.19 | 24.6 | 12.25 | 19.31 | 16.85 | 19.64 | 19.64 | 19.64 | 19.64 | 19.64 |
EBIT | 27.6 | 85.1 | -25.8 | 1,025.4 | 2.9 | 67.0 | 62.2 | 57.8 | 53.6 | 49.8 |
EBIT, % | 6.14 | 19.41 | -5.72 | 382.99 | 0.97645 | 24.16 | 24.16 | 24.16 | 24.16 | 24.16 |
Total Cash | 222.1 | 127.7 | 268.6 | 1,125.3 | 684.4 | 187.4 | 174.0 | 161.6 | 150.1 | 139.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 27.2 | 38.1 | 35.0 | 50.8 | 57.6 | 33.7 | 31.3 | 29.0 | 27.0 | 25.0 |
Account Receivables, % | 6.06 | 8.67 | 7.74 | 18.97 | 19.29 | 12.15 | 12.15 | 12.15 | 12.15 | 12.15 |
Inventories | 1.2 | 1.5 | .5 | .7 | 2.0 | .9 | .9 | .8 | .7 | .7 |
Inventories, % | 0.27365 | 0.34949 | 0.11865 | 0.25846 | 0.67018 | 0.33408 | 0.33408 | 0.33408 | 0.33408 | 0.33408 |
Accounts Payable | 13.9 | 10.6 | 4.9 | 9.0 | 7.5 | 6.9 | 6.4 | 6.0 | 5.5 | 5.1 |
Accounts Payable, % | 3.1 | 2.41 | 1.09 | 3.36 | 2.5 | 2.49 | 2.49 | 2.49 | 2.49 | 2.49 |
Capital Expenditure | -400.7 | -302.2 | -214.4 | -267.4 | -325.2 | -224.8 | -208.7 | -193.8 | -180.0 | -167.2 |
Capital Expenditure, % | -89.28 | -68.89 | -47.46 | -99.88 | -108.98 | -81.1 | -81.1 | -81.1 | -81.1 | -81.1 |
Tax Rate, % | 3852.45 | 3852.45 | 3852.45 | 3852.45 | 3852.45 | 3852.45 | 3852.45 | 3852.45 | 3852.45 | 3852.45 |
EBITAT | 28.0 | 76.4 | -31.5 | 811.0 | -109.3 | 49.4 | 45.9 | 42.6 | 39.6 | 36.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -274.1 | -132.3 | -192.1 | 583.4 | -393.9 | -96.5 | -110.3 | -102.5 | -95.2 | -88.4 |
WACC, % | 6.57 | 6.47 | 6.57 | 6.37 | 5.61 | 6.32 | 6.32 | 6.32 | 6.32 | 6.32 |
PV UFCF | ||||||||||
SUM PV UFCF | -413.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -90 | |||||||||
Terminal Value | -2,087 | |||||||||
Present Terminal Value | -1,537 | |||||||||
Enterprise Value | -1,950 | |||||||||
Net Debt | 545 | |||||||||
Equity Value | -2,495 | |||||||||
Diluted Shares Outstanding, MM | 107 | |||||||||
Equity Value Per Share | -23.40 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios.
- Real-World Data: Golar LNG Limited’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as revenue growth, EBITDA margin, and capital expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial outputs.
- High-Precision Accuracy: Leverages Golar LNG Limited’s (GLNG) actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Easily evaluate different assumptions and analyze results side by side.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Golar LNG Limited’s (GLNG) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the updated results, including Golar LNG Limited’s (GLNG) intrinsic value.
- Step 5: Make informed investment choices or create reports based on the outputs.
Why Choose Golar LNG Limited (GLNG) Calculator?
- Accuracy: Utilizes Golar LNG Limited's real financial data for precise calculations.
- Flexibility: Users can easily adjust and experiment with input variables.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use Golar LNG Limited (GLNG)?
- Investors: Make informed choices with a reliable resource for LNG market insights.
- Financial Analysts: Streamline your analysis with comprehensive data on Golar LNG's performance.
- Consultants: Efficiently tailor presentations or reports using Golar LNG's industry benchmarks.
- Energy Sector Enthusiasts: Enhance your knowledge of the LNG industry with practical examples from Golar LNG.
- Educators and Students: Utilize it as an educational tool in energy finance and investment courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Golar LNG Limited (GLNG) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that illustrate intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate thorough analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Golar LNG Limited (GLNG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify results analysis.