Financial Modelling Training at BPP

Financial Modelling Training at BPP

Do you use excel?

Most people whose jobs involve them sitting at a desk will use Microsoft excel from time to time. Many jobs require extensive use of excel, and the ability to use some of the more advanced functionality can be essential. It is a tool that has been around for years and has evolved in such a way that it is arguably now one of the indispensible tools of office life. However, as with all of these modern IT applications, there is the right way to use it, and the wrong way. Not only that, but unless you are a professional excel user, then you are probably using less than 5% of its functionality. Maybe you are aware of these facts, but have you ever thought of doing something about it? The BPP Financial Modelling training courses will not only open your eyes to some incredibly useful excel functionality, but more importantly, how to get the best out of excel. Not only will you be much better able to do your job, but your colleagues will be seeking you out for help and guidance (rather than you having to ask the chap who sits on the other side of the photocopier).

Financial Modelling?

So what is the difference between simply using excel, and Financial Modelling. Financial modelling refers to excel files (models) that clearly derive an answer (output) from a number of assumptions (inputs) via workings. So if you are organising a kids weekend sports team tour, you might build a simple model to work out the total cost based on the number of children, the distance driven, the cost of accommodation, and any other assumptions that would impact the cost. Done correctly, this would tell you the total cost of the tour, but the real value of the model is in the scenario analysis that can be performed once the model is built. So what if we take the train? What if we eat at cafés rather than taking pack lunches? Excel can be used to quickly give you the total cost in any of these circumstances, so you can decide how you want the weekend to run.

The right way vs the wrong way

So how can a BPP training course help you with something that sounds relatively simple? Well, unsurprisingly, there is a wrong way and a right way to go about building these models. A poorly built model can not only result in the wrong answer, but will often lead to incorrect decision making. It seems obvious, but a high quality financial model will:

  • be dynamic and flexible: easy to trace changing inputs through to the outputs
  • not fall apart as the inputs change
  • look professional and easy on the eye

The training courses offered by BPP provide numerous Golden Rules and Top Tips which, if applied with discipline and rigour, will always result in high quality financial models.

BPP Financial Modelling Courses

There are many courses offered by BPP in this area, but at the core is Financial Modelling: Introduction (1 day) and Financial Modelling: Comprehensive (2 days). The focus of both of these courses is the forward forecasting of an integrated set of financial statements (income statement, cash flow statement and statement of financial position). This could be done for many different purposes: budgeting, credit analysis, business planning, financial analysis and many others. On these courses the forecasts are used to value the business, and a sensitivity analysis is performed on that value. For example, how does the value change as the forecast interest rate moves?

The courses are suitable for both accountants and non-accountants, but a basic financial literacy is helpful. The Introduction course is for those concerned about their basic excel skills, and those more confident with using excel could attend the Intermediate straight away (uses a real life company example).

Both courses have been running for many years, evolving with each new version of excel, and invariably receive outstanding feedback.

Financial Modelling Introduction course click here

Financial Modelling Comprehensive course click here

Financial Modelling Advanced (& Introduction to VBA) course click here

Debt Modelling (with LBO) course click here

To find out more about our in-house training visit the website or email corporatebusinessteam@bpp.com

Leave a comment

*

* required field