Forecasting Revenue for Subscription Businesses

Why Subscription Revenue Forecasting Is Different

Subscription-based businesses have fundamentally different revenue dynamics. Revenue is recurring and compounds over time. Customer retention matters as much as acquisition. Small changes in churn rates can have enormous long-term financial impacts.

These characteristics require specialized forecasting approaches that capture the mechanics of recurring revenue.

The Building Blocks of Subscription Revenue

Monthly Recurring Revenue (MRR)

MRR is the foundation of subscription forecasting. It represents the predictable revenue you expect each month from active subscriptions. This is your baseline that everything else builds upon or subtracts from.

Components of MRR Change

Each month, your MRR changes based on four factors that interact to determine your total revenue trajectory:

MRR Component	Source	Healthy Benchmark
New MRR	First-time subscribers	Growing month over month
Expansion MRR	Upgrades and add-ons	2-5% of existing MRR monthly
Churned MRR	Cancellations	Under 5% monthly
Contraction MRR	Downgrades	Under 1% monthly

The MRR Waterfall Model

The most effective framework for subscription forecasting is the MRR waterfall:

Ending MRR = Starting MRR + New MRR + Expansion MRR - Churned MRR - Contraction MRR

Net new MRR: The sum of new and expansion MRR minus churn and contraction. When positive, your business is growing.
Quick ratio: New and expansion MRR divided by churned and contracted MRR. A ratio above 4 indicates healthy, sustainable growth.

Cohort-Based Revenue Projection

For more accurate long-term forecasts, model revenue by customer cohort. Group customers by the month they subscribed and track their retention and expansion patterns over time. Apply cohort-specific retention curves rather than using a single average churn rate.

This captures the reality that churn is typically highest in the first few months and decreases for customers who stay longer.

Forecasting Annual Contracts

If your business sells annual subscriptions, your model needs to account for the timing difference between cash received upfront and revenue recognized monthly. Track renewal dates and model expected renewal rates based on historical data.

Putting Subscription Forecasting Together

Build your forecast by starting with current MRR, projecting each component of the waterfall forward, and summing to get total projected revenue. Finntree can help by analyzing your actual revenue patterns from bank statement data, identifying trends in customer payments.

Key Takeaway: The key to subscription revenue forecasting is granularity. The more precisely you model each MRR component, the more accurate your overall projection will be and the better equipped you will be to pull the right growth levers.