Roivant Sciences Ltd. (ROIV) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Roivant Sciences Ltd. (ROIV) Bundle
Discover the true potential of Roivant Sciences Ltd. (ROIV) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and examine the effects of changes on Roivant's valuation – all within a comprehensive 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 | 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.