# Model

> Build valuation and scenario models to stress-test financial assumptions

- Skill: `bromso/model` (Agent Skill)
- Install (CLI): `npx skillmds@latest add bromso/model`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bromso/model/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: bromso (https://skillmd.com/u/bromso)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/bromso/model

---


# Model

Build the financial model for "$ARGUMENTS". Create an integrated model with scenario analysis, valuation, and sensitivity testing to support decision-making and fundraising.

## Prerequisites

Read `.metapowers/finance/$ARGUMENTS/04-budget.md`. If this file does not exist, tell the user:

> Phase 4 (Budget) has not been completed for "$ARGUMENTS". Run `/finance:budget $ARGUMENTS` first, or use `--skip-checks` to bypass.

If `--skip-checks` is present in $ARGUMENTS, skip this check and log to `.metapowers/finance/$ARGUMENTS/skip-log.md`.

## Process

1. **Read context:**
   - Read `.metapowers/finance/$ARGUMENTS/01-assess.md` through `04-budget.md` for complete financial picture
   - Reference `financial-model-template.md` for scenario table structure

2. **Build integrated P&L model:**
   - Revenue model with driver-based projections
   - COGS and gross profit
   - Operating expenses by category
   - EBITDA and net income
   - Project 3-5 years with monthly detail for year 1

3. **Build scenario models:**
   - **Base case:** aligned with the forecast and budget
   - **Best case:** upside assumptions (faster growth, better margins)
   - **Worst case:** downside assumptions (slower growth, higher costs, churn)
   - For each scenario: revenue, expenses, cash flow, runway, break-even
   - Reference `financial-model-template.md` for scenario table format

4. **Valuation analysis** (if applicable):
   - Revenue multiples (based on comparable companies)
   - DCF analysis with WACC assumptions
   - Last-round valuation and implied metrics
   - Cap table impact of future fundraising scenarios

5. **Sensitivity analysis:**
   - Identify the 5-8 variables with the most impact
   - Show how changes in each variable affect key outputs
   - Create tornado chart data (which inputs swing outcomes most)

6. **Write the artifact** to `.metapowers/finance/$ARGUMENTS/05-model.md` with sections:
   - **Integrated P&L** — multi-year income statement
   - **Scenario Analysis** — best/base/worst case summaries
   - **Valuation** — multiples, DCF, and comparable analysis
   - **Sensitivity Matrix** — variable impact on key metrics
   - **Model Assumptions Log** — every input and its source/rationale

## Output

The model written to `.metapowers/finance/$ARGUMENTS/05-model.md`. Present a summary highlighting:
- Base case P&L trajectory
- Scenario range (worst to best)
- Valuation range
- Most sensitive variables