12-Month Revenue Forecast Calculator

Compounding is the most important concept in studio finance

A studio that grows 4% per month while churning 3% is growing. But the margin between those two numbers compounds. Over 12 months, the difference between 4% growth / 3% churn and 4% growth / 5% churn is not a straight-line gap — it widens every month as the member base diverges.

The calculator above makes that compounding visible. Enter your starting membership, your revenue per member, your growth and churn assumptions, and your additional monthly revenue. The table shows you exactly where you land in month 12 — and whether you're growing, flat, or shrinking before you've made a single decision.

How to use the forecast as a planning tool

The forecast is most useful as a sensitivity tool, not a prediction. Run three scenarios:

• Base case: your honest best-guess growth and churn rates
• Bear case: half the growth, 20% more churn
• Bull case: 1.5× the growth, 20% less churn

The range between bear and bull at month 12 is your planning envelope. If even the bear case cash-flows your fixed costs, you have a resilient business. If the base case barely covers overhead, you have a leverage problem that marketing alone won't solve.

Three things that move the forecast more than marketing spend

1. Churn reduction. Cutting churn from 5% to 3% per month has a larger compounding effect on month-12 revenue than increasing growth from 4% to 6%. This counterintuitive result shows up clearly in the table when you adjust the churn input down. Retention is cheaper than acquisition and compounds faster — it should get at least as much attention as your marketing budget.

2. Revenue per member. An additional $20 per member per month (through a price increase, a pack upsell, or a premium tier) increases every row in the table proportionally. Unlike growth rate or churn, revenue per member is a lever you can pull today without acquiring a single new member.

3. Additional revenue diversification. The additional revenue field matters most at low member counts, where it represents a meaningful fraction of total revenue. A studio with 80 members generating $1,800/month in packs and drop-ins has 15% revenue diversification away from the membership base — that's meaningful downside protection during slow growth months.

The floor the forecast doesn't show

This model assumes all members pay on time. In practice, 2–4% of MRR is in failed payments at any given moment in studios without automated recovery. If your billing platform doesn't retry failed charges automatically, your actual revenue will trail this forecast consistently. That's a recoverable gap — but only if you track it.

For a live view of these metrics in your actual studio, see our guide to studio financial dashboards and how to use predictive churn analysis to identify at-risk members before they cancel.