A free aircraft lease model in Excel, from the lease rate factor to the lessor's return
A narrowbody sale-leaseback priced month by month, the residual moved a fifth either way, values and impairment, return conditions, transition, default and repossession, an ABS pool, IFRS 16 and the lessor's P&L: thirteen sheets, no macros.
The file prices a fictional sale-leaseback: Larkfield Aviation Capital buys a new narrowbody from Varnley Air for $56 million, 1.8% above its current market value, and leases it back for twelve years at a lease rate factor of 0.68%, or $380,800 a month in advance. The residual is assumed at $33 million, 59% of the price, against a book value of $33.15 million at lease end. Unlevered, the deal returns 5.99%; with a $39.2 million loan at 5.25% and a $14 million balloon, the equity earns 7.03%. Move the residual down a fifth and the levered IRR falls to 4.48%; up a fifth and it rises to 9.00%.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Aircraft_Lease_Model.xlsx (70 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is one worked case from The Aircraft Leasing Professional. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Thirteen sheets, one per chapter of the case. Blue cells on a light blue background are inputs, on the Inputs sheet only.
Read Me and Inputs
The case and every input: the fleet, the depreciation policy, the sale-leaseback terms, the loan, values, maintenance, transition, default, the ABS pool and the lessor's results.
Portfolio
Larkfield's 120 owned aircraft at the year end and the depreciation policy.
SLB Pricing and IRR
Price against appraisals, rent from the lease rate factor, residual against book value, the secured loan and its balloon, first-year arithmetic, and monthly cash flows to unlevered and levered IRR.
Residual Sensitivity
The IRRs at the base residual and a fifth either side.
Values and Impairment
Current market value, base value and the impairment test.
Lease Return and Transition
Half-life tests and compensation at redelivery, and the cost of moving the aircraft to the next lessee.
Default and Repossession
Arrears, security and repossession when a lessee stops paying.
ABS
A securitisation of leased aircraft, valued from two appraisals.
Lessee Accounting and Lessor P&L and ROE
IFRS 16 on the lessee's side, and the lessor's income statement and return on equity.
Checks
The figures printed in the book against the formulas: 210 lines, all OK.
What the worked case returns
Measure
Value
Purchase price
$56.0m
Lease rate factor (monthly)
0.68%
Monthly rent, in advance
$380,800
Term
144 months
Simple rental yield on price
8.16%
Assumed residual value
$33.0m (58.9%)
Loan, rate and balloon
$39.2m, 5.25%, $14.0m
Unlevered IRR
5.99%
Levered IRR
7.03%
Levered IRR, residual down or up a fifth
4.48% or 9.00%
The residual is the deal. Rent over twelve years adds up to $54.8 million, less than the $56 million price: the return comes from what the aircraft is worth when it comes back. A fifth off the residual costs the equity more than two and a half points of IRR, which is why the residual and the return conditions get more of the book than the rent does.
How to use it on your own aircraft
Enter your aircraft on Inputs: price, appraised value, lease rate factor, term and deposit.
Set the residual from an appraiser's future value, not from the depreciation policy.
Enter the loan: amount, rate, margin and balloon.
Read the IRRs on SLB Pricing and IRR, then the spread on Residual Sensitivity.
Use the other sheets for the events of the lease: return, transition, default and the lessor's results.
Questions people ask about it
Is this aircraft lease model really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference: monthly cash flows annualised into IRRs, and a level loan payment computed in closed form.
What is a lease rate factor?
The monthly rent as a share of the aircraft's price. At 0.68% on $56 million the rent is $380,800 a month, a simple annual yield of 8.16% on the price.
Can I use it for a real transaction?
You can reuse the structure. The lessor, the airlines and every figure are fictional, and nothing here is investment advice.
The rest of the files
This template is the companion workbook for The Aircraft Leasing Professional; the companion page also carries the toolkit of working documents that goes with it. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
This template comes from The Aircraft Leasing Professional. The book is on Apple Books and Google Play.
If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.