Basic Financial Modelling and Forecasting

Improve decision making with advanced modelling techniques! Build more powerful and more accurate forecasting models to better analyse financial data, predict revenues and Fees, assess risks - and justify critical business decisions.

How You Will Benefit

•    Creating effective financial models that meet your business needs.
•    Learning how to quantify the uncertainty inherent in forecasting models with risk analysis techniques.
•    Making better, more profitable business decisions using advanced financial modeling methods.
•    Knowing how to evaluate patterns in your historical data.
•    Identifying and utilizing key business drivers and integrate them into your forecast.
•    Effectively communicate the results of your models to colleagues and senior management.

Course Highlights:

•    Introduction and overview of Financial Modelling
•    Time value models
•    Financial analysis models
•    Financial ratio analysis models

•    Using regression models to project financial statements
•    Models for valuation of stock
•    Comprehensive models
•    Putting it all together

What will be covered?

•    Working with advanced Excel modelling techniques such as simulation add-ins
•    Creating your own model from real-world examples
•    Analyzing and applying diagnostics to validate your forecast 
•    Understanding how Monte Carlo simulations handle uncertainty

Duration:  3 days
Lagos: Apr 20-22, Sept. 6-8
Fee: N 150,000