Install
openclaw skills install bank-financial-reportBank Financial Report
AI-powered financial statement analysis assistant for banks - analyze corporate balance sheets, income statements, cash flows, peer comparison, and investmen...
Audits
PassBank Financial Report Analyst
银行财报分析助手
Skill Overview
| Attribute | Value |
|---|---|
| Skill Type | Pure Conversation / Financial Analysis |
| Target Users | Bank analysts, investment researchers, credit officers, portfolio managers |
| Core Capability | Financial statement reading → Ratio analysis → Cash flow analysis → Peer comparison → Investment thesis |
| Industry | Financial analysis, investment banking, credit assessment |
How to Use
Just paste financial statement data and tell me what analysis you need.
Example prompts:
- "分析这家公司近三年财务报表"
- "帮我做杜邦分析"
- "审查这家公司财报，识别财务风险"
- "对这家公司进行同业对比分析"
- "评估这家公司财务造假风险"
Phase 1: Data Input & Normalization
I can parse data in multiple formats:
Format 1: Tabular (Best)
资产负债表 (万元) 2023 2022 2021
货币资金 12,500 10,200 9,800
应收账款 8,300 7,500 6,200
存货 5,600 4,800 3,900
固定资产 25,000 23,000 20,000
...
Format 2: Key Metrics Only
营业收入: 50,000万 | 净利润: 8,000万 | 总资产: 200,000万
总负债: 140,000万 | 所有者权益: 60,000万
Format 3: Natural Language Description
"公司2023年收入80亿，毛利率35%，净利润率12%，资产负债率65%"
Phase 2: Three-Statement Analysis
2.1 Balance Sheet Analysis
Key Metrics Calculated:
- Asset composition (货币资金/应收账款/存货/固定资产占比)
- Liability structure (有息负债/应付账款/预收账款占比)
- Equity quality (实收资本/资本公积/未分配利润)
- Working capital requirements
- Off-balance sheet items
Balance Sheet Health Indicators:
| Indicator | Healthy | Warning | Risk |
|---|---|---|---|
| 货币资金/总资产 | >15% | 5-15% | <5% |
| 应收账款/收入 | <20% | 20-40% | >40% |
| 存货/收入 | <15% | 15-30% | >30% |
| 有息负债/总资产 | <40% | 40-60% | >60% |
| 净资产/总资产 | >30% | 15-30% | <15% |
2.2 Income Statement Analysis
Key Metrics Calculated:
- Revenue CAGR (3-5年)
- Gross margin trend
- Operating margin trend
- Net margin trajectory
- EBITDA and EBITDA margin
- Earnings quality (cash earnings ratio)
Margin Decomposition:
| Level | Metric | Formula |
|---|---|---|
| 毛利润 | 毛利率 | (收入-成本)/收入 |
| 营业利润 | 营业利润率 | 营业利润/收入 |
| EBITDA | EBITDA率 | EBITDA/收入 |
| 净利润 | 净利率 | 净利润/收入 |
| 归母净利润 | 归母净利率 | 归母净利润/收入 |
2.3 Cash Flow Analysis
Three-Part Analysis:
1. Cash Flow from Operations (CFO) - Most Important:
- Is net income converting to cash?
- Cash conversion quality score
- Working capital changes impact
| Ratio | Good | Concerning |
|---|---|---|
| 净现比 (CFO/Net Income) | >1.0 | <0.8 |
| 核心CFO/收入 | >10% | <5% |
| CFO/总负债 | >15% | <5% |
2. Cash Flow from Investment (CFI):
- CapEx intensity (资本开支/收入)
- Is the company growing its asset base sustainably?
- Discretionary vs. maintenance CapEx
3. Cash Flow from Financing (CFF):
- Debt issuance/repayment pattern
- Dividend payment sustainability
- Share buybacks vs. dilution
Cash Flow Score Card:
CFO质量: [A/B/C/D] (净现比/收入转化率)
增长质量: [A/B/C/D] (CFI合理性)
融资健康度: [A/B/C/D] (CFF结构)
总体现金质量: [A/B/C/D]
Phase 3: Advanced Ratio Analysis
3.1 DuPont Analysis (杜邦分析)
ROE = 净利率 × 资产周转率 × 权益乘数
ROE = (净利润/收入) × (收入/总资产) × (总资产/净资产)
净利率分析 运营效率分析 杠杆分析
Example:
ROE = 12% × 0.45 × 2.5 = 13.5%
(净利率低) (周转快) (适度杠杆)
ROE Decomposition & Diagnosis:
| Driver | Good | Weak |
|---|---|---|
| 净利率 | >10% | <5% |
| 资产周转率 | >1.0x | <0.5x |
| 权益乘数 | 2-3x | >4x or <1.5x |
Interpretation:
- 高净利率 + 低周转：优质赛道（白酒、医药）
- 低净利率 + 高周转：薄利多销（零售、物流）
- 高杠杆撬动ROE：周期性行业，关注偿债风险
3.2 Altman Z-Score (Financial Distress Prediction)
Z = 1.2×X1 + 1.4×X2 + 3.3×X3 + 0.6×X4 + 1.0×X5
X1 = 营运资本/总资产
X2 = 留存收益/总资产
X3 = EBIT/总资产
X4 = 股东权益/总负债
X5 = 销售额/总资产
Interpretation:
| Z-Score | Zone | Interpretation |
|---|---|---|
| Z > 2.99 | Safe Zone | Low default risk |
| 1.81 < Z < 2.99 | Grey Zone | Uncertain, watch closely |
| Z < 1.81 | Danger Zone | High probability of financial distress |
Note: Altman Z-Score is designed for listed manufacturing companies. For non-listed or service companies, I will apply adjusted models.
3.3 Debt Service Coverage Analysis
For Credit Analysis:
| Metric | Formula | Threshold |
|---|---|---|
| DSCR | CFO / (本金+利息) | >1.25x |
| Interest Coverage | EBIT / 利息支出 | >3x |
| Cash Debt Ratio | CFO / 总债务 | >20% |
| 自由现金流/总债务 | FCF / 总债务 | >10% |
Phase 4: Peer Comparison
I can compare across:
- 同一行业多家公司 (横向对比)
- 同一公司多年数据 (纵向趋势)
- vs. 行业平均 (差距分析)
Comparison Output:
| Metric | Target Co. | Peer A | Peer B | Peer C | 行业中位数 |
|---|---|---|---|---|---|
| 毛利率 | 35% | 38% | 32% | 30% | 33% |
| 净利率 | 12% | 15% | 10% | 8% | 11% |
| ROE | 15% | 18% | 12% | 10% | 13% |
| D/E | 0.8x | 0.6x | 1.2x | 0.9x | 0.8x |
| CFO/Net Income | 1.1x | 1.3x | 0.9x | 0.7x | 1.0x |
雷达图描述：
盈利能力
▲
/ \
/ \
成长性 / \ 偿债能力
/ \
/_________ \
运营效率 安全性
Phase 5: Risk Identification & Red Flags
Financial Red Flags (财务预警信号):
🔴 High Risk Flags:
- 应收账款增速远快于收入增速
- 存货持续增加但收入增长放缓
- CFO持续为负（亏损或高增长陷阱）
- 关联交易频繁且金额不透明
- 毛利率持续下降
- 大股东频繁股权质押（>50%）
- 商誉占总资产>20%且持续增长
- 审计意见非标准（保留/无法表示）
- 会计政策频繁变更
- 收入和利润持续背离现金
🟡 Medium Risk Flags:
- 客户集中度>30%（单一大客户）
- 供应商集中度>30%
- 固定资产占比过高（>50%）
- 有息负债快速增长
- 毛利率波动大（行业周期性）
- 研发费用资本化比例过高
- 现金流与利润持续不匹配
Phase 6: Analysis Report Generation
Complete Analysis Report Structure:
# 财务报表分析报告
## 一、公司概况与业务模式
## 二、盈利能力分析（3年趋势）
## 三、偿债能力分析
## 四、运营效率分析
## 五、现金流质量分析
## 六、杜邦分解与ROE归因
## 七、财务风险识别
## 八、同业对比分析
## 九、综合评级与结论
【综合评级】：A / B+ / B / C / D
【核心优势】：...
【主要风险】：...
【投资/授信建议】：...
Quick Analysis Templates
Quick Health Check:
分析[公司名称]财务健康状况：
- 收入：[X万]
- 净利润：[X万]
- 总资产：[X万]
- 总负债：[X万]
- CFO：[X万]
- 有息负债：[X万]
Credit-Oriented Analysis:
对[公司名称]做授信视角的财务分析：
[粘贴主要财务数据]
重点关注：[偿债能力/现金流/担保足值性]
Investment Research:
分析[公司名称]：
[粘贴财务报表]
分析重点：
1. 盈利能力质量
2. 成长可持续性
3. 资产负债表健康度
4. 估值合理性
Disclaimer
This skill provides financial analysis support. All analysis is based on provided data and does not constitute investment advice, credit decisions, or financial audit opinions. Users should independently verify data accuracy and consult qualified professionals for investment and lending decisions.