Formula
Expected loss for a tier = Tier outstanding × Tier annual default rate × Loss given default.
Required reserve = Expected loss A + Expected loss B + Expected loss C. Reserve as share of portfolio = Required reserve ÷ (Tier A + Tier B + Tier C outstanding).
Shortfall or excess vs existing = Existing reserve − Required reserve (negative means a shortfall).
Coverage of 30+ day delinquencies = Required reserve ÷ Balances currently 30+ days past due.
Worked examples
Example 1: default inputs, a $4.3 million book in three tiers
Inputs: Tier A outstanding $2,000,000 at a 3% annual default rate; Tier B $1,500,000 at 8%; Tier C $800,000 at 18%; Loss given default 60%; Balances currently 30+ days past due $250,000; Existing reserve $200,000. Tier A expected loss = 2,000,000 × 0.03 × 0.60 = $36,000. Tier B = 1,500,000 × 0.08 × 0.60 = $72,000. Tier C = 800,000 × 0.18 × 0.60 = $86,400. Required reserve = 36,000 + 72,000 + 86,400 = $194,400. Portfolio outstanding = 2,000,000 + 1,500,000 + 800,000 = $4,300,000, so the reserve is 194,400 ÷ 4,300,000 = 4.52% of the book. Existing reserve of $200,000 less $194,400 required = an excess of $5,600. Coverage of delinquencies = 194,400 ÷ 250,000 = 0.78, flagged because it is below 1.0. The tier table makes the structure visible: Tier C is 19 percent of the book and 44 percent of the expected loss. The reserve is adequate against expected loss but would not cover the $250,000 already past due if all of it were lost, which is the tension between a statistical reserve and the ledger that the coverage ratio is designed to expose.
Example 2: a prime-heavy book with a small subprime tail
Inputs: Tier A $5,000,000 at 2%; Tier B $3,000,000 at 6%; Tier C $500,000 at 25%; LGD 45%; delinquent $300,000; existing reserve $400,000. Tier A = 5,000,000 × 0.02 × 0.45 = $45,000. Tier B = 3,000,000 × 0.06 × 0.45 = $81,000. Tier C = 500,000 × 0.25 × 0.45 = $56,250. Required = 45,000 + 81,000 + 56,250 = $182,250 on a book of $8,500,000, or 2.14%. Excess = 400,000 − 182,250 = $217,750. Coverage = 182,250 ÷ 300,000 = 0.61. This book holds more than twice the reserve its expected loss requires, which an auditor would question as much as a shortfall; under an expected-loss framework a reserve should be supportable, not merely large. Yet coverage of current delinquencies is only 0.61, lower than the default example, because $300,000 is past due on a book whose model expects $405,000 of defaults a year before recoveries. If those delinquencies are concentrated in Tier C, the 25 percent default assumption is probably already stale.
Example 3: a subprime book with a shortfall
Inputs: Tier A $0; Tier B $4,000,000 at 10%; Tier C $2,000,000 at 20%; LGD 70%; delinquent $900,000; existing reserve $500,000. Tier A = 0. Tier B = 4,000,000 × 0.10 × 0.70 = $280,000. Tier C = 2,000,000 × 0.20 × 0.70 = $280,000. Required = $560,000 on $6,000,000, or 9.33%. Shortfall = 500,000 − 560,000 = −$60,000. Coverage = 560,000 ÷ 900,000 = 0.62. Two things stand out. First, Tier C contributes as much expected loss as Tier B on half the balance, which is what a doubled default rate does. Second, 15 percent of the book is already 30 or more days past due, well above the 13.3 percent blended annual default rate the model assumes, so the default rates entered are likely understated for the current period. A funder in this position would increase the Tier C rate until the model's expected defaults at least match what the ledger shows, which pushes the required reserve, and the shortfall, considerably higher.