china-xlsx-author
china-xlsx-author generates professional Chinese financial analysis workbooks for A-share companies using iFind or AkShare data sources. The skill structures multi-sheet Excel models following Chinese Accounting Standards with standardized layouts for income statements, balance sheets, cash flows, and valuation analyses, applying color-coded formatting conventions where blue indicates inputs, black shows calculations, and red flags warnings or hardcoded values. Use this when building A-share financial models requiring institutional-grade formatting and structure for equity analysis or investment presentations.
git clone --depth 1 https://github.com/jwangkun/claude-for-financial-services-cn /tmp/china-xlsx-author && cp -r /tmp/china-xlsx-author/agent-plugins/china-market-researcher/skills/china-xlsx-author ~/.claude/skills/china-xlsx-authorSKILL.md
# 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 免费备选) ```python 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 - Rev_prev) / Rev_prev | 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**: Se
Three-statement financial model for A-share stocks. Adapts the standard 3-statement-model methodology for Chinese accounting standards (CAS), Chinese GAAP differences, and AkShare-sourced financials. Use instead of the original 3-statement-model skill when building integrated IS/BS/CF models for Chinese listed companies.
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.