EPR Properties (EPR) DCF Valuation

EPR Properties (EPR) 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

EPR Properties (EPR) 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:

Evaluate EPR Properties' financial outlook like an expert! This EPR DCF Calculator comes with pre-loaded financial data and offers full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your projections.


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 652.0 414.7 531.7 658.0 705.7 745.9 788.5 833.5 881.1 931.3
Revenue Growth, % 0 -36.4 28.22 23.76 7.24 5.71 5.71 5.71 5.71 5.71
EBITDA 476.5 260.1 404.6 504.2 467.7 529.3 559.5 591.5 625.2 660.9
EBITDA, % 73.09 62.73 76.09 76.62 66.27 70.96 70.96 70.96 70.96 70.96
Depreciation 321.2 326.4 267.7 320.2 168.0 374.2 395.5 418.1 441.9 467.2
Depreciation, % 49.27 78.71 50.35 48.66 23.81 50.16 50.16 50.16 50.16 50.16
EBIT 155.3 -66.3 136.9 184.0 299.6 155.2 164.0 173.4 183.3 193.7
EBIT, % 23.83 -15.98 25.74 27.96 42.46 20.8 20.8 20.8 20.8 20.8
Total Cash 528.8 1,025.6 288.8 107.9 78.1 392.2 414.6 438.2 463.2 489.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 84.8 489.1 455.5 513.7 637.3
Account Receivables, % 13 117.96 85.67 78.07 90.31
Inventories -32.8 2.4 1.1 2.6 .0 -5.7 -6.1 -6.4 -6.8 -7.2
Inventories, % -5.03 0.58674 0.20294 0.39162 0 -0.76928 -0.76928 -0.76928 -0.76928 -0.76928
Accounts Payable 122.9 105.4 73.5 80.1 94.9 124.9 132.0 139.5 147.5 155.9
Accounts Payable, % 18.86 25.41 13.82 12.17 13.45 16.74 16.74 16.74 16.74 16.74
Capital Expenditure -437.2 -133.2 -113.2 -13.4 .0 -182.8 -193.2 -204.2 -215.9 -228.2
Capital Expenditure, % -67.06 -32.12 -21.29 -2.04 0 -24.5 -24.5 -24.5 -24.5 -24.5
Tax Rate, % 0.98814 0.98814 0.98814 0.98814 0.98814 0.98814 0.98814 0.98814 0.98814 0.98814
EBITAT 158.4 -75.9 134.7 182.7 296.7 154.1 162.9 172.2 182.1 192.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 113.4 -339.8 292.3 436.4 358.5 470.9 341.5 361.0 381.5 403.3
WACC, % 8.79 8.79 8.76 8.78 8.77 8.78 8.78 8.78 8.78 8.78
PV UFCF
SUM PV UFCF 1,539.2
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 419
Terminal Value 8,775
Present Terminal Value 5,761
Enterprise Value 7,300
Net Debt 2,965
Equity Value 4,335
Diluted Shares Outstanding, MM 76
Equity Value Per Share 57.25

What You Will Get

  • Real EPR Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for EPR Properties (EPR).
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to EPR Properties (EPR).
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on EPR Properties (EPR)’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections relevant to EPR Properties (EPR).
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for EPR Properties (EPR).

Key Features

  • Customizable Financial Inputs: Adjust essential factors such as rental income growth, operating margins, and capital investments.
  • Instant DCF Analysis: Quickly computes intrinsic value, net present value (NPV), and additional metrics.
  • High-Precision Valuation: Leverages EPR Properties’ (EPR) actual financial data for accurate valuation results.
  • Streamlined Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
  • Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file containing EPR Properties' (EPR) preloaded data.
  • 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
  • 3. View Results in Real-Time: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
  • 4. Experiment with Scenarios: Evaluate different forecasts to explore various valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation findings to back your investment decisions.

Why Choose This Calculator for EPR Properties (EPR)?

  • Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for EPR Properties.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
  • Detailed Insights: Automatically computes the intrinsic value and Net Present Value for EPR Properties.
  • Preloaded Data: Utilizes historical and forecasted data for reliable analysis.
  • Professional Quality: Perfect for financial analysts, investors, and real estate consultants focused on EPR Properties.

Who Should Use EPR Properties (EPR)?

  • Real Estate Investors: Utilize a trusted platform for informed investment decisions in the real estate sector.
  • Financial Analysts: Streamline your analysis with comprehensive data and insights tailored for EPR Properties (EPR).
  • Consultants: Easily modify reports and presentations to showcase EPR Properties (EPR) to clients.
  • Finance Enthusiasts: Enhance your knowledge of real estate investment strategies through detailed case studies of EPR Properties (EPR).
  • Educators and Students: Leverage this resource as a hands-on tool for learning about real estate finance and investment.

What the Template Contains

  • Preloaded EPR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.