Hilltop Holdings Inc. (HTH) 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
Hilltop Holdings Inc. (HTH) Bundle
Evaluate Hilltop Holdings Inc.'s (HTH) financial outlook like an expert! This (HTH) DCF Calculator provides you with pre-filled financial data and the full 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 | 1,647.3 | 2,114.6 | 1,833.3 | 700.3 | 1,177.4 | 1,240.4 | 1,306.7 | 1,376.6 | 1,450.2 | 1,527.8 |
Revenue Growth, % | 0 | 28.37 | -13.31 | -61.8 | 68.13 | 5.35 | 5.35 | 5.35 | 5.35 | 5.35 |
EBITDA | .0 | 431.3 | 386.1 | .0 | .0 | 102.8 | 108.3 | 114.1 | 120.2 | 126.7 |
EBITDA, % | 0 | 20.39 | 21.06 | 0 | 0 | 8.29 | 8.29 | 8.29 | 8.29 | 8.29 |
Depreciation | 34.9 | 34.2 | 33.5 | 30.8 | .0 | 24.7 | 26.0 | 27.4 | 28.9 | 30.4 |
Depreciation, % | 2.12 | 1.62 | 1.83 | 4.39 | 0 | 1.99 | 1.99 | 1.99 | 1.99 | 1.99 |
EBIT | -34.9 | 397.1 | 352.6 | -30.8 | .0 | 78.1 | 82.3 | 86.7 | 91.4 | 96.3 |
EBIT, % | -2.12 | 18.78 | 19.23 | -4.39 | 0 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 |
Total Cash | 1,483.4 | 2,524.8 | 4,953.7 | 9,672.2 | 1,858.7 | 1,215.7 | 1,280.7 | 1,349.2 | 1,421.3 | 1,497.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | -3,138.5 | -3,553.9 | -5,487.3 | -4,599.4 | .0 | -992.3 | -1,045.4 | -1,101.3 | -1,160.2 | -1,222.2 |
Inventories, % | -190.52 | -168.06 | -299.32 | -656.76 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 1,605.5 | 1,368.4 | 1,477.3 | 966.5 | 1,430.7 | 1,098.4 | 1,157.1 | 1,219.0 | 1,284.2 | 1,352.9 |
Accounts Payable, % | 97.46 | 64.71 | 80.58 | 138 | 121.51 | 88.55 | 88.55 | 88.55 | 88.55 | 88.55 |
Capital Expenditure | -42.3 | -37.7 | -24.8 | -9.8 | -8.5 | -19.4 | -20.4 | -21.5 | -22.7 | -23.9 |
Capital Expenditure, % | -2.57 | -1.78 | -1.35 | -1.4 | -0.72089 | -1.56 | -1.56 | -1.56 | -1.56 | -1.56 |
Tax Rate, % | 26.47 | 26.47 | 26.47 | 26.47 | 26.47 | 26.47 | 26.47 | 26.47 | 26.47 | 26.47 |
EBITAT | -26.2 | 315.1 | 262.0 | -22.3 | .0 | 58.6 | 61.7 | 65.0 | 68.5 | 72.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 4,710.5 | 489.8 | 2,313.0 | -1,400.0 | -4,143.6 | 723.8 | 179.1 | 188.6 | 198.7 | 209.4 |
WACC, % | 18.27 | 18.9 | 18.16 | 17.89 | 18.05 | 18.25 | 18.25 | 18.25 | 18.25 | 18.25 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,046.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 214 | |||||||||
Terminal Value | 1,314 | |||||||||
Present Terminal Value | 568 | |||||||||
Enterprise Value | 1,614 | |||||||||
Net Debt | -1,202 | |||||||||
Equity Value | 2,817 | |||||||||
Diluted Shares Outstanding, MM | 65 | |||||||||
Equity Value Per Share | 43.30 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to develop various scenarios.
- Real-World Data: Hilltop Holdings Inc. (HTH) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to fit your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Hilltop Holdings Inc. (HTH).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable inputs specific to HTH.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Hilltop Holdings Inc. (HTH) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Hilltop Holdings Inc. (HTH).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of HTH.
How It Works
- 1. Access the Template: Download and open the Excel file containing Hilltop Holdings Inc.'s (HTH) financial data.
- 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation findings to enhance your decision-making process.
Why Choose This Calculator for Hilltop Holdings Inc. (HTH)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and investment consultants.
- Accurate Financial Data: Hilltop Holdings’ historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Hilltop Holdings Inc. (HTH)?
- Institutional Investors: Develop comprehensive and trustworthy valuation models for investment portfolios.
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decision-making.
- Financial Consultants: Deliver precise valuation assessments for clients interested in Hilltop Holdings Inc. (HTH).
- Academic Scholars: Leverage real-time data to enhance learning and teaching in financial analysis.
- Finance Enthusiasts: Gain insights into how financial institutions like Hilltop Holdings Inc. (HTH) are valued in the market.
What the Template Contains
- Historical Data: Includes Hilltop Holdings Inc.'s (HTH) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Hilltop Holdings Inc.'s (HTH) 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 Hilltop Holdings Inc.'s (HTH) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.