Federal Realty Investment Trust Financial Model
Real Estate Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
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.
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.
The downloadable Federal Realty Investment Trust 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 & AssumptionsFederal Realty Investment Trust financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2020 | FY2021 | FY2022 | FY2023 | FY2024 |
|---|---|---|---|---|---|
| Revenue | $951.2M | $1.07B | $1.13B | $1.20B | $1.28B |
| Rental expenses | $198.1M | $229.0M | $231.7M | $249.6M | $267.4M |
| Operating income | $394.7M | $526.4M | $406.5M | $472.4M | $602.2M |
| Net income | $261.5M | $385.5M | $237.0M | $295.2M | $411.1M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2025–FY2029.
See 8 moreSee less
How to build a detailed financial model for Federal Realty Investment Trust
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
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
- Assumptions: Hardcoded inputs for macroeconomic drivers, rent growth, occupancy, cap rates, and debt terms.
- Property Portfolio: Row-by-row build of GLA, occupancy, and ABR for the comparable portfolio and recent acquisitions.
- Income Statement: GAAP income statement mirroring the 10-K (Rental Income, Property Expenses, G&A, Depreciation, Interest Expense).
- Balance Sheet: Assets (Real Estate, Accumulated Depreciation), Liabilities (Debt, Payables), and Equity.
- Cash Flow Statement: GAAP cash flow statement (Operating, Investing, Financing).
- FFO & AFFO Reconciliation: Critical REIT sheet bridging Net Income to NAREIT FFO, Core FFO, and AFFO.
- Debt Schedule: Tranche-by-tranche debt roll-forward, interest expense calculation, and maturity schedule.
- Fixed Asset Roll-forward: Tracks Real Estate at Cost, Capex, Acquisitions, Dispositions, and Depreciation.
- NAV Valuation: Net Asset Value calculation applying a market cap rate to forward 12-month NOI.
- Dividend & Equity Schedule: Tracks share count, share repurchases, and the dividend payout growth.
Key Financial Relationships
- `Rental Income = Total GLA x Occupancy % x Average Base Rent per Sq Ft`
- `Tenant Recoveries = Property Operating Expenses x Recovery Ratio %`
- `Total Revenue = Rental Income + Tenant Recoveries + Percentage Rent`
- `Net Operating Income (NOI) = Total Revenue - Property Operating Expenses - Real Estate Taxes`
- `Same-Store NOI = Prior Year Same-Store NOI x (1 + Same-Store NOI Growth Rate)`
- `Depreciation Expense = Gross Real Estate Assets x Implied Depreciation Rate`
- `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`
- `NAREIT FFO = Net Income + Real Estate Depreciation & Amortisation - Gains on Sale of Real Estate`
- `Core FFO = NAREIT FFO - One-time items (e.g., New Market Tax Credit income, early debt extinguishment costs)`
- `AFFO = Core FFO - Maintenance Capex - Straight-Line Rent Adjustments`
- `Dividends Paid = Shares Outstanding x Annual Dividend per Share`
- `Ending Real Estate Assets = Beginning Real Estate Assets + Acquisitions + Development Capex + Maintenance Capex - Dispositions`
- `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
- "Failing to exclude straight-line rent from AFFO will artificially inflate the company's true cash generation capability."
- "Applying the corporate tax rate to pre-tax income; FRT is a REIT and pays effectively zero corporate tax."
- "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."
- "Underestimating interest expense by ignoring the refinancing of low-rate debt (e.g., 1.25% notes refinancing at 4.25-4.50% in 2026)."
- "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."
- "Forgetting to deduct preferred dividends before calculating FFO available to common shareholders."
- "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."
- "Assuming 100% occupancy. FRT operates at a premium, but structural vacancy of 4-6% must be modelled."
Validation Checks
- "Occupancy rate must not exceed 97% (historical peak is around 96.6% leased rate)."
- "NOI Margin should remain tightly bound between 70% and 74%."
- "Dividend payout ratio must be between 60% and 65% of Core FFO to align with management's historical targets."
- "Debt to EBITDA should remain between 5.0x and 6.0x to maintain the BBB+ credit rating."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Core FFO per share growth should be in the 4% to 6% range based on management guidance and historical averages."
- "Maintenance Capex should be roughly 10-15% of NOI; flag if it drops below this threshold as it implies underinvestment."
- "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)
Do more with the Federal Realty Investment Trust model
Frequently asked
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.
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.
