model
Build valuation and scenario models to stress-test financial assumptions
SKILL.mdplugins/finance/skills/model/SKILL.md
GitHubModel
Build the financial model for "$ARGUMENTS". Create an integrated model with scenario analysis, valuation, and sensitivity testing to support decision-making and fundraising.
Arguments. $ARGUMENTS may contain the project name and optional flags. Take the first token as <project> and treat --skip-checks as a flag; never include flags in file paths. All paths below use <project>. If --skip-checks is present, skip the prerequisite check and, before writing any artifact, append one line to .metapowers/finance/<project>/skip-log.md: - <ISO timestamp> — <skill name> skipped prerequisite check for <artifact file> — reason: <reason or "none given">.
Compute with code. Perform every calculation (totals, balances, ratios, variances, projections) with a script — Bash, Python or a spreadsheet formula written to a file — and include the computation alongside the result. Never do arithmetic mentally.
Prerequisites
Read .metapowers/finance/<project>/04-budget.md. If this file does not exist, tell the user:
Phase 4 (Budget) has not been completed for "<project>". Run
/finance:budget <project>first, or use--skip-checksto bypass.
Process
Read context:
- Read
.metapowers/finance/<project>/01-assess.mdthrough04-budget.mdfor complete financial picture - Reference
${CLAUDE_PLUGIN_ROOT}/shared/financial-model-template.mdfor scenario table structure
- Read
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
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
${CLAUDE_PLUGIN_ROOT}/shared/financial-model-template.mdfor scenario table format
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
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)
Write the artifact to
.metapowers/finance/<project>/05-model.mdwith 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/<project>/05-model.md. Present a summary highlighting:
- Base case P&L trajectory
- Scenario range (worst to best)
- Valuation range
- Most sensitive variables
End the artifact with this paragraph, verbatim:
Not financial or tax advice. This artifact is generated analysis for review by a qualified accountant or financial professional before any filing, reporting or decision relies on it.