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
| month | retention r(t) | survival S(t) | closed form | constant-churn S |
|---|---|---|---|---|
| 1 | 0.847 | 0.847 | 0.847 | 0.847 |
| 2 | 0.870 | 0.737 | 0.737 | 0.718 |
| 3 | 0.886 | 0.653 | 0.653 | 0.609 |
| 4 | 0.899 | 0.587 | 0.587 | 0.516 |
| 6 | 0.917 | 0.490 | 0.490 | 0.370 |
| 12 | 0.947 | 0.330 | 0.330 | 0.137 |
| 24 | 0.969 | 0.204 | 0.204 | 0.019 |
| 36 | 0.978 | 0.149 | 0.149 | 0.003 |
| first-month churn a/(a+b) | 0.153 | |||
| lost by month 2 / lost by month 24 | 0.331 | |||
| survival at 24: sBG / constant churn | 10.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
- Chapter 1 · The Bathtub Steady State: New Sign-ups Set the Slope, Churn Sets the Ceiling
- Chapter 3 · Carving Out a Subscription Layer: the Ratio of Must-Have Use to the Billing Period
- Chapter 4 · Failed Charges: Decline Reasons and Retry Schedules for Involuntary Churn
- Chapter 5 · Annual Lock-In: the NPV Tipping Point of Two Free Months and the Self-Selection Correction
- Chapter 6 · Whom to Retain and Transparent Renewal: Risk times Recoverability, and Revenue That Does Not Rest on Inattention
- Chapter 7 · Classical Sources East and West: Steady Livelihood and Steady Heart, Granaries, Breeding Money and the Ant's Store
- Chapter 8 · Actuarial Tools and Execution Checklist: the Monthly Subscription Cash Ledger, the Calculator and Pre-Registered Tests