What does Loyalty-Point Liabilities and Breakage conclude, in numbers, about “Closing the Loop: a Monthly Loyalty-Liability Report, the Loyalty Liability Actuary and a Pre-Registered Test”?
Answer: Chapter 8 gives a monthly loyalty-liability report, the distilled Loyalty Liability Actuary and a pre-registered test, and states plainly that scheme rules must not use hidden expiry terms to create breakage and that members should be told before points lapse. The book contains 21 runnable Python programs.
Scope of the numbers: Parameters are illustrative and all calculations are generated by the book's programs; this is not individualised accounting, tax or legal advice, and a practising accountant's opinion prevails. Chapter 1 reworks the allocation and the cumulative catch-up with the numbers of the standard's illustrative example.
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
POINTS open 15,200,000 +issued 1,010,000
-redeemed 760,000 -expired 190,000
close 15,260,000
LIABILITY open 107,000 +deferred 7,065
-face 5,316 -breakage 2,278 close 106,470
BREAKAGE booked 0.300 matured 0.287 95% [0.270, 0.306]
RESERVE ratio 0.374 boundary 0.271
INFLATION issue growth 0.122 redeem growth 0.027
NOTICE expiring lots notified 1.000
FLAGS issuance outrunning redemptionsShow the full program
# Chapter 8. p81: a monthly loyalty-points liability report.
# Every input below is illustrative. Sections: points roll-forward,
# contract liability roll-forward (deferral per expected point, split
# into face and breakage release), breakage estimate from matured lots
# with a Wilson interval, reserve against the run boundary of p52, an
# inflation check (issuance growth vs redemption growth over three
# months) and the share of expiring lots that got advance notice.
import math
from statistics import NormalDist
Z = NormalDist().inv_cdf(0.975)
OPEN_PTS, ISSUED, REDEEMED, EXPIRED = 15200000, 1010000, 760000, 190000
OPEN_LIAB, PRICE_PER_PT, B_BOOK, VALUE = 107000.0, 10.0, 0.30, 0.01
MATURED, MATURED_LAPSED = 2400, 690
RESERVE, COST, RHO_STAR = 24000.0, 0.006, 0.271
ISSUE_3M, REDEEM_3M = (0.9e6, 0.95e6, 1.01e6), (0.74e6, 0.75e6, 0.76e6)
EXPIRING, NOTIFIED = 5200, 5200
def wilson(x, n):
p = x / n
den = 1 + Z * Z / n
mid = (p + Z * Z / (2 * n)) / den
half = Z * math.sqrt(p * (1 - p) / n + Z * Z / (4 * n * n)) / den
return mid - half, mid + half
if __name__ == "__main__":
close_pts = OPEN_PTS + ISSUED - REDEEMED - EXPIRED
r = 1 - B_BOOK
d_issued = PRICE_PER_PT * r * VALUE / (PRICE_PER_PT + r * VALUE)
new = ISSUED * d_issued
face = REDEEMED * d_issued
brk = REDEEMED * d_issued * (1 / r - 1)
close = math.fsum([OPEN_LIAB, new, -face, -brk])
lo, hi = wilson(MATURED_LAPSED, MATURED)
full = COST * close_pts * r
g_i = ISSUE_3M[-1] / ISSUE_3M[0] - 1
g_r = REDEEM_3M[-1] / REDEEM_3M[0] - 1
print("POINTS open {:>10,} +issued {:>9,}".format(OPEN_PTS, ISSUED))
print(" -redeemed {:>9,} -expired {:>9,}".format(
REDEEMED, EXPIRED))
print(" close {:>10,}".format(close_pts))
print("LIABILITY open {:9,.0f} +deferred {:8,.0f}".format(
OPEN_LIAB, new))
print(" -face {:8,.0f} -breakage {:8,.0f} close {:9,.0f}"
.format(face, brk, close))
print("BREAKAGE booked {:.3f} matured {:.3f} 95% [{:.3f}, {:.3f}]"
.format(B_BOOK, MATURED_LAPSED / MATURED, lo, hi))
print("RESERVE ratio {:.3f} boundary {:.3f}".format(
RESERVE / full, RHO_STAR))
print("INFLATION issue growth {:.3f} redeem growth {:.3f}".format(
g_i, g_r))
print("NOTICE expiring lots notified {:.3f}".format(
NOTIFIED / EXPIRING))
flags = []
if not lo <= B_BOOK <= hi:
flags.append("booked breakage outside interval")
if RESERVE / full < RHO_STAR:
flags.append("reserve below run boundary")
if g_i > g_r + 0.02:
flags.append("issuance outrunning redemptions")
if NOTIFIED < EXPIRING:
flags.append("expiry notice incomplete")
print("FLAGS " + ("; ".join(flags) if flags else "none"))Single source and citation
Fan, Y. (2026). Loyalty-Point Liabilities and Breakage Actuarial Science: Issuance, Redemption Rates and the Insolvency Boundary of Deferred Revenue (Version 1.0.0), Chapter 8: Closing the Loop: a Monthly Loyalty-Liability Report, the Loyalty Liability Actuary and a Pre-Registered Test. 5D Library. DOI pending
DOI pending · monograph page goes live after publication · 5DL-B-315 · v1.0.0 · CC-BY-NC-ND-4.0
BibTeX
@book{fan2026315,
author = {Fan, Yafu},
title = {Loyalty-Point Liabilities and Breakage Actuarial Science: Issuance, Redemption Rates and the Insolvency Boundary of Deferred Revenue},
year = {2026},
publisher = {5D Library},
edition = {1.0.0},
note = {DOI pending}
}Other chapter answers in this book
- Chapter 1 · Issuing Points Creates a Liability: Material Rights, Stand-Alone Selling Prices and the Cumulative Catch-Up
- Chapter 2 · Redemption Survival Curves: Censoring, the Product-Limit Estimator and Extrapolation to Expiry
- Chapter 3 · Estimating Expected Breakage: Matured Cohorts, Point Weighting and the Reversal Constraint
- Chapter 4 · Present Value and Expiry Terms: Discounted Fulfilment Cost, the Expiry Horizon and Advance Notice
- Chapter 5 · Points Inflation and Redemption Runs: Issuance Speed, Expected Devaluation and the Two-Month Window
- Chapter 6 · The Insolvency Boundary: Reserve-to-Liability Ratios, Dependence on Breakage and a Two-Dimensional Stress Map
- Chapter 7 · Sources East and West: Flying Cash in Chang'an and Receipts in Amsterdam