The first line of defence in an auto ABS is not the subordinated notes. It is the gap between what the loans pay and what the structure costs, and it can be measured in one line.
A $500 million pool earns $67.50 million of interest at a 13.50 per cent APR. After a 1 per cent servicing fee and $24.07 million of note interest, excess spread is $38.43 million a year, 7.69% of the pool. Expected losses at a 6.5 per cent default rate and 45 per cent recovery are $17.88 million, so excess spread alone covers them 2.15x. Adding the $25.0 million of overcollateralisation and the $5.0 million reserve, the first-year default multiple that reaches the first dollar of loss on the junior class is 3.83x.
Rating agencies and investors ask how many times a transaction covers its expected loss. In an auto ABS the first answer comes from excess spread, because the loans pay far more than the notes cost. This article computes that cover for the Tallis auto receivables trust in the book, using one year and a static pool; the workbook’s own cash flow runs month by month on an amortising pool.
| Item | Value |
|---|---|
| Pool balance | $500.0 million |
| Weighted average APR | 13.50% |
| Servicing fee (a year) | 1.00% |
| Class A / B / C / D | $375 / 40 / 35 / 25 million at 4.80% / 5.40% / 6.00% / 7.25% |
| Notes outstanding | $475.0 million |
| Reserve account | $5.0 million |
| Base default rate (CDR) / recovery | 6.5% / 45% |
Note interest is each class balance times its coupon, and the weighted cost is the total over the notes:
Note interest = Σ class × coupon. In Excel: =SUMPRODUCT(B2:B5,C2:C5), with class sizes in B2:B5 and coupons in C2:C5.
375 × 4.80% = 18.00; 40 × 5.40% = 2.16; 35 × 6.00% = 2.10; 25 × 7.25% = 1.8125. The total is $24.07 million, and 24.0725 ÷ 475 = 5.07%, the weighted average coupon.
Excess spread is what is left of the loan interest after servicing and note interest:
Excess spread = pool × APR − pool × servicing fee − note interest. In Excel: =B6*B7-B6*B8-B9.
500 × 13.50% = 67.50; less servicing of 5.00 and note interest of 24.0725 leaves $38.43 million, which is 7.69% of the pool a year. The loans pay 13.50%; the structure costs 5.81%.
Defaults are a share of the pool, and the loss is the part not recovered:
Annual loss = pool × CDR × (1 − recovery). In Excel: =B6*B10*(1-B11).
500 × 6.5% = 32.50 of defaults, and 32.50 × (1 − 0.45) = $17.88 million, or 3.575% of the pool. The cover is 38.4275 ÷ 17.875 = 2.15x.
Multiply the default rate by a factor k. Losses of k × 17.875 are met first by excess spread, then by the $25.0 million of overcollateralisation and the $5.0 million reserve ($30.0 million together), and only then by Class D:
Break-even multiple = (excess spread + overcollateralisation + reserve) ÷ base annual loss. In Excel: =(B12+B13+B14)/B15.
| Default multiple | Annual loss ($m) | % of pool | Excess spread left ($m) | Taken from OC and reserve ($m) | Class D loss ($m) |
|---|---|---|---|---|---|
| 1.00x | 17.88 | 3.57% | 20.55 | 0.00 | 0.00 |
| 1.40x | 25.03 | 5.01% | 13.40 | 0.00 | 0.00 |
| 2.00x | 35.75 | 7.15% | 2.68 | 0.00 | 0.00 |
| 2.15x | 38.43 | 7.69% | −0.00 | 0.00 | 0.00 |
| 3.00x | 53.63 | 10.73% | −15.20 | 15.20 | 0.00 |
| 3.83x | 68.43 | 13.69% | −30.00 | 30.00 | 0.00 |
| 4.00x | 71.50 | 14.30% | −33.07 | 30.00 | 3.07 |
(38.4275 + 30) ÷ 17.875 = 3.83x. At 1.4 times the base default rate, the multiple used on the book’s second auto sheet, the annual loss is $25.03 million and excess spread covers it 1.54x.
Compute excess spread ($38.43 million), the annual expected loss ($17.88 million) and their ratio (2.15x), then add the hard enhancement ($30.0 million) to get the multiple at which the junior class takes its first loss (3.83x). It is a first-year screen, not a substitute for the month-by-month waterfall. For that waterfall, and for the 1.4 times default case, see The Structured Credit Analyst.
The pool, APR, servicing fee, default rate, recovery, class sizes, coupons and reserve are in Structured_Credit_Model.xlsx, rows 6 to 25 of the Inputs sheet; the Auto ABS and Auto ABS 1.4x sheets run the month-by-month cash flow at one and 1.4 times the default rate. The first-year cover and break-even multiple above are a simplification and are not lines of the workbook.
Loan interest less servicing and note interest. Here 67.50 less 5.00 less 24.0725 is $38.43 million a year, 7.69% of the pool.
2.15x in this case: excess spread of 38.4275 divided by an annual loss of 17.875 (6.5% default rate, 45% recovery).
3.83x in the first year: excess spread plus $25.0 million of overcollateralisation and $5.0 million of reserve, divided by the base annual loss.
Every figure above is built from the inputs in the free companion files for The Structured Credit Analyst, which also hold a CLO model with base, stress and severe default paths and a non-QM RMBS model with a stress case. No account and no email address.
How to Read an ABS Servicing Agreement
106 pages, printed on demand and shipped worldwide, direct from the author: $32.99 paperback, $19.99 PDF. Not sold on Amazon. See the book →
The bookshop
151 handbooks and exam guides by Julian R. Sterling that are not on Amazon, sorted by subject. 15% off from 2 books. Browse the bookshop →
Reading guide: credit, private credit and distressed debt → · All 1908 articles →