The Oncology Institute, Inc. (TOI) DCF Valuation
- ✓ 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
The Oncology Institute, Inc. (TOI) Bundle
Discover the true value of The Oncology Institute, Inc. (TOI) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect The Oncology Institute's valuation – all within a single Excel template.
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 | 155.4 | 187.5 | 203.0 | 252.5 | 324.2 | 390.5 | 470.2 | 566.3 | 682.0 | 821.3 |
Revenue Growth, % | 0 | 20.66 | 8.26 | 24.37 | 28.42 | 20.43 | 20.43 | 20.43 | 20.43 | 20.43 |
EBITDA | .3 | -11.3 | -7.9 | 8.4 | -70.5 | -22.0 | -26.5 | -31.9 | -38.4 | -46.2 |
EBITDA, % | 0.19762 | -6.02 | -3.91 | 3.33 | -21.73 | -5.63 | -5.63 | -5.63 | -5.63 | -5.63 |
Depreciation | 2.9 | 3.2 | 3.3 | 4.4 | 5.9 | 6.9 | 8.3 | 10.0 | 12.0 | 14.4 |
Depreciation, % | 1.89 | 1.69 | 1.65 | 1.75 | 1.81 | 1.76 | 1.76 | 1.76 | 1.76 | 1.76 |
EBIT | -2.6 | -14.5 | -11.3 | 4.0 | -76.3 | -28.8 | -34.7 | -41.8 | -50.4 | -60.7 |
EBIT, % | -1.7 | -7.72 | -5.56 | 1.58 | -23.54 | -7.39 | -7.39 | -7.39 | -7.39 | -7.39 |
Total Cash | 2.4 | 6.0 | 114.3 | 73.8 | 82.9 | 90.5 | 109.0 | 131.2 | 158.0 | 190.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 14.7 | 17.3 | 21.2 | 40.4 | 42.9 | 45.6 | 54.9 | 66.1 | 79.7 | 95.9 |
Account Receivables, % | 9.48 | 9.2 | 10.46 | 16.01 | 13.23 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 |
Inventories | 3.9 | 4.4 | 6.4 | 9.3 | 13.7 | 12.4 | 14.9 | 18.0 | 21.7 | 26.1 |
Inventories, % | 2.5 | 2.32 | 3.17 | 3.67 | 4.22 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
Accounts Payable | 8.9 | 12.6 | 15.6 | 9.4 | 14.4 | 22.1 | 26.6 | 32.0 | 38.6 | 46.5 |
Accounts Payable, % | 5.72 | 6.74 | 7.66 | 3.71 | 4.45 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
Capital Expenditure | -1.2 | -1.2 | -3.0 | -5.5 | -4.6 | -5.1 | -6.1 | -7.4 | -8.9 | -10.7 |
Capital Expenditure, % | -0.77511 | -0.63681 | -1.5 | -2.19 | -1.41 | -1.3 | -1.3 | -1.3 | -1.3 | -1.3 |
Tax Rate, % | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 | 0.04331921 |
EBITAT | -4.0 | -14.0 | -10.6 | 3.5 | -76.3 | -27.6 | -33.2 | -40.0 | -48.1 | -58.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -12.0 | -11.2 | -13.5 | -25.8 | -76.8 | -19.5 | -38.4 | -46.2 | -55.7 | -67.0 |
WACC, % | 5.94 | 5.78 | 5.67 | 5.32 | 5.94 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 |
PV UFCF | ||||||||||
SUM PV UFCF | -187.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -68 | |||||||||
Terminal Value | -1,833 | |||||||||
Present Terminal Value | -1,388 | |||||||||
Enterprise Value | -1,575 | |||||||||
Net Debt | 86 | |||||||||
Equity Value | -1,661 | |||||||||
Diluted Shares Outstanding, MM | 74 | |||||||||
Equity Value Per Share | -22.52 |
What You Will Get
- Comprehensive TOI Financials: Access to both historical and projected data for precise valuation.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Planning: Explore various scenarios to assess The Oncology Institute’s future performance.
- User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- Customizable Treatment Parameters: Adjust essential factors such as patient demographics, treatment efficacy, and cost of care.
- Instant Outcome Projections: Provides real-time estimates of patient outcomes and cost-effectiveness.
- High-Precision Analytics: Leverages TOI’s extensive clinical data for accurate treatment evaluations.
- Seamless Scenario Testing: Explore various treatment pathways and easily compare results.
- Efficiency-Boosting Solution: Streamlines the process of developing complex treatment models.
How It Works
- Step 1: Download the Excel file for The Oncology Institute, Inc. (TOI).
- Step 2: Review TOI’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as patient growth, treatment costs, and reimbursement 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 informed investment decisions.
Why Choose The Oncology Institute, Inc. (TOI) Calculator?
- Comprehensive Tool: Integrates treatment cost analysis, patient outcome metrics, and financial projections in one solution.
- Customizable Inputs: Modify highlighted fields to explore different treatment scenarios and financial outcomes.
- Detailed Insights: Automatically computes the intrinsic value of TOI and forecasts future profitability.
- Preloaded Data: Access to historical treatment data and market trends for informed decision-making.
- Professional Quality: Perfect for healthcare analysts, investors, and oncology consultants.
Who Should Utilize This Service?
- Healthcare Professionals: Enhance patient care with advanced oncology treatment solutions.
- Researchers: Access valuable data and insights for groundbreaking cancer studies.
- Patients and Families: Find comprehensive support and resources tailored to your oncology needs.
- Healthcare Administrators: Streamline operations with efficient management tools designed for oncology practices.
- Students and Educators: Utilize it as a resource for learning about oncology and cancer care methodologies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for The Oncology Institute, Inc. (TOI).
- Real-World Data: The Oncology Institute’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 for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to The Oncology Institute, Inc. (TOI).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.