Navigator Project Finance - Project Finance Modelling (A)

If you are in investment banking or project/corporate finance at any level of seniority, knowing how to build, adapt or review financial models is crucial to the success of your team and the transaction.

Over two interactive days – you will be working on your own laptop - we take you through the following components

How to build a transparent, flexible and well presented cashflow model

How to layout and build a greenfield project finance model
Structuring calculations in a simple logical manner
Using the Excel environment in an ultra-efficient way
Build a Scenario manager that runs 'all scenarios all of the time'
Debt repayment mechanics from first principles
Construction of a Structured Finance 'friendly' Cash waterfall (without circular references)
Calculation of key Project Finance metrics (DSCR / LLCR)
Transparent calculation of 'Project' and 'Equity' returns NPV and IRR
Using {Arrays} as smart functions.
Continuous and strong emphasis on ultra-efficient and reliable working using 'shortcuts' and 'styles'
Regular discussions on aspects such as what not to model, circular references and model review considerations.
Throughout the course we will demonstrate smart ways to use the Excel environment, and highlight shortcomings of different modelling approaches and Excel settings and functions. The majority of this highly interactive course is spent developing a flexible project finance model, which allows you to take the key techniques away with you. Comprehensive printed notes, Excel files and a handy menu of short-cuts are provided upon arrival.

By balancing the experience of the small number of participants, we ensure that all participants understand each concept before moving on. Typical attendees include analysts, managers, senior managers and Associate Directors from investment banks. We regularly welcome Senior Management and CFOs from the industry, to give them a better understanding of how a solid financial model can assist their company in strategic decisions and negotiations

• < Previous Event
• Next Event >

Comment