Simon Property Group, Inc. (SPG) DCF Valuation

Simon Property Group, Inc. (SPG) 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

Simon Property Group, Inc. (SPG) 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 choices with the [Symbol] DCF Calculator! Explore authentic Simon Property Group financials, adjust growth projections and expenses, and immediately observe how these changes affect [Symbol] intrinsic value.


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 5,755.2 4,607.5 5,116.8 5,291.4 5,658.8 5,679.6 5,700.5 5,721.4 5,742.4 5,763.5
Revenue Growth, % 0 -19.94 11.05 3.41 6.94 0.36704 0.36704 0.36704 0.36704 0.36704
EBITDA 4,636.8 3,412.1 4,458.7 4,589.3 4,069.1 4,548.2 4,564.9 4,581.7 4,598.5 4,615.4
EBITDA, % 80.57 74.05 87.14 86.73 71.91 80.08 80.08 80.08 80.08 80.08
Depreciation 2,847.4 2,635.7 2,703.6 2,694.5 1,262.1 2,643.8 2,653.5 2,663.2 2,673.0 2,682.8
Depreciation, % 49.47 57.2 52.84 50.92 22.3 46.55 46.55 46.55 46.55 46.55
EBIT 1,789.4 776.4 1,755.1 1,894.8 2,807.0 1,904.4 1,911.4 1,918.5 1,925.5 1,932.6
EBIT, % 31.09 16.85 34.3 35.81 49.6 33.53 33.53 33.53 33.53 33.53
Total Cash 669.4 1,011.6 533.9 621.6 2,169.0 1,068.9 1,072.8 1,076.7 1,080.7 1,084.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 832.2 1,236.7 919.7 823.5 826.1
Account Receivables, % 14.46 26.84 17.97 15.56 14.6
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0.0000000217 0 0 0 0.00000000434 0.00000000434 0.00000000434 0.00000000434 0.00000000434
Accounts Payable 1,390.7 1,311.9 1,433.2 1,491.6 1,682.1 1,574.0 1,579.7 1,585.5 1,591.4 1,597.2
Accounts Payable, % 24.16 28.47 28.01 28.19 29.73 27.71 27.71 27.71 27.71 27.71
Capital Expenditure -876.0 -484.1 -527.9 -650.0 -793.3 -708.2 -710.8 -713.4 -716.1 -718.7
Capital Expenditure, % -15.22 -10.51 -10.32 -12.28 -14.02 -12.47 -12.47 -12.47 -12.47 -12.47
Tax Rate, % 15.41 15.41 15.41 15.41 15.41 15.41 15.41 15.41 15.41 15.41
EBITAT 1,532.9 678.7 1,448.5 1,598.6 2,374.6 1,617.2 1,623.1 1,629.1 1,635.0 1,641.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 4,062.8 2,346.9 4,062.5 3,797.6 3,031.4 3,254.7 3,567.8 3,580.9 3,594.0 3,607.2
WACC, % 9.92 9.94 9.87 9.9 9.9 9.9 9.9 9.9 9.9 9.9
PV UFCF
SUM PV UFCF 13,325.2
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 3,752
Terminal Value 63,531
Present Terminal Value 39,619
Enterprise Value 52,944
Net Debt 25,349
Equity Value 27,595
Diluted Shares Outstanding, MM 327
Equity Value Per Share 84.44

What You Will Get

  • Real Simon Property Group Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Simon Property Group’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Simon Property Group, Inc. (SPG).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable input parameters.
  • Customizable Forecast Assumptions: Alter growth rates, capital expenditures, and discount rates as needed.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Simon Property Group, Inc. (SPG).
  • Interactive Dashboard and Charts: Visual representations that encapsulate key valuation metrics for straightforward analysis.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Simon Property Group, Inc. (SPG)'s preloaded data.
  • 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
  • 3. Instant Results: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
  • 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
  • 5. Make Informed Decisions: Present detailed valuation insights to back up your strategic choices.

Why Choose This Calculator for Simon Property Group, Inc. (SPG)?

  • All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for real estate investments.
  • Flexible Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
  • In-Depth Analysis: Automatically computes Simon Property Group’s intrinsic value and Net Present Value.
  • Preloaded Information: Historical and projected data provide reliable starting points for analysis.
  • High-Quality Standards: Perfect for real estate analysts, investors, and business advisors.

Who Should Use This Product?

  • Real Estate Investors: Develop comprehensive and accurate valuation models for property analysis.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
  • Consultants and Advisors: Offer clients precise valuation insights for Simon Property Group, Inc. (SPG).
  • Students and Educators: Utilize real-world data to practice and teach financial modeling in real estate.
  • Market Analysts: Gain insights into how real estate investment trusts (REITs) like Simon Property Group, Inc. (SPG) are valued in the market.

What the Template Contains

  • Pre-Filled Data: Includes Simon Property Group’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 Simon Property Group’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.