Companion files · The Private Markets Career Guides
How Commercial Aircraft Lessors Really Work: Sale-and-Leasebacks, Lease Rates and Residual Values, Maintenance Reserves and Return Conditions, Airline Credit, Repossession, Financing and the Career.
These are the companion files of the book. One workbook rebuilds the Larkfield Aviation Capital case: the portfolio, the Varnley Air sale-and-leaseback with its monthly cash flows, IRRs and residual sensitivity, the appraisals and impairment test of the Teskar aircraft, its return and transition to Merrow Air, the Calder Coast default and repossession, the LALS 2025-1 securitization, Varnley Air’s IFRS 16 lease liability and Larkfield’s 2025 results. A toolkit holds the fourteen 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 1 to 16
One Inputs sheet holds every case assumption: the fleet and the depreciation policy, the sale-and-leaseback price, lease rate factor, residual and loan, the Teskar return conditions and engine reserves, the transition costs and downtime, the Calder Coast arrears, recovery and repossession costs, the ABS appraisals and tranches, and Larkfield’s results. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook71 KBAppendix B
Lease proposal checklist, sale-and-leaseback pricing checklist, appraisal review checklist, airline credit review checklist, lease document checklist, insurance certificate checklist, delivery and acceptance checklist, maintenance reserve review checklist, lease return checklist, transition plan checklist, default and repossession checklist, Cape Town and registration checklist, financing and ABS eligibility checklist and quarterly portfolio review checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| Varnley Air sale-and-leaseback | $56.0 million paid, a lease rate factor of 0.68 percent and $380,800 a month for 144 months, a residual of $33.0 million: an unlevered IRR of 6.0 percent and, with a 70.0 percent loan at 5.25 percent, a levered IRR of 7.0 percent (4.5 percent had the residual been $26.4 million) |
| Calder Coast default | Four aircraft, $4.26 million of arrears, $2.08 million of deposits applied, possession after a 60-day waiting period: a total economic cost of $9.66 million, 8.2 percent of their book value |
| Larkfield in 2025 | $745.0 million of revenue, $207.0 million of net profit on $1,650.0 million of equity: a return on equity of 12.5 percent at a debt to equity of 2.55x |
The files are provided as they are, without warranty of any kind. The model is illustrative: Larkfield Aviation Capital and the other names are fictional, the model is simplified, the rules and standards are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal, tax or accounting advice.
More in infrastructure and energy, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.
Also available as a standalone free template: aircraft lease model.