Community Healthcare Trust Incorporated (CHCT) DCF Valuation

Community Healthcare Trust Incorporated (CHCT) 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

Community Healthcare Trust Incorporated (CHCT) 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:

Streamline Community Healthcare Trust Incorporated (CHCT) valuation with this customizable DCF Calculator! Utilizing real Community Healthcare Trust Incorporated (CHCT) financials and adjustable forecast inputs, you can explore scenarios and determine Community Healthcare Trust Incorporated (CHCT) fair value in just minutes.


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 60.8 75.7 90.6 97.7 112.8 131.9 154.1 180.1 210.4 245.9
Revenue Growth, % 0 24.38 19.68 7.84 15.53 16.86 16.86 16.86 16.86 16.86
EBITDA 41.3 53.6 63.4 66.3 65.5 88.3 103.1 120.5 140.8 164.6
EBITDA, % 67.93 70.83 69.96 67.85 58.08 66.93 66.93 66.93 66.93 66.93
Depreciation 42.2 47.8 57.7 63.8 39.7 78.2 91.4 106.8 124.8 145.9
Depreciation, % 69.32 63.1 63.67 65.33 35.17 59.32 59.32 59.32 59.32 59.32
EBIT -.8 5.8 5.7 2.5 25.8 10.0 11.7 13.7 16.0 18.7
EBIT, % -1.39 7.72 6.29 2.52 22.9 7.61 7.61 7.61 7.61 7.61
Total Cash 1.7 2.5 2.4 11.2 3.5 6.1 7.2 8.4 9.8 11.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 31.8 28.4 43.1 53.8 56.9
Account Receivables, % 52.24 37.5 47.6 55.13 50.45
Inventories 2.3 32.3 -.3 -22.7 .0 6.0 7.1 8.2 9.6 11.3
Inventories, % 3.81 42.66 -0.37867 -23.21 0 4.58 4.58 4.58 4.58 4.58
Accounts Payable 3.6 5.7 7.8 11.4 12.0 11.7 13.7 16.0 18.7 21.9
Accounts Payable, % 5.93 7.59 8.66 11.65 10.66 8.9 8.9 8.9 8.9 8.9
Capital Expenditure -4.4 -7.0 -7.2 -10.4 -19.0 -13.7 -16.0 -18.7 -21.8 -25.5
Capital Expenditure, % -7.18 -9.24 -7.97 -10.62 -16.82 -10.37 -10.37 -10.37 -10.37 -10.37
Tax Rate, % 3.82 3.82 3.82 3.82 3.82 3.82 3.82 3.82 3.82 3.82
EBITAT -.7 5.8 5.7 2.5 24.9 9.6 11.3 13.2 15.4 18.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 6.6 22.2 76.1 71.0 20.5 60.7 76.9 89.8 104.9 122.6
WACC, % 5.81 6.1 6.1 6.11 6.03 6.03 6.03 6.03 6.03 6.03
PV UFCF
SUM PV UFCF 375.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 125
Terminal Value 3,105
Present Terminal Value 2,317
Enterprise Value 2,692
Net Debt 404
Equity Value 2,288
Diluted Shares Outstanding, MM 25
Equity Value Per Share 90.80

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Community Healthcare Trust Incorporated’s (CHCT) financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you automatically.
  • Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Community Healthcare Trust Incorporated (CHCT).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to (CHCT).
  • Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates relevant to (CHCT).
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Community Healthcare Trust Incorporated (CHCT).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of (CHCT).

How It Works

  1. Step 1: Download the Excel file for Community Healthcare Trust Incorporated (CHCT).
  2. Step 2: Review the pre-filled financial data and forecasts specific to CHCT.
  3. Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for informed investment decisions.

Why Choose This Calculator for Community Healthcare Trust Incorporated (CHCT)?

  • User-Friendly Interface: Perfect for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters easily to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to CHCT’s valuation as you modify inputs.
  • Preloaded Data: Comes with CHCT’s actual financial metrics for swift evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts seeking reliable insights.

Who Should Use This Product?

  • Individual Investors: Gain insights to make informed decisions about buying or selling Community Healthcare Trust Incorporated (CHCT) stock.
  • Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for healthcare real estate.
  • Consultants: Provide clients with accurate and timely valuation insights related to healthcare investments.
  • Business Owners: Learn how healthcare REITs like Community Healthcare Trust Incorporated (CHCT) are valued to inform your own business strategies.
  • Finance Students: Explore valuation methodologies using real-world data from the healthcare sector.

What the Template Contains

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

No products were found matching.