Clarivate Plc (CLVT) 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
Clarivate Plc (CLVT) Bundle
If you’re an investor or analyst, this Clarivate Plc (CLVT) DCF Calculator is your go-to resource for accurate valuation. With real data from Clarivate, you can adjust forecasts and immediately observe the effects.
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 | 1,254.0 | 1,876.9 | 2,659.8 | 2,659.8 | 2,628.8 | 3,221.7 | 3,948.3 | 4,838.8 | 5,930.1 | 7,267.5 |
| Revenue Growth, % | 0 | 49.67 | 41.71 | 0 | -1.17 | 22.55 | 22.55 | 22.55 | 22.55 | 22.55 |
| EBITDA | 110.5 | 52.4 | 532.2 | -3,008.3 | -85.9 | -461.7 | -565.9 | -693.5 | -849.9 | -1,041.6 |
| EBITDA, % | 8.81 | 2.79 | 20.01 | -113.1 | -3.27 | -14.33 | -14.33 | -14.33 | -14.33 | -14.33 |
| Depreciation | 200.5 | 303.2 | 537.8 | 710.5 | 708.3 | 683.1 | 837.2 | 1,026.0 | 1,257.4 | 1,541.0 |
| Depreciation, % | 15.99 | 16.15 | 20.22 | 26.71 | 26.94 | 21.2 | 21.2 | 21.2 | 21.2 | 21.2 |
| EBIT | -90.1 | -250.8 | -5.7 | -3,718.8 | -794.2 | -972.7 | -1,192.1 | -1,461.0 | -1,790.5 | -2,194.3 |
| EBIT, % | -7.18 | -13.36 | -0.2128 | -139.82 | -30.21 | -30.19 | -30.19 | -30.19 | -30.19 | -30.19 |
| Total Cash | 257.7 | 430.9 | 348.8 | 348.8 | 370.7 | 540.2 | 662.0 | 811.3 | 994.3 | 1,218.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 333.9 | 737.7 | 906.4 | 872.1 | 908.3 | 1,078.3 | 1,321.5 | 1,619.5 | 1,984.8 | 2,432.4 |
| Account Receivables, % | 26.62 | 39.31 | 34.08 | 32.79 | 34.55 | 33.47 | 33.47 | 33.47 | 33.47 | 33.47 |
| Inventories | 70.0 | 233.3 | 97.4 | 97.4 | -88.5 | 141.6 | 173.5 | 212.6 | 260.6 | 319.4 |
| Inventories, % | 5.59 | 12.43 | 3.66 | 3.66 | -3.37 | 4.39 | 4.39 | 4.39 | 4.39 | 4.39 |
| Accounts Payable | 26.5 | 82.0 | 129.2 | 101.4 | 144.1 | 132.9 | 162.9 | 199.7 | 244.7 | 299.9 |
| Accounts Payable, % | 2.11 | 4.37 | 4.86 | 3.81 | 5.48 | 4.13 | 4.13 | 4.13 | 4.13 | 4.13 |
| Capital Expenditure | -113.7 | -118.5 | -202.9 | -202.9 | -242.5 | -256.9 | -314.8 | -385.8 | -472.8 | -579.4 |
| Capital Expenditure, % | -9.07 | -6.32 | -7.63 | -7.63 | -9.22 | -7.97 | -7.97 | -7.97 | -7.97 | -7.97 |
| Tax Rate, % | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| EBITAT | -87.7 | -262.7 | -5.6 | -3,691.9 | -714.7 | -945.5 | -1,158.7 | -1,420.0 | -1,740.3 | -2,132.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -378.3 | -589.6 | 343.7 | -3,177.8 | -56.5 | -930.4 | -881.4 | -1,080.2 | -1,323.8 | -1,622.4 |
| WACC, % | 7.65 | 7.74 | 7.72 | 7.72 | 7.39 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -4,599.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,655 | |||||||||
| Terminal Value | -29,327 | |||||||||
| Present Terminal Value | -20,293 | |||||||||
| Enterprise Value | -24,893 | |||||||||
| Net Debt | 4,438 | |||||||||
| Equity Value | -29,331 | |||||||||
| Diluted Shares Outstanding, MM | 672 | |||||||||
| Equity Value Per Share | -43.67 |
What You Will Receive
- Comprehensive Financial Model: Clarivate's actual data allows for accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other critical factors.
- Real-Time Calculations: Instant updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation analysis.
- Adaptable and Reusable: Designed for versatility, enabling frequent use for in-depth forecasts.
Key Features
- Comprehensive Data: Clarivate’s extensive historical financial records and pre-populated forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Monitor Clarivate’s intrinsic value updates instantly as you modify inputs.
- Intuitive Visualizations: Engaging dashboard graphics showcase valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and financial professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based CLVT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Clarivate’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Clarivate Plc (CLVT)?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and industry consultants.
- Accurate Data: Clarivate’s historical and forecasted financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance to facilitate your calculations.
Who Should Use This Product?
- Finance Students: Master valuation techniques and apply them to real-world data for Clarivate Plc (CLVT).
- Academics: Integrate professional models into your research or teaching focused on Clarivate Plc (CLVT).
- Investors: Validate your investment strategies and evaluate valuation results for Clarivate Plc (CLVT).
- Analysts: Enhance your efficiency with a ready-to-use, customizable DCF model for Clarivate Plc (CLVT).
- Small Business Owners: Discover how large public companies like Clarivate Plc (CLVT) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Clarivate Plc (CLVT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Clarivate Plc (CLVT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.