Twice-weekly lessons, delivered over a six week period (Mon & Wed, 16.30 to 18.00 BST), with additional Q&A support for students as they work on the course model. All sessions will be recorded and made available to attendees.
The Course will start with a blank Excel spreadsheet and progress through a model build, using the process to explore the fundamental principles of good practice in project finance modelling.
Students have the benefit of live interaction during workshops and the opportunity to re-watch recordings as needed and complete modelling tasks at their own pace.
The workshops will focus on the following topics as we build our model;
Introduction ~ Starting with a blank page ~ Introducing the illustrative project ~ Building a model skeleton ~ Building the construction costs ~ Building the NCF summary ~ Introducing inflation into the model ~ Building the operations calculations ~Preparing for circular calculations ~ Building the base funding calculations ~ Building tax and P&L calculations ~ Building cashflow cascade sheet ~ Cash accounts and dividends ~ Internal rate of return ~ Debt Cover Calculations ~ Case control table ~ Balance sheet ~ Monthly construction calculations ~ Sculpted repayments ~ Cash Sweep ~ Annual Figures ~ Adding Summary Page ~ Using Charts ~ Making a library of results ~ Checking ~ Summary