NETSTREIT Corp. (NTST) DCF Valuation

NETSTREIT Corp. (NTST) 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

NETSTREIT Corp. (NTST) 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:

Enhance your investment strategy with the NETSTREIT Corp. (NTST) DCF Calculator! Utilize accurate NETSTREIT financial data, adjust growth assumptions and expenses, and instantly observe how these adjustments affect the intrinsic value of NETSTREIT Corp. (NTST).


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 19.8 33.7 59.1 96.3 131.9 212.8 343.4 554.2 894.3 1,443.0
Revenue Growth, % 0 70.3 75.35 62.8 37 61.36 61.36 61.36 61.36 61.36
EBITDA 16.1 19.8 39.0 65.7 95.6 147.6 238.2 384.4 620.3 1,000.9
EBITDA, % 81.5 58.73 65.87 68.2 72.51 69.36 69.36 69.36 69.36 69.36
Depreciation 16.1 32.5 52.3 82.2 63.7 170.3 274.8 443.4 715.4 1,154.4
Depreciation, % 81.52 96.47 88.38 85.38 48.27 80 80 80 80 80
EBIT .0 -12.7 -13.3 -16.5 32.0 -22.6 -36.5 -59.0 -95.1 -153.5
EBIT, % -0.01514769 -37.74 -22.5 -17.18 24.24 -10.64 -10.64 -10.64 -10.64 -10.64
Total Cash 169.3 92.6 7.6 70.5 18.4 127.7 206.1 332.6 536.7 866.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .6 2.9 5.1 46.4 133.7
Account Receivables, % 3.23 8.59 8.56 48.17 101.35
Inventories 179.6 -.3 -4.3 -8.7 .0 35.3 56.9 91.9 148.2 239.2
Inventories, % 906.72 -0.75014 -7.29 -9.09 0 16.58 16.58 16.58 16.58 16.58
Accounts Payable 1.2 .9 .4 1.4 4.7 6.1 9.8 15.9 25.6 41.3
Accounts Payable, % 5.88 2.72 0.70849 1.45 3.56 2.86 2.86 2.86 2.86 2.86
Capital Expenditure -2.8 -.1 -.7 -1.2 .0 -7.1 -11.5 -18.6 -30.0 -48.4
Capital Expenditure, % -14.11 -0.15121 -1.24 -1.25 -0.02653425 -3.36 -3.36 -3.36 -3.36 -3.36
Tax Rate, % 0.05847098 0.05847098 0.05847098 0.05847098 0.05847098 0.05847098 0.05847098 0.05847098 0.05847098 0.05847098
EBITAT .0 240.2 -12.6 -15.6 32.0 -17.6 -28.4 -45.9 -74.1 -119.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -165.7 450.0 40.3 29.5 2.8 173.6 172.9 278.9 450.1 726.3
WACC, % 7.08 5.23 6.98 6.97 7.08 6.67 6.67 6.67 6.67 6.67
PV UFCF
SUM PV UFCF 1,418.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 741
Terminal Value 15,867
Present Terminal Value 11,490
Enterprise Value 12,908
Net Debt 622
Equity Value 12,286
Diluted Shares Outstanding, MM 65
Equity Value Per Share 189.99

What You Will Receive

  • Adjustable Forecast Parameters: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Comprehensive Financial Data: NETSTREIT Corp.’s (NTST) financial information pre-loaded to facilitate your analysis.
  • Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for your convenience.
  • Tailored and Professional Design: A refined Excel model that can be customized to meet your valuation requirements.
  • Designed for Analysts and Investors: Perfect for evaluating forecasts, confirming strategies, and enhancing efficiency.

Key Features

  • Comprehensive Data: NETSTREIT Corp.'s (NTST) historical financial statements and pre-filled projections.
  • Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
  • Real-Time Insights: Observe NETSTREIT Corp.'s (NTST) intrinsic value update instantly.
  • Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
  • Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.

How It Works

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

Why Choose NETSTREIT Corp. (NTST) Calculator?

  • Reliable Data: Utilize accurate NETSTREIT financials for trustworthy valuation outcomes.
  • Flexible Options: Modify essential inputs such as growth rates, WACC, and tax rates to align with your forecasts.
  • Efficiency Boost: Built-in calculations save you the hassle of starting from the ground up.
  • Professional-Quality Tool: Tailored for investors, analysts, and financial consultants.
  • Easy to Use: Clear design and guided instructions ensure accessibility for all users.

Who Should Use NETSTREIT Corp. (NTST)?

  • Real Estate Students: Understand investment strategies and apply them to real estate data.
  • Researchers: Utilize industry models in academic studies or projects focused on real estate investment trusts (REITs).
  • Investors: Evaluate your investment strategies and analyze valuation metrics for NETSTREIT Corp. (NTST).
  • Financial Analysts: Enhance your analytical processes with a customizable financial model tailored for REITs.
  • Small Investors: Learn about the analysis of publicly traded REITs like NETSTREIT Corp. (NTST) to inform your investment decisions.

What the Template Contains

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

No products were found matching.