Skip to main content
ClaudeWave
Skill424 repo starsupdated 3d ago

china-3-statement-model

The china-3-statement-model skill builds integrated three-statement financial models for Chinese A-share companies, adapting standard methodology to Chinese Accounting Standards, CAS-specific treatments like goodwill amortization and VAT handling, and market conventions including CNY currency and thousands-unit reporting. Use this instead of the standard 3-statement-model when constructing income statement, balance sheet, and cash flow projections for Chinese listed equities, pulling historical data from AkShare or Wind terminals and normalizing for CAS differences.

Install in Claude Code
Copy
git clone --depth 1 https://github.com/jwangkun/claude-for-financial-services-cn /tmp/china-3-statement-model && cp -r /tmp/china-3-statement-model/agent-plugins/china-model-builder/skills/china-3-statement-model ~/.claude/skills/china-3-statement-model
Then start a new Claude Code session; the skill loads automatically.

SKILL.md

# china-3-statement-model

## Purpose

Build institutional-quality three-statement models (Income Statement / Balance Sheet / Cash Flow) for A-share equities, adapted for Chinese Accounting Standards (CAS) and the Chinese market context.

## Key Differences from US 3-Statement Models

| Parameter | US Model | China Model |
|-----------|----------|-------------|
| Accounting standard | US GAAP / IFRS | CAS (企业会计准则) |
| Tax rate | 21% federal | 25% standard (高新技术企业 15%) |
| Currency | USD | CNY (人民币) |
| Fiscal year | Varied | Mostly Dec 31 year-end |
| Revenue recognition | ASC 606 | CAS 14 (similar principles) |
| Goodwill | Indefinite life (no amortization) | CAS 8 — goodwill amortized or tested |
| R&D capitalization | Typically expensed | Can be capitalized under CAS |
| VAT treatment | Sales tax separate | 增值税 often embedded in revenue/sales |
| Unit reporting | USD | Often 千元 (thousands CNY) — verify |

## Data Sources

### Tier 0 — 万得 Wind(最全面付费数据)
- 覆盖:A股/港美股/基金/指数/债券/宏观/研报/分析(44个工具)
- MCP 服务:`wind-mcp`(需 `WIND_API_KEY` 密钥,以 `ak_` 开头)
- 优势:全市场覆盖面最广、数据最全面、包含研报和量化分析
- 密钥申请:https://aifinmarket.wind.com.cn/#/home

### Tier 1 — 同花顺 iFind(付费精确数据)/ AkShare MCP(Tier-2 免费备选)

```python
get_financials(ticker, "income", "annual")   → 利润表
get_financials(ticker, "balance", "annual")  → 资产负债表
get_financials(ticker, "cashflow", "annual") → 现金流量表
get_quote(ticker)                            → 实时行情
get_historical_data(ticker)                  → 历史价格
get_stock_info(ticker)                       → 公司基本信息
```

### Secondary Sources (when AkShare insufficient)
- 巨潮资讯 (cninfo.com.cn) — mandatory disclosure filings
- 上交所 / 深交所 — listed company announcements
- 上证e互动 / 深交所互动易 — IR Q&A
- 公司官网投资者关系页面

## Workflow

### Step 1: Data Retrieval

Pull 3-5 years of historical financials from AkShare.

**Verify units carefully:**
- Some statements report in 元 (CNY)
- Others in 千元 (thousands CNY)
- Normalize to consistent unit before modeling

```python
# Pull all three statements
get_financials(ticker, "income", "annual")
get_financials(ticker, "balance", "annual")
get_financials(ticker, "cashflow", "annual")
```

### Step 2: Historical Analysis

Document key trends:

- **Revenue growth**: YoY %, CAGR over 3-5 years
- **Gross margin**: 毛利率 — track expansion/contraction
- **Operating margin**: 营业利润率
- **Net margin**: 净利率
- **Tax rate**: 所得税率 — flag if below 25% (likely 高新技术企业)
- **Effective tax rate**: vs statutory rate
- **D&A**: 折旧与摊销 as % of PPE
- **CapEx**: 资本支出 from cash flow statement
- **Working capital**: 应收账款、存货、应付账款 trends
- **Debt structure**: 有息负债 composition

### Step 3: Build the Model

Follow standard 3-statement modeling methodology, adapted for CAS:

#### Income Statement (利润表)

Key line items (Chinese naming):
- 营业收入 (Revenue)
- 营业成本 (COGS)
- 税金及附加 (Taxes and surcharges — includes 消费税、城建税等)
- 销售费用 (Selling expenses)
- 管理费用 (G&A)
- 研发费用 (R&D expenses — must be separated per CAS)
- 财务费用 (Financial costs — net of interest income)
- 营业利润 (Operating profit)
- 营业外收入/支出 (Non-operating income/expenses)
- 利润总额 (Profit before tax)
- 所得税费用 (Income tax expense)
- 净利润 (Net income)
- 归属于母公司股东的净利润 (Net income attributable to parent)

#### Balance Sheet (资产负债表)

Key line items:
- 货币资金 (Cash & equivalents)
- 交易性金融资产 (Trading financial assets)
- 应收账款 (Accounts receivable)
- 预付款项 (Prepayments)
- 存货 (Inventory)
- 其他流动资产 (Other current assets)
- 流动资产合计 (Total current assets)
- 固定资产 (Fixed assets / PPE)
- 在建工程 (Construction in progress)
- 无形资产 (Intangible assets)
- 商誉 (Goodwill — flag if >30% of equity)
- 非流动资产合计 (Total non-current assets)
- 资产总计 (Total assets)
- 短期借款 (Short-term borrowings)
- 应付账款 (Accounts payable)
- 预收款项/合同负债 (Advance receipts / contract liabilities)
- 一年内到期非流动负债 (Current portion of LT debt)
- 流动负债合计 (Total current liabilities)
- 长期借款 (Long-term borrowings)
- 应付债券 (Bonds payable)
- 非流动负债合计 (Total non-current liabilities)
- 负债合计 (Total liabilities)
- 股本 (Share capital)
- 资本公积 (Capital reserve)
- 盈余公积 (Surplus reserve)
- 未分配利润 (Retained earnings)
- 归属于母公司股东权益合计 (Parent equity)
- 少数股东权益 (Minority interest)
- 所有者权益合计 (Total equity)
- 负债和股东权益总计 (Total liabilities + equity)

#### Cash Flow Statement (现金流量表)

Chinese indirect method:
- 经营活动现金流量 (Operating CF):
  - Start from 净利润
  - Adjust: D&A, 财务费用, 投资收益, 营运资本 changes
  - 经营活动产生的现金流量净额
- 投资活动现金流量 (Investing CF):
  - 购建固定资产/无形资产 (CapEx)
  - 处置收回 (Asset sales)
  - 投资支付/收回 (Investment purchases/sales)
- 筹资活动现金流量 (Financing CF):
  - 吸收投资 (Equity issuance)
  - 取得借款 (Borrowings)
  - 偿还债务 (Debt repayment)
  - 分配股利 (Dividends)
- 现金净增加额 (Net change in cash)
- 期末现金余额 (Ending cash balance)

### Step 4: Balance Checks

**CRITICAL — Chinese-specific checks:**

1. **Cash reconciliation**: 货币资金 (BS) = 期末现金余额 (CF) ± restricted cash
2. **BS balancing**: 资产总计 = 负债和股东权益总计
3. **RE roll-forward**: 期初未分配利润 + 本期净利润 - 提取盈余公积 - 现金分红 = 期末未分配利润
4. **CF-IS linkage**: 净利润 (IS) → starting point for 经营CF
5. **CapEx check**: 购建固定资产 (CF) ≈ 固定资产增加 (BS) + 累计折旧增加 (BS)
6. **Debt check**: 借款变动 (CF) = 短期借款变动 + 长期借款变动 (BS)
7. **Tax check**: 所得税费用 (IS) vs 实际缴纳 (CF indirect method add-back)

### Step 5: Scenario & Sensitivity

- Base / Bear / Bull scenarios
- Sensitivity on revenue growth, gross margin, tax rate
- Key drivers: 毛利率, 期间费用率, 营运资本效率

## China-Specific Modeling Conventions

### 增值税 (VAT)
- Listed companies report 营业收入 net of VAT
- 税金及附加 includes 消费税 but not VAT
- VAT is off-balance-sheet in most models

### 商誉 (Goodwill)
- Common from M&A, especially 2015-2016 boom
- Flag if 商誉 > 30% of 归母权益
- Note annual impairment testing requirements

### 研发费用 (R&D)
- CAS requires R&D to be expensed (not capitalized like IFRS allows)
- Some companies disclose R&D capitalization in notes — check if >5% of revenue

### 折旧 (Depreciation)
- Chinese companies often use straight-line over longer lives
- Typical ranges:
  - Buildings: 20-40 years
  - Equipment: 5-10 years
  - Vehicles: 4-6 years

### 存货 (Inventory)
- LIFO not permitted under CAS (FIFO or weighted average only)
- 存货计价 affects margin comp
china-accrual-scheduleSkill

Build accrual schedules for A-share fund administration. Tracks revenue recognition, expense accruals, and working capital timing for fund accounting. Adapted from the original accrual-schedule skill for fund accounting standards. Triggers on "基金应计项目", "应计计提基金", "accrual schedule fund", "NAV accruals", or "accruals [fund]".

china-audit-xlsSkill

Audit financial models and Excel workbooks for A-share analysis. Adapts the original audit-xls skill for Chinese financial modeling standards, CAS conventions, and A-share-specific checks. Triggers on "A股模型审计", "财务模型核查", "audit model China", "audit xlsx", "模型QC", or "check model [company]".

china-break-traceSkill

Forensic financial analysis for A-share fund holdings and portfolio companies. Adapts the original break-trace skill for fund administration context and Chinese market standards. Triggers on "基金持仓核查", "持仓异常", "forensic fund analysis China", "持仓质量分析", or "investigate [fund] holdings".

china-catalyst-calendarSkill

Track upcoming catalysts for A-share coverage universe — earnings dates, regulatory announcements, sector conferences, product launches, and policy events relevant to Chinese equities. Adapted from the original catalyst-calendar skill for A-share market conventions. Triggers on "A股催化剂日历", "事件日历", "财报日历", "earnings calendar A-share", "upcoming catalysts China", or "what's coming up for [company]".

china-clean-data-xlsSkill

Clean and normalize A-share financial data for modeling. Adapts the original clean-data-xls skill for Chinese financial statements, CAS conventions, and A-share data formats. Triggers on "A股数据清洗", "财务数据清洗", "clean financial data China", "数据清洗", or "normalize financial statements".

china-comps-analysisSkill

Comparable company analysis for A-share equities. Adapts the original comps-analysis skill for Chinese market data sources, A-share trading multiples, and domestic peer selection. Triggers on "A股可比公司", "可比分析", "comps China", "peer comparison A-share", "可比公司分析", or "trading comps [industry]".

china-compsSkill

Comparable company analysis for A-share stocks. Uses AkShare MCP to build peer groups, pull financial data, compute valuation multiples (PE, PB, PS), and assess relative value within a Chinese industry sector.

china-dcf-modelSkill

Discounted cash flow (DCF) valuation model for A-share equities. This alias skill redirects to china-dcf, which provides comprehensive DCF modeling adapted for Chinese market conventions. Triggers on "A股DCF模型", "DCF估值", "DCF model China", "现金流折现", "discounted cash flow A-share", or "DCF [company]".