REIT Fundamental Analysis Framework
Analyze REIT fundamentals using FFO, AFFO, and dividend sustainability metrics
What You Can Do
You can systematically evaluate REIT investment opportunities by normalizing earnings through FFO and AFFO calculations, assessing leverage efficiency, modeling dividend sustainability, and comparing valuations across property sectors. The framework accounts for accounting adjustments, non-recurring items, and capital allocation decisions that distort traditional GAAP metrics, helping you identify red flags and make data-driven investment recommendations.
Features
Normalize REIT earnings by adding back depreciation, amortization, and non-recurring items to identify true cash available for distribution
Model payout ratios and assess sustainability across interest rate environments and occupancy scenarios
Assess leverage ratios, refinancing risk, debt maturity ladders, and balance sheet strength relative to peers
Analyze organic revenue growth, occupancy trends, rent escalation, and expense inflation impacts by property segment
Compare price-to-FFO multiples, cap rates, and NAV estimates across office, industrial, retail, residential, and healthcare property types
Evaluate credit quality, lease concentration, and upcoming rent roll expirations to identify revenue risk
Map distributions from operations through debt service to identify capital allocation priorities and growth investment capacity
Example Output
Example 1: FFO/AFFO Analysis
- FFO per share: $2.85 (GAAP EPS: $0.42)
- AFFO per share: $2.64 after maintenance capex
- Payout ratio: 76% (dividend $2.01 / AFFO $2.64)
- Assessment: Sustainable dividend with 24% cushion; coverage remains stable across 4.5% interest rate scenario
Example 2: Peer Comparison
- Target REIT: P/FFO 12.5x, 4.2% dividend yield, 5.8x debt/EBITDA
- Sector median: P/FFO 14.2x, 3.9% yield, 5.4x leverage
- Finding: Valuation discount and stronger yield attractive; leverage slightly elevated but manageable given 18-month weighted average lease term
Example 3: Red Flag Detection
- FFO growth +3.5% YoY but same-store NOI flat; external growth via acquisition masking operational weakness
- Payout ratio expanded to 92% AFFO; limited reinvestment capacity for maintenance capex and lease renewal risk rising
- Recommendation: Reduce position; dividend at risk in 2-3 quarters if occupancy declines further
What's Included
- SKILL.md instruction file with REIT analysis framework and methodology:
- FFO/AFFO Calculation Template: Structured worksheet for normalizing earnings from income statement
- Dividend Sustainability Checklist: Assessment of payout ratio, coverage margins, and rate sensitivity scenarios
- REIT Peer Comparison Framework: Sector-specific metrics and valuation multiple benchmarking
- Capital Structure Analysis Workbook: Leverage ratios, debt maturity schedule, and refinancing risk evaluation
- Property Sector Quick Reference: Key metrics and benchmarks for office, industrial, retail, residential, and healthcare REITs
Who It's For
- Real estate investment analysts evaluating REIT opportunities for institutional portfolios
- Private equity or infrastructure fund managers assessing REIT add-ons to real estate platforms
- Financial advisors conducting REIT portfolio reviews and dividend sustainability analysis
- Corporate development teams at REITs benchmarking peer capital structures and valuation metrics
- Fixed income analysts and credit investors evaluating REIT balance sheets and refinancing risk
Best For
- Quarterly or annual REIT investment due diligence and portfolio review
- Comparing valuations and metrics across peer REITs within same property sector
- Assessing dividend coverage and sustainability through interest rate cycles
- Identifying red flags in capital allocation, occupancy trends, or leverage metrics
- Modeling NOI sensitivity to occupancy changes, rent growth, or expense inflation scenarios
You might also like
You'll architect backtesting systems that separate genuinely profitable strategies from curve-fitted fantasies. The skill guides you through modeling realistic market microstructure, accounting for transaction costs, detecting survivorship bias, and stress-testing strategies across regime changes. You'll implement walk-forward validation, out-of-sample testing, and Monte Carlo simulations to predict actual live performance and identify where backtest results diverge from real trading outcomes.
by fission
You can rapidly value complex structured notes, convertibles, and equity-linked instruments by breaking them into vanilla bonds and embedded derivatives. The skill guides you through scenario analysis, sensitivity testing, and credit spread modeling to identify secondary market mispricings, calculate Greeks, and stress-test barrier knockouts or coupon adjustments. Output includes fair value estimates, comparable valuation matrices, and hedge recommendations defensible to traders and risk committees.
by fission
You can construct rigorous development pro formas that model complex project dynamics—construction budgets, phased timelines, pre-leasing velocity, financing structures, and market assumptions—then run sensitivity analysis to show how changes in rent, construction costs, or hold periods impact returns. This skill produces defensible investment theses suitable for LP presentations, lender submissions, and institutional review committees by capturing interdependencies that simple models miss.
by fission
You can conduct rigorous competitive positioning analysis for SaaS companies by mapping competitors across pricing architecture, target buyer personas, feature differentiation, go-to-market efficiency, and retention dynamics. This skill transforms raw competitive data into structured frameworks that identify sustainable competitive advantages, market share vulnerabilities, and valuation implications—helping you differentiate your research thesis from consensus and reduce confirmation bias in your coverage.
by fission
You can rapidly evaluate multiple financing structures for M&A, recapitalizations, and growth transactions by modeling different capital stack configurations and comparing them against recent comparable transaction benchmarks. The skill helps you assess debt capacity, analyze covenant headroom across downside scenarios, and stress-test leverage under EBITDA decline, capex disruption, and refinancing risk—enabling you to present optimized structures that balance cost of capital, covenant flexibility, and stakeholder requirements in client presentations and pitch books.
by fission
You can ingest multi-property portfolio data and generate comprehensive financial diagnostics, including performance metrics, peer benchmarking, concentration risk analysis, and stress-test scenarios across economic conditions. Claude systematizes the analysis of 10-500+ heterogeneous assets (varying property types, leverage, lease structures, and markets) to identify underperformers, quantify rebalancing impact, and deliver executive summaries with specific buy/sell/hold recommendations backed by financial modeling.
by fission
You can systematically decompose portfolio returns to isolate alpha (manager skill) from beta (passive market exposure) and identify which specific positions, sectors, or factor exposures drove performance. The skill enables rigorous performance attribution across multiple timeframes, generates risk-adjusted performance metrics (Information Ratio, Sharpe ratio, CAPM alpha), and produces institutional-grade client reporting with statistical rigor to support manager evaluation and capital allocation decisions.
by fission
You can systematically evaluate corporate bond issuers by synthesizing quantitative metrics (leverage ratios, cash flow coverage, liquidity), qualitative factors (management quality, competitive positioning, covenant protections), and market signals (credit spreads, relative value) into a cohesive credit opinion. This framework enables you to construct ratings that withstand peer review, document credit theses for investment committees, and respond to market events with quantified analytical support.
by fission