Goosehead Insurance, Inc (GSHD) DCF Valuation
- ✓ 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
Goosehead Insurance, Inc (GSHD) Bundle
Explore Goosehead Insurance, Inc's (GSHD) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Goosehead Insurance, Inc's (GSHD) intrinsic value and shape your investment approach.
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 | 77.5 | 117.0 | 151.3 | 209.4 | 261.3 | 355.0 | 482.3 | 655.4 | 890.5 | 1,209.9 |
| Revenue Growth, % | 0 | 51.01 | 29.31 | 38.38 | 24.78 | 35.87 | 35.87 | 35.87 | 35.87 | 35.87 |
| EBITDA | 16.0 | 23.1 | 13.5 | 17.0 | 45.8 | 53.3 | 72.4 | 98.3 | 133.6 | 181.5 |
| EBITDA, % | 20.65 | 19.73 | 8.95 | 8.12 | 17.54 | 15 | 15 | 15 | 15 | 15 |
| Depreciation | 1.9 | 3.6 | 5.1 | 7.1 | 9.5 | 11.3 | 15.4 | 20.9 | 28.4 | 38.6 |
| Depreciation, % | 2.49 | 3.05 | 3.38 | 3.4 | 3.62 | 3.19 | 3.19 | 3.19 | 3.19 | 3.19 |
| EBIT | 14.1 | 19.5 | 8.4 | 9.9 | 36.4 | 41.9 | 57.0 | 77.4 | 105.2 | 142.9 |
| EBIT, % | 18.16 | 16.68 | 5.57 | 4.73 | 13.92 | 11.81 | 11.81 | 11.81 | 11.81 | 11.81 |
| Total Cash | 14.3 | 24.9 | 28.5 | 28.7 | 42.0 | 62.8 | 85.3 | 115.9 | 157.5 | 214.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 20.5 | 38.9 | 41.7 | 43.2 | 31.9 | 85.3 | 115.9 | 157.4 | 213.9 | 290.6 |
| Account Receivables, % | 26.46 | 33.23 | 27.58 | 20.63 | 12.21 | 24.02 | 24.02 | 24.02 | 24.02 | 24.02 |
| Inventories | 35.8 | 65.1 | .0 | -10.9 | .0 | 68.6 | 93.2 | 126.6 | 172.0 | 233.7 |
| Inventories, % | 46.15 | 55.65 | 0.000000661 | -5.21 | 0 | 19.32 | 19.32 | 19.32 | 19.32 | 19.32 |
| Accounts Payable | 6.0 | 9.4 | 14.9 | 17.6 | 16.4 | 28.6 | 38.9 | 52.8 | 71.8 | 97.5 |
| Accounts Payable, % | 7.69 | 8.05 | 9.88 | 8.41 | 6.28 | 8.06 | 8.06 | 8.06 | 8.06 | 8.06 |
| Capital Expenditure | -4.1 | -10.4 | -15.4 | -12.6 | -19.1 | -26.7 | -36.3 | -49.3 | -67.0 | -91.1 |
| Capital Expenditure, % | -5.29 | -8.86 | -10.18 | -6.02 | -7.29 | -7.53 | -7.53 | -7.53 | -7.53 | -7.53 |
| Tax Rate, % | 46.42 | 46.42 | 46.42 | 46.42 | 46.42 | 46.42 | 46.42 | 46.42 | 46.42 | 46.42 |
| EBITAT | 12.5 | 20.7 | 11.6 | 5.1 | 19.5 | 33.0 | 44.9 | 61.0 | 82.8 | 112.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -40.0 | -30.4 | 69.2 | 11.7 | 9.1 | -92.1 | -21.0 | -28.5 | -38.8 | -52.7 |
| WACC, % | 10.47 | 10.49 | 10.49 | 10.41 | 10.41 | 10.45 | 10.45 | 10.45 | 10.45 | 10.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -179.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -54 | |||||||||
| Terminal Value | -636 | |||||||||
| Present Terminal Value | -387 | |||||||||
| Enterprise Value | -567 | |||||||||
| Net Debt | 101 | |||||||||
| Equity Value | -668 | |||||||||
| Diluted Shares Outstanding, MM | 38 | |||||||||
| Equity Value Per Share | -17.41 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GSHD financials.
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Goosehead's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Data: Goosehead Insurance’s historical financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Goosehead Insurance’s intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard charts present valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based GSHD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Goosehead Insurance’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Goosehead Insurance, Inc (GSHD)?
- Accurate Data: Utilize real Goosehead Insurance financials for trustworthy valuation outcomes.
- Customizable: Tailor essential 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 the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the insurance sector.
- User-Friendly: An intuitive design and clear step-by-step guidance make it accessible for everyone.
Who Should Use This Product?
- Insurance Professionals: Develop comprehensive and reliable models for insurance policy analysis.
- Corporate Finance Teams: Evaluate insurance market scenarios to inform strategic decisions.
- Consultants and Advisors: Offer clients precise valuation insights for Goosehead Insurance (GSHD) stock.
- Students and Educators: Utilize real-world data to practice and teach financial modeling in the insurance sector.
- Finance Enthusiasts: Gain an understanding of how insurance companies like Goosehead are valued in the marketplace.
What the Template Contains
- Preloaded GSHD 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.