# Leasing Model Build an equipment and asset leasing model covering operating and finance lease classifications, residual value sensitivity, and structured payment profiles. Designed for lessors, fleet operators, and asset finance teams. - Canonical: https://finamodel.com/templates/leasing-model - Excel download: https://finamodel.com/templates/leasing.xlsx - Category: Capital Markets - Model type: Project finance - Difficulty: Beginner - Audiences: Founders & operators, CFOs & FP&A, Leasing Companies, Equipment Finance Teams, Asset Managers, Capital Markets - Tags: leasing, residual-value, equipment, yield, re-lease ## Overview An Equipment Leasing Model projects the cash generation and leverage profile of a mid-market equipment leasing portfolio ($100M+ originations annually). It forecasts lease income (gross contractual yield), origination fees, servicing fees, and residual gains on equipment sold at lease-end. A typical portfolio yields 9.5% on average earning assets, funded by warehouse debt at 7.0% all-in cost, producing a net interest margin (NIM) of 2.5-3.5% before credit losses. The model tracks portfolio roll-forward (originations, amortization, prepayments, charge-offs), debt repayment schedules, and equity returns through a 7-year projection. The workbook separates portfolio mechanics (origination schedule, lease term, advance rate sizing) from financial results. The Portfolio_Build sheet calculates average earning assets and ending balances quarter-on-quarter. Revenue_Yield derives lease income, fees, and residual gains using actual cohort aging and standard recovery assumptions. Debt funding is sized mechanically at 80% advance rate against portfolio balance, with covenant tests on maximum 4.5x debt-to-equity and 85% maximum advance rate. The Income Statement captures net interest margin (NIM), credit loss provisions (0.75% default rate), and operating expenses (SG&A at 2.2% of assets), producing 12-14% ROE at maturity. This model suits mid-market lessors, specialty finance lenders, and investors evaluating equipment leasing platform acquisitions or originations programs. Key metrics include portfolio yield (contractual rate on loans), cost of funds (SOFR + spread), net charge-off rates (typically 0.5-1.5% through the cycle), and covenant headroom (targeting 1.5-2.0x debt/equity cushion above limits). ## What's included - Operating and finance lease classification logic - Right-of-use asset and liability amortisation schedules - Residual value and disposition sensitivity analysis - Structured payment profiles with step-ups and balloon payments - IRR and NPV yield calculations - Lease portfolio composition and payment schedules - Equipment depreciation and residual value assumptions - Operating expense forecasts (maintenance, insurance, setup) - Re-lease cycles, recovery, and refurbishment costs - Cost of funding and spread analysis - Operating vs. finance lease accounting treatment ## How the Equipment Leasing Model Projects Portfolio Performance and Leverage This leasing model projects a mid-market equipment lessor's financials over seven years, driven by portfolio roll-forward, spread income, residual realisations and warehouse debt. It is built for lessors, fleet operators and asset finance teams evaluating how originations, funding structure and credit losses interact. The specification is a values-only preview. ### Portfolio Origins and Capital Deployment Annual originations are the engine of the leasing model, equivalent to capital expenditure for a lessor. - Each funded lease splits between a lease receivable and a capitalised residual asset, so the full equipment cost is not booked twice. - The portfolio then rolls forward from opening receivables, adding funded amounts and subtracting scheduled amortisation, prepayments and charge-offs. - Growth is set by an origination growth rate rather than a standalone revenue growth assumption, so lease income scales as the book seasons. ### Revenue Spread and Residual Gains Lease income accrues on average receivables plus the average residual asset, reflecting the full net investment. Servicing fees are charged on average earning assets, while origination fees are recognised in the year of funding under a management-account convention. - Residual gains arise when equipment sells at lease expiry: proceeds less the carrying value released. If the realisation rate falls below the book rate, the model correctly books a loss. - Cohort timing links off-lease equipment to the origination cohort from the matching lease term. ### Funding and Balance Sheet Mechanics Debt is a senior secured warehouse facility sized mechanically at a fixed advance rate against ending earning assets, which avoids circularity between debt, interest and equity. Interest expense is average debt multiplied by an all-in cost of funds, combining a base rate and borrowing spread. - The balance sheet holds cash, net receivables and the residual asset as a balance-sheet item. Equity comprises sponsor capital, cumulative capital calls and retained earnings. - Minimum cash is maintained as a proportion of net receivables and funded through equity when required. ### Cash Flow, Covenants and Practical Use The cash flow statement uses the indirect method. Residual gains recognised in the income statement are reversed out of operating cash flow, with residual proceeds shown as an investing inflow, ensuring the balance sheet balances. - Originations are investing outflows, while amortisation and prepayments are inflows. The model checks leverage against a debt-to-equity covenant and advance rate against a covenant limit, alongside net interest margin, cash floor and portfolio roll checks. - Scenarios are a reserved placeholder, so the template currently runs a base case with named-range inputs available for sensitising. ## Built for asset finance decisions Use this model when you need to evaluate lease vs buy, price new originations, or understand residual value risk across a portfolio of leased assets. ## Handles IFRS 16 and ASC 842 properly A useful leasing model should reflect the correct accounting treatment for both operating and finance leases, including ROU assets and liability schedules. ## Better for structured lease analysis This gives you a cleaner framework for lease pricing and return analysis than a basic amortisation table that ignores residual value and payment structure. ## Built for asset finance decisions Use this model when you need to evaluate lease vs buy, price new originations, or understand residual value risk across a portfolio of leased assets. ## Handles IFRS 16 and ASC 842 properly A useful leasing model should reflect the correct accounting treatment for both operating and finance leases, including ROU assets and liability schedules. ## Better for structured lease analysis This gives you a cleaner framework for lease pricing and return analysis than a basic amortisation table that ignores residual value and payment structure. ## Features - **Residual value tracking:** Monitor asset recovery rates at lease end, factoring in equipment degradation, market demand, and refurbishment investment. - **Portfolio yield analysis:** Calculate weighted average yield across multiple lease cohorts with varying terms, payment profiles, and residual economics. - **Refurbishment and re-lease modeling:** Forecast the cost and time to refurbish off-lease equipment and re-lease into a secondary market at discounted rates. ## Use cases - **Lease pricing and structuring:** Set competitive lease rates and terms that achieve target yield while accounting for residual risk and operating costs. - **Asset portfolio valuation:** Calculate the NPV of an existing portfolio to determine fair market value for sale or securitization. - **Credit and loss mitigation:** Model loss severity on default, including recovery from asset auction, and adjust pricing to cover expected losses. ## Frequently asked questions ### What is a leasing financial model? It is a model used to evaluate asset-backed leases, covering payment structures, accounting treatment, residual values, and investment returns for lessors and lessees. ### What should a leasing model include? It should include lease classification logic, payment schedules, residual value assumptions, ROU asset and liability tracking, and yield calculations. ### Who uses leasing models? Leasing companies, fleet operators, corporate finance teams, and project finance professionals use them for pricing, underwriting, and portfolio analysis. ### Does it support IFRS 16 accounting? Yes. A proper leasing model should handle both operating and finance lease treatments under IFRS 16 and ASC 842 standards. ### Can I model different payment structures? Yes. The model supports step-ups, seasonal holidays, balloon payments, and other structured rent profiles commonly used in asset finance. ## Related templates - [Sale-Leaseback Real Estate Model](https://finamodel.com/templates/sale-leaseback-model)