Finance & Accounting for Management Consultants and Analysts

What is the aim of this course?

During many consulting projects you will have to analyze financial statements (balance sheet, income statement, cash flows) and draw conclusion about specific company. This is especially true during due diligence, strategic projects and turn-arounds. Financial analyses require relatively good understanding of finance and accounting. Business Analysts and Management Consultants that did not study Finance or Business tend to have some problems with navigating this area. This course will help you overcome this problem. Those of you who have finished Business School or Economics will find here a great refresher with a lot of practical tips how to do certain analysis during a consulting project.

This course will help you drastically improve your knowledge and skills in finance and accounting. It is designed for people who are or want to become management consultants, business. In the course you will learn 5 main things:

1. How to read financial statements such as a balance sheet, an income (profit & loss) statement, cash flows

2. How to draw conclusions from financial statements

3. Main principles of accounting

4. How to analyze financial indicators

5. How to estimate the value of the firm / do valuation

I will NOT teach you everything about finance & accounting 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) things that will enable you to understand the financial data and analyze them.

The course is based on my 15 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 Retail, FMCG, SMCG, B2B and services sector that I worked for. On many occasions I had to analyze and model in Excel the business I was responsible for. On the basis of what you will find in this course I have trained over 100 consultants, business analysts and managers who now are CFOs, Investment Directors in PE, Sales and Marketing Directors, Operational Directors, COOs, Directors in Consulting Companies, Supply Chain Directors, Board Members etc. On top of that my courses on Udemy were already taken by more than 51 000 students.

I teach through cases, so most of the lectures are case studies showing some business problems solved in Excel. There will be also overview of main differences between the way data are presented in USA and in Europe. To every lecture you will find attached (in additional resources) the Excels shown in the lecture 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?

Analyzing financial situation of the firm is a fundamental skill in consulting. It helps you understand the current situation of the firm, identify problems and estimate potential savings. Many Management Consultants and Business Analysts did not finish Business Schools and sometimes struggle with some financial analyses. This sometimes puts them at a disadvantage and makes it difficult for them to get promoted. On top of that, many consultants and analysts that did study finance & accounting at university / collage have forgotten some things.

Therefore, I have decided to create this course that will help students understand or refresh the essential elements of finance and accounting. The course will give you the knowledge and insight into real life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know how to understand the financial statements, analyze them and draw conclusions from them. You will also master the basics about valuation.

To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of finance and accounting. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business schools or Economics.

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 your knowledge of finance and accounting. There is little theory – mainly examples, case studies with 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 learn:

1. How to read financial statements such as a balance sheet, an income (profit & loss) statement, cash flows

2. How to draw conclusions from financial statements

3. Main principles of accounting

4. How to analyze financial indicators

5. How to estimate the value of the firm / do valuation

You can also ask me any question either through the discussion field or by messaging me directly.

How the course is organized?

The course is divided currently in 4 sections and I will be adding new sections to address other important issues. Currently you will find the following sections:

• Introduction. We begin with little intro into the course. I will show you here what you can expect from this course and how it is organized

• Profit & loss statement. In the second section I will concentrate on the first financial statement the income statement often called profit & loss statement (P&L). I will show you step by step all elements of profit and loss statement. We will also have a look at examples of P&Ls for firms like Amazon, Disney, P&G, LPP. We will devote a lot of time to the depreciation and amortization

• Modeling of Profit & loss statement for FMCG Firm. In this section I will show you an example how to model the profit & loss statement in Excel for FMCG business model.

• Balance Sheet. In the 4th section I will concentrate on the second financial statement – the balance sheet. As always we will go through each and every element of the Balance Sheet. We will also discuss the difference between the USA and European balance sheets. We will also have a look at examples of balance sheets for firms like Amazon, Disney, P&G, LPP.

• Cash flow statement / statement of cash flows. In this section I will concentrate on the last financial statements – the cash flow. I will show you step by step all elements of cash flow . We will also have a look at examples of cash flows for firms like Amazon, Disney, P&G, LPP.

• Financial analysis of indicators. In this section we will have a look at different sets of financial indicators that you can use to analyze a firm. We will have a look at Profitability ratios, ROE Decomposition (DuPont Model), Liquidity ratios, Activity ratios, Debt ratios. We will also calculate them for Amazon so you can see how to use those ratios in practice.

• Valuation. In the last section we will discuss different methods of valuating the firm (estimating its valuation). We will have a look at the DCF methods as well as the Multiplier methods. We will use a case study to see how these methods work in practice.

  
  

  
  

You will be able also to download many additional resources

1. Excels with analyses shown in the course

2. Presentation of slides show in the course

3. Links to additional presentations and movies

4. Links to books worth reading

At the end of my course, students will be able to…

• Analyze financial statements of a firm especially income statement, balance sheet, cash flows

• Create a model of profit and loss statement (income statement) in Excel

• Analyze in Excel financial indicators and draw conclusion out of that

• Estimate the value of a firm using DCF and multiplier method

• You will understand the main difference between financial statements in USA and Europe

• You will master main bookkeeping / accounting principles

Who should take this course? Who should not?

• Management Consultants

• Business Analysts

• Startups founders

• Managers

• Students that did not finish business school

• Students who want to refresh their knowledge about Finance & Accounting