three-statement-model-builder — Codex skill for financial models
Builds an integrated Excel operating model for a public company, linking its income statement, balance sheet, and cash flow statement. Use it for a new forecast or a model refresh.
npx skills add openai/plugins --skill three-statement-model-builder -a codexWhat three-statement-model-builder does
The main deliverable is a formula-driven workbook covering the three statements, operating drivers, scenarios, and model checks. Its Cover tab presents the key outputs, warnings, and workbook map. Formula mode is the normal route for a full build; deterministic exports are reserved for controlled calculations, smoke tests, or lightweight support work.
Start with a valid plan.json, validate it with python3 scripts/validate_plan.py, then run python3 scripts/build_banker_formula_workbook.py. The supporting python3 scripts/run_pipeline.py path is for limited calculation and export cases. Outputs include the workbook, run log, and manifest; formula mode also writes model_citations.json. Active placeholders or unsupported assumptions cap the model at screen-grade, while hard failures make it not-decision-ready. A financial package is needed for a company-specific build; without context, the template plan is illustrative.
What it helps with
- build an integrated income statement, balance sheet, and cash flow forecast
- refresh a public-company operating model in Excel
- connect working capital, debt, and cash in one forecast
- surface model checks and unresolved assumptions in the workbook
Example prompts for the agent
- Build a formula-based three-statement model from this public-company financial package.
- Refresh the forecast in
plan.jsonand save the workbook underoutput. - Review the run log and report whether the model is decision-ready.
How to install three-statement-model-builder
1Skills CLI (Vercel)
npx skills add openai/plugins --skill three-statement-model-builder -a codex2Manually: put the files in place
.agents/skills/three-statement-model-builder/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add openai/plugins --skill three-statement-model-builder -a claude-code2Manually: put the files in place
~/.claude/skills/three-statement-model-builder/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/three-statement-model-builder/
Manually: put the files in place
.cursor/skills/three-statement-model-builder/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install openai/plugins three-statement-model-builder2Manually: put the files in place
.github/skills/three-statement-model-builder/SKILL.mdPlatform CLI
gemini skills install https://github.com/openai/plugins --path plugins/public-equity-investing/skills/three-statement-model-builderManually: put the files in place
.devin/skills/three-statement-model-builder/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: Codex skills: how to install, where they live, how to call them
Questions about three-statement-model-builder
How do I install three-statement-model-builder in Codex?
Run npx skills add openai/plugins --skill three-statement-model-builder -a codex. The skill file is at .agents/skills/three-statement-model-builder/SKILL.md.
What does three-statement-model-builder do?
It builds a formula-based public-company operating model that connects the three financial statements, forecasts, and checks. The primary deliverable is an Excel workbook with a summary Cover tab.
What input does the model builder use?
Its preferred input is a schema-valid plan.json, checked with python3 scripts/validate_plan.py path/to/plan.json. With no company context, it can use assets/plan_template.json as an illustrative plan, with status capped at screen-grade.
