Virtus Investment Partners, Inc. (VRTS) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Virtus Investment Partners, Inc. (VRTS) Bundle
As an investor or analyst, this (VRTS) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Virtus Investment Partners, Inc., you can adjust forecasts and immediately see 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 | 562.3 | 603.2 | 974.7 | 881.7 | 841.5 | 956.7 | 1,087.7 | 1,236.6 | 1,405.9 | 1,598.3 |
| Revenue Growth, % | 0 | 7.29 | 61.58 | -9.54 | -4.56 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 |
| EBITDA | 291.8 | 300.1 | 474.1 | 321.5 | 151.5 | 391.8 | 445.4 | 506.4 | 575.7 | 654.5 |
| EBITDA, % | 51.9 | 49.75 | 48.64 | 36.46 | 18 | 40.95 | 40.95 | 40.95 | 40.95 | 40.95 |
| Depreciation | 35.2 | 38.9 | 50.8 | 64.2 | 68.4 | 63.8 | 72.5 | 82.4 | 93.7 | 106.6 |
| Depreciation, % | 6.27 | 6.44 | 5.21 | 7.28 | 8.13 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 |
| EBIT | 256.6 | 261.2 | 423.3 | 257.3 | 83.0 | 328.0 | 372.9 | 423.9 | 482.0 | 548.0 |
| EBIT, % | 45.63 | 43.31 | 43.43 | 29.18 | 9.87 | 34.28 | 34.28 | 34.28 | 34.28 | 34.28 |
| Total Cash | 321.5 | 333.5 | 378.9 | 338.2 | 340.3 | 440.3 | 500.6 | 569.2 | 647.1 | 735.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 74.1 | 84.5 | 123.9 | 99.3 | 109.1 | 122.7 | 139.5 | 158.6 | 180.3 | 205.0 |
| Account Receivables, % | 13.18 | 14.01 | 12.71 | 11.26 | 12.96 | 12.82 | 12.82 | 12.82 | 12.82 | 12.82 |
| Inventories | .0 | .0 | .0 | 250.9 | .0 | 54.5 | 61.9 | 70.4 | 80.0 | 91.0 |
| Inventories, % | -0.00284566 | -0.000497326044 | 0.000000103 | 28.46 | 0 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 |
| Accounts Payable | 23.3 | 25.4 | 48.5 | 33.2 | 38.8 | 41.5 | 47.2 | 53.7 | 61.0 | 69.4 |
| Accounts Payable, % | 4.15 | 4.2 | 4.98 | 3.77 | 4.61 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
| Capital Expenditure | -7.6 | -1.0 | -5.8 | -6.6 | -8.8 | -7.5 | -8.5 | -9.7 | -11.0 | -12.5 |
| Capital Expenditure, % | -1.34 | -0.1729 | -0.59897 | -0.7465 | -1.05 | -0.78206 | -0.78206 | -0.78206 | -0.78206 | -0.78206 |
| Tax Rate, % | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 |
| EBITAT | 174.4 | 191.2 | 249.1 | 184.5 | 58.1 | 224.2 | 254.9 | 289.8 | 329.5 | 374.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 151.3 | 220.7 | 277.8 | .5 | 364.5 | 215.2 | 300.3 | 341.4 | 388.2 | 441.3 |
| WACC, % | 8.03 | 8.27 | 7.6 | 8.21 | 8.13 | 8.05 | 8.05 | 8.05 | 8.05 | 8.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,311.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 450 | |||||||||
| Terminal Value | 7,443 | |||||||||
| Present Terminal Value | 5,054 | |||||||||
| Enterprise Value | 6,366 | |||||||||
| Net Debt | 1,835 | |||||||||
| Equity Value | 4,531 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | 614.33 |
What You Will Receive
- Flexible Forecast Inputs: Effortlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Virtus Investment Partners, Inc.'s (VRTS) financial information pre-loaded to streamline your analysis.
- Instant DCF Outputs: The template automatically computes Net Present Value (NPV) and intrinsic value for your convenience.
- Tailored and Professional: A refined Excel model that can be customized to suit your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Investment Metrics: Adjust essential inputs such as asset allocation, risk tolerance, and expected returns.
- Real-Time Performance Analytics: Provides instant insights into portfolio performance and risk assessment.
- Institutional-Grade Precision: Leverages Virtus Investment Partners' robust financial data for reliable investment evaluations.
- Effortless Scenario Simulation: Explore various market conditions and assess potential impacts on investment strategies.
- Efficiency-Boosting Solution: Streamline the investment analysis process without starting from the ground up.
How It Works
- Step 1: Download the Excel file for Virtus Investment Partners, Inc. (VRTS).
- Step 2: Review pre-entered data on Virtus (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: Observe automatic recalculations for Virtus’s intrinsic value.
- Step 5: Utilize the outputs for investment decisions or reporting.
Why Choose This Calculator for Virtus Investment Partners, Inc. (VRTS)?
- All-in-One Solution: Integrates DCF, WACC, and financial ratio analyses seamlessly.
- Flexible Inputs: Modify the highlighted cells to explore different investment scenarios.
- In-Depth Analysis: Automatically computes Virtus Investment Partners' intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for reliable analysis.
- Expert Level: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Finance Students: Explore investment strategies and apply them using real market data for Virtus Investment Partners, Inc. (VRTS).
- Academics: Integrate advanced financial models into your studies or research projects focused on investment management.
- Investors: Validate your investment hypotheses and evaluate performance metrics for Virtus Investment Partners, Inc. (VRTS).
- Analysts: Enhance your analysis process with a ready-to-use, customizable financial model tailored for Virtus Investment Partners, Inc. (VRTS).
- Small Business Owners: Understand the evaluation processes used for large investment firms like Virtus Investment Partners, Inc. (VRTS).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Virtus Investment Partners, Inc. (VRTS) 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 Virtus Investment Partners, Inc. (VRTS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.