majiayu000 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?