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

testp1p2n per arm
H1 retry schedule0.6000.700356
H2 first renewal0.6500.720691
H3 renewal 6 vs 10.8470.917333
H3 cohort size so month-5 survivors reach n680
H1 simulated power at n = 356 per arm0.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