# Federal Realty Investment Trust (FRT) Financial Model

Free Excel 3-statement financial model and company analysis for Federal Realty Investment Trust.

- Canonical: https://finamodel.com/companies/federal-realty-investment-trust
- Industry: Real Estate
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/FRT.xlsx

## Model Purpose

This model projects property-level Net Operating Income (NOI), Funds From Operations (FFO), and Adjusted Funds From Operations (AFFO) to determine the Net Asset Value (NAV) and equity valuation of Federal Realty Investment Trust for an equity research analyst.

## Company Overview

Federal Realty Investment Trust (FRT) is a real estate investment trust that owns, operates, and redevelops high-quality, retail-based properties located primarily in major coastal markets in the United States. The company focuses on open-air retail and mixed-use properties, combining affluent demographics with dense populations to drive premium rents.

- **Business segments**: The company operates as a single reportable segment (retail and mixed-use real estate), but revenue is driven by Base Rent (approx. 75%), Tenant Recoveries (approx. 20%), and Percentage Rent / Other (approx. 5%).
- **Key geographies**: Washington D.C., New York, Boston, San Francisco, Los Angeles, Silicon Valley, Chicago, and Miami.
- **Business model type**: Asset-heavy real estate owner and operator (REIT).
- **Competitive position**: FRT is a premium operator with the longest consecutive dividend growth record in the REIT industry (58 years as a Dividend King), boasting high occupancy rates (94.5% as of late 2025) and industry-leading demographics.
- **Recent major events**: In 2025, FRT achieved record leasing volume of 2.5 million square feet, acquired the Del Monte Shopping Center for $123.5 million, Annapolis Town Center for $187 million, and two open-air centers in Leawood, KS for $289 million.

## Revenue Deep Dive



### Rental Income (Base Rent)

- **Segment name**: Rental Income - Minimum Rent
- **Revenue driver formula**: Gross Leasable Area (GLA) x Occupancy Rate x Annualised Base Rent (ABR) per square foot
- **Historical growth rate**: 3-5% CAGR, driven by contractual rent bumps and strong leasing spreads (recent cash spreads of 15%).
- **Key growth levers and headwinds**: Mark-to-market rent increases on lease expirations, redevelopment of existing assets, and acquisitions. Headwinds include tenant bankruptcies and higher interest rates impacting consumer spending.
- **Pricing dynamics**: Contractual leases typically spanning 5 to 10 years with built-in annual escalators.
- **Revenue recognition notes**: Recognised on a straight-line basis over the lease term. The model must track straight-line rent adjustments separately from cash rent.
- **Seasonality**: Generally stable, though percentage rents (based on tenant sales) peak in the fourth quarter due to holiday shopping.

### Tenant Recoveries

- **Segment name**: Rental Income - Tenant Recoveries
- **Revenue driver formula**: Recoverable Property Expenses x Recovery Ratio (typically 80-90%)
- **Historical growth rate**: Tracks property operating expense growth (3-5%).
- **Key growth levers and headwinds**: Inflation in property taxes, insurance, and maintenance costs drives this line item up, but it is a pass-through.
- **Pricing dynamics**: Contractually stipulated in triple-net (NNN) or modified gross leases.
- **Revenue recognition notes**: Recognised in the period the applicable expenses are incurred.
- **Seasonality**: Spikes in quarters where property taxes are assessed or snow removal costs are high (Q1/Q4).

## Cost Structure



### Property Operating Expenses

- **Line-by-line breakdown**: Real estate taxes, property management, repairs and maintenance, insurance, utilities, and security.
- **Gross margin range**: NOI margin (Revenue less Property Expenses) typically ranges from 70% to 74%.
- **Key input costs**: Local property tax assessments, utility rates, and labour for maintenance.
- **How COGS scales with revenue**: Highly fixed in the short term. Increases in expenses are largely passed through to tenants via recoveries.

### Operating Expenses

- **G&A**: General and administrative expenses typically run at 5-7% of total revenue. It is largely headcount-driven (corporate staff, leasing agents).
- **Depreciation & Amortisation**: Significant non-cash expense, typically 25-30% of revenue, driven by the massive real estate asset base.
- **Stock-Based Compensation**: Modest, typically 1-2% of revenue.
- **Restructuring / one-time charges**: Rare, but occasional impairment charges on underperforming properties or early debt extinguishment costs.

### Margin Profile

- **NOI Margin**: 70-74% (stable).
- **EBITDA Margin**: 60-65%.
- **Net Margin**: 25-30% (heavily distorted by non-cash depreciation).
- **Margin trend**: Stable to slightly expanding due to operating leverage and strong rent spreads on comparable properties.

## Balance Sheet Structure

- **Total assets**: Approximately $8.0 to $8.5 billion.
- **Key asset categories**: Real Estate at Cost (land, buildings, improvements), Accumulated Depreciation, Cash and Cash Equivalents, Tenant Receivables.
- **Goodwill & intangibles**: Minimal. REITs primarily hold tangible real estate.
- **Working capital profile**:
  - **Days Sales Outstanding (DSO)**: 10-15 days (rent is typically paid on the first of the month).
  - **Days Payable Outstanding (DPO)**: 20-30 days.
  - **Net working capital**: Typically negative, which is standard for REITs as they collect rent upfront and delay vendor payments.
- **PP&E**: Real Estate Assets dominate the balance sheet. Useful lives are typically 30-40 years for buildings and 10-15 years for improvements.
- **Right-of-use assets**: Immaterial for the core business, though some ground leases exist.

## Capital Expenditure & Investment

- **Capex as % of revenue**: 15-25%, highly dependent on the redevelopment pipeline.
- **Maintenance capex vs. growth capex**: Maintenance (tenant improvements, leasing commissions, roof/parking lot repairs) is roughly 5-8% of revenue. Growth capex (redevelopments, expansions like Santana Row or Willow Grove) makes up the remainder.
- **Major capex programmes underway**: Willow Grove redevelopment ($110-$120 million projected cost, 7% expected ROI), Lot 12 residential project at Santana Row.
- **Capitalised software**: Immaterial.
- **M&A pattern**: Selective acquirer of premium assets (e.g., Del Monte Shopping Center, Annapolis Town Center).
- **Typical acquisition multiple paid**: 6.5% to 7.5% going-in cap rate.

## Debt & Capital Structure

- **Total debt**: Approximately $4.5 billion.
- **Debt/EBITDA ratio**: Target range of 5.0x to 6.0x.
- **Credit rating**: BBB+ (S&P), stable outlook.
- **Key debt instruments**: $1.25 billion revolving credit facility, $600 million unsecured term loan (SOFR + 0.85%), and various senior unsecured notes and mortgages.
- **Maturity profile**: Well-laddered. The model must account for refinancing of near-term maturities (e.g., 1.25% unsecured notes refinancing at 4.25-4.50%).
- **Interest rate profile**: Predominantly fixed rate (or effectively fixed via swaps). Variable rate debt is roughly 15-20% of total debt.
- **Covenants**: Standard REIT covenants (Total Debt to Total Assets < 60%, Secured Debt to Total Assets < 40%, Fixed Charge Coverage > 1.5x).
- **Share repurchase programme**: Active $300 million authorisation announced in 2025.
- **Dividend policy**: Dividend King. 2025 annualised dividend of $4.52 per share. Payout ratio is typically 60-65% of FFO.

## Cash Flow Characteristics

- **Operating cash flow conversion**: OCF is consistently higher than Net Income due to massive depreciation add-backs.
- **Free cash flow margin**: AFFO (Adjusted Funds From Operations, a proxy for REIT free cash flow) margin is typically 45-50%.
- **Major non-cash items**: Depreciation and amortisation, straight-line rent adjustments, stock-based compensation.
- **Working capital cash flow impact**: Minimal impact year-over-year.
- **Capex intensity**: High. Real estate requires constant reinvestment (Tenant Improvements and Leasing Commissions) to maintain occupancy and rent growth.
- **Cash tax rate**: Near 0%. As a REIT, FRT pays no corporate income tax provided it distributes at least 90% of its taxable income to shareholders.

## Sheet Structure

1. **Assumptions**: Hardcoded inputs for macroeconomic drivers, rent growth, occupancy, cap rates, and debt terms.
2. **Property Portfolio**: Row-by-row build of GLA, occupancy, and ABR for the comparable portfolio and recent acquisitions.
3. **Income Statement**: GAAP income statement mirroring the 10-K (Rental Income, Property Expenses, G&A, Depreciation, Interest Expense).
4. **Balance Sheet**: Assets (Real Estate, Accumulated Depreciation), Liabilities (Debt, Payables), and Equity.
5. **Cash Flow Statement**: GAAP cash flow statement (Operating, Investing, Financing).
6. **FFO & AFFO Reconciliation**: Critical REIT sheet bridging Net Income to NAREIT FFO, Core FFO, and AFFO.
7. **Debt Schedule**: Tranche-by-tranche debt roll-forward, interest expense calculation, and maturity schedule.
8. **Fixed Asset Roll-forward**: Tracks Real Estate at Cost, Capex, Acquisitions, Dispositions, and Depreciation.
9. **NAV Valuation**: Net Asset Value calculation applying a market cap rate to forward 12-month NOI.
10. **Dividend & Equity Schedule**: Tracks share count, share repurchases, and the dividend payout growth.

## Key Financial Relationships

1. `Rental Income = Total GLA x Occupancy % x Average Base Rent per Sq Ft`
2. `Tenant Recoveries = Property Operating Expenses x Recovery Ratio %`
3. `Total Revenue = Rental Income + Tenant Recoveries + Percentage Rent`
4. `Net Operating Income (NOI) = Total Revenue - Property Operating Expenses - Real Estate Taxes`
5. `Same-Store NOI = Prior Year Same-Store NOI x (1 + Same-Store NOI Growth Rate)`
6. `Depreciation Expense = Gross Real Estate Assets x Implied Depreciation Rate`
7. `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`
8. `NAREIT FFO = Net Income + Real Estate Depreciation & Amortisation - Gains on Sale of Real Estate`
9. `Core FFO = NAREIT FFO - One-time items (e.g., New Market Tax Credit income, early debt extinguishment costs)`
10. `AFFO = Core FFO - Maintenance Capex - Straight-Line Rent Adjustments`
11. `Dividends Paid = Shares Outstanding x Annual Dividend per Share`
12. `Ending Real Estate Assets = Beginning Real Estate Assets + Acquisitions + Development Capex + Maintenance Capex - Dispositions`
13. `Implied Capitalisation Rate = Forward 12-Month NOI / Gross Real Estate Value`

## Cross-Sheet Dependencies

- **Assumptions** feeds all schedules (growth rates, margins, interest rates).
- **Property Portfolio** feeds the **Income Statement** (Rental Income) and **NAV Valuation** (NOI).
- **Fixed Asset Roll-forward** feeds **Income Statement** (Depreciation) and **Balance Sheet** (Real Estate Assets).
- **Debt Schedule** feeds **Income Statement** (Interest Expense) and **Balance Sheet** (Debt balances).
- **Income Statement** feeds **Cash Flow Statement** (Net Income) and **FFO & AFFO Reconciliation**.
- **FFO & AFFO Reconciliation** feeds the **Dividend & Equity Schedule** (to check payout ratio sustainability).
- **Cash Flow Statement** feeds **Balance Sheet** (Ending Cash).
- Circularity risk: Interest expense depends on the debt balance, which depends on the cash shortfall/surplus from the Cash Flow Statement, which in turn depends on Net Income (and thus Interest Expense). A circuit breaker toggle must be included.

## Sign Convention

- **Revenues and Assets**: Positive.
- **Expenses and Liabilities**: Positive in their native schedules (e.g., Debt Schedule, Opex build).
- **Income Statement**: Expenses are subtracted (entered as positive, formula uses a minus sign).
- **Cash Flow Statement**: Cash inflows are positive, cash outflows (capex, dividends, debt repayment) are negative.
- **FFO Reconciliation**: Add-backs (Depreciation) are positive, deductions (Straight-line rent) are negative.

## Things Most Likely to Go Wrong

1. "Failing to exclude straight-line rent from AFFO will artificially inflate the company's true cash generation capability."
2. "Applying the corporate tax rate to pre-tax income; FRT is a REIT and pays effectively zero corporate tax."
3. "Confusing NAREIT FFO with Core FFO. The model must adjust for the $0.15 per share New Market Tax Credit income recognised in 2025 to calculate a clean Core FFO."
4. "Underestimating interest expense by ignoring the refinancing of low-rate debt (e.g., 1.25% notes refinancing at 4.25-4.50% in 2026)."
5. "Double-counting acquisitions. If an acquisition is added to the Fixed Asset Roll-forward, its revenue must be pro-rated in the Income Statement based on the close date."
6. "Forgetting to deduct preferred dividends before calculating FFO available to common shareholders."
7. "Miscalculating the dividend payout ratio by using Net Income instead of FFO or AFFO. REIT dividends are paid out of cash flow, not GAAP earnings."
8. "Assuming 100% occupancy. FRT operates at a premium, but structural vacancy of 4-6% must be modelled."

## Validation Checks

1. "Occupancy rate must not exceed 97% (historical peak is around 96.6% leased rate)."
2. "NOI Margin should remain tightly bound between 70% and 74%."
3. "Dividend payout ratio must be between 60% and 65% of Core FFO to align with management's historical targets."
4. "Debt to EBITDA should remain between 5.0x and 6.0x to maintain the BBB+ credit rating."
5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
6. "Core FFO per share growth should be in the 4% to 6% range based on management guidance and historical averages."
7. "Maintenance Capex should be roughly 10-15% of NOI; flag if it drops below this threshold as it implies underinvestment."
8. "Effective tax rate must be 0%."

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Comparable Portfolio Occupancy | 94.5 | % | Actual Q4 2025 reported occupancy |
| Comparable Leased Rate | 96.6 | % | Actual Q4 2025 reported leased rate |
| Same-Store NOI Growth | 3.5 | % | Midpoint of management's 3.0-3.5% guidance for 2026 |
| Recovery Ratio | 85.0 | % | Historical average for NNN/modified gross leases |
| G&A as % of Revenue | 6.0 | % | Historical 3-year average |
| Maintenance Capex as % of NOI | 12.0 | % | Standard run-rate for premium open-air retail |
| Weighted Average Interest Rate | 4.25 | % | Reflects refinancing of older debt at current market rates |
| Effective Tax Rate | 0.0 | % | REIT tax status |
| Annual Dividend per Share | 4.52 | $ | Actual 2025 annualised dividend |
| Dividend Growth Rate | 2.5 | % | Historical average growth rate for this Dividend King |
| Target Debt / EBITDA | 5.5 | x | Midpoint of management target range |
| Capitalisation Rate (NAV) | 6.5 | % | Blended market cap rate for premium coastal retail assets |
| Share Count (Diluted) | 85.7 | Millions | Actual outstanding shares from Q1 2025 10-K |

## Data Sources & Benchmarks

- **Filings**: SEC EDGAR (Form 10-K, 10-Q, 8-K), Federal Realty Investor Relations page (quarterly supplemental packages are critical for REITs).
- **Key peers for benchmarking**: Kimco Realty (KIM), Regency Centers (REG), Brixmor Property Group (BRX).
- **Industry data sources**: NAREIT (National Association of Real Estate Investment Trusts) for industry-wide occupancy and cap rate trends, Green Street Advisors for premium real estate valuation metrics.
- **Consensus estimates source**: FactSet or Bloomberg for forward FFO and AFFO estimates.

## Sources

- Federal Realty Investment Trust Q4 2025 Earnings Press Release (February 12, 2026)
- Federal Realty Investment Trust 2024 Form 10-K (Filed February 13, 2025)
- Seeking Alpha: "Federal Realty: A Dividend King Built For Market Volatility" (March 28, 2026)
- The Motley Fool: "This Elite Financial King Could See Payout Growth Hit 7% By 2028" (December 4, 2025)
- Stock Analysis: FRT Dividend History and Yield Data (April 2026)

---

## Frequently asked questions

### What kind of properties does Federal Realty Investment Trust own?

Federal Realty Investment Trust (FRT) is a real estate investment trust that owns, operates, and redevelops high-quality, retail-based properties. These properties are primarily located in major coastal markets across the United States, focusing on open-air retail and mixed-use developments.

### How does Federal Realty Investment Trust generate its revenue?

FRT's revenue is primarily driven by Base Rent, which accounts for approximately 75% of its total revenue. Tenant Recoveries contribute about 20%, with Percentage Rent and other sources making up the remaining 5%.

### What is Federal Realty Investment Trust's capital expenditure strategy?

FRT's capital expenditure typically ranges from 15-25% of revenue, heavily influenced by its redevelopment pipeline. This includes both maintenance capex for tenant improvements and growth capex for significant redevelopments and expansions like Willow Grove and Santana Row.

### What is the purpose of the financial model for Federal Realty Investment Trust?

The financial model for Federal Realty Investment Trust projects property-level Net Operating Income (NOI), Funds From Operations (FFO), and Adjusted Funds From Operations (AFFO). Its primary purpose is to determine the Net Asset Value (NAV) and equity valuation for equity research analysts.

### What is the assumed revenue growth rate in the Federal Realty Investment Trust financial model?

The financial model for Federal Realty Investment Trust assumes a revenue growth rate of approximately 5.46%. This assumption helps project future income and cash flows over the forecast horizon from FY2025 to FY2029.

### Can I download an Excel financial model for Federal Realty Investment Trust?

Yes, an Excel financial model for Federal Realty Investment Trust is available for download. This model projects financials from FY2025 to FY2029 and is designed for equity research analysts.

[Interactive forecast calculator](https://finamodel.com/companies/federal-realty-investment-trust/forecast)