analyzing-reit-financials

Evaluates REIT financial performance with FFO, AFFO, NAV, and leverage metrics. Use when analyzing REITs, calculating FFO/AFFO, or comparing REIT valuations.

11 stars

Best use case

analyzing-reit-financials is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

Evaluates REIT financial performance with FFO, AFFO, NAV, and leverage metrics. Use when analyzing REITs, calculating FFO/AFFO, or comparing REIT valuations.

Teams using analyzing-reit-financials should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

  • You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

  • You only need a quick one-off answer and do not need a reusable workflow.
  • You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/analyzing-reit-financials/SKILL.md --create-dirs "https://raw.githubusercontent.com/CaseMark/skills/main/skills/finance/analyzing-reit-financials/SKILL.md"

Manual Installation

  1. Download SKILL.md from GitHub
  2. Place it in .claude/skills/analyzing-reit-financials/SKILL.md inside your project
  3. Restart your AI agent — it will auto-discover the skill

How analyzing-reit-financials Compares

Feature / Agentanalyzing-reit-financialsStandard Approach
Platform SupportNot specifiedLimited / Varies
Context Awareness High Baseline
Installation ComplexityUnknownN/A

Frequently Asked Questions

What does this skill do?

Evaluates REIT financial performance with FFO, AFFO, NAV, and leverage metrics. Use when analyzing REITs, calculating FFO/AFFO, or comparing REIT valuations.

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

SKILL.md Source

# Analyzing REIT Financials

## When To Use

- Evaluating a REIT's operating performance for investment or lending decisions
- Calculating FFO, AFFO, or NAV from 10-K/10-Q filings or supplemental data packages
- Comparing REIT valuations across peers within the same property sector
- Assessing leverage, coverage ratios, and distribution sustainability
- Preparing underwriting memos or investment committee summaries for REIT-backed transactions

## Inputs To Gather

- **Financial statements**: Income statement, balance sheet, cash flow statement (at least 2–3 periods for trend analysis)
- **Supplemental operating data**: Same-store NOI, occupancy rates, lease expirations, tenant concentration
- **Capitalization details**: Share count (diluted), OP units, preferred equity, convertible instruments
- **Debt schedule**: Outstanding balances, maturities, interest rates, secured vs. unsecured split, credit facility availability
- **Distribution history**: Dividend per share, payout ratio, DRIP participation
- **Peer set**: 3–5 comparable REITs by property type, geography, and market cap for relative valuation
- **Market data**: Current share price, trading volume, analyst consensus estimates

## Workflow

1. **Calculate FFO**
   - Start with GAAP net income attributable to common shareholders
   - Add back real estate depreciation and amortization
   - Remove gains/losses on property sales and impairments
   - Adjust for unconsolidated JV interests (proportionate share)
   - Express as FFO per diluted share/unit

2. **Calculate AFFO (CAD/FAD)**
   - Begin with FFO
   - Subtract recurring capital expenditures (maintenance capex, tenant improvements, leasing commissions)
   - Adjust for straight-line rent and above/below-market lease amortization
   - Add back non-cash compensation expense
   - Express as AFFO per diluted share/unit and compute AFFO payout ratio (dividends ÷ AFFO)

3. **Estimate Net Asset Value (NAV)**
   - Capitalize stabilized NOI by property segment using appropriate cap rates [VERIFY cap rate sources — broker surveys, transaction comps, or appraised values]
   - Add value of development pipeline, land bank, and other tangible assets at estimated fair value
   - Add cash and receivables; subtract total debt, preferred equity, and other liabilities at face or fair value
   - Divide by fully diluted share/unit count to arrive at NAV per share
   - Compare current share price to NAV: premium/(discount) = (Price − NAV) ÷ NAV

4. **Assess Leverage and Coverage**
   - **Debt-to-Gross Assets**: Total debt ÷ (total assets + accumulated depreciation)
   - **Net Debt / EBITDA**: (Total debt − cash) ÷ trailing EBITDA (target typically 5.0×–7.0× depending on sector) [VERIFY sector-specific thresholds]
   - **Fixed Charge Coverage**: Adjusted EBITDA ÷ (interest expense + preferred dividends + secured debt amortization); minimum 1.5× is common benchmark
   - **Secured Debt Ratio**: Secured debt ÷ total assets; most investment-grade REITs target < 40%
   - **Debt Maturity Profile**: Flag any single-year maturity exceeding 15–20% of total debt

5. **Peer Comparison**
   - Assemble a table with: P/FFO, P/AFFO, premium/discount to NAV, dividend yield, same-store NOI growth, leverage metrics
   - Rank subject REIT within peer group on each metric
   - Note any structural differences affecting comparability (e.g., external vs. internal management, JV-heavy structures, development exposure)

6. **Distribution Sustainability**
   - AFFO payout ratio above 90% signals limited retained cash flow cushion
   - Review trend in AFFO per share vs. dividend per share over 3+ years
   - Check whether distributions are funded by asset sales, debt draws, or equity issuance rather than operating cash flow

## Output

Produce a structured analysis report containing:

- **Executive Summary**: One-paragraph investment thesis with bull/bear case and key conclusion
- **FFO / AFFO Bridge**: Tabular reconciliation from GAAP net income to FFO to AFFO with per-share figures
- **NAV Summary**: Segment-level NOI and cap rate assumptions, NAV per share, and premium/discount
- **Leverage Dashboard**: Key ratios with traffic-light indicators (green/yellow/red relative to sector norms)
- **Peer Comp Table**: Side-by-side metrics for subject and comparable REITs
- **Risk Factors**: Tenant concentration, lease rollover exposure, floating-rate debt percentage, geographic concentration
- **Appendix**: Detailed assumptions, data sources, and any items marked [VERIFY]

## Quality Checks

- FFO reconciliation must tie back to the GAAP income statement line by line — any unexplained delta should be flagged
- Confirm diluted share count includes OP units, vested RSUs, and in-the-money convertibles
- Verify cap rates used for NAV are sourced and dated; stale cap rates can materially distort NAV
- AFFO maintenance capex should reflect actual recurring spend, not management's normalized guidance, unless justified
- Ensure leverage ratios use consistent definitions (e.g., gross vs. net debt, GAAP vs. pro forma EBITDA)
- Cross-check dividend yield calculation against most recent declared distribution and current price
- Mark any metric that relies on management-reported non-GAAP adjustments with [VERIFY] for independent confirmation

Related Skills

analyzing-vital-statistics

11
from CaseMark/skills

Structures vital records analysis with birth, death, and demographic trend reporting. Use when analyzing vital statistics, interpreting mortality data, or reporting demographic trends.

analyzing-social-determinants-of-health

11
from CaseMark/skills

Maps social determinants affecting health outcomes with intervention strategy development. Use when analyzing SDOH, mapping community resources, or designing social health interventions.

analyzing-pharmacovigilance-data

11
from CaseMark/skills

Structures post-marketing safety surveillance with signal detection and PSUR reporting. Use when analyzing safety signals, preparing PSURs, or managing pharmacovigilance data.

analyzing-flow-cytometry

11
from CaseMark/skills

Interprets flow cytometry panels for hematologic malignancy classification and minimal residual disease. Use when analyzing flow cytometry, classifying lymphomas/leukemias, or documenting immunophenotyping.

analyzing-epidemiological-data

11
from CaseMark/skills

Structures epidemiologic analysis with incidence, prevalence, rate calculations, and statistical inference. Use when calculating disease rates, analyzing epi data, or interpreting population statistics.

analyzing-clinical-trial-data

11
from CaseMark/skills

Structures clinical trial data analysis with primary endpoint evaluation and safety reporting. Use when analyzing trial results, evaluating endpoints, or preparing statistical reports.

analyzing-clinical-data-warehouses

11
from CaseMark/skills

Structures clinical data warehouse queries for quality measurement, research, and operational analytics. Use when querying clinical data, building analytics reports, or extracting research datasets.

managing-reit-portfolio-analysis

11
from CaseMark/skills

Structures REIT portfolio evaluation with property-level analysis, geographic diversification, and tenant concentration. Use when analyzing REIT portfolios, evaluating property mix, or assessing concentration risk.

analyzing-yield-curves

11
from CaseMark/skills

Interprets yield curve shapes with term structure analysis and relative value identification. Use when analyzing yield curves, identifying curve trades, or interpreting interest rate expectations.

analyzing-wealthtech-platforms

11
from CaseMark/skills

Evaluates wealth management technology with robo-advisory models, digital planning, and fee analysis. Use when analyzing wealthtech, evaluating robo-advisors, or assessing digital wealth platforms.

analyzing-water-risk

11
from CaseMark/skills

Structures water risk assessment with water stress mapping, usage analysis, and regulatory exposure evaluation. Use when analyzing water risk, mapping water stress, or evaluating water-related financial exposure.

analyzing-volatility-surfaces

11
from CaseMark/skills

Constructs and interprets implied volatility surfaces with skew analysis and term structure assessment. Use when analyzing vol surfaces, interpreting skew, or modeling volatility dynamics.