DateVenuePrice
| Jan 23 2012 - Jan 25 2012 | Lagos | ₦ 100,000 |  |
| Apr 04 2012 - Apr 06 2012 | Lagos | ₦ 100,000 | |
| Aug 15 2012 - Aug 17 2012 | Lagos | ₦ 100,000 | |
Duration: 2 days
To arrange an alternative date for this course, please select the following: 
Course Overview
When looking at any financial opportunity the ability to perform accurate and realistic analysis is imperative. In today's ever-changing business environment the capability to write simple spreadsheets is not enough. You have to be able to incorporate all the "what if" scenarios and stress any proposal to its limits. A well structured financial model can facilitate and improve the reliability and quality of your decision-making.
Course Objectives
- Understand the different types of financial models and when each should be applied
- Construct financial models making use of a broad range of Excel methods and techniques
- Incorporate elements such as risk, sensitivity, optimisation and forecasting into financial models
- Produce meaningful management reports and charts for communication
Course Outline
- Overview of the modelling process
- The key Excel functions in modelling
- Creating a framework for financial forecasting
- Identifying data patterns and applying time series modelling techniques
- Modelling and forecasting your key business drivers
- Simulating a complete financial forecast: Drilling down to the bottom line
- Dealing with uncertainty
- Weighing approaches to interest rate risk modelling
- Communicating the forecast to management Data visualization techniques
*Course fee is not inclusive of VAT