This 3-day course covers:
- Best financial modelling practice
- Revenue and cost build-ups
- Taxes, interest and fee calculation
- Leverage, risk and the debt/equity equation
- Modelling multiple drawdowns
- Multiple currency modelling
- Inflation/escalation factors
- Derivation of ratios
- Risk reviews
The principal aim of the course is enable participants to create, use and analyse a project finance model. These skills can be used to support credit approvals and reviews by lenders and to support organisations which run or sponsor projects. This will be done by reviewing best practice in model structures and logic, and using tools to highlight areas of risk, particularly in sensitivity analysis.
The learning methods used are practical, as practice of newly-learned techniques enables a deeper and more effective building of skills. Each section will be covered briefly as a module in a traditional class style, but the real learning experience will be found in the PC-based exercises within each module.
Suggested solutions to each exercise will be provided and discussed, and participants will be encouraged to review their work independently. As the time available is limited, and the needs of the participants will vary, each section will not be covered in depth, but supporting materials will be available for further in-depth learning according to participants' own needs.
All attendees must be familiar with the use of Excel spreadsheets for financial modelling purposes. Delegates are likely to be working with an existing PF model which requires updating or refining.