An LGD calculator works out loss given default: the share of a loan that a lender loses when the borrower defaults. Enter the exposure at default and the amount recovered, and the calculator gives the loss, the LGD and the recovery rate. Add a probability of default to see the expected loss, the figure lenders use to price loans and set aside provisions.
The LGD formula
LGD = (exposure at default − amount recovered) ÷ exposure at default
Recovery rate = 1 − LGD
Expected loss EL = PD × EAD × LGD
The OCC's Comptroller's Handbook describes LGD as the loss rate expected at the time of default, and expected credit losses as PD × LGD × EAD, where EAD is the projected balance at the time of default. The recovery rate is one minus LGD, the share of the exposure that is recovered.
How to use the LGD calculator
- Enter the exposure at default: the amount owed at the time of default.
- Enter the amount recovered, after the costs of recovering it.
- Optionally enter a probability of default to see the expected loss.
- Press Calculate.
Worked example
For example, take an unsecured debt of $100,000 on which the lender recovers $80,000 after default. The loss is $20,000, so the LGD is 20 percent and the recovery rate is 80 percent. A secured loan with an exposure of 200,000 and a collateral sale of 160,000 has a loss of 40,000 and again an LGD of 20 percent. If the probability of default on the first loan is 2 percent, the expected loss is 0.02 × $100,000 × 0.20 = $400, or 0.4 percent of the exposure.
Expected loss
The three parts of expected loss answer three questions: how likely is the borrower to default, how much will be owed if they do, and how much of that will be lost. Multiplying them gives the average loss a lender can expect on a loan, or across a portfolio of similar loans. It is an average, so actual losses on a single loan are either zero, if the borrower doesn't default, or much larger, if they do. Over many loans, expected losses give a guide to the provisions a lender needs and the interest margin it must charge to cover them.
Regulatory values
Under the Basel II foundation approach, banks use supervisory values rather than their own estimates: an LGD of 45 percent for senior unsecured claims on companies, governments and banks, and 75 percent for all subordinated claims. Banks using the advanced approach estimate LGD from their own data. Downturn LGD reflects losses during an economic downturn, and one definition of a downturn is at least two consecutive quarters of negative real GDP growth.
What affects LGD
Collateral matters a great deal: a loan backed by assets that can be sold for close to the amount owed has a low LGD, while an unsecured loan can lose much more. The costs of recovery, the time it takes and the borrower's other debts also matter, because a lender ranked behind others gets paid later or not at all. Collateral values are adjusted for haircuts, reductions in its value to allow for price falls and selling costs, before working out an effective LGD.
Gross and net figures
Gross LGD divides losses by the whole exposure at default, unlike versions that divide only by the unsecured part. Use the same definition consistently when comparing loans. The amount recovered should be net of the costs of recovery, such as legal fees and selling costs, so that the LGD reflects what the lender actually loses. For the loan payments themselves, the loan payment calculator helps, and for probabilities in general the probability calculator.
Using LGD for a portfolio
For a portfolio of loans, work out the expected loss of each loan and add them up. Loans with the same probability of default can have very different expected losses if their LGDs differ, for example because some are secured and others are not. Grouping loans by type of collateral and comparing their average LGDs shows where losses would be heaviest if defaults rose, which is useful when deciding how much to lend against each kind of security.
Changing the inputs
Try a few values to see how sensitive the expected loss is. Doubling the probability of default doubles the expected loss, and so does doubling the LGD. A lender that improves its recovery process, raising recoveries from 80 to 90 percent of the exposure, halves the LGD from 20 to 10 percent and halves the expected loss with it, without changing who it lends to.
Common mistakes
- Using the original loan amount. Use the exposure at the time of default.
- Ignoring recovery costs. Use the recovery after costs.
- Entering PD as a decimal. Enter 2 for 2 percent.
- Treating expected loss as the loss on one loan. It is an average.
How to read the LGD result
Take an exposure at default of $250,000, recoveries of $150,000 after costs and a probability of default of 5 percent. The LGD calculator shows a loss of $100,000, an LGD of 40 percent, a recovery rate of 60 percent, an expected loss of $5,000 and an expected loss of 2 percent of the exposure.
Read the last figure as the share of the loan a lender should expect to lose on average, which it can compare with the interest margin it earns. If better collateral lifted recoveries to $220,000, the LGD would drop to 12 percent and the expected loss to $1,500, or 0.6 percent of the exposure. The calculator won’t accept recoveries larger than the exposure, because a lender can’t lose a negative share of what it was owed.
What next
Use this often? Add LGD to your Home screen.
Frequently asked questions
How does an LGD calculator work?
It subtracts the amount recovered from the exposure at default and divides the loss by the exposure.
What is the LGD if $80,000 of a $100,000 debt is recovered?
20 percent.
How is expected loss calculated?
PD × EAD × LGD; with a 2% PD that example gives $400.
What LGD does the Basel II foundation approach use?
45% for senior unsecured claims and 75% for subordinated claims.
What is the recovery rate?
One minus the LGD.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.