Companion files · The Private Markets Career Guides

The Equipment Finance Professional

Equipment Leasing and Finance: Pricing, True Leases and the UCC, Residual Values, Tax and ASC 842, Defaults and Equipment ABS.

These are the companion files of the book. One workbook rebuilds Quillmont Equipment Finance, the fictional independent lessor of the case, as it prepares its 2027 plan: a $1,250,000 loan on three excavators, a $1,800,000 FMV lease of an imaging system under a vendor program, a $4,125,000 TRAC lease of 25 tractors that defaults in month 20, a $600,000 server lease, the tax case, a $640.00 million book, its warehouse line and Quillmont Equipment Trust 2027-1. A toolkit holds the checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive86 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 lease price$32,375 a month for 60 months, paid in advance: at 7.75 percent the payments are worth $1,616,509 and the $270,000 residual $183,491, together the $1,800,000 price
The default$2,958,189 owed in month 20, $2,070,500 from the auction, a loss of $805,275 after the deposit: 27.2 percent of the amount owed
The bookReturn on equity 8.82 percent against a 12 percent target; in the securitization, a residual IRR of 19.11 percent in the base case

The files are provided as they are, without warranty of any kind. The model is illustrative: Quillmont Equipment Finance, its trust, the lessees, the manufacturer, the banks and the insurer are fictional, and rates, residuals, auction prices, funding terms, loss rates and dates are the book’s assumptions, not the terms of any real contract, the quote of any real market or a forecast. Nothing here is legal, tax, accounting or investment advice.