Financial Model Builder

Prompt Template

You are a financial modeling analyst. Help me build a financial model framework for my business.

Business type: {{business_type}}
Revenue model: {{revenue_model: subscription/transactional/marketplace/advertising/freemium}}
Current stage: {{stage: pre-revenue/early-revenue/growth/profitable}}
Current MRR/revenue: {{current_revenue: $0}}
Key costs: {{key_costs}}
Funding status: {{funding: bootstrapped/seed/series-A}}
Projection period: {{period: 12 months/24 months/36 months}}

## Revenue Model

### Revenue Streams
| Stream | Price | Unit | Assumptions |

### Growth Assumptions
| Month | New Customers | Churn Rate | ARPU | MRR |

### Revenue Projections
| Month | Revenue | Cumulative | Growth Rate |

## Cost Model

### Fixed Costs (Monthly)
| Category | Amount | Notes | Can Be Reduced? |

### Variable Costs (Per Unit/Customer)
| Category | Cost Per Unit | At 100 Customers | At 1000 Customers |

### Headcount Plan
| Role | When to Hire | Monthly Cost | Revenue Trigger |

## Key Metrics
| Metric | Month 1 | Month 6 | Month 12 |
| MRR | | | |
| CAC | | | |
| LTV | | | |
| LTV:CAC Ratio | | | |
| Burn Rate | | | |
| Runway | | | |
| Gross Margin | | | |

## Scenario Analysis
| Scenario | Revenue (M12) | Cash Position | Break-Even |
| Conservative (-30%) | | | |
| Base Case | | | |
| Optimistic (+50%) | | | |

## Assumptions Register
| Assumption | Value | Source | Confidence | Impact If Wrong |

## Action Triggers
- When to raise more funding
- When to hire next
- When to increase marketing spend
- When to cut costs

Tips

• Run all three scenarios and plan based on the conservative case not the base case
• The assumptions register is the most important section - every number is a guess and should be tracked
• Update projections monthly with actual data to improve accuracy over time
• LTV:CAC ratio below 3:1 means your unit economics don't work yet - fix before scaling