Companion files · The Private Markets Career Guides
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 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 3 and 5 to 15, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Deal 1 Loan, Deal 2 Lease, Vendor, Tax, Deal 3 TRAC and Default, Deal 4, Portfolio, Warehouse, ABS. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 13 exercises of Appendix A run on it.
Download the workbook49 KBAppendix B
New lessee credit file; Asset and collateral file; Documentation and UCC filing; True lease or security interest questions; Residual setting; Vendor program review; Default and repossession; Lease end and remarketing.
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 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 book | Return 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.