Financial Analysis For Management Consultants & Analysts

A practical guide with case studies and examples of financial analyses done during consulting projects

What you'll learn
How to conduct fast and efficiently financial analyses during consulting project in Excel
How to draw conclusions from financial analyses
Analyze financial indicators, ratios
Do essential firm valuation
Analyze different types of investments in Excel
Estimate the impact of the M&A activity
Estimate the impact of proposed improvements on profit and balance sheet
Create a business model of the firm in Excel
Analyze business units
Requirements
Basic or intermediate Excel
Basic knowledge of economics or finance
Basic or intermediate knowledge of finance & accounting
Description
What is the aim of this course?During many consulting projects, you will have to do a lot of financial analysis and draw conclusions about a specific company or industry. This is especially true during due diligence projects, strategic projects, and turn-arounds. Financial analyses will help you decide which option is better, what investments you should take, estimate potential improvements or estimate the impact on the profit and the balance sheet. On top of that, during consulting projects, you have to do everything 3x faster and with little data. Therefore, I will teach you in this course how to do fast and efficiently financial analyses and how to draw conclusions from themIn the course you will learn the following things:How to do financial analyses in Excel fast and efficientlyHow to draw conclusions from the analysesHow to analyze financial statements in ExcelHow to use financial indicatorsHow to model a business in ExcelHow to analyze business units of the firmHow to carry out analyses related to M&AHow to evaluate a potential investment in ExcelHow to estimate the value of the firm using simple methodsThis course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 124 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.I teach through case studies, so you will have a lot of lectures showing examples of analyses, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, materials shown in the lectures 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 or your team in your work.Why have I decided to create this course?Analyzing the 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 at university/college have forgotten some things.Therefore, I have decided to create this course that will help students understand or refresh how to do financial analyses in Excel. 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 financial data, analyze them and draw conclusions from them. You will also master the essential information related to 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 financial analyses. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business school or Economics. The course will help you become an expert in financial analyses on the level of McKinsey, BCG, Bain, and other top consulting firms. That is why, I highly recommend this course to Managers, Management Consultants, owners/founders of businesses that need better to have a good understanding of the business.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 understand, analyze the businesses. 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 learn:How to do financial analyses in Excel fast and efficientlyHow to draw conclusions from the analysesHow to analyze financial statements in ExcelHow to use financial indicatorsHow to model a business in ExcelHow to analyze business units of the firmHow to carry out analyses related to M&AHow to evaluate a potential investment in ExcelHow to estimate the value of the firm using simple methodsYou 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 into 8 sections. Currently, you will find the following sections:Introduction. We begin with a little intro to the course as well as some general info on how the course is organizedGeneral Analysis of Financial Statements. In the second section, I will show you how to analyze 3 main financial statements: cash flows, profit, and loss statement, and balance sheet.Financial Analysis of Indicators. In this section I will show you how to use financial indicators, ratios to analyze the situation of the firm, especially in comparison with other firms. We will look at profitability, efficiency, liquidity, and debt ratios.Modeling of Profit & Loss statement in practice. In the 4th section, I show you how to model the profit and loss statement of a company in Excel. A business model of the firm you can use to understand the business, forecast future growth, or for valuation purposesBusiness Units Analyses. In the 5th section, we will discuss the analysis of Business Units. Many firms are running more complicated businesses with plenty of business units that you should analyze separately. We will have a look at 2 examples of such analysesValuation. During consulting projects, especially devoted to M&A or due diligence you will have to evaluate a specific business. In this section, I will show you examples of how to do it in practice.Financial Analyses related to M&A. In this section, I will show you how to analyze the different aspects of M&A. Here we will see what is better: organic growth or M&A, how to estimate the impact of M&A on the firm, and how to decide whether to sell a business unit or notInvestment Analyses. In the last section, I will show you how to analyze different investments in the firm. We will look at investments demanded by customers, investments that are supposed to generate savings, and investment in bottlenecks. Different types of investments require a different approach.You will be able also to download many additional resourcesUseful frameworks and techniquesSelected analyses presented in the courseLinks to additional presentations, articles, and moviesLinks to books worth readingAt the end of my course, students will be able to…How to conduct fast and efficiently financial analyses during a consulting project in ExcelHow to draw conclusions from financial analysesAnalyze financial indicators, ratiosDo essential firm valuationAnalyze investments in ExcelEstimate the impact of the M&A activityCreate a business model of the firm in ExcelAnalyze business unitsWho should take this course? Who should not?Management Consultants and Business AnalystsManagersFinancial ControllersStartup FoundersOwners of small and mid-sized businessesInvestment DirectorsWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economics or financeBasic or intermediate knowledge of finance & accounting

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 A little bit about me

Lecture 3 How this course will be organized?

Lecture 4 How to deal with Blurry image

Lecture 5 How to reach additional resources

Section 2: General Analysis of Financial Statements

Lecture 6 General Analysis of Financial Statements – Introduction

Lecture 7 Essential Excel Formulas

Lecture 8 Essential Accounting & Finance

Lecture 9 3 financial statements

Lecture 10 P&L example – Amazon

Lecture 11 Balance Sheet example – Amazon

Lecture 12 Cash Flow statement example – Amazon

Lecture 13 Amazon – Overivew of P&L

Lecture 14 Amazon – Analysis in Excel of P&L

Lecture 15 Amazon – Analysis in Excel of BS

Lecture 16 Amazon – Analysis in Excel of CF

Section 3: Financial Analysis of Indicators.

Lecture 17 Financial analysis of indicators – Introduction

Lecture 18 Profitability ratios – Overview

Lecture 19 Profitability ratios – Case Study – Data Available

Lecture 20 Profitability ratios – Case Study – Solution

Lecture 21 ROE Decomposition

Lecture 22 Liquidity ratios – Overview

Lecture 23 Liquidity ratios – Case Study – Solution

Lecture 24 Activity ratios – Overview

Lecture 25 Activity ratios – Case Study – Solution

Lecture 26 Debt ratios – Overview

Lecture 27 Debt ratios – Case Study – Solution

Lecture 28 More on KPIs

Section 4: Modeling of Profit & Loss statement in practice

Lecture 29 Modeling of Profit & Loss statement in practice – Introduction

Lecture 30 Introduction to retailer business model

Lecture 31 Main challenges in Retail

Lecture 32 Business model of Retailer in Excel - transaction version - 1 store

Lecture 33 Business model of Retailer in Excel - transaction version - retail chain

Lecture 34 Business model of Retailer in Excel - sq m version

Lecture 35 Introduction to the SMCG Business Model

Lecture 36 Things that matter in SMCG Business Model

Lecture 37 Drivers for SMG business model

Lecture 38 SMCG business model in Excel – Basic assumptions

Lecture 39 SMCG business model in Excel – Sales

Lecture 40 SMCG business model in Excel – Fixed and Variable Production Costs

Lecture 41 SMCG business model in Excel – Gross Margin

Lecture 42 SMCG business model in Excel – Selling & Marketing costs

Lecture 43 SMCG business model in Excel – Net Margin

Lecture 44 SMCG business model in Excel – Head Office costs

Lecture 45 SMCG business model in Excel – P&L

Lecture 46 SMCG business model in Excel – Working Capital

Lecture 47 Modeling SMCG business model as a service business – Introduction

Lecture 48 From SMCG to service – Introduction – Part 1

Lecture 49 From SMCG to service – Introduction – Part 2

Lecture 50 From SMCG to service – Case Introduction

Lecture 51 From SMCG to service – If sold as a product

Lecture 52 From SMCG to service – If sold as a service – Part 1

Lecture 53 From SMCG to service – If sold as a service – Part 2

Lecture 54 From SMCG to service – Comparison

Lecture 55 From SMCG to service – Solution in Power Point

Lecture 56 Modeling SMCG business model as a service business – General Remarks

Lecture 57 Modeling SMCG business model as a service business – Head Office costs

Lecture 58 Modeling SMCG business model as a service business – Profit & Loss

Lecture 59 Other financial models

Section 5: Business Units Analyses

Lecture 60 Business Units Analysis – Introduction

Lecture 61 Why analysis of Business Units makes sense

Lecture 62 Overview of Business models

Lecture 63 Analysis of Business Units – Disney – Overall Segment results

Lecture 64 Analysis of Business Units – Disney – Analysis of structure

Lecture 65 Analysis of Business Units – Disney – Media Networks

Lecture 66 Analysis of Business Units – Disney – Parks & Resorts

Lecture 67 Analysis of Business Units – Disney – Studio Entertainment

Lecture 68 Analysis of Business Units – Disney – Consumer Products & Interactive Media

Lecture 69 Analysis of Business Units – Groceries Discounter – Case Introduction

Lecture 70 Analysis of Business Units – Groceries Discounter – Data Available

Lecture 71 Analysis of Business Units – Groceries Discounter – Formats Results Analysis

Lecture 72 Analysis of Business Units – Groceries Discounter – Formats Structure Analysis

Lecture 73 Analysis of Business Units – Groceries Discounter – Region Results Analysis

Lecture 74 Analysis of Business Units – Groceries Discounter – Region Structure Analysis

Lecture 75 Analysis of Business Units – Groceries Discounter – How we did the analyses

Section 6: Valuation

Lecture 76 Valuation Case study – Introduction

Lecture 77 Introduction to Valuation

Lecture 78 Introduction to DCF method

Lecture 79 Difference between FCFF and FCFE

Lecture 80 DCF method of valuation applied to FCFF

Lecture 81 DCF method of valuation applied to FCFE

Lecture 82 Introduction to using multipliers for valuation

Lecture 83 Enterprise to EBIT or EBITDA

Lecture 84 Price per Earning multiplier

Lecture 85 More on Valuation

Lecture 86 How to increase the value of the business

Section 7: Financial analysis related to M&A

Lecture 87 Financial analysis related to M&A – Introduction

Lecture 88 What kind of financial analysis consultants do when it comes to M&A

Lecture 89 Expand via M&A – Plywood – Introduction

Lecture 90 Expand via M&A – Plywood – Solution

Lecture 91 Expand via M&A – Plywood – Calculation in Excel

Lecture 92 Expand via M&A – Plywood – Power Point

Lecture 93 Vertical Consolidation via M&As – Case Introduction

Lecture 94 Vertical Consolidation via M&As – Available Data

Lecture 95 Vertical Consolidation via M&As – Goals we want to achieve

Lecture 96 Vertical Consolidation via M&As – Analysis of M&A Target

Lecture 97 Vertical Consolidation via M&As – Organic growth option

Lecture 98 Vertical Consolidation via M&As – M&A option

Lecture 99 Vertical Consolidation via M&As – Comparison of both options

Lecture 100 Sell non-core assets – Introduction

Lecture 101 Sell non-core assets – Cosmetics – Introduction

Lecture 102 Sell non-core assets – Cosmetics – Solution for the Hotel

Lecture 103 Sell non-core assets – Cosmetics – Solution for the Kindergarten

Lecture 104 More on M&A

Section 8: Investment analyses

Lecture 105 Investment Analysis – Introduction

Lecture 106 Time value of money

Lecture 107 Time value of money – in Excel

Lecture 108 NPV – Introduction

Lecture 109 NPV – How to use it

Lecture 110 IRR

Lecture 111 NPV – How to calculate it in Excel

Lecture 112 Investments – General thoughts

Lecture 113 Replacement Investment – Introduction

Lecture 114 Replacement Investment – Current Costs

Lecture 115 Replacement Investment – Future Costs

Lecture 116 Replacement Investment – NPV

Lecture 117 Replacement Investment – Power Point

Lecture 118 Required by customer investment – Introduction (PET)

Lecture 119 Required by customer investment – Costs

Lecture 120 Required by customer investment – Benefits

Lecture 121 Required by customer investment – NPV

Lecture 122 Required by customer investment – Solution in Power Point

Lecture 123 Investment in bottleneck removal – Introduction

Lecture 124 Investment in bottleneck removal – Costs

Lecture 125 Investment in bottleneck removal – Benefits

Lecture 126 Investment in bottleneck removal – NPV

Lecture 127 Investment in bottleneck removal – Solution in Power Point

Lecture 128 Cost reduction Investment – Retail – Introduction (LED ligths)

Lecture 129 Cost reduction Investment – Retail – Current Costs

Lecture 130 Cost reduction Investment – Retail – Future Costs

Lecture 131 Cost reduction Investment – Retail – NPV

Lecture 132 Cost reduction Investment – Retail – Solution in Power Point

Lecture 133 Cost reduction Investment – Ceramic Tiles – Introduction

Lecture 134 Cost reduction Investment – Ceramic Tiles – Current Costs

Lecture 135 Cost reduction Investment – Ceramic Tiles – Future Costs

Lecture 136 Cost reduction Investment – Ceramic Tiles – NPV

Lecture 137 Cost reduction Investment – Ceramic Tiles – Solution in Power Point

Section 9: Conclusions

Lecture 138 Bonus Lecture

Management Consultants and Business Analysts,Managers,Financial Controllers,Startup Founders,Owners of small and mid-sized businesses