# three-statement-model-builder

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.

- skill · `type=skill` · Codex, ChatGPT · ★ 7604
- Author: OpenAI · official OpenAI repository
- License: LicenseRef-Proprietary · policy=link-only · description only; the file stays with the author
- Source: https://github.com/openai/plugins/tree/HEAD/plugins/public-equity-investing/skills/three-statement-model-builder/SKILL.md
- Updated: 2026-10-08
- HTML: https://affpapa.org/en/nevibecode/skills/three-statement-model-builder

## What it 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.

## Install

### Codex (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add openai/plugins --skill three-statement-model-builder -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/three-statement-model-builder/SKILL.md` — For all projects use ~/.agents/skills/

### Claude Code

1. **Skills CLI (Vercel)**
```bash
npx skills add openai/plugins --skill three-statement-model-builder -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/three-statement-model-builder/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/three-statement-model-builder/

### Cursor

**Manually: put the files in place**
- File: `.cursor/skills/three-statement-model-builder/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install openai/plugins three-statement-model-builder
```

2. **Manually: put the files in place**
- File: `.github/skills/three-statement-model-builder/SKILL.md`

### Gemini CLI

**Platform CLI**
```bash
gemini skills install https://github.com/openai/plugins --path plugins/public-equity-investing/skills/three-statement-model-builder
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/three-statement-model-builder/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/openai/plugins/tree/HEAD/plugins/public-equity-investing/skills/three-statement-model-builder/SKILL.md

## When to use it
- 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
- Build a formula-based three-statement model from this public-company financial package.
- Refresh the forecast in `plan.json` and save the workbook under `output`.
- Review the run log and report whether the model is decision-ready.

## Similar
- [churn-prevention](https://affpapa.org/en/nevibecode/skills/coreyhaines31-churn-prevention.md) — skill · 121600 installs
- [revops](https://affpapa.org/en/nevibecode/skills/revops.md) — skill · 114000 installs
- [ads](https://affpapa.org/en/nevibecode/skills/ads.md) — skill · 83400 installs
- [pricing](https://affpapa.org/en/nevibecode/skills/pricing.md) — skill · 79900 installs
- [marketing-plan](https://affpapa.org/en/nevibecode/skills/marketing-plan.md) — skill · 68400 installs
- [humanizer](https://affpapa.org/en/nevibecode/skills/blader-humanizer.md) — skill · 10600 installs

From the same set: [openai/plugins](https://affpapa.org/en/nevibecode/by/openai/plugins.md) — 528 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md