Grosvenor Capital Management, L.P. (GCMG) 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
Grosvenor Capital Management, L.P. (GCMG) Bundle
Evaluate Grosvenor Capital Management, L.P.'s financial outlook like an expert! This (GCMG) DCF Calculator provides pre-filled financial data and allows you to easily 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 | 416.4 | 430.0 | 531.6 | 446.5 | 445.0 | 456.7 | 468.8 | 481.1 | 493.8 | 506.9 |
Revenue Growth, % | 0 | 3.26 | 23.63 | -16 | -0.34287 | 2.64 | 2.64 | 2.64 | 2.64 | 2.64 |
EBITDA | 95.3 | -45.4 | 113.4 | 84.2 | -9.2 | 46.1 | 47.3 | 48.6 | 49.8 | 51.1 |
EBITDA, % | 22.89 | -10.57 | 21.34 | 18.85 | -2.06 | 10.09 | 10.09 | 10.09 | 10.09 | 10.09 |
Depreciation | 336.8 | 495.0 | 412.4 | 340.2 | 2.7 | 306.3 | 314.3 | 322.6 | 331.1 | 339.9 |
Depreciation, % | 80.9 | 115.12 | 77.58 | 76.19 | 0.60584 | 67.05 | 67.05 | 67.05 | 67.05 | 67.05 |
EBIT | -241.5 | -540.4 | -299.0 | -256.0 | -11.8 | -250.5 | -257.1 | -263.9 | -270.9 | -278.0 |
EBIT, % | -58.01 | -125.68 | -56.24 | -57.34 | -2.66 | -54.85 | -54.85 | -54.85 | -54.85 | -54.85 |
Total Cash | 79.9 | 198.1 | 96.2 | 85.2 | 44.4 | 102.7 | 105.4 | 108.2 | 111.0 | 113.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 44.9 | 95.3 | 125.1 | 48.3 | 65.9 | 75.0 | 77.0 | 79.0 | 81.1 | 83.2 |
Account Receivables, % | 10.78 | 22.16 | 23.53 | 10.82 | 14.82 | 16.42 | 16.42 | 16.42 | 16.42 | 16.42 |
Inventories | -10.2 | .0 | -2.7 | 224.0 | .0 | 43.1 | 44.2 | 45.4 | 46.6 | 47.8 |
Inventories, % | -2.46 | 0 | -0.50697 | 50.16 | 0 | 9.44 | 9.44 | 9.44 | 9.44 | 9.44 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -4.0 | -1.3 | -.6 | -.8 | -3.8 | -2.2 | -2.2 | -2.3 | -2.4 | -2.4 |
Capital Expenditure, % | -0.95943 | -0.3042 | -0.10854 | -0.17513 | -0.84562 | -0.47858 | -0.47858 | -0.47858 | -0.47858 | -0.47858 |
Tax Rate, % | 159.38 | 159.38 | 159.38 | 159.38 | 159.38 | 159.38 | 159.38 | 159.38 | 159.38 | 159.38 |
EBITAT | -232.6 | -579.0 | -277.5 | -228.4 | 7.0 | -189.5 | -194.5 | -199.7 | -204.9 | -210.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 65.6 | -145.9 | 107.2 | -38.9 | 212.3 | 62.4 | 114.4 | 117.4 | 120.5 | 123.7 |
WACC, % | 6.75 | 6.79 | 6.72 | 6.69 | 5.91 | 6.57 | 6.57 | 6.57 | 6.57 | 6.57 |
PV UFCF | ||||||||||
SUM PV UFCF | 439.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 126 | |||||||||
Terminal Value | 2,759 | |||||||||
Present Terminal Value | 2,007 | |||||||||
Enterprise Value | 2,446 | |||||||||
Net Debt | 382 | |||||||||
Equity Value | 2,065 | |||||||||
Diluted Shares Outstanding, MM | 187 | |||||||||
Equity Value Per Share | 11.02 |
What You Will Receive
- Comprehensive Financial Model: GCMG’s actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates provide immediate insights as you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for expert-level valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive Data Access: GCMG’s extensive historical performance metrics and market analysis.
- Customizable Parameters: Adjust investment strategies, risk assessments, and return projections.
- Real-Time Analytics: Monitor GCMG’s asset valuations and market trends instantly.
- Intuitive Visualizations: Interactive dashboards showcase investment performance and critical indicators.
- Designed for Professionals: A robust platform tailored for asset managers, investors, and financial analysts.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Grosvenor Capital Management's (GCMG) preloaded data.
- 2. Adjust Assumptions: Modify critical inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Assurance: Deliver expert valuation insights to guide your strategic decisions.
Why Choose Grosvenor Capital Management (GCMG)?
- Expertise: Leverage industry-leading insights for informed investment decisions.
- Customizable: Tailor investment strategies to meet individual client needs.
- Efficiency: Streamlined processes to enhance investment performance.
- Institutional Quality: Built on a foundation of institutional-grade investment practices.
- Accessible: Designed for both seasoned investors and newcomers to the market.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive investment strategies using insights from Grosvenor Capital Management, L.P. (GCMG).
- Asset Managers: Evaluate fund performance and asset allocation with GCMG's analytical tools.
- Financial Consultants: Offer clients tailored investment advice based on GCMG's market expertise.
- Students and Academics: Leverage real investment data to enhance learning in finance and investment courses.
- Market Analysts: Gain a deeper understanding of alternative investment strategies through GCMG's research.
What the Template Contains
- Preloaded GCMG 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.