SelectQuote, Inc. (SLQT) 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
SelectQuote, Inc. (SLQT) Bundle
Assess SelectQuote, Inc.'s (SLQT) financial outlook like an expert! This (SLQT) DCF Calculator provides pre-filled financial data alongside full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 531.5 | 937.8 | 764.0 | 1,002.8 | 1,321.8 | 1,721.5 | 2,242.1 | 2,920.2 | 3,803.4 | 4,953.6 |
| Revenue Growth, % | 0 | 76.44 | -18.53 | 31.26 | 31.8 | 30.24 | 30.24 | 30.24 | 30.24 | 30.24 |
| EBITDA | 139.9 | 204.3 | -320.7 | 29.9 | 89.5 | 54.7 | 71.3 | 92.8 | 120.9 | 157.4 |
| EBITDA, % | 26.32 | 21.78 | -41.97 | 2.98 | 6.77 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
| Depreciation | 8.0 | 16.2 | 24.7 | 27.9 | 25.0 | 38.4 | 49.9 | 65.1 | 84.7 | 110.4 |
| Depreciation, % | 1.5 | 1.73 | 3.24 | 2.78 | 1.89 | 2.23 | 2.23 | 2.23 | 2.23 | 2.23 |
| EBIT | 131.9 | 188.1 | -345.4 | 2.0 | 64.5 | 16.4 | 21.3 | 27.7 | 36.1 | 47.1 |
| EBIT, % | 24.82 | 20.05 | -45.2 | 0.20252 | 4.88 | 0.9501 | 0.9501 | 0.9501 | 0.9501 | 0.9501 |
| Total Cash | 321.1 | 286.5 | 141.0 | 83.2 | 42.7 | 416.4 | 542.3 | 706.3 | 919.9 | 1,198.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 134.8 | 194.5 | 246.0 | 265.7 | 270.9 | 431.4 | 561.9 | 731.8 | 953.1 | 1,241.3 |
| Account Receivables, % | 25.37 | 20.74 | 32.2 | 26.5 | 20.49 | 25.06 | 25.06 | 25.06 | 25.06 | 25.06 |
| Inventories | 47.8 | .2 | 5.8 | 5.6 | 8.8 | 37.8 | 49.3 | 64.1 | 83.5 | 108.8 |
| Inventories, % | 8.99 | 0.01876703 | 0.7531 | 0.55512 | 0.66259 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 |
| Accounts Payable | 22.9 | 34.1 | 24.8 | 27.6 | 36.6 | 57.5 | 74.9 | 97.5 | 127.0 | 165.4 |
| Accounts Payable, % | 4.31 | 3.63 | 3.24 | 2.75 | 2.77 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 |
| Capital Expenditure | -15.6 | -23.0 | -34.6 | -9.1 | -3.4 | -38.1 | -49.7 | -64.7 | -84.3 | -109.8 |
| Capital Expenditure, % | -2.93 | -2.45 | -4.53 | -0.90991 | -0.25587 | -2.22 | -2.22 | -2.22 | -2.22 | -2.22 |
| Tax Rate, % | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 | -17.41 |
| EBITAT | 98.8 | 141.6 | -263.6 | 1.7 | 75.7 | 13.4 | 17.5 | 22.8 | 29.7 | 38.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -68.5 | 134.0 | -340.0 | 3.8 | 98.0 | -155.0 | -106.7 | -139.0 | -181.0 | -235.8 |
| WACC, % | 9.63 | 9.66 | 9.73 | 10.31 | 11.39 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -601.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -241 | |||||||||
| Terminal Value | -2,953 | |||||||||
| Present Terminal Value | -1,822 | |||||||||
| Enterprise Value | -2,423 | |||||||||
| Net Debt | 671 | |||||||||
| Equity Value | -3,094 | |||||||||
| Diluted Shares Outstanding, MM | 169 | |||||||||
| Equity Value Per Share | -18.36 |
What You Will Get
- Pre-Filled Financial Model: SelectQuote’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for SelectQuote, Inc. (SLQT).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with customizable inputs specific to the insurance sector.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to reflect market conditions.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to SelectQuote, Inc. (SLQT).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing SelectQuote, Inc.'s (SLQT) preloaded data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for SelectQuote, Inc. (SLQT)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Data: SelectQuote’s historical and projected financials preloaded for reliable analysis.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions to evaluate outcomes.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth and intuitive experience.
Who Should Use SelectQuote, Inc. (SLQT)?
- Insurance Professionals: Enhance your understanding of insurance products and sales strategies.
- Financial Advisors: Integrate SelectQuote's offerings into your client solutions and portfolio management.
- Investors: Evaluate the performance and potential of SelectQuote, Inc. (SLQT) within your investment strategy.
- Market Analysts: Utilize data-driven insights to assess market trends and competitive positioning.
- Consumers: Discover how SelectQuote, Inc. (SLQT) can help you find the best insurance options tailored to your needs.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: SelectQuote, Inc.'s (SLQT) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.