Genie Energy Ltd. (GNE) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Genie Energy Ltd. (GNE) Bundle
Designed for accuracy, our (GNE) DCF Calculator empowers you to evaluate Genie Energy Ltd. valuation using real-world financial data while offering complete flexibility to modify all essential parameters for enhanced projections.
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 | 315.3 | 379.3 | 363.7 | 315.5 | 428.7 | 470.3 | 515.9 | 566.0 | 620.9 | 681.2 |
Revenue Growth, % | 0 | 20.31 | -4.11 | -13.25 | 35.87 | 9.7 | 9.7 | 9.7 | 9.7 | 9.7 |
EBITDA | 10.1 | 25.7 | 24.5 | 78.0 | 18.7 | 43.1 | 47.3 | 51.9 | 56.9 | 62.4 |
EBITDA, % | 3.21 | 6.78 | 6.74 | 24.73 | 4.35 | 9.16 | 9.16 | 9.16 | 9.16 | 9.16 |
Depreciation | 3.6 | 3.0 | .4 | .4 | .5 | 2.1 | 2.4 | 2.6 | 2.8 | 3.1 |
Depreciation, % | 1.15 | 0.78089 | 0.11987 | 0.12201 | 0.108 | 0.45623 | 0.45623 | 0.45623 | 0.45623 | 0.45623 |
EBIT | 6.5 | 22.8 | 24.1 | 77.7 | 18.2 | 41.0 | 44.9 | 49.3 | 54.1 | 59.3 |
EBIT, % | 2.06 | 6 | 6.62 | 24.61 | 4.25 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
Total Cash | 31.2 | 42.0 | 96.8 | 99.1 | 108.0 | 98.0 | 107.5 | 117.9 | 129.4 | 141.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 49.8 | 48.4 | 41.3 | 55.1 | 61.9 | 67.6 | 74.1 | 81.3 | 89.2 | 97.9 |
Account Receivables, % | 15.8 | 12.75 | 11.36 | 17.47 | 14.44 | 14.36 | 14.36 | 14.36 | 14.36 | 14.36 |
Inventories | 16.6 | 16.9 | 17.7 | 15.7 | 14.6 | 21.6 | 23.7 | 26.0 | 28.6 | 31.3 |
Inventories, % | 5.28 | 4.46 | 4.87 | 4.98 | 3.41 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 |
Accounts Payable | 24.4 | 26.9 | 14.5 | 25.3 | 27.9 | 31.4 | 34.4 | 37.8 | 41.4 | 45.4 |
Accounts Payable, % | 7.73 | 7.1 | 4 | 8.02 | 6.5 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 |
Capital Expenditure | -.4 | -.2 | -.1 | -1.0 | -9.0 | -2.5 | -2.7 | -3.0 | -3.3 | -3.6 |
Capital Expenditure, % | -0.12814 | -0.04402708 | -0.03464156 | -0.32294 | -2.11 | -0.52712 | -0.52712 | -0.52712 | -0.52712 | -0.52712 |
Tax Rate, % | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 |
EBITAT | 1.5 | 12.5 | 21.5 | 56.6 | 19.6 | 27.9 | 30.6 | 33.6 | 36.8 | 40.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -37.3 | 19.0 | 15.7 | 54.9 | 8.0 | 18.4 | 24.6 | 27.0 | 29.6 | 32.5 |
WACC, % | 5.4 | 5.4 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
PV UFCF | ||||||||||
SUM PV UFCF | 111.6 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 33 | |||||||||
Terminal Value | 666 | |||||||||
Present Terminal Value | 512 | |||||||||
Enterprise Value | 623 | |||||||||
Net Debt | -107 | |||||||||
Equity Value | 731 | |||||||||
Diluted Shares Outstanding, MM | 26 | |||||||||
Equity Value Per Share | 28.04 |
What You Will Get
- Pre-Filled Financial Model: Genie Energy Ltd.'s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Customizable Energy Forecasts: Adjust key metrics such as energy production, cost per megawatt, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Analytics: Leverages Genie Energy’s actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate results with ease.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template containing Genie Energy Ltd.'s (GNE) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Genie Energy Ltd.'s (GNE) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose Genie Energy Ltd. (GNE)?
- Time Efficiency: Access ready-to-use energy solutions without the hassle of starting from scratch.
- Enhanced Accuracy: Utilize reliable energy data and analytics to minimize valuation errors.
- Completely Customizable: Adapt our services to align with your specific energy needs and forecasts.
- User-Friendly: Intuitive interfaces and clear outputs simplify the analysis process.
- Endorsed by Professionals: Crafted for industry experts who prioritize precision and functionality.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Genie Energy Ltd. (GNE) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Genie Energy Ltd. (GNE).
- Consultants: Provide accurate valuation insights for clients regarding Genie Energy Ltd. (GNE) swiftly.
- Business Owners: Gain insights into how companies like Genie Energy Ltd. (GNE) are valued to inform your own business strategies.
- Finance Students: Master valuation techniques using real-world examples and data from Genie Energy Ltd. (GNE).
What the Template Contains
- Preloaded GNE Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.