Financial Models Skill

Financial Models Skill

Core Philosophy

Know your numbers. Track revenue and expenses religiously. Make data-driven decisions. Aim for profitability, not just revenue.

Key Financial Metrics

Revenue Metrics

Monthly Recurring Revenue (MRR)

MRR = Number of Subscribers × Monthly Price

Stable, predictable income from subscriptions or retainers.

Annual Recurring Revenue (ARR)

ARR = MRR × 12

Used for annual planning and valuation.

Average Revenue Per User (ARPU)

ARPU = Total Revenue / Total Customers

Helpful for comparing segments and tracking growth.

Revenue by Stream

Track each revenue source separately:

• Sponsorships
• Digital products (courses, templates)
• Subscriptions
• Consulting
• Affiliate

Profitability Metrics

Gross Margin

Gross Margin = (Revenue - COGS) / Revenue × 100

For creators, COGS is typically low (platform fees, contractors).

Target: 70-90% for digital products, 60-80% for services

Net Profit Margin

Net Margin = (Revenue - All Expenses) / Revenue × 100

Target: 40-60% for lean operations (Justin Welsh achieves 90%+)

Operating Expenses

• Software/​tools subscriptions
• Contractors/​freelancers
• Marketing/​advertising
• Professional services (legal, accounting)
• Education/​training

Customer Metrics

Customer Acquisition Cost (CAC)

CAC = Total Marketing Spend / New Customers Acquired

Customer Lifetime Value (LTV)

LTV = ARPU × Average Customer Lifespan (months)

For subscriptions:

LTV = Monthly Price / Monthly Churn Rate

LTV:CAC Ratio

LTV:CAC = Customer Lifetime Value / Customer Acquisition Cost

Target: 3:1 or higher

• Below 1:1: Losing money on acquisition
• 1:1 to 3:1: Sustainable but tight
• 3:1+: Healthy, can invest in growth

Subscription Metrics

Churn Rate

Monthly Churn = Customers Lost / Starting Customers × 100

Benchmarks:

• <3% monthly: Excellent
• 3-5% monthly: Good
• 5-7% monthly: Needs attention
• 7%+ monthly: Problem

Retention Rate

Retention = 1 - Churn Rate

P&L Statement Template

Monthly P&L

# Profit & Loss Statement
## [Month Year]

### Revenue
| Source | Amount | % of Total |
|--------|--------|-----------|
| Sponsorships | $X,XXX | XX% |
| Course Sales | $X,XXX | XX% |
| Subscriptions | $XXX | XX% |
| Consulting | $X,XXX | XX% |
| Affiliate | $XXX | XX% |
| **Total Revenue** | **$X,XXX** | **100%** |

### Cost of Goods Sold (COGS)
| Item | Amount |
|------|--------|
| Platform fees | $XXX |
| Payment processing | $XXX |
| Course hosting | $XXX |
| **Total COGS** | **$XXX** |

### Gross Profit
| | Amount | Margin |
|---|--------|--------|
| Gross Profit | $X,XXX | XX% |

### Operating Expenses
| Category | Amount |
|----------|--------|
| Software/​Tools | $XXX |
| Contractors | $XXX |
| Marketing | $XXX |
| Professional services | $XXX |
| Other | $XXX |
| **Total OpEx** | **$XXX** |

### Net Profit
| | Amount | Margin |
|---|--------|--------|
| **Net Profit** | **$X,XXX** | **XX%** |

Annual P&L Summary

# Annual Summary [Year]

| Quarter | Revenue | COGS | Gross Profit | OpEx | Net Profit |
|---------|---------|------|--------------|------|------------|
| Q1 | $XX,XXX | $X,XXX | $XX,XXX | $X,XXX | $XX,XXX |
| Q2 | $XX,XXX | $X,XXX | $XX,XXX | $X,XXX | $XX,XXX |
| Q3 | $XX,XXX | $X,XXX | $XX,XXX | $X,XXX | $XX,XXX |
| Q4 | $XX,XXX | $X,XXX | $XX,XXX | $X,XXX | $XX,XXX |
| **Total** | **$XXX,XXX** | **$XX,XXX** | **$XX,XXX** | **$XX,XXX** | **$XX,XXX** |

Revenue Forecasting

Bottom-Up Forecasting

For Sponsorships

Available slots per month: [X]
Expected fill rate: [X]%
Average deal size: $[X]
= Monthly sponsorship revenue: $[X]

Variables to adjust:
- Subscriber growth → higher rates
- More placements → more inventory
- Better engagement → higher rates

For Products

Monthly traffic to landing page: [X]
Conversion rate: [X]%
Average order value: $[X]
= Monthly product revenue: $[X]

Variables to adjust:
- More traffic
- Better conversion rate
- Higher prices / upsells

For Subscriptions

Current subscribers: [X]
Monthly growth: [X]%
Monthly churn: [X]%
Monthly price: $[X]
= MRR: $[X]

Projection:
Month 1: [X] subs × $[X] = $[X]
Month 2: [X] subs × $[X] = $[X]
...

12-Month Revenue Projection Template

| Month | Sponsors | Products | Subs | Consulting | Affiliate | Total |
|-------|----------|----------|------|------------|-----------|-------|
| Jan | $X | $X | $X | $X | $X | $X |
| Feb | $X | $X | $X | $X | $X | $X |
| Mar | $X | $X | $X | $X | $X | $X |
| Apr | $X | $X | $X | $X | $X | $X |
| May | $X | $X | $X | $X | $X | $X |
| Jun | $X | $X | $X | $X | $X | $X |
| Jul | $X | $X | $X | $X | $X | $X |
| Aug | $X | $X | $X | $X | $X | $X |
| Sep | $X | $X | $X | $X | $X | $X |
| Oct | $X | $X | $X | $X | $X | $X |
| Nov | $X | $X | $X | $X | $X | $X |
| Dec | $X | $X | $X | $X | $X | $X |
| **Total** | $X | $X | $X | $X | $X | **$X** |

**Assumptions**:
- [List key assumptions]

Unit Economics

For Courses

## [Course Name] Unit Economics

**Revenue per sale**: $[X]
**Costs per sale**:
- Payment processing (2.9% + $0.30): $[X]
- Platform fee (X%): $[X]
- Affiliate commission (X%): $[X]
**Net per sale**: $[X]

**Fixed costs** (one-time):
- Creation time: [X] hours × $[X]/​hr = $[X]
- Tools/​software: $[X]
- Marketing launch: $[X]
**Total fixed**: $[X]

**Break-even**: [X] sales
**Current sales**: [X]
**Profit so far**: $[X]

For Sponsorships

## Sponsorship Unit Economics

**Revenue per sponsor**: $[X] average
**Costs per sponsor**:
- Sales time: [X] hours × $[X]/​hr = $[X]
- Creative review: [X] hours = $[X]
- Reporting: [X] hours = $[X]
**Net per sponsor**: $[X]

**Monthly capacity**: [X] sponsors
**Break-even (for time)**: [X] sponsors
**Target**: [X] sponsors at $[X] average = $[X] net

Financial Planning

Budget Template

# [Year] Budget

## Revenue Targets
| Source | Annual Target | Monthly Avg |
|--------|---------------|-------------|
| Sponsorships | $[X] | $[X] |
| Products | $[X] | $[X] |
| Subscriptions | $[X] | $[X] |
| Consulting | $[X] | $[X] |
| Affiliate | $[X] | $[X] |
| **Total** | **$[X]** | **$[X]** |

## Expense Budget
| Category | Annual | Monthly | Notes |
|----------|--------|---------|-------|
| Tools/​Software | $[X] | $[X] | [List] |
| Contractors | $[X] | $[X] | [Who] |
| Marketing | $[X] | $[X] | [Channels] |
| Professional | $[X] | $[X] | Legal, accounting |
| Education | $[X] | $[X] | Courses, conferences |
| Reserve | $[X] | $[X] | Emergency fund |
| **Total** | **$[X]** | **$[X]** | |

## Profit Target
- Target Revenue: $[X]
- Target Expenses: $[X]
- **Target Profit**: $[X] ([X]% margin)

Cash Flow Considerations

Revenue Timing

• Sponsorships: Usually paid before or after campaign
• Products: Immediate (minus refund period)
• Subscriptions: Monthly, predictable
• Consulting: Often net 30-60 days

Expense Timing

• Software: Monthly or annual
• Contractors: Per project or monthly
• Taxes: Quarterly estimated payments

Cash Buffer

Keep 3-6 months of expenses in reserve

Monthly expenses: $[X]
Buffer target: $[X] (X months)

Financial Reporting

Monthly Report Template

# Financial Report: [Month Year]

## Summary
| Metric | This Month | Last Month | Change |
|--------|------------|------------|--------|
| Revenue | $[X] | $[X] | [+/​-X%] |
| Expenses | $[X] | $[X] | [+/​-X%] |
| Net Profit | $[X] | $[X] | [+/​-X%] |
| Profit Margin | [X]% | [X]% | [+/​-X%] |

## Revenue Breakdown
[Pie chart or table by source]

## Notable Items
- [Highlight: Best performing revenue source]
- [Concern: Any issues to address]
- [Opportunity: Potential for next month]

## vs. Budget
| Metric | Actual | Budget | Variance |
|--------|--------|--------|----------|
| Revenue | $[X] | $[X] | [+/​-X%] |
| Expenses | $[X] | $[X] | [+/​-X%] |

## Next Month Focus
1. [Priority 1]
2. [Priority 2]
3. [Priority 3]

Quarterly Business Review

# Q[X] [Year] Review

## Financial Performance
| Metric | Q[X] | Q[X-1] | YoY Change |
|--------|------|--------|------------|
| Revenue | $[X] | $[X] | [+/​-X%] |
| Net Profit | $[X] | $[X] | [+/​-X%] |
| Customers | [X] | [X] | [+/​-X%] |

## Revenue Mix
[Chart showing revenue by source]

## Key Wins
1. [Achievement 1]
2. [Achievement 2]
3. [Achievement 3]

## Challenges
1. [Issue 1]
2. [Issue 2]

## Next Quarter Goals
1. [Goal 1] - Target: [Metric]
2. [Goal 2] - Target: [Metric]
3. [Goal 3] - Target: [Metric]

Tax Considerations (General)

Track for Taxes

• All income by source
• All deductible expenses
• Home office usage (if applicable)
• Equipment purchases
• Software subscriptions
• Professional development

Common Creator Deductions

• Software and tools
• Home office
• Equipment (computer, mic, camera)
• Professional services
• Education and training
• Marketing expenses
• Travel for business

Quarterly Estimated Taxes

If you expect to owe $1,000+ in taxes:

• Q1: April 15
• Q2: June 15
• Q3: September 15
• Q4: January 15

Disclaimer: Consult a tax professional for specific advice

Pricing Analysis Tools

Price Sensitivity Analysis

## [Product] Pricing Analysis

| Price | Expected Volume | Revenue | Notes |
|-------|----------------|---------|-------|
| $29 | 200 | $5,800 | High volume |
| $49 | 150 | $7,350 | Sweet spot? |
| $79 | 80 | $6,320 | Premium positioning |
| $99 | 50 | $4,950 | Too expensive? |

**Recommendation**: $[X] based on [reasoning]

Discount Impact Calculator

## Discount Impact on [Product/​Service]

| Discount | Price | Break-even Volume Increase |
|----------|-------|---------------------------|
| 10% | $90 (was $100) | +11% |
| 20% | $80 | +25% |
| 30% | $70 | +43% |
| 40% | $60 | +67% |
| 50% | $50 | +100% |

**Question to ask**: Will this discount really drive [X]% more volume?

Resources

• Baremetrics - SaaS Metrics
• ChartMogul - Subscription Analytics
• Stripe Atlas Guides
• Justin Welsh - Solopreneur Financials