Corporate Credit Memo Skill
Produces full institutional-grade Credit Application Memoranda (20–30+ pages) from uploaded
financial documents and user-provided deal parameters. Output follows the 8-section structure
used by major international banks, with all financial ratios calculated and flagged where data
is insufficient.
Step 1 — Intake & Clarification
When triggered, immediately check what the user has provided. Do NOT ask multiple questions
at once. Follow this sequence:
1a. Check for uploaded files
If annual reports / financial statements are attached → proceed to Step 2.
If nothing is attached, ask:
"Please upload the company's annual reports (last 2–3 years, PDF or Word). If you don't
have them, paste the key financials and I'll work with those."
1b. Collect deal parameters (ask once, in a single message)
Once files are confirmed, ask the user to confirm or provide:
CODEBLOCK0
Tell the user:
"Items marked [TO BE CONFIRMED] will be flagged in the report for your team to complete —
including RAROC, internal limits, and any policy-specific thresholds."
Step 2 — Document Extraction
Read all uploaded files carefully. Extract and organise:
From financial statements (P&L, Balance Sheet, Cash Flow):
- - 3 years of annual data + latest interim period if available
- All line items needed for ratio calculation (see
references/financial-ratios.md) - Auditor name and opinion type (unqualified / qualified / emphasis of matter)
- Reporting currency and any FX translation notes
From the annual report narrative:
- - Business description, segment breakdown, revenue mix
- Key customers and suppliers (concentration risk)
- Management team and ownership structure
- Geographic footprint
- Material litigation, contingent liabilities, off-balance-sheet items
- ESG disclosures if present
Flag clearly any data that is:
- - Missing → label INLINECODE1
- Restated vs prior year → note the restatement
- Unaudited → label INLINECODE2
Step 3 — Research (Web Search)
Use web search to supplement document data for:
- - Industry overview: market size, growth rate, cycle positioning
- Regulatory / policy environment relevant to the borrower's sector
- Competitive landscape: 2–3 named peers with approximate market share
- Recent news on the company (last 12 months): M&A, rating actions, management changes
- Macroeconomic context relevant to the jurisdiction and sector
Do NOT fabricate specific figures. If web search returns insufficient data, note:
"[Industry data limited — recommend analyst review / Bloomberg supplement]"
Step 4 — Calculate Financial Ratios
Read references/financial-ratios.md for all formulas and flag logic.
Calculate every ratio for each available year. Apply the following flag rules:
- - ✅ Calculated successfully → show figure
- ⚠️ Calculated but at borderline threshold → show figure + note
- 🔲 Data insufficient → show INLINECODE4
- 📋 Requires internal input → show INLINECODE5
RAROC and internal capital allocation are always [TO BE CONFIRMED].
DSCR denominator must match the proposed repayment schedule — confirm with user if unclear.
Step 5 — Draft the Credit Memo
Read references/credit-memo-structure.md for the full 8-section structure and
content requirements for each section.
Drafting principles:
- - Write in formal institutional English — consistent with major UK/international bank standards
- Tone: analytical, direct, no marketing language
- Every material statement should be traceable to either the uploaded documents or web search
- Clearly distinguish facts from analytical judgements
- Use tables for all financial data — never prose for numbers
- Section headers must match the structure in
references/credit-memo-structure.md exactly - Flag all
[TO BE CONFIRMED] items inline — do not omit them or leave blank - Do not invent internal policy figures (hurdle rates, limits, RWA) — always flag these
Risk section (Section 6):
Read
references/risk-framework.md before drafting.
Assign a risk rating (Low / Medium / High) for each risk category with a one-line rationale.
This section reflects the analytical approach expected of a senior risk function,
consistent with PRA supervisory expectations for credit risk governance.
Disclaimer:
Append the standard disclaimer from
assets/disclaimer.md at the end of every report.
Step 6 — Output as Word Document (.docx)
Generate the final report as a formatted .docx file using the docx skill conventions:
- - Font: Arial throughout
- Colour scheme: dark navy headers (#1F4E79), mid-blue subheadings (#2E75B6)
- All financial tables: dark navy header row, alternating white/light-blue rows
- Info tables (deal terms, company details): two-column label/value format
- Risk rating boxes: colour-coded text (green=Low, amber=Medium, red=High)
- Page header: "Credit Application Memorandum | Confidential — Internal Use Only"
- Page footer: document date + page number
- Cover page: borrower name, facility type, amount, date, classification label
Present the .docx file to the user when complete.
Also offer a brief verbal summary of the key credit highlights and top 3 risks.
Quality Checklist (run before presenting output)
Before finalising, verify:
- - [ ] All 3 years of financials extracted and populated in tables
- [ ] Every ratio in
references/financial-ratios.md either calculated or flagged - [ ] No internal policy figures invented (RAROC, RWA, limits)
- [ ] Risk section has a rating for each of the 7 categories
- [ ] All [TO BE CONFIRMED] items visible and not hidden
- [ ] Disclaimer appended
- [ ] Document is .docx format, not markdown
Handling Edge Cases
Listed company: Extract financials from uploaded annual report. Use web search for
stock performance context and peer comparison. Note exchange and ticker.
Unlisted / private company: Flag absence of public ratings. Rely on audited accounts.
Note that valuation of pledged equity (if any) requires independent appraisal.
Holding company borrower / SPV: Distinguish between holdco and opco financials.
Analyse guarantor separately. Note structural subordination risk.
Insufficient financials (only 1 year available): Complete what is possible.
Note that trend analysis is limited and recommend additional data before credit approval.
Chinese-language source documents: Extract data from tables regardless of language.
For narrative sections, translate key disclosures as needed. Note source language.
M&A / acquisition finance: Produce pro-forma combined financials. Separate target
and acquirer analysis. Reference references/credit-memo-structure.md Section 1 addendum
for transaction analysis structure.
企业授信备忘录技能
根据上传的财务文件及用户提供的交易参数,生成完整的机构级授信申请备忘录(20-30页以上)。输出遵循国际大型银行使用的8部分结构,所有财务比率均已计算,并在数据不足时进行标注。
第一步 — 信息接收与澄清
触发时,立即检查用户已提供的内容。请勿一次性提出多个问题。按以下顺序操作:
1a. 检查上传文件
如已附上年报/财务报表 → 进入第二步。
如未附上任何文件,请询问:
请上传公司近2-3年的年报(PDF或Word格式)。如无法提供,请粘贴关键财务数据,我将据此进行分析。
1b. 收集交易参数(一次性询问,单条消息内完成)
确认文件后,请用户确认或提供以下信息:
- 1. 借款人法定名称
- 融资类型及金额(例如:5000万英镑定期贷款 / 1.2亿美元循环信贷)
- 期限(例如:3年、5年)
- 贷款用途(营运资金 / 资本支出 / 再融资 / 并购)
- 担保/保证结构(如已知)
- 还款方式(一次性还本 / 分期摊还 / 按季还款)
- 定价(如已知——例如:SONIA + 250个基点)
- 贷款银行/分行名称
- 是否需要参考任何内部政策或行业分类?
(如不确定,请留空——我将标注为[待确认])
告知用户:
标注为[待确认]的项目将在报告中标记,供您的团队补充完善——包括RAROC、内部限额及任何政策特定阈值。
第二步 — 文件提取
仔细阅读所有上传文件。提取并整理以下内容:
从财务报表(损益表、资产负债表、现金流量表)中提取:
- - 3年年度数据 + 最新中期数据(如有)
- 比率计算所需的所有项目(参见 references/financial-ratios.md)
- 审计师名称及审计意见类型(无保留意见 / 保留意见 / 强调事项)
- 报告货币及任何外汇折算说明
从年报叙述部分提取:
- - 业务描述、业务板块划分、收入构成
- 主要客户和供应商(集中度风险)
- 管理团队及股权结构
- 地理分布
- 重大诉讼、或有负债、表外项目
- ESG披露信息(如有)
明确标注任何存在以下情况的数据:
- - 缺失 → 标注 [数据不可用——请提供]
- 与上一年度存在重述 → 注明重述情况
- 未经审计 → 标注 [未经审计]
第三步 — 研究(网络搜索)
使用网络搜索补充文件数据,涵盖以下方面:
- - 行业概况:市场规模、增长率、周期定位
- 与借款人所在行业相关的监管/政策环境
- 竞争格局:2-3家具名同业及其大致市场份额
- 公司近期新闻(过去12个月):并购、评级变动、管理层变更
- 与司法管辖区及行业相关的宏观经济背景
不得编造具体数据。如网络搜索返回数据不足,请注明:
[行业数据有限——建议分析师复核 / 彭博补充]
第四步 — 计算财务比率
阅读 references/financial-ratios.md 获取所有公式及标记逻辑。
计算每个可用年份的各项比率。应用以下标记规则:
- - ✅ 计算成功 → 显示数值
- ⚠️ 已计算但处于临界阈值 → 显示数值并附注说明
- 🔲 数据不足 → 显示 [不适用——需要数据]
- 📋 需要内部输入 → 显示 [待确认——内部政策]
RAROC和内部资本配置始终标注为 [待确认]。
DSCR分母必须与拟议还款计划一致——如不明确,请与用户确认。
第五步 — 起草授信备忘录
阅读 references/credit-memo-structure.md 获取完整的8部分结构及各部分内容要求。
起草原则:
- - 使用正式的机构英语——符合主要英国/国际银行标准
- 语气:分析性、直接,不使用营销语言
- 每项实质性陈述均应可追溯至上传文件或网络搜索
- 清晰区分事实与分析判断
- 所有财务数据使用表格呈现——切勿以文字形式列出数字
- 章节标题必须与 references/credit-memo-structure.md 中的结构完全一致
- 所有 [待确认] 项目须在文中标注——不得省略或留空
- 不得编造内部政策数据(最低回报率、限额、风险加权资产)——始终标注这些项目
风险部分(第六部分):
起草前阅读 references/risk-framework.md。
为每个风险类别分配风险评级(低 / 中 / 高),并附一行理由说明。
本部分反映高级风险职能部门的分析方法,符合PRA对信用风险治理的监管期望。
免责声明:
在每份报告末尾附加 assets/disclaimer.md 中的标准免责声明。
第六步 — 输出为Word文档(.docx)
使用docx技能规范生成格式化的.docx格式最终报告:
- - 字体:全文使用Arial
- 配色方案:深海军蓝标题(#1F4E79)、中蓝色副标题(#2E75B6)
- 所有财务表格:深海军蓝表头行,交替使用白色/浅蓝色行
- 信息表格(交易条款、公司详情):两列标签/数值格式
- 风险评级框:颜色编码文本(绿色=低、琥珀色=中、红色=高)
- 页眉:授信申请备忘录 | 机密——仅供内部使用
- 页脚:文档日期 + 页码
- 封面页:借款人名称、融资类型、金额、日期、分类标签
完成后向用户呈现.docx文件。
同时提供关键授信亮点及前三大风险的口头简要总结。
质量检查清单(在呈现输出前执行)
定稿前,请验证:
- - [ ] 所有3年财务数据已提取并填入表格
- [ ] references/financial-ratios.md 中的每项比率均已计算或标记
- [ ] 未编造任何内部政策数据(RAROC、风险加权资产、限额)
- [ ] 风险部分中7个类别均有评级
- [ ] 所有[待确认]项目可见且未被隐藏
- [ ] 已附加免责声明
- [ ] 文档为.docx格式,非markdown格式
边缘情况处理
上市公司: 从上传的年报中提取财务数据。使用网络搜索获取股票表现背景及同业比较。注明交易所及股票代码。
非上市/私营公司: 标注缺乏公开评级。依赖经审计的账目。注明质押股权(如有)的估值需独立评估。
控股公司借款人/特殊目的公司: 区分控股公司与运营公司的财务数据。单独分析担保人。注明结构性从属风险。
财务数据不足(仅1年数据可用): 完成可能完成的部分。注明趋势分析受限,建议在授信审批前补充更多数据。
中文源文件: 无论语言如何,从表格中提取数据。对于叙述部分,根据需要翻译关键披露信息。注明源语言。
并购/收购融资: 编制备考合并财务数据。分别分析目标公司和收购方。参考 references/credit-memo-structure.md 第一部分附录中的交易分析结构。