|
Sportradar Group AG (SRAD) DCF Valuation
CH | Technology | Software - Application | NASDAQ
|
- ✓ 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
Sportradar Group AG (SRAD) Bundle
Assess Sportradar Group AG's financial outlook like an expert! This SRAD DCF Calculator provides you with pre-filled financial data and offers comprehensive flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 396.0 | 421.5 | 584.2 | 760.1 | 913.6 | 1,131.3 | 1,401.0 | 1,734.9 | 2,148.5 | 2,660.6 |
Revenue Growth, % | 0 | 6.45 | 38.59 | 30.11 | 20.19 | 23.84 | 23.84 | 23.84 | 23.84 | 23.84 |
EBITDA | 161.8 | 178.2 | 188.4 | 252.6 | 296.7 | 409.8 | 507.5 | 628.4 | 778.2 | 963.7 |
EBITDA, % | 40.87 | 42.28 | 32.25 | 33.23 | 32.48 | 36.22 | 36.22 | 36.22 | 36.22 | 36.22 |
Depreciation | 117.1 | 103.0 | 140.0 | 188.9 | 214.8 | 285.9 | 354.0 | 438.4 | 542.9 | 672.3 |
Depreciation, % | 29.57 | 24.44 | 23.97 | 24.85 | 23.51 | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 |
EBIT | 44.8 | 75.2 | 48.3 | 63.7 | 81.9 | 123.9 | 153.4 | 190.0 | 235.3 | 291.4 |
EBIT, % | 11.3 | 17.84 | 8.28 | 8.38 | 8.96 | 10.95 | 10.95 | 10.95 | 10.95 | 10.95 |
Total Cash | 59.4 | 401.3 | 773.2 | 253.7 | 288.5 | 622.6 | 771.0 | 954.8 | 1,182.4 | 1,464.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 34.5 | 49.5 | 85.7 | 128.0 | 137.5 | 151.7 | 187.8 | 232.6 | 288.0 | 356.7 |
Account Receivables, % | 8.71 | 11.75 | 14.68 | 16.84 | 15.05 | 13.41 | 13.41 | 13.41 | 13.41 | 13.41 |
Inventories | 16.1 | 11.9 | .0 | .0 | 6.2 | 17.1 | 21.2 | 26.2 | 32.5 | 40.3 |
Inventories, % | 4.07 | 2.81 | 0 | 0.000000137 | 0.68207 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 |
Accounts Payable | 17.4 | 38.4 | 26.3 | 58.7 | 60.0 | 73.0 | 90.5 | 112.0 | 138.7 | 171.8 |
Accounts Payable, % | 4.39 | 9.11 | 4.49 | 7.72 | 6.57 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
Capital Expenditure | -102.3 | -97.8 | -136.1 | -169.2 | -208.5 | -265.7 | -329.0 | -407.4 | -504.5 | -624.8 |
Capital Expenditure, % | -25.83 | -23.2 | -23.3 | -22.26 | -22.82 | -23.48 | -23.48 | -23.48 | -23.48 | -23.48 |
Tax Rate, % | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 | 26.57 |
EBITAT | -51.3 | 51.8 | 25.5 | 39.0 | 60.1 | 63.5 | 78.6 | 97.4 | 120.6 | 149.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -69.7 | 67.2 | -7.0 | 48.9 | 52.0 | 71.7 | 80.9 | 100.1 | 124.0 | 153.6 |
WACC, % | 13.99 | 14.4 | 14.3 | 14.35 | 14.43 | 14.29 | 14.29 | 14.29 | 14.29 | 14.29 |
PV UFCF | ||||||||||
SUM PV UFCF | 343.1 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 160 | |||||||||
Terminal Value | 1,551 | |||||||||
Present Terminal Value | 795 | |||||||||
Enterprise Value | 1,139 | |||||||||
Net Debt | -236 | |||||||||
Equity Value | 1,375 | |||||||||
Diluted Shares Outstanding, MM | 317 | |||||||||
Equity Value Per Share | 4.34 |
What You Will Get
- Real SRAD Financial Data: Pre-filled with Sportradar Group AG’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 Sportradar Group AG’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 Performance Metrics: Adjust essential inputs such as user growth, revenue streams, and operational costs.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics in real-time.
- High-Precision Accuracy: Leverages Sportradar's actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results effortlessly.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Sportradar data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Sportradar’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Sportradar Group AG (SRAD)?
- User-Friendly Interface: Tailored for both newcomers and seasoned users.
- Customizable Inputs: Adjust parameters easily to suit your analytical needs.
- Real-Time Insights: Watch Sportradar’s valuation update instantly as you change inputs.
- Pre-Loaded Data: Comes with Sportradar’s latest financial information for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and precise valuation models for assessing investments in Sportradar Group AG (SRAD).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver clients accurate valuation insights regarding Sportradar Group AG (SRAD) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Sports Analytics Enthusiasts: Gain insights into how companies like Sportradar Group AG (SRAD) are valued in the sports data market.
What the Template Contains
- Preloaded SRAD 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.