Communitygithub.com

Mr-Nobody-Anonymous/All-skills

结构化贷款组合审查,涵盖信贷质量趋势、观察名单管理和集中度分析。用于监控贷款组合、跟踪信贷质量或管理观察名单。

All-skills 是什么?

该技能提供了一套完整的贷款组合监控工作流程,涵盖数据验证、信贷质量趋势分析、观察名单管理、集中度风险评估以及损失覆盖率评估。它适用于银行、信用合作社及其他金融机构的信贷委员会或董事会定期(月度/季度)贷款组合审查报告的编写。技能支持信用评级迁移矩阵构建、加权平均风险评级计算、不良资产比率跟踪、集中度阈值监控(如行业、地域、单一借款人等)以及贷款损失准备金(ACL)充足性评估。输出为结构化的管理报告,包含执行摘要、组合构成表格、观察名单详情、集中度仪表盘以及行动项建议,确保所有数据与总账一致,并引用权威监管指导(如机构间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+天分组、非应计贷款、TDR/贷款修改
  • 集中度政策限额 — 董事会按行业、地域、单一借款人、CRE/C&I拆分和产品类型批准的限额[根据当前董事会政策核验]
  • 核销与回收数据 — 报告期及过去12个月按分组的净核销
  • 抵押品估值 — 最新的评估或估值报告,有担保信用的LTV计算
  • 经济/市场数据 — 影响关键组合板块的相关基准(失业率、CRE空置率、商品价格)

工作流程

  1. 验证数据完整性

    • 将贷款试算表总额与总账调节一致
    • 确认风险评级为最新(审查周期内无过时评级)
    • 标记任何缺少必填字段(评级、NAICS代码、抵押品类型)的贷款,并附上[核验]标记
  2. 编制组合概览

    • 汇总总承诺金额、未偿余额及未提取承诺
    • 按贷款类型分类(C&I、CRE自用、CRE非自用、建设、消费、贸易融资)
    • 展示各期之间的金额和百分比变化
  3. 分析信贷质量趋势

    • 构建风险评级迁移矩阵(期初 vs. 期末评级)
    • 计算组合及主要板块的加权平均风险评级
    • 跟踪关注类和不良类资产比率(特别关注、次级、可疑)与政策阈值对比[根据内部政策核验阈值]
    • 汇总逾期趋势和非应计余额,附根本原因说明
  4. 管理观察名单

    • 新增条目:借款人名称、未偿风险敞口、风险评级、列入观察原因、建议行动计划
    • 更新现有条目:进度说明和修改后的时间表
    • 仅在信用已升级、偿还或核销时移除条目——记录移除依据
    • 明确分配负责人(客户经理或清收专员)和下次审查日期
  5. 评估集中度风险

    • 将实际集中度与各类别董事会批准限额进行比较
    • 标记任何限额突破或接近阈值的情况(例如超过限额80%)
    • 对于CRE集中度,计算CRE对资本比率和建设对资本比率[根据机构间CRE指引阈值核验:300%和100%]
    • 识别单一借款人或关联实体接近法定贷款限额的风险敞口
  6. 评估损失覆盖率

    • 将ACL对总贷款比率与同业基准和历史范围进行比较
    • 评估ACL对不良贷款的覆盖率
    • 记录基于观察趋势可能需要修订的定性调整因素(Q因素)
  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...

相关技能