Simon Property Group Financial Model
Real Estate Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
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.
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.
The downloadable Simon Property Group financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsSimon Property Group financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $5.12B | $5.29B | $5.66B | $5.96B | $6.36B |
| Total operating expenses | $2.70B | $2.71B | $2.85B | $2.87B | $3.19B |
| Operating income | $2.41B | $2.58B | $2.81B | $3.09B | $3.18B |
| Net income | $2.57B | $2.45B | $2.62B | $2.73B | $5.36B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Simon Property Group
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
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
- Assumptions: Hardcoded drivers including occupancy rates, base minimum rent per square foot, retailer sales per square foot, capitalisation rates, and debt interest rates.
- 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.
- 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.
- 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.
- Balance Sheet: Assets including Investment properties at cost, Accumulated depreciation, Cash, and Investments in unconsolidated entities. Liabilities including Mortgages, Unsecured notes, and Accounts payable.
- 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).
- Debt Schedule: Tranche-by-tranche breakdown of unsecured notes and mortgages, calculating weighted average interest expense and tracking maturity walls.
- 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.
- Returns & Dividends: Tracks dividend per share, payout ratio against FFO, and implied dividend yield.
Key Financial Relationships
- `Lease Income = (Total Gross Leasable Area x Occupancy Percentage x Base Minimum Rent per Square Foot) + Tenant Reimbursements + Overage Rent`
- `Total Revenue = Lease Income + Management Fees and Other Revenues`
- `Property Net Operating Income = Lease Income - Property Operating Expenses - Real Estate Taxes - Repairs and Maintenance - Advertising and Promotion`
- `Net Operating Income Margin = Property Net Operating Income / Lease Income`
- `Real Estate FFO = Net Income + Depreciation and Amortisation - Gain on Disposal of Real Estate + Unrealised Losses on Publicly Traded Equity Instruments`
- `AFFO = Real Estate FFO - Maintenance Capital Expenditures - Tenant Allowances - Straight-Line Rent Adjustments`
- `Interest Expense = Average Total Debt Balance x Weighted Average Interest Rate`
- `Net Debt = Total Debt - Cash and Cash Equivalents`
- `Implied Real Estate Value = Forward 12-Month Property Net Operating Income / Blended Capitalisation Rate`
- `Net Asset Value = Implied Real Estate Value + Investments in Unconsolidated Entities + Cash - Total Debt`
- `Net Asset Value per Share = Net Asset Value / Diluted Shares Outstanding`
- `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
Do more with the Simon Property Group model
Frequently asked
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.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Real Estate Company Financial Models
Browse another company in the same sector.
Alexandria Real Estate Equities
Alexandria Real Estate Equities (ARE) is a pioneering, internally managed Real Estate Investment Trust (REIT) focused exclusively on collaborative life science, agtech, and technology campuses.
AvalonBay Communities
AvalonBay Communities, Inc.
BXP
BXP is the largest publicly traded developer, owner, and manager of premier Class A office space in the United States, operating as a fully integrated real estate investment trust.
CBRE Group
CBRE Group is the world's largest commercial real estate services and investment firm, providing a broad suite of services to occupiers, owners, lenders, and investors.
Camden Property Trust
Camden Property Trust is an S&P 500 real estate investment trust (REIT) primarily engaged in the ownership, management, development, redevelopment, acquisition, and construction of multifamily apartment communities.
Digital Realty
Digital Realty Trust, Inc.
Healthpeak Properties
Healthpeak Properties, Inc.
Equinix
Equinix is the world's largest digital infrastructure company, operating as a real estate investment trust (REIT) that provides global colocation, interconnection, and managed IT services.
Explore more Real Estate financial model templates.
