The modelling for debt restructuring programme is taught using a mixture of instruction, demonstrations and practical exercises. The workshop emphasis concentrates on the application of financial theory to Excel to produce a flexible and informative model.
Each session consists of theory, demonstrations and a practical exercise as participants develop the model in stages. The template for each session acts shows the solution to the previous session.
Comprehensive product notes will be provided to all participants. Participants receive a full pack of Excel software and templates for future reference as part of the course materials.
Each participant will be required to bring a laptop with an available USB running Microsoft Office to the seminar.
Exercise: starting a model template
Exercise: adding and checking accounting statements
Exercise: adding loan sheets and calculating ratios
Exercise: completing initial forecast statements
Exercise: calculating new loans and repayment profiles
Exercise: adding loans to forecast statements and checking cash position
Exercise: layering stress testing on the initial model
Exercise: model completion and final checks