Regency Centers logo
Regency Centers Financial Model

Real Estate Company Financials Example (Free Excel Download)

Regency Centers Corporation (Ticker: REG) is a preeminent national owner, operator, and developer of grocery-anchored shopping centres located in affluent suburban trade areas.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model projects Net Asset Value (NAV) and Funds From Operations (FFO) to help an equity research analyst determine the fair value of Regency Centers' shares and assess the sustainability of its dividend.

Regency Centers Corporation (Ticker: REG) is a preeminent national owner, operator, and developer of grocery-anchored shopping centres located in affluent suburban trade areas. The company focuses on necessity-driven retail, leasing space to highly productive grocers, restaurants, and service providers.

The company operates as a single reportable segment (Retail Real Estate), but revenue is driven by distinct streams including Base Rent (approximately 75% of total revenue), Tenant Recoveries (approximately 20%), and Percentage Rent/Other Income (approximately 5%). Regency has a national footprint with significant concentrations in Florida, California, and the Northeast. The business model is an asset-heavy Retail Real Estate Investment Trust (REIT) that generates predictable cash flows from long-term leases. Regency holds a strong competitive position as an S&P 500 member and one of the largest grocery-anchored REITs, competing directly with Federal Realty Investment Trust, Kite Realty Group, and Brixmor Property Group. A recent major event was the August 2023 acquisition of Urstadt Biddle Properties, which significantly expanded Regency's footprint in the Northeast United States.

The downloadable Regency Centers 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 & AssumptionsRegency Centers financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$1.17B$1.22B$1.32B$1.45B$1.55B
Other operating expenses-$5.8M-$6.2M-$9.5M-$10.9M-$8.8M
Total operating expenses$714.0M$751.7M$854.3M$940.1M$970.5M
Net income$361.4M$482.9M$364.6M$400.4M$527.5M

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
3.9%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
6.9%
D&A % of revenue
29.2%
Effective tax rate
0.9%
See 8 more
Capex % of revenue
16.8%
Net working capital % of revenue
0.0%
Other assets % of revenue
500.0%
Other liabilities % of revenue
81.9%
Annual debt paydown
5.0%
Interest rate on debt
4.0%
Dividend payout ratio
90.0%
Buybacks % of net income
44.7%

How to build a detailed financial model for Regency Centers

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Base Rent

  • Segment name: Base Rent
  • Revenue driver formula: Gross Leasable Area (GLA) x Occupancy Percentage x Average Annualised Base Rent per Square Foot
  • Historical growth rate: 3% to 5% CAGR
  • Key growth levers and headwinds: Driven by contractual rent steps, positive leasing spreads on renewals, and new development stabilisations. Headwinds include tenant bankruptcies and store closures.
  • Pricing dynamics: Contractual and long-term. Leases typically span 5 to 10 years with embedded annual rent escalators.
  • Revenue recognition notes: Recognised on a straight-line basis over the lease term, which creates a non-cash straight-line rent variance compared to actual cash collected.
  • Seasonality: Minimal seasonality due to the contractual nature of the leases.

Tenant Recoveries

  • Segment name: Tenant Recoveries
  • Revenue driver formula: (Property Operating Expenses + Real Estate Taxes) x Tenant Recovery Ratio
  • Historical growth rate: 4% to 6% CAGR, tracking inflation and property tax assessments.
  • Key growth levers and headwinds: Driven by inflation in operating costs and local tax rate increases. Headwinds occur if occupancy drops, leaving the landlord to absorb the unrecovered share of expenses.
  • Pricing dynamics: Contractual reimbursement based on the tenant's pro-rata share of the shopping centre's leased area.
  • Revenue recognition notes: Recognised in the same period the associated recoverable expenses are incurred.
  • Seasonality: Slightly higher in winter months for properties in colder climates due to snow removal costs.

Percentage Rent and Other Property Income

  • Segment name: Percentage Rent and Other Property Income
  • Revenue driver formula: (Tenant Sales Volume - Breakpoint) x Percentage Rent Rate + Parking/Temporary Tenant Income
  • Historical growth rate: Highly variable, generally 1% to 3% CAGR.
  • Key growth levers and headwinds: Driven by tenant sales performance and inflation. Headwinds include macroeconomic slowdowns reducing consumer spending.
  • Pricing dynamics: Variable based on individual tenant performance above negotiated sales thresholds.
  • Revenue recognition notes: Recognised only when the tenant's sales exceed the contractual breakpoint.
  • Seasonality: Highly seasonal, with the vast majority of percentage rent recognised in the fourth quarter following the holiday shopping season.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: Property Operating Expenses (common area maintenance, insurance, utilities, landscaping) and Real Estate Taxes.
  • Gross margin range: Same Property Net Operating Income (NOI) margin typically ranges from 70% to 74%.
  • Key input costs and commodity exposures: Labour for property maintenance, utility rates, and local municipal tax assessments.
  • How COGS scales with revenue: Step-function. Property expenses are largely fixed in the short term but scale up as new developments are added to the portfolio.

Operating Expenses

  • R&D: Not applicable for a Retail REIT.
  • SG&A: Reported as General and Administrative (G&A) expense. It covers corporate headcount, executive compensation, and IT systems. It typically runs between $90 million and $100 million annually.
  • Depreciation & Amortisation: Significant non-cash expense representing 25% to 30% of total revenues. It includes depreciation of buildings and improvements, and amortisation of in-place lease intangibles.
  • Stock-Based Compensation: Typically $15 million to $20 million annually, excluded from Core Operating Earnings.
  • Restructuring / one-time charges: Infrequent, though merger-related transition expenses occurred in 2023 and 2024 following the Urstadt Biddle acquisition.

Margin Profile

  • Gross margin: NOI margin is consistently 70% to 74%.
  • EBITDA margin: Operating EBITDAre margin ranges from 60% to 65%.
  • Margin trend: Stable to slightly expanding. The company benefits from operating leverage as contractual rent steps outpace fixed property costs.
  • Segment-level margins: Not disclosed separately, but the company reports Same Property NOI growth (typically 3% to 5% excluding termination fees).

Balance Sheet Structure

  • Total assets: Approximately $11.5 billion to $12.5 billion.
  • Key asset categories: Real Estate Investments (land, buildings, improvements) make up over 85% of total assets. Developments in progress and cash make up the remainder.
  • Goodwill & intangibles: Intangible assets (primarily acquired above-market leases and in-place lease value) represent 5% to 8% of assets, largely stemming from the Urstadt Biddle acquisition.
  • Working capital profile:
  • Days Sales Outstanding (DSO): Minimal (under 10 days) as rent is typically due on the first of the month.
  • Days Inventory Outstanding (DIO): Not applicable.
  • Days Payable Outstanding (DPO): 30 to 45 days for property maintenance vendors.
  • Net working capital as % of revenue: Typically negative.
  • Is working capital positive or negative? Negative. The company collects rent in advance and pays vendors in arrears, providing a slight working capital advantage.
  • PP&E: Real estate assets are depreciated over 30 to 40 years for buildings and 10 to 20 years for improvements.
  • Right-of-use assets / operating leases: Immaterial relative to the owned real estate portfolio.

Capital Expenditure & Investment

  • Capex as % of revenue: Total capital spend (maintenance plus development) ranges from 20% to 30% of revenue.
  • Maintenance capex vs. growth capex: Maintenance capex (tenant improvements and leasing commissions) is approximately $60 million to $80 million annually. Growth capex (development and redevelopment) is $200 million to $250 million annually.
  • Major capex programmes underway: The company maintains an active development and redevelopment pipeline, typically targeting 7% to 9% stabilised yields on cost.
  • Capitalised software / development costs: Immaterial.
  • M&A pattern: Opportunistic bolt-on acquirer. The company occasionally executes transformational deals (like Equity One in 2017 and Urstadt Biddle in 2023) but primarily relies on organic development.
  • Typical acquisition multiple paid: Implied capitalisation rates on acquisitions typically range from 5.5% to 6.5%.

Debt & Capital Structure

  • Total debt: Approximately $4.5 billion to $5.0 billion.
  • Debt/EBITDA ratio: Pro-rata net debt and preferred stock to trailing twelve months operating EBITDAre was 5.1x at the end of 2025. The target is 5.0x to 5.5x.
  • Credit rating: A- (S&P), upgraded in February 2025.
  • Key debt instruments: Unsecured senior notes, term loans, and a $1.5 billion revolving credit facility.
  • Maturity profile: Well-laddered with an average maturity of 6 to 8 years.
  • Interest rate profile: Predominantly fixed rate (over 85%), with a weighted average interest rate of approximately 4.0% to 4.5%.
  • Covenants: Standard REIT covenants including total debt to total assets (must be under 60%) and fixed charge coverage ratios.
  • Share repurchase programme: Active but opportunistic. The company uses an At-The-Market (ATM) equity programme to issue shares when the stock trades at a premium to NAV.
  • Dividend policy: The company pays a robust dividend, declaring $0.755 per share quarterly in early 2026. The payout ratio is typically 60% to 70% of Adjusted Funds From Operations (AFFO).

Cash Flow Characteristics

  • Operating cash flow conversion: OCF is typically 1.5x to 2.0x GAAP Net Income due to heavy non-cash depreciation add-backs.
  • Free cash flow margin: AFFO margin (a REIT proxy for free cash flow) typically ranges from 45% to 55% of total revenues.
  • Major non-cash items: Real estate depreciation, amortisation of lease intangibles, and straight-line rent adjustments.
  • Working capital cash flow impact: Minimal impact year-over-year.
  • Capex intensity: High. Real estate requires constant reinvestment (tenant improvements) to maintain occupancy and rental rates.
  • Cash tax rate vs. GAAP effective tax rate: As a REIT, Regency pays near-zero corporate income tax provided it distributes at least 90% of its taxable income to shareholders.

Sheet Structure

  1. Assumptions: Hardcoded drivers for macroeconomic factors, portfolio occupancy, rent spreads, capitalisation rates, and debt terms.
  2. Portfolio Metrics: Tracks Gross Leasable Area (GLA), anchor vs. shop occupancy percentages, base rent per square foot, and lease expiration schedules.
  3. Income Statement: GAAP view of revenues (Base Rent, Tenant Recoveries, Percentage Rent) and expenses (Property Operating, Real Estate Taxes, G&A, Depreciation).
  4. FFO & AFFO Reconciliation: Bridges GAAP Net Income to Nareit FFO, Core Operating Earnings, and AFFO by adjusting for depreciation, gains on sale, and maintenance capex.
  5. Balance Sheet: Tracks Real Estate Assets, Accumulated Depreciation, Cash, Unsecured Debt, and Shareholders' Equity.
  6. Cash Flow Statement: Standard three-section cash flow, driven by Net Income, working capital changes, capex, debt issuance, and dividends.
  7. Debt Schedule: Details tranches of unsecured notes, term loans, and revolver capacity, calculating weighted average interest expense.
  8. Development Pipeline: Tracks active ground-up developments and redevelopments, projecting capital spend and stabilised NOI contributions.
  9. Valuation: Calculates Net Asset Value (NAV) by applying a blended capitalisation rate to forward NOI, alongside a Dividend Discount Model (DDM).

Key Financial Relationships

  1. "Base Rent = Prior Period Base Rent x (1 + Blended Rent Spread) x Occupancy Rate"
  2. "Tenant Recoveries = (Property Operating Expenses + Real Estate Taxes) x Tenant Recovery Ratio"
  3. "Total Revenues = Base Rent + Tenant Recoveries + Percentage Rent + Other Property Income"
  4. "Property Net Operating Income (NOI) = Total Revenues - Property Operating Expenses - Real Estate Taxes"
  5. "Same Property NOI = Total NOI - NOI from Acquisitions - NOI from Developments - NOI from Dispositions"
  6. "Nareit FFO = Net Income Attributable to Common Shareholders + Real Estate Depreciation and Amortisation - Gains on Sale of Real Estate"
  7. "Core Operating Earnings = Nareit FFO - Non-Core Items (e.g., Merger Transition Expenses, Debt Extinguishment Costs)"
  8. "Adjusted Funds From Operations (AFFO) = Core Operating Earnings - Maintenance Capital Expenditures - Straight-Line Rent Adjustments - Non-Cash Interest Expense"
  9. "Net Debt = Total Unsecured Debt + Term Loans + Revolver Balance - Cash and Cash Equivalents"
  10. "Net Debt to EBITDAre = Net Debt / Annualised Operating EBITDAre"
  11. "Implied Capitalisation Rate = Forward 12-Month NOI / Implied Real Estate Value"
  12. "Net Asset Value (NAV) per Share = (Forward 12-Month NOI / Market Cap Rate) - Net Debt + Construction in Progress / Diluted Shares Outstanding"

Cross-Sheet Dependencies

  • The Portfolio Metrics sheet dictates the revenue lines on the Income Statement.
  • The Income Statement calculates GAAP Net Income, which is the starting point for the FFO & AFFO Reconciliation and the Cash Flow Statement.
  • The Development Pipeline feeds growth capex into the Cash Flow Statement and adds new stabilised NOI to the Income Statement.
  • The Debt Schedule calculates interest expense, which feeds the Income Statement, and ending debt balances, which feed the Balance Sheet and Valuation sheets.
  • The Valuation sheet relies on forward NOI from the Income Statement and share count/debt figures from the Balance Sheet. Circularity risk exists if interest expense is calculated on average debt balances drawn from a revolver that funds cash shortfalls; use a beginning-balance interest calculation to avoid this.

Sign Convention

  • Revenues, assets, and equity are positive.
  • Expenses are positive in their specific build-up schedules but must be subtracted when calculating Net Income or NOI.
  • Capital expenditures and dividends are positive in their build-up schedules but must be subtracted (shown as negative) on the Cash Flow Statement.
  • Contra-assets (like Accumulated Depreciation) should be entered as positive numbers but subtracted from Gross Real Estate to calculate Net Real Estate.

Things Most Likely to Go Wrong

  • Straight-line rent adjustments distort cash yields. The model must explicitly deduct straight-line rent from FFO to calculate true cash AFFO.
  • Confusing GAAP Net Income with FFO. REIT valuations rely on FFO and AFFO; Net Income is largely irrelevant due to heavy depreciation.
  • Miscalculating tenant recovery ratios. Recoveries rarely reach 100% because landlords absorb the costs for vacant spaces.
  • Ignoring the timing of development pipeline stabilisations. Developments do not generate full NOI immediately; the model must phase in NOI over 12 to 24 months post-completion.
  • Forgetting to exclude termination fees from Same Property NOI growth. Regency explicitly excludes these fees when reporting core growth metrics.
  • Overestimating percentage rent. This line item is highly seasonal and should be modelled to spike in Q4, not spread evenly across the year.
  • M&A accounting noise. The Urstadt Biddle acquisition created significant above/below market lease amortisation that artificially impacts GAAP revenues and must be adjusted out for Core Operating Earnings.
  • Share count dilution. The company frequently uses its ATM equity programme. The model must forecast share issuance to accurately calculate per-share FFO metrics.

Validation Checks

  • "Same Property NOI growth should be in the 3.0% to 5.0% range; flag if outside this band."
  • "Net Debt to EBITDAre should remain between 5.0x and 5.5x per rating agency guidance."
  • "Dividend payout ratio should remain between 60% and 75% of AFFO."
  • "Anchor occupancy should remain above 97% and shop occupancy above 93% based on historical averages."
  • "Tenant recovery ratio should be between 75% and 85% of total property operating expenses and taxes."
  • "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
  • "Nareit FFO per share growth should align with management guidance (typically 5% to 7% year-over-year)."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Same Property NOI Growth3.5%Aligns with 2024 actuals and 2025 management guidance
Anchor Occupancy97.9%Actual reported figure as of December 31, 2025
Shop Occupancy94.2%Actual reported figure as of December 31, 2025
Tenant Recovery Ratio80.0%Historical average for Regency's portfolio
Annual Development Spend250.0$ MillionsAligns with management's stated annual capital allocation target
Development Stabilised Yield8.0%Midpoint of historical development yields on cost
General & Administrative Expense95.0$ MillionsAligns with 2025 guidance run-rate
Maintenance Capex (TIs & LCs)75.0$ MillionsHistorical average required to maintain portfolio occupancy
Weighted Average Interest Rate4.5%Reflects current blended cost of unsecured debt
Annual Dividend per Share3.02$Based on the $0.755 quarterly dividend declared in February 2026
Target Net Debt to EBITDAre5.1xActual reported leverage as of December 31, 2025
Diluted Shares Outstanding183.0MillionsProjected weighted average share count for 2025/2026
Valuation Capitalisation Rate6.0%Standard market cap rate for high-quality grocery-anchored retail

Data Sources & Benchmarks

  • Filings: SEC EDGAR for 10-K and 10-Q filings. Regency Centers Investor Relations website for Quarterly Supplemental Information packages (crucial for REIT modelling).
  • Key peers for benchmarking: Federal Realty Investment Trust (FRT), Kite Realty Group (KRG), Brixmor Property Group (BRX), and Retail Opportunity Investments Corp (ROIC).
  • Industry data sources: Nareit (National Association of Real Estate Investment Trusts) for sector-wide cap rates and FFO multiples. Green Street Advisors for proprietary retail real estate valuation metrics.
  • Consensus estimates source: FactSet or Bloomberg for consensus FFO and NAV estimates.

Sources

Frequently asked

What kind of properties does Regency Centers own?+

Regency Centers is a national owner, operator, and developer of grocery-anchored shopping centers. These properties are located in affluent suburban trade areas and focus on necessity-driven retail, leasing space to highly productive grocers, restaurants, and service providers.

How does Regency Centers generate its revenue?+

Regency Centers primarily generates revenue from distinct streams, with Base Rent making up approximately 75% of total revenue. Other significant drivers include Tenant Recoveries, which account for about 20%, and Percentage Rent/Other Income, contributing approximately 5%.

What is Regency Centers' capital expenditure strategy?+

Regency Centers maintains an active development and redevelopment pipeline, with total capital spend ranging from 20% to 30% of revenue. Growth capex, focused on development and redevelopment, typically accounts for $200 million to $250 million annually, targeting 7% to 9% stabilized yields on cost.

What is the purpose of the financial model for Regency Centers?+

The financial model for Regency Centers projects Net Asset Value (NAV) and Funds From Operations (FFO). Its primary purpose is to help equity research analysts determine the fair value of Regency Centers' shares and assess the sustainability of its dividend.

Can I download an Excel financial model for Regency Centers?+

Yes, an Excel financial model for Regency Centers is available for download. This model forecasts financial performance from FY2026 through FY2030, providing detailed projections for analysis.

Who are Regency Centers' main competitors in the REIT sector?+

Regency Centers is a prominent S&P 500 member and one of the largest grocery-anchored REITs. It competes directly with companies such as Federal Realty Investment Trust, Kite Realty Group, and Brixmor Property Group.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

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.

Explore more Real Estate financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview