National Fuel Gas Company (NFG) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
National Fuel Gas Company (NFG) Bundle
Streamline your analysis and boost precision with our (NFG) DCF Calculator! Utilizing actual National Fuel Gas Company data and customizable assumptions, this tool empowers you to forecast, evaluate, and assess (NFG) like a seasoned investor.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 1,546.3 | 1,742.7 | 2,186.0 | 2,173.8 | 1,944.8 | 2,076.3 | 2,216.7 | 2,366.6 | 2,526.6 | 2,697.5 |
| Revenue Growth, % | 0 | 12.7 | 25.44 | -0.56152 | -10.53 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 |
| EBITDA | 760.7 | 976.5 | 1,164.2 | 1,178.5 | 683.0 | 1,029.1 | 1,098.7 | 1,173.0 | 1,252.3 | 1,337.0 |
| EBITDA, % | 49.2 | 56.03 | 53.26 | 54.22 | 35.12 | 49.56 | 49.56 | 49.56 | 49.56 | 49.56 |
| Depreciation | 313.7 | 345.4 | 379.8 | 417.9 | 457.0 | 416.1 | 444.3 | 474.3 | 506.4 | 540.6 |
| Depreciation, % | 20.29 | 19.82 | 17.37 | 19.23 | 23.5 | 20.04 | 20.04 | 20.04 | 20.04 | 20.04 |
| EBIT | 447.0 | 631.1 | 784.5 | 760.6 | 226.0 | 613.0 | 654.4 | 698.7 | 745.9 | 796.4 |
| EBIT, % | 28.91 | 36.21 | 35.89 | 34.99 | 11.62 | 29.52 | 29.52 | 29.52 | 29.52 | 29.52 |
| Total Cash | 20.5 | 31.5 | 46.0 | 55.4 | 38.2 | 40.5 | 43.3 | 46.2 | 49.3 | 52.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 179.0 | 238.6 | 412.0 | 177.2 | 142.7 | 247.5 | 264.2 | 282.1 | 301.2 | 321.6 |
| Account Receivables, % | 11.57 | 13.69 | 18.84 | 8.15 | 7.34 | 11.92 | 11.92 | 11.92 | 11.92 | 11.92 |
| Inventories | 85.2 | 120.4 | 172.3 | 81.5 | 82.7 | 117.5 | 125.5 | 134.0 | 143.0 | 152.7 |
| Inventories, % | 5.51 | 6.91 | 7.88 | 3.75 | 4.25 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
| Accounts Payable | 134.1 | 171.7 | 178.9 | 152.2 | 165.1 | 175.2 | 187.1 | 199.7 | 213.2 | 227.7 |
| Accounts Payable, % | 8.67 | 9.85 | 8.19 | 7 | 8.49 | 8.44 | 8.44 | 8.44 | 8.44 | 8.44 |
| Capital Expenditure | -1,222.4 | -751.7 | -811.8 | -1,009.9 | -931.2 | -1,053.4 | -1,124.6 | -1,200.7 | -1,281.9 | -1,368.5 |
| Capital Expenditure, % | -79.05 | -43.14 | -37.14 | -46.46 | -47.88 | -50.73 | -50.73 | -50.73 | -50.73 | -50.73 |
| Tax Rate, % | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 | 11.16 |
| EBITAT | 526.8 | 479.8 | 650.4 | 565.5 | 200.7 | 517.5 | 552.5 | 589.9 | 629.8 | 672.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -512.0 | 16.2 | .3 | 272.4 | -227.4 | -249.2 | -140.7 | -150.2 | -160.4 | -171.2 |
| WACC, % | 6.65 | 6.25 | 6.36 | 6.22 | 6.46 | 6.39 | 6.39 | 6.39 | 6.39 | 6.39 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -734.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -172 | |||||||||
| Terminal Value | -2,923 | |||||||||
| Present Terminal Value | -2,144 | |||||||||
| Enterprise Value | -2,878 | |||||||||
| Net Debt | 2,741 | |||||||||
| Equity Value | -5,619 | |||||||||
| Diluted Shares Outstanding, MM | 92 | |||||||||
| Equity Value Per Share | -60.85 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-populated financials for National Fuel Gas Company (NFG).
- Accurate Data: Historical figures and projected estimates (highlighted in the yellow cells).
- Assumption Flexibility: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of National Fuel Gas Company (NFG).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Design: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life NFG Financials: Pre-filled historical and projected data for National Fuel Gas Company (NFG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate National Fuel Gas Company's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize National Fuel Gas Company's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered National Fuel Gas Company (NFG) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for National Fuel Gas Company’s (NFG) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for National Fuel Gas Company (NFG)?
- Accuracy: Utilizes real National Fuel Gas Company financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminates the need to create 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 with varying levels of financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling National Fuel Gas Company (NFG) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for National Fuel Gas Company (NFG).
- Consultants: Deliver professional valuation insights on National Fuel Gas Company (NFG) to clients quickly and accurately.
- Business Owners: Understand how companies like National Fuel Gas Company (NFG) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios from National Fuel Gas Company (NFG).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: National Fuel Gas Company’s (NFG) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.