INTRODUCTION TO PROJECT FINANCE MODELLING

Duration: 2 Days

This course, which we are currently only offering as a private in-house course, is aimed at experienced modellers who use or develop financial models involving project finance.

The primary focus of this course is developing robust and efficient project finance models from a blank workbook applying best practice modelling techniques. Emphasis is placed on managing look-forward circularities (such as debt sizing and DSRAs), other project specific modelling elements (such as debt sculpting and deferred taxes) and model structure (cash waterfall and modular build up approach).

Key topics covered on this course

  • What is project finance and modelling implications therein
  • Model setup (sections, worksheets, order etc.)
  • Inputs and scenario manager
  • Dates and flags
  • Funding requirements, commitment fees and debt sizing
  • Modelling for circularities (VBA)
  • Cash flow waterfall structure and setup
  • Cashflow / balance sheet / income statement interaction
  • Revenue and cost drivers and escalation
  • Capital expenditure, life-cycle costs and depreciation
  • Refinancing, amortisation sculpting and Debt service reserve account (DSRA)
  • Senior debt vs. Sub debt
  • Debt ratios, distributions and lockups
  • Tax calculations, deferred taxes and tax losses

This course is right for you if you have:

  • Intermediate to advanced experience with Excel in a financial environment
  • Understanding of accounting and finance concepts in financial models
  • Existing knowledge of project finance concepts

You don’t need to know:

  • VBA

Ask about training

Other courses coming soon

  • VBA for Project Finance
  • Introduction to Excel
  • Model Review and Audit

Really enjoyed the course, excellent trainer, would recommend to others.

Webster was a wonderful teacher and was apt and eager to answer all our questions.

Webster was a great course instructor and very helpful in every aspect. The course definitely builds confidence in excel and financial modelling and provides you with what you might need when creating your own.

Why choose a JPA course?

  • This is a practical course – get ready to roll up your sleeves and start building a sophisticated integrated 3-way financial model
  • Our presenters are experienced financial modellers who have worked on some of Australia’s biggest infrastructure and M&A transactions
  • Class sizes are limited to maximise your time with the presenters
  • We use real world examples based on our day to day client work, not academic theory