|
Perella Weinberg Partners (PWP) DCF Valuation
US | Financial Services | Financial - Capital Markets | NASDAQ
|
- ✓ 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
Perella Weinberg Partners (PWP) Bundle
Assess Perella Weinberg Partners' (PWP) financial outlook like an expert! This (PWP) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 533.3 | 519.0 | 801.7 | 631.5 | 648.7 | 702.6 | 761.1 | 824.4 | 892.9 | 967.2 |
| Revenue Growth, % | 0 | -2.68 | 54.47 | -21.23 | 2.71 | 8.32 | 8.32 | 8.32 | 8.32 | 8.32 |
| EBITDA | -130.3 | 10.4 | 62.4 | 5.5 | -97.9 | -40.6 | -43.9 | -47.6 | -51.6 | -55.9 |
| EBITDA, % | -24.44 | 2 | 7.78 | 0.87062 | -15.09 | -5.77 | -5.77 | -5.77 | -5.77 | -5.77 |
| Depreciation | 15.9 | 32.6 | 31.9 | 26.6 | 14.7 | 27.7 | 30.0 | 32.5 | 35.2 | 38.1 |
| Depreciation, % | 2.97 | 6.28 | 3.97 | 4.22 | 2.26 | 3.94 | 3.94 | 3.94 | 3.94 | 3.94 |
| EBIT | -146.2 | -22.2 | 30.6 | -21.1 | -112.5 | -68.3 | -73.9 | -80.1 | -86.8 | -94.0 |
| EBIT, % | -27.41 | -4.28 | 3.81 | -3.35 | -17.35 | -9.72 | -9.72 | -9.72 | -9.72 | -9.72 |
| Total Cash | .0 | 329.1 | 502.8 | 311.7 | 338.3 | 319.9 | 346.5 | 375.3 | 406.5 | 440.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 41.1 | 51.1 | 71.3 | 51.3 | 47.1 | 51.0 | 55.2 | 59.8 | 64.8 |
| Account Receivables, % | 0 | 7.92 | 6.38 | 11.29 | 7.92 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
| Inventories | .0 | .0 | 2.0 | 2.6 | .0 | .9 | 1.0 | 1.1 | 1.2 | 1.3 |
| Inventories, % | 0 | 0 | 0.24973 | 0.41108 | 0 | 0.13216 | 0.13216 | 0.13216 | 0.13216 | 0.13216 |
| Accounts Payable | .0 | 22.2 | 31.0 | 46.3 | 52.1 | 33.1 | 35.8 | 38.8 | 42.0 | 45.5 |
| Accounts Payable, % | 0 | 4.29 | 3.87 | 7.34 | 8.03 | 4.71 | 4.71 | 4.71 | 4.71 | 4.71 |
| Capital Expenditure | -7.4 | -5.5 | -1.5 | -26.6 | -57.6 | -22.1 | -23.9 | -25.9 | -28.1 | -30.4 |
| Capital Expenditure, % | -1.39 | -1.06 | -0.18237 | -4.21 | -8.88 | -3.14 | -3.14 | -3.14 | -3.14 | -3.14 |
| Tax Rate, % | 84.73 | 84.73 | 84.73 | 84.73 | 84.73 | 84.73 | 84.73 | 84.73 | 84.73 | 84.73 |
| EBITAT | -148.4 | -25.9 | 5.4 | -31.3 | -17.2 | -45.4 | -49.2 | -53.3 | -57.7 | -62.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -140.0 | -17.7 | 32.5 | -36.7 | -31.8 | -55.5 | -44.4 | -48.1 | -52.1 | -56.4 |
| WACC, % | 10.92 | 10.92 | 10.64 | 10.92 | 10.63 | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -189.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -58 | |||||||||
| Terminal Value | -653 | |||||||||
| Present Terminal Value | -391 | |||||||||
| Enterprise Value | -581 | |||||||||
| Net Debt | -71 | |||||||||
| Equity Value | -510 | |||||||||
| Diluted Shares Outstanding, MM | 87 | |||||||||
| Equity Value Per Share | -5.88 |
What You Will Receive
- Comprehensive Financial Model: Utilize Perella Weinberg Partners’ (PWP) actual data for accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Instantaneous updates allow you to view results as adjustments are made.
- Professional-Grade Template: An expertly crafted Excel file tailored for high-quality valuation.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Perella Weinberg Partners (PWP).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Update growth rates, capital expenditures, and discount rates as per your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Perella Weinberg Partners (PWP).
- Visual Dashboard and Charts: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-configured Excel file featuring Perella Weinberg Partners' (PWP) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose Perella Weinberg Partners (PWP)?
- Expertise: Leverage insights from a team of seasoned financial professionals.
- Customization: Tailored solutions to meet diverse client needs and objectives.
- Efficiency: Streamlined processes to deliver timely and effective results.
- Institutional Quality: Services designed to meet the highest standards of the financial industry.
- Accessibility: Intuitive tools and resources for clients at all levels of financial acumen.
Who Should Use This Product?
- Investors: Effectively assess Perella Weinberg Partners’ (PWP) market position prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis related to PWP.
- Consultants: Efficiently modify the template for client valuation reports involving PWP.
- Entrepreneurs: Acquire knowledge of financial modeling practices adopted by leading firms like PWP.
- Educators: Implement it as a resource to illustrate valuation techniques in the context of PWP.
What the Template Contains
- Pre-Filled Data: Contains Perella Weinberg Partners’ (PWP) historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automatic computations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate PWP’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.