What does Subscription Stacking, Dunning and Annual Plans conclude, in numbers, about “Stacking Cohorts: the Shifted-Beta-Geometric Model and the First Two Renewals”?

Answer: Retention in the first period is 0.847, which means first-month churn of 0.153. Every later period is steadier than the one before: 0.870 in the second, 0.917 in the sixth, 0.947 in the twelfth, 0.969 in the twenty-fourth and 0.978 in the thirty-sixth. The surviving share falls from 0.847 to 0.330 at month twelve and 0.204 at month twenty-four. The running product and the closed form agree to three decimals at every horizon.

Scope of the numbers: Its subscriber counts, prices, churn, recovery and discount rates are illustrative, all calculations are generated by its programs, and none corresponds to a real customer or transaction. It is not legal, accounting, tax or investment advice and promises no level of income; "steady" means only that revenue can be anticipated, with premises and failure conditions stated.

中文版

Data table

The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 0.153, 0.204, 0.330, 0.847, 0.870, 0.917

monthretention r(t)survival S(t)closed formconstant-churn S
10.8470.8470.8470.847
20.8700.7370.7370.718
30.8860.6530.6530.609
40.8990.5870.5870.516
60.9170.4900.4900.370
120.9470.3300.3300.137
240.9690.2040.2040.019
360.9780.1490.1490.003
first-month churn a/(a+b)0.153
lost by month 2 / lost by month 240.331
survival at 24: sBG / constant churn10.8 x
Show the full program
# Chapter 2. p21: shifted-beta-geometric (sBG) retention and survival.
# Each customer churns with a constant monthly probability theta, and
# theta ~ Beta(a, b) across customers (Fader and Hardie 2007 form).
# r(t) = (b + t - 1) / (a + b + t - 1);  S(t) = B(a, b + t) / B(a, b).
# a = 0.90, b = 5.00 are illustrative, not fitted to any real base.
import math

A, B = 0.90, 5.00


def lbeta(x, y):
    return math.lgamma(x) + math.lgamma(y) - math.lgamma(x + y)


def surv_closed(t):
    return math.exp(lbeta(A, B + t) - lbeta(A, B))


def retention(t):
    return (B + t - 1.0) / (A + B + t - 1.0)


s, rows = 1.0, {}
for t in range(1, 37):
    s *= retention(t)
    rows[t] = s
churn1 = A / (A + B)
print("month  retention r(t)  survival S(t)  closed form  constant-churn S")
for t in (1, 2, 3, 4, 6, 12, 24, 36):
    print("%5d  %14.3f  %13.3f  %11.3f  %16.3f" % (
        t, retention(t), rows[t], surv_closed(t), (1.0 - churn1) ** t))
lost2 = 1.0 - rows[2]
lost24 = 1.0 - rows[24]
print("first-month churn a/(a+b)                    %.3f" % churn1)
print("lost by month 2 / lost by month 24           %.3f" % (lost2 / lost24))
print("survival at 24: sBG / constant churn        %.1f x" % (
    rows[24] / (1.0 - churn1) ** 24))

Single source and citation

Fan, Y. (2026). Stacking Monthly Recurring Revenue, Involuntary-Churn Dunning Recovery and Upfront Annual Cash Lock-In (Version 1.0.0), Chapter 2: Stacking Cohorts: the Shifted-Beta-Geometric Model and the First Two Renewals. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-367 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026367,
  author    = {Fan, Yafu},
  title     = {Stacking Monthly Recurring Revenue, Involuntary-Churn Dunning Recovery and Upfront Annual Cash Lock-In},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book