三表模型
原名：3-statement-model
在 Excel 中构建集成的 IS/BS/CF 财务报表工作簿。
- 分类
- 开发提效
- 版本
- v1.0.0
- 作者
- 弈韬(@ra1nzzz)
- 下载
- 2
- 收藏
- 0
- 发布
- 2026-08-25
- 更新
- 2026-09-28
- TRACE 评分
- 4.4 / 5
内容概览
This skill assumes headless openpyxl — you are producing an .xlsx file on disk. Follow the excel-author skill's conventions for cell coloring, formulas, named ranges, and sensitivity tables. Recalculate before delivery: python /path/to/excel-author/scripts/recalc.py ./out/model.xlsx. Complete and populate integrated financial model templates with proper linkages between Income Statement, Balance Sheet, and Cash Flow Statement. Formulas over hardcodes (non-negotiable): - Every projection cell, roll-forward, linkage, and subtotal MUST be an Excel formula — never a pre-computed value - When using Python/openpyxl: write formula strings (ws["D15"] = "=D14 (1+Assumptions!$B$5)"), NOT computed results (ws["D15"] = 12500) - The ONLY cells that should contain hardcoded numbers are: (1) historical actuals, (2) assumption drivers in the Assumptions tab - If you find yourself computing a value in Py…