Scholar Rock Holding Corporation (SRRK) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Scholar Rock Holding Corporation (SRRK) Bundle
Whether you’re an investor or analyst, this Scholar Rock Holding Corporation (SRRK) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Scholar Rock, you can adjust forecasts and observe the effects in real-time.
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 | 20.5 | 15.4 | 18.8 | 33.2 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | -24.83 | 22.16 | 76.41 | -100 | -6.57 | -6.57 | -6.57 | -6.57 | -6.57 |
EBITDA | -53.2 | -85.4 | -127.3 | -131.4 | -168.5 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | -259.8 | -554.35 | -676.52 | -395.82 | 100 | -60 | -60 | -60 | -60 | -60 |
Depreciation | 2.3 | 3.9 | 9.0 | 9.9 | 2.8 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 11.22 | 25.13 | 47.96 | 29.78 | 100 | 42.82 | 42.82 | 42.82 | 42.82 | 42.82 |
EBIT | -55.5 | -89.3 | -136.3 | -141.3 | -171.3 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | -271.03 | -579.48 | -724.48 | -425.6 | 100 | -60 | -60 | -60 | -60 | -60 |
Total Cash | 157.4 | 341.0 | 253.0 | 315.4 | 279.9 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 25.0 | .0 | .0 | 2.7 | 1.1 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 122 | 0 | 0 | 8.24 | 100 | 41.65 | 41.65 | 41.65 | 41.65 | 41.65 |
Inventories | -25.0 | .0 | .0 | -2.7 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | -122 | 0 | 0 | -8.24 | 100 | -1.65 | -1.65 | -1.65 | -1.65 | -1.65 |
Accounts Payable | 1.1 | 3.4 | 4.4 | 4.0 | 3.5 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 5.51 | 22.13 | 23.57 | 12.03 | 100 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 |
Capital Expenditure | -3.1 | -4.1 | -5.2 | -1.1 | -.1 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | -15.2 | -26.54 | -27.89 | -3.21 | 100 | -14.57 | -14.57 | -14.57 | -14.57 | -14.57 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -54.1 | -87.7 | -136.3 | -138.3 | -171.3 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -53.8 | -85.7 | -131.5 | -129.9 | -170.1 | -2.4 | .0 | .0 | .0 | .0 |
WACC, % | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 |
PV UFCF | ||||||||||
SUM PV UFCF | -2.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -2 | |||||||||
Net Debt | -40 | |||||||||
Equity Value | 38 | |||||||||
Diluted Shares Outstanding, MM | 83 | |||||||||
Equity Value Per Share | 0.45 |
What You Will Get
- Real SRRK Financial Data: Pre-filled with Scholar Rock Holding Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Scholar Rock Holding Corporation’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Research Inputs: Adjust essential variables such as revenue projections, R&D investment, and operational costs.
- Instant DCF Analysis: Automatically computes intrinsic value, NPV, and additional metrics in real-time.
- High-Precision Estimates: Leverages Scholar Rock's actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based SRRK DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically recalculate Scholar Rock’s intrinsic value.
- Test Scenarios: Explore different assumptions to see how they impact potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Scholar Rock Holding Corporation (SRRK)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for SRRK.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios for SRRK.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Scholar Rock Holding Corporation.
- Preloaded Information: Access to historical and projected data for precise calculations.
- Expert-Level Tool: Perfect for financial analysts, investors, and consultants focusing on SRRK.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Scholar Rock Holding Corporation (SRRK) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Scholar Rock Holding Corporation (SRRK).
- Consultants: Deliver professional valuation insights on Scholar Rock Holding Corporation (SRRK) to clients quickly and accurately.
- Business Owners: Understand how biotech companies like Scholar Rock Holding Corporation (SRRK) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Scholar Rock Holding Corporation (SRRK).
What the Template Contains
- Preloaded SRRK Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.