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 pool0.0410
k takers steady share naive gain true gain full-year payers
1200 0.900 366.1 159.9 0.802
2310 0.871 257.5 -35.8 0.789
3410 0.805 -69.5 -377.8 0.760
k2: churn the takers behave like 0.0220
k2: tipping churn c* from p51 0.0242
months of discount per taker spent on full-year payers1.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