Companion files · The Private Markets Career Guides
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 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.
Chapters 4 to 16, and Appendix A
11 sheets that follow the book: Rate card, Application, Dealer, Vintage, Losses, Allowance, Funding, Trust, Collections, Channel, Checks. The Checks sheet puts the figures printed in the book beside the cells that compute them, and the 11 exercises of Appendix A run on the workbook.
Download the workbook473 KBAppendix B
Dealer sign-up and annual review; Application and structure check; Funding audit check-list; Monthly vintage and dealer review; Collections and repossession file; Allowance committee pack; Trust pool and waterfall review; State rules grid: the columns to keep.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The deal | As 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 vintage | Lifetime 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 trust | Every 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.