Heidrick & Struggles International, Inc. (HSII) 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
Heidrick & Struggles International, Inc. (HSII) Bundle
Discover the true value of Heidrick & Struggles International, Inc. (HSII) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect Heidrick & Struggles International, Inc. (HSII) valuation – all within a single Excel template.
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 | 725.6 | 629.4 | 1,008.5 | 1,083.6 | 1,041.2 | 1,081.7 | 1,123.7 | 1,167.4 | 1,212.8 | 1,259.9 |
Revenue Growth, % | 0 | -13.26 | 60.24 | 7.45 | -3.91 | 3.89 | 3.89 | 3.89 | 3.89 | 3.89 |
EBITDA | 78.0 | 161.8 | 125.6 | 122.9 | 102.7 | 151.7 | 157.6 | 163.7 | 170.1 | 176.7 |
EBITDA, % | 10.75 | 25.71 | 12.45 | 11.34 | 9.86 | 14.02 | 14.02 | 14.02 | 14.02 | 14.02 |
Depreciation | 10.4 | 26.7 | 19.6 | 10.6 | 18.5 | 22.4 | 23.3 | 24.2 | 25.1 | 26.1 |
Depreciation, % | 1.43 | 4.24 | 1.94 | 0.97851 | 1.78 | 2.07 | 2.07 | 2.07 | 2.07 | 2.07 |
EBIT | 67.6 | 135.2 | 106.0 | 112.3 | 84.2 | 129.3 | 134.3 | 139.5 | 144.9 | 150.6 |
EBIT, % | 9.32 | 21.47 | 10.51 | 10.36 | 8.08 | 11.95 | 11.95 | 11.95 | 11.95 | 11.95 |
Total Cash | 332.9 | 336.5 | 545.2 | 621.6 | 478.2 | 555.3 | 576.9 | 599.3 | 622.6 | 646.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 135.8 | 113.6 | 173.9 | 172.7 | 175.6 | 187.8 | 195.1 | 202.7 | 210.6 | 218.8 |
Account Receivables, % | 18.72 | 18.05 | 17.24 | 15.94 | 16.87 | 17.36 | 17.36 | 17.36 | 17.36 | 17.36 |
Inventories | 20.2 | 19.0 | 21.8 | 24.1 | .0 | 22.0 | 22.9 | 23.8 | 24.7 | 25.6 |
Inventories, % | 2.78 | 3.01 | 2.16 | 2.22 | 0 | 2.03 | 2.03 | 2.03 | 2.03 | 2.03 |
Accounts Payable | 8.6 | 8.8 | 20.4 | 14.6 | 20.8 | 17.2 | 17.9 | 18.6 | 19.3 | 20.1 |
Accounts Payable, % | 1.19 | 1.4 | 2.02 | 1.35 | 2 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 |
Capital Expenditure | -3.4 | -7.3 | -6.2 | -11.1 | -13.4 | -9.9 | -10.3 | -10.7 | -11.1 | -11.5 |
Capital Expenditure, % | -0.46195 | -1.16 | -0.61876 | -1.03 | -1.29 | -0.91236 | -0.91236 | -0.91236 | -0.91236 | -0.91236 |
Tax Rate, % | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 |
EBITAT | 45.8 | 162.3 | 72.6 | 77.4 | 51.6 | 94.7 | 98.4 | 102.2 | 106.2 | 110.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -94.6 | 205.2 | 34.4 | 70.0 | 84.1 | 69.5 | 104.0 | 108.0 | 112.2 | 116.6 |
WACC, % | 7.9 | 8.04 | 7.91 | 7.91 | 7.88 | 7.93 | 7.93 | 7.93 | 7.93 | 7.93 |
PV UFCF | ||||||||||
SUM PV UFCF | 401.8 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 117 | |||||||||
Terminal Value | 1,577 | |||||||||
Present Terminal Value | 1,077 | |||||||||
Enterprise Value | 1,479 | |||||||||
Net Debt | -313 | |||||||||
Equity Value | 1,792 | |||||||||
Diluted Shares Outstanding, MM | 21 | |||||||||
Equity Value Per Share | 86.28 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled financial data for Heidrick & Struggles International, Inc. (HSII).
- Comprehensive Data: Access to historical figures and forward-looking projections (as indicated in the highlighted cells).
- Assumption Flexibility: Modify forecast inputs such as revenue growth, EBITDA margin, and WACC.
- Instant Calculations: Quickly observe how your adjustments affect Heidrick & Struggles' valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and efficiency, complete with easy-to-follow instructions.
Key Features
- 🔍 Real-Life HSII Financials: Pre-filled historical and projected data for Heidrick & Struggles International, Inc. (HSII).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Heidrick & Struggles' intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Heidrick & Struggles' valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-built Excel file containing Heidrick & Struggles International, Inc.'s (HSII) financial data.
- Customize: Modify projections, such as 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 results.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose Heidrick & Struggles International, Inc. (HSII)?
- Expertise You Can Trust: Benefit from decades of experience in executive search and consulting.
- Global Reach: Access a vast network of professionals and insights across various industries.
- Tailored Solutions: Customized strategies that align with your unique organizational needs.
- Data-Driven Insights: Leverage advanced analytics to inform your leadership decisions.
- Commitment to Diversity: Focused on fostering inclusive leadership and diverse talent pipelines.
Who Should Use Heidrick & Struggles International, Inc. (HSII)?
- Corporate Leaders: Leverage expert insights to make strategic leadership decisions.
- Talent Acquisition Professionals: Streamline your recruitment process with tailored solutions for finding top talent.
- Consultants: Utilize our resources to enhance client engagements and provide impactful recommendations.
- Business Students: Gain practical knowledge of executive search and leadership consulting through real-world case studies.
- Investors: Analyze market trends and company performance to inform investment strategies.
What the Template Contains
- Historical Data: Includes Heidrick & Struggles International, Inc.'s (HSII) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Heidrick & Struggles International, Inc.'s (HSII) 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 Heidrick & Struggles International, Inc.'s (HSII) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.