|
Huron Consulting Group Inc. (HURN) DCF Valuation
US | Industrials | Consulting Services | 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
Huron Consulting Group Inc. (HURN) Bundle
Evaluate Huron Consulting Group Inc.'s (HURN) financial outlook like an expert! This (HURN) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential 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 | 965.5 | 871.0 | 927.0 | 1,159.0 | 1,398.8 | 1,546.9 | 1,710.7 | 1,891.8 | 2,092.2 | 2,313.7 |
| Revenue Growth, % | 0 | -9.78 | 6.42 | 25.03 | 20.69 | 10.59 | 10.59 | 10.59 | 10.59 | 10.59 |
| EBITDA | 101.9 | 12.8 | 120.6 | 154.2 | 161.8 | 154.4 | 170.8 | 188.9 | 208.9 | 231.0 |
| EBITDA, % | 10.55 | 1.47 | 13.01 | 13.3 | 11.57 | 9.98 | 9.98 | 9.98 | 9.98 | 9.98 |
| Depreciation | 33.7 | 37.4 | 32.5 | 33.7 | 31.2 | 50.8 | 56.2 | 62.2 | 68.8 | 76.0 |
| Depreciation, % | 3.49 | 4.29 | 3.5 | 2.91 | 2.23 | 3.29 | 3.29 | 3.29 | 3.29 | 3.29 |
| EBIT | 68.1 | -24.6 | 88.2 | 120.5 | 130.6 | 103.6 | 114.5 | 126.7 | 140.1 | 154.9 |
| EBIT, % | 7.06 | -2.82 | 9.51 | 10.39 | 9.34 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
| Total Cash | 11.6 | 67.2 | 20.8 | 11.8 | 12.1 | 40.4 | 44.6 | 49.4 | 54.6 | 60.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 198.9 | 141.6 | 221.7 | 290.6 | 359.8 | 345.2 | 381.7 | 422.2 | 466.9 | 516.3 |
| Account Receivables, % | 20.6 | 16.26 | 23.91 | 25.07 | 25.72 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 |
| Inventories | .0 | .0 | .0 | -7.1 | .0 | -1.9 | -2.1 | -2.3 | -2.6 | -2.8 |
| Inventories, % | 0.000000104 | 0 | 0 | -0.61331 | 0 | -0.12266 | -0.12266 | -0.12266 | -0.12266 | -0.12266 |
| Accounts Payable | 7.9 | .6 | 13.6 | 14.3 | 10.1 | 13.4 | 14.8 | 16.3 | 18.1 | 20.0 |
| Accounts Payable, % | 0.82281 | 0.07439605 | 1.47 | 1.23 | 0.72021 | 0.86335 | 0.86335 | 0.86335 | 0.86335 | 0.86335 |
| Capital Expenditure | -23.6 | -16.4 | -15.8 | -24.3 | -35.2 | -32.9 | -36.4 | -40.2 | -44.5 | -49.2 |
| Capital Expenditure, % | -2.44 | -1.88 | -1.7 | -2.1 | -2.52 | -2.13 | -2.13 | -2.13 | -2.13 | -2.13 |
| Tax Rate, % | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 |
| EBITAT | 54.2 | -17.2 | 69.4 | 83.8 | 97.3 | 77.1 | 85.3 | 94.3 | 104.3 | 115.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -126.6 | 53.7 | 19.0 | 32.1 | 12.8 | 114.9 | 70.2 | 77.6 | 85.8 | 94.9 |
| WACC, % | 6.86 | 6.8 | 6.86 | 6.79 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 366.9 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 98 | |||||||||
| Terminal Value | 2,953 | |||||||||
| Present Terminal Value | 2,123 | |||||||||
| Enterprise Value | 2,489 | |||||||||
| Net Debt | 362 | |||||||||
| Equity Value | 2,128 | |||||||||
| Diluted Shares Outstanding, MM | 20 | |||||||||
| Equity Value Per Share | 108.55 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-loaded financial data for Huron Consulting Group Inc. (HURN).
- Accurate Data: Access to historical figures and projected estimates (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth, EBITDA margin, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Huron’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as project costs, revenue projections, and operating margins.
- Instant DCF Valuation: Provides real-time calculations for intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Huron Consulting Group's actual financial data for dependable valuation results.
- Simplified Scenario Testing: Easily evaluate various assumptions and assess their impacts on outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the necessity to construct intricate models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Huron Consulting Group Inc. (HURN) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Huron Consulting Group Inc. (HURN)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- Accurate Data: Up-to-date Huron Consulting Group Inc. (HURN) financials ensure reliable valuation results.
- Customizable: Tailor key parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the consulting sector.
- User-Friendly: Easy-to-navigate layout and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Huron Consulting Group Inc.’s (HURN) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading consulting firms.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Preloaded HURN 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.