Select Medical Holdings Corporation (SEM) DCF Valuation

Select Medical Holdings Corporation (SEM) DCF Valuation

US | Healthcare | Medical - Care Facilities | NYSE
Select Medical Holdings Corporation (SEM) 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

Select Medical Holdings Corporation (SEM) Bundle

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

TOTAL:

Enhance your investment strategies with the (SEM) DCF Calculator! Utilize genuine Select Medical financial data, adjust growth projections and expenses, and instantly observe how these changes affect the intrinsic value of (SEM).


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 5,453.9 5,531.7 6,204.5 6,333.5 6,664.1 7,012.0 7,378.2 7,763.5 8,168.9 8,595.4
Revenue Growth, % 0 1.43 12.16 2.08 5.22 5.22 5.22 5.22 5.22 5.22
EBITDA 684.5 683.3 772.7 585.3 763.6 814.2 856.7 901.4 948.5 998.0
EBITDA, % 12.55 12.35 12.45 9.24 11.46 11.61 11.61 11.61 11.61 11.61
Depreciation 212.6 205.7 202.6 205.8 208.7 242.1 254.7 268.1 282.0 296.8
Depreciation, % 3.9 3.72 3.27 3.25 3.13 3.45 3.45 3.45 3.45 3.45
EBIT 471.9 477.6 570.1 379.5 554.9 572.1 602.0 633.4 666.5 701.3
EBIT, % 8.65 8.63 9.19 5.99 8.33 8.16 8.16 8.16 8.16 8.16
Total Cash 335.9 577.1 74.3 97.9 143.0 301.2 317.0 333.5 350.9 369.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 762.7 896.8 889.3 941.3 940.3
Account Receivables, % 13.98 16.21 14.33 14.86 14.11
Inventories .0 5.7 .0 -74.9 .0 -15.1 -15.9 -16.8 -17.6 -18.6
Inventories, % 0.0000000183 0.10279 0 -1.18 0 -0.21583 -0.21583 -0.21583 -0.21583 -0.21583
Accounts Payable 145.7 177.1 233.8 186.7 174.3 213.3 224.4 236.1 248.4 261.4
Accounts Payable, % 2.67 3.2 3.77 2.95 2.62 3.04 3.04 3.04 3.04 3.04
Capital Expenditure -157.1 -146.4 -180.5 -190.4 -229.2 -208.7 -219.6 -231.1 -243.2 -255.9
Capital Expenditure, % -2.88 -2.65 -2.91 -3.01 -3.44 -2.98 -2.98 -2.98 -2.98 -2.98
Tax Rate, % 36.32 36.32 36.32 36.32 36.32 36.32 36.32 36.32 36.32 36.32
EBITAT 358.3 271.0 364.1 231.5 353.4 367.6 386.7 406.9 428.2 450.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -203.2 221.8 456.1 222.7 246.6 364.6 380.0 399.8 420.7 442.7
WACC, % 5.87 5.29 5.5 5.42 5.5 5.51 5.51 5.51 5.51 5.51
PV UFCF
SUM PV UFCF 1,705.1
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 458
Terminal Value 22,761
Present Terminal Value 17,405
Enterprise Value 19,110
Net Debt 4,876
Equity Value 14,234
Diluted Shares Outstanding, MM 123
Equity Value Per Share 115.63

What You Will Receive

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real SEM financials.
  • Accurate Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
  • Flexible Forecasting: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs affect Select Medical's valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.

Key Features

  • Real-Life SEM Data: Pre-filled with Select Medical Holdings Corporation's historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Testing: Develop multiple forecast scenarios to explore various valuation outcomes.
  • User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Select Medical Holdings Corporation’s (SEM) preloaded data.
  • 2. Modify Inputs: Adjust key variables such as growth projections, WACC, and capital expenditures.
  • 3. View Results Immediately: The DCF model automatically computes intrinsic value and NPV.
  • 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
  • 5. Present with Assurance: Deliver professional valuation insights to enhance your decision-making.

Why Choose This Calculator for Select Medical Holdings Corporation (SEM)?

  • Accurate Data: Up-to-date financial information for Select Medical ensures trustworthy valuation outcomes.
  • Customizable: Tailor essential metrics such as growth rates, WACC, and tax rates to fit your financial forecasts.
  • Time-Saving: Pre-configured calculations streamline your analysis process, saving you time.
  • Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on Select Medical Holdings Corporation (SEM).
  • User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.

Who Should Use This Product?

  • Investors: Accurately estimate Select Medical Holdings Corporation’s (SEM) fair value before making investment decisions.
  • CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Select Medical Holdings Corporation (SEM).
  • Consultants: Quickly adapt the template for valuation reports for clients focused on Select Medical Holdings Corporation (SEM).
  • Entrepreneurs: Gain insights into financial modeling used by leading healthcare companies like Select Medical Holdings Corporation (SEM).
  • Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to Select Medical Holdings Corporation (SEM).

What the Template Contains

  • Pre-Filled DCF Model: Select Medical Holdings Corporation’s (SEM) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Select Medical Holdings Corporation’s (SEM) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.