Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Finance & AccountingFinancial Modeling & AnalysisFinancial Analysis

Financial Analysis for Management Consultants & Analysts

A practical guide with case studies and examples of financial analyses done during consulting projects
Rating: 4.9 out of 54.9 (102 ratings)
1,781 students
Created by Asen Gyczew
Last updated 3/2022
English
English [Auto]

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 them

In the course you will learn the following things:

  1. How to do financial analyses in Excel fast and efficiently

  2. How to draw conclusions from the analyses

  3. How to analyze financial statements in Excel

  4. How to use financial indicators

  5. How to model a business in Excel

  6. How to analyze business units of the firm

  7. How to carry out analyses related to M&A

  8. How to evaluate a potential investment in Excel

  9. How to estimate the value of the firm using simple methods

This 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:

  1. How to do financial analyses in Excel fast and efficiently

  2. How to draw conclusions from the analyses

  3. How to analyze financial statements in Excel

  4. How to use financial indicators

  5. How to model a business in Excel

  6. How to analyze business units of the firm

  7. How to carry out analyses related to M&A

  8. How to evaluate a potential investment in Excel

  9. How to estimate the value of the firm using simple methods

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 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 organized

  • General 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 purposes

  • Business 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 analyses

  • Valuation. 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 not

  • Investment 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 resources

  1. Useful frameworks and techniques

  2. Selected analyses presented in the course

  3. Links to additional presentations, articles, and movies

  4. Links to books worth reading

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

  • How to conduct fast and efficiently financial analyses during a consulting project in Excel

  • How to draw conclusions from financial analyses

  • Analyze financial indicators, ratios

  • Do essential firm valuation

  • Analyze investments in Excel

  • Estimate the impact of the M&A activity

  • Create a business model of the firm in Excel

  • Analyze business units

Who should take this course? Who should not?

  • Management Consultants and Business Analysts

  • Managers

  • Financial Controllers

  • Startup Founders

  • Owners of small and mid-sized businesses

  • Investment Directors

What will students need to know or do before starting this course?

  • Basic or intermediate Excel

  • Basic knowledge of economics or finance

  • Basic or intermediate knowledge of finance & accounting

Who this course is for:

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

Instructor

Asen Gyczew
Expert in performance improvement, turnaround and startups
Asen Gyczew
  • 4.5 Instructor Rating
  • 27,056 Reviews
  • 135,039 Students
  • 63 Courses

Expert in performance improvement, scaling businesses, and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 500 million) and startups. I have trained in person over 100 consultants, business analysts, and managers who now are Investment Directors, CEO, Partners in PE and VC funds, Sales and Marketing Directors, Operational  Directors, COO, Directors in Consulting Companies, Supply Chain Directors, Board Members, etc.


Functional experience:
performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence, turn-arounds, PMO; 

 Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending, fashion, toys), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing), foodtech, marketplaces

Countries: Poland, Serbia, Russia, Ukraine 

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.