AI for REIT Analysis: Claude Tools for Real Estate Investment Trust Valuation

REIT Analysis and AI

Real Estate Investment Trusts (REITs) are valued using specialized metrics — FFO, AFFO, NOI, cap rates, and NAV — that differ from standard corporate finance. REITs must distribute 90%+ of taxable income as dividends, are analyzed on cash yield, and trade at multiples of FFO (not P/E). Claude with ClaudeFinLab calculates REIT-specific metrics, performs NAV analysis, analyzes same-store NOI trends, and stress-tests dividend sustainability.

FFO and AFFO Calculation

• "Calculate FFO for this REIT: Net income $84M, add back real estate depreciation $148M, add back amortization of acquired in-place leases $28M, subtract gains on sale of properties $24M, add back impairment of real estate $0. FFO = $84M + $148M + $28M − $24M = $236M. Shares outstanding 120M. FFO per share = $1.97. P/FFO at current price $28: 14.2x. How does this compare to the apartment REIT sector P/FFO of 16-18x?"
• "AFFO calculation: FFO $236M. AFFO adjustments: subtract recurring capex (tenant improvements $18M + leasing commissions $12M + maintenance capex $24M) = $54M. Add back straight-line rent adjustment ($8.4M non-cash revenue that overstates cash rent). Add back stock-based compensation $6.2M (non-cash). AFFO = $236M − $54M − $8.4M + $6.2M = $179.8M. AFFO per share = $1.50. Dividend per share $1.20. AFFO payout ratio = 80% — sustainable. If AFFO fell 15%, payout ratio rises to 94% — still covered, but thin."
• "FFO bridge (year-over-year): FFO increased from $210M to $236M (+12.4%). Drivers: (1) same-store NOI growth $18M (organic); (2) acquisitions closed mid-year $14M incremental NOI; (3) dispositions ($6M NOI lost); (4) lower interest expense from debt refinancing $4M; (5) G&A savings $1M. FFO bridge sums to +$31M, but dispositions reduced by $5M → net $26M. Reconcile to actual $26M increase."

NOI and Same-Store Analysis

• "NOI calculation: total revenues $420M (base rent $380M, expense recoveries $28M, other $12M). Operating expenses: property operating expenses $84M, real estate taxes $42M, insurance $8.4M. NOI = $420M − $84M − $42M − $8.4M = $285.6M. NOI margin = 68.0%. How does this compare to the industrial REIT sector NOI margin of 72%? What are the main sources of margin compression?"
• "Same-store NOI analysis: same-store pool = properties owned for 12+ months. Same-store revenue $380M (+4.2% YoY), same-store expenses $134M (+2.8% YoY). Same-store NOI = $246M (+5.1% YoY). Drivers: rent growth +3.8% (achieved rents on renewals and new leases), occupancy +40bps (96.2% vs 95.8% prior year). This is strong — industrial sector average same-store NOI growth in 2026: 3.5-4.5%. What does it imply for NAV growth?"
• "Lease roll and rent spread analysis: leases expiring this year = 8.4% of base rent ($31.9M). Average in-place rent on expiring leases: $8.40/sqft. Market rent today: $11.20/sqft. Rent spread on renewal: +33.3% (positive mark-to-market). Total NOI impact when leases roll: $31.9M × 33.3% = $10.6M incremental NOI annually when fully re-leased at market. NPV of this 'below-market lease' embedded value at 10% cap rate: $106M in hidden value not yet in reported NOI."

NAV Analysis

• "NAV calculation for industrial REIT: stabilized NOI $285.6M. Apply blended cap rate: stabilized assets at 5.2% cap rate, development pipeline at cost. NAV of stabilized portfolio: $285.6M / 5.2% = $5.49B. Add: development pipeline at cost (fair value estimated at 15% premium to book): $420M × 1.15 = $483M. Add: cash $84M. Subtract: total debt $2.8B, preferred equity $280M, other liabilities $42M. NAV = $5.49B + $483M + $84M − $2.8B − $280M − $42M = $2.935B. Shares: 120M. NAV per share: $24.46. Current price $28 → 14.5% premium to NAV. Is this justified?"
• "Cap rate sensitivity for NAV: at 5.2% cap rate → NAV $24.46. If cap rates expand 50bps to 5.7% (interest rate driven): NAV = $285.6M / 5.7% = $5.01B → NAV per share falls to $21.02 (-14.1%). If cap rates compress 25bps to 4.95%: NAV = $5.77B → NAV per share $23.78... wait, that's lower. Recalculate: full NAV bridge at each cap rate scenario."

REIT Debt and Leverage Analysis

• "REIT leverage metrics: debt to total assets = $2.8B / ($5.49B + $0.567B other) = 46.4%. Net debt to EBITDA: ($2.8B − $84M cash) / ($285.6M NOI + $42M G&A + $4M other) = $2.716B / $331.6M = 8.19x. Interest coverage: EBITDA $331.6M / interest $112M = 2.96x. Sector benchmarks: industrial REITs typically target 35-40% LTV and 5-6x debt/EBITDA. This REIT is more levered than peers — is the leverage justified by asset quality?"
• "Debt maturity profile: $400M 3.5% notes due 2027, $600M 4.2% notes due 2029, $800M floating TLB (SOFR+175bps) due 2028, $1B revolving credit facility ($200M drawn). Refinancing risk: in 2027, $400M matures. At current market (IG REIT bonds at 5.4% for 7-year), refinancing cost: $400M × (5.4% − 3.5%) = $7.6M additional annual interest. Impact on FFO per share: $7.6M × 75% (after-tax) / 120M shares = $0.048/share dilution to AFFO."

Dividend Sustainability and Growth

• "Dividend sustainability analysis: annual dividend $1.20/share, 120M shares → $144M annual dividends. AFFO $179.8M. AFFO payout ratio 80%. Minimum sustainable AFFO to maintain current dividend: at 100% payout, AFFO must be ≥ $144M. AFFO would need to fall 20% to threaten the dividend. What macro scenario could cause 20% AFFO decline? (10% occupancy decline + rent flat = NOI down ~8%; financing cost increase = -4%; together = -12% → insufficient to cut dividend. Need a severe stress.)"
• "REIT dividend growth model: current dividend $1.20. AFFO grows at same-store NOI growth (5%) + acquisitions (2%) − dilution from equity issuances (1%) = net 6%/year. If management targets 70% AFFO payout, dividend grows at 6%/year. Year 5 dividend: $1.20 × (1.06)^5 = $1.607. Implied total return at 4% current yield + 6% growth = 10%/year. Does this beat the S&P 500 expected 8% in base case?"

Related Articles

• Real Estate Underwriting AI
• Real Estate Finance AI
• Equity Research AI