Financial Modelling Using Excel

Course details

• This 40 Hour practical course is designed to equip the participants with a sound financial modelling skills and techniques to prepare and forecast financial statements needed in a modern corporate world. Participants will gain a firm understanding of the modelling process and financial ratios analysis.
• The training is run in small groups ensuring direct interaction with the trainer throughout the whole course and each session is concluded with a practical model building exercise.

• At the end of the training participants will be able to:
  - Build a financial model from a scratch using the best structuring techniques
  - Use efficiently key Excel functions to construct sound financial forecasting models
  - Build interactive excel/VBA dashboards to automate Excel operations
  - Create a forecast income, cash flow statement and balance sheet
  - Interpret and analyse the key ratios used in a financial forecast.