Communitygithub.com

Mr-Nobody-Anonymous/All-skills

結構化貸款組合審查,包含信用品質趨勢、觀察名單管理和集中度分析。適用於監控貸款組合、追蹤信用品質或管理觀察名單時使用。

All-skills 是什麼?

這項技能旨在協助使用者和AI代理執行全面性的貸款組合監控報告製作流程。它提供一個結構化的框架,從數據驗證開始,逐步完成組合快照編制、信用品質趨勢分析、觀察名單管理、集中度風險評估、損失覆蓋率評估,最終產出可供管理層或信貸委員會參考的正式報告。此技能特別強調數據完整性,要求對照總帳核對試算表,並確保所有風險評級均為最新,任何缺失欄位的貸款都會被標記。在觀察名單管理方面,技能提供新增、更新及移除項目的明確指引,包括指定負責人(關係經理或處理官員)和設定下次審查日期。此外,集中度風險分析會自動與董事會核准的限額進行比對,並對接近或超過門檻的情況發出警報,同時計算CRE對資本比率等關鍵監管指標。最終產出包含執行摘要、組合組成表、風險評級遷移矩陣、觀察名單明細、集中度儀表板以及行動項目,確保報告清晰、可追溯且具備行動導向。

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

在你喜歡的 AI 中提問

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

說明文件

管理貸款組合監控

結構化貸款組合審查,包含信用品質趨勢、觀察名單管理和集中度分析。

使用時機

  • 為信用委員會或董事會準備定期(每月/每季)貸款組合審查報告
  • 追蹤貸款在不同風險評級類別之間的遷移情況
  • 建立或更新包含降級/升級觸發條件的信用觀察名單
  • 分析按行業、地區、借款人、擔保品類型或產品的組合集中度
  • 回應監管機構針對組合管理或集中度風險的檢查結果
  • 評估相對於組合趨勢的信用損失準備金(ACL)充足性

需蒐集的輸入資料

  • 貸款試算表 — 未償還餘額、承諾金額、風險評級、到期日、應計狀態
  • 風險評級歷史 — 前期評級,用於遷移分析(至少兩個季度,最好四個季度)
  • 觀察名單 — 當前的觀察名單,包含列入日期、行動計劃和最後審查日期
  • 逾期與拖欠報告 — 30/60/90+ 天區間、非應計貸款、債務重整/貸款修改
  • 集中度政策限額 — 董事會核准的按行業、地區、單一借款人、CRE/C&I 劃分及產品類型的限額 [根據現行董事會政策進行驗證]
  • 沖銷與回收數據 — 按區間劃分的報告期間及過去12個月的淨沖銷額
  • 擔保品估值 — 最新的鑑價或評估報告、有擔保信貸的貸款成數計算
  • 經濟/市場數據 — 影響主要組合區塊的相關基準(失業率、CRE空置率、大宗商品價格)

工作流程

  1. 驗證資料完整性

    • 將貸款試算表總額與總分類帳核對
    • 確認風險評級為最新(無超過審查週期的過時評級)
    • 標記任何缺少必要欄位(評級、NAICS代碼、擔保品類型)的貸款,並加上 [驗證] 標記
  2. 編制組合快照

    • 彙總總承諾金額、未償還餘額和未動用承諾
    • 按貸款類型劃分(C&I、自用型CRE、非自用型CRE、建築貸款、消費貸款、貿易融資)
    • 顯示相對於前期在金額和百分比上的變化
  3. 分析信用品質趨勢

    • 建立風險評級遷移矩陣(期初 vs 期末評級)
    • 計算整個組合及主要區塊的加權平均風險評級
    • 追蹤應注意及分類資產比率(特殊提及、次級、可疑)與政策門檻的比較 [根據內部政策驗證門檻]
    • 彙總逾期趨勢和非應計餘額,並附上根本原因說明
  4. 管理觀察名單

    • 新增項目,包含:借款人名稱、未償還曝險額、風險評級、納入觀察原因及建議行動計劃
    • 更新現有項目,附上進度說明和修訂後的時間表
    • 僅在信用已被調升、清償或沖銷時移除項目,並記錄移除理由
    • 指派明確的負責人(關係經理或處理官員)及下次審查日期
  5. 評估集中度風險

    • 將實際集中度與每個類別的董事會核准限額進行比較
    • 標記任何限額違規或接近門檻的情況(例如,超過限額的80%)
    • 對於CRE集中度,計算CRE對資本比率和建築貸款對資本比率 [根據跨機構CRE監管指引門檻進行驗證:300% 和 100%]
    • 識別接近法定貸款限額的單一借款人或相關實體曝險
  6. 評估損失覆蓋率

    • 比較ACL對總貸款比率與同業基準及歷史區間
    • 評估不良貸款的ACL覆蓋率
    • 根據觀察到的趨勢,記錄任何需要修正的定性調整因子
  7. 準備管理報告

    • 執行摘要,包含關鍵指標和趨勢箭頭(改善/穩定/惡化)
    • 組合組成表格和圖表
    • 信用品質遷移矩陣
    • 觀察名單細節及行動項目
    • 集中度儀表板,顯示政策限額及目前使用率
    • 建議行動和提報委員會決策的升級事項

產出

一份結構化的貸款組合監控報告,包含:

  • 執行摘要 — 主要指標(組合總規模、加權平均風險評級、分類資產比率、淨沖銷率、前三大集中度)及相對於前期的趨勢指標
  • 組合組成表格 — 按產品、行業、地區和到期區間劃分
  • 風險評級遷移矩陣 — 顯示升級、降級和穩定的可視化網格
  • 觀察名單 — 可排序表格,包含借款人、曝險額、評級、觀察原因、行動計劃、負責人及下次審查日期
  • 集中度分析 — 儀表板,以紅綠燈指示燈(綠/黃/紅)比較實際曝險與政策限額
  • 行動項目 — 編號列表,列出建議的委員會決策、升級事項及後續行動截止日期

品質檢查

  • 所有組合總額均能與總分類帳核對一致 — 無無法解釋的差異
  • 風險評級遷移矩陣的行列總和平衡(期初數量 ± 新增/清償/沖銷 = 期末數量)
  • 每個觀察名單項目都有一個指定的負責人、具體的行動計劃和下次審查日期
  • 集中度百分比使用一致的計算分母(監管比率使用第一類資本 + ACL,內部限額使用總承諾金額或未償還總額)[根據機構政策驗證分母慣例]
  • 逾期和非應計數字能與明細報告核對一致
  • 報告在相關處清楚區分已承諾與未償還曝險
  • 所有外部參考的門檻(監管指引、同業數據)均須註明來源和日期
  • 需要委員會決策的事項應明確指出,而非隱藏在敘述中

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...

相關技能