New Fortress Energy Inc. (NFE) 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
New Fortress Energy Inc. (NFE) Bundle
Discover the true potential of New Fortress Energy Inc. (NFE) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect New Fortress Energy Inc. (NFE) valuation – all in one convenient Excel template.
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 | 189.1 | 451.7 | 1,322.8 | 2,368.3 | 2,413.3 | 4,108.2 | 6,993.6 | 11,905.5 | 20,267.1 | 34,501.5 |
| Revenue Growth, % | 0 | 138.81 | 192.88 | 79.03 | 1.9 | 70.23 | 70.23 | 70.23 | 70.23 | 70.23 |
| EBITDA | -175.8 | -160.2 | 350.5 | 440.8 | 1,129.6 | -300.1 | -510.9 | -869.6 | -1,480.4 | -2,520.2 |
| EBITDA, % | -92.97 | -35.47 | 26.49 | 18.61 | 46.81 | -7.3 | -7.3 | -7.3 | -7.3 | -7.3 |
| Depreciation | 8.6 | 33.2 | 98.8 | 142.6 | 187.3 | 272.7 | 464.2 | 790.1 | 1,345.1 | 2,289.8 |
| Depreciation, % | 4.57 | 7.36 | 7.47 | 6.02 | 7.76 | 6.64 | 6.64 | 6.64 | 6.64 | 6.64 |
| EBIT | -184.5 | -193.4 | 251.6 | 298.2 | 942.2 | -572.7 | -975.0 | -1,659.8 | -2,825.5 | -4,810.0 |
| EBIT, % | -97.54 | -42.83 | 19.02 | 12.59 | 39.04 | -13.94 | -13.94 | -13.94 | -13.94 | -13.94 |
| Total Cash | 27.1 | 601.5 | 187.5 | 675.5 | 155.4 | 1,343.1 | 2,286.4 | 3,892.3 | 6,626.0 | 11,279.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 51.5 | 85.8 | 208.5 | 318.5 | 424.6 | 764.2 | 1,300.9 | 2,214.5 | 3,769.9 | 6,417.6 |
| Account Receivables, % | 27.21 | 18.99 | 15.76 | 13.45 | 17.59 | 18.6 | 18.6 | 18.6 | 18.6 | 18.6 |
| Inventories | 63.4 | 22.9 | 37.2 | 39.1 | 113.7 | 392.5 | 668.2 | 1,137.5 | 1,936.4 | 3,296.4 |
| Inventories, % | 33.54 | 5.06 | 2.81 | 1.65 | 4.71 | 9.55 | 9.55 | 9.55 | 9.55 | 9.55 |
| Accounts Payable | 11.6 | 21.3 | 68.1 | 80.4 | 549.5 | 346.4 | 589.7 | 1,003.9 | 1,709.1 | 2,909.4 |
| Accounts Payable, % | 6.13 | 4.72 | 5.15 | 3.39 | 22.77 | 8.43 | 8.43 | 8.43 | 8.43 | 8.43 |
| Capital Expenditure | -377.1 | -157.0 | -669.3 | -1,174.0 | -3,029.8 | -2,752.0 | -4,684.8 | -7,975.1 | -13,576.3 | -23,111.4 |
| Capital Expenditure, % | -199.37 | -34.76 | -50.6 | -49.57 | -125.55 | -66.99 | -66.99 | -66.99 | -66.99 | -66.99 |
| Tax Rate, % | 17.54 | 17.54 | 17.54 | 17.54 | 17.54 | 17.54 | 17.54 | 17.54 | 17.54 | 17.54 |
| EBITAT | -184.9 | -197.0 | 232.3 | 945.4 | 777.0 | -543.9 | -925.9 | -1,576.1 | -2,683.1 | -4,567.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -656.6 | -304.8 | -428.5 | -185.6 | -1,777.1 | -3,844.7 | -5,715.6 | -9,729.8 | -16,563.4 | -28,196.5 |
| WACC, % | 6.5 | 6.5 | 6.26 | 6.5 | 5.95 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -50,443.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -28,760 | |||||||||
| Terminal Value | -662,175 | |||||||||
| Present Terminal Value | -486,879 | |||||||||
| Enterprise Value | -537,322 | |||||||||
| Net Debt | 7,219 | |||||||||
| Equity Value | -544,541 | |||||||||
| Diluted Shares Outstanding, MM | 206 | |||||||||
| Equity Value Per Share | -2,637.23 |
What You Will Get
- Real NFE Financial Data: Pre-filled with New Fortress Energy’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See New Fortress Energy’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Financial Data: Access precise historical figures and future forecasts tailored for New Fortress Energy Inc. (NFE).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively present your valuation findings.
- Suitable for All Levels: An intuitive layout designed for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review New Fortress Energy Inc.'s (NFE) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for New Fortress Energy Inc. (NFE)?
- Accurate Data: Up-to-date New Fortress Energy financials provide trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the energy sector.
- User-Friendly: An intuitive design and clear instructions ensure ease of use for everyone.
Who Should Use New Fortress Energy Inc. (NFE)?
- Investors: Make informed decisions with a comprehensive analysis of energy market trends.
- Financial Analysts: Streamline your workflow with ready-to-use financial models tailored for the energy sector.
- Consultants: Easily customize reports and presentations for clients in the energy industry.
- Energy Enthusiasts: Enhance your knowledge of energy investments through practical case studies.
- Educators and Students: Utilize this resource as a hands-on learning tool in energy finance courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled New Fortress Energy Inc. (NFE) 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 display intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for New Fortress Energy Inc. (NFE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.