London, 11-13 Dec 2019

3 day Masterclass

Aircraft Lease Modelling



The workshop is designed to demonstrate the benefits of best practice in Excel modelling by building an aircraft lease model in stages, showing how the financial theory can be integrated into the modelling framework. In particular the workshop builds the individual cash flows, calculates the returns and provides clear reporting and analysis.

Learn bulb

learn from the best

Experienced trainers share industry best practice for model design and structure

Learn bulb

get practical

Apply financial mathematics for financial analysis in aviation

Learn bulb

gain strategic advantage

Use effective models to support decision making in your business


The workshop is taught using formal lectures combined with a practical and interactive case study and exercises to reinforce the concepts covered in each teaching session.  Emphasis is placed on delegates gaining practical, hands-on experience of the construction of flexible financial models in Excel.

Comprehensive product notes and modelling software will be provided for future reference.  Delegates receive a full pack of Excel software and templates for future reference as part of the course materials.


book today saving £320

In just 3 days you will:

  • Gain a comprehensive overview of financial modelling for leasing
  • Recognise the key steps to lease model design and structure
  • Exercise applied financial mathematics for aviation
  • Understand pricing theory
  • Using cash flows to support a variety of financing structures
  • Understand the tools and methods on how to audit and test the risk analysis

Meet your instructor

Alastair Day teaching Aircraft Lease Modelling for Terrapinn Training

Alastair is a finance professional with extensive experience of financial modeling, finance, and leasing. Alastair was previously a director of a start-up structured finance company, which grew rapidly and was subsequently sold to a public company.

Later, Alastair established Systematic Finance as an independent consultancy to concentrate on assignments in structured finance, leasing and financial model development.

Past projects have included investment analysis, debt restructuring, valuation, aircraft leasing, power and project finance models prepared for a variety of clients. In addition, Alastair designs and delivers courses covering financial modeling, credit analysis, and equipment leasing.

He is the author of standard modeling textbooks such as Mastering Financial Modelling, Mastering Risk Modelling, Mastering Cash Flow and Valuation Modelling and Mastering Financial Mathematics in Excel, together with a number of leasing and credit books.

Alastair has a degree in German and Economics from London University and an MBA. He has held positions as an associate lecturer at the OUBS and the ifs University College (Chartered Institute of Bankers).

Organisations that will benefit:

  • Airlines
  • Aviation Authorities
  • Financial Institutions
  • Leasing Companies
  • Banks & Investors
  • Private Equity & Hedge Funds
  • Suppliers
  • Lawyers
  • Governments & Regulators
  • Transport Ministries

Who will attend:

  • C-Level Executives: CEO's, CFO's, COO's
  • Financial Managers, Controllers & Analysts
  • Aircraft analysts
  • Credit Managers
  • Risk Managers
  • Corporate Finance
  • Leasing Managers

Course Agenda

  • Overview
  • Exercise: analysing examples of modelling techniques
  • Model Design
  • Exercise: starting case model
  • Financial Mathematics and Pricing
  • Exercise: building examples
  • Revenue Cash Flow
  • Exercise: calculating revenue
  • Maintenance Cash Flow
  • Exercise: calculating maintenance cash flow
  • Lease Cash Flow
  • Exercise: completing lease cash flow
  • Accounting Statements
  • Exercise: completing accounting statements
  • Initial Results
  • Exercise: producing single point answers
  • Auditing & Testing
  • Exercise: testing course model
  • Risk and Sensitivity
  • Exercise: adding sensitivity to course model
  • Targeting and Optimisation
  • Exercise: checking and improving model outcomes
  • Practical - Reporting and Model Completion
  • Exercise: completing course model for reporting
  • Questions and answers
  • Wrap Up

For further information please call: +44 (0)207 092 1045

The earlier you book, the more you save…

Additionally, VAT may be applicable depending on course location.
Before 1 Nov 2019Before 22 Nov 2019After 22 Nov 2019
Save £320
Save £160
  • “The depth and knowledge of my trainer was extremely impressive. In 3 days I have had, without a doubt, a masterclass on the industry. Truly world class.”

    - Gordon Dowall Potter, Past Delegate

  • “Well worth 3 days of study!”

    - Syed Hamza, Past Delegate

  • “The training was excellent! I give it a 10 and will get my trainer's support for my next challenges.”

    - Head of Partnerships & Customer Loyalty at Avis Budget, Past Delegate

  • “Extremely constructive course with a very good dynamic and passionate trainer.”

    - Managing Director at BNP Paribas, Past Delegate

  • “Impressive and cooperative trainer who wanted to make sure the delegates understood.”

    - Budgeting, Planning & Reporting Manager, Past Delegate


We can come to you too! If you have a team of six or more, why not hold a private course? Our experts come to you and the course is tailored to your requirements.

Call +44 (0)20 7092 1045 (United Kingdom)
or (Asia Pacific)
for more details


Sign up for our Monthly Course Calendars