SkillsLib.ai

REIT Fundamental Analysis Framework

Analyze REIT fundamentals using FFO, AFFO, and dividend sustainability metrics

3.7(14 reviews)
100+ downloads
Updated Nov 2026
Verified SafeSecurity VerifiedThis skill was analyzed by our AI security scanner for harmful content including data exfiltration, system manipulation, credential theft, and prompt injection. No threats were detected.

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

FFO and AFFO calculation

Normalize REIT earnings by adding back depreciation, amortization, and non-recurring items to identify true cash available for distribution

Dividend coverage analysis

Model payout ratios and assess sustainability across interest rate environments and occupancy scenarios

Capital structure evaluation

Assess leverage ratios, refinancing risk, debt maturity ladders, and balance sheet strength relative to peers

Same-store NOI growth tracking

Analyze organic revenue growth, occupancy trends, rent escalation, and expense inflation impacts by property segment

Sector-specific valuation metrics

Compare price-to-FFO multiples, cap rates, and NAV estimates across office, industrial, retail, residential, and healthcare property types

Tenant quality and lease maturity assessment

Evaluate credit quality, lease concentration, and upcoming rent roll expirations to identify revenue risk

Cash flow waterfall modeling

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

Financial Statement Forensics Analyzer
$40
Financials4.3(20)
Financial Statement Forensics Analyzer

You can rapidly decompose multi-year financial statements to distinguish between legitimate business performance and accounting manipulation or one-time distortions. This skill helps you identify suspicious patterns in working capital trends, revenue recognition timing, asset impairment practices, and cash flow divergence from reported profits—enabling you to validate investment theses with forensic rigor and reduce the risk of catastrophic research errors.

Long/Short Thesis Validation Framework
$35
Long/Short4.0(35)
Long/Short Thesis Validation Framework

You can decompose complex investment theses into measurable components, stress-test narrative consistency against market scenarios, and identify logical gaps or metric blind spots before committing capital. This framework separates fundamental thesis soundness from market timing risk, helping you distinguish between theses that are broken versus theses that are correct but prematurely positioned.

ESG/Impact Report Builder for Institutional Disclosure
$35
Reporting4.2(30)
ESG/Impact Report Builder for Institutional Disclosure

You can rapidly assemble institutional-grade ESG and impact reports by integrating quantitative metrics, qualitative narratives, materiality assessments, and third-party validations across multiple frameworks (GRI, SASB, TCFD, ISSB, SDG). The skill reduces report production timelines from weeks to days while ensuring consistency, regulatory alignment, and stakeholder credibility—whether you're preparing standalone sustainability reports, due diligence data rooms, investor fact books, or fund impact disclosures.

Structured Product Valuation & Risk Framework
$40
Structured4.5(11)
Structured Product Valuation & Risk Framework

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.

Portfolio Performance Attribution Analyzer
$45
Portfolio Performance Attribution Analyzer

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.

Consumer Sector Competitive Positioning Analysis
$45
Consumer4.3(33)
Consumer Sector Competitive Positioning Analysis

You can systematically evaluate consumer companies' competitive defensibility, pricing sustainability, and vulnerability to disruption. This skill helps you differentiate between companies with durable moats and those facing margin compression, translating qualitative competitive assessments into investable theses that support valuation spreads and sector rotation decisions.

Real Estate Deal Analysis Framework for Acquisitions
$35
Real Estate Deal Analysis Framework for Acquisitions

You can systematically evaluate real estate acquisition opportunities by inputting property financials, market data, and deal terms into a standardized framework. The skill analyzes cap rates, cash flow projections, market fundamentals, and risk factors to generate consistent, comparable metrics across multiple deals. This enables you to quickly identify investment-worthy opportunities versus deals that fail fundamental criteria, while documenting your investment thesis for compliance and portfolio tracking.

Capital Markets Deal Structure Advisor
$35
Capital Markets Deal Structure Advisor

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.

$40.00