# Aircraft Leasing An 8-year aircraft operating-lease portfolio from the equity sponsor perspective: a 10-aircraft narrowbody fleet bought for 500M, leased at a monthly lease rate factor, financed with 65% senior debt amortising to a balloon, and sold at a 72% residual value. Returns sheet computes levered IRR, equity multiple, cash yield, and the unlevered asset return, with a 5x5 lease-rate-factor by utilisation sensitivity grid. - Canonical: https://finamodel.com/templates/aircraft-leasing - Excel download: https://finamodel.com/templates/aircraft-leasing.xlsx - Category: Logistics - Model type: Project finance - Difficulty: Intermediate - Audiences: Investors & analysts, Bankers & advisors, Aircraft lessors, Aviation finance teams, Infrastructure funds, Asset-backed lenders - Tags: aircraft leasing, aviation finance, operating lease, asset-backed, lessor returns ## Overview An aircraft leasing model captures the cash flows, financing, and equity returns of an operating-lease portfolio from the lessor (equity sponsor) perspective. The workbook lays out a 10-aircraft narrowbody fleet - 50M per aircraft, 500M total cost, an 8-year levered hold - across nine sheets: Cover, Assumptions, Fleet, Lease_Income, Debt, Cash_Flow, Returns, Sensitivity, Checks. Every input is a named-range cell, every formula is one or two operations long, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. The Fleet sheet runs the net book value roll-forward. NBV opens at zero, takes the full fleet cost as an acquisition in Year 0, and depreciates by a constant straight-line charge each operating year (cost net of a 15% accounting residual, spread over a 25-year useful life). Closing NBV equals opening plus acquisitions plus depreciation. At the end of the hold the fleet is marked to an exit residual value (72% of original cost), and the gain or loss on sale is the difference between that market value and the depreciated closing book value. The Lease_Income sheet walks the operating result. Annual rental per aircraft equals the lease rate factor times twelve times aircraft cost; lease revenue equals aircraft on lease (fleet times 96% utilisation) times the annual rental, escalated 1.5% each year. Operating expenses are 8% of revenue; EBITDA is revenue less opex. Depreciation, interest expense, and the gain or loss on sale carry down to pre-tax income, which is taxed at 21% to give net income. The Debt sheet schedules the senior facility: a 65% loan-to-value drawdown at acquisition (325M), straight-line amortisation over a 12-year schedule, and a balloon repaid from sale proceeds at exit. Interest accrues on the declining opening balance, so debt service falls each year. The Cash_Flow sheet builds operating cash flow (EBITDA less cash taxes less interest), then the levered (equity) cash flow that adds the Year-0 acquisition outflow, debt drawdown, debt repayment, and exit sale proceeds, plus a cumulative equity cash flow and a separate unlevered cash flow view that strips out all debt items. The Returns sheet reports the levered IRR off the equity cash flow stream (~8.5%), the equity multiple of distributions to equity invested (~1.8x), the average operating cash yield, and the unlevered IRR off the asset cash flow (~4.0%) - with the levered IRR exceeding the unlevered IRR because the debt cost sits below the asset return. The exit summary shows sale proceeds, debt outstanding at exit, net exit equity, and total cash returned to equity. The Sensitivity sheet flexes a 5x5 grid of net lease yield on cost against lease rate factor and utilisation offsets. The Checks sheet runs seven validation checks: debt fully repaid at exit, net book value never negative, equity ties to sources, the Year-0 equity outflow equals equity invested, loan-to-value and utilisation within bounds, and accumulated depreciation reconciles to fleet cost less closing NBV. Target users are aircraft lessors, aviation finance and structured-finance teams, infrastructure and asset-backed funds, and lenders sizing senior facilities against narrowbody fleets. Useful for acquisition underwriting (does a fleet purchase clear the equity return hurdle), leverage structuring (how loan-to-value and amortisation reshape the equity IRR), and residual-value stress testing (what a soft secondary market at sale does to the equity multiple). Calibrate against lessor 20-F filings from AerCap and Air Lease Corporation, Cirium fleet values, and aircraft appraiser residual-value curves. ## What's included - 10-aircraft narrowbody operating-lease portfolio, 500M fleet cost, 8-year levered hold - Fleet net book value roll-forward: acquisition, straight-line depreciation, closing NBV - Exit valuation: market value at 72% residual and gain/(loss) on sale versus book - Lease income statement: revenue, opex, EBITDA, depreciation, interest, tax, net income - Senior debt schedule: 65% LTV drawdown, straight-line amortisation, balloon at exit, declining-balance interest - Operating, levered and unlevered cash flow with cumulative equity CF - Returns: levered IRR, equity multiple, average cash yield, unlevered IRR, exit summary - Sensitivity grid: 5x5 lease rate factor by utilisation producing net lease yield on cost - Seven validation checks: debt repaid at exit, NBV non-negative, sources tie, Year-0 outflow, LTV and utilisation bounds, depreciation reconciliation - Operating, levered (equity) and unlevered cash flow with cumulative equity CF - 5x5 sensitivity grid flexing lease rate factor against fleet utilisation ## Inside the Aircraft Leasing Model: How Lessor Returns Are Built This aircraft leasing model evaluates an 8-year operating-lease portfolio from the equity sponsor's perspective: a ten-narrowbody fleet, monthly lease rate factor pricing, senior secured debt amortising to a balloon, and an exit sale at residual value. It shows how the unlevered asset return and levered equity return are separated so the contribution of leverage is explicit. ### What Drives the Portfolio's Cash Flow The model's operating engine rests on a handful of commercial and financing drivers. Lease revenue begins with the lease rate factor, which sets the annual rental per aircraft as a percentage of aircraft cost, and is then scaled by the number of aircraft on lease, reflecting fleet size and utilisation. - A contractual rent step-up applies during the hold, and a re-leasing event near year seven introduces a transition-downtime utilisation haircut and a re-lease rate step. Operating costs include a maintenance expense driver carrying lessor-funded heavy-check costs, separate SG&A and insurance, and remarketing or transition costs. - The capital structure is set by loan-to-value, an amortisation period longer than the hold to leave a balloon, and an interest rate applied to the declining balance. ### How the Model Calculates Returns The calculation flow starts with fleet net book value, which opens at zero, takes the full fleet cost in Year 0, and depreciates on a straight line each operating year. Lease income builds revenue from the lease rate factor, utilisation, and rent step-up, then deducts opex, maintenance expense, depreciation, interest, and tax to reach net income. - Debt is drawn at close based on loan-to-value, amortises on a straight-line schedule, and the remaining balloon is repaid from exit proceeds. The exit value is the exit residual applied to total fleet cost, and gain or loss on sale is the difference between market value and closing net book value. - Operating, levered, and unlevered cash flow are computed separately, with the unlevered view stripping out all debt items. ### Outputs and Sensitivities The returns sheet reports the levered IRR, equity multiple, average operating cash yield, unlevered IRR, and minimum operating-year DSCR, alongside an exit summary showing sale proceeds, debt outstanding, net exit equity, and total cash returned to equity. A scenario toggle switches among base, downside, and upside cases by altering five live drivers: lease rate factor, utilisation, exit residual, interest rate, and re-lease step. - A sensitivity sheet flexes exit residual against lease rate factor to show levered IRR and equity multiple grids. Separate maintenance reserve and security deposit mechanics track restricted cash and deposits, which net to zero over the hold. - Deferred tax timing from accelerated depreciation is also modelled, reversing fully at exit. ### Using the Template for Evaluation This template is useful for understanding how lease rate factor, fleet utilisation, residual value retention, and senior debt structure interact to produce equity returns. The DSCR row and covenant test highlight the operating headroom available to service debt, while the separation of levered and unlevered IRR shows whether leverage is accretive given the spread between asset yield and debt cost. - Validation checks confirm debt repayment, non-negative book value, equity ties to sources, and reconciliation of accumulated depreciation. The public download is a values-only preview; it illustrates the modelled relationships but does not contain live formulas or automatic recalculation. - Use it to assess the logic of the structure rather than as a production underwriting tool. ## Built for the aviation finance desk Aircraft leasing returns hinge on four numbers: the lease rate factor, fleet utilisation, the cost of senior debt, and the residual value at sale. This template lays all four on named-range inputs and reads the levered IRR and equity multiple straight off the Returns sheet. ## Levered and unlevered side by side The Cash_Flow sheet builds an unlevered asset cash flow next to the levered equity cash flow, so the Returns sheet shows both the asset IRR and the equity IRR. The accretion from senior leverage is explicit rather than buried. ## Audit-friendly mechanics Every input is a named-range cell, every formula is one or two operations, the debt fully retires at exit through a balloon, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Built for the aviation finance desk Aircraft leasing returns hinge on four numbers: the lease rate factor, fleet utilisation, the cost of senior debt, and the residual value at sale. This template lays all four on named-range inputs and reads the levered IRR and equity multiple straight off the Returns sheet. ## Levered and unlevered side by side The Cash_Flow sheet builds an unlevered asset cash flow next to the levered equity cash flow, so the Returns sheet shows both the asset IRR and the equity IRR. The accretion from senior leverage is explicit rather than buried. ## Audit-friendly mechanics Every input is a named-range cell, every formula is one or two operations, the debt fully retires at exit through a balloon, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: fleet and acquisition, lease terms, depreciation and residual, financing, and tax. - Fleet count, aircraft cost, acquisition year, hold period - Lease rate factor, utilisation, rent escalation, opex ratio - Useful life, accounting residual, exit residual value - Loan-to-value, interest rate, amortisation period, tax rate - Five derived rows: fleet cost, annual rental, depreciation, debt, equity ### Fleet Aircraft count, book value roll-forward, and exit valuation over Year 0 to Year 8. - Aircraft in service and aircraft on lease - Opening NBV, acquisitions, depreciation, closing NBV - Market value at exit = residual times fleet cost - Gain/(loss) on sale versus depreciated book value ### Lease_Income Lease revenue through to net income over the operating hold. - Lease revenue = aircraft on lease times annual rental, escalated - Operating expenses and EBITDA - Depreciation, EBIT, interest expense, gain on sale - Pre-tax income, tax expense, net income ### Debt Senior debt drawdown, amortisation, balloon, and interest. - Opening balance and Year-0 drawdown at loan-to-value - Scheduled repayment straight-line over the amortisation period - Balloon repayment of the residual balance at exit - Interest expense on the declining opening balance ### Cash_Flow Operating, levered and unlevered cash flow. - Operating cash flow = EBITDA less cash taxes less interest - Levered cash flow adds acquisition, drawdown, repayment, sale - Cumulative equity cash flow roll-forward - Unlevered cash flow view stripping out all debt items ### Returns Headline equity returns plus an exit summary. - Levered IRR off the equity cash flow stream - Equity multiple = distributions / equity invested - Average cash yield and unlevered IRR - Exit summary: sale proceeds, debt at exit, net exit equity, cash to equity ### Sensitivity Net lease yield on cost across lease rate factor and utilisation. - Utilisation offset header row - Lease rate factor offset column - Grid formula: net lease yield on cost - 5x5 = 25 yield cells ### Checks Seven validation checks plus an ALL CHECKS PASS rollup. - Debt fully repaid at exit - Net book value never negative - Equity ties to sources: fleet cost minus debt - Year-0 equity outflow equals equity invested - Loan-to-value and utilisation within bounds - Depreciation reconciles to fleet cost minus closing NBV ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: fleet and acquisition, lease terms, depreciation and residual, financing, and tax. - Fleet count, aircraft cost, acquisition year, hold period - Lease rate factor, utilisation, rent escalation, opex ratio - Useful life, accounting residual, exit residual value - Loan-to-value, interest rate, amortisation period, tax rate - Five derived rows: fleet cost, annual rental, depreciation, debt, equity ### Fleet Aircraft count, book value roll-forward, and exit valuation over Year 0 to Year 8. - Aircraft in service and aircraft on lease - Opening NBV, acquisitions, depreciation, closing NBV - Market value at exit = residual times fleet cost - Gain/(loss) on sale versus depreciated book value ### Lease_Income Lease revenue through to net income over the operating hold. - Lease revenue = aircraft on lease times annual rental, escalated - Operating expenses and EBITDA - Depreciation, EBIT, interest expense, gain on sale - Pre-tax income, tax expense, net income ### Debt Senior debt drawdown, amortisation, balloon, and interest. - Opening balance and Year-0 drawdown at loan-to-value - Scheduled repayment straight-line over the amortisation period - Balloon repayment of the residual balance at exit - Interest expense on the declining opening balance ### Cash_Flow Operating, levered and unlevered cash flow. - Operating cash flow = EBITDA less cash taxes less interest - Levered cash flow adds acquisition, drawdown, repayment, sale - Cumulative equity cash flow roll-forward - Unlevered cash flow view stripping out all debt items ### Returns Headline equity returns plus an exit summary. - Levered IRR off the equity cash flow stream - Equity multiple = distributions / equity invested - Average cash yield and unlevered IRR - Exit summary: sale proceeds, debt at exit, net exit equity, cash to equity ### Sensitivity Net lease yield on cost across lease rate factor and utilisation. - Utilisation offset header row - Lease rate factor offset column - Grid formula: net lease yield on cost - 5x5 = 25 yield cells ### Checks Seven validation checks plus an ALL CHECKS PASS rollup. - Debt fully repaid at exit - Net book value never negative - Equity ties to sources: fleet cost minus debt - Year-0 equity outflow equals equity invested - Loan-to-value and utilisation within bounds - Depreciation reconciles to fleet cost minus closing NBV ## Features - **Fleet NBV roll-forward with exit valuation:** Net book value opens at zero, takes the full fleet cost as an acquisition in Year 0, and depreciates straight-line each operating year. At exit the fleet is marked to a residual value and the gain or loss versus closing book value flows into taxable income. - **Levered and unlevered return split:** The Cash_Flow sheet builds an unlevered asset cash flow alongside the levered equity cash flow, so the Returns sheet shows both the asset IRR and the equity IRR - making the contribution of senior leverage explicit. - **Amortising debt with balloon at exit:** Senior debt amortises straight-line over a period longer than the hold, leaving a balloon that is repaid from sale proceeds in the exit year. Interest accrues on the declining opening balance so debt service falls each year. ## Use cases - **Lessor acquisition underwriting:** Flex the lease rate factor, utilisation, and exit residual to see how the levered IRR and equity multiple move. Decide whether a fleet purchase clears the sponsor return hurdle at the available debt terms. - **Leverage structuring:** Change the loan-to-value, interest rate, and amortisation period to test how senior debt reshapes the equity return. Because the asset return is shown unlevered, the accretion or dilution from leverage is read directly. - **Residual-value stress:** Lower the exit residual value to model a soft secondary market at sale. The Fleet sheet recomputes the gain/(loss) on sale, the tax effect flows through, and the Returns sheet shows the hit to the equity multiple. ## Frequently asked questions ### What is an aircraft operating lease? An operating lease is a medium-term rental of an aircraft to an airline. The lessor keeps ownership and the residual-value risk, while the airline pays a fixed monthly rental and returns the aircraft at lease end. This template takes the lessor view across a portfolio of 10 narrowbody aircraft over an 8-year hold. ### What is the lease rate factor? The lease rate factor is the monthly lease rental expressed as a percentage of aircraft cost. A 0.95% monthly factor on a 50M aircraft implies a 5.7M annual rental. New narrowbody lease rate factors typically run 0.80 to 1.00% per month. ### Why is the levered IRR higher than the unlevered IRR? Because the senior debt cost of 5.5% sits below the unlevered asset return, leverage is accretive. Borrowing at a rate lower than the asset earns amplifies the equity return. The model reports both the levered and unlevered IRR so the contribution of debt is explicit. ### How is the senior debt repaid? Debt is drawn at acquisition at 65% loan-to-value, amortises straight-line over a 12-year schedule, and the balance still outstanding at the end of the 8-year hold is repaid as a balloon from the sale proceeds. Interest accrues on the declining opening balance. ### What drives the exit value? Exit proceeds equal the exit residual value, 72% of original cost, times total fleet cost. The gain or loss on sale is the difference between that market value and the depreciated book value, and it flows through pre-tax income in the exit year. ### Can I resize the fleet or change the hold? Yes. The number of aircraft, aircraft cost, and hold period are named-range inputs. The builder is parameterised by NUM_PERIODS, currently 9, equal to Year 0 plus an 8-year hold. Bump it together with the Hold Period assumption to extend the horizon. ## Related templates - [Equipment Leasing Model](https://finamodel.com/templates/leasing-model) - [Sale-Leaseback Real Estate Model](https://finamodel.com/templates/sale-leaseback-model) - [Airline Operations Model](https://finamodel.com/templates/airline-model)