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.03 | 333,333 102,053 0.306 22.8 mo 76 0.97 |
| 0.05 | 200,000 91,928 0.460 13.5 mo 45 0.95 |
| 0.08 | 125,000 79,042 0.632 8.3 mo 28 0.92 |
| 0.12 | 83,333 65,361 0.784 5.4 mo 19 0.88 |
| lever at c | 0.08 MRR@12 MRR@24 MRR@60 ceiling adds@60 |
| base | 79,042 108,103 124,160 125,000 12,000 |
| double new | 158,083 216,205 248,320 250,000 24,000 |
| halve churn | 96,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
- Chapter 2 · Stacking Cohorts: the Shifted-Beta-Geometric Model and the First Two Renewals
- 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