agilon health, inc. (AGL) 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
agilon health, inc. (AGL) Bundle
Gain insights into your agilon health, inc. (AGL) valuation analysis using our sophisticated DCF Calculator! This Excel template is preloaded with real (AGL) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of agilon health, inc.
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 | 794.4 | 1,218.3 | 1,833.6 | 2,708.2 | 4,316.4 | 6,592.6 | 10,069.3 | 15,379.5 | 23,489.9 | 35,877.6 |
| Revenue Growth, % | 0 | 53.36 | 50.5 | 47.7 | 59.38 | 52.74 | 52.74 | 52.74 | 52.74 | 52.74 |
| EBITDA | -64.2 | -40.1 | -383.8 | -72.4 | -167.6 | -512.4 | -782.6 | -1,195.4 | -1,825.8 | -2,788.6 |
| EBITDA, % | -8.08 | -3.29 | -20.93 | -2.67 | -3.88 | -7.77 | -7.77 | -7.77 | -7.77 | -7.77 |
| Depreciation | 41.4 | 14.1 | 14.7 | 13.8 | 20.2 | 107.4 | 164.0 | 250.6 | 382.7 | 584.5 |
| Depreciation, % | 5.21 | 1.16 | 0.80008 | 0.50853 | 0.46708 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| EBIT | -105.6 | -54.2 | -398.5 | -86.2 | -187.8 | -619.8 | -946.7 | -1,445.9 | -2,208.5 | -3,373.1 |
| EBIT, % | -13.3 | -4.45 | -21.73 | -3.18 | -4.35 | -9.4 | -9.4 | -9.4 | -9.4 | -9.4 |
| Total Cash | 123.6 | 106.8 | 1,040.0 | 909.0 | 488.3 | 1,660.4 | 2,536.0 | 3,873.4 | 5,916.1 | 9,036.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 93.3 | 144.6 | 293.4 | 492.4 | 942.5 | 1,049.8 | 1,603.5 | 2,449.0 | 3,740.6 | 5,713.2 |
| Account Receivables, % | 11.74 | 11.86 | 16 | 18.18 | 21.83 | 15.92 | 15.92 | 15.92 | 15.92 | 15.92 |
| Inventories | .0 | .0 | .0 | 10.6 | .0 | 5.2 | 7.9 | 12.1 | 18.4 | 28.1 |
| Inventories, % | 0.000000126 | 0.0000000821 | 0.0000000545 | 0.39177 | 0 | 0.07835436 | 0.07835436 | 0.07835436 | 0.07835436 | 0.07835436 |
| Accounts Payable | 61.7 | 256.7 | 109.6 | 174.0 | 968.1 | 839.5 | 1,282.2 | 1,958.4 | 2,991.2 | 4,568.6 |
| Accounts Payable, % | 7.77 | 21.07 | 5.98 | 6.42 | 22.43 | 12.73 | 12.73 | 12.73 | 12.73 | 12.73 |
| Capital Expenditure | -3.9 | -2.4 | -13.4 | -32.7 | -30.8 | -44.0 | -67.2 | -102.6 | -156.8 | -239.4 |
| Capital Expenditure, % | -0.49169 | -0.19289 | -0.73224 | -1.21 | -0.71391 | -0.66734 | -0.66734 | -0.66734 | -0.66734 | -0.66734 |
| Tax Rate, % | -35.04 | -35.04 | -35.04 | -35.04 | -35.04 | -35.04 | -35.04 | -35.04 | -35.04 | -35.04 |
| EBITAT | -105.4 | -55.0 | -399.3 | -87.1 | -253.6 | -619.6 | -946.3 | -1,445.4 | -2,207.6 | -3,371.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -99.5 | 100.5 | -694.0 | -251.3 | 90.3 | -797.3 | -963.1 | -1,471.0 | -2,246.8 | -3,431.6 |
| WACC, % | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -6,801.2 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -3,569 | |||||||||
| Terminal Value | -98,206 | |||||||||
| Present Terminal Value | -67,981 | |||||||||
| Enterprise Value | -74,782 | |||||||||
| Net Debt | -55 | |||||||||
| Equity Value | -74,727 | |||||||||
| Diluted Shares Outstanding, MM | 409 | |||||||||
| Equity Value Per Share | -182.74 |
What You Will Get
- Real AGL Financial Data: Pre-filled with agilon health, inc.'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 agilon health, inc.'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 DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for agilon health, inc. (AGL).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to agilon health, inc. (AGL).
- Customizable Forecast Assumptions: Update growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to agilon health, inc. (AGL).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based AGL DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates agilon health, inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial decisions.
Why Choose This Calculator for Agilon Health, Inc. (AGL)?
- Reliable Data: Current Agilon financials provide trustworthy valuation insights.
- Flexible Options: Modify essential factors such as growth projections, WACC, and tax rates to fit your analysis.
- Efficiency Boost: Built-in calculations save you the effort of starting from the ground up.
- Expert-Quality Tool: Tailored for investors, analysts, and healthcare consultants.
- Easy to Use: User-friendly design and clear instructions ensure accessibility for all skill levels.
Who Should Use Agilon Health, Inc. (AGL)?
- Healthcare Investors: Make informed investment choices leveraging a comprehensive analysis of the healthcare sector.
- Healthcare Analysts: Streamline your research process with ready-to-use financial models tailored for the health industry.
- Consultants: Effortlessly modify presentations or reports for clients in the healthcare space.
- Health Policy Enthusiasts: Expand your knowledge of healthcare systems and their financial implications through real-life case studies.
- Educators and Students: Utilize this resource as a hands-on educational tool in healthcare finance courses.
What the Template Contains for Agilon Health, Inc. (AGL)
- Comprehensive DCF Model: Editable template featuring thorough valuation calculations tailored for Agilon Health.
- Real-World Data: Agilon Health’s historical and projected financials preloaded for detailed 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 performance.
- Key Ratios: Integrated analysis focusing on profitability, efficiency, and leverage specific to Agilon Health.
- Dashboard with Visual Outputs: Interactive charts and tables providing clear, actionable results.