PJT Partners Inc. (PJT) 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
PJT Partners Inc. (PJT) Bundle
Gain insight into your PJT Partners Inc. (PJT) valuation analysis with our state-of-the-art DCF Calculator! This Excel template comes preloaded with real PJT data, enabling you to adjust forecasts and assumptions to determine PJT's intrinsic value accurately.
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 | 717.6 | 1,052.3 | 991.9 | 1,025.5 | 1,153.2 | 1,316.7 | 1,503.5 | 1,716.7 | 1,960.2 | 2,238.2 |
Revenue Growth, % | 0 | 46.63 | -5.74 | 3.38 | 12.45 | 14.18 | 14.18 | 14.18 | 14.18 | 14.18 |
EBITDA | 123.1 | 289.6 | 262.9 | 251.8 | 214.3 | 301.0 | 343.7 | 392.5 | 448.1 | 511.7 |
EBITDA, % | 17.15 | 27.52 | 26.5 | 24.56 | 18.58 | 22.86 | 22.86 | 22.86 | 22.86 | 22.86 |
Depreciation | 635.4 | 804.3 | 772.5 | 824.0 | 36.7 | 859.5 | 981.5 | 1,120.7 | 1,279.6 | 1,461.1 |
Depreciation, % | 88.55 | 76.44 | 77.88 | 80.35 | 3.18 | 65.28 | 65.28 | 65.28 | 65.28 | 65.28 |
EBIT | -512.4 | -514.7 | -509.6 | -572.2 | 177.6 | -558.5 | -637.7 | -728.2 | -831.5 | -949.4 |
EBIT, % | -71.4 | -48.92 | -51.38 | -55.8 | 15.4 | -42.42 | -42.42 | -42.42 | -42.42 | -42.42 |
Total Cash | 216.0 | 299.5 | 200.5 | 173.2 | 355.5 | 333.1 | 380.4 | 434.3 | 495.9 | 566.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 227.5 | 233.2 | 289.3 | 317.8 | 263.5 | 360.4 | 411.5 | 469.9 | 536.5 | 612.6 |
Account Receivables, % | 31.7 | 22.16 | 29.16 | 30.98 | 22.85 | 27.37 | 27.37 | 27.37 | 27.37 | 27.37 |
Inventories | 445.0 | 670.6 | .0 | 541.2 | .0 | 470.1 | 536.8 | 612.9 | 699.8 | 799.1 |
Inventories, % | 62.01 | 63.72 | 0 | 52.78 | 0 | 35.7 | 35.7 | 35.7 | 35.7 | 35.7 |
Accounts Payable | 24.8 | 25.9 | 23.8 | 24.8 | 22.3 | 33.3 | 38.1 | 43.5 | 49.6 | 56.7 |
Accounts Payable, % | 3.45 | 2.47 | 2.39 | 2.42 | 1.93 | 2.53 | 2.53 | 2.53 | 2.53 | 2.53 |
Capital Expenditure | -8.8 | -8.9 | -6.5 | -3.4 | -3.9 | -8.9 | -10.2 | -11.7 | -13.3 | -15.2 |
Capital Expenditure, % | -1.23 | -0.8414 | -0.65246 | -0.33486 | -0.34054 | -0.6794 | -0.6794 | -0.6794 | -0.6794 | -0.6794 |
Tax Rate, % | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 | 53.94 |
EBITAT | -397.7 | -441.0 | -441.1 | -468.0 | 81.8 | -421.9 | -481.7 | -550.0 | -628.1 | -717.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -418.8 | 124.5 | 937.2 | -216.1 | 707.5 | -127.2 | 376.5 | 429.9 | 490.8 | 560.4 |
WACC, % | 7.11 | 7.13 | 7.13 | 7.12 | 7.04 | 7.11 | 7.11 | 7.11 | 7.11 | 7.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,329.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 572 | |||||||||
Terminal Value | 11,195 | |||||||||
Present Terminal Value | 7,942 | |||||||||
Enterprise Value | 9,272 | |||||||||
Net Debt | -25 | |||||||||
Equity Value | 9,297 | |||||||||
Diluted Shares Outstanding, MM | 42 | |||||||||
Equity Value Per Share | 221.98 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real PJT financials.
- Authentic Data: Historical figures and future projections (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs influence PJT’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Layout: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Model: Offers detailed unlevered and levered DCF valuation frameworks tailored for PJT Partners Inc. (PJT).
- Customizable WACC Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Flexible Forecast Inputs: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to PJT Partners Inc. (PJT).
- Interactive Dashboard and Visuals: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the comprehensive Excel file featuring PJT Partners Inc. (PJT) financial data.
- Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC for PJT.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment approach for PJT.
Why Choose PJT Partners Inc. (PJT) Calculator?
- Accuracy: Utilizes real PJT financial data for precise calculations.
- Flexibility: Tailored for users to easily adjust and experiment with inputs.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use PJT Partners Inc. (PJT)?
- Investors: Assess the intrinsic value of PJT Partners Inc. (PJT) to inform investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and strategic analysis.
- Consultants: Efficiently customize the template for client valuation reports related to PJT Partners Inc. (PJT).
- Entrepreneurs: Discover financial modeling techniques employed by leading advisory firms.
- Educators: Implement it as a resource for teaching valuation principles in finance courses.
What the Template Contains
- Historical Data: Includes PJT Partners Inc.'s (PJT) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate PJT Partners Inc.'s (PJT) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of PJT Partners Inc.'s (PJT) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.