I used to avoid thinking about unit economics. Not because I didn't care — I cared deeply — but because every financial modeling tutorial I found assumed you had a CFO, a spreadsheet team, and three hours of free time. I had none of those things.
Then I spent one afternoon building a proper financial model for my SaaS using AI as a thinking partner. It changed how I made product and pricing decisions. Here's exactly what I did and how you can replicate it.
Why Solopreneurs Skip the Financial Model (And Why That's Dangerous)
Most indie developers I know operate on vibes and bank balance. You know roughly how many subscribers you have, you have a vague sense of churn, and you make pricing decisions based on gut feeling. That worked fine at zero revenue. It starts breaking down the moment you're trying to decide whether to hire a contractor, raise prices, or build a new feature.
The dangerous part isn't ignorance — it's false confidence. You might think you're profitable when you're actually in a slow-burn death spiral where churn is quietly eating your growth. I've seen solopreneurs with 200 paying users who were effectively standing still because their monthly churn rate was 5%.
A financial model doesn't need to be fancy. It needs to answer three questions: Where am I right now? When do I break even? What happens to my business if I change one variable?
Start With MRR and the Numbers You Actually Know
Monthly Recurring Revenue is your foundation. If you're charging $49/month and you have 87 active subscribers, your MRR is $4,263. Simple.
What most people skip is separating MRR into its components:
- New MRR: revenue from new customers this month
- Expansion MRR: upgrades, upsells
- Churned MRR: revenue lost from cancellations
- Net New MRR: the combination that tells you if you're growing
When I sat down with Claude to build my model, the first prompt I used was: "I have 87 paying customers at $49/month. Last month I added 12 new customers and lost 5. Break down my MRR movement and tell me what my monthly churn rate is."
The response gave me a 5.7% monthly churn rate. That sounds manageable until you annualize it — that's roughly 50% of your customer base leaving every year. That single calculation changed how urgently I thought about retention.
Calculating LTV and CAC Without an MBA
LTV (Lifetime Value) and CAC (Customer Acquisition Cost) are the unit economics that determine whether your business is viable, not just alive.
LTV formula for SaaS: Average Revenue Per User ÷ Monthly Churn Rate
With my $49 ARPU and 5.7% churn: LTV = $49 ÷ 0.057 = $860 per customer.
CAC depends on your acquisition channel. If you're spending $200/month on ads and content tools and bringing in 4 customers from that spend, your blended CAC is $50. That gives you an LTV:CAC ratio of 17:1, which is healthy.
But here's where it gets interesting. I asked the AI to model what happens at different churn rates:
| Monthly Churn | LTV | LTV:CAC (at $50 CAC) |
|---|---|---|
| 3% | $1,633 | 32:1 |
| 5.7% | $860 | 17:1 |
| 8% | $612 | 12:1 |
| 12% | $408 | 8:1 |
Below 3:1 LTV:CAC, most businesses are unsustainable. The table made it viscerally clear: churn isn't just a retention problem, it's a fundamental threat to unit economics. Reducing churn from 5.7% to 3% nearly doubles the value of every customer I acquire.
Building a Breakeven Analysis in Plain Language
Breakeven is where your MRR covers your fixed monthly costs. For a solo SaaS, that usually means: hosting, software subscriptions, your own salary expectation, and any contractors.
My monthly costs at the time:
- Hetzner VPS + Cloudflare: €45
- SaaS tools (Loops, Lemon Squeezy, etc.): €80
- My own minimum viable salary: €2,500
- Total: ~€2,625/month
Breakeven customer count = Total Fixed Costs ÷ ARPU = 2,625 ÷ 49 = 54 customers
I had 87. So I was past breakeven — but only barely, and only because I was undervaluing my time.
The follow-up question I gave the AI: "If I want to pay myself €4,000/month instead of €2,500, how many customers do I need and how long will it take to get there at my current net growth rate?"
That produced a growth projection I could actually use. At 7 net new customers per month (12 new minus 5 churned), I was 20 customers short of the new target. That meant roughly 3 months to hit it — assuming churn stayed constant. The model showed that if churn crept up even 2%, the timeline extended to 5+ months.
Using AI to Stress-Test Scenarios
The real power of building your model with AI isn't the calculations — it's the speed at which you can test scenarios. I ran six different pricing and growth scenarios in about 40 minutes.
A few that changed my thinking:
Scenario 1: Raise price to $69 for new customers only. Even with 20% lower conversion, net MRR growth was higher because LTV jumped to $1,210 at the same churn rate.
Scenario 2: Add a $9/month tier. This one looked attractive on paper but the AI pointed out that if even 30% of existing customers downgraded, it would wipe out any new revenue gained from conversion improvements.
Scenario 3: Spend €300/month on acquisition. At my CAC, that's 6 additional customers per month — enough to accelerate breakeven on the new salary target by 6 weeks. The math made the decision easy.
None of these required a spreadsheet wizard. I described each scenario in plain language, the AI modeled it, and I made decisions.
What Your Financial Model Should Actually Look Like
You don't need 40 tabs. A practical indie SaaS financial model has five components:
- MRR dashboard — current MRR broken into new, churned, and net
- Unit economics sheet — ARPU, churn rate, LTV, CAC, LTV:CAC ratio
- Breakeven calculator — fixed costs vs. customer count
- Growth projection — 12-month forecast at current and improved churn
- Scenario table — 3-4 pricing or acquisition scenarios side by side
Start with actual numbers. Feed them to an AI. Ask it to help you build each section. Ask follow-up questions. The whole thing should take you an afternoon, not a week.
The constraint isn't time or spreadsheet skill. It's knowing which questions to ask in the right order — and that's exactly what a good financial model prompt guide helps you with.
If you want to shortcut the learning curve, I've put together a step-by-step resource that walks through the exact prompts and model structure I used: AI Build Financial Model: Stop Leaving Money Behind. It's built for indie developers and solopreneurs who want a real model without the corporate overhead — 12€, no fluff.
Your numbers deserve more than a gut check.