How to build and use a financial model for a project from debt perspective and understand the difference as well as additional requirements in models made from equity perspective
About the best practices as well as pitfalls and challenges in building financial models including excel functions
How to use the model to do sensitivity analysis using single variable and how to choose sensitivities
From real-life case studies including greenfield & stressed projects
The objective of this training is to help the participants
Master the steps in building an accurate financial model through hands-on exercises
Understand the constituents and complexities of a financial model
Learn how to make basic macros and break circularities
Learn the techniques of fundamental analysis using financial modelling
Build basic knowledge of sensitivity analysis
Understand the changes in approach while developing a model for greenfield & stressed projects
The programme will benefit
Professionals responsible for project appraisal from banks and financial institutions
Professionals from corporate finance/ projects division of corporates / ARCs/Special Situation Funds
Financial Intermediaries involved in syndication of project finance
Project finance consultants
Debt Restructuring Firms
Pre-requisite
Basic understanding of finance and/or project finance (should be comfortable with financial statements)
Basic working knowledge of Excel (should be comfortable with simple excel formulae and excel menu)
Participants will be required to work on their laptop during the programme