Course Overview
This course offers a significant expansion from the introduction to financial modelling course to provide participants with new skillsets to compliment and extend their existing financial modelling base. By completing this course, partipants will learn how to automate and streamline large data flows into financial models using Power Query / M coding language, use VBA to automate tasks and solve special modelling problems. This course is intended for professionals with existing excel skills and financial modelling knowledge but is suitable for both accountants and non-accountants. To attend this course it is essential that all participants have completed the pre-requisit 'Introduction to Financial Modelling' course in advance.
Partipants of this course will build a full debt and equity funded project finance model with integrated financial statements and a complete dashboard analysiing various investor and bank KPIs with the support of the trainer. The financial model will include taxes, working capital analysis and advanced debt modelling techniques.
Course Content
This course will provide a coverage of advanced financial modelling skills and techniques and wiill train participants through building a fully operational project finance model with advanced debt calculations and complimentary data analysis and visualisation skills. The course will cover the following:
- Data feeds (Power Query and M language);
- Sophisticated Fixed assets and depreciation calculations;
- Advanced debt modelling;
- VBA code for automation & advanced modelling problems;
- Comprehensive project finance P&L, Cash Flow and Balance Sheet;
- Advanced sensitivity analysis;
- Advanced scenario analysis;
- Excel KPI dashboard;
- Power BI dashboard building
