Modelling Fundamentals

DATE: 14 November - 15 November

Course Detail

Modelling Fundamentals

DATE: 14 November - 15 November

The Full 2 day course starts with the half day introduction course and builds on the core principals and "SCILS" learnt by building a fully integrated model from scratch. A case study is used to step through the techniques and modules needed to build sophisticated, flexible models. You will benefit most from this course if you have a good grasp of financial fundamentals and are already proficient with Excel. This course is the first step on the road from "Excel wiz" to professional financial modeller and will show you how to get the best out of the spreadsheet as a tool for forecasting and decision making.

What is covered:

This course incorporates the half day introduction course and then applies the principles learnt to build a fully integrated model one step at a time. Applying our best practice principles for modelling, delegates will learn the easy way to build a model that will balance and reconcile. Our case study steps through a project introducing each concept then allowing delegates to build this into their own model, reinforcing the concepts learnt.

We will show you techniques that can be applied to solve most modelling issues. You will return to work equipped to face new modelling challenges using the first practice principles you will learn on the course. At the end of the case study, the final result is a fully integrated model that can act as a reference for your future model build projects.

Course content:

The course starts with the Half day introduction to modelling course content described here and is then followed by explanation, demonstration and hands on exercises for the following:

  • Profit and loss modelling
  • Cash flow forecasting
  • Building a balancing balance sheet
  • Dealing with fixed assets and depreciation
  • Timing of cash receipts and debtors
  • Inventory and purchasing
  • Sensitivity analysis

Who should attend this course:

Individuals with a basic grasp of Excel and familiarity with financial principles. If you are looking for a good grounding in modelling this course will be suited to you with the course culminating in a "real life" case study model build.

Required knowledge to sit the course:

Excel and basic accounting

Required tools:

Laptop with Microsoft Excel 2007 onwards (demonstrations will be in Excel 2010)

What you will learn:

By the end of the course each delegate will have built a model with an integrated set of financial statements, a six year forecasting horizon for the case study company, the importance of using good modelling practice principles and the importance of applying a development framework right from the start of any modelling task.

You will have the ability to build financial models which give results quickly, accurately and efficiently whilst retaining control over the spreadsheet process. Your models will be clearly structured, more understandable, you will have a clear understanding of what is involved in the development of integrated financial models and have a solid foundation which can be applied to more complex modelling challenges.

Cost: £ 1800 + vat