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.
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-modelSKILL.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
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]".
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]".
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".
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]".
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".
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]".
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.
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]".