Aviation Finance Finuas Logo

We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes subject to funding being available

Please click on the following link to check if you meet Jobseekers eligibility criteria;

CLICK HERE TO BOOK NOW

 

Training Provider – Alistair Day, Euromoney

Dates - 15th 16th & 17th October  9.00am to 5.00pm each day

Venue –Jurys Inn Custom House, Custom House Quay, Dublin 1

Cost - €1400.00 per participant: funding applied.

 

Day One

Lease Modelling and Pricing

 

 

 

Module 1

9:00-10:30

Introduction and Overview

 

 

 

-Outline of financial modelling for leasing

 

-Overview of market and lease types

-Examples of Excel financial models

Exercise: Analysing examples of modelling techniques

 

Concepts of spreadsheet best practice

 

Common modelling errors

 

 

 

Break

10:30-10:45

 

 

Module 2

10:45-12:30

Lease Model Design

 

 

 

-Model design and structure – key steps

 

 

Exercise: Defining a model plan for a leasing model

 

-Key Excel methods

 

Exercise: starting a financial calculator

 

 

 

Lunch

12:30-13:30

 

 

Module 3

13:30-15:00

Financial Mathematics

 

 

 

-Basic concepts

 

-Interest rates

 

-Time value of money

 

-Net present value and internal rates

 

Exercise: building examples

 

 

 

Break

15:00-15:15

 

 

13:30-15:00

Module 4

15:15-17:00

Pricing and Structuring

 

 

 

-Review of pricing theory

 

-Calculating lease NPV and IRR

 

-Cost of capital

 

-Return measures

 

Exercise: transforming course model into a pricing model

 

 

 

Questions and answers

17:00-17:30

 

Day Two

 

Cash Flow and Accounting

 

 

 

Module 5

9:00-10:30

Cash Flow 1

 

 

 

-Rental inputs

 

-Time lines, masks and flags

 

-Rental cash flow

 

Exercise: calculating revenue

 

 

 

Break

10:30-10:45

 

 

Module 6

10:45-12:30

Cash Flow 2

 

 

 

-Financing

 

-Final values

 

-Maintenance reserves

 

-Final cash flow

 

Exercise: completing lease cash flow

 

 

 


Lunch

12:30-13:30

 

 

Module 7

13:30-15:00

Accounting Statements

 

 

 

-Income statement

 

-Balance sheet

 

-Integrity checks

 

Exercise: completing accounting statements

 

 

 

Break:

15:00-15:15

 

 

Module 8

15:15-17:00

Initial Results

 

 

 

-Net present value

 

-Internal rates

 

-Modified rates

 

Exercise: producing single point answers

 

 

 

Questions and answers

17:00-17:30

 

 

 

 

Alastair Day

Euromoney Lease Training

 Is a finance professional with extensive experience of treasury and funding activities, risk and portfolio management, business analysis, accounting, taxation and documentation.

In 1983, Alastair joined Technology Group Limited (TGL) where he established the treasury function and organised individual transaction funding together with installing rental receivable and administrative systems for this rapidly expanding leasing company.  In addition, he designed business systems for performance analysis, pricing, deal structuring and evaluation.

As a director of TGL, Alastair was also responsible for managing marketing teams and establishing relationships in new areas and products.  The company grew rapidly and the directors negotiated a sale to a PLC in 1988.

In 1990, Alastair established Systematic Finance plc as an independent lessor and financial consultancy.  At Systematic, he has conducted consulting and contracting assignments on data analysis, portfolio management, debt collection, budgeting and reporting systems.

In addition, Alastair works as a consultant with Euromoney Lease Training designing and delivering tailored courses covering accounting, taxation, pricing, lease evaluation and financial modelling.

Alastair has a degree in German and Economics from London University and an MBA from the Open University Business School specialising in corporate finance, performance measurement and medium term forecasting.

He is the author of Lease and Finance Evaluation and the Euromoney Financial Calculator both of which are published by Euromoney Publications plc and is an associate lecturer with the Open University Business School.

 Skillnets


The Aviation Finance Finuas Network is funded by member companies and the Finuas Network Programme, an initiative of Skillnets Ltd. funded from the National Training Fund through the Department of Education and Skills.

 

Click here for Finuas Network website www.finuas.ie

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

 

 

Skillnets funded from the National Training Fund through the Department of Education and Skills

The Aviation Finance Finuas Network is funded by member companies and the Finuas Networks Programme, an initiative of Skillnets funded from the National Training Fund through the Department of Education and Skills.

Click here for Finuas Network website www.finuas.ie

 


 

Enquire about this course:

Full Name (required)

Your Email (required)

Your Message

Anti-Spam Check:
Please enter the text & numbers as they appear in this image
captcha