What does Subscription Stacking, Dunning and Annual Plans conclude, in numbers, about “Actuarial Tools and Execution Checklist: the Monthly Subscription Cash Ledger, the Calculator and Pre-Registered Tests”?
Answer: The ledger has one row per month and one sheet per subscription layer; it separates voluntary from passive churn, classifies failures into four reasons, and keeps annual plans and deferred revenue on lines of their own. The calculator turns the ledger into a steady-state ceiling, recovery by reason, next month's retry days, the annual tipping point and alerts; on the demonstration ledger the ceiling is 251,440 units and two alerts light up. The execution checklist fixes actions by day, week, month and quarter. The pre-registered tests give sample sizes: 356 failures per arm for the retry schedule, 691 subscribers per arm for the first renewal, and a cohort of 680 newcomers for the test of rising retention.
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: 356, 680, 691
| test | p1 | p2 | n per arm |
| H1 retry schedule | 0.600 | 0.700 | 356 |
| H2 first renewal | 0.650 | 0.720 | 691 |
| H3 renewal 6 vs 1 | 0.847 | 0.917 | 333 |
| H3 cohort size so month-5 survivors reach n | 680 | ||
| H1 simulated power at n = 356 per arm | 0.797 |
Show the full program
# Chapter 8. p82: pre-registered tests and their sample sizes.
# Two-sided alpha 0.05, power 0.80, two-proportion normal approximation:
# n per arm = (z_a * sqrt(2 pbar qbar) + z_b * sqrt(p1 q1 + p2 q2))^2
# / (p1 - p2)^2
# H1 retry schedule: recovery of insufficient-funds failures 0.60 -> 0.70.
# H2 carved layer: first-renewal rate 0.65 -> 0.72 after a usage nudge.
# H3 heterogeneity: retention in renewal 6 (0.917) above renewal 1
# (0.847), the sBG values of p21; cohort size needed so that month-5
# survivors (0.490 of the cohort by p21) reach the n of the test.
# The H1 size is checked by a fixed-seed simulation of 2,000 trials.
import math
import random
import statistics
Z = statistics.NormalDist()
ZA, ZB = Z.inv_cdf(0.975), Z.inv_cdf(0.80)
def n_per_arm(p1, p2):
pbar = (p1 + p2) / 2.0
top = ZA * math.sqrt(2 * pbar * (1 - pbar)) + \
ZB * math.sqrt(p1 * (1 - p1) + p2 * (1 - p2))
return math.ceil(top ** 2 / (p1 - p2) ** 2)
rng = random.Random(20261120)
print("test p1 p2 n per arm")
for name, p1, p2 in (("H1 retry schedule", 0.60, 0.70),
("H2 first renewal", 0.65, 0.72),
("H3 renewal 6 vs 1", 0.847, 0.917)):
print("%-26s %6.3f %6.3f %9s" % (name, p1, p2,
"{:,}".format(n_per_arm(p1, p2))))
n3 = n_per_arm(0.847, 0.917)
print("H3 cohort size so month-5 survivors reach n %s" % "{:,}".format(
math.ceil(n3 / 0.490)))
n1 = n_per_arm(0.60, 0.70)
hits = 0
for _ in range(2000):
a = 0
b = 0
for _ in range(n1):
a += rng.random() < 0.60
b += rng.random() < 0.70
pa, pb = a / n1, b / n1
pool = (a + b) / (2.0 * n1)
se = math.sqrt(pool * (1 - pool) * 2.0 / n1)
if abs(pb - pa) / se > ZA:
hits += 1
print("H1 simulated power at n = %d per arm %.3f" % (n1, hits / 2000))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 8: Actuarial Tools and Execution Checklist: the Monthly Subscription Cash Ledger, the Calculator and Pre-Registered Tests. 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 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