What does Subscription Stacking, Dunning and Annual Plans conclude, in numbers, about “The Bathtub Steady State: New Sign-ups Set the Slope, Churn Sets the Ceiling”?

Answer: Chapters 1 to 3 show that steady-state revenue equals monthly sign-ups times revenue per subscriber divided by monthly churn, so sign-ups set the slope and churn sets the ceiling; that with heterogeneous subscribers aggregate retention rises with age and the shifted-beta-geometric model projects it from a few months of cohort data; that the first two renewals are a sieve where each intervention returns 1.40 times as much as later, while the three-year gain lies in the tail, 18,598 against 4,760 with illustrative parameters; and that a subscription layer stands only when must-have uses clearly exceed the value threshold.

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 only

churn ceiling MRR MRR@12 share@12 half-life t90 carried-in
0.03333,333 102,053 0.306 22.8 mo 76 0.97
0.05200,000 91,928 0.460 13.5 mo 45 0.95
0.08125,000 79,042 0.632 8.3 mo 28 0.92
0.1283,333 65,361 0.784 5.4 mo 19 0.88
lever at c0.08 MRR@12 MRR@24 MRR@60 ceiling adds@60
base79,042 108,103 124,160 125,000 12,000
double new158,083 216,205 248,320 250,000 24,000
halve churn96,823 156,147 228,412 250,000 12,000
Show the full program
# Chapter 1. p11: bathtub steady state of MRR and how fast it is reached.
# Difference equation S[t+1] = S[t] * (1 - c) + N, MRR = S * ARPU.
# Illustrative parameters only: N = 200 new subscribers a month,
# ARPU = 50 units, base starts empty. No real customer data.
import math

N, ARPU = 200, 50.0


def path(n_new, c, months):
    s, out = 0.0, []
    for _ in range(months):
        s = s * (1.0 - c) + n_new
        out.append(s)
    return out


def t_share(c, share):
    return math.ceil(math.log(1.0 - share) / math.log(1.0 - c))


print("churn  ceiling MRR   MRR@12   share@12  half-life  t90  carried-in")
for c in (0.03, 0.05, 0.08, 0.12):
    p = path(N, c, 240)
    ceil = N * ARPU / c
    m12 = p[11] * ARPU
    half = math.log(0.5) / math.log(1.0 - c)
    print("%5.2f  %11s %8s  %8.3f  %7.1f mo  %3d  %9.2f" % (
        c, "{:,.0f}".format(ceil), "{:,.0f}".format(m12), m12 / ceil,
        half, t_share(c, 0.9), 1.0 - c))
print()
print("lever at c = 0.08      MRR@12   MRR@24   MRR@60  ceiling  adds@60")
base = 0.08
for name, n_new, c in (("base", N, base), ("double new", 2 * N, base),
                       ("halve churn", N, base / 2)):
    p = path(n_new, c, 60)
    adds = n_new * 60
    print("%-18s %10s %8s %8s %8s %8s" % (
        name, "{:,.0f}".format(p[11] * ARPU), "{:,.0f}".format(p[23] * ARPU),
        "{:,.0f}".format(p[59] * ARPU), "{:,.0f}".format(n_new * ARPU / c),
        "{:,}".format(adds)))

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 1: The Bathtub Steady State: New Sign-ups Set the Slope, Churn Sets the Ceiling. 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