Whitestone REIT (WSR) DCF Valuation

Whitestone REIT (WSR) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Whitestone REIT (WSR) 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:

Looking to determine the intrinsic value of Whitestone REIT? Our (WSR) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment decisions.


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 119.3 117.9 125.4 140.6 147.9 156.3 165.1 174.4 184.2 194.6
Revenue Growth, % 0 -1.12 6.32 12.13 5.22 5.64 5.64 5.64 5.64 5.64
EBITDA 76.4 59.2 64.1 78.4 87.2 87.6 92.5 97.7 103.2 109.0
EBITDA, % 64.08 50.23 51.16 55.74 58.94 56.03 56.03 56.03 56.03 56.03
Depreciation 85.8 90.3 85.4 93.0 33.1 95.3 100.7 106.4 112.4 118.7
Depreciation, % 71.91 76.54 68.11 66.14 22.35 61.01 61.01 61.01 61.01 61.01
EBIT -9.3 -31.0 -21.2 -14.6 54.1 -7.8 -8.2 -8.7 -9.2 -9.7
EBIT, % -7.83 -26.31 -16.94 -10.4 36.59 -4.98 -4.98 -4.98 -4.98 -4.98
Total Cash 15.5 25.8 15.7 6.2 4.6 17.2 18.1 19.1 20.2 21.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 23.3 23.3 23.2 26.9 32.1
Account Receivables, % 19.56 19.8 18.54 19.17 21.7
Inventories -.1 .0 64.0 .0 .0 15.9 16.8 17.8 18.8 19.8
Inventories, % -0.04947548 0.000000848 51.04 0.000000711 0 10.2 10.2 10.2 10.2 10.2
Accounts Payable 19.8 31.0 32.3 28.5 36.4 35.5 37.5 39.6 41.8 44.2
Accounts Payable, % 16.63 26.29 25.78 20.24 24.61 22.71 22.71 22.71 22.71 22.71
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, % 3.62 3.62 3.62 3.62 3.62 3.62 3.62 3.62 3.62 3.62
EBITAT -9.2 -28.7 -23.7 -14.2 52.2 -7.5 -8.0 -8.4 -8.9 -9.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 73.1 72.7 -.9 135.2 88.0 72.2 92.1 97.3 102.8 108.6
WACC, % 7.86 7.71 7.89 7.83 7.81 7.82 7.82 7.82 7.82 7.82
PV UFCF
SUM PV UFCF 374.4
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 112
Terminal Value 2,602
Present Terminal Value 1,786
Enterprise Value 2,160
Net Debt 636
Equity Value 1,524
Diluted Shares Outstanding, MM 51
Equity Value Per Share 29.99

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Whitestone REIT (WSR) financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Quickly see how your inputs affect Whitestone REIT’s (WSR) 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 guidance.

Key Features

  • Comprehensive Data: Whitestone REIT’s (WSR) historical financial statements and pre-filled projections.
  • Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Calculations: Instantly view Whitestone REIT’s (WSR) intrinsic value as you adjust inputs.
  • Intuitive Visuals: Dashboard charts 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 for Whitestone REIT (WSR).
  2. Step 2: Review Whitestone REIT’s pre-filled financial data and projections.
  3. Step 3: Adjust key inputs such as rental income growth, capitalization rates, and occupancy rates (highlighted cells).
  4. Step 4: Observe the DCF model refresh in real-time as you modify assumptions.
  5. Step 5: Evaluate the outputs and leverage the findings for your investment strategies.

Why Choose This Calculator for Whitestone REIT (WSR)?

  • Accuracy: Utilizes real Whitestone REIT financials to ensure precise data.
  • Flexibility: Built for users to easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
  • Professional-Grade: Crafted with the precision and usability expected by CFOs.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use This Product?

  • Investors: Assess Whitestone REIT’s (WSR) value before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation workflows and validate financial forecasts.
  • Real Estate Entrepreneurs: Discover valuation methods used for established REITs like Whitestone REIT.
  • Consultants: Provide detailed valuation analyses and reports for clients in real estate.
  • Students and Educators: Utilize current market data to learn and teach valuation principles.

What the Template Contains

  • Historical Data: Includes Whitestone REIT’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Whitestone REIT’s 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 Whitestone REIT’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.