National Retail Properties, Inc. (NNN) 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
National Retail Properties, Inc. (NNN) Bundle
Looking to determine the intrinsic value of National Retail Properties, Inc.? Our (NNN) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 670.5 | 660.7 | 726.4 | 773.1 | 828.1 | 864.3 | 902.0 | 941.4 | 982.6 | 1,025.5 |
| Revenue Growth, % | 0 | -1.46 | 9.95 | 6.42 | 7.12 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
| EBITDA | 605.7 | 571.1 | 654.3 | 706.4 | 793.7 | 784.9 | 819.2 | 855.0 | 892.3 | 931.3 |
| EBITDA, % | 90.33 | 86.44 | 90.08 | 91.37 | 95.85 | 90.81 | 90.81 | 90.81 | 90.81 | 90.81 |
| Depreciation | 254.2 | 265.0 | 278.4 | 299.7 | 238.6 | 317.9 | 331.8 | 346.3 | 361.4 | 377.2 |
| Depreciation, % | 37.91 | 40.11 | 38.33 | 38.76 | 28.82 | 36.79 | 36.79 | 36.79 | 36.79 | 36.79 |
| EBIT | 351.5 | 306.1 | 375.9 | 406.7 | 555.1 | 467.0 | 487.4 | 508.6 | 530.9 | 554.0 |
| EBIT, % | 52.42 | 46.33 | 51.74 | 52.61 | 67.03 | 54.03 | 54.03 | 54.03 | 54.03 | 54.03 |
| Total Cash | 1.1 | 267.2 | 171.3 | 2.5 | 1.2 | 111.8 | 116.7 | 121.8 | 127.1 | 132.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 31.8 | 58.3 | 35.1 | 31.4 | 38.3 | 46.8 | 48.8 | 51.0 | 53.2 | 55.5 |
| Account Receivables, % | 4.74 | 8.82 | 4.83 | 4.06 | 4.62 | 5.42 | 5.42 | 5.42 | 5.42 | 5.42 |
| Inventories | 7.0 | 5.7 | 5.6 | 4.3 | .0 | 5.6 | 5.8 | 6.1 | 6.3 | 6.6 |
| Inventories, % | 1.05 | 0.85836 | 0.765 | 0.55274 | 0 | 0.64432 | 0.64432 | 0.64432 | 0.64432 | 0.64432 |
| 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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 210.2 | 133.0 | 197.2 | 226.9 | 555.1 | 290.9 | 303.6 | 316.9 | 330.7 | 345.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 425.6 | 372.8 | 499.0 | 531.6 | 791.1 | 594.7 | 633.2 | 660.8 | 689.7 | 719.8 |
| WACC, % | 7.01 | 6.74 | 6.89 | 6.94 | 7.67 | 7.05 | 7.05 | 7.05 | 7.05 | 7.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,683.9 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 749 | |||||||||
| Terminal Value | 24,538 | |||||||||
| Present Terminal Value | 17,454 | |||||||||
| Enterprise Value | 20,138 | |||||||||
| Net Debt | 4,359 | |||||||||
| Equity Value | 15,779 | |||||||||
| Diluted Shares Outstanding, MM | 182 | |||||||||
| Equity Value Per Share | 86.84 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: National Retail Properties, Inc. (NNN) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you automatically.
- Customizable and Professional: A sleek Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Accurate NNN Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based NNN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to show National Retail Properties, Inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial strategies.
Why Choose This Calculator for National Retail Properties, Inc. (NNN)?
- Precision: Utilizes actual financial data from National Retail Properties, Inc. for reliable calculations.
- Versatility: Built to allow users to easily adjust and experiment with various inputs.
- Efficiency: Eliminate the need to create a DCF model from the ground up.
- Expert-Level: Crafted with the accuracy and functionality expected by finance professionals.
- Intuitive: Simple to navigate, making it accessible for users without extensive financial modeling knowledge.
Who Should Use This Product?
- Investors: Evaluate National Retail Properties, Inc. (NNN)’s market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Real Estate Developers: Understand how established companies like National Retail Properties, Inc. (NNN) are appraised.
- Consultants: Create comprehensive valuation reports for clients in the retail sector.
- Students and Educators: Utilize current market data to learn and teach real estate valuation practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled National Retail Properties, Inc. (NNN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for National Retail Properties, Inc. (NNN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.