Financial Modelling With Microsoft Exel
-
Wonderful people and proper VETS care was done.
← | →
-
They are known for maintaining good work culture, benefits are amazing and overall a great experience.
← | →
-
People were passionate and I am fortunate enough to work with such group of people.
← | →
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
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. Suitable for: This programme is for you if you are involved in business or financial planning, budgeting or forecasting and would like your computer to take the strain. Even if you have never used a spreadsheet before, it will show you how to build professional models for a variety of tasks. The programme includes presentations, discussions and computer based hands on modelling sessions.
Facilities
Location
Start date
Start date
Reviews
-
Wonderful people and proper VETS care was done.
← | →
-
They are known for maintaining good work culture, benefits are amazing and overall a great experience.
← | →
-
People were passionate and I am fortunate enough to work with such group of people.
← | →
Course rating
Recommended
Centre rating
Student reviewer
Student reviewer
Billi Smith
Emma Turner
Course programme
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
Financial Modelling With Microsoft Exel