|
Getty Realty Corp. (GTY) DCF Valuation
US | Real Estate | REIT - Retail | NYSE
|
- ✓ 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
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 | 108.2 | 111.8 | 115.6 | 119.4 | 123.5 |
Account Receivables, % | 53.44 | 40.21 | 41.93 | 53.72 | 92.25 | 56.31 | 56.31 | 56.31 | 56.31 | 56.31 |
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
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Getty Realty Corp. (GTY) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Getty Realty Corp.'s (GTY) intrinsic value.
- 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.