Course Overview

Join us on Tuesday, April 16, 2024, as we kick off the Project Finance Modelling course. The training will run for eight sessions at three and a half hours each (4 days' worth) and will cover the unique attributes that define and distinguish project finance. The total course price displayed is inclusive of applicable HST.

Course Objectives

This course will give you a hands-on practical opportunity to complete a Wind Farm financing model. With a focus on instructional best practices, this course will cover key project finance concepts such as risk transfer, debt and equity sizing, cash flows and reserves and many more. This course will give you the tools to feel confident to succeed in project finance.

Course Code & Name: Project Finance Modelling (PFM-1172)
Date & time:

This course will run from April 16, 2024, to May 9, 2024, for eight (8) sessions at three and a half hours (3.5) each (a total of 4 days' worth).*

The course will run from 8:30 am to 12:30 pm EST. 

  1. April 16, 2024
  2. April 18, 2024
  3. April 23, 2024
  4. April 25, 2024
  5. April 30, 2024
  6. May 2, 2024
  7. May 7, 2024
  8. May 9, 2024


*Please note if minimum enrollment is not met, the course may be cancelled or postponed to a later date.
Course level: Intermediate / Advanced
Course type:  Virtual Instructor-led Training.
Prerequisites: None
Who should attend: Targeted to those interested in pursuing a career in project and infrastructure finance or gaining a deeper understanding of financial modelling.
Format:
 Interactive lecture, participant discussion and hands-on practical.
Price:

 CAD $3107.50*
*Price is inclusive of applicable HST. 

What you will learn:

  • How to efficiently structure a model and related components with a focus on tab order and layout, model schedules, the model audit tab, and periodicity / granularity considerations. 
  • The implementation of a version control system, including input and scenario management.
  • Techniques to model timing & indexation, advanced date functions and binary / flag modelling structures.
  • How to model the construction period including capital costs, interest during construction, and interim / Substantial Completion payments.
  • Elements of the funding requirement including sources & uses, circularities, and dynamically linking to original data files with active refresh.
  • Types of financing sources & profiles, covering Bond debt, Bank debt and equity.
  • A review of depreciation including building efficient and compact depreciation pools.
  • How to model the operations period covering revenues, expenses and calculating Cash Flows Available for Debt Service (CFADS).
  • How to apply a Cashflow Waterfall to clearly calculate and depict the priority of cash flows post-funding requirement.
  • A review of Taxes, specifically tax-loss carry forwards.
  • How to size debt & equity, including sculpted debt repayment profiles.
  • What is model circularity and the pros and cons of Excel iteration / circuit breakers, as well as the use of macros / VBA. 
  • Elements of reserve accounts, including Debt Service Reserve Account (DSRA), Major Maintenance Reserve Account (MMRA), and Equity Lock-Up Accounts.
  • How to use advanced VBA techniques such as copy-paste macros, and scenario saving / loading. 
  • Financial statements & outputs, with a focus on the income statement, balance sheet and equity Internal Rate of Return (IRR).


What you will receive:

  • All the worksheets, checklists and forms in Microsoft® Excel template format.
  • Complete a Wind Farm financing model and receive detailed feedback on your materials to help improve your output.

Meet your instructor

Managing Director, CognitiveSeven

Glen Bastedo

Glen is the Managing Director of CognitiveSeven Consulting Inc. in Toronto. and is the lead instructor providing advanced financial modelling training to leading investment banks, private equity teams, major project developers and consulting firms. Glen has 20 years of experience providing financial capital and advisory services to public and private infrastructure and general corporate clients in North and South America, Europe and the Middle East.

Project Finance Modelling

Register your spot now to learn how finance, economics and risk theory concepts can be applied to build financial models.

SECURE YOUR SPOT NOW
Project Finance Modelling