RPT Realty (RPT) DCF Valuation

RPT Realty (RPT) 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

RPT Realty (RPT) 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:

Whether you’re an investor or analyst, this (RPT) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from RPT Realty, you can adjust forecasts and instantly observe the effects.


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 234.1 191.7 213.5 217.7 -16.9 -12.4 -9.2 -6.8 -5.0 -3.7
Revenue Growth, % 0 -18.1 11.36 1.95 -107.75 -26.2 -26.2 -26.2 -26.2 -26.2
EBITDA 133.3 103.8 116.6 116.9 .0 -5.5 -4.0 -3.0 -2.2 -1.6
EBITDA, % 56.94 54.12 54.64 53.73 0 43.88 43.88 43.88 43.88 43.88
Depreciation 79.3 77.1 72.3 .4 .5 -2.6 -1.9 -1.4 -1.0 -.8
Depreciation, % 33.86 40.19 33.84 0.20399 -3.17 20.99 20.99 20.99 20.99 20.99
EBIT 54.0 26.7 44.4 116.5 -.5 -2.8 -2.1 -1.6 -1.1 -.8
EBIT, % 23.08 13.93 20.79 53.52 3.17 22.9 22.9 22.9 22.9 22.9
Total Cash 110.3 208.9 13.4 262.5 184.4 -3.8 -2.8 -2.1 -1.5 -1.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 25.0 26.6 24.0 7.5 7.3
Account Receivables, % 10.67 13.86 11.22 3.42 -43.34
Inventories -2.3 -2.8 .0 .0 .0 .1 .0 .0 .0 .0
Inventories, % -0.99578 -1.46 0.000000468 0 0 -0.49178 -0.49178 -0.49178 -0.49178 -0.49178
Accounts Payable 55.4 45.3 47.0 40.3 .0 -2.2 -1.6 -1.2 -.9 -.6
Accounts Payable, % 23.65 23.63 22.03 18.5 0 17.56 17.56 17.56 17.56 17.56
Capital Expenditure -56.6 -23.1 -28.1 -29.4 .0 1.6 1.2 .9 .6 .5
Capital Expenditure, % -24.18 -12.06 -13.18 -13.51 0 -12.59 -12.59 -12.59 -12.59 -12.59
Tax Rate, % -0.76422 -0.76422 -0.76422 -0.76422 -0.76422 -0.76422 -0.76422 -0.76422 -0.76422 -0.76422
EBITAT 52.7 26.6 43.4 -20.4 -.5 -2.3 -1.7 -1.2 -.9 -.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 108.0 69.4 89.1 -39.6 -40.1 1.7 -1.8 -1.3 -1.0 -.7
WACC, % 9.71 9.9 9.73 1.39 9.92 8.13 8.13 8.13 8.13 8.13
PV UFCF
SUM PV UFCF -2.3
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) -1
Terminal Value -10
Present Terminal Value -7
Enterprise Value -9
Net Debt 569
Equity Value -578
Diluted Shares Outstanding, MM 24
Equity Value Per Share -23.80

What You Will Get

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

Key Features

  • Accurate RPT Financials: Gain access to reliable pre-loaded historical data and future forecasts.
  • Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
  • Real-time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation outcomes.
  • Designed for All Levels: An intuitive framework tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered RPT Realty (RPT) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for RPT Realty’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for RPT Realty (RPT)?

  • Designed for Industry Experts: A sophisticated tool utilized by real estate analysts, investors, and financial advisors.
  • Accurate Financial Data: RPT Realty’s historical and projected financials are preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and investment assumptions.
  • Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential performance metrics.
  • User-Friendly Interface: Step-by-step guidance makes the process straightforward.

Who Should Use RPT Realty (RPT)?

  • Real Estate Students: Understand property valuation methods and apply them to real-world scenarios.
  • Researchers: Integrate industry-specific models into academic studies or papers.
  • Property Investors: Validate your investment strategies and evaluate valuation metrics for RPT Realty (RPT).
  • Market Analysts: Enhance your analysis with a ready-to-use, customizable valuation model.
  • Real Estate Professionals: Discover how major real estate companies like RPT Realty (RPT) assess their portfolios.

What the Template Contains

  • Historical Data: Includes RPT Realty’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate RPT Realty’s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of RPT Realty’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.