Leading Advisors in Project Finance

Project Finance Modelling Course2-4 day course

  • Part 1: Project Finance Modelling - Methodology & Techniques (2 day course)

    Learn how to construct a robust project finance model from scratch and use it to assess the feasibility of a project.

    The Project Finance Modelling Methodology & Techniques course is aimed at financial analysts seeking a best practice approach to building a project finance model. Delegates will construct a model to perform a discounted cash flow analysis for the investment decision, and explore the relevant sensitivities, to introduce an overall approach to building models, as well as a number of fundamental techniques and concepts which will prove invaluable in future modelling assignments.

    VAT of 20% is required to be levied for training courses conducted in the United Kingdom. Training courses conducted outside the UK may include local sales taxes, where applicable. The fees below are quoted net of any taxes.

    Date Location Price Register interest
    20-21 November 2017 London £1600
    11-12 December 2017 London £1600
    15-16 January 2018 London £1600
    19-20 Feburary 2018 London £1600
    5-6 March 2018 London £1600
    23-24 April 2018 London £1600

    This course is also available outside of the UK. See our international courses listed under the Combined Course below.

  • Part 2: Project Finance Modelling - Extended Techniques (2 day course)

    Extend the model constructed on the Project Finance Modelling Methodology & Techniques course and explore a range of sophisticated techniques for developing a plan for financing a project.

    Starting with a simple term loan, delegates develop a number of increasingly complex features associated with debt modelling, including grace periods, the cash cascade, debt sculpting, the cash sweep and the debt service reserve account (DSRA). Techniques for handling and managing circularities are explored, as are the concepts and applications of the various debt cover ratios.

    We will expect you to have attended the Project Finance Modelling Methodology & Techniques course before joining this course.

    VAT of 20% is required to be levied for training courses conducted in the United Kingdom. Training courses conducted outside the UK may include local sales taxes, where applicable. The fees below are quoted net of any taxes.

    Date Location Price Register interest
    22-23 November 2017 London £1600
    13-14 December 2017 London £1600
    17-18 January 2018 London £1600
    21-22 February 2018 London £1600
    7-8 March 2018 London £1600
    25-26 April 2018 London £1600

    This course is also available outside of the UK. See our international courses listed under the Combined Course below.

  • Combined Course (4 day course)

    Construct a robust project finance model from scratch and use it to make an investment and financing decision.

    The Project Finance Modelling Combined course is for professionals who wish to complete both the Project Finance Modelling Methodology & Techniques and Project Finance Modelling Extended Techniques course in four intensive days of back-to-back financial modelling.

    On this course we explore both the investment and financing decisions in relation to the project case study, and build a robust model capable of sensitivity and scenario analysis.

    VAT of 20% is required to be levied for training courses conducted in the United Kingdom. Training courses conducted outside the UK may include local sales taxes, where applicable. The fees below are quoted net of any taxes.

    Date Location Price Register interest
    20-23 November 2017 London £3200
    11-14 December 2017 London £3200
    15-18 January 2018 London £3200
    19-22 February 2018 London £3200
    5-8 March 2018 London £3200
    23-26 April 2018 London £3200
    5-8 March 2018 Johannesburg USD$2950

    This course is also available outside of the UK. See our international courses listed under the Combined Course below.

Closed Courses

Where there is demand for multiple delegates from the same firm, it may be better to run a closed course. This is a cost effective method of training participants from the one company, conducted on your chosen date, either at your premises or ours, for up to eight delegates.

Selected course:

captcha

Alternatively, contact on or

Course Details

Who should attend this course

The project finance modelling courses are suitable for anyone seeking to develop their modelling skills. Whether you’re an entry-level graduate or a modeller with several years’ experience, you will learn a trusted modelling methodology and key modelling techniques to aid faster modelling with fewer errors.

Full course program
  • Part 1: Project Finance Modelling - Methodology & Techniques
  • Day 1

    • Model design and construction
      • The top down approach
      • The Principle of Error Reduction
    • Techniques for quick and efficient modelling
      • Keyboard shortcuts
    • Using range names
      • Pros and cons
    • The inflation index
    • The cash flow drivers
      • Production and revenue
      • Variable and fixed costs
      • Working capital
    • Profits and Retained earnings
    • The cash flow and net cash
  • Day 2

    • Cash and overdraft (cash shortfall)
    • Capital expenditure and depreciation
    • Financing and capital structure
    • Interest and dividends
    • Tax losses and the tax calculation
    • Sensitivities and data tables
    • Graphs
    • Investment decision: base case vs expansion case
    • Conclusion and review
  • Part 2: Project Finance Modelling - Extended Techniques
  • Day 1

    • Introduction and revision
      • Case study outline and model
    • Calculating interest
      • The calculation of interest
      • Interest on unpaid interest
    • Peak exposure
      • INDEX and MATCH functions
    • Subordinated debt
      • Deferring interest
      • Deferring repayments
      • Interest on unpaid interest
    • The cash cascade
      • Sources and uses of funds
  • Day 2

    • Ratios
      • Annual debt service cover ratio
      • Loan life cover ratio
      • Project life cover ratio
    • Debt service reserve account
      • Future debt service obligations
      • Movements to and from the DSRA
    • Senior debt
      • Calculating debt requirements
      • Repayment holiday
      • Repayment period mask
    • Cash sweep
      • The circular problem
      • Recognising future cash flows
    • Debt sculpting
      • Restructuring the debt
  • Part 1: Project Finance Modelling - Combined Course
  • Day 1

    • Model design and construction
      • The top down approach
      • The Principle of Error Reduction
    • Techniques for quick and efficient modelling
      • Keyboard shortcuts
    • Using range names
      • Pros and cons
    • The inflation index
    • The cash flow drivers
      • Production and revenue
      • Variable and fixed costs
      • Working capital
    • Profits and Retained earnings
    • The cash flow and net cash
  • Day 2

    • Cash and overdraft (cash shortfall)
    • Capital expenditure and depreciation
    • Financing and capital structure
    • Interest and dividends
    • Tax losses and the tax calculation
    • Sensitivities and data tables
    • Graphs
    • Investment decision: base case vs expansion case
  • Day 3

    • Calculating interest
      • The calculation of interest
      • Interest on unpaid interest
    • Peak exposure
      • INDEX and MATCH functions
    • Subordinated debt
      • Deferring interest
      • Deferring repayments
      • Interest on unpaid interest
    • The cash cascade
      • Sources and uses of funds
  • Day 4

    • Ratios
      • Annual debt service cover ratio
      • Loan life cover ratio
      • Project life cover ratio
    • Debt service reserve account
      • Future debt service obligations
      • Movements to and from the DSRA
    • Senior debt
      • Calculating debt requirements
      • Repayment holiday
      • Repayment period mask
    • Cash sweep
      • The circular problem
      • Recognising future cash flows
    • Debt sculpting
      • Restructuring the debt

Companies we train

"Wish I had this training a lot earlier in my professional career!"
Ginkgo Tree Investment
"A great course taught extremely well. Modelling won’t be the same ever again!"
Ministry of Defence
"Absolutely game changer in how you look at project finance modelling. A must do course to hit the ground running as an investment analyst."
AIIM
"Excellent principles for modelling – if only everyone did it this way!"
African Infrastructure Investment Managers
"If you use Excel regularly, the only reason not to go on this course is if you’ve already been on it. Very useful even if you’re an experienced user."
DfT
"Excellent course for those with little experience in project finance modelling. Great interactive learning of modelling best practice"
BioTherm Energy
"I highly recommend this course to project finance professionals. The training really lifts up the bar of financial modelling skills and fills up any knowledge gaps you have in your tool set."
China Road & Bridge Corporation
"Excellent approach to building model, can definitely use what I have learnt here on a daily basis."
Green Investment Bank
"Extremely useful course that teaches you how to create complex financial models from scratch in a single and accurate manner."
Foresight Group
"From start to finish, the course covers all aspects of Excel and modelling, whilst also not over loading you at the same time."
Sir Robert McAlpine
Contact

Fill in our form and we’ll get back to you:

captcha