Articles

How fast does excess spread build overcollateralisation to its target?

Overcollateralisation grows when excess spread, trapped as extra principal, exceeds credit losses. The speed depends on the margin between the pool coupon and the cost of the notes, and on the loss rate.

A $500 million pool pays 11.0% against notes of $485 million at 5.0%, with 1.0% servicing. Year-one excess spread is $25.75 million, 5.15% of the pool. With losses of 3.0% of the pool a year, the structure traps all of it as principal and overcollateralisation rises from 3.0% to 7.05% after year 1 and reaches its 8.0% target in year 2. At 4.5% losses the target is also met in year 2. At 6.0% it is not met in four years, and at 8.0% the notes are undercollateralised from year 2.

The assumptions

Illustrative auto loan ABS, annual periods, $ million
ItemValue
Pool balance$500.0
Notes at closing$485.0 (initial overcollateralisation $15.0, 3.0%)
Pool coupon (WAC)11.0% on the opening pool balance
Servicing fee1.0%
Note coupon5.0%
Principal collections24.0% of the opening pool each year
Target overcollateralisation8.0% of the current pool

Annual steps keep the arithmetic short; a real deal runs monthly. Interest is earned on the full opening balance, which means defaulted loans are treated as paying interest during the year in which they default. All principal collections and any excess spread needed go to the notes until overcollateralisation reaches the target; above the target the cash is released to the residual holder.

Step 1: excess spread

Excess spread = pool interest − servicing fee − note interest

Excel: =B2*WAC-B2*Serv-Notes*NoteRate

Year 1: 500 × 11.0% = $55.00 of pool interest, less $5.00 of servicing and $24.25 of note interest (485 × 5.0%). Excess spread is $25.75 million, 5.15% of the opening pool. This is the first line of protection: losses up to that rate are absorbed before overcollateralisation falls.

Step 2: the first year with 3.0% annual losses

Losses are 3.0% × 500 = $15.00 million and principal collections are 24.0% × 500 = $120.00 million, so the pool ends at 500 − 120 − 15 = $365 million. For 8.0% overcollateralisation the notes may be at most 92% × 365 = $335.8 million, a paydown of $149.2 million. Cash available for the notes is collections plus excess spread: 120 + 25.75 = $145.75 million, short by $3.45 million. All of it is paid, nothing is released, and the notes end at $339.25 million.

Overcollateralisation = pool − notes = 365 − 339.25 = $25.75 million (7.05%)

Change = excess spread − losses = 25.75 − 15 + 15.00 initial = 25.75

Step 3: the four-year build at 3.0% losses

Overcollateralisation path, $ million
YearClosing poolExcess spreadClosing notesOvercollateralisation% of poolReleased
1365.025.75339.2525.757.05%0.00
2266.419.54245.1321.328.00%13.02
3194.514.39178.9515.568.00%12.15
4142.010.50130.6311.368.00%8.87

In year 2 the need for paydown, $94.12 million, is below the cash available, $107.14 million, so the target of 8.0% is reached and $13.02 million is released. After that the structure keeps 8.0% of a shrinking pool and releases about $12 million a year. The trap works as a savings account that closes once it has reached its target.

How the loss rate changes the answer

Overcollateralisation as a percentage of the pool, by annual loss rate
Annual loss rateTarget reachedEnd of year 1End of year 2End of year 4
3.0%Year 27.05%8.00%8.00%
4.5%Year 25.10%8.00%8.00%
6.0%Not in 4 years3.07%3.18%3.58%
8.0%Not in 4 years0.22%−4.07%−20.93%

The break-even is the excess spread rate, about 5.1% of the pool a year: at that loss rate the overcollateralisation dollars stay at their $15.0 million in year 1. At 6.0% losses overcollateralisation falls in dollars, from $15.0 million to $10.75 million in year 1, and ends year 4 at only 3.58% of a smaller pool. At 8.0% losses, year 1 leaves only $0.75 million of overcollateralisation and the notes are undercollateralised by $9.41 million at the end of year 2.

What if: the target is 10.0%

With a 10.0% target and 3.0% losses the structure still reaches its target in year 2, but it releases only $7.69 million that year instead of $13.02 million. A higher target keeps more cash in the structure, which lowers the residual holder's return without changing how fast the build happens.

The common mistakes

Takeaway

Questions readers ask

How does excess spread build overcollateralisation?

Excess spread, the pool interest left after servicing and note interest, is paid as extra principal to the notes instead of being released. Each dollar pays down notes while the pool is unchanged, so the gap between the pool and the notes widens.

How long does it take to reach the target overcollateralisation?

On a $500 million pool with 3.0% initial overcollateralisation, an 8.0% target and 3.0% annual losses, the target is reached in year 2. At 4.5% losses it is also reached in year 2; at 6.0% it is not reached within four years.

What loss rate stops overcollateralisation from building?

The loss rate that equals the excess spread rate. Here excess spread is 5.15% of the opening pool in year 1, so losses above that rate reduce overcollateralisation in dollars and the target cannot be met.

The workbooks behind this article

The free companion files for The Structured Credit Analyst rebuild a fictional auto loan securitisation, its collateral, waterfall, tests and tranche returns, in live formulas. The pool and rates in this article are invented and are not in them. No account and no email address.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: credit, private credit and distressed debt → · All 1908 articles →