Atmos Energy Corporation (ATO) 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
Atmos Energy Corporation (ATO) Bundle
Designed for accuracy, our (ATO) DCF Calculator enables you to evaluate Atmos Energy Corporation's valuation using real-time financial data and offers complete flexibility to modify all essential parameters for improved projections.
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 | 2,821.1 | 3,407.5 | 4,201.7 | 4,275.4 | 4,165.2 | 4,615.7 | 5,115.0 | 5,668.3 | 6,281.5 | 6,960.9 |
| Revenue Growth, % | 0 | 20.78 | 23.31 | 1.75 | -2.58 | 10.82 | 10.82 | 10.82 | 10.82 | 10.82 |
| EBITDA | 1,261.1 | 1,380.8 | 1,490.4 | 1,743.9 | 2,096.4 | 1,955.4 | 2,166.9 | 2,401.3 | 2,661.0 | 2,948.9 |
| EBITDA, % | 44.7 | 40.52 | 35.47 | 40.79 | 50.33 | 42.36 | 42.36 | 42.36 | 42.36 | 42.36 |
| Depreciation | 429.8 | 478.0 | 535.7 | 604.3 | 670.0 | 666.8 | 738.9 | 818.9 | 907.4 | 1,005.6 |
| Depreciation, % | 15.24 | 14.03 | 12.75 | 14.14 | 16.09 | 14.45 | 14.45 | 14.45 | 14.45 | 14.45 |
| EBIT | 831.3 | 902.9 | 954.7 | 1,139.6 | 1,426.4 | 1,288.6 | 1,428.0 | 1,582.4 | 1,753.6 | 1,943.3 |
| EBIT, % | 29.47 | 26.5 | 22.72 | 26.66 | 34.25 | 27.92 | 27.92 | 27.92 | 27.92 | 27.92 |
| Total Cash | 20.8 | 116.7 | 51.6 | 15.4 | 307.3 | 121.2 | 134.3 | 148.8 | 164.9 | 182.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 230.6 | 343.0 | 375.6 | 342.6 | 365.9 | 406.0 | 449.9 | 498.5 | 552.5 | 612.2 |
| Account Receivables, % | 8.17 | 10.07 | 8.94 | 8.01 | 8.78 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 |
| Inventories | 112.0 | 178.1 | 357.9 | 280.1 | 186.5 | 265.3 | 294.0 | 325.9 | 361.1 | 400.2 |
| Inventories, % | 3.97 | 5.23 | 8.52 | 6.55 | 4.48 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 |
| Accounts Payable | 141.1 | 224.9 | 258.5 | 218.2 | 341.9 | 286.8 | 317.8 | 352.2 | 390.3 | 432.5 |
| Accounts Payable, % | 5 | 6.6 | 6.15 | 5.1 | 8.21 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
| Capital Expenditure | -1,935.7 | -1,969.5 | -2,444.4 | -2,806.0 | -2,937.1 | -2,960.9 | -3,281.2 | -3,636.1 | -4,029.4 | -4,465.3 |
| Capital Expenditure, % | -68.61 | -57.8 | -58.18 | -65.63 | -70.52 | -64.15 | -64.15 | -64.15 | -64.15 | -64.15 |
| Tax Rate, % | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 |
| EBITAT | 669.5 | 733.4 | 867.9 | 1,009.3 | 1,203.8 | 1,096.9 | 1,215.6 | 1,347.1 | 1,492.8 | 1,654.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,037.8 | -852.9 | -1,219.8 | -1,121.8 | -869.3 | -1,371.3 | -1,368.3 | -1,516.3 | -1,680.3 | -1,862.0 |
| WACC, % | 6.51 | 6.51 | 6.63 | 6.6 | 6.55 | 6.56 | 6.56 | 6.56 | 6.56 | 6.56 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -6,403.0 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -1,937 | |||||||||
| Terminal Value | -75,587 | |||||||||
| Present Terminal Value | -55,009 | |||||||||
| Enterprise Value | -61,412 | |||||||||
| Net Debt | 7,822 | |||||||||
| Equity Value | -69,234 | |||||||||
| Diluted Shares Outstanding, MM | 153 | |||||||||
| Equity Value Per Share | -453.50 |
What You Will Get
- Real ATO Financials: Includes historical and forecasted data for accurate valuation.
- Adjustable Inputs: Modify WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are calculated dynamically.
- Scenario Analysis: Test multiple scenarios to evaluate Atmos Energy Corporation’s future performance.
- Clear and Intuitive Design: Built for professionals yet accessible for beginners.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as revenue growth, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Accuracy: Leverages Atmos Energy Corporation’s (ATO) actual financial data for credible valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and evaluate potential outcomes.
- Efficiency Booster: Avoid the complexity of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for Atmos Energy Corporation (ATO).
- Step 2: Review Atmos Energy's 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 decisions.
Why Choose This Calculator for Atmos Energy Corporation (ATO)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Atmos Energy's historical and forecasted financials are preloaded to ensure precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance helps you navigate the calculator with ease.
Who Should Use Atmos Energy Corporation (ATO)?
- Investors: Make informed decisions with a reliable resource for understanding utility investments.
- Financial Analysts: Streamline your analysis with comprehensive data on energy sector performance.
- Consultants: Easily modify insights for client strategies or market assessments.
- Energy Enthusiasts: Enhance your knowledge of the energy market with real-time data and trends.
- Educators and Students: Utilize it as a valuable educational tool in energy economics and finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Atmos Energy Corporation (ATO).
- Real-World Data: Atmos Energy's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into operations.
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations including charts and tables for clear and actionable results.