Companion files · The Private Markets Career Guides

The Auto Finance Professional

Auto Lending from Dealer to Auto ABS: Indirect Lending, Subprime Auto Loans, Underwriting, Risk-Based Pricing, Loss Curves and Securitization.

DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample

These are the companion files of the book. One workbook rebuilds the case of Brindlemoor Auto Finance, a fictional finance company that buys $150,000,000 of dealer contracts each quarter of 2027 across four credit tiers, from prime to deep subprime. It follows one application from the dealer to the counteroffer, builds the rate card in points, runs every tier's vintage month by month, books the allowance, funds the book and securitizes $300,000,000 of contracts through a trust with tranches, a reserve, overcollateralization and a trigger. A toolkit holds the check-lists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive493 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

The dealAs the dealer sent it, $30,422.50 financed on a $23,500 guide value, a loan to value of 129.5 percent against a limit of 125.0 percent; approved at $29,375.00 with more cash down
The vintageLifetime net losses of $10,190,216 on $150,000,000, or 6.79 percent; a return on equity of 24.5 percent before overhead and taxes
The trustEvery class repaid in the base case and $43,600,850 released to Brindlemoor; the 2027 provision on the new vintages is $40,760,864

The files are provided as they are, without warranty of any kind. The model is illustrative: Brindlemoor Auto Finance, its trust and its dealers are fictional, every contract in a tier is the tier’s average contract, and rates, prices, loss assumptions, funding terms and dates are the book’s assumptions, not market data, the terms or results of any real lender or dealer or a forecast. Nothing here is legal, compliance, tax, accounting, credit or investment advice.