Demo company: Anytown Comfort Co. Sample values, not benchmarks. Replace every number with your own.
Every year, the base moves toward new members per year ÷ the share who leave. Today's size only sets where it starts. Renewal rate sets where it ends up.
Each row raises the renewal rate by that many points, with the program cost and everything else held the same. The highlighted row matches your slider.
End-of-year members, and added gross profit for that year after the program's cost.
These are estimates from simple assumptions, not a forecast. New-member sales are held flat, and members who stay are assumed to buy at today's rate.
It doesn't promise that any program moves renewals by a set number of points. The question it answers is narrower: if you can move them, what is that worth, and how much can you spend to get there?
It also leaves out referrals from members who stay, the lower cost of serving a home you already know, and pricing power when members can see what they pay for. All three usually push the real number higher.
Value at sale treats the final year's added profit as added EBITDA and applies your multiple. Use your own deal math for anything formal.