Bank Financial Report Analyst#

银行财报分析助手#

Skill Overview#

AttributeValueSkill TypePure Conversation / Financial AnalysisTarget UsersBank analysts, investment researchers, credit officers, portfolio managersCore CapabilityFinancial statement reading → Ratio analysis → Cash flow analysis → Peer comparison → Investment thesisIndustryFinancial 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)

text

资产负债表 (万元)     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

text

营业收入: 50,000万 | 净利润: 8,000万 | 总资产: 200,000万
总负债: 140,000万 | 所有者权益: 60,000万

Format 3: Natural Language Description

text

"公司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:

IndicatorHealthyWarningRisk货币资金/总资产>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:

LevelMetricFormula毛利润毛利率(收入-成本)/收入营业利润营业利润率营业利润/收入EBITDAEBITDA率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

RatioGoodConcerning净现比 (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:

text

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 (杜邦分析)#

text

ROE = 净利率 × 资产周转率 × 权益乘数

ROE = (净利润/收入) × (收入/总资产) × (总资产/净资产)

     净利率分析       运营效率分析      杠杆分析

Example:
ROE = 12% × 0.45 × 2.5 = 13.5%
     (净利率低)   (周转快)      (适度杠杆)

ROE Decomposition & Diagnosis:

DriverGoodWeak净利率>10%<5%资产周转率>1.0x<0.5x权益乘数2-3x>4x or <1.5x

Interpretation:

• 高净利率 + 低周转：优质赛道（白酒、医药）
• 低净利率 + 高周转：薄利多销（零售、物流）
• 高杠杆撬动ROE：周期性行业，关注偿债风险

---

3.2 Altman Z-Score (Financial Distress Prediction)#

text

Z = 1.2×X1 + 1.4×X2 + 3.3×X3 + 0.6×X4 + 1.0×X5

X1 = 营运资本/总资产
X2 = 留存收益/总资产
X3 = EBIT/总资产
X4 = 股东权益/总负债
X5 = 销售额/总资产

Interpretation:

Z-ScoreZoneInterpretationZ > 2.99Safe ZoneLow default risk1.81 < Z < 2.99Grey ZoneUncertain, watch closelyZ < 1.81Danger ZoneHigh 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:

MetricFormulaThresholdDSCRCFO / (本金+利息)>1.25xInterest CoverageEBIT / 利息支出>3xCash Debt RatioCFO / 总债务>20%自由现金流/总债务FCF / 总债务>10%

---

Phase 4: Peer Comparison#

I can compare across:#

• 同一行业多家公司 (横向对比)
• 同一公司多年数据 (纵向趋势)
• vs. 行业平均 (差距分析)

Comparison Output:#

MetricTarget Co.Peer APeer BPeer C行业中位数毛利率35%38%32%30%33%净利率12%15%10%8%11%ROE15%18%12%10%13%D/E0.8x0.6x1.2x0.9x0.8xCFO/Net Income1.1x1.3x0.9x0.7x1.0x

雷达图描述：

text

          盈利能力
             ▲
            / \
           /   \
    成长性 /     \ 偿债能力
         /       \
        /_________ \
      运营效率    安全性

---

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:#

text

# 财务报表分析报告

## 一、公司概况与业务模式
## 二、盈利能力分析（3年趋势）
## 三、偿债能力分析
## 四、运营效率分析
## 五、现金流质量分析
## 六、杜邦分解与ROE归因
## 七、财务风险识别
## 八、同业对比分析
## 九、综合评级与结论

【综合评级】：A / B+ / B / C / D
【核心优势】：...
【主要风险】：...
【投资/授信建议】：...

---

Quick Analysis Templates#

Quick Health Check:

text

分析[公司名称]财务健康状况：
- 收入：[X万]
- 净利润：[X万]
- 总资产：[X万]
- 总负债：[X万]
- CFO：[X万]
- 有息负债：[X万]

Credit-Oriented Analysis:

text

对[公司名称]做授信视角的财务分析：
[粘贴主要财务数据]
重点关注：[偿债能力/现金流/担保足值性]

Investment Research:

text

分析[公司名称]：
[粘贴财务报表]
分析重点：
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.