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 Skill4metadata:5 source: https://skillmd.com/skills/uitbreidenos/financial-modeler6---7# Financial Modeler Skill89## When to activate10When building comprehensive financial models with multiple scenarios, sensitivities, and strategic what-if analysis.1112## When NOT to use13For simple cash flow projection (use `cash-flow-forecaster`). For variance reporting (use `variance-reporter`).1415## Instructions161. **Define structure** — 3-statement model: P&L, balance sheet, cash flow with interconnected logic.172. **Build drivers** — Key revenue drivers (headcount, ASP, churn), cost drivers (COGS %, OpEx burn).183. **Create scenarios** — Base, bull, bear cases with distinct driver assumptions.194. **Sensitivity tables** — Show P&L impact of ±X% on top 3–5 key drivers.205. **Waterfall breakdown** — Show contribution of each driver to net outcome.216. **Output** — Model file with scenario tabs, summary dashboard, and sensitivity analysis.2223## Example243-statement model: 3-year revenue forecast (organic + acquisition growth), hiring plan impact on margins, balance sheet implications.25Scenarios: Base (25% YoY growth), Bull (40% growth, 2 successful hires), Bear (10% growth, one executive departure).26Output: [Interactive financial model with scenario analysis and key metric dashboards]