# The Equipment Finance Professional: companion files

Julian R. Sterling

## What is here

- **Equipment_Finance_Model.xlsx**: the workbook that rebuilds the Quillmont case and reproduces the figures of the book with live formulas. Sheets: Inputs, Deal 1 Loan, Deal 2 Lease, Vendor, Tax, Deal 3 TRAC and Default, Deal 4, Portfolio, Warehouse, ABS, Checks.
- **Equipment_Finance_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapters 3 and 6: Deal 1 Loan (the contractor's loan at $25,465 a month, the year-1 schedule and the collateral cover with and without a down payment)
- Chapters 3, 7, 10 and 13: Deal 2 Lease (the imaging center's FMV lease at $32,375 a month, the proof of the price, the ASC 842 classification, year-1 income and the three lease-end outcomes)
- Chapter 8: Vendor (the program at 3.9 percent and the rate buydown of $173,906)
- Chapter 9: Tax (after-tax yield 6.46 percent with MACRS, 7.38 percent with bonus depreciation)
- Chapters 5 and 12: Deal 3 TRAC and Default (the carrier's credit test, the TRAC settlement and a loss of $805,275 after default)
- Chapter 13: Deal 4 (the server lease: a realized yield of 6.54 percent instead of 9.25 percent)
- Chapters 11 and 14: Portfolio (the 2027 plan by segment, return on equity 8.82 percent, and the stress)
- Chapter 14: Warehouse (borrowing base $303.45 million, deficiency $6.55 million)
- Chapter 15: ABS (Quillmont Equipment Trust 2027-1, residual IRR 19.11 percent in the base case)
- Appendix A: 13 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, set the deal 3 auction price per tractor from $92,000 to $80,000: watch the loss after default on Deal 3 TRAC and Default.
2. On Inputs, raise the ABS default rate from 1.0 percent to 3.0 percent: the trigger trips, every class is still repaid and the residual IRR collapses on the ABS sheet. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Quillmont Equipment Finance, Quillmont Equipment Trust 2027-1, the lessees, the manufacturer, the banks and the insurer are fictional; rates, residuals, auction prices, policy limits, funding terms, loss rates and dates are teaching assumptions, not the terms of any real contract, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
