Centerspace (CSR) DCF Valuation

Centerspace (CSR) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

Centerspace (CSR) 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:

Explore Centerspace's (CSR) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, profit margins, and expenses to calculate Centerspace's (CSR) intrinsic value and refine your investment approach.


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 185.8 178.0 201.7 256.7 261.3 286.3 313.6 343.6 376.4 412.3
Revenue Growth, % 0 -4.18 13.32 27.27 1.79 9.55 9.55 9.55 9.55 9.55
EBITDA 87.9 85.6 122.1 121.6 186.1 157.2 172.2 188.7 206.7 226.4
EBITDA, % 47.34 48.09 60.51 47.37 71.23 54.91 54.91 54.91 54.91 54.91
Depreciation 173.2 168.0 199.0 241.3 103.2 240.3 263.3 288.4 316.0 346.2
Depreciation, % 93.25 94.38 98.65 94 39.48 83.95 83.95 83.95 83.95 83.95
EBIT -85.3 -82.4 -76.9 -119.7 83.0 -83.1 -91.1 -99.8 -109.3 -119.8
EBIT, % -45.91 -46.29 -38.14 -46.62 31.75 -29.04 -29.04 -29.04 -29.04 -29.04
Total Cash 26.6 .4 31.3 10.5 8.6 21.4 23.5 25.7 28.2 30.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .9 .9 1.0 6.6 7.7
Account Receivables, % 0.5055 0.4826 0.50073 2.59 2.93
Inventories 14.7 1.2 -2.3 -13.7 .0 1.2 1.3 1.4 1.6 1.7
Inventories, % 7.9 0.68317 -1.16 -5.33 0 0.41866 0.41866 0.41866 0.41866 0.41866
Accounts Payable 39.5 39.7 56.7 58.8 62.8 67.9 74.4 81.5 89.3 97.8
Accounts Payable, % 21.29 22.31 28.11 22.91 24.02 23.73 23.73 23.73 23.73 23.73
Capital Expenditure -21.0 -30.3 -35.9 -56.7 .0 -39.0 -42.8 -46.8 -51.3 -56.2
Capital Expenditure, % -11.28 -17.03 -17.79 -22.08 0 -13.64 -13.64 -13.64 -13.64 -13.64
Tax Rate, % 14.76 14.76 14.76 14.76 14.76 14.76 14.76 14.76 14.76 14.76
EBITAT -48.9 416.9 -1,149.1 -101.9 70.7 -54.5 -59.7 -65.4 -71.7 -78.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 127.3 568.2 -965.6 90.5 163.1 154.4 166.8 182.7 200.2 219.3
WACC, % 5.97 4.83 6.82 6.52 6.53 6.13 6.13 6.13 6.13 6.13
PV UFCF
SUM PV UFCF 767.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 224
Terminal Value 5,412
Present Terminal Value 4,019
Enterprise Value 4,786
Net Debt 907
Equity Value 3,879
Diluted Shares Outstanding, MM 17
Equity Value Per Share 226.60

What You Will Get

  • Real CSR Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Explore various scenarios to assess Centerspace’s future performance.
  • User-Friendly Design: Tailored for professionals yet easy for newcomers to navigate.

Key Features

  • Real-Time CSR Data: Pre-loaded with Centerspace’s historical performance metrics and future growth estimates.
  • Comprehensive Input Options: Modify variables such as rental growth, operating margins, capital costs, and investment strategies.
  • Interactive Valuation Framework: Instant updates to Net Asset Value (NAV) and intrinsic worth based on user-defined parameters.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
  • Intuitive User Interface: Clean, organized, and suitable for both industry experts and newcomers.

How It Works

  • Download: Get the pre-built Excel file featuring Centerspace's (CSR) financial data.
  • Customize: Modify projections, including rental growth, operating income %, and discount rate.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various forecasts and evaluate results instantly.
  • Make Decisions: Leverage the valuation insights to shape your investment approach.

Why Choose This Calculator for Centerspace (CSR)?

  • Precise Financials: Utilize authentic Centerspace financial data for trustworthy valuation outcomes.
  • Flexible Options: Modify essential parameters 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.
  • Expert-Level Tool: Tailored for investors, analysts, and financial consultants.
  • Easy to Use: User-friendly design and clear, step-by-step guidance make it accessible for everyone.

Who Should Use Centerspace (CSR)?

  • Real Estate Investors: Make informed decisions with a robust investment analysis tool.
  • Financial Analysts: Streamline your workflow with a customizable financial modeling template.
  • Consultants: Easily modify the resources for client proposals or financial reports.
  • Property Enthusiasts: Enhance your knowledge of real estate valuation through practical examples.
  • Educators and Students: Utilize it as a hands-on resource in real estate or finance courses.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Centerspace (CSR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Centerspace (CSR).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.