LTC Properties, Inc. (LTC) DCF Valuation

LTC Properties, Inc. (LTC) 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

LTC Properties, Inc. (LTC) 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:

Gain mastery over your LTC Properties, Inc. (LTC) valuation analysis using our sophisticated DCF Calculator! Equipped with real LTC data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of LTC Properties, Inc. (LTC).


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 185.3 159.3 155.3 175.2 197.2 201.6 206.1 210.6 215.3 220.0
Revenue Growth, % 0 -14.01 -2.52 12.77 12.61 2.21 2.21 2.21 2.21 2.21
EBITDA 121.1 134.7 93.1 136.6 175.9 152.0 155.4 158.8 162.3 165.9
EBITDA, % 65.35 84.54 59.94 77.98 89.17 75.4 75.4 75.4 75.4 75.4
Depreciation 77.1 131.3 82.0 80.2 37.4 97.4 99.6 101.8 104.0 106.3
Depreciation, % 41.63 82.43 52.77 45.78 18.97 48.32 48.32 48.32 48.32 48.32
EBIT 43.9 3.4 11.1 56.4 138.5 54.6 55.8 57.0 58.3 59.6
EBIT, % 23.72 2.11 7.17 32.2 70.21 27.08 27.08 27.08 27.08 27.08
Total Cash 4.2 7.8 5.2 10.4 20.3 10.8 11.0 11.2 11.5 11.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 90.2 71.7 24.1 126.2 19.6
Account Receivables, % 48.69 44.98 15.55 72.07 9.95
Inventories 62.0 .0 .0 13.0 .0 16.5 16.8 17.2 17.6 18.0
Inventories, % 33.44 0 0 7.43 0 8.17 8.17 8.17 8.17 8.17
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0 0 0 0 0 0 0 0 0 0
Capital Expenditure -.6 -.4 -6.3 -9.0 .0 -3.9 -4.0 -4.1 -4.2 -4.3
Capital Expenditure, % -0.32811 -0.22217 -4.05 -5.13 0 -1.95 -1.95 -1.95 -1.95 -1.95
Tax Rate, % 1.89 1.89 1.89 1.89 1.89 1.89 1.89 1.89 1.89 1.89
EBITAT 25.8 2.3 5.4 56.1 135.9 40.8 41.7 42.6 43.5 44.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -49.8 213.8 128.5 12.2 292.9 60.3 135.2 138.1 141.2 144.3
WACC, % 6.54 6.75 6.32 7.37 7.34 6.86 6.86 6.86 6.86 6.86
PV UFCF
SUM PV UFCF 499.8
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 149
Terminal Value 3,848
Present Terminal Value 2,761
Enterprise Value 3,261
Net Debt 871
Equity Value 2,390
Diluted Shares Outstanding, MM 41
Equity Value Per Share 57.79

What You Will Get

  • Real LTC Financials: Comprehensive historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess LTC's future performance.
  • User-Friendly Design: Designed for professionals while remaining easy for newcomers to navigate.

Key Features

  • Comprehensive LTC Financials: Gain access to precise historical data and future forecasts tailored for LTC Properties, Inc. (LTC).
  • Adjustable Projection Variables: Modify highlighted fields such as WACC, growth rates, and profit margins to fit your analysis.
  • Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • Interactive Dashboard: User-friendly charts and summaries to help visualize your investment valuation outcomes.
  • Designed for All Users: An intuitive format suitable for investors, CFOs, and consultants, regardless of experience level.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based LTC Properties, Inc. (LTC) DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
  3. Instant Calculations: The model automatically recalculates the intrinsic value of LTC Properties, Inc. (LTC).
  4. Test Scenarios: Experiment with various assumptions to assess possible changes in valuation.
  5. Analyze and Decide: Utilize the outcomes to inform your investment or financial strategy.

Why Choose This Calculator for LTC Properties, Inc. (LTC)?

  • Designed for Industry Experts: A specialized tool utilized by real estate analysts, investment managers, and financial consultants.
  • Comprehensive Data: LTC's historical and projected financials are preloaded for precise calculations.
  • Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions to see different outcomes.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.

Who Should Use This Product?

  • Real Estate Investors: Develop comprehensive valuation models for analyzing LTC Properties, Inc. (LTC) investments.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions related to LTC.
  • Consultants and Advisors: Offer clients precise valuation insights for LTC Properties, Inc. (LTC).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to LTC.
  • Market Analysts: Gain insights into how real estate investment trusts like LTC Properties, Inc. (LTC) are valued in the market.

What the Template Contains

  • Comprehensive DCF Model: Editable template with detailed valuation calculations specific to LTC Properties, Inc. (LTC).
  • Real-World Data: LTC's historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to evaluate 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 for clear, actionable insights related to LTC.

Es wurden keine passenden Produkte gefunden.