How to model saas-specific financial projections

The most important part of a SaaS financial model is the Monthly Recurring Revenue (MRR) build-up. Unlike traditional retail, where you start at zero every month, SaaS revenue compounds. Your model must demonstrate how new sign-ups, cancellations (churn), and upgrades interact over a 12 to 36-month period to determine your "runway"—the amount of time you have before your business runs out of cash.

The Core Metrics

To build an accurate forecast, you need to understand five key pillars that define the health of a software business:

• MRR (Monthly Recurring Revenue): The total predictable revenue you earn from all active subscriptions each month.
• ARR (Annual Recurring Revenue): Your MRR multiplied by 12. This is the figure most UK investors use to value your company.
• Churn Rate: The percentage of customers who cancel their subscription each month. A high churn rate is a "leaky bucket" that can prevent your business from growing regardless of how many new customers you sign up.
• CAC (Customer Acquisition Cost): The total spend on marketing and sales divided by the number of new customers acquired.
• LTV (Lifetime Value): The total revenue a customer is expected to pay you before they churn.

Step-by-Step Forecasting

1. Map your Revenue Tiers: Create a table showing your different subscription levels. Forecast how many users will join each tier month-by-month. Be realistic about your growth curve; most SaaS businesses see a "J-curve" where growth starts slow and accelerates later.
2. Factor in Churn: Always subtract a percentage of your total customers every month. For early-stage startups, a 5-10% monthly churn is common. As you improve the product, you should aim to get this below 3%.
3. Calculate your CAC: Estimate your marketing budget, including digital ads and content costs. Ensure your model reflects that as you scale, finding new customers often becomes more expensive.
4. List Operating Expenses (OpEx): Don't forget the costs of running the software. This includes cloud hosting (like AWS or Azure), third-party API fees, and your own salary.

The "Golden Ratio"

In the SaaS world, health is often measured by the LTV to CAC ratio. A healthy business should aim for an LTV that is at least 3 times its CAC (3:1). If your ratio is 1:1, you are essentially "buying" revenue at no profit. If it is 5:1, you are likely under-spending on marketing and could afford to grow faster.

Pro Tip: Be conservative with your "Trial to Paid" conversion rates. Many founders assume 50% of trial users will eventually pay, but 10-15% is a much safer baseline for a new product until you have real-world data.