Communitygithub.com

REIT 投資組合分析管理工具

結構化評估 REIT 投資組合的物業層級分析、地理分散程度與租戶集中度。適用於 REIT 投資組合分析、物業組合評估或集中風險評估。

REIT 投資組合分析管理工具 是什麼?

此技能旨在幫助開發者、分析師或 AI 代理有效分析房地產投資信託(REIT)的投資組合。它提供了一個結構化的工作流程,涵蓋物業層級數據整理、行業配置分析、地理分散評估、租戶集中度審查,以及投資組合品質指標計算。用戶可以輸入物業清單、租金摘要、財務數據及債務結構,技能會自動生成一份包含執行摘要、行業配置表、地理熱點圖、租戶集中表、租約到期時間表及風險警示摘要的綜合管理報告。此技能支援 Equity REIT 和 Mortgage REIT,並與一般 AI 代理平台相容,特別適合需要深入進行投資盡職調查、風險評估或投資組合再平衡的場景。通過標準化評估流程和自動計算,它顯著提升了 REIT 分析的一致性和效率。

相容平台✓Claude Code~Codex CLI~Cursor
npx skills add https://github.com/Mr-Nobody-Anonymous/All-skills/tree/HEAD/awesome_skills/finance/managing-reit-portfolio-analysis

在你喜歡的 AI 中提問

開啟一個已預先載入此 Agent Skill 的新對話。

說明文件

管理 REIT 投資組合分析

以物業層級分析、地理分散程度、租戶集中度評估及行業配置審查,結構化地評估 REIT 投資組合。

使用時機

  • 評估權益型或抵押型 REIT 的物業持有情況,以進行投資盡職調查
  • 評估 REIT 投資組合內的地理與租戶集中風險
  • 比較行業配置(辦公、工業、零售、住宅、特殊用途)與基準或同業
  • 在資本籌集、授信額度續約或評級機構簡報前,審查投資組合品質
  • 監控投資組合是否偏離既定投資授權或目標配置

需收集的輸入資料

  • 物業清單:完整的資產清單,包含物業名稱、類型、地點(MSA/州)、平方英尺或單位數、取得日期、取得成本或現行帳面價值
  • 租金摘要:按年化基礎租金(ABR)或占總收入百分比排序的前幾大租戶、租約到期時間表、加權平均租期(WALT)
  • 財務數據:各物業或部門的淨營業收入(NOI)、同店 NOI 成長率、出租率、取得時的資本化率與當前市場資本化率
  • 債務結構:物業層級或資產池層級的擔保債務、貸款成數(LTV)比率、到期時間輪廓
  • 基準數據:同業 REIT 配置、NAREIT 行業指數,或內部目標配置政策 [請驗證:確認利害關係人使用的基準集合]

工作流程

  1. 編譯物業層級數據

    • 將物業類型標準化為常見類別(辦公、工業、多戶住宅、零售、醫療保健、數據中心、自助儲物、特殊用途)
    • 確認計算百分比時所用的總資產總值(GAV)或企業價值分母
    • 對任何缺少 NOI、出租率或估值數據的物業標記為 [請驗證]
  2. 分析行業配置

    • 計算各物業類型占 GAV、NOI 貢獻及平方英尺的比例
    • 與該 REIT 的既定策略及同業中位數配置進行比較
    • 識別相對於基準的超配/低配部位
  3. 評估地理分散程度

    • 按 MSA、州及區域繪製物業分布圖
    • 計算集中度指標:前 1、3、5、10 大市場的 GAV 及 NOI 占比
    • 將 GAV 或 NOI 中單一市場占比超過 20% 標記為高風險
    • 記錄對需求趨勢不利的市場的曝險情況(例如高空置率 MSA 中的辦公物業)[請驗證:標記 MSA 的當前市場狀況]
  4. 評估租戶集中度

    • 按 ABR 貢獻對租戶進行排序;識別前 10 大租戶及其累計占比
    • 將任何單一租戶 ABR 占比 >5%,或前 10 大租戶合計占比超過 40% 標記為警示
    • 在可取得數據的情況下,評估租戶信用品質(投資級 vs. 未評級)[請驗證:截至分析日期的信用評級為最新]
    • 按年度繪製未來 5 年的租約到期時間表;突顯任何一年 ABR 到期占比超過 15% 的情況
  5. 審查投資組合品質指標

    • 計算整個投資組合的加權平均出租率
    • 計算加權平均剩餘租期
    • 評估同店 NOI 成長趨勢(過去 4-8 季)
    • 識別出租率、NOI 利潤率或資本化率利差最後四分之一的資產
  6. 綜合風險與機會標記

    • 總結集中度風險(地理、租戶、行業)
    • 識別潛在出售標的(績效不佳、非核心)
    • 注意在相同期間集中的即將到來的租約到期或債務到期
    • 突顯與該 REIT 既定投資主題的相符或偏離程度

輸出

製作一份結構化的管理報告,內容包含:

  • 執行摘要:投資組合規模、行業組合、關鍵集中度指標及高層風險評估(2-3 段)
  • 行業配置表:物業類型、物業數量、GAV、NOI、各項占比
  • 地理熱點圖數據:依 GAV 及 NOI 排序的前 10 大 MSA,附帶集中度百分比
  • 租戶集中度表:前 10 大租戶、ABR、占總 ABR 百分比、信用評級、WALT
  • 租約到期時間表:第 1 至 5 年每年到期的 ABR 金額及累計百分比
  • 風險標記摘要:集中度超標、數據缺口及市場層級疑慮的逐項清單
  • 建議事項:具體後續步驟(再平衡目標、潛在出售標的、進一步盡職調查項目)

品質檢查

  • 所有百分比總和須在四捨五入容忍範圍內(±0.5%)正確加總為 100%
  • NOI 與 GAV 總額須與來源財務報表或補充資料核對一致
  • 租戶名稱及租約條款須與最新租金清單一致;過時數據需標記 [請驗證]
  • 地理分類使用一致的 MSA 定義(例如人口普查局 CBSA 邊界)[請驗證:確認使用的 MSA 定義標準]
  • 在標記超標前,所套用的集中度門檻須符合該 REIT 自身的政策限制或授信額度契約
  • 報告須清楚區分已確認數據與分析師估計值

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

Mr-Nobody-Anonymous/All-skills

Build agency portfolios. TRIGGERS - Use when user needs help with agency-portfolio-builder related tasks.

Mr-Nobody-Anonymous/All-skills

Generate landing pages with AI. TRIGGERS - Use when user needs help with ai-landing-page-gen related tasks.

Mr-Nobody-Anonymous/All-skills

Skill for discovering and researching autonomous AI agents, tools, and ecosystems using the AgentFolio directory.

Mr-Nobody-Anonymous/All-skills

Review investment portfolios with rebalancing recommendations. TRIGGERS - Use when user needs help with investment-portfolio-review related tasks.

Mr-Nobody-Anonymous/All-skills

Create makeup artist portfolio guides. TRIGGERS - Use when user needs help with makeup-artist-portfolio related tasks.

Mr-Nobody-Anonymous/All-skills

Build freelance portfolios with case studies. TRIGGERS - Use when user needs help with freelance-portfolio-builder related tasks.

Mr-Nobody-Anonymous/All-skills

Structures secondary portfolio construction with vintage diversification, strategy mix, and geographic allocation optimization. Use when building secondary portfolios, managing allocation targets, or optimizing portfolio composition.

Mr-Nobody-Anonymous/All-skills

Optimize landing page copy for conversions. TRIGGERS - Use when user needs help with landing-page-optimizer related tasks.

Mr-Nobody-Anonymous/All-skills

Build copywriting portfolios. TRIGGERS - Use when user needs help with copywriting-portfolio related tasks.

Mr-Nobody-Anonymous/All-skills

Design cryptocurrency portfolio strategies. TRIGGERS - Use when user needs help with crypto-portfolio-strategy related tasks.

Mr-Nobody-Anonymous/All-skills

Build UX design portfolios. TRIGGERS - Use when user needs help with ux-portfolio-builder related tasks.

Mr-Nobody-Anonymous/All-skills

Design cloud landing zones. TRIGGERS - Use when user needs help with cloud-landing-zone related tasks.

Mr-Nobody-Anonymous/All-skills

Generate high-converting landing page copy with headlines, benefits, CTAs, and social proof. TRIGGERS - Use when user wants landing page copy, sales page content, or conversion-focused web copy.

Mr-Nobody-Anonymous/All-skills

Design portfolio assessment systems. TRIGGERS - Use when user needs help with portfolio-assessment related tasks.

Mr-Nobody-Anonymous/All-skills

Conducts portfolio performance measurement with benchmark comparison, attribution, and risk-adjusted metrics. Use when measuring portfolio performance, calculating Sharpe/Sortino ratios, or conducting performance attribution.

Mr-Nobody-Anonymous/All-skills

Builds strategic and tactical asset allocation models with risk-return optimization and constraint management. Use when constructing portfolios, optimizing asset allocation, or building model portfolios.

Mr-Nobody-Anonymous/All-skills

Creates client-facing portfolio reports with performance, allocation, commentary, and outlook. Use when producing client reports, preparing quarterly reviews, or creating portfolio summaries.

Mr-Nobody-Anonymous/All-skills

Design investment portfolios. TRIGGERS - Use when user needs help with investment-portfolio-design related tasks.

Mr-Nobody-Anonymous/All-skills

Plan investment portfolios. TRIGGERS - Use when user needs help with investment-portfolio-plan related tasks.

Mr-Nobody-Anonymous/All-skills

You are a Conversion Rate Optimization Strategist and Persuasive Content Specialist. Use this skill when the user wants to audit or improve a landing page, write conversion-focused copy, optimize CTAs, build an FAQ schema block, translate features into benefits, or maximize conversions on any specific page type. Activate when the user mentions "landing page," "sales page," "lead capture page," "squeeze page," "webinar sign-up page," "product launch page," "waitlist page," "early access page," "thank you page," "upsell page," "SaaS pricing page," "onboarding page," "ecommerce page," "audit this page," "improve conversions," "CTA optimization," "hero section," "headline rewrite," "subhead," "benefits section," "features to benefits," "FAQ schema," "schema FAQ," "trust elements," "page layout," "above the fold," "scroll order," "microcopy," "mobile-first copy," "landing page copy," "page flow," "drop-off," "weak CTA," "conversion copy," "page goal," "split test copy," "A/B test copy," or "wireframe suggestion...

相關技能