What is the aim of this course?
As a business analysts or a consultant you will have to from time to time create financial models. There are a bit different than business models. In business models you go into details of operations and you focus on getting the links on the KPIs. Those models are usually done for internal purposes, to manage in the right direction the business. Financial models on the other hand are more for external users. You concentrate in them on creating the picture of the business in a standardized, understood by everybody way. You also want to create the financial statements: profit & loss statement, balance sheet statement, cash flow statement.
On top of that you use the financial statements for valuation purposes.
The most typical situation when, as a business analyst or a consultant, you will have to prepare such a model are connected with selling or purchasing a company. You may be doing it on the sell side or on the buy side. Financial modeling is done as a part of strategy projects, turn around projects, due diligence.
I will NOT teach you everything on financial modelling because it is simply not efficient (and frankly you don’t need it). This course is organized around 80/20 rule and I want to teach you the most useful (from business analyst / consultant perspective) ways to go as fast as possible from rough description to working model in Excel that you can make more and more complicated.
The aim of this course is that you are able to do a financial model of the business as fast as possible.
If done properly, this course will transform you in 1 day into pretty good business analyst that knows how to create fast and efficiently financial models. It is based on my 12 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for. On the basis of what you will find in this course I have trained over 100 business analysts who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members etc.
I teach step by step on the basis of Excel files that will be attached to the course. We will go through a real life example of a business and create the financial model for it. To make the best out of the course you should follow my steps and repeat what I do with the data after every lecture. Don’t move to the next lecture if you have not done what I show in the lecture that you have gone through.
I assume that you know basic Excel so the basic features (i.e. how to write formula in Excel) are not explained in this course. I concentrate on intermediate and advanced solutions and purposefully get rid of some things that are advanced yet later become very inflexible and useless (i.e. naming the variables).
To every lecture you will find attached (in additional resources) the Excel shown in the Llcture so as a part of this course you will also get a library of ready-made analyses that can, with certain modification, be applied by you in your work.
Why I decided to create this course?
This course is a part of my attempt to help business analyst and consultants gain fast useful knowledge that will help them excel at their work. I have done 10 other courses that will help you be great business analysts or consultants. I have covered already: hacks and tricks in Excel, business modelling, market research, management productivity hacks and others. Now you have the opportunity to learn financial modeling in Excel
In what way will you benefit from this course?
The course is a practical, step by step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you do the analyses as well as the quality of the conclusions coming out of available in your company data. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:
You can also ask me any question either through the discussion mode or by messaging me directly.
How the course is organized?
The course is divided currently in 10 sections and will be adding new section to address other important issues. Currently you will find the following sections:
You will be able also to download many additional resources
At the end of my course, students will be able to…
Who should take this course? Who should not?
What will students need to know or do before starting this course?