To forecast subscription revenue, multiply new trials by trial-to-paid conversion, carry those payers forward with a renewal rate for each plan, and multiply by the price after the store's cut. Three measured rates drive the result. Everything else is arithmetic.
The subscription revenue forecast formula
Run these three lines once per month, in order:
- New payers = new trials × trial conversion
- Active subscribers = last month's active subscribers × renewal rate + new payers
- Net revenue = active subscribers × price × (1 − store fee)
One month with round numbers: 1,000 trials at 20% conversion is 200 new payers. If 600 subscribers were active last month and 90% renew, that is 540 renewals, so 740 active subscribers. At a $10 price that is $7,400 gross, and with a 30% store fee $5,180 net.
Shift new payers by the trial length. A 7-day trial that starts on the 28th pays in the next month, so it belongs to that month's new payers.
Get your trial conversion and renewal inputs from your own app
Start from your own numbers, not a benchmark. Once RevenueCat or Superwall is connected, ActivationPal shows trial outcomes by cohort (converted, pending and churned, with refunds) and splits revenue into new, renewal and one-time. The renewal rate you calculate yourself.
- Trial conversion: Trial outcomes by cohort shows trials started, converted, pending and churned for a start cohort, with refunds beside it. Use only cohorts whose trial length has passed, as trial conversion rate explains. A trial still pending has not failed yet.
- New versus renewal revenue: the revenue split separates new subscriptions, renewals and one-time purchases. Forecast the first two from this formula and one-time purchases on their own.
- Renewal rate: you calculate it: subscribers who renewed ÷ subscribers due to renew.
Retention by week cohort on the dashboard measures app activity. A cohort that stops opening the app is an early warning for renewals, but it is not the renewal rate.
Spreadsheet layout for a subscription revenue forecast
One row per forecast month, one column per line below. Inputs are your measured rates; every other column is a formula.
| Column | What you enter or calculate | Formula |
|---|
| Month | The forecast month | Month 1, 2, 3 and on |
| New trials | Trials you expect to start | Input |
| Trial conversion | Share of trials that pay | Input |
| New payers | First payments this month | New trials × Trial conversion |
| Renewal rate | Share of last month's subscribers who pay again | Input |
| Active subscribers | Paying subscribers this month | Previous active subscribers × Renewal rate + New payers |
| Gross revenue | Payments before fees | Active subscribers × Price |
| Store fee rate | The store's cut this month | Input |
| Refund rate | Share of payments refunded | Input |
| Net revenue | What you keep | Gross revenue × (1 − Store fee rate) × (1 − Refund rate) |
Renewal rate already contains churn. Subtracting a churn rate as well counts every cancellation twice.
Monthly vs annual plans in the forecast
Keep one block of columns per plan and add the plans at the end. They behave differently.
- Monthly plans pay every month. Each month's subscribers are the previous month's times the monthly renewal rate, plus new payers.
- Annual plans pay once at the start. The next payment arrives at month 12 and equals the payers from month 0 × the annual renewal rate. Cash lands in lumps, so forecast cash by payment month and MRR as price ÷ 12 for every active annual subscriber.
Split trial conversion by plan too, since the two plans rarely convert at the same rate. Annual vs monthly subscription covers which plan to push.
Subtract store fees and refunds
Apple's subscription page sets the rate: you receive 70% of the subscription price, minus applicable taxes, during a subscriber's first year of paid service, and 85% after one year of paid service. Members of the Small Business Program receive 85% from the start.
What that does to the sheet:
- A monthly subscriber's payments 1 to 12 use a 30% fee, payment 13 onward 15%.
- An annual subscriber's first payment uses 30%, the renewal 15%.
- Free trial days do not count toward the year, only days of paid service do.
Because the fee changes with subscriber age, a single fee rate is only right for a young app. For an older one, split active subscribers into those under and over a year of paid service and apply each rate. Take refunds from the same refund row you read the trial outcomes from.
Turn the forecast into MRR and check it
MRR is the monthly forecast row, with annual plans counted at price ÷ 12. Drop the result into the MRR calculator, or run low and high versions through the app revenue calculator.
Build three cases from the range you have observed: low, base and high for trial conversion and renewal rate. At the end of each month, replace the assumption with the actual number and re-run the sheet. If renewals fall short, the churn rate calculator shows how much of the gap is cancellations.
Monthly metrics such as ARPU and LTV are defined in subscription metrics.