This two-day workshop explores:
The 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.
What participants will gain:
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
|Training Course||Training Course Summary|
|Leveraged Loans in Private Equity and Corporate Transactions||Get an overview of the market trends affecting corporates and PE borrowers|
|The Structuring & Negotiating Mezzanine, PIK, Second Lien And Unitranche Course||This structured debt course is designed to give insight to the structuring & negotiating of mezzanine, PIK, second lien and unitranche elements involved with corporate finance and debt principles.|