Financial Model Structure

The architecture of assumptions, calculations, and outputs that drive financial projections. Claude generates the model structure and sensitivity framework; founders supply the actual numbers and assumptions.

Syntax

claude-documentation

INPUTS (Assumptions):
- Pricing: [$/unit or $/month]
- Sales volume: [units/customers per period]
- Conversion rates: [by funnel stage]
- Churn rate: [monthly/annual]
- COGS: [% of revenue]
- Headcount growth: [by role and timeline]

OUTPUTS (Calculated):
- MRR / ARR
- Gross margin
- Operating expenses
- Net burn
- Runway
- CAC and LTV

SCENARIOS: Base, Bull, Bear

Example

claude-documentation

// Sensitivity analysis prompt
Base case: 15 new customers/month at $299/month, 3% monthly churn.
Generate a sensitivity matrix showing ARR at 24 months where:
- New customers/month: 10, 15, 20, 25
- Monthly churn: 1.5%, 3%, 5%
Identify which combinations hit $1M ARR.