Antero Midstream Corporation (AM) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Antero Midstream Corporation (AM) Bundle
Evaluate Antero Midstream Corporation's (AM) financial outlook like an expert! This (AM) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 849.6 | 971.4 | 234.2 | 990.7 | 1,112.4 | 1,253.5 | 1,412.5 | 1,591.7 | 1,793.6 | 2,021.1 |
Revenue Growth, % | 0 | 14.34 | -75.89 | 323.07 | 12.29 | 12.68 | 12.68 | 12.68 | 12.68 | 12.68 |
EBITDA | -194.5 | 148.4 | 803.9 | 836.3 | 824.9 | 629.2 | 709.0 | 798.9 | 900.3 | 1,014.5 |
EBITDA, % | -22.89 | 15.28 | 343.33 | 84.42 | 74.16 | 50.19 | 50.19 | 50.19 | 50.19 | 50.19 |
Depreciation | 152.7 | 179.6 | 179.9 | 202.7 | 206.9 | 382.0 | 430.4 | 485.0 | 546.6 | 615.9 |
Depreciation, % | 17.98 | 18.49 | 76.84 | 20.46 | 18.6 | 30.47 | 30.47 | 30.47 | 30.47 | 30.47 |
EBIT | -347.2 | -31.2 | 624.0 | 633.7 | 618.0 | 439.9 | 495.6 | 558.5 | 629.4 | 709.2 |
EBIT, % | -40.86 | -3.21 | 266.5 | 63.97 | 55.56 | 35.09 | 35.09 | 35.09 | 35.09 | 35.09 |
Total Cash | 1.2 | .6 | .0 | .0 | .1 | .5 | .6 | .7 | .8 | .9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 105.6 | 91.8 | 82.9 | 87.7 | 89.6 | 186.0 | 209.6 | 236.1 | 266.1 | 299.8 |
Account Receivables, % | 12.43 | 9.45 | 35.4 | 8.85 | 8.05 | 14.84 | 14.84 | 14.84 | 14.84 | 14.84 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0.000000103 | 0 | 0 | 0 | 0.0000000206 | 0.0000000206 | 0.0000000206 | 0.0000000206 | 0.0000000206 |
Accounts Payable | 6.6 | 9.5 | 23.6 | 22.9 | 4.5 | 36.5 | 41.1 | 46.3 | 52.2 | 58.8 |
Accounts Payable, % | 0.78213 | 0.97746 | 10.08 | 2.31 | 0.40065 | 2.91 | 2.91 | 2.91 | 2.91 | 2.91 |
Capital Expenditure | -267.4 | -157.9 | -232.8 | -515.7 | -184.0 | -540.9 | -609.5 | -686.8 | -773.9 | -872.1 |
Capital Expenditure, % | -31.47 | -16.26 | -99.43 | -52.05 | -16.54 | -43.15 | -43.15 | -43.15 | -43.15 | -43.15 |
Tax Rate, % | 25.65 | 25.65 | 25.65 | 25.65 | 25.65 | 25.65 | 25.65 | 25.65 | 25.65 | 25.65 |
EBITAT | -269.4 | -21.5 | 457.7 | 465.9 | 459.5 | 323.4 | 364.4 | 410.6 | 462.7 | 521.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -483.1 | 16.9 | 427.8 | 147.4 | 462.1 | 100.0 | 166.3 | 187.4 | 211.2 | 238.0 |
WACC, % | 12.03 | 11.84 | 11.94 | 11.94 | 11.96 | 11.94 | 11.94 | 11.94 | 11.94 | 11.94 |
PV UFCF | ||||||||||
SUM PV UFCF | 625.6 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 245 | |||||||||
Terminal Value | 2,742 | |||||||||
Present Terminal Value | 1,560 | |||||||||
Enterprise Value | 2,186 | |||||||||
Net Debt | 3,213 | |||||||||
Equity Value | -1,028 | |||||||||
Diluted Shares Outstanding, MM | 482 | |||||||||
Equity Value Per Share | -2.13 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Antero Midstream Corporation’s (AM) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Access reliable pre-loaded historical figures and future forecasts for Antero Midstream Corporation (AM).
- Adjustable Forecast Parameters: Modify highlighted cells for key inputs like WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you visualize valuation outcomes.
- Designed for All Levels: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing Antero Midstream Corporation’s (AM) preloaded data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Confidence: Share professional valuation insights to guide your investment decisions.
Why Choose This Calculator for Antero Midstream Corporation (AM)?
- Designed for Industry Experts: A specialized tool utilized by financial analysts, investment managers, and industry consultants.
- Accurate Financial Data: Antero Midstream’s historical and forecasted financial information is preloaded for precision.
- Flexible Scenario Analysis: Easily test various financial forecasts and assumptions.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the calculation process.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing Antero Midstream Corporation (AM).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Antero Midstream Corporation (AM).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how companies like Antero Midstream Corporation (AM) are valued in the energy market.
What the Template Contains
- Pre-Filled Data: Contains Antero Midstream Corporation's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Evaluate Antero Midstream Corporation's profitability, efficiency, and leverage.
- Customizable Inputs: Easily adjust revenue growth, margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing key valuation results.