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

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Compute the lease rate factor of six leased aircraft, pool it for the portfolio, read a target factor from an age curve and turn it into the monthly rent of a new deal.
• Add up four months of utilisation reports per aircraft with SUMIFS, compute the flight-hour-to-cycle ratio and the average hours flown per month.
• Escalate the base reserve rates of a fictional lease, pick the right driver for each component, compute this month's reserve per component and the total invoice.
• Work out how much of five shop visits the reserve accounts pay, what is left in each account, where the money runs short and how much the lessor tops up under a cap.
• Measure how much life each component has used at lease end, turn the gap to half-life into compensation in both directions, label who pays and net the bill.
• Project the value of a new aircraft year by year on a straight-line and on a declining curve, read the value at lease end and measure how much of the lessor's inflows depend on that residual value.
• Lay out purchase, rent and sale as a yearly cash-flow row for two deals, compute each deal's IRR and NPV at the hurdle rate and decide which one earns more.
• Group the portfolio value by lessee, find the largest lessee's share, compute the rent-weighted remaining lease term and the value-weighted age, and chart the concentration.