Formula
For each year t from 1 to ceil(Remaining life): fraction of year = min(1, Remaining life − (t − 1)); exposure in year t = balance × (1 − (t − 0.5) ÷ Remaining life) if amortizing, otherwise the full balance.
Marginal PD in year t = survival × (1 − (1 − Annual PD)^fraction), where survival starts at 1 and is multiplied by (1 − annual PD for the year) after each year.
Loss in year t = marginal PD × Loss given default × exposure. Discounted loss = loss ÷ (1 + Effective interest rate)^(t − 0.5).
Lifetime ECL = sum of discounted losses. Undiscounted expected loss = sum of losses. Cumulative default probability = 1 − final survival. 12-month expected loss = discounted loss in year 1.
Worked examples
Example 1: default inputs, a three-year amortizing loan
Inputs: Exposure at default $500,000, Annual probability of default 6%, Loss given default 55%, Remaining life 3 years, Effective interest rate 12%, Balance amortizes evenly checked. Year 1: exposure at mid-year = 500,000 × (1 − 0.5 ÷ 3) = $416,667; survival 1.000; marginal PD = 6.00%; loss = 0.06 × 0.55 × 416,667 = $13,750; discount factor 1.12^0.5 = 1.0583; discounted = 13,750 ÷ 1.0583 = $12,993. Year 2: exposure = 500,000 × (1 − 1.5 ÷ 3) = $250,000; survival 0.94; marginal PD = 0.94 × 0.06 = 5.64%; loss = 0.0564 × 0.55 × 250,000 = $7,755; factor 1.12^1.5 = 1.1853; discounted $6,543. Year 3: exposure = 500,000 × (1 − 2.5 ÷ 3) = $83,333; survival 0.8836; marginal PD = 5.30%; loss = 0.0530 × 0.55 × 83,333 = $2,430; factor 1.12^2.5 = 1.3275; discounted $1,830. Lifetime ECL = 12,993 + 6,543 + 1,830 = $21,366. Undiscounted = 13,750 + 7,755 + 2,430 = $23,935. ECL as share of exposure = 21,366 ÷ 500,000 = 4.27%. Cumulative default probability = 1 − 0.8836 × 0.94 = 1 − 0.8306 = 16.9%. The 12-month expected loss is the first row, $12,993, which is 61 percent of the lifetime figure because amortization concentrates exposure in year one.
Example 2: a one-year high-rate advance
Inputs: exposure $100,000, annual PD 15%, LGD 60%, remaining life 1 year, effective rate 30%, amortizing. There is a single period. Exposure at mid-year = 100,000 × (1 − 0.5 ÷ 1) = $50,000. Marginal PD = 15.00%. Loss = 0.15 × 0.60 × 50,000 = $4,500. Discount factor 1.30^0.5 = 1.1402; discounted = 4,500 ÷ 1.1402 = $3,947. Lifetime ECL = 12-month ECL = $3,947, or 3.95% of the original exposure; undiscounted $4,500; cumulative default probability 15.0%. The result looks small for a 15 percent default rate because the average exposure over an evenly amortizing year is half the starting balance and the high effective rate discounts the loss further. Whether that is right depends on when defaults occur: for daily-debit products, defaults cluster early, when the balance is still high, and a funder with that experience should either uncheck the amortizing box or use a higher LGD to compensate. The undiscounted, non-amortizing loss would be 0.15 × 0.60 × 100,000 = $9,000, more than double.
Example 3: a five-year bullet exposure
Inputs: exposure $250,000, annual PD 4%, LGD 40%, remaining life 5 years, effective rate 8%, amortizing unchecked. Exposure is $250,000 in every year. Year 1: marginal PD 4.00%, loss = 0.04 × 0.40 × 250,000 = $4,000, factor 1.08^0.5 = 1.0392, discounted $3,849. Year 2: survival 0.96, marginal 3.84%, loss $3,840, factor 1.08^1.5 = 1.1224, discounted $3,421. Year 3: survival 0.9216, marginal 3.69%, loss $3,686, factor 1.2122, discounted $3,041. Year 4: survival 0.8847, marginal 3.54%, loss $3,539, factor 1.3091, discounted $2,703. Year 5: survival 0.8493, marginal 3.40%, loss $3,397, factor 1.4139, discounted $2,403. Lifetime ECL = 3,849 + 3,421 + 3,041 + 2,703 + 2,403 = $15,418, or 6.17% of exposure; undiscounted $18,463; cumulative default probability = 1 − 0.8493 × 0.96 = 18.5%. The 12-month figure, $3,849, is only a quarter of lifetime, which is the gap CECL closes: an incurred-loss or one-year allowance would hold a quarter of what the full-life view requires on a bullet loan.