NexPoint Residential Trust, Inc. (NXRT) DCF Valuation

NexPoint Residential Trust, Inc. (NXRT) 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

NexPoint Residential Trust, Inc. (NXRT) 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:

Gain full control over your NexPoint Residential Trust, Inc. (NXRT) valuation analysis using our sophisticated DCF Calculator! Fully equipped with real (NXRT) data, this Excel template enables you to adjust forecasts and assumptions to accurately calculate the intrinsic value of NexPoint Residential Trust, Inc.


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 181.1 204.8 219.2 264.0 277.5 309.2 344.6 383.9 427.8 476.6
Revenue Growth, % 0 13.11 7.05 20.39 5.14 11.42 11.42 11.42 11.42 11.42
EBITDA 211.7 165.1 151.3 130.5 208.4 231.4 257.8 287.3 320.1 356.7
EBITDA, % 116.91 80.63 69.01 49.44 75.08 74.83 74.83 74.83 74.83 74.83
Depreciation 166.2 191.3 201.1 228.9 95.2 246.1 274.2 305.6 340.5 379.4
Depreciation, % 91.78 93.39 91.75 86.73 34.3 79.59 79.59 79.59 79.59 79.59
EBIT 45.5 -26.1 -49.8 -98.4 113.2 -4.3 -4.7 -5.3 -5.9 -6.6
EBIT, % 25.12 -12.77 -22.73 -37.3 40.78 -1.38 -1.38 -1.38 -1.38 -1.38
Total Cash 25.7 24.5 49.5 16.8 12.4 36.8 41.0 45.7 50.9 56.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 6.3 9.0 4.8 17.1 14.6
Account Receivables, % 3.47 4.42 2.21 6.49 5.26
Inventories -4.4 .0 -3.8 124.5 .0 26.6 29.6 33.0 36.8 41.0
Inventories, % -2.42 -0.00146484 -1.73 47.17 0 8.6 8.6 8.6 8.6 8.6
Accounts Payable 12.0 10.1 12.6 12.3 17.1 17.4 19.4 21.6 24.0 26.8
Accounts Payable, % 6.61 4.91 5.74 4.67 6.18 5.62 5.62 5.62 5.62 5.62
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.38035 0.38035 0.38035 0.38035 0.38035 0.38035 0.38035 0.38035 0.38035 0.38035
EBITAT 28.0 1.5 50.1 -686.7 112.7 -2.2 -2.5 -2.8 -3.1 -3.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 204.2 183.7 261.7 -598.6 339.8 218.6 269.2 299.9 334.2 372.3
WACC, % 7.4 4.69 4.69 9.1 9.08 6.99 6.99 6.99 6.99 6.99
PV UFCF
SUM PV UFCF 1,204.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 380
Terminal Value 7,608
Present Terminal Value 5,427
Enterprise Value 6,632
Net Debt 1,465
Equity Value 5,167
Diluted Shares Outstanding, MM 26
Equity Value Per Share 196.88

What You Will Get

  • Real NexPoint Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for NexPoint Residential Trust, Inc. (NXRT).
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
  • Instant Valuation Updates: Automatic recalculations to assess the impact of changes on NexPoint's fair value.
  • Versatile Excel Template: Designed for quick edits, scenario testing, and detailed financial projections.
  • Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.

Key Features

  • Comprehensive NXRT Financials: Gain access to precise pre-loaded historical data and future forecasts.
  • Adjustable Forecast Inputs: Modify yellow-highlighted fields 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 you visualize your valuation outcomes.
  • Suitable for All Levels: A straightforward, intuitive design tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review NexPoint Residential Trust, Inc.'s (NXRT) pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as rental growth, capitalization rates, and operating expenses (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose This Calculator?

  • Accuracy: Real NexPoint Residential Trust, Inc. (NXRT) financials ensure data accuracy.
  • Flexibility: Designed for users to test and modify inputs freely.
  • Time-Saving: Skip the hassle of building a DCF model from scratch.
  • Professional-Grade: Developed with CFO-level precision and usability in mind.
  • User-Friendly: Easy to use, even for those without advanced financial modeling experience.

Who Should Use NexPoint Residential Trust, Inc. (NXRT)?

  • Real Estate Investors: Enhance your investment strategies with accurate property valuation insights.
  • Financial Analysts: Streamline your analysis with our comprehensive financial modeling tools.
  • Consultants: Efficiently tailor reports and presentations for your clients in the residential market.
  • Real Estate Enthusiasts: Expand your knowledge of market trends and valuation methods through practical examples.
  • Educators and Students: Utilize our resources as an effective teaching aid in real estate and finance courses.

What the Template Contains

  • Historical Data: Includes NexPoint Residential Trust, Inc.'s (NXRT) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate NexPoint Residential Trust, Inc.'s (NXRT) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of NexPoint Residential Trust, Inc.'s (NXRT) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.