Financial institutions schedules · in 1 model

Allowance for expected credit losses on a lifetime basis

Loss still to come, reserve build, the provision.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: allowance for expected credit losses on a lifetime basis.Updated 11 November 2026

What it does

Under a lifetime approach, the allowance holds every loss still expected on the loans on the book, not the losses of the next year. Each vintage carries the part of its lifetime loss that its age has not yet charged off, scaled by the lender’s outlook at the balance sheet date. The provision in the income statement is charge-offs plus the change in the allowance. Two things follow. The whole expected loss of a loan is charged in the year it is made, so a growing lender provides more than it charges off; and a worse outlook is charged at once on the whole book, before the losses arrive, which is why provisions jump at the start of a downturn and fall before it ends.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Consumer lending model: loan vintages
  • Allowance, rows 6–8: After the year of origination, % of principal originated, After one year on, % of principal originated, After two years on, % of principal originated
  • Allowance, rows 11–13: Loss still to come on the book, base loss curve, Outlook, % of the base loss curve, Allowance required
  • Allowance, rows 16–21: Opening allowance, Provision for credit losses, Charge-offs, net of recoveries, Closing allowance…
  • Allowance, rows 24–26: Lifetime loss booked on the year’s originations, Older vintages: losses off the curve and a changed outlook, Check: provision - (originations + older vintages)
  • Allowance, rows 29–31: Allowance, % of receivables, Provision, % of average receivables, Provision, % of originations

What a reviewer looks for

  • The provision set equal to charge-offs, with no allowance to build as the book grows.
  • An allowance held at a fixed share of receivables while the mix of young and seasoned vintages changes.
  • Charge-offs taken through the income statement as well as against the allowance, counting the loss twice.

Learn it, then build it

Vocabulary: Charge-Off, Loss Given Default (LGD).

Other financial institutions schedules