Computing DERL for the sBG Model Using Excel
This note shows how to evaluate an expression for a customer's discounted expected residual lifetime (DERL) using a simple Excel worksheet (under the assumption that contract duration is characterized by the shifted-beta-geometric (sBG) distribution).
Note [PDF (82k)]
Excel spreadsheet [XLS (126k)]