Course Overview
This course offers a comprehensive introduction to financial modelling to ensure that participants are given a complete base in financial modelling with respect to financial modelling best practices and techniques. By completing this course, partipants will gain a solid base in financial modelling and be able to understand how to create financial models and the practices to follow to ensure that they are professional, robust and flexible. This course is intended for professionals at all levels of proficiency in excel, no prior professional training in financial modelling and is suitable for both accountants and non-accountants. It can be advantagous to have completed the 'Business Analysis in MS Excel courses in advance however these are not a pre-requisit of this course.
Partipants of this course will build a full financial model with integrated financial statements and discounted cash flow valuation analysis with the support of the trainer and will test sensitivities and scenarios with changing assumptions. The financial model will include taxes, working capital analysis and techniques for creating dynamic dates, timings and forecasts will also be covered.
Course Content
This course will provide a full coverage of the excel skills, accounting principals and financial modelling techniques required to gain a solid base in building and understanding financial models. The course will cover the following:
- Financial Model Structure and planning a financial model build;
- Financial Model Review / Audit principles;
- Financial Model dates functions and timelines;
- Forecasting techniques and updating actuals;
- Modelling corporate tax and VAT;
- Modelling basic senior debt and interest;
- Completing the P&L, Cash Flow and Balance Sheet;
- Balancing the balance sheet;
- Valuation techniques (inc. discount cashflow); &
- Sensitivity analysisScenario analysis
