Getty Realty Corp. (GTY) DCF Valuation

Getty Realty Corp. (GTY) DCF Valuation

US | Real Estate | REIT - Retail | NYSE
Getty Realty Corp. (GTY) 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

Getty Realty Corp. (GTY) Bundle

Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Engineered for accuracy, our Getty Realty Corp. (GTY) DCF Calculator empowers you to assess Getty Realty's valuation using real-world financial data, along with complete flexibility to modify all essential parameters for enhanced 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 140.7 147.3 155.4 165.6 185.8 192.1 198.5 205.2 212.1 219.2
Revenue Growth, % 0 4.76 5.47 6.55 12.23 3.36 3.36 3.36 3.36 3.36
EBITDA 102.4 129.6 127.8 163.0 143.0 160.7 166.1 171.7 177.5 183.5
EBITDA, % 72.82 87.93 82.25 98.44 76.96 83.68 83.68 83.68 83.68 83.68
Depreciation 70.9 72.1 81.3 61.2 51.3 83.1 85.9 88.7 91.7 94.8
Depreciation, % 50.44 48.9 52.29 36.94 27.63 43.24 43.24 43.24 43.24 43.24
EBIT 31.5 57.5 46.6 101.8 91.7 77.7 80.3 83.0 85.8 88.7
EBIT, % 22.38 39.02 29.96 61.5 49.33 40.44 40.44 40.44 40.44 40.44
Total Cash 21.8 55.1 24.7 8.7 3.3 29.1 30.1 31.1 32.2 33.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 75.2 59.2 65.2 89.0 171.4
Account Receivables, % 53.44 40.21 41.93 53.72 92.25
Inventories 1.9 .9 5.3 6.3 .0 3.5 3.6 3.8 3.9 4.0
Inventories, % 1.34 0.5918 3.44 3.8 0 1.83 1.83 1.83 1.83 1.83
Accounts Payable 26.6 11.0 6.6 4.1 27.4 18.4 19.0 19.6 20.3 21.0
Accounts Payable, % 18.94 7.44 4.28 2.46 14.74 9.57 9.57 9.57 9.57 9.57
Capital Expenditure .0 -.3 -.3 .0 -.3 -.2 -.2 -.2 -.2 -.2
Capital Expenditure, % -0.00995343 -0.19139 -0.17438 0 -0.16627 -0.1084 -0.1084 -0.1084 -0.1084 -0.1084
Tax Rate, % 0 0 0 0 0 0 0 0 0 0
EBITAT 11.1 18.4 .3 101.8 91.7 41.6 43.0 44.5 45.9 47.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 31.6 91.4 66.6 135.7 89.8 175.2 125.5 129.7 134.1 138.6
WACC, % 6.39 6.35 5.87 7.38 7.38 6.67 6.67 6.67 6.67 6.67
PV UFCF
SUM PV UFCF 585.3
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 144
Terminal Value 5,393
Present Terminal Value 3,904
Enterprise Value 4,490
Net Debt 769
Equity Value 3,720
Diluted Shares Outstanding, MM 50
Equity Value Per Share 74.09

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GTY financials.
  • Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe the impact of your inputs on Getty Realty Corp.'s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Customizable Investment Metrics: Adjust essential variables such as rental income growth, occupancy rates, and capital expenditures.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
  • High-Precision Accuracy: Leverages Getty Realty Corp.'s (GTY) actual financial data for dependable valuation results.
  • Simplified Scenario Analysis: Easily evaluate various assumptions and assess their impacts on outcomes.
  • Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.

How It Works

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

Why Choose Getty Realty Corp. (GTY)?

  • Comprehensive Investment: Focuses on high-quality net lease properties across diverse sectors.
  • Customizable Portfolio: Tailor your investment strategy to align with your financial goals.
  • In-Depth Analysis: Provides detailed insights into market trends and property valuations.
  • Reliable Data: Access historical performance metrics and future projections for informed decisions.
  • Professional Expertise: Backed by a team of experienced real estate professionals and analysts.

Who Should Use Getty Realty Corp. (GTY)?

  • Real Estate Investors: Gain insights into the performance of retail and convenience store properties.
  • Financial Analysts: Utilize comprehensive data to enhance your investment analysis and reporting.
  • Consultants: Easily tailor reports and presentations for clients interested in real estate investments.
  • Market Researchers: Expand your knowledge of the real estate sector with detailed market analysis and trends.
  • Educators and Students: Leverage real-world case studies to enrich finance and real estate education.

What the Template Contains

  • Pre-Filled Data: Includes Getty Realty Corp.'s (GTY) 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 Getty Realty Corp.'s (GTY) profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.