ActivationPal

How to Forecast Subscription Revenue

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:

  1. New payers = new trials × trial conversion
  2. Active subscribers = last month's active subscribers × renewal rate + new payers
  3. 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.

ColumnWhat you enter or calculateFormula
MonthThe forecast monthMonth 1, 2, 3 and on
New trialsTrials you expect to startInput
Trial conversionShare of trials that payInput
New payersFirst payments this monthNew trials × Trial conversion
Renewal rateShare of last month's subscribers who pay againInput
Active subscribersPaying subscribers this monthPrevious active subscribers × Renewal rate + New payers
Gross revenuePayments before feesActive subscribers × Price
Store fee rateThe store's cut this monthInput
Refund rateShare of payments refundedInput
Net revenueWhat you keepGross 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.

Frequently asked questions

How many months ahead should I forecast?

Forecast as far as your renewal data reaches. A monthly plan that is 6 months old gives you six months of renewal behaviour to extend. Annual plans show no renewal until month 12, so a first-year forecast for them rests on trial conversion alone.

What if my app has too few trials to measure conversion?

Use the trials you have, widen the cohort to several weeks, and run the low and high cases from the spread. A rate built on a handful of trials moves a lot with one more payer, so rely on the range, not the midpoint.

How do I forecast plans with no free trial?

Skip the conversion column. New payers become the number of people who see the paywall × the share who buy, and the rest of the sheet is unchanged. Weekly plans use the same logic with a weekly renewal rate and four to five periods per month.

Should one-time purchases go in the same forecast?

No. They do not renew, so they have no renewal rate. Forecast them as purchases per month × price × (1 − store fee) in a separate row and add them to net revenue.