Financial Modeler Skill
When to activate
When building comprehensive financial models with multiple scenarios, sensitivities, and strategic what-if analysis.
When NOT to use
For simple cash flow projection (use cash-flow-forecaster). For variance reporting (use variance-reporter).
Instructions
- Define structure — 3-statement model: P&L, balance sheet, cash flow with interconnected logic.
- Build drivers — Key revenue drivers (headcount, ASP, churn), cost drivers (COGS %, OpEx burn).
- Create scenarios — Base, bull, bear cases with distinct driver assumptions.
- Sensitivity tables — Show P&L impact of ±X% on top 3–5 key drivers.
- Waterfall breakdown — Show contribution of each driver to net outcome.
- Output — Model file with scenario tabs, summary dashboard, and sensitivity analysis.
Example
3-statement model: 3-year revenue forecast (organic + acquisition growth), hiring plan impact on margins, balance sheet implications.
Scenarios: Base (25% YoY growth), Bull (40% growth, 2 successful hires), Bear (10% growth, one executive departure).
Output: [Interactive financial model with scenario analysis and key metric dashboards]
1---2name: financial-modeler3description: Financial Modeler Skill4---5# Financial Modeler Skill67## When to activate8When building comprehensive financial models with multiple scenarios, sensitivities, and strategic what-if analysis.910## When NOT to use11For simple cash flow projection (use `cash-flow-forecaster`). For variance reporting (use `variance-reporter`).1213## Instructions141. **Define structure** — 3-statement model: P&L, balance sheet, cash flow with interconnected logic.152. **Build drivers** — Key revenue drivers (headcount, ASP, churn), cost drivers (COGS %, OpEx burn).163. **Create scenarios** — Base, bull, bear cases with distinct driver assumptions.174. **Sensitivity tables** — Show P&L impact of ±X% on top 3–5 key drivers.185. **Waterfall breakdown** — Show contribution of each driver to net outcome.196. **Output** — Model file with scenario tabs, summary dashboard, and sensitivity analysis.2021## Example223-statement model: 3-year revenue forecast (organic + acquisition growth), hiring plan impact on margins, balance sheet implications.23Scenarios: Base (25% YoY growth), Bull (40% growth, 2 successful hires), Bear (10% growth, one executive departure).24Output: [Interactive financial model with scenario analysis and key metric dashboards]
UitbreidenOS