Financial Modeling Workflow | Bootspring Docs

The Financial Modeling workflow helps founders build comprehensive financial models that inform decisions, guide fundraising, and track business health.

Overview#

Property	Value
Phases	4
Tier	Business
Typical Duration	1-2 weeks
Best For	Fundraising, budgeting, scenario planning

Why Financial Modeling Matters#

Good financial models:

Inform decisions - Understand impact of choices before making them
Enable fundraising - Investors expect projections and unit economics
Track progress - Compare actuals to plan
Identify risks - Understand runway and burn rate

Financial Model Structure#

┌─────────────────────────────────────────────────────────────────────────┐
│                         FINANCIAL MODEL STRUCTURE                        │
├─────────────────────────────────────────────────────────────────────────┤
│                                                                         │
│  ┌─────────────────────────────────────────────────────────────────┐   │
│  │                         ASSUMPTIONS                              │   │
│  │  Pricing, growth rates, conversion rates, costs                  │   │
│  └─────────────────────────────────────────────────────────────────┘   │
│                              │                                          │
│              ┌───────────────┼───────────────┐                         │
│              │               │               │                         │
│       ┌──────▼──────┐ ┌──────▼──────┐ ┌──────▼──────┐                  │
│       │   REVENUE   │ │    COSTS    │ │  UNIT ECON  │                  │
│       │   Model     │ │   Model     │ │   Model     │                  │
│       └──────┬──────┘ └──────┬──────┘ └──────┬──────┘                  │
│              │               │               │                          │
│              └───────────────┼───────────────┘                          │
│                              │                                          │
│                       ┌──────▼──────┐                                   │
│                       │    P&L      │                                   │
│                       │  Statement  │                                   │
│                       └──────┬──────┘                                   │
│                              │                                          │
│              ┌───────────────┼───────────────┐                          │
│              │               │               │                          │
│       ┌──────▼──────┐ ┌──────▼──────┐ ┌──────▼──────┐                  │
│       │  CASH FLOW  │ │   RUNWAY    │ │  SCENARIOS  │                  │
│       │             │ │             │ │             │                   │
│       └─────────────┘ └─────────────┘ └─────────────┘                  │
│                                                                         │
└─────────────────────────────────────────────────────────────────────────┘

Phases#

Phase 1: Revenue Model (3-5 days)#

Agents: business-analyst

Build a detailed revenue model based on your pricing and growth assumptions.

Tasks:

Define pricing tiers
Model customer acquisition
Project revenue by segment
Calculate key revenue metrics

Revenue Model Template:

Loading code block...

Revenue by Segment#

Month	Pro MRR	Team MRR	Ent MRR	Total MRR	Growth
M1	$58	$0	$0	$58	-
M3	$290	$198	$0	$488	741%
M6	$1,160	$990	$500	$2,650	443%
M12	$5,220	$4,950	$2,500	$12,670	378%


### Phase 2: Cost Model (2-3 days)

**Agents:** business-analyst

Model all costs including infrastructure, people, and services.

**Tasks:**
- Categorize fixed vs. variable costs
- Project infrastructure costs at scale
- Plan headcount and compensation
- Model marketing spend

**Cost Model Template:**

```markdown
## Cost Model

### Fixed Costs (Monthly)

| Category | Item | M1 | M6 | M12 | Notes |
|----------|------|-----|-----|-----|-------|
| Infrastructure | Hosting | $20 | $100 | $500 | Scales with users |
| Infrastructure | Database | $20 | $50 | $200 | Scales with data |
| Infrastructure | CDN/Storage | $0 | $20 | $100 | |
| Services | Auth (managed provider) | $25 | $50 | $100 | Per MAU |
| Services | Email (Resend) | $20 | $50 | $100 | |
| Services | Analytics | $0 | $0 | $100 | Free tier |
| Services | Error tracking | $26 | $26 | $50 | |
| Tools | Dev tools | $50 | $100 | $200 | |
| **Subtotal** | | **$161** | **$396** | **$1,350** | |

### Variable Costs

| Category | Unit Cost | M1 | M6 | M12 |
|----------|-----------|-----|-----|-----|
| Payment processing | 2.9% + $0.30 | $2 | $77 | $367 |
| Customer support | $0.50/user | $20 | $250 | $1,250 |
| **Subtotal** | | **$22** | **$327** | **$1,617** |

### People Costs

| Role | M1 | M6 | M12 | Notes |
|------|-----|-----|------|-------|
| Founder(s) | $0 | $0 | $8,000 | Salary starts M10 |
| Engineer #1 | $0 | $0 | $12,000 | Hire M9 |
| Engineer #2 | $0 | $0 | $0 | Hire M14 |
| Customer Success | $0 | $0 | $0 | Hire M15 |
| **Subtotal** | **$0** | **$0** | **$20,000** | |

### Marketing Costs

| Channel | M1 | M6 | M12 | Notes |
|---------|-----|-----|------|-------|
| Content/SEO | $0 | $500 | $1,000 | Writer |
| Paid ads | $0 | $500 | $2,000 | Test channels |
| Tools | $50 | $100 | $200 | SEO, social |
| **Subtotal** | **$50** | **$1,100** | **$3,200** | |

### Total Costs Summary

| Category | M1 | M6 | M12 |
|----------|-----|-----|------|
| Fixed costs | $161 | $396 | $1,350 |
| Variable costs | $22 | $327 | $1,617 |
| People | $0 | $0 | $20,000 |
| Marketing | $50 | $1,100 | $3,200 |
| **Total** | **$233** | **$1,823** | **$26,167** |

Phase 3: Unit Economics (2-3 days)#

Agents: business-analyst

Calculate and optimize unit economics for sustainable growth.

Tasks:

Calculate Customer Acquisition Cost (CAC)
Calculate Lifetime Value (LTV)
Analyze LTV:CAC ratio
Model payback period

Unit Economics Model:

Loading code block...

LTV = ARPA × Gross Margin × (1 / Monthly Churn Rate)


**By Segment:**

| Segment | ARPA | Gross Margin | Churn | Lifetime | LTV |
|---------|------|--------------|-------|----------|-----|
| Pro | $29 | 85% | 5% | 20 mo | $493 |
| Team | $99 | 85% | 4% | 25 mo | $2,104 |
| Enterprise | $500 | 80% | 2% | 50 mo | $20,000 |

### LTV:CAC Ratio

| Segment | LTV | CAC | LTV:CAC | Target | Status |
|---------|-----|-----|---------|--------|--------|
| Pro | $493 | $25 | 19.7:1 | > 3:1 | Excellent |
| Team | $2,104 | $100 | 21.0:1 | > 3:1 | Excellent |
| Enterprise | $20,000 | $1,000 | 20.0:1 | > 3:1 | Excellent |
| **Blended** | **$1,532** | **$73** | **21.0:1** | > 3:1 | **Excellent** |

### Payback Period

**Formula:**

Payback = CAC / (ARPA × Gross Margin)


| Segment | CAC | Monthly Contribution | Payback |
|---------|-----|---------------------|---------|
| Pro | $25 | $24.65 | 1.0 mo |
| Team | $100 | $84.15 | 1.2 mo |
| Enterprise | $1,000 | $400 | 2.5 mo |

**Target:** < 12 months
**Status:** All segments well under target

### Unit Economics Dashboard

┌─────────────────────────────────────────────────────────────────────────┐ │ UNIT ECONOMICS DASHBOARD │ ├─────────────────────────────────────────────────────────────────────────┤ │ │ │ LTV:CAC RATIO PAYBACK PERIOD │ │ ┌─────────────┐ ┌─────────────┐ │ │ │ │ │ │ │ │ │ 21:1 │ │ 1.5 mo │ │ │ │ Target │ │ Target │ │ │ │ >3:1 │ │ <12 mo │ │ │ │ ✓ GOOD │ │ ✓ GOOD │ │ │ └─────────────┘ └─────────────┘ │ │ │ │ GROSS MARGIN CHURN RATE │ │ ┌─────────────┐ ┌─────────────┐ │ │ │ │ │ │ │ │ │ 85% │ │ 4% │ │ │ │ Target │ │ Target │ │ │ │ >70% │ │ <5% │ │ │ │ ✓ GOOD │ │ ✓ GOOD │ │ │ └─────────────┘ └─────────────┘ │ │ │ └─────────────────────────────────────────────────────────────────────────┘

Phase 4: Financial Statements & Scenarios (3-5 days)#

Agents: business-analyst

Build comprehensive financial statements and scenario analysis.

Tasks:

Create P&L statement
Build cash flow projection
Calculate runway
Model scenarios (base, bull, bear)

Profit & Loss Statement:

Loading code block...

Cash Flow & Runway:

Loading code block...

Runway = Cash Balance / Monthly Burn Rate Runway = $30,000 / $11,897 = 2.5 months (at M12 burn)


**Runway by Stage:**

| Period | Cash | Monthly Burn | Runway |
|--------|------|--------------|--------|
| Now (M1) | $50,000 | $155 | 322 mo |
| M6 | $51,500 | -$1,103 | Profitable |
| M12 | $30,000 | $11,897 | 2.5 mo |

**Note:** Burn increases with hiring. Need to fundraise by M10 or reach profitability.

### Break-Even Analysis

**Monthly Break-Even:**
- Fixed costs at scale: ~$25,000/mo
- Contribution margin: 85%
- Break-even MRR: $25,000 / 0.85 = $29,412

**Timeline to Break-Even:** Month 14-16 (projected)

Scenario Analysis:

Loading code block...

Starting the Workflow#

Loading code block...

Deliverables#

A successful Financial Modeling workflow produces:

Revenue model with projections
Cost model (fixed, variable, people)
Unit economics (CAC, LTV, payback)
P&L statement (monthly, annual)
Cash flow projection
Runway calculation
Scenario analysis (bull, base, bear)
Investor-ready financial summary

Best Practices#

Be conservative - Overestimate costs, underestimate revenue
Show your work - Document assumptions clearly
Build for scenarios - Plans change, models should adapt
Update monthly - Compare actuals to projections
Focus on unit economics - LTV:CAC > 3:1 is critical
Know your runway - Never be surprised by cash position

Key Metrics for Investors#

Metric	Seed Stage Target	Series A Target
MRR	$10-50K	$100K+
MoM Growth	15-20%	10-15%
Gross Margin	> 70%	> 80%
LTV:CAC	> 3:1	> 3:1
Payback	< 12 mo	< 12 mo
Net Revenue Retention	> 100%	> 120%

Common Pitfalls#

Hockey stick projections without evidence
Ignoring churn in revenue models
Underestimating people costs
Not stress-testing scenarios
Forgetting variable costs at scale