What does Subscription Stacking, Dunning and Annual Plans conclude, in numbers, about “Annual Lock-In: the NPV Tipping Point of Two Free Months and the Self-Selection Correction”?
Answer: Chapter 5 solves the annual tipping point, a monthly churn of 0.0242 when money costs 0.01 a month and two months are free; annual takers lean to low churn and behave as if their churn were 0.0220, so a naive gain of 257.5 becomes -35.8, and prepayments are recognised monthly with a refund reserve.
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: -35.8, 0.0220, 0.0242, 257.5
| blended churn of the offer pool | 0.0410 |
| k takers steady share naive gain true gain full-year payers | |
| 1 | 200 0.900 366.1 159.9 0.802 |
| 2 | 310 0.871 257.5 -35.8 0.789 |
| 3 | 410 0.805 -69.5 -377.8 0.760 |
| k | 2: churn the takers behave like 0.0220 |
| k | 2: tipping churn c* from p51 0.0242 |
| months of discount per taker spent on full-year payers | 1.578 |
Show the full program
# Chapter 5. p52: who takes the annual plan, and the shifted tipping point.
# Two illustrative types: steady (monthly churn 0.015, share 0.6) and
# restless (0.08, share 0.4); r = 0.01 a month. Take-up of an annual
# plan with k free months rises with k but far more for steady types.
# The naive analysis prices every taker at the blended churn; the
# corrected one prices each taker at their own churn. Per 1,000 offers.
# Field anchor: DellaVigna and Malmendier (2006) studied 7,752 members;
# monthly-fee members paid over 70 dollars and came about 4.3 times.
import math
R = 0.01
TYPES = (("steady", 0.6, 0.015), ("restless", 0.4, 0.08))
TAKE = {1: (0.30, 0.05), 2: (0.45, 0.10), 3: (0.55, 0.20)}
def v_monthly(c, r=R, months=12):
q = (1.0 - c) / (1.0 + r)
return math.fsum(q ** t for t in range(months))
blend = math.fsum(s * c for _, s, c in TYPES)
print("blended churn of the offer pool %.4f" % blend)
print("k takers steady share naive gain true gain full-year payers")
for k in (1, 2, 3):
paid = 12 - k
takers = [1000 * s * TAKE[k][i] for i, (_, s, _) in enumerate(TYPES)]
n = math.fsum(takers)
naive = n * (paid - v_monthly(blend))
true = math.fsum(t * (paid - v_monthly(c))
for t, (_, _, c) in zip(takers, TYPES))
stayers = math.fsum(t * (1 - c) ** 11
for t, (_, _, c) in zip(takers, TYPES))
print("%d %6.0f %12.3f %10.1f %9.1f %16.3f" % (
k, n, takers[0] / n, naive, true, stayers / n))
k = 2
takers = [1000 * s * TAKE[k][i] for i, (_, s, _) in enumerate(TYPES)]
pool_v = math.fsum(t * v_monthly(c) for t, (_, _, c) in
zip(takers, TYPES)) / math.fsum(takers)
lo, hi = 0.0, 0.5
for _ in range(80):
mid = (lo + hi) / 2.0
if v_monthly(mid) > pool_v:
lo = mid
else:
hi = mid
print("k = 2: churn the takers behave like %.4f" % lo)
print("k = 2: tipping churn c* from p51 0.0242")
print("months of discount per taker spent on full-year payers %.3f" % (
2.0 * math.fsum(t * (1 - c) ** 11 for t, (_, _, c) in
zip(takers, TYPES)) / math.fsum(takers)))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 5: Annual Lock-In: the NPV Tipping Point of Two Free Months and the Self-Selection Correction. 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 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