Articles

How many times does excess spread cover the losses in an auto ABS?

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.

The assumptions

ItemValue
Pool balance$500.0 million
Weighted average APR13.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) / recovery6.5% / 45%
Notes total $475 million against a $500 million pool, so the structure starts with $25 million of overcollateralisation. The first-year, static-pool view ignores amortisation and the timing of defaults.

Step 1: what the structure costs

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.

Step 2: excess spread

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%.

Step 3: the loss it has to cover

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.

Step 4: what happens at a higher default rate

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 multipleAnnual loss ($m)% of poolExcess spread left ($m)Taken from OC and reserve ($m)Class D loss ($m)
1.00x17.883.57%20.550.000.00
1.40x25.035.01%13.400.000.00
2.00x35.757.15%2.680.000.00
2.15x38.437.69%−0.000.000.00
3.00x53.6310.73%−15.2015.200.00
3.83x68.4313.69%−30.0030.000.00
4.00x71.5014.30%−33.0730.003.07
First-year view of the $500 million pool. The multiples 2.15x and 3.83x are the points where excess spread, and then excess spread plus $30.0 million of hard enhancement, are exhausted.

(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.

What if the APR or the recovery were lower?

The common mistakes

Takeaway

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.

Reproducing it in the workbook

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.

Questions readers ask

How do you calculate excess spread in an auto ABS?

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.

How many times does excess spread cover expected losses?

2.15x in this case: excess spread of 38.4275 divided by an annual loss of 17.875 (6.5% default rate, 45% recovery).

What default multiple reaches the junior class?

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.

The workbooks behind this article

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.

Open the companion files →

Paperback on this topic

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 →

Also on this site

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