Tabellab

Aircraft Leasing by the Numbers: Lease Rate Factors, Maintenance Reserves, Return Conditions, Residual Values & Lessor Returns

See how lessors price and manage aircraft. You will turn values into monthly rents with lease rate factors, collect maintenance reserves per flight hour and cycle, settle return conditions, project residual values, compare a sale-and-leaseback with a new order and measure the lessor's returns, all with fictional aircraft and every cell checked as you go.

8 lessons 8 labs 2.2 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

In this course you work through the numbers of a fictional aircraft lessor step by step. You turn aircraft values into monthly rents with lease rate factors and an age curve, add up flight hours and cycles from utilisation reports with SUMIFS, and escalate maintenance reserve rates per flight hour, cycle and month. You pay shop visits from the reserve accounts with MIN and MAX, settle half-life return conditions in both directions and project residual values on straight-line and declining curves. Finally you compare a sale-and-leaseback with a direct order through IRR and NPV and review lessee concentration, remaining lease term and age with SUMPRODUCT and a chart.

Lessons

  1. The Lease Rate Factor: Monthly Rent as a Share of ValueLab15 min Pro
  2. Utilisation: Flight Hours, Cycles and the Hour-to-Cycle RatioLab15 min Pro
  3. Maintenance Reserves: Rates per Flight Hour, Cycle and MonthLab16 min Pro
  4. Reserve Draws: Paying Shop Visits from the Reserve AccountsLab16 min Pro
  5. Return Conditions: Half-Life and Compensation in Both DirectionsLab16 min Pro
  6. Residual Values: Depreciation Curves and the Value at Lease EndLab16 min Pro
  7. Lessor Returns: IRR and NPV, Sale-and-Leaseback vs Direct OrderLab17 min Pro
  8. Portfolio View: Lessee Concentration, Remaining Term and AgeLab18 min Pro