|
Roivant Sciences Ltd. (ROIV) Valoración de DCF
GB | Healthcare | Biotechnology | NASDAQ
|
- ✓ 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
Roivant Sciences Ltd. (ROIV) Bundle
¡Descubra el verdadero potencial de Roivant Sciences Ltd. (ROIV) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y examine los efectos de los cambios en la valoración de Roivant, todo dentro de una plantilla de Excel integral.
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 | 67.7 | 23.8 | 55.3 | 61.3 | 124.8 | 170.3 | 232.5 | 317.4 | 433.2 | 591.3 |
| Revenue Growth, % | 0 | -64.85 | 132.34 | 10.84 | 103.65 | 36.5 | 36.5 | 36.5 | 36.5 | 36.5 |
| EBITDA | -553.3 | -895.7 | -916.7 | -1,178.0 | 4,310.2 | -102.2 | -139.5 | -190.4 | -259.9 | -354.8 |
| EBITDA, % | -817.42 | -3764.4 | -1658.12 | -1922.34 | 3453.86 | -60 | -60 | -60 | -60 | -60 |
| Depreciation | -20.9 | 175.2 | 5.9 | 18.9 | 22.0 | 43.7 | 59.7 | 81.5 | 111.2 | 151.8 |
| Depreciation, % | -30.84 | 736.12 | 10.73 | 30.77 | 17.66 | 25.66 | 25.66 | 25.66 | 25.66 | 25.66 |
| EBIT | -532.4 | -1,070.9 | -922.6 | -1,196.9 | 4,288.2 | -102.2 | -139.5 | -190.4 | -259.9 | -354.8 |
| EBIT, % | -786.58 | -4500.52 | -1668.85 | -1953.11 | 3436.2 | -60 | -60 | -60 | -60 | -60 |
| Total Cash | 2,185.5 | 2,132.7 | 2,060.4 | 1,681.8 | 6,541.1 | 170.3 | 232.5 | 317.4 | 433.2 | 591.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 15.3 | 13.8 | 6.7 | 37.6 | 82.8 | 75.2 | 102.6 | 140.1 | 191.2 | 261.0 |
| Account Receivables, % | 22.57 | 58.13 | 12.18 | 61.43 | 66.36 | 44.13 | 44.13 | 44.13 | 44.13 | 44.13 |
| Inventories | .0 | .0 | .0 | 2.8 | 35.3 | 11.2 | 15.2 | 20.8 | 28.4 | 38.7 |
| Inventories, % | 0.000001477345 | 0 | 0 | 4.51 | 28.25 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 |
| Accounts Payable | 10.3 | 20.6 | 34.6 | 37.8 | 53.2 | 91.5 | 124.9 | 170.4 | 232.7 | 317.6 |
| Accounts Payable, % | 15.23 | 86.36 | 62.55 | 61.73 | 42.65 | 53.7 | 53.7 | 53.7 | 53.7 | 53.7 |
| Capital Expenditure | -4.9 | -5.8 | -17.4 | -12.7 | -1.4 | -29.0 | -39.5 | -54.0 | -73.7 | -100.5 |
| Capital Expenditure, % | -7.26 | -24.4 | -31.54 | -20.71 | -1.11 | -17 | -17 | -17 | -17 | -17 |
| Tax Rate, % | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 |
| EBITAT | 1,139.4 | -964.5 | -844.2 | -986.0 | 4,384.5 | -74.4 | -101.5 | -138.6 | -189.2 | -258.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,108.6 | -783.4 | -834.6 | -1,010.2 | 4,342.9 | 10.3 | -79.5 | -108.6 | -148.2 | -202.3 |
| WACC, % | 9.82 | 10.12 | 10.13 | 10.09 | 10.15 | 10.06 | 10.06 | 10.06 | 10.06 | 10.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -363.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -206 | |||||||||
| Terminal Value | -2,559 | |||||||||
| Present Terminal Value | -1,584 | |||||||||
| Enterprise Value | -1,948 | |||||||||
| Net Debt | -6,036 | |||||||||
| Equity Value | 4,088 | |||||||||
| Diluted Shares Outstanding, MM | 831 | |||||||||
| Equity Value Per Share | 4.92 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ROIV financials.
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Roivant Sciences’ valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Financial Data: Gain access to precise historical data and future forecasts specific to Roivant Sciences Ltd. (ROIV).
- Adjustable Forecast Variables: Modify highlighted inputs such as discount rates, growth projections, and profit margins.
- Real-Time Calculations: Automatic adjustments for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries for a clear visualization of your valuation outcomes.
- Suitable for All Skill Levels: An intuitive design tailored for investors, financial officers, and consultants alike.
How It Works
- 1. Access the Model: Download and open the Excel file featuring Roivant Sciences Ltd.'s preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as revenue growth, discount rates, and research expenditures.
- 3. Analyze Results in Real-Time: The DCF model automatically computes intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Evaluate various projections to assess a range of valuation possibilities.
- 5. Present with Assurance: Share professional valuation findings to inform your strategic decisions.
Why Choose This Calculator for Roivant Sciences Ltd. (ROIV)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your analysis needs.
- Real-Time Adjustments: Observe immediate changes in Roivant's valuation as you modify inputs.
- Preloaded Data: Comes with Roivant's actual financial information for swift evaluations.
- Relied Upon by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Roivant Sciences' valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Discover how biotech companies like Roivant Sciences are valued in the market.
- Consultants: Provide comprehensive valuation reports for your clients in the healthcare sector.
- Students and Educators: Utilize real-world examples to teach and learn valuation strategies.
What the Template Contains
- Pre-Filled Data: Includes Roivant Sciences Ltd.'s historical financials and forecasts.
- 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: Analyze Roivant Sciences Ltd.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.