Their focus is on the forward forecasting of an integrated set of financial statements (income statement, cash flow statement and statement of financial position). There are a range of courses offered in this area, but core are Financial modelling – introduction and Financial modelling - comprehensive. The modelling training courses offered by BPP Professional Development provide numerous golden rules and top tips which, if applied with discipline and rigour, will always result in high quality financial models. be dynamic and flexible: easy to trace changing inputs through to the outputs.It seems obvious, but a high quality financial model will: A poorly built model can not only result in the wrong answer, but will often lead to incorrect decision making. So how can a 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.

So what if we take the train? What if we eat at the café 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 day to run. So if you are organising a school outing to a castle, you might build a simple model to work out the total cost based on the number of children, the distance driven, the cost of entry to the castle, and any other assumptions that would impact the cost.ĭone correctly, this would tell you the total cost of the outing, but the real value of the model is in the scenario analysis that can be performed once the model is built. 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. 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).

Our 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. Maybe you are aware of these facts, but have you ever thought of doing something about it? Not only that, but unless you are a professional Excel user, then you are probably using less than 5% of its functionality. However, as with all of these modern IT applications, there is the right way to use it, and the wrong way. It is a tool that has been around for years and has evolved in such a way that it is now one of the indispensable tools of office life. Whatever your area of work, it is difficult to get by these days without using excel.

Financial modelling course