Equity Residential Financial Model
Real Estate Company Financials Example (Free Excel Download)
Equity Residential (EQR) is one of the largest publicly traded Real Estate Investment Trusts (REITs) in the United States, focused on the acquisition, development, and management of high-quality multi-family residential properties.
professionals from Deloitte
Used by professionals from
About this model
This model forecasts Net Operating Income (NOI), Funds From Operations (FFO), and Adjusted Funds From Operations (AFFO) to determine the Net Asset Value (NAV) and dividend sustainability of Equity Residential for an equity research analyst or dedicated REIT investor.
- Equity Residential (EQR) is one of the largest publicly traded Real Estate Investment Trusts (REITs) in the United States, focused on the acquisition, development, and management of high-quality multi-family residential properties.
- Business Segments: The company operates as a single segment but reports NOI geographically. Key contributors include Southern California (~25% of NOI), Washington D.C. (~15%), San Francisco (~15%), New York (~14%), Boston (~11%), and Seattle (~10%), alongside "Expansion Markets" like Atlanta, Denver, and Dallas/Ft. Worth (~7% combined).
- Key Geographies: 100% United States, heavily concentrated in coastal, urban, and high-density suburban gateway markets.
- Business Model Type: Asset-heavy real estate owner/operator. Revenue is generated through short-term (typically 12-month) residential leases.
- Competitive Position: EQR is an S&P 500 constituent and a dominant player in the multi-family REIT space, competing with AvalonBay Communities (AVB), Camden Property Trust (CPT), UDR, and Mid-America Apartment Communities (MAA). It targets an affluent demographic (average household income of ~$167,000).
- Recent Major Events: EQR is executing a "portfolio optimization strategy," actively selling older assets in highly regulated coastal markets to fund acquisitions in Sunbelt "Expansion Markets" (e.g., acquiring 795 units in Atlanta and Denver in Q4 2024 for $274.3 million at a 5.2% cap rate).
The downloadable Equity Residential 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 & AssumptionsEquity Residential financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Income before income and other taxes, income (loss) from investments in unconsolidated entities and net gain (loss) on sales of land parcels | $1.40B | $812.9M | $875.0M | $1.08B | $1.17B |
| Other expenses | -$19.3M | -$13.7M | -$29.4M | -$74.1M | -$60.5M |
| Total expenses | $1.84B | $1.92B | $2.00B | $2.11B | $2.22B |
| Net income | $1.33B | $776.9M | $835.4M | $1.04B | $1.12B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Equity Residential
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Rental Income
- Segment Name: Rental Income (reported on a Same-Store and Non-Same-Store basis).
- Revenue Driver Formula: `Total Units x Physical Occupancy % x Average Monthly Rental Rate x 12`
- Historical Growth Rate: 2.5% - 10.6% (highly volatile during/post-COVID; 2024 Same-Store revenue grew 3.0%).
- Key Growth Levers and Headwinds: Driven by "Blended Rate" growth (new lease rates + renewal rates). Headwinds include new multi-family supply in Sunbelt markets and regulatory rent control measures in coastal markets (e.g., California, New York).
- Pricing Dynamics: Spot pricing via algorithmic revenue management systems (e.g., LRO/YieldStar). Leases are typically 12 months, allowing the portfolio to re-price to market relatively quickly.
- Revenue Recognition Notes: Recognised straight-line over the lease term. Concessions (e.g., "one month free") are amortised over the life of the lease, creating a variance between cash rent and GAAP rent.
- Seasonality: Q2 and Q3 are the strongest leasing seasons (highest traffic and rent growth), while Q1 and Q4 see lower turnover and flat/declining sequential rent growth.
Other Property Income
- Segment Name: Other Property Income (Utility recoveries, parking, pet fees, early lease termination fees).
- Revenue Driver Formula: `Total Units x Other Income per Unit`
- Historical Growth Rate: 3.0% - 5.0% CAGR.
- Pricing Dynamics: Highly correlated with occupancy and inflation (utility pass-throughs).
Cost Structure
Variable Costs / COGS (Property Operating Expenses)
- Line-by-line breakdown: Real estate taxes (largest expense), on-site payroll, utilities, repairs and maintenance (R&M), and property insurance.
- Gross Margin Range: In REIT terminology, this is the NOI Margin (Net Operating Income / Total Property Revenues), which typically ranges from 66% to 69%.
- Key input costs and commodity exposures: Local property tax assessments, utility rates (gas/electric), and property insurance premiums (which have spiked due to climate risks).
- How COGS scales with revenue: High operating leverage. Property taxes and insurance are fixed in the short term; payroll and R&M scale slightly with occupancy but are largely fixed per property.
Operating Expenses (Corporate)
- Property Management: Regional supervision and corporate property management overhead (typically 2.5% - 3.5% of revenue).
- General & Administrative (G&A): Executive compensation, legal, public company costs (typically 1.5% - 2.0% of revenue).
- Depreciation & Amortisation: Massive non-cash expense representing 25% - 30% of revenue. Real estate is depreciated over 27.5 to 30 years.
- Stock-Based Compensation: Included in G&A; relatively small but material for AFFO adjustments.
Margin Profile
- NOI Margin: 66% - 69% (stable, slightly pressured by insurance and tax inflation).
- EBITDAre Margin: 60% - 63%.
- Net Margin: Highly distorted by real estate depreciation and gains on property sales; not a useful metric for REITs.
Balance Sheet Structure
- Total Assets: ~$21 - $22 billion (historical cost basis; fair market value is significantly higher).
- Key Asset Categories: Investment in Real Estate (Land, Depreciable Property, Projects under development), Cash and Cash Equivalents.
- Goodwill & Intangibles: Minimal. REITs acquire hard assets.
- Working Capital Profile:
- DSO / DIO / DPO: Not applicable in the traditional sense. Rent is paid in advance on the 1st of the month.
- Net working capital: Typically negative. The company collects cash upfront and pays vendors/taxes in arrears. This is a structural advantage.
- PP&E: Represents the core business. Land is not depreciated; buildings are depreciated over ~30 years; furniture/fixtures over 5-10 years.
- Right-of-use assets: Immaterial for EQR (they own the vast majority of their land in fee simple).
Capital Expenditure & Investment
- Capex as % of revenue: 5% - 8% in total.
- Maintenance capex vs. growth capex:
- *Maintenance (Recurring) Capex:* ~$1,000 - $1,500 per unit annually (carpet, paint, appliances).
- *Value-Add / Renovation Capex:* Kitchen/bath upgrades designed to achieve a 10%+ return on cost via higher rents.
- *Development Capex:* Ground-up construction (currently a smaller portion of EQR's capital allocation).
- M&A pattern: Asset recycler. EQR sells older assets in low-growth/high-capex markets and uses 1031 exchanges to buy newer assets in expansion markets.
- Typical acquisition multiple paid: 5.0% - 5.5% Capitalisation Rate (NOI / Purchase Price).
Debt & Capital Structure
- Total debt: ~$7.5 - $8.0 billion.
- Debt/EBITDA ratio: Target is 4.0x - 5.0x (currently ~4.2x).
- Credit rating: A- / A3 (one of the highest rated apartment REITs).
- Key debt instruments: Unsecured notes/bonds (majority of capital structure), commercial paper program, and a revolving credit facility. Very little secured mortgage debt.
- Maturity profile: Well-laddered, average maturity of 7-8 years.
- Interest rate profile: ~90%+ fixed rate. Weighted average interest rate is ~3.8% - 4.2%.
- Covenants: Standard unsecured REIT covenants (Total Debt to Total Assets < 60%, Secured Debt to Total Assets < 40%, Fixed Charge Coverage > 1.5x).
- Share repurchase programme: Active when stock trades at a deep discount to NAV (e.g., repurchased $500M in late 2024/early 2025).
- Dividend policy: Payout ratio targeted at ~70% of Normalized FFO. 2025 dividend is $2.77 per share.
Cash Flow Characteristics
- Operating cash flow conversion: Very high. OCF closely tracks AFFO.
- Free cash flow margin: AFFO margin is typically 45% - 50% of revenue.
- Major non-cash items: Real estate depreciation (massive add-back), straight-line rent adjustments, stock-based compensation.
- Working capital cash flow impact: Minimal year-over-year impact.
- Capex intensity: Low maintenance capex relative to asset value, but high absolute dollars required to keep Class A properties competitive.
- Cash tax rate: ~0%. As a REIT, EQR pays no federal income tax provided it distributes at least 90% of its taxable income to shareholders.
Sheet Structure
- Cover & Dashboard: Model outputs, target price, NAV premium/discount, and implied cap rate.
- Assumptions: Hardcoded drivers for macro (inflation), segment-level rent growth, occupancy, and expense growth.
- Portfolio & Unit Count: Roll-forward of apartment units (Beginning Units + Acquisitions + Developments - Dispositions = Ending Units). Broken out by Established vs. Expansion markets.
- Revenue Schedule: Calculates Rental Income and Other Income. Splits portfolio into "Same-Store" (owned for >1 year) and "Non-Same-Store" (recent acquisitions/developments).
- Property Expenses: Forecasts Real Estate Taxes, Payroll, Utilities, R&M, and Insurance. Calculates property-level NOI.
- Consolidated Income Statement: Bridges NOI to Net Income (deducts corporate G&A, property management, depreciation, and interest expense).
- Balance Sheet: Tracks Gross Real Estate, Accumulated Depreciation, Debt, and Equity.
- Debt & Interest Schedule: Tranches of unsecured notes, commercial paper, interest rate assumptions, and capitalised interest.
- Cash Flow Statement: Standard 3-statement OCF, CFI, CFF.
- FFO & AFFO Reconciliation: The most critical sheet. Bridges Net Income to FFO, Normalized FFO, and AFFO.
- NAV & Valuation: Calculates Net Asset Value based on forward 12-month NOI and market cap rates, plus a Dividend Discount Model (DDM).
Key Financial Relationships
- `Ending Units = Beginning Units + Acquired Units + Developed Units - Sold Units`
- `Average Operating Units = (Beginning Units + Ending Units) / 2` (Adjusted for timing of mid-year acquisitions).
- `Same-Store Rental Income = Prior Year Same-Store Rental Income x (1 + Blended Rate Growth)`
- `Total Property Revenue = Rental Income + Other Property Income`
- `Total Property Operating Expenses = Real Estate Taxes + Payroll + Utilities + R&M + Insurance`
- `Net Operating Income (NOI) = Total Property Revenue - Total Property Operating Expenses`
- `NOI Margin = Net Operating Income / Total Property Revenue`
- `Gross Real Estate Asset Value = Prior Gross Real Estate + Acquisitions + Development Capex + Value-Add Capex - Cost Basis of Dispositions`
- `FFO = Net Income + Real Estate Depreciation & Amortisation - Gains on Sales of Real Estate`
- `Normalized FFO = FFO + Debt Extinguishment Costs + Deal/Integration Expenses`
- `AFFO = Normalized FFO - Maintenance Capital Expenditures - Straight-Line Rent Adjustments`
- `Implied Cap Rate = Forward 12-Month NOI / (Market Capitalisation + Total Debt - Cash)`
- `Net Asset Value (NAV) = (Forward 12-Month NOI / Target Market Cap Rate) - Net Debt`
Cross-Sheet Dependencies
- Portfolio & Unit Count feeds the Revenue Schedule (unit volumes) and Balance Sheet (acquisitions/dispositions drive gross real estate).
- Revenue Schedule and Property Expenses feed the Consolidated Income Statement to calculate NOI.
- Consolidated Income Statement feeds FFO & AFFO Reconciliation (Net Income is the starting point) and Balance Sheet (Retained Earnings).
- Debt & Interest Schedule feeds the Consolidated Income Statement (Interest Expense) and Balance Sheet (Debt balances).
- FFO & AFFO Reconciliation feeds the NAV & Valuation sheet (AFFO drives dividend capacity and DDM valuation).
- *Circularity Risk:* Interest expense depends on average debt balances, which depends on cash flow shortfalls (revolver draw), which depends on interest expense. A circuit breaker (toggle) must be included in the Debt Schedule.
Sign Convention
- Revenues/Income: Positive.
- Expenses/Costs: Positive in their specific schedules, subtracted in aggregation formulas (e.g., `Revenue - Expenses`).
- Assets: Positive.
- Liabilities/Equity: Positive.
- Cash Flow Statement: Cash inflows are positive; cash outflows (capex, dividends, debt paydown) are negative.
- Contra-Assets (Accumulated Depreciation): Positive balance on the balance sheet, subtracted from Gross Assets to yield Net Assets.
Things Most Likely to Go Wrong
- Forgetting the FFO Add-Backs: The builder must add back *only* real estate depreciation to Net Income to get FFO. Corporate depreciation (e.g., office software) is not added back.
- Gains on Sale Distortion: EQR frequently sells properties. The GAAP gain on sale must be excluded from FFO, otherwise earnings will look artificially inflated in disposition-heavy years.
- Same-Store vs. Non-Same-Store Mismatch: Revenue growth assumptions (e.g., 3.0%) apply *only* to the Same-Store pool. Non-Same-Store revenue must be calculated based on the absolute unit count and average rent of newly acquired/developed properties.
- Capitalised Interest: During development, interest is capitalised into the asset base rather than expensed. This must be modelled correctly or interest expense will be overstated.
- Property Tax Reassessments: When EQR acquires a property (especially in California due to Prop 13), property taxes jump significantly. The model must apply a higher tax expense ratio to newly acquired units.
- Straight-Line Rent: Concessions create a wedge between GAAP revenue and cash revenue. AFFO must deduct the non-cash straight-line rent adjustment.
- Share Count Creep/Shrink: EQR has an active ATM (At-The-Market) equity program and a share repurchase program. FFO *per share* is highly sensitive to the weighted average diluted share count.
- Maintenance vs. Value-Add Capex: Only maintenance capex is deducted to calculate AFFO. Value-add capex is considered growth capital and is excluded from AFFO deductions.
Validation Checks
- "NOI Margin should be consistently between 66.0% and 69.0%; flag if outside this band."
- "FFO per share must be greater than the Dividend per share (Payout ratio < 100%)."
- "Total Assets must equal Total Liabilities + Shareholders' Equity in every period."
- "Debt to EBITDAre should remain between 4.0x and 5.0x based on management targets."
- "Implied Cap Rate should reconcile to the 5.0% - 6.0% range observed in recent private market transactions."
- "Same-Store Revenue Growth should not exceed 5.0% in a normalised environment (flag if >5%)."
- "Effective tax rate should be exactly 0% (REIT status maintained)."
- "Maintenance Capex per unit should be between $1,000 and $1,500 annually."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Same-Store Revenue Growth | 2.75 | % | Midpoint of management's 2025 guidance (2.25% - 3.25%). |
| Same-Store Expense Growth | 3.00 | % | Normalised inflationary growth for taxes, insurance, and payroll. |
| Physical Occupancy | 96.6 | % | Actual Q4 2024 reported occupancy. |
| Average Monthly Rent | 3,050 | $ | Approximate blended rent across EQR's coastal/urban portfolio. |
| Property Management Expense | 3.0 | % of Rev | Historical average for corporate property management overhead. |
| G&A Expense | 1.8 | % of Rev | Historical average for executive and public company costs. |
| Maintenance Capex per Unit | 1,200 | $ | Standard run-rate for Class A multi-family upkeep. |
| Acquisition Cap Rate | 5.2 | % | Actual weighted average cap rate on Q4 2024 acquisitions. |
| Disposition Cap Rate | 5.0 | % | EQR typically sells older assets at slightly lower cap rates to fund higher-yielding Sunbelt acquisitions. |
| Target Debt / EBITDA | 4.5 | x | Midpoint of management's leverage target. |
| Weighted Average Interest Rate | 4.1 | % | Reflects current fixed-rate debt stack and recent refinancing rates. |
| Annual Dividend per Share | 2.77 | $ | Actual declared 2025 dividend (2.6% increase from 2024). |
| Target Valuation Cap Rate | 5.5 | % | Reasonable market cap rate for NAV calculation in the current interest rate environment. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K). EQR Investor Relations website (specifically the Q4 2024 Earnings Release and February 2025 Investor Day Presentation).
- Key Peers: AvalonBay Communities (AVB), Camden Property Trust (CPT), UDR Inc. (UDR), Mid-America Apartment Communities (MAA), Essex Property Trust (ESS).
- Industry Data: RealPage (for multi-family rent and occupancy data), CoStar (for submarket supply/demand and cap rate data), NAREIT (National Association of Real Estate Investment Trusts) for industry-wide FFO benchmarks.
- Consensus Estimates: Bloomberg, FactSet, or S&P Capital IQ for forward FFO and NAV estimates.
Sources
- Equity Residential Q4 2024 Earnings Release (February 3, 2025) - https://investors.equityapartments.com
- Equity Residential Q4 2024 Management Presentation (February 4, 2025)
- Equity Residential 2024 Annual Report / Form 10-K (Filed February 2025)
- Equity Residential 2025 Investor Day Announcement and Materials (February 2025)
Do more with the Equity Residential model
Frequently asked
What kind of properties does Equity Residential own?+
Equity Residential (EQR) is a Real Estate Investment Trust (REIT) focused on the acquisition, development, and management of high-quality multi-family residential properties. Its portfolio is heavily concentrated in coastal, urban, and high-density suburban gateway markets across the United States.
How does Equity Residential generate revenue?+
Equity Residential generates revenue primarily through short-term residential leases, typically 12 months in duration. The company operates as an asset-heavy real estate owner and operator, with revenue stemming from its extensive portfolio of multi-family properties.
What is Equity Residential's typical capital expenditure as a percentage of revenue?+
Equity Residential's total capital expenditure typically ranges from 5% to 8% of its revenue. This includes maintenance capex for recurring unit improvements, value-add renovations designed to increase rents, and development capex for new construction.
What key metrics does the Equity Residential financial model forecast?+
The Equity Residential financial model forecasts Net Operating Income (NOI), Funds From Operations (FFO), and Adjusted Funds From Operations (AFFO). These metrics are crucial for determining the Net Asset Value (NAV) and assessing the sustainability of dividends for investors.
Can I download an Excel financial model for Equity Residential?+
Yes, an Excel financial model for Equity Residential is available for download. This model provides forecasts for the company's financial performance from FY2026 through FY2030, serving as a tool for equity research analysts and dedicated REIT investors.
Where are Equity Residential's primary geographic markets?+
Equity Residential's key geographic contributors to Net Operating Income include Southern California, Washington D.C., San Francisco, New York, Boston, and Seattle. The company also has expansion markets such as Atlanta, Denver, and Dallas/Ft. Worth, comprising about 7% of NOI combined.
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.
