|
Ontrak, Inc. (OTRK) DCF Valuation
US | Healthcare | Medical - Healthcare Information Services | NASDAQ
|
- ✓ 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
Ontrak, Inc. (OTRK) Bundle
Gain insight into your Ontrak, Inc. (OTRK) valuation analysis with our state-of-the-art DCF Calculator! Equipped with real-time OTRK data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Ontrak, 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 | 35.1 | 82.8 | 84.1 | 14.5 | 12.7 | 13.0 | 13.2 | 13.4 | 13.6 | 13.8 |
Revenue Growth, % | 0 | 136.04 | 1.56 | -82.75 | -12.2 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 |
EBITDA | -21.8 | -14.9 | -24.7 | -42.4 | -14.4 | -8.0 | -8.1 | -8.3 | -8.4 | -8.6 |
EBITDA, % | -62.07 | -18.01 | -29.3 | -291.98 | -113.13 | -61.88 | -61.88 | -61.88 | -61.88 | -61.88 |
Depreciation | .8 | 1.9 | 4.3 | 5.2 | 6.4 | 2.5 | 2.5 | 2.6 | 2.6 | 2.6 |
Depreciation, % | 2.36 | 2.33 | 5.16 | 35.83 | 50.08 | 19.15 | 19.15 | 19.15 | 19.15 | 19.15 |
EBIT | -22.6 | -16.9 | -29.0 | -47.6 | -20.8 | -8.3 | -8.4 | -8.5 | -8.7 | -8.8 |
EBIT, % | -64.43 | -20.34 | -34.46 | -327.81 | -163.21 | -63.85 | -63.85 | -63.85 | -63.85 | -63.85 |
Total Cash | 13.6 | 86.9 | 58.8 | 5.0 | 9.7 | 8.3 | 8.4 | 8.6 | 8.7 | 8.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.7 | 21.1 | 9.2 | 1.4 | .6 | 1.7 | 1.8 | 1.8 | 1.8 | 1.9 |
Account Receivables, % | 16.26 | 25.48 | 10.9 | 9.82 | 4.76 | 13.45 | 13.45 | 13.45 | 13.45 | 13.45 |
Inventories | .0 | 11.5 | 7.3 | 4.6 | .0 | 1.4 | 1.4 | 1.5 | 1.5 | 1.5 |
Inventories, % | 0 | 13.86 | 8.7 | 31.92 | 0 | 10.89 | 10.89 | 10.89 | 10.89 | 10.89 |
Accounts Payable | 1.4 | 1.3 | 1.0 | 1.9 | .6 | .6 | .6 | .7 | .7 | .7 |
Accounts Payable, % | 3.95 | 1.55 | 1.19 | 13.28 | 4.42 | 4.88 | 4.88 | 4.88 | 4.88 | 4.88 |
Capital Expenditure | .0 | -1.8 | -4.5 | -1.2 | -.3 | -.5 | -.5 | -.5 | -.5 | -.5 |
Capital Expenditure, % | 0 | -2.12 | -5.32 | -7.96 | -2.24 | -3.53 | -3.53 | -3.53 | -3.53 | -3.53 |
Tax Rate, % | 0.28571 | 0.28571 | 0.28571 | 0.28571 | 0.28571 | 0.28571 | 0.28571 | 0.28571 | 0.28571 | 0.28571 |
EBITAT | -23.1 | -16.4 | -29.1 | -47.7 | -20.7 | -8.2 | -8.4 | -8.5 | -8.6 | -8.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -26.6 | -43.2 | -13.4 | -32.3 | -10.6 | -8.7 | -6.3 | -6.4 | -6.6 | -6.7 |
WACC, % | 53.6 | 52.54 | 53.6 | 53.6 | 53.49 | 53.37 | 53.37 | 53.37 | 53.37 | 53.37 |
PV UFCF | ||||||||||
SUM PV UFCF | -12.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -7 | |||||||||
Terminal Value | -13 | |||||||||
Present Terminal Value | -2 | |||||||||
Enterprise Value | -14 | |||||||||
Net Debt | -8 | |||||||||
Equity Value | -6 | |||||||||
Diluted Shares Outstanding, MM | 11 | |||||||||
Equity Value Per Share | -0.51 |
What You Will Get
- Comprehensive OTRK Financials: Access historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to suit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Ontrak’s future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Performance Metrics: Adjust essential inputs such as patient engagement rates, revenue per patient, and operational costs.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Ontrak's (OTRK) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Download: Get the pre-built Excel file containing Ontrak, Inc.'s (OTRK) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and compare results instantly.
- Make Decisions: Utilize the valuation findings to inform your investment strategy.
Why Choose This Calculator for Ontrak, Inc. (OTRK)?
- Designed for Experts: A specialized tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Data: Ontrak’s historical and anticipated financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Detailed instructions walk you through each step of the calculation.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Ontrak, Inc. (OTRK) stock.
- Financial Analysts: Enhance valuation processes with efficient, ready-to-use financial models for Ontrak, Inc. (OTRK).
- Consultants: Provide clients with professional valuation insights on Ontrak, Inc. (OTRK) swiftly and accurately.
- Business Owners: Learn how companies like Ontrak, Inc. (OTRK) are valued to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and case studies related to Ontrak, Inc. (OTRK).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Ontrak, Inc. (OTRK).
- Real-World Data: Ontrak’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test scenarios specific to Ontrak, Inc. (OTRK).
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Ontrak's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage tailored to Ontrak, Inc. (OTRK).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results regarding Ontrak, Inc. (OTRK).