Financial Modelling exemplified by a project financed transaction
Accurate integrated budgeting requires a systematic approach in order to avoid costly decision-making errors.
Our two or three-day training courses in financial modelling are interactive.
In the theoretical part we will give you a brief overview of project financing and the theoretical foundations of financial modelling (best practice). Besides, you will learn all you need to know about the various worksheets (input sheet, spreadsheets, result sheets, ratios), specific risks of project financing, definition and analysis of performance indicators and receive information on advanced excel applications (e.g. choose or index function).
In the practical part you will prepare your own model on the basis of a case study. You will become acquainted with the sensitivity analysis, with which you can identify the value driver of the model, use the break-even analysis and add additional scenarios to the model to analyse the interdependency of certain inputs.
We will show you specific tools that improve the quality, safety and transparency of a model. Besides, you will become acquainted with the use of macros to avoid circular references.
Financial modelling exemplified by a project financed transaction (2/3 days)
Structured creation of a financing model of your own in Excel on the basis of a case study taking into account theoretical principles to avoid common modelling errors.
"Financial Modeling" is a trainings course offered by Euler Hermes Aktiengesellschaft.