Global Net Lease, Inc. (GNL) 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
Global Net Lease, Inc. (GNL) Bundle
Streamline your analysis and improve precision with our (GNL) DCF Calculator! Equipped with actual data from Global Net Lease, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and value (GNL) just like a seasoned investor.
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 | 306.2 | 330.1 | 391.2 | 378.9 | 515.1 | 591.2 | 678.5 | 778.8 | 893.9 | 1,026.0 |
Revenue Growth, % | 0 | 7.8 | 18.52 | -3.16 | 35.95 | 14.78 | 14.78 | 14.78 | 14.78 | 14.78 |
EBITDA | 246.2 | 230.3 | 285.5 | 279.4 | 215.7 | 400.6 | 459.8 | 527.7 | 605.7 | 695.2 |
EBITDA, % | 80.39 | 69.77 | 72.99 | 73.75 | 41.88 | 67.76 | 67.76 | 67.76 | 67.76 | 67.76 |
Depreciation | 207.6 | 236.7 | 264.4 | 255.3 | 233.7 | 378.2 | 434.1 | 498.3 | 571.9 | 656.4 |
Depreciation, % | 67.81 | 71.72 | 67.58 | 67.4 | 45.38 | 63.98 | 63.98 | 63.98 | 63.98 | 63.98 |
EBIT | 38.5 | -6.4 | 21.2 | 24.1 | -18.0 | 22.4 | 25.7 | 29.5 | 33.8 | 38.8 |
EBIT, % | 12.58 | -1.94 | 5.41 | 6.36 | -3.5 | 3.78 | 3.78 | 3.78 | 3.78 | 3.78 |
Total Cash | 270.3 | 124.2 | 89.7 | 103.3 | 121.6 | 236.1 | 271.0 | 311.1 | 357.0 | 409.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .4 | .4 | 74.2 | 73.0 | 84.3 | 64.8 | 74.4 | 85.4 | 98.0 | 112.5 |
Account Receivables, % | 0.11463 | 0.11421 | 18.97 | 19.28 | 16.36 | 10.97 | 10.97 | 10.97 | 10.97 | 10.97 |
Inventories | -.6 | 127.5 | -1.2 | -30.8 | .0 | 35.5 | 40.7 | 46.7 | 53.6 | 61.6 |
Inventories, % | -0.19398 | 38.63 | -0.31082 | -8.12 | 0 | 6 | 6 | 6 | 6 | 6 |
Accounts Payable | 22.9 | 28.3 | 25.9 | 22.9 | 99.0 | 56.7 | 65.1 | 74.7 | 85.7 | 98.4 |
Accounts Payable, % | 7.48 | 8.58 | 6.62 | 6.04 | 19.22 | 9.59 | 9.59 | 9.59 | 9.59 | 9.59 |
Capital Expenditure | -17.3 | -6.4 | -7.9 | -29.9 | -47.3 | -31.6 | -36.2 | -41.6 | -47.8 | -54.8 |
Capital Expenditure, % | -5.66 | -1.93 | -2.03 | -7.9 | -9.18 | -5.34 | -5.34 | -5.34 | -5.34 | -5.34 |
Tax Rate, % | -7.33 | -7.33 | -7.33 | -7.33 | -7.33 | -7.33 | -7.33 | -7.33 | -7.33 | -7.33 |
EBITAT | 35.3 | -4.4 | 10.2 | 12.6 | -19.3 | 16.1 | 18.5 | 21.2 | 24.4 | 28.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 248.7 | 103.2 | 319.1 | 265.7 | 201.2 | 304.4 | 409.9 | 470.5 | 540.0 | 619.8 |
WACC, % | 5.17 | 4.31 | 3.56 | 3.7 | 5.49 | 4.45 | 4.45 | 4.45 | 4.45 | 4.45 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,032.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 632 | |||||||||
Terminal Value | 25,853 | |||||||||
Present Terminal Value | 20,800 | |||||||||
Enterprise Value | 22,832 | |||||||||
Net Debt | 5,171 | |||||||||
Equity Value | 17,662 | |||||||||
Diluted Shares Outstanding, MM | 143 | |||||||||
Equity Value Per Share | 123.87 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GNL financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Global Net Lease, Inc.'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
- Comprehensive Financial Data: Global Net Lease, Inc. (GNL) provides extensive historical financial statements and detailed forecasts.
- Customizable Parameters: Adjust inputs such as WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Global Net Lease, Inc. (GNL).
- Intuitive Visualizations: Engaging dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Global Net Lease, Inc.'s (GNL) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
- 5. Present with Confidence: Deliver professional valuation insights to enhance your decision-making process.
Why Choose Global Net Lease, Inc. (GNL)?
- Maximize Returns: Benefit from a well-structured investment strategy tailored for real estate.
- Enhance Portfolio Diversification: Invest in a diverse range of properties across various sectors.
- Transparent Operations: Access clear and comprehensive reports for informed decision-making.
- Expert Management: Rely on a team of seasoned professionals dedicated to optimizing performance.
- Proven Track Record: Join a company with a history of delivering consistent returns to investors.
Who Should Use Global Net Lease, Inc. (GNL)?
- Real Estate Investors: Gain insights for informed decisions with a reliable investment analysis tool.
- Portfolio Managers: Streamline your workflow with a customizable financial model tailored for REITs.
- Financial Advisors: Easily modify the template for client portfolios or investment strategies.
- Market Analysts: Enhance your understanding of real estate investment trusts through practical case studies.
- Students and Educators: Utilize it as a hands-on resource in real estate finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Global Net Lease, Inc.'s (GNL) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights.