Cernio — Financial Projections
Version: 1.0 Date: 2026-03-25 Beta Launch (Month 0): August 2026 Source: Handbook (Ch. 68-84, 85-100), Strategy (02, 04), Revenue & Cost Structure (02) Purpose: 3/6/12-month and 3-year financial projections for investor analysis and strategic planning
1. Key Assumptions
Growth Assumptions
| Assumption | Value | Rationale |
|---|---|---|
| Beta launch date | August 2026 | Ring 1 completion target |
| Beta duration | 3 months (Aug-Oct 2026) | Free access, feedback collection |
| Paid launch | November 2026 (Month 3) | Stripe activated, Pro plan available |
| Initial users (beta invite) | 10 | Founder’s personal network (Handbook Ch. 89) |
| Monthly user growth (beta) | 5-8 new users/month | Network + trade fair referrals |
| Monthly user growth (post-launch) | 15-25% MoM | PLG + content + referrals |
| Free → Pro conversion rate | 15-25% | Industry SaaS avg 5-10%, higher for niche vertical |
| Pro → Team upgrade rate | 5-10% per year | Teams with 2+ export managers |
| Monthly churn (Pro) | 3-5% | Vertical SaaS benchmark |
| Monthly churn (Team) | 2-3% | Higher switching costs |
Pricing Assumptions
| Item | Value | Notes |
|---|---|---|
| Pro plan price | $59/mo | Midpoint of $39-79 range |
| Team plan price | $149/mo | Midpoint of $99-199 range |
| Enterprise plan price | $500/mo | Custom, estimated average |
| Average credit pack revenue per buyer | $40/quarter | Weighted average across pack sizes |
| Credit pack buyer rate | 20% of paid users | Power users exceeding plan limits |
| Annual discount | 20% | Offered from Month 6+ |
Cost Assumptions
| Item | Value | Notes |
|---|---|---|
| Infrastructure (fixed) | $18/mo → scales at 200+ users | Hetzner VPS, self-hosted |
| AI cost per search | $0.06 | Current provider pricing |
| Average searches per Pro user/mo | 30 | Handbook Ch. 80: light=10, medium=30, heavy=80 |
| Average searches per Team user/mo | 100 | Team = higher usage teams |
| Stripe transaction fee | 2.9% + $0.30 | Standard rate |
| Marketing spend (Year 1) | $0 | Bootstrapped, organic only |
| Marketing spend (Year 2+) | $500-2,000/mo | Content, trade fair travel, LinkedIn ads |
2. Three-Month Projection (Beta Period: Aug-Oct 2026)
Month-by-Month
| Metric | Month 0 (Aug) | Month 1 (Sep) | Month 2 (Oct) |
|---|---|---|---|
| Users | |||
| New signups | 10 | 7 | 8 |
| Total registered users | 10 | 17 | 25 |
| Active users | 8 | 14 | 20 |
| Revenue | |||
| Subscription revenue | $0 | $0 | $0 |
| Credit revenue | $0 | $0 | $0 |
| Total revenue | $0 | $0 | $0 |
| Costs | |||
| Infrastructure | $18 | $18 | $18 |
| AI API costs | $15 | $25 | $36 |
| Total costs | $33 | $43 | $54 |
| Net | -$33 | -$43 | -$54 |
Beta Period Summary
| Metric | Value |
|---|---|
| Total beta investment | ~$130 |
| Users acquired | 25 |
| Cost per beta user | $5.20 |
| Key goal | Validate discovery accuracy, collect feedback, refine onboarding |
Beta is intentionally free. Revenue = $0. The goal is product-market fit validation with real exporters, not revenue. Beta users get relaxed limits (5 discoveries/mo, 3 reveals/mo).
3. Six-Month Projection (Aug 2026 - Jan 2027)
Month-by-Month
| Metric | M0 (Aug) | M1 (Sep) | M2 (Oct) | M3 (Nov) | M4 (Dec) | M5 (Jan) |
|---|---|---|---|---|---|---|
| Users | ||||||
| New signups | 10 | 7 | 8 | 12 | 15 | 20 |
| Total registered | 10 | 17 | 25 | 37 | 52 | 72 |
| Free users | 10 | 17 | 25 | 32 | 42 | 55 |
| Pro users | 0 | 0 | 0 | 5 | 9 | 14 |
| Team users | 0 | 0 | 0 | 0 | 1 | 3 |
| Churned (cumulative) | 0 | 0 | 0 | 0 | 0 | 1 |
| Revenue | ||||||
| Subscription MRR | $0 | $0 | $0 | $295 | $680 | $1,273 |
| Credit pack revenue | $0 | $0 | $0 | $0 | $40 | $80 |
| Total MRR | $0 | $0 | $0 | $295 | $720 | $1,353 |
| Costs | ||||||
| Infrastructure | $18 | $18 | $18 | $18 | $18 | $18 |
| AI API costs | $15 | $25 | $36 | $52 | $72 | $100 |
| Stripe fees | $0 | $0 | $0 | $9 | $21 | $40 |
| Total costs | $33 | $43 | $54 | $79 | $111 | $158 |
| Net profit/loss | -$33 | -$43 | -$54 | +$216 | +$609 | +$1,195 |
Six-Month Summary
| Metric | Value |
|---|---|
| Total revenue (6 months) | $2,368 |
| Total costs (6 months) | $478 |
| Net profit (6 months) | +$1,890 |
| Ending MRR | $1,353 |
| Total paying customers | 17 (14 Pro + 3 Team) |
| Total registered users | 72 |
| Free → Paid conversion | 23.6% |
| Cumulative churn | 1 user |
The business is profitable from Month 3 (first paid month). This is the power of near-zero fixed costs.
4. Twelve-Month Projection (Aug 2026 - Jul 2027)
Quarterly Summary
| Metric | Q1 (Aug-Oct) | Q2 (Nov-Jan) | Q3 (Feb-Apr) | Q4 (May-Jul) |
|---|---|---|---|---|
| Users | ||||
| New signups | 25 | 47 | 85 | 140 |
| Total registered | 25 | 72 | 155 | 290 |
| Free users | 25 | 55 | 105 | 178 |
| Pro users | 0 | 14 | 38 | 78 |
| Team users | 0 | 3 | 8 | 18 |
| Enterprise users | 0 | 0 | 0 | 1 |
| Churned (quarter) | 0 | 1 | 4 | 8 |
| Revenue | ||||
| Quarterly sub revenue | $0 | $2,248 | $8,940 | $20,310 |
| Quarterly credit revenue | $0 | $120 | $480 | $1,200 |
| Quarterly total | $0 | $2,368 | $9,420 | $21,510 |
| Costs | ||||
| Infrastructure | $54 | $54 | $54 | $80 |
| AI API costs | $76 | $224 | $580 | $1,200 |
| Stripe fees | $0 | $70 | $280 | $640 |
| Marketing | $0 | $0 | $0 | $500 |
| Quarterly total costs | $130 | $348 | $914 | $2,420 |
| Quarterly net | -$130 | +$2,020 | +$8,506 | +$19,090 |
Year 1 Summary (12 Months)
| Metric | Value |
|---|---|
| Total revenue | $33,298 |
| Total costs | $3,812 |
| Net profit | $29,486 |
| Ending MRR | $7,951 |
| Ending ARR (annualized) | $95,412 |
| Total registered users | 290 |
| Total paying customers | 97 (78 Pro + 18 Team + 1 Enterprise) |
| Free → Paid conversion rate | 22% (lifetime) |
| Monthly churn rate | ~3.5% |
| Net Revenue Retention | ~105% (upgrades offset churn) |
Year 1 Revenue Waterfall
5. Three-Year Projection (Aug 2026 - Jul 2029)
Annual Summary
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Users | |||
| New signups | 297 | 600 | 1,200 |
| Total registered (cumulative) | 290 | 820 | 1,850 |
| Paying customers (end of year) | 97 | 310 | 680 |
| — Pro | 78 | 230 | 480 |
| — Team | 18 | 65 | 160 |
| — Enterprise | 1 | 15 | 40 |
| Annual churn | 13 | 75 | 150 |
| Revenue | |||
| Subscription revenue | $33,298 | $168,000 | $456,000 |
| Credit pack revenue | $1,800 | $12,000 | $36,000 |
| Total revenue | $35,098 | $180,000 | $492,000 |
| Costs | |||
| Infrastructure | $242 | $960 | $2,400 |
| AI API costs | $2,080 | $12,000 | $36,000 |
| Stripe fees | $990 | $5,400 | $14,760 |
| Marketing | $500 | $12,000 | $24,000 |
| Tools & SaaS | $0 | $1,200 | $3,600 |
| Contractor/hire (Year 3) | $0 | $0 | $60,000 |
| Total costs | $3,812 | $31,560 | $140,760 |
| Net profit | $31,286 | $148,440 | $351,240 |
| Profit margin | 89.1% | 82.5% | 71.4% |
Key Milestones
| Milestone | When | Metric |
|---|---|---|
| First paying customer | Month 3 (Nov 2026) | $59 MRR |
| $1K MRR | Month 5 (Jan 2027) | ~15 paying customers |
| $5K MRR | Month 9 (May 2027) | ~80 paying customers |
| $10K MRR | Month 13 (Sep 2027) | ~150 paying customers |
| $25K MRR | Month 20 (Apr 2028) | ~350 paying customers |
| $50K MRR | Month 28 (Dec 2028) | ~680 paying customers |
| $100K ARR | Month 13 (Sep 2027) | Annualized from MRR |
| $500K ARR | Month 28 (Dec 2028) | Annualized from MRR |
| First hire | Month 24 (Aug 2028) | Revenue supports salary |
Year-over-Year Growth
| Metric | Y1 → Y2 | Y2 → Y3 |
|---|---|---|
| Revenue growth | +413% | +173% |
| Customer growth | +220% | +119% |
| ARPU growth | +20% | +12% |
6. MRR Growth Trajectory (36 Months)
7. Cash Flow Analysis
Cumulative Cash Position (No External Funding)
| Month | Cumulative Revenue | Cumulative Costs | Cash Position |
|---|---|---|---|
| M0 (Aug 2026) | $0 | $33 | -$33 |
| M3 (Nov 2026) | $295 | $209 | +$86 |
| M6 (Jan 2027) | $2,368 | $478 | +$1,890 |
| M12 (Jul 2027) | $35,098 | $3,812 | +$31,286 |
| M18 (Jan 2028) | $95,000 | $16,000 | +$79,000 |
| M24 (Jul 2028) | $215,098 | $35,372 | +$179,726 |
| M30 (Jan 2029) | $380,000 | $90,000 | +$290,000 |
| M36 (Jul 2029) | $707,098 | $176,132 | +$530,966 |
Monthly Burn Rate
| Period | Monthly Burn | Notes |
|---|---|---|
| Beta (M0-M2) | ~$43 | Infrastructure + minimal AI |
| Early paid (M3-M6) | ~$100 | AI costs scale with users |
| Growth (M7-M12) | ~$250 | Moderate AI + first marketing |
| Year 2 average | ~$2,630 | Marketing spend + growing AI |
| Year 3 average | ~$11,730 | First hire + scaled operations |
Runway is essentially infinite with no external funding. The business generates positive cash flow from Month 3 and never requires funding to operate. Total pre-revenue investment is ~$130 (beta period).
8. Sensitivity Analysis
What If Conversion Is Lower?
| Free → Pro Rate | Paying Customers (Y1) | Year 1 Revenue | Year 1 Profit |
|---|---|---|---|
| 10% (pessimistic) | 29 | $12,000 | $9,000 |
| 15% (conservative) | 44 | $20,000 | $17,000 |
| 22% (expected) | 97 | $35,098 | $31,286 |
| 30% (optimistic) | 87 | $42,000 | $38,000 |
What If Churn Is Higher?
| Monthly Churn | Paying Customers (Y1 end) | Year 1 Revenue | Impact |
|---|---|---|---|
| 2% (optimistic) | 110 | $38,000 | +$3K vs expected |
| 3.5% (expected) | 97 | $35,098 | baseline |
| 5% (pessimistic) | 82 | $30,000 | -$5K vs expected |
| 8% (worst case) | 60 | $22,000 | -$13K vs expected |
What If AI Costs Double?
| Scenario | AI Cost/Search | Year 1 AI Spend | Impact on Margin |
|---|---|---|---|
| Current | $0.06 | $2,080 | 85% gross margin |
| 2x cost | $0.12 | $4,160 | 80% gross margin |
| 3x cost | $0.18 | $6,240 | 75% gross margin |
| 5x cost | $0.30 | $10,400 | 65% gross margin |
Even at 5x current AI costs, the business remains profitable with 65% gross margins. The model is highly resilient to AI cost increases.
What If User Growth Is Slower?
| Growth Rate | Users (Y1 end) | Paying (Y1 end) | Y1 Revenue |
|---|---|---|---|
| 50% of expected | 145 | 48 | $17,500 |
| 75% of expected | 218 | 73 | $26,300 |
| 100% (expected) | 290 | 97 | $35,098 |
| 150% of expected | 435 | 145 | $52,600 |
9. Scenario Comparison
Three Scenarios Over 3 Years
| Metric | Bear Case | Base Case | Bull Case |
|---|---|---|---|
| Assumptions | |||
| Conversion rate | 12% | 22% | 30% |
| Monthly churn | 5% | 3.5% | 2% |
| User growth | Slow (50%) | Expected | Fast (150%) |
| Year 1 | |||
| Revenue | $12,000 | $35,098 | $52,600 |
| Paying customers | 29 | 97 | 145 |
| MRR (end) | $2,000 | $7,951 | $13,000 |
| Year 2 | |||
| Revenue | $60,000 | $180,000 | $350,000 |
| Paying customers | 100 | 310 | 600 |
| MRR (end) | $8,000 | $25,000 | $50,000 |
| Year 3 | |||
| Revenue | $150,000 | $492,000 | $1,200,000 |
| Paying customers | 220 | 680 | 1,500 |
| MRR (end) | $18,000 | $50,000 | $120,000 |
| Cumulative (3 years) | |||
| Total revenue | $222,000 | $707,098 | $1,602,600 |
| Total costs | $80,000 | $176,132 | $400,000 |
| Total profit | $142,000 | $530,966 | $1,202,600 |
| Ending ARR | $216,000 | $600,000 | $1,440,000 |
10. Key Metrics Dashboard (Investor View)
SaaS Health Metrics at Month 12
| Metric | Value | Benchmark | Status |
|---|---|---|---|
| MRR | $7,951 | — | Growing |
| ARR (annualized) | $95,412 | — | Growing |
| MRR Growth (MoM) | 15-20% | >10% = excellent | Excellent |
| Gross Margin | 85%+ | >70% = healthy | Excellent |
| Net Revenue Retention | ~105% | >100% = expansion | Good |
| Monthly Churn | 3.5% | <5% for SMB SaaS | Good |
| LTV:CAC | 50x+ | >3x = healthy | Outstanding |
| CAC Payback | <1 month | <12 months = good | Outstanding |
| Free → Paid Conversion | 22% | >5% = good | Excellent |
| Burn Multiple | Negative (profitable) | <2x = efficient | Outstanding |
SaaS Health Metrics at Month 36
| Metric | Value | Benchmark | Status |
|---|---|---|---|
| MRR | $50,000 | — | Strong |
| ARR | $600,000 | — | Approaching $1M |
| Paying customers | 680 | — | Healthy base |
| Gross Margin | 71% | >70% = healthy | Good (hire costs) |
| Monthly Churn | 3% | <5% = good | Improving |
11. Funding Scenarios
Scenario A: Bootstrap (Recommended Path)
Scenario B: Small Seed Round ($50K-100K)
Scenario C: Larger Seed ($250K-500K)
Summary
| Question | Answer |
|---|---|
| Can this business survive without funding? | Yes — $130 pre-revenue investment, profitable from Month 3 |
| When does it become a real income? | Month 7-8 ($3K+/mo extractable) |
| When does it hit $100K ARR? | Month 13 (Sep 2027) |
| What’s the 3-year revenue? | 1.6M (bull) |
| What’s the biggest risk? | Slow user acquisition (addressable with marketing) |
| What’s the strongest signal? | 85%+ gross margin + near-zero CAC = exceptional economics |
Next: 04-swot-analysis.md — Strengths, Weaknesses, Opportunities, Threats