| Price: £1480 + UK VAT | |
| Book now | A limited number of discounted Advance Bookings are available, and reductions can be arranged for self-funding students. Please contact Penny for more information. |
| For more information see below or follow booking link | |
For more information please see the course details & agenda, or follow the booking link to the course website.
A number of specialist extension modules will be available as optional additions to the main course, including modelling for PFI/PPP, renewables modelling, exit valuation and multi-currency models. Discounts on the extensions will be offered to anyone booking or already booked on the main course.
Penny Lynch draws on nearly forty years of modelling experience and more two decades of teaching in this field to offer this live on-line modelling masterclass. The course exploits the opportunities offered by online training to provide a highly practical and dynamic program. Detailed methodolgies and overall modelling principles are explained during construction of a generic project finance model, supported by short theory presentations to provide context and highlight key concepts.
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
The live sessions for the course will run on Mondays and Wednesdays between 4PM and 6.30PM UK time, over six weeks plus two additional sessions if required, providing timing flexibility for completion of the course content and allowing recovery in case technical or other issues disrupt any scheduled sessions.
Live workshops will be recorded, and made available on-line to course participants shortly after each workshop. Copies of the course model will be saved at the end of each workshop and at key stages during workshops, and made available for download by participants.
Penelope will also be available to answer questions in a chat room or forum during scheduled 1 hour timeslots twice a week.