|
Revolution Medicines, Inc. (RVMD) Valoración de DCF
US | 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
Revolution Medicines, Inc. (RVMD) Bundle
¡Descubra el verdadero potencial de Revolution Medicines, Inc. (RVMD) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Revolution Medicines, Inc. (RVMD), todo dentro de una sola plantilla de Excel.
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 | 50.0 | 43.0 | 29.4 | 35.4 | 11.6 | 8.9 | 6.8 | 5.3 | 4.0 | 3.1 |
Revenue Growth, % | 0 | -14.1 | -31.62 | 20.38 | -67.27 | -23.15 | -23.15 | -23.15 | -23.15 | -23.15 |
EBITDA | -48.6 | -101.9 | -179.7 | -239.5 | -430.6 | -8.8 | -6.8 | -5.2 | -4.0 | -3.1 |
EBITDA, % | -97.1 | -237.1 | -611.59 | -676.85 | -3718.32 | -99.42 | -99.42 | -99.42 | -99.42 | -99.42 |
Depreciation | 3.3 | 6.5 | 7.3 | 9.7 | 9.3 | 2.8 | 2.1 | 1.6 | 1.2 | 1.0 |
Depreciation, % | 6.68 | 15.23 | 24.95 | 27.29 | 80.39 | 30.91 | 30.91 | 30.91 | 30.91 | 30.91 |
EBIT | -51.9 | -108.5 | -187.1 | -249.1 | -439.9 | -8.9 | -6.8 | -5.3 | -4.0 | -3.1 |
EBIT, % | -103.78 | -252.33 | -636.54 | -704.14 | -3798.71 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 122.8 | 440.7 | 577.1 | 644.9 | 1,853.0 | 8.9 | 6.8 | 5.3 | 4.0 | 3.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.7 | 6.4 | 5.9 | 4.7 | 1.3 | 1.4 | 1.0 | .8 | .6 | .5 |
Account Receivables, % | 17.46 | 14.87 | 20.17 | 13.21 | 10.83 | 15.31 | 15.31 | 15.31 | 15.31 | 15.31 |
Inventories | .0 | .0 | -12.7 | .0 | .0 | -.8 | -.6 | -.5 | -.3 | -.3 |
Inventories, % | 0.000001998361 | 0 | -43.28 | 0.000002826456 | 0 | -8.66 | -8.66 | -8.66 | -8.66 | -8.66 |
Accounts Payable | 11.4 | 12.6 | 14.1 | 21.3 | 61.8 | 4.6 | 3.6 | 2.7 | 2.1 | 1.6 |
Accounts Payable, % | 22.78 | 29.33 | 47.83 | 60.22 | 533.58 | 52.03 | 52.03 | 52.03 | 52.03 | 52.03 |
Capital Expenditure | -2.6 | -2.9 | -6.5 | -10.8 | -7.7 | -2.3 | -1.8 | -1.4 | -1.1 | -.8 |
Capital Expenditure, % | -5.17 | -6.82 | -22.21 | -30.57 | -66.74 | -26.3 | -26.3 | -26.3 | -26.3 | -26.3 |
Tax Rate, % | 0.80111 | 0.80111 | 0.80111 | 0.80111 | 0.80111 | 0.80111 | 0.80111 | 0.80111 | 0.80111 | 0.80111 |
EBITAT | -47.6 | -108.1 | -179.8 | -248.7 | -436.4 | -8.7 | -6.7 | -5.1 | -3.9 | -3.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -44.2 | -100.9 | -164.3 | -254.1 | -390.9 | -64.7 | -7.3 | -5.6 | -4.3 | -3.3 |
WACC, % | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 |
PV UFCF | ||||||||||
SUM PV UFCF | -73.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -3 | |||||||||
Terminal Value | -38 | |||||||||
Present Terminal Value | -22 | |||||||||
Enterprise Value | -95 | |||||||||
Net Debt | -608 | |||||||||
Equity Value | 513 | |||||||||
Diluted Shares Outstanding, MM | 113 | |||||||||
Equity Value Per Share | 4.53 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financials for Revolution Medicines, Inc. (RVMD).
- Real-Time Data: Historical financial data and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify assumptions such as revenue growth, EBITDA %, and WACC to suit your analysis.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Revolution Medicines, Inc. (RVMD).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and user-friendliness, complete with detailed instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Revolution Medicines, Inc. (RVMD).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to RVMD.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Revolution Medicines' projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Revolution Medicines, Inc. (RVMD).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Revolution Medicines, Inc. (RVMD).
- Step 2: Review the pre-filled financial data and forecasts for Revolution Medicines, Inc. (RVMD).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells) for Revolution Medicines, Inc. (RVMD).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions for Revolution Medicines, Inc. (RVMD).
- Step 5: Evaluate the outputs and utilize the results for your investment decisions regarding Revolution Medicines, Inc. (RVMD).
Why Choose the Revolution Medicines, Inc. (RVMD) Calculator?
- Accuracy: Utilizes real Revolution Medicines financial data for precise calculations.
- Flexibility: Allows users to easily experiment and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial modeling knowledge.
Who Should Use This Product?
- Investors: Evaluate Revolution Medicines, Inc. (RVMD) to inform stock trading decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate financial forecasts.
- Biotech Entrepreneurs: Understand the valuation strategies of established biotech firms like Revolution Medicines.
- Consultants: Provide comprehensive valuation analyses for clients in the biotech sector.
- Students and Educators: Utilize current market data to explore and teach valuation concepts.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Revolution Medicines, Inc. (RVMD).
- Real-World Data: Revolution Medicines' historical and projected financials preloaded for in-depth 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 the company's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Revolution Medicines, Inc. (RVMD).
- Dashboard with Visual Outputs: Interactive charts and tables providing clear, actionable results for stakeholders.