A股三表预测模型
SkillCommerce & financeThis skill gives your AI the ability to build integrated financial models in Excel covering the income statement, balance sheet, and cash flow. Once added, your AI can produce a complete three-statement workbook where the figures across all three statements are tied together.
Available today. Use it from your connected AI after setup.
No other account needed.
Add the skill, then ask your AI to build a three-statement financial model in Excel.
Then ask your AI: use the A股三表预测模型 skill
What your AI can do with it
- Build income statement, balance sheet, and cash flow statements in Excel
- Link the three statements together so the figures stay consistent
- Produce a complete integrated three-statement workbook
- Deliver the finished model as an Excel file
What this skill tells your AI
The instructions your AI receives, as published by cyijun/china-financial-services in plugins/financial-analysis/skills/3-statement-model/SKILL.md and read by ahel’s review.
工作流
- 调用
a-share-research-evidence和a-share-financial-forensics冻结财务版本、合并范围、累计/单季口径及会计政策。 - 至少导入三年年度和八个季度原始三表,保留
ann_date、f_ann_date、end_date、report_type和更新标志。 - 先建收入量价、毛利、费用、税率、折旧摊销、资本开支和营运资本驱动,再联动三表。
- 利润表流入留存收益;非现金项目、营运资本和投资融资活动流入现金流;期末现金回到资产负债表。
- 债务计划按工具列期初、借入、偿还、利率、利息和期末;循环引用必须显式、可关闭并有收敛检查。
- 政府补助、非经常损益、减值、股权激励、租赁、少数股东和关联交易按重要性单列。
- 建立基础、压力、乐观驱动,不以历史增速直接外推,不赋主观精确概率。
检查与交付
- 工作簿至少包含
Sources、Inputs、三张报表、Schedules、Checks。 - 检查资产=负债+权益、现金流净变动=现金变动、留存收益、固定资产、债务和利息勾稽。
- 计算单元格使用公式,硬编码输入有来源或
[ASSUMPTION]。 - 调用
xlsx-author生成文件,再调用audit-xls;未运行公式引擎时标记formula_execution_unverified。
输出模型、驱动表、勾稽结果、情景和未验证项,不给评级或交易动作。
Signals
- GitHub stars
- 20
- Forks
- 3
- Last commit
- Aug 2026
Advanced
- Catalog kind
- skill
- Gateway key
x-3-statement-model- Source
- github.com/cyijun/china-financial-services