# Simon Property Group (SPG) Financial Model

Free Excel 3-statement financial model and company analysis for Simon Property Group.

- Canonical: https://finamodel.com/companies/simon-property-group
- Industry: Real Estate
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/SPG.xlsx

## Model Purpose

This model forecasts Net Asset Value and Funds From Operations for Simon Property Group to determine whether equity investors should buy, hold, or sell the stock based on its implied valuation, cash flow generation, and dividend yield.

## Company Overview

Simon Property Group is a self-administered and self-managed real estate investment trust that owns, develops, and manages premier shopping, dining, entertainment, and mixed-use destinations. The company operates globally, providing community gathering places that generate billions in annual retail sales.

Business segments include U.S. Malls and Premium Outlets, The Mills, Taubman Realty Group, and International Properties, alongside a portfolio of Other Platform Investments in retail brands. The primary geography is the United States, with additional exposure to Europe and Asia through joint ventures and investments like Klépierre. The business model is an asset-heavy retail landlord structure, generating revenue primarily through long-term lease agreements, tenant reimbursements, and percentage rents based on retailer sales. Simon holds a dominant competitive position as the largest mall operator in the United States and an S&P 100 company, boasting high-quality Class A assets. A recent major event includes the fourth quarter 2025 acquisition of the remaining interest in Taubman Realty Group, which resulted in a $2.89 billion non-cash gain from remeasuring the previously held equity interest to fair value.

## Revenue Deep Dive



### Lease Income

- Segment name: Lease income
- Revenue driver formula: (Total Gross Leasable Area x Occupancy Percentage x Base Minimum Rent per Square Foot) + Tenant Reimbursements + Overage Rent
- Historical growth rate: 3% to 5% CAGR
- Key growth levers and headwinds: Occupancy recovery (reaching 96.4% at the end of 2025), positive leasing spreads on renewals, and retailer sales per square foot (reaching $799 in 2025). Headwinds include retail bankruptcies and store fleet rationalisation.
- Pricing dynamics: Contractual base rent with built-in annual escalators, plus variable overage rent tied directly to tenant sales performance.
- Revenue recognition notes: Base rent is recognised on a straight-line basis over the lease term, which creates a non-cash variance between billed rent and reported revenue.
- Seasonality: The fourth quarter is historically the strongest due to holiday shopping driving higher retailer sales, which directly boosts overage (percentage) rent.

### Management Fees and Other Revenues

- Segment name: Management fees and other revenues
- Revenue driver formula: Assets Under Management in Unconsolidated Joint Ventures x Management Fee Rate
- Historical growth rate: 1% to 3% CAGR
- Key growth levers and headwinds: Driven by the formation of new joint ventures and the operational performance of unconsolidated properties.
- Pricing dynamics: Contractual fee structures based on property revenues or asset values.
- Revenue recognition notes: Recognised over time as management services are rendered.
- Seasonality: Generally stable across quarters, with slight uplifts in the fourth quarter mirroring joint venture revenue seasonality.

## Cost Structure



### Variable Costs / COGS

- Line-by-line breakdown: Property operating expenses, real estate taxes, repairs and maintenance, and advertising and promotion.
- Gross margin range: Net Operating Income margin typically ranges from 72% to 75%.
- Key input costs and commodity exposures: Utility costs, security labour, and local property tax assessments.
- How COGS scales with revenue: Highly fixed cost base. Real estate taxes and maintenance must be paid regardless of occupancy, creating significant operating leverage when occupancy increases.

### Operating Expenses

- R&D: Not applicable for this real estate business.
- SG&A: Reported as "Home and regional office costs" and "General and administrative". Driven primarily by corporate headcount, executive compensation, and legal fees.
- Depreciation & Amortisation: Massive non-cash expense representing 20% to 25% of revenue, split between building depreciation, tenant improvements, and leasing commissions.
- Stock-Based Compensation: Minimal relative to revenue, typically less than 1%.
- Restructuring / one-time charges: Infrequent at the property level, but the company occasionally records impairment charges on unconsolidated retail investments.

### Margin Profile

- Gross margin (NOI Margin): 72% to 75%.
- EBITDA margin: 65% to 68%.
- Operating margin: 45% to 50% (heavily burdened by non-cash depreciation).
- Net margin: Highly volatile due to mark-to-market adjustments on equity investments (e.g., 2025 net margin was artificially inflated by a $2.89 billion non-cash gain).
- Margin trend: Stable to slightly expanding as occupancy recovers and tenant reimbursements cover inflationary increases in property operating expenses.

## Balance Sheet Structure

- Total assets: Approximately $30 billion to $35 billion on a historical cost basis.
- Key asset categories: Investment properties (land, buildings, equipment) represent the vast majority of assets. Investments in unconsolidated entities (joint ventures, Klépierre, retail brands) are also highly material.
- Goodwill & intangibles as % of total assets: Less than 5%, primarily related to acquired lease intangibles.
- Working capital profile:
  - Days Sales Outstanding (DSO): 10 to 15 days (rent is typically billed and collected in advance).
  - Days Inventory Outstanding (DIO): Not applicable.
  - Days Payable Outstanding (DPO): 30 to 45 days.
  - Net working capital as % of revenue: Typically negative.
  - Is working capital positive or negative? Negative working capital is a structural advantage, as the company collects rent before paying property taxes and maintenance vendors.
- PP&E: Investment properties are depreciated over 15 to 40 years for buildings and improvements. Capex is split between maintenance (tenant allowances) and growth (redevelopments).
- Right-of-use assets / operating leases: Immaterial, as the company is the lessor, not the lessee, for the vast majority of its footprint.

## Capital Expenditure & Investment

- Capex as % of revenue: 10% to 15%.
- Maintenance capex vs. growth capex: Approximately 30% maintenance (tenant improvements, roof repairs) and 70% growth (mixed-use densification, adding hotels or residential units to existing malls).
- Major capex programmes underway or planned: Redevelopment of former department store boxes into lifestyle, dining, and entertainment precincts.
- Capitalised software / development costs if material: Immaterial.
- M&A pattern: Opportunistic acquirer of distressed retail brands (SPARC Group, J.C. Penney) to maintain mall occupancy, alongside strategic acquisitions of rival mall portfolios (Taubman Realty Group).
- Typical acquisition multiple paid: Real estate acquisitions are typically executed at 5.5% to 7.0% capitalisation rates.

## Debt & Capital Structure

- Total debt: Approximately $25 billion to $28 billion.
- Debt/EBITDA ratio: 5.5x to 6.0x (management target is typically around 5.5x).
- Credit rating: A- (S&P) / A3 (Moody's), making it one of the highest-rated real estate investment trusts.
- Key debt instruments: Senior unsecured notes, mortgage debt secured by specific properties, and a multi-billion dollar unsecured revolving credit facility.
- Maturity profile: Well-laddered with average maturity typically exceeding 6 years.
- Interest rate profile: Predominantly fixed-rate debt (over 85%), with a weighted average interest rate historically between 3.5% and 4.5%.
- Covenants: Standard unsecured bond covenants including total debt to total assets (must be under 60%) and secured debt to total assets (must be under 40%).
- Share repurchase programme: Active opportunistically, though the primary return of capital is through dividends.
- Dividend policy: REIT regulations require distributing at least 90% of taxable income. The company targets a payout ratio of 60% to 70% of Funds From Operations, yielding approximately 4% to 6%.

## Cash Flow Characteristics

- Operating cash flow conversion: Operating Cash Flow to Net Income is typically greater than 1.5x, driven by massive non-cash depreciation add-backs.
- Free cash flow margin: Adjusted Funds From Operations margin typically ranges from 50% to 55% of revenue.
- Major non-cash items that bridge net income to OCF: Real estate depreciation, straight-line rent adjustments, and unrealised gains or losses on equity investments.
- Working capital cash flow impact: Neutral to slightly positive source of cash due to advance rent collections.
- Capex intensity: Moderate to high, as retail properties require constant reinvestment and tenant allowances to remain competitive.
- Cash tax rate vs. GAAP effective tax rate: Effectively 0% at the corporate level due to REIT tax status, provided the company distributes its taxable income as dividends.

## Sheet Structure

1. **Assumptions**: Hardcoded drivers including occupancy rates, base minimum rent per square foot, retailer sales per square foot, capitalisation rates, and debt interest rates.
2. **Portfolio Metrics**: Row-level detail tracking Gross Leasable Area, occupancy percentage, and base rent per square foot broken out by U.S. Malls and Premium Outlets, The Mills, and Taubman Realty Group.
3. **Income Statement**: Revenue lines for Lease income and Management fees. Expense lines for Property operating, Real estate taxes, Repairs and maintenance, Advertising and promotion, Provision for credit losses, Home and regional office costs, and Depreciation and amortisation.
4. **FFO & AFFO Reconciliation**: Starts with Net Income, adds back Depreciation and amortisation, deducts Gains on sale of real estate, and adjusts for Unrealised losses on equity investments to calculate Real Estate FFO. Deducts maintenance capex and straight-line rent to calculate AFFO.
5. **Balance Sheet**: Assets including Investment properties at cost, Accumulated depreciation, Cash, and Investments in unconsolidated entities. Liabilities including Mortgages, Unsecured notes, and Accounts payable.
6. **Cash Flow Statement**: Standard three-section layout bridging Net Income to Operating Cash Flow, Cash from Investing (capex, acquisitions), and Cash from Financing (debt issuance, dividends).
7. **Debt Schedule**: Tranche-by-tranche breakdown of unsecured notes and mortgages, calculating weighted average interest expense and tracking maturity walls.
8. **NAV Valuation**: Applies an implied capitalisation rate to forward 12-month Net Operating Income, adds the value of unconsolidated joint ventures and cash, and subtracts total debt to arrive at Net Asset Value per share.
9. **Returns & Dividends**: Tracks dividend per share, payout ratio against FFO, and implied dividend yield.

## Key Financial Relationships

1. `Lease Income = (Total Gross Leasable Area x Occupancy Percentage x Base Minimum Rent per Square Foot) + Tenant Reimbursements + Overage Rent`
2. `Total Revenue = Lease Income + Management Fees and Other Revenues`
3. `Property Net Operating Income = Lease Income - Property Operating Expenses - Real Estate Taxes - Repairs and Maintenance - Advertising and Promotion`
4. `Net Operating Income Margin = Property Net Operating Income / Lease Income`
5. `Real Estate FFO = Net Income + Depreciation and Amortisation - Gain on Disposal of Real Estate + Unrealised Losses on Publicly Traded Equity Instruments`
6. `AFFO = Real Estate FFO - Maintenance Capital Expenditures - Tenant Allowances - Straight-Line Rent Adjustments`
7. `Interest Expense = Average Total Debt Balance x Weighted Average Interest Rate`
8. `Net Debt = Total Debt - Cash and Cash Equivalents`
9. `Implied Real Estate Value = Forward 12-Month Property Net Operating Income / Blended Capitalisation Rate`
10. `Net Asset Value = Implied Real Estate Value + Investments in Unconsolidated Entities + Cash - Total Debt`
11. `Net Asset Value per Share = Net Asset Value / Diluted Shares Outstanding`
12. `Dividend Payout Ratio = Total Dividends Paid / Real Estate FFO`

## Cross-Sheet Dependencies

The **Assumptions** sheet feeds the **Portfolio Metrics** sheet, which calculates the total square footage and occupied space. The **Portfolio Metrics** sheet drives the Lease income line on the **Income Statement**. The **Income Statement** generates Net Income, which is the starting point for the **FFO & AFFO Reconciliation** and the **Cash Flow Statement**. The **Debt Schedule** calculates interest expense, which feeds back into the **Income Statement**, creating a potential circularity if debt is balanced using a revolving credit facility tied to cash shortfalls. The **Income Statement** Net Operating Income feeds directly into the **NAV Valuation** sheet to determine the implied asset value. The **Cash Flow Statement** determines the ending cash balance, which flows to the **Balance Sheet** and the **NAV Valuation** sheet.

## Sign Convention

- Revenues, assets, and operational metrics (occupancy, square footage) are entered and displayed as positive numbers.
- Expenses, liabilities, and contra-assets (accumulated depreciation) are entered as negative numbers.
- Cash inflows are positive; cash outflows (capital expenditures, debt repayments, dividend payments) are negative.
- In formulas, sum a revenue (positive) and an expense (negative) to calculate profit. Do not subtract a negative number.

## Things Most Likely to Go Wrong

- Confusing GAAP Net Income with Funds From Operations. Net Income is heavily distorted by non-cash depreciation and mark-to-market equity gains, making FFO the only reliable metric for valuation and dividend coverage.
- Mishandling the fourth quarter 2025 Taubman Realty Group acquisition. The $2.89 billion non-cash gain must be excluded from FFO and operating cash flow calculations.
- Failing to separate maintenance capex from growth capex. Only maintenance capex should be deducted when bridging FFO to AFFO.
- Straight-line rent adjustments can artificially inflate Lease income in the early years of a lease. The model must deduct this non-cash revenue when calculating AFFO.
- Incorrectly consolidating joint ventures. Simon uses the equity method for many investments (like Klépierre), meaning their revenues do not appear on the consolidated top line, but their earnings appear below the operating line.
- Ignoring the seasonality of overage rent. Retailer sales spike in the fourth quarter, driving a disproportionate share of percentage rent in that period.
- Miscalculating Net Asset Value by applying the capitalisation rate to Net Income instead of Net Operating Income.
- Overlooking the impact of Other Platform Investments. Retail brand investments (SPARC, J.C. Penney) introduce retail operating volatility that behaves differently from traditional real estate lease income.

## Validation Checks

- Occupancy for U.S. Malls and Premium Outlets should cap at approximately 98%; flag if the model projects occupancy above this historical ceiling.
- Base minimum rent per square foot should grow at 2% to 4% annually; flag if growth exceeds 5% without a major redevelopment catalyst.
- Net Operating Income margin must remain within the 70% to 75% band; flag if expenses scale disproportionately to lease income.
- Real Estate FFO per share should be in the $12.00 to $13.50 range based on 2025 actuals.
- Debt to Net Operating Income should remain below 6.0x to align with the company's A- credit rating profile.
- The Balance Sheet must balance perfectly in every forecasted period (Total Assets + Total Liabilities + Equity = 0, assuming liabilities and equity are negative).
- Dividend payout ratio should remain between 60% and 75% of Real Estate FFO.
- Effective corporate tax rate should be 0%, as the company operates as a REIT.

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| U.S. Malls & Premium Outlets Occupancy | 96.4 | % | Actual reported occupancy at December 31, 2025. |
| Base Minimum Rent PSF | 60.97 | $ | Actual reported base rent at December 31, 2025. |
| Retailer Sales PSF | 799 | $ | Actual trailing 12-month sales at December 31, 2025. |
| Lease Income Growth Rate | 3.5 | % | Blended historical average of rent escalators and occupancy gains. |
| Property NOI Margin | 73.5 | % | Historical average reflecting fixed property costs against growing rent. |
| Maintenance Capex PSF | 1.50 | $ | Standard industry assumption for enclosed mall tenant allowances. |
| Weighted Average Interest Rate | 4.2 | % | Reflects the company's highly fixed, well-laddered debt profile. |
| Target Debt to EBITDA | 5.5 | x | Management's stated leverage target for maintaining A- credit rating. |
| Blended Capitalisation Rate | 6.0 | % | Standard market assumption for Class A mall and outlet valuations. |
| Dividend per Share | 8.25 | $ | Approximate annualised run-rate based on recent quarterly declarations. |
| Effective Tax Rate | 0.0 | % | Statutory benefit of maintaining Real Estate Investment Trust status. |
| Diluted Shares Outstanding | 379 | Millions | Approximate share count including operating partnership units. |

## Data Sources & Benchmarks

- SEC EDGAR: Source for the annual 10-K, quarterly 10-Q, and 8-K earnings releases.
- Investor Relations: Simon Property Group website for supplemental financial packages, which provide critical property-level NOI and occupancy metrics not fully detailed in the 10-K.
- Key Peers for Benchmarking: Macerich (MAC), Tanger (SKT), Kimco Realty (KIM), and Regency Centers (REG).
- Industry Data Sources: Green Street Advisors for mall capitalisation rates and asset valuations; ICSC (International Council of Shopping Centers) for broader retail foot traffic and sales trends.
- Consensus Estimates: FactSet or Bloomberg for forward FFO per share and Net Asset Value estimates.

## Sources

- Simon Property Group Q4 2025 Earnings Release (https://investors.simon.com/)
- Simon Property Group 2024 Annual Report on Form 10-K (https://www.sec.gov/edgar/browse/?CIK=1063761)
- U.S. Securities and Exchange Commission EDGAR Database (https://www.sec.gov/edgar/searchedgar/companysearch)

---

## Frequently asked questions

### What kind of company is Simon Property Group and what does it do?

Simon Property Group is a self-administered and self-managed real estate investment trust (REIT) that owns, develops, and manages premier shopping, dining, entertainment, and mixed-use destinations globally. It operates as the largest mall operator in the United States, providing community gathering places.

### How does Simon Property Group generate its revenue?

Simon Property Group primarily generates revenue through long-term lease agreements with tenants across its U.S. Malls, Premium Outlets, The Mills, and International Properties. Additional revenue streams include tenant reimbursements and percentage rents based on retailer sales.

### What is Simon Property Group's capital expenditure strategy?

Simon Property Group's capital expenditure typically ranges from 10% to 15% of revenue, with approximately 30% allocated to maintenance capex like tenant improvements and roof repairs. The remaining 70% is growth capex, focused on redevelopments, mixed-use densification, and adding hotels or residential units to existing malls.

### What is the purpose of the financial model for Simon Property Group?

The financial model for Simon Property Group forecasts Net Asset Value and Funds From Operations. Its purpose is to help equity investors determine whether to buy, hold, or sell the stock based on its implied valuation, cash flow generation, and dividend yield.

### Can I download an Excel financial model for Simon Property Group?

Yes, an Excel financial model for Simon Property Group is available for download. This model provides a forecast horizon from FY2026 to FY2030, allowing users to analyze key financial metrics and assumptions.

### What is Simon Property Group's working capital profile?

Simon Property Group typically exhibits negative net working capital as a percentage of revenue. This is a structural advantage for the company, as it generally collects rent from tenants in advance before paying property taxes and maintenance vendors.

[Interactive forecast calculator](https://finamodel.com/companies/simon-property-group/forecast)