Why Your SaaS Revenue Model Leaks — And How to Fix It
Most early-stage startups model revenue as a flat line: "We have X customers paying $Y/month." That works for napkin math, but it misses the single biggest driver of MRR growth — the interaction between price tiers and churn.
Here's a concrete example from a real founder I advised:
"We had 200 customers on $29/mo (Starter) and 50 on $299/mo (Business). Our 'average' MRR was $78K. When I built a waterfall, I discovered Starter tier contributed only 18% of net revenue after churn. Business tier was 62%."
That's the power of the waterfall method: it reveals which tiers are actually profitable.
The 4-Step Waterfall Framework
Step 1: Define Your Pricing Tiers
List every tier, its monthly price, customer count, and monthly churn rate. Be honest — include your free tier as a feeder mechanism.
Step 2: Calculate Gross Revenue Per Tier
Simple: Price × Customer Count. But this number is misleading — churn eats into it.
Step 3: Apply Churn Adjustment
Gross Revenue × (1 - Monthly Churn Rate) = Net Stable Revenue.
This is what you can actually spend on operations.
Step 4: Build the Waterfall Chart
Stack your tiers from highest contribution margin to lowest. The visual reveal is almost always: one or two tiers carry the entire business.
The Free Template
I built a Google Sheets template that does all the math for you — just plug in your tiers and customer counts:
👉 Revenue Waterfall Calculator — Google Sheets
It includes pre-built VLOOKUP formulas, churn-adjusted math, and a 12-month projection sheet. Grab it free or pay-what-you-want.
Key Takeaway
Don't manage revenue as an average. Break it down by tier. The insight you'll get — "this tier actually loses money" or "that tier should be 3x more expensive" — is worth 10x the spreadsheet cost.
Tags: googlesheets, excel, finance, investing, saas
Top comments (0)