China Xlsx Author

china-xlsx-author

Purpose

Create professional A股财务分析Excel模型 — structured workbooks for Chinese equity analysis.

Data Sources

Primary: iFind MCP (Tier-1 付费) / AkShare MCP (Tier-2 免费备选)

get_financials(ticker, "income")     → Income statement data
get_financials(ticker, "balance")    → Balance sheet data
get_financials(ticker, "cashflow")   → Cash flow data
get_quote(ticker)                    → Market data

Secondary Sources

• 巨潮 — source filings
• 券商研报 — template references

Workflow

Step 1: Workbook Structure

Standard A-share model structure:

| Sheet | Content | |-------|---------| | 封面 (Cover) | Company, date, version, disclaimer | | 假设 (Assumptions) | All model inputs, drivers | | 利润表 (Income) | Historical + forecast P&L | | 资产负债表 (Balance Sheet) | Historical + forecast BS | | 现金流量表 (Cash Flow) | Historical + forecast CF | | 营运资本 (Working Capital) | WC analysis, assumptions | | 估值 (Valuation) | DCF, comps, sensitivity | | 图表 (Charts) | Key visuals | | 检查 (Checks) | Sum checks, balances |

Step 2: Formatting Standards

Chinese financial model formatting:

| Element | Format | |---------|--------| | Headers | Bold, background color | | Inputs | Blue font, light blue background | | Calculations | Black font, no background | | Hardcodes (to avoid) | Red font | | Negative numbers | Red font or (XXX) | | Percentage | % format, 1 decimal | | Currency | ¥ or 万元 | | Dates | YYYY-MM-DD or YYYY年MM月 |

Color coding:

蓝色 = 输入 (Inputs)
黑色 = 公式 (Calculations)
红色 = 警告 (Warnings / hardcodes)
绿色 = 链接 (Links)
灰色 = 标签 (Labels)

Step 3: Income Statement Layout

Standard P&L format (CAS):

| Item | FY2021 | FY2022 | FY2023 | FY2024E | FY2025E | |------|--------|--------|--------|---------|---------| | 营业收入 | | | | | | | 减: 营业成本 | | | | | | | = 毛利 | | | | | | | 毛利率 | | | | | | | 减: 税金及附加 | | | | | | | 减: 销售费用 | | | | | | | 减: 管理费用 | | | | | | | 减: 研发费用 | | | | | | | 减: 财务费用 | | | | | | | 加: 投资收益 | | | | | | | 加: 公允价值变动 | | | | | | | 减: 信用减值损失 | | | | | | | 减: 资产减值损失 | | | | | | | 加: 资产处置收益 | | | | | | | = 营业利润 | | | | | | | 加: 营业外收入 | | | | | | | 减: 营业外支出 | | | | | | | = 利润总额 | | | | | | | 减: 所得税费用 | | | | | | | = 净利润 | | | | | | | 其中: 归母净利润 | | | | | | | 其中: 扣非净利润 | | | | | | | EPS (元/股) | | | | | |

Step 4: Balance Sheet Layout

Standard BS format (CAS):

| Item | FY2021 | FY2022 | FY2023 | FY2024E | FY2025E | |------|--------|--------|--------|---------|---------| | 资产 | | | | | | | 货币资金 | | | | | | | 交易性金融资产 | | | | | | | 应收票据 | | | | | | | 应收账款 | | | | | | | 预付款项 | | | | | | | 存货 | | | | | | | 其他流动资产 | | | | | | | 流动资产合计 | | | | | | | 长期股权投资 | | | | | | | 固定资产 | | | | | | | 在建工程 | | | | | | | 无形资产 | | | | | | | 商誉 | | | | | | | 其他非流动资产 | | | | | | | 非流动资产合计 | | | | | | | 资产总计 | | | | | | | | | | | | | | 负债 | | | | | | | 短期借款 | | | | | | | 应付票据 | | | | | | | 应付账款 | | | | | | | 合同负债 | | | | | | | 应付职工薪酬 | | | | | | | 应交税费 | | | | | | | 其他应付款 | | | | | | | 流动负债合计 | | | | | | | 长期借款 | | | | | | | 应付债券 | | | | | | | 预计负债 | | | | | | | 非流动负债合计 | | | | | | | 负债合计 | | | | | | | | | | | | | | 所有者权益 | | | | | | | 股本 | | | | | | | 资本公积 | | | | | | | 盈余公积 | | | | | | | 未分配利润 | | | | | | | 归母股东权益 | | | | | | | 少数股东权益 | | | | | | | 所有者权益合计 | | | | | | | 负债及权益总计 | | | | | |

Step 5: Assumptions Sheet

Key assumptions to centralize:

| Category | Assumption | Value | Source | |----------|-----------|-------|--------| | Revenue growth | FY2024E | X% | | | Revenue growth | FY2025E | X% | | | Gross margin | FY2024E | X% | | | SG&A % of revenue | FY2024E | X% | | | Tax rate | Effective | X% | | | D&A | % of PPE | X% | | | CapEx | % of revenue | X% | | | NWC | % of revenue | X% | | | Terminal growth | | X% | | | WACC | | X% | |

Step 6: Valuation Sheet

DCF layout:

| Item | Value | Notes | |------|-------|-------| | Enterprise value | ¥XX亿 | | | Less: Net debt | ¥XX亿 | | | Equity value | ¥XX亿 | | | Shares outstanding | XX亿股 | | | Value per share | ¥XX | | | Current price | ¥XX | | | Upside/(Downside) | X% | |

Football field:

| Method | Low | Mid | High | |--------|-----|-----|------| | P/E | | | | | P/B | | | | | EV/EBITDA | | | | | DCF | | | | | Range | ¥XX | ¥XX | ¥XX |

Step 7: Checks Sheet

Essential checks:

| Check | Formula | Target | Result | |-------|---------|--------|--------| | BS balances | Assets - L - E | 0 | | | CF ties | Ending cash - Beg cash - Net CF | 0 | | | Revenue growth | (Rev - Revprev) / Revprev | Reasonable | | | Margin check | GP / Revenue | Reasonable | | | Debt schedule | ST + LT debt | = Total | | | Retained earnings | RE beg + NI - Div | = RE end | | | Depreciation | D&A / PPE | Reasonable | |

Step 8: Charts & Presentation

Key charts to include:

| Chart | Purpose | |-------|---------| | Revenue & profit bridge | Historical + forecast | | Margin trends | Gross, operating, net | | Valuation multiples | Historical range | | DCF sensitivity | Tornado chart | | Peer comparison | Comps scatter plot |

China-Specific Excel Conventions

Unit Standards

| Unit | Usage | |------|-------| | 元 | Per-share items | | 万元 | Most financial items | | 亿元 | Large totals, market cap |

Naming Conventions

| Item | Convention | |------|-----------| | Sheet names | Short, Chinese preferred | | Cell references | Named ranges for key cells | | File naming | [Ticker][Company][Date]_v[X] |

Formula Conventions

| Convention | Example | |------------|---------| | Sheet references | '利润表'!B10 | | Named ranges | Revenue, WACC, Shares | | Chinese function names | SUM, IF, VLOOKUP |

Quality Checks

Before finalizing:

• [ ] All sheets present and linked
• [ ] No hardcodes in calculation cells
• [ ] Historicals cross-checked
• [ ] CAS conventions applied
• [ ] BS balances and CF ties
• [ ] Valuation reasonable
• [ ] Charts update automatically
• [ ] All checks green
• [ ] Documentation complete

> Data Source Mode Switch: Set env var IFIND_DATA_SOURCE_MODE to control data source preference. > - ifind-only (strict): Use iFind only, error if unavailable > - ifind-fallback (default): iFind preferred, fallback to AkShare > - akshare-only, wind-only (Wind only), wind-fallback (Wind first, fallback to iFind → AkShare): Skip iFind, use AkShare only

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: jwangkun
• Source: jwangkun/claude-for-financial-services-cn
• License: Apache-2.0

Install and usage instructions live in the source repository linked above.