Companion files · The Private Markets Career Guides

The Aircraft Leasing Professional

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 workbook, the toolkit and the read-me, in one archive95 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

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 defaultFour 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.

Also by Julian R. Sterling

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.