# The Aircraft Leasing Professional: companion files

Julian R. Sterling

## What is here

- **Aircraft_Leasing_Model.xlsx**: the workbook that rebuilds the Larkfield Aviation Capital case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Portfolio, SLB Pricing and IRR, Residual Sensitivity, Values and Impairment, Lease Return, Transition, Default and Repossession, ABS, Lessee Accounting, Lessor P&L and ROE, Checks.
- **Aircraft_Leasing_Toolkit.docx**: the fourteen checklists of Appendix 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, quarterly portfolio review checklist), in editable form.

## Which sheet answers which chapter

- Chapters 1, 2 and 16: Portfolio (120 aircraft, $6,000.0 million of net book value, 41 lessees in 27 countries, 30 narrowbodies on order, depreciation over 25 years to 15.0 percent of cost)
- Chapters 5 and 6: SLB Pricing and IRR (the Varnley Air aircraft bought for $56.0 million, a lease rate factor of 0.68 percent and a rent of $380,800 a month for 144 months, a 70.0 percent loan at 5.25 percent, an unlevered IRR of 6.0 percent and a levered IRR of 7.0 percent)
- Chapters 5 and 7: Residual Sensitivity (residuals of $26.4 million, $33.0 million and $39.6 million: unlevered 5.1, 6.0 and 6.8 percent, levered 4.5, 7.0 and 9.0 percent)
- Chapter 7: Values and Impairment (a half-life market value of $27.0 million, a maintenance-adjusted value of $23.42 million, value in use of $28.00 million against a book value of $26.71 million)
- Chapter 8: Lease Return (the Teskar half-life tests, $0.90 million of compensation and $12.18 million of engine reserves retained)
- Chapter 10: Transition (four months on the ground, $2.04 million of cost and forgone rent, $1.14 million net; the Merrow Air lease at $285,000 a month)
- Chapter 11: Default and Repossession (Calder Coast: $4.26 million of arrears, $2.08 million of deposits, a total economic cost of $9.66 million)
- Chapter 14: ABS (LALS 2025-1: $800.0 million of aircraft, Series A to 70.0 percent loan-to-value, $120.0 million of equity, debt service cover of 1.12x)
- Chapter 15: Lessee Accounting (Varnley Air's lease liability of $38.21 million)
- Chapter 16: Lessor P&L and ROE ($745.0 million of revenue, $207.0 million of net profit, debt to equity of 2.55x, return on equity of 12.5 percent)

## Two inputs to change first

1. On Inputs, lower the assumed residual value of the Varnley Air aircraft: watch the levered IRR fall faster than the unlevered IRR on SLB Pricing and IRR and Residual Sensitivity.
2. On Inputs, add two months to the Calder Coast rent lost: watch the total economic cost and its share of pre-tax profit move on Default and Repossession. 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. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Larkfield Aviation Capital, Varnley Air, Teskar Airlines, Merrow Air, Calder Coast Airways and LALS 2025-1 are fictional; the model is a simplified teaching model; rules and standards are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, legal, tax or accounting advice.
