Sabra Health Care REIT, Inc. (SBRA) DCF Valuation

Sabra Health Care REIT, Inc. (SBRA) 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

Sabra Health Care REIT, Inc. (SBRA) 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:

Explore the financial potential of Sabra Health Care REIT, Inc. (SBRA) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Sabra Health Care REIT, Inc. (SBRA) and refine 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 661.7 598.6 569.5 624.8 647.5 645.8 644.1 642.4 640.7 639.0
Revenue Growth, % 0 -9.55 -4.85 9.7 3.63 -0.26436 -0.26436 -0.26436 -0.26436 -0.26436
EBITDA 516.9 418.0 166.2 323.4 311.8 357.8 356.9 355.9 355.0 354.0
EBITDA, % 78.11 69.83 29.18 51.75 48.15 55.4 55.4 55.4 55.4 55.4
Depreciation 341.6 370.4 358.7 375.4 183.1 342.1 341.2 340.3 339.4 338.5
Depreciation, % 51.63 61.88 62.98 60.09 28.28 52.97 52.97 52.97 52.97 52.97
EBIT 175.2 47.5 -192.5 -52.1 128.7 15.7 15.7 15.6 15.6 15.6
EBIT, % 26.48 7.94 -33.8 -8.33 19.88 2.43 2.43 2.43 2.43 2.43
Total Cash 39.1 59.1 112.0 49.3 41.3 64.2 64.0 63.9 63.7 63.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 213.5 219.5 480.1 147.9 103.3
Account Receivables, % 32.27 36.68 84.3 23.67 15.95
Inventories 59.2 72.0 119.8 411.4 .0 139.3 138.9 138.6 138.2 137.8
Inventories, % 8.94 12.02 21.03 65.84 0 21.57 21.57 21.57 21.57 21.57
Accounts Payable 75.4 72.2 143.0 142.3 73.8 106.8 106.6 106.3 106.0 105.7
Accounts Payable, % 11.39 12.06 25.11 22.77 11.4 16.54 16.54 16.54 16.54 16.54
Capital Expenditure .0 -105.6 -33.6 .0 .0 -30.4 -30.3 -30.2 -30.2 -30.1
Capital Expenditure, % 0 -17.64 -5.9 0 0 -4.71 -4.71 -4.71 -4.71 -4.71
Tax Rate, % 12.7 12.7 12.7 12.7 12.7 12.7 12.7 12.7 12.7 12.7
EBITAT 166.9 47.3 -195.7 -52.9 112.4 15.2 15.1 15.1 15.0 15.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 311.2 290.1 -108.2 362.4 683.0 74.8 326.7 325.9 325.0 324.1
WACC, % 8.03 8.11 8.12 8.12 7.89 8.05 8.05 8.05 8.05 8.05
PV UFCF
SUM PV UFCF 1,065.7
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 337
Terminal Value 8,314
Present Terminal Value 5,644
Enterprise Value 6,710
Net Debt 2,405
Equity Value 4,305
Diluted Shares Outstanding, MM 233
Equity Value Per Share 18.49

What You Will Get

  • Comprehensive SBRA Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Real-Time Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Evaluate various scenarios to assess Sabra Health Care's future performance.
  • User-Friendly Interface: Designed for industry experts while remaining approachable for newcomers.

Key Features

  • Comprehensive SBRA Data: Includes Sabra Health Care REIT's historical performance metrics and future projections.
  • Customizable Assumptions: Modify occupancy rates, rental growth, capital expenditures, and other key financial inputs.
  • Interactive Valuation Tool: Instant recalculations of Net Asset Value (NAV) and intrinsic value based on user-defined parameters.
  • Multiple Scenario Analysis: Develop various investment scenarios to evaluate different financial outcomes.
  • Intuitive Interface: Designed for ease of use, catering to both industry experts and newcomers.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Sabra Health Care REIT, Inc.'s (SBRA) pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as occupancy rates, rental growth, and operating expenses (highlighted cells).
  4. Step 4: Observe the DCF model refresh in real-time as you adjust your assumptions.
  5. Step 5: Evaluate the outputs and leverage the findings for your investment strategies.

Why Choose Sabra Health Care REIT, Inc. (SBRA)?

  • Streamlined Investment: Access to a well-structured portfolio without the hassle of extensive research.
  • Enhanced Returns: Proven strategies and reliable data help maximize your investment potential.
  • Flexible Options: Customize your investment approach to align with your financial goals.
  • User-Friendly Insights: Intuitive reports and visualizations simplify performance analysis.
  • Endorsed by Industry Leaders: A trusted choice among investors prioritizing stability and growth.

Who Should Use This Product?

  • Real Estate Investors: Gain insights into healthcare real estate with a specialized valuation tool.
  • Financial Analysts: Streamline your analysis with a customizable DCF model tailored for healthcare REITs.
  • Consultants: Effortlessly modify the template for client reports or presentations in the healthcare sector.
  • Finance Enthusiasts: Enhance your knowledge of healthcare REIT valuation through practical examples.
  • Educators and Students: Utilize it as a hands-on resource for finance and real estate courses.

What the Template Contains

  • Pre-Filled Data: Includes Sabra Health Care REIT, Inc.'s (SBRA) historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Sabra Health Care REIT, Inc.'s (SBRA) profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.