Courses / Financial Modelling with MS Excel
Financial Modelling with MS Excel
- Provider
- WWP Training Limited
- Course ID
- FINANMOD
- Summary
- The widespread availability of computer spreadsheets has revolutionised budgeting, forecasting and planning. In the past, financial modelling was something done exclusively by accountants and as a result they had almost total control of financial information. Nowadays many managers are expected to have a much closer control and understanding of the financial performance of their team. This programme shows you how you can combine basic financial knowledge with the power of spreadsheets to develop this closer understanding.
About the Course
- Target
- 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.
- Entry requirements
- Outcome
- 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 - 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 quotations
Financial 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 - Cost
- £900 + VAT
- Enrolment
- Visit the providers website to book online - Email: info@wwp.co.uk
Availability
- Duration
- 2 days
- Timetable
- Contact course provider for details.
- Provider
- WWP Training Limited
Venues/Contact
Second address
24 - 26 Baltic Street West
London
EC1Y 0UR
UNITED KINGDOM
Telephone 01753 857 828
Fax 01753 858 615
Email info@wwp.co.uk
Website www.wwp.co.uk
Contact Notes Please contact the provider to arrange a venue.
Courses
Syndicate
