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.
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
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/analyzing-reit-financials/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How analyzing-reit-financials Compares
| Feature / Agent | analyzing-reit-financials | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/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
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
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
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
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
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
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
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
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
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
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
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
Constructs and interprets implied volatility surfaces with skew analysis and term structure assessment. Use when analyzing vol surfaces, interpreting skew, or modeling volatility dynamics.