|
BrightSphere Investment Group Inc. (BSIG) DCF Valuation
US | Financial Services | Asset Management | NYSE
|
- ✓ 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
BrightSphere Investment Group Inc. (BSIG) Bundle
Explore the financial outlook of BrightSphere Investment Group Inc. (BSIG) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of BrightSphere Investment Group Inc. (BSIG) and enhance your investment approach.
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 | 819.5 | 718.5 | 523.8 | 417.2 | 426.6 | 365.3 | 312.7 | 267.8 | 229.3 | 196.3 |
| Revenue Growth, % | 0 | -12.32 | -27.1 | -20.35 | 2.25 | -14.38 | -14.38 | -14.38 | -14.38 | -14.38 |
| EBITDA | 247.8 | 179.4 | 173.0 | 187.8 | 132.9 | 120.1 | 102.8 | 88.0 | 75.4 | 64.5 |
| EBITDA, % | 30.24 | 24.97 | 33.03 | 45.01 | 31.15 | 32.88 | 32.88 | 32.88 | 32.88 | 32.88 |
| Depreciation | 569.2 | 340.2 | 373.0 | 248.0 | 17.3 | 183.7 | 157.3 | 134.7 | 115.3 | 98.7 |
| Depreciation, % | 69.46 | 47.35 | 71.21 | 59.44 | 4.06 | 50.3 | 50.3 | 50.3 | 50.3 | 50.3 |
| EBIT | -321.4 | -160.8 | -200.0 | -60.2 | 115.6 | -63.6 | -54.5 | -46.7 | -39.9 | -34.2 |
| EBIT, % | -39.22 | -22.38 | -38.18 | -14.43 | 27.1 | -17.42 | -17.42 | -17.42 | -17.42 | -17.42 |
| Total Cash | 111.3 | 401.9 | 252.1 | 108.4 | 147.6 | 130.2 | 111.5 | 95.4 | 81.7 | 70.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 178.1 | 100.6 | 172.0 | 124.5 | 146.1 | 96.9 | 83.0 | 71.0 | 60.8 | 52.1 |
| Account Receivables, % | 21.73 | 14 | 32.84 | 29.84 | 34.25 | 26.53 | 26.53 | 26.53 | 26.53 | 26.53 |
| Inventories | 308.8 | -180.9 | -171.7 | .0 | .0 | -14.8 | -12.7 | -10.9 | -9.3 | -8.0 |
| Inventories, % | 37.68 | -25.18 | -32.78 | 0.00000024 | 0 | -4.06 | -4.06 | -4.06 | -4.06 | -4.06 |
| Accounts Payable | 12.9 | 6.7 | 5.0 | 5.0 | 8.8 | 4.9 | 4.2 | 3.6 | 3.1 | 2.6 |
| Accounts Payable, % | 1.57 | 0.9325 | 0.95456 | 1.2 | 2.06 | 1.34 | 1.34 | 1.34 | 1.34 | 1.34 |
| Capital Expenditure | -33.9 | -27.2 | -15.1 | -16.1 | -13.8 | -13.1 | -11.2 | -9.6 | -8.2 | -7.0 |
| Capital Expenditure, % | -4.14 | -3.79 | -2.88 | -3.86 | -3.23 | -3.58 | -3.58 | -3.58 | -3.58 | -3.58 |
| Tax Rate, % | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 |
| EBITAT | -278.9 | -107.8 | -143.9 | -41.8 | 78.8 | -46.3 | -39.6 | -33.9 | -29.0 | -24.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -217.6 | 766.2 | 131.7 | 65.9 | 64.5 | 184.5 | 117.6 | 100.7 | 86.2 | 73.8 |
| WACC, % | 9.71 | 9.45 | 9.51 | 9.48 | 9.46 | 9.52 | 9.52 | 9.52 | 9.52 | 9.52 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 450.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 75 | |||||||||
| Terminal Value | 1,001 | |||||||||
| Present Terminal Value | 635 | |||||||||
| Enterprise Value | 1,085 | |||||||||
| Net Debt | 200 | |||||||||
| Equity Value | 886 | |||||||||
| Diluted Shares Outstanding, MM | 43 | |||||||||
| Equity Value Per Share | 20.83 |
What You Will Get
- Genuine BSIG Data: Preloaded financials – encompassing revenue to EBIT – derived from actual and projected figures.
- Complete Customization: Modify all key parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalibrations to assess the impact of changes on BrightSphere Investment Group Inc.'s (BSIG) fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and comprehensive projections.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for BrightSphere Investment Group Inc. (BSIG).
- WACC Calculator: Features a pre-constructed Weighted Average Cost of Capital sheet with adjustable inputs.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for BrightSphere Investment Group Inc. (BSIG).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered BrightSphere Investment Group Inc. (BSIG) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for BrightSphere Investment Group Inc. (BSIG)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for BrightSphere Investment Group Inc. (BSIG)?
- Accurate Data: Up-to-date BrightSphere financials provide trustworthy valuation outcomes.
- Customizable: Tailor key variables such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations help you avoid starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear step-by-step guidance cater to users of all levels.
Who Should Use This Product?
- Individual Investors: Make informed decisions about investing in BrightSphere Investment Group Inc. (BSIG).
- Financial Analysts: Enhance valuation assessments with comprehensive financial models tailored for BSIG.
- Consultants: Provide clients with accurate valuation insights on BrightSphere Investment Group Inc. (BSIG) efficiently.
- Business Owners: Gain insights into the valuation of investment firms like BSIG to inform your own business strategies.
- Finance Students: Master valuation methods using real-time data and case studies involving BrightSphere Investment Group Inc. (BSIG).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for BrightSphere Investment Group Inc. (BSIG).
- Real-World Data: BrightSphere’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to evaluate various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis focusing on profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.