Create professional Excel workbooks for A-share financial analysis. Adapts the original xlsx-author skill for Chinese financial modeling standards, CAS conventions, and A-share formatting. Triggers on "A股Excel模型", "财务模型制作", "create model China", "build model xlsx", "制作模型", or "Excel model [company]".
インストール方法を見るインストールする前に、エージェントに与えられる指示の中身を確認できます。
Create professional A股财务分析Excel模型 — structured workbooks for Chinese equity analysis.
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
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 |
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)
Standard P&L format (CAS):
| Item | FY2021 | FY2022 | FY2023 | FY2024E | FY2025E |
|---|---|---|---|---|---|
| 营业收入 | |||||
| 减: 营业成本 | |||||
| = 毛利 | |||||
| 毛利率 | |||||
| 减: 税金及附加 | |||||
| 减: 销售费用 | |||||
| 减: 管理费用 | |||||
| 减: 研发费用 | |||||
| 减: 财务费用 | |||||
| 加: 投资收益 | |||||
| 加: 公允价值变动 | |||||
| 减: 信用减值损失 | |||||
| 减: 资产减值损失 | |||||
| 加: 资产处置收益 | |||||
| = 营业利润 | |||||
| 加: 营业外收入 | |||||
| 减: 营业外支出 | |||||
| = 利润总额 | |||||
| 减: 所得税费用 | |||||
| = 净利润 | |||||
| 其中: 归母净利润 | |||||
| 其中: 扣非净利润 | |||||
| EPS (元/股) |
Standard BS format (CAS):
| Item | FY2021 | FY2022 | FY2023 | FY2024E | FY2025E |
|---|---|---|---|---|---|
| 资产 | |||||
| 货币资金 | |||||
| 交易性金融资产 | |||||
| 应收票据 | |||||
| 应收账款 | |||||
| 预付款项 | |||||
| 存货 | |||||
| 其他流动资产 | |||||
| 流动资产合计 | |||||
| 长期股权投资 | |||||
| 固定资产 | |||||
| 在建工程 | |||||
| 无形资产 | |||||
| 商誉 | |||||
| 其他非流动资产 | |||||
| 非流动资产合计 | |||||
| 资产总计 | |||||
| 负债 | |||||
| 短期借款 | |||||
| 应付票据 | |||||
| 应付账款 | |||||
| 合同负债 | |||||
| 应付职工薪酬 | |||||
| 应交税费 | |||||
| 其他应付款 | |||||
| 流动负债合计 | |||||
| 长期借款 | |||||
| 应付债券 | |||||
| 预计负债 | |||||
| 非流动负债合计 | |||||
| 负债合计 | |||||
| 所有者权益 | |||||
| 股本 | |||||
| 资本公积 | |||||
| 盈余公积 | |||||
| 未分配利润 | |||||
| 归母股东权益 | |||||
| 少数股东权益 | |||||
| 所有者权益合计 | |||||
| 负债及权益总计 |
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% |
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 |
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 |
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 |
| Unit | Usage |
|---|---|
| 元 | Per-share items |
| 万元 | Most financial items |
| 亿元 | Large totals, market cap |
| Item | Convention |
|---|---|
| Sheet names | Short, Chinese preferred |
| Cell references | Named ranges for key cells |
| File naming | [Ticker][Company][Date]_v[X] |
| Convention | Example |
|---|---|
| Sheet references | '利润表'!B10 |
| Named ranges | Revenue, WACC, Shares |
| Chinese function names | SUM, IF, VLOOKUP |
Before finalizing:
Data Source Mode Switch: Set env var
IFIND_DATA_SOURCE_MODEto control data source preference.
ifind-only(strict): Use iFind only, error if unavailableifind-fallback(default): iFind preferred, fallback to AkShareakshare-only, wind-only (Wind only), wind-fallback (Wind first, fallback to iFind → AkShare): Skip iFind, use AkShare only
まだレビューはありません。使ってみた感想をお寄せください。
概要と使いどころ
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]".
日本語の概要は準備中です。原文の説明を表示しています。
Build accrual schedules for A-share companies tracking revenue recognition, expense accruals, and working capital timing. Adapted from the original accrual-schedule skill for CAS accounting and Chinese business practices. Triggers on "A股应计项目", "应计计提", "accrual schedule China", "应计账款分析", or "working capital accruals [company]".
日本語の概要は準備中です。原文の説明を表示しています。
Assess an A-share portfolio company's AI readiness for China-focused private equity investments. Evaluates data infrastructure, technology stack, talent, and AI adoption opportunities in the Chinese market context. Triggers on "A股公司AI评估", "AI readiness China", "AI assessment portfolio company", "AI转型评估", or "artificial intelligence readiness [company]".
日本語の概要は準備中です。原文の説明を表示しています。
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".
日本語の概要は準備中です。原文の説明を表示しています。