Financial Modelling With Microsoft Exel

Course objectives:
On completion of this programme you will be able to:
-Understand what financial models are and how to use them for decision making and problem solving
-Create your own financial models for many common business situations
-Understand the rules for creating good models
-Know the common problems encountered when building models and how to test your models to confirm their validity
-How to use models to perform what if analyses
Course content:
Introduction to financial models
-What is a model?
-How do we use them?
Spreadsheet basics
-What is a spreadsheet?
-Common functions used for financial modelling
Building your first simple models
-A personal tax calculator
-Simple budget model
The basic principles of modelling
-Model layout
-Handling of assumptions
-Documenting the model
-The logic of the model
Financial control models
-Budgeting
-Costs for decision making
-Project costing
-Bids and quotationsFinancial planning models
-Profit planning
-Cash flow planning
-Balance sheet planning
Internal audit and control models
-Working capital cycle models
-Stock control
Quality control and validation of models
-Common spreadsheet problems
-Testing and validation
-Auditing spreadsheets
What if analysis
Review of Programme
Other Recommended Programmes
-Accounting Budgeting and Forecasting
-Introduction to Strategic Financial Management