|
ONE Gas, Inc. (OGS) DCF Valuation
US | Utilities | Regulated Gas | NYSE
|
- ✓ 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
ONE Gas, Inc. (OGS) Bundle
Explore the financial future of ONE Gas, Inc. (OGS) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and costs to determine the intrinsic value of ONE Gas, Inc. (OGS) and shape your investment decisions.
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 | 1,652.7 | 1,530.3 | 1,808.6 | 2,578.0 | 2,372.0 | 2,640.8 | 2,940.1 | 3,273.2 | 3,644.2 | 4,057.1 |
| Revenue Growth, % | 0 | -7.41 | 18.19 | 42.54 | -7.99 | 11.33 | 11.33 | 11.33 | 11.33 | 11.33 |
| EBITDA | 472.7 | 493.3 | 514.3 | 574.3 | 666.9 | 737.6 | 821.2 | 914.3 | 1,017.9 | 1,133.3 |
| EBITDA, % | 28.6 | 32.24 | 28.44 | 22.28 | 28.12 | 27.93 | 27.93 | 27.93 | 27.93 | 27.93 |
| Depreciation | 180.4 | 194.9 | 207.2 | 228.5 | 279.8 | 294.5 | 327.9 | 365.1 | 406.5 | 452.5 |
| Depreciation, % | 10.91 | 12.74 | 11.46 | 8.86 | 11.8 | 11.15 | 11.15 | 11.15 | 11.15 | 11.15 |
| EBIT | 292.3 | 298.4 | 307.1 | 345.8 | 387.1 | 443.1 | 493.3 | 549.2 | 611.5 | 680.7 |
| EBIT, % | 17.68 | 19.5 | 16.98 | 13.41 | 16.32 | 16.78 | 16.78 | 16.78 | 16.78 | 16.78 |
| Total Cash | 17.9 | 8.0 | 8.9 | 9.7 | 18.8 | 17.2 | 19.2 | 21.4 | 23.8 | 26.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 260.0 | 293.0 | 341.8 | 553.8 | 347.9 | 474.9 | 528.8 | 588.7 | 655.4 | 729.7 |
| Account Receivables, % | 15.73 | 19.15 | 18.9 | 21.48 | 14.67 | 17.98 | 17.98 | 17.98 | 17.98 | 17.98 |
| Inventories | 160.0 | 146.7 | 234.5 | 340.1 | 264.7 | 298.9 | 332.7 | 370.5 | 412.4 | 459.2 |
| Inventories, % | 9.68 | 9.59 | 12.97 | 13.19 | 11.16 | 11.32 | 11.32 | 11.32 | 11.32 | 11.32 |
| Accounts Payable | 120.5 | 152.3 | 258.6 | 360.5 | 278.1 | 302.3 | 336.6 | 374.8 | 417.2 | 464.5 |
| Accounts Payable, % | 7.29 | 9.95 | 14.3 | 13.98 | 11.72 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 |
| Capital Expenditure | -417.3 | -471.3 | -495.2 | -609.5 | -666.6 | -714.0 | -794.9 | -885.0 | -985.2 | -1,096.9 |
| Capital Expenditure, % | -25.25 | -30.8 | -27.38 | -23.64 | -28.1 | -27.04 | -27.04 | -27.04 | -27.04 | -27.04 |
| Tax Rate, % | 14.9 | 14.9 | 14.9 | 14.9 | 14.9 | 14.9 | 14.9 | 14.9 | 14.9 | 14.9 |
| EBITAT | 237.7 | 246.3 | 256.9 | 285.8 | 329.4 | 368.0 | 409.7 | 456.2 | 507.9 | 565.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -298.7 | -18.0 | -61.5 | -310.9 | 141.4 | -188.3 | -110.7 | -123.2 | -137.2 | -152.7 |
| WACC, % | 5.83 | 5.85 | 5.87 | 5.86 | 5.9 | 5.86 | 5.86 | 5.86 | 5.86 | 5.86 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -604.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -156 | |||||||||
| Terminal Value | -4,032 | |||||||||
| Present Terminal Value | -3,033 | |||||||||
| Enterprise Value | -3,637 | |||||||||
| Net Debt | 3,030 | |||||||||
| Equity Value | -6,668 | |||||||||
| Diluted Shares Outstanding, MM | 56 | |||||||||
| Equity Value Per Share | -119.36 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: ONE Gas, Inc. (OGS) financial data pre-loaded 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 forecasts, validating strategies, and enhancing efficiency.
Key Features
- Real-Life OGS Data: Pre-filled with ONE Gas, Inc.'s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures tailored to OGS.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs for OGS.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes for ONE Gas, Inc. (OGS).
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike in the context of OGS.
How It Works
- Download the Template: Gain immediate access to the Excel-based OGS DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates ONE Gas, Inc.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial decisions.
Why Choose ONE Gas, Inc. (OGS) Services?
- Save Time: Quickly access essential gas services without the hassle of lengthy processes.
- Enhance Reliability: Dependable service and accurate billing ensure peace of mind for customers.
- Fully Customizable Plans: Adapt services to meet your specific energy needs and preferences.
- User-Friendly Interface: Intuitive online tools make managing your account straightforward.
- Backed by Expertise: Our team of professionals is committed to delivering top-notch customer support.
Who Should Use This Product?
- Investors: Accurately estimate ONE Gas, Inc.'s (OGS) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to ONE Gas, Inc. (OGS).
- Consultants: Efficiently adapt the template for valuation reports tailored to ONE Gas, Inc. (OGS) clients.
- Entrepreneurs: Gain insights into financial modeling practices used by major utility companies, including ONE Gas, Inc. (OGS).
- Educators: Employ it as a teaching tool to illustrate valuation methodologies relevant to the utility sector, including ONE Gas, Inc. (OGS).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled ONE Gas, Inc. (OGS) 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 ONE Gas, Inc. (OGS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.