STAG Industrial, Inc. (STAG) DCF Valuation

STAG Industrial, Inc. (STAG) 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

STAG Industrial, Inc. (STAG) 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:

Evaluate STAG Industrial, Inc.'s financial outlook like an expert! This (STAG) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, profit margins, and other essential assumptions to align with your predictions.


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 406.0 483.4 562.2 654.4 707.8 813.9 935.9 1,076.1 1,237.4 1,422.9
Revenue Growth, % 0 19.08 16.29 16.4 8.17 14.99 14.99 14.99 14.99 14.99
EBITDA 293.1 352.4 402.8 827.9 516.1 634.3 729.4 838.7 964.3 1,108.9
EBITDA, % 72.21 72.9 71.65 126.52 72.91 77.93 77.93 77.93 77.93 77.93
Depreciation 298.4 346.2 398.2 452.1 278.4 528.0 607.1 698.1 802.8 923.1
Depreciation, % 73.5 71.62 70.83 69.08 39.34 64.87 64.87 64.87 64.87 64.87
EBIT -5.2 6.2 4.6 375.9 237.6 149.5 171.9 197.6 227.2 261.3
EBIT, % -1.29 1.28 0.81738 57.44 33.57 18.36 18.36 18.36 18.36 18.36
Total Cash 9.0 15.7 19.0 25.9 20.7 25.6 29.4 33.9 38.9 44.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 57.6 77.8 93.6 115.5 128.3
Account Receivables, % 14.19 16.09 16.65 17.65 18.12
Inventories 45.8 5.1 4.2 -66.2 .0 4.9 5.6 6.4 7.4 8.5
Inventories, % 11.29 1.06 0.74979 -10.11 0 0.59733 0.59733 0.59733 0.59733 0.59733
Accounts Payable 30.0 44.1 46.0 62.0 68.6 71.4 82.1 94.4 108.5 124.8
Accounts Payable, % 7.38 9.12 8.18 9.47 9.68 8.77 8.77 8.77 8.77 8.77
Capital Expenditure -205.6 -114.8 -160.4 -52.7 -18.5 -184.9 -212.6 -244.5 -281.1 -323.3
Capital Expenditure, % -50.65 -23.75 -28.53 -8.06 -2.61 -22.72 -22.72 -22.72 -22.72 -22.72
Tax Rate, % 2.21 2.21 2.21 2.21 2.21 2.21 2.21 2.21 2.21 2.21
EBITAT .4 4.3 3.1 215.0 232.4 86.9 99.9 114.9 132.1 151.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 19.6 270.3 227.9 678.8 420.0 421.6 484.2 556.8 640.2 736.1
WACC, % 6.69 7.62 7.6 7.46 8.01 7.47 7.47 7.47 7.47 7.47
PV UFCF
SUM PV UFCF 2,253.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 751
Terminal Value 13,715
Present Terminal Value 9,565
Enterprise Value 11,818
Net Debt 2,637
Equity Value 9,181
Diluted Shares Outstanding, MM 181
Equity Value Per Share 50.85

What You Will Get

  • Pre-Filled Financial Model: STAG Industrial’s actual data facilitates accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, margins, WACC, and other critical drivers.
  • Instant Calculations: Automatic updates ensure you see results in real-time as you make adjustments.
  • Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
  • Customizable and Reusable: Designed for adaptability, allowing repeated use for comprehensive forecasts.

Key Features

  • Real-Life STAG Data: Pre-filled with STAG Industrial’s historical performance and future projections.
  • Fully Customizable Inputs: Modify rental growth, occupancy rates, capital expenditures, and financing costs.
  • Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation results.
  • User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.

How It Works

  • Download: Obtain the pre-prepared Excel file featuring STAG Industrial, Inc.'s (STAG) financial data.
  • Customize: Modify projections such as rental income growth, occupancy rates, and cap rates.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various forecasts and instantly compare results.
  • Make Decisions: Leverage the valuation findings to inform your investment approach.

Why Choose This Calculator for STAG Industrial, Inc. (STAG)?

  • Designed for Industry Experts: A sophisticated tool utilized by real estate analysts, investors, and financial advisors.
  • Comprehensive Data: STAG’s historical and projected financials preloaded for enhanced precision.
  • Versatile Scenario Analysis: Effortlessly simulate various investment scenarios and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and other vital metrics.
  • User-Friendly: Step-by-step guidance ensures a seamless experience throughout the process.

Who Should Use STAG Industrial, Inc. (STAG)?

  • Real Estate Investors: Enhance your investment strategies with insights from a leading industrial REIT.
  • Financial Analysts: Utilize comprehensive market data to streamline your property evaluations.
  • Consultants: Tailor reports and presentations using STAG's robust portfolio information.
  • Real Estate Enthusiasts: Expand your knowledge of industrial property trends and valuation methods.
  • Educators and Students: Leverage real-world case studies from STAG in your finance and real estate courses.

What the Template Contains

  • Pre-Filled DCF Model: STAG Industrial's financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate STAG Industrial's profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.