Option Care Health, Inc. (OPCH) 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
Option Care Health, Inc. (OPCH) Bundle
Explore Option Care Health, Inc. (OPCH) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to compute Option Care Health, Inc. (OPCH) intrinsic value and inform 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 | 2,310.4 | 3,032.6 | 3,438.6 | 3,944.7 | 4,302.3 | 5,038.3 | 5,900.3 | 6,909.7 | 8,091.7 | 9,476.0 |
| Revenue Growth, % | 0 | 31.26 | 13.39 | 14.72 | 9.06 | 17.11 | 17.11 | 17.11 | 17.11 | 17.11 |
| EBITDA | 72.8 | 182.7 | 255.9 | 345.8 | 483.2 | 368.9 | 432.1 | 506.0 | 592.5 | 693.9 |
| EBITDA, % | 3.15 | 6.02 | 7.44 | 8.77 | 11.23 | 7.32 | 7.32 | 7.32 | 7.32 | 7.32 |
| Depreciation | 77.6 | 96.7 | 84.0 | 85.1 | 62.2 | 126.9 | 148.6 | 174.0 | 203.8 | 238.7 |
| Depreciation, % | 3.36 | 3.19 | 2.44 | 2.16 | 1.45 | 2.52 | 2.52 | 2.52 | 2.52 | 2.52 |
| EBIT | -4.8 | 85.9 | 172.0 | 260.7 | 421.0 | 242.0 | 283.4 | 331.9 | 388.7 | 455.2 |
| EBIT, % | -0.20784 | 2.83 | 5 | 6.61 | 9.78 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 |
| Total Cash | 67.1 | 99.3 | 119.4 | 294.2 | 343.8 | 252.9 | 296.2 | 346.8 | 406.2 | 475.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 324.4 | 328.3 | 338.2 | 377.5 | 377.7 | 534.6 | 626.1 | 733.2 | 858.6 | 1,005.5 |
| Account Receivables, % | 14.04 | 10.83 | 9.84 | 9.57 | 8.78 | 10.61 | 10.61 | 10.61 | 10.61 | 10.61 |
| Inventories | 115.9 | 158.6 | 183.1 | 224.3 | 274.0 | 278.4 | 326.0 | 381.7 | 447.1 | 523.5 |
| Inventories, % | 5.02 | 5.23 | 5.32 | 5.69 | 6.37 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 |
| Accounts Payable | 221.1 | 282.9 | 279.2 | 378.8 | 426.5 | 468.9 | 549.1 | 643.1 | 753.1 | 881.9 |
| Accounts Payable, % | 9.57 | 9.33 | 8.12 | 9.6 | 9.91 | 9.31 | 9.31 | 9.31 | 9.31 | 9.31 |
| Capital Expenditure | -28.3 | -26.9 | -25.6 | -35.4 | -41.9 | -47.6 | -55.8 | -65.3 | -76.5 | -89.6 |
| Capital Expenditure, % | -1.22 | -0.8862 | -0.74541 | -0.89633 | -0.9731 | -0.94512 | -0.94512 | -0.94512 | -0.94512 | -0.94512 |
| Tax Rate, % | 25.55 | 25.55 | 25.55 | 25.55 | 25.55 | 25.55 | 25.55 | 25.55 | 25.55 | 25.55 |
| EBITAT | -4.7 | 132.4 | 206.5 | 190.7 | 313.4 | 215.3 | 252.1 | 295.2 | 345.7 | 404.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -174.6 | 217.4 | 226.8 | 259.5 | 331.7 | 175.6 | 286.1 | 335.0 | 392.3 | 459.5 |
| WACC, % | 9.29 | 9.32 | 9.32 | 9.06 | 9.07 | 9.21 | 9.21 | 9.21 | 9.21 | 9.21 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,229.4 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 476 | |||||||||
| Terminal Value | 8,325 | |||||||||
| Present Terminal Value | 5,358 | |||||||||
| Enterprise Value | 6,588 | |||||||||
| Net Debt | 823 | |||||||||
| Equity Value | 5,765 | |||||||||
| Diluted Shares Outstanding, MM | 180 | |||||||||
| Equity Value Per Share | 31.96 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled financial data for Option Care Health, Inc. (OPCH).
- Comprehensive Data: Access to historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify key forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Option Care Health, Inc. (OPCH).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for straightforward navigation and ease of use, complete with detailed instructions.
Key Features
- Comprehensive Historical Data: Option Care Health's past financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe Option Care Health's intrinsic value recalculating instantly.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Option Care Health, Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for Option Care Health, Inc. (OPCH)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and healthcare consultants.
- Comprehensive Data: Option Care Health’s historical and projected financials integrated for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed instructions provide a smooth and guided experience.
Who Should Use This Product?
- Individual Investors: Gain insights for making informed decisions about investing in Option Care Health, Inc. (OPCH).
- Financial Analysts: Enhance valuation methodologies with comprehensive financial models tailored for Option Care Health, Inc. (OPCH).
- Consultants: Provide clients with precise valuation assessments of Option Care Health, Inc. (OPCH) efficiently.
- Business Owners: Learn how healthcare companies like Option Care Health, Inc. (OPCH) are valued to inform your own business strategies.
- Finance Students: Explore valuation practices using real-world examples and data from Option Care Health, Inc. (OPCH).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to Option Care Health, Inc. (OPCH).
- Real-World Data: Option Care Health’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns to gain deeper insights into the company's performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Engaging charts and tables that provide clear, actionable results.