SelectQuote, Inc. (SLQT) DCF Valuation

SelectQuote, Inc. (SLQT) DCF Valuation
  • Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • Predeterminadas Para Un Uso Rápido Y Eficiente
  • No Se Necesita Experiencia; Fáciles De Seguir

SelectQuote, Inc. (SLQT) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 25.37 20.74 32.2 26.5 20.49
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.