Companies Home Search Profile

Finance & Accounting for Management Consultants and Analysts

Focused View

Asen Gyczew

4:17:59

15 View
  • 001 What the course will be about.mp4
    02:06
  • 002 A little bit about me.mp4
    01:47
  • 003 How this course will be organized.mp4
    02:43
  • 004 How to deal with Blurry image.mp4
    02:04
  • 005 How to reach additional resources.mp4
    01:05
  • 001 Essential-Finance-Accounting-v19-upload-version.pdf
  • 001 Profit & loss statement Introduction.mp4
    01:50
  • 002 3 financial statements.mp4
    03:07
  • 003 What is the role of P&L.mp4
    01:51
  • 004 Revenue General division.mp4
    02:25
  • 005 Revenue Case study Introduction.mp4
    01:15
  • 006 Income-statement-burger-chain-empty.xlsx
  • 006 Revenue Case study Data Available.mp4
    00:49
  • 007 Income-statement-burger-chain-revenue.xlsx
  • 007 Revenue Case study Solution.mp4
    01:26
  • 008 Costs general division.mp4
    01:41
  • 009 Costs Case study Introduction.mp4
    01:09
  • 009 Income-statement-burger-chain-revenue.xlsx
  • 010 Costs Case study Solution.mp4
    01:25
  • 010 Income-statement-burger-chain-costs.xlsx
  • 011 P&L General structure.mp4
    03:43
  • 012 Income-statement-burger-chain-costs.xlsx
  • 012 P&L Case study Introduction.mp4
    00:46
  • 013 Income-statement-burger-chain-all.xlsx
  • 013 P&L Case study Solution in Excel.mp4
    03:17
  • 014 P&L Case study Solution in Power Point.mp4
    01:53
  • 015 P&L Alternative names for profits.mp4
    01:36
  • 016 Division of operating Expenses by type of costs.mp4
    04:09
  • 017 Division of operating Expenses by stages.mp4
    02:47
  • 018 COGS alternative names.mp4
    01:43
  • 019 What is Gross Profit Margin.mp4
    02:21
  • 020 What is Net Margin.mp4
    01:38
  • 021 Gross Profit Case study Introduction.mp4
    00:37
  • 022 Gross Profit Case study Data Available.mp4
    02:08
  • 022 Gross-Margin-burger-chain-Empty.xlsx
  • 023 Gross Profit Case study Solution in Excel.mp4
    02:00
  • 023 Gross-Margin-burger-chain-Solution.xlsx
  • 024 Gross Profit Case study Solution in Power Point.mp4
    01:53
  • 025 Amazon-AR-2018.pdf
  • 025 P&L example Amazon.mp4
    02:49
  • 026 Disney-AR-2018.pdf
  • 026 P&L example Disney.mp4
    02:33
  • 027 P&L example P&G.mp4
    02:19
  • 027 P-G-AR-2018.pdf
  • 028 LPP-3-Q-2018.pdf
  • 028 P&L example LPP.mp4
    01:37
  • 029 Depreciation Amortization a weird cost.mp4
    02:26
  • 030 Depreciation Amortization Short example.mp4
    04:27
  • 030 Depreciation-truck-Empty.xlsx
  • 031 Depreciation Amortization Short example Excel.mp4
    02:34
  • 031 Depreciation-truck-Solution.xlsx
  • 032 Depreciation Amortization Case study Introduction.mp4
    01:18
  • 033 Financial-model-after-intangibles-END.xlsx
  • 033 Financial-model-after-other-BEG.xlsx
  • 033 Intangibles modeling of gross value, net value and depreciation.mp4
    04:47
  • 034 Financial-model-after-other-BEG.xlsx
  • 034 Machinery modeling of gross value, net value and depreciation.mp4
    01:51
  • 035 Depreciation Amortization Summary of the Case study.mp4
    01:20
  • 035 Financial-model-after-Machinery-END.xlsx
  • 035 Financial-model-after-intangibles-BEG.xlsx
  • 036 EBITDA definition.mp4
    01:42
  • 037 Why people look at EBITDA.mp4
    03:28
  • 001 Modeling of Profit & loss statement for FMCG Firm Introduction.mp4
    01:32
  • 002 FMCG-business-model-v5-upload-version.pdf
  • 002 Introduction to the FMCG Business Model.mp4
    00:51
  • 003 Things that matter in FMCG Business Model.mp4
    03:01
  • 004 Introduction to modeling FMCG Services in Excel.mp4
    00:32
  • 005 Drivers for FMG business model.mp4
    01:52
  • 006 FMCG business model in Excel - Basic assumptions and Sales.mp4
    02:26
  • 006 FMCG-business-modelsv2.xlsx
  • 006 FMCG-business-models-with-WorkCapv4.xlsx
  • 007 FMCG business model in Excel - Fixed and Variable Production Costs.mp4
    03:25
  • 008 FMCG business model in Excel - Gross Margin.mp4
    02:17
  • 009 FMCG business model in Excel - Selling & Marketing Costs and Net Margin.mp4
    02:44
  • 010 FMCG business model in Excel - Net Margin.mp4
    01:44
  • 011 FMCG business model in Excel - Head Office costs.mp4
    00:56
  • 012 FMCG business model in Excel - P&L.mp4
    02:23
  • 001 Balance Sheet Introduction.mp4
    00:57
  • 002 What is a Balance Sheet.mp4
    02:23
  • 003 Balance Sheet elements.mp4
    03:21
  • 004 Non-current assets General overview.mp4
    03:06
  • 005 Current assets General overview.mp4
    02:45
  • 006 Equity Main sources.mp4
    01:49
  • 007 Equity Share prices.mp4
    02:53
  • 008 Equity General overview.mp4
    01:37
  • 009 Non-current liabilities General overview.mp4
    02:36
  • 010 Current liabilities General overview.mp4
    01:41
  • 011 Balance Sheet Short Exercises Introduction.mp4
    02:46
  • 012 Balance Sheet Short Exercises Data Available.mp4
    03:23
  • 012 Balance-sheet-exercises-cerami-tiles-producer-empty.xlsx
  • 013 Balance Sheet Short Exercises Solution Part 1.mp4
    04:21
  • 013 Balance-sheet-exercises-cerami-tiles-producer-Solution-Part-1.xlsx
  • 014 Balance Sheet Short Exercises Solution Part 2.mp4
    03:34
  • 014 Balance-sheet-exercises-cerami-tiles-producer-Solution-Part-2.xlsx
  • 015 Accrual accounting.mp4
    03:42
  • 016 Prepayments Short Exercises Introduction.mp4
    00:56
  • 017 Prepayments Short Exercises Data Available.mp4
    01:09
  • 017 Prepayments-Empty.xlsx
  • 018 Prepayments Short Exercises Solution.mp4
    02:53
  • 018 Prepayments-Solution.xlsx
  • 019 Amazon-AR-2018.pdf
  • 019 Balance Sheet example Amazon.mp4
    03:53
  • 020 Balance Sheet example Disney.mp4
    03:02
  • 020 Disney-AR-2018.pdf
  • 021 Balance Sheet example P&G.mp4
    03:41
  • 021 P-G-AR-2018.pdf
  • 022 Balance Sheet example LPP.mp4
    03:20
  • 022 LPP-3-Q-2018.pdf
  • 022 LPP-databook-4Q18.xlsx
  • 001 Cash Flow Introduction.mp4
    00:51
  • 002 What is the purpose of Cash Flow.mp4
    03:21
  • 003 3 parts of Cash Flow.mp4
    01:50
  • 004 Cash Flow from Operating Activities.mp4
    04:19
  • 005 Cash Flow from Investing.mp4
    01:13
  • 006 Cash Flow from Financing.mp4
    02:06
  • 007 Amazon-AR-2018.pdf
  • 007 Cash Flow statement example Amazon.mp4
    04:07
  • 008 Cash Flow statement example Disney.mp4
    03:34
  • 008 Disney-AR-2018.pdf
  • 009 Cash Flow statement example P&G.mp4
    04:06
  • 009 P-G-AR-2018.pdf
  • 010 Cash Flow statement example LPP.mp4
    04:17
  • 010 LPP-3-Q-2018.pdf
  • 010 LPP-databook-4Q18.xlsx
  • 001 Financial analysis of indicators Introduction.mp4
    02:15
  • 001 KPIs-for-Management-Consultants-v14-upload.pdf
  • 002 Profitability ratios Overview.mp4
    04:35
  • 003 Finacial-ratio-analyses-Amazon-Empty.xlsx
  • 003 Profitability ratios Case Study Data Available.mp4
    01:38
  • 004 Finacial-ratio-analyses-Amazon-Profitability.xlsx
  • 004 Profitability ratios Case Study Solution.mp4
    02:28
  • 005 ROE Decomposition.mp4
    03:46
  • 006 Liquidity ratios Overview.mp4
    02:50
  • 007 Finacial-ratio-analyses-Amazon-Liquidity.xlsx
  • 007 Liquidity ratios Case Study Solution.mp4
    02:32
  • 008 Activity ratios Overview.mp4
    04:04
  • 009 Activity ratios Case Study Solution.mp4
    02:29
  • 009 Finacial-ratio-analyses-Amazon-Efficiency.xlsx
  • 010 Debt ratios Overview.mp4
    02:39
  • 011 Debt ratios Case Study Solution.mp4
    01:54
  • 011 Finacial-ratio-analyses-Amazon-Solution.xlsx
  • 001 Valuation Case study Introduction.mp4
    01:21
  • 002 Introduction to Valuation.mp4
    02:16
  • 003 Introduction to DCF method.mp4
    02:25
  • 004 Difference between FCFF and FCFE.mp4
    02:13
  • 005 DCF method of valuation applied to FCFF.mp4
    03:42
  • 005 Financial-model-Finished-versionv10.xlsx
  • 006 DCF method of valuation applied to FCFE.mp4
    01:59
  • 007 Introduction to using multipliers for valuation.mp4
    02:56
  • 008 Enterprise to EBIT or EBITDA.mp4
    04:08
  • 009 Financial-model-Finished-versionv10.xlsx
  • 009 Financial-model-course-all-slides.pdf
  • 009 Financial-model-course-assumptions.pdf
  • 009 Price per Earning multiplier.mp4
    02:09
  • 001 Bonus Lecture.html
  • Description


    A practical guide that will help you understand financial statements & do financial analyses during consulting projects

    What You'll Learn?


    • 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 is this for?


  • Management Consultants
  • Business Analysts
  • Startups founders
  • Managers
  • Students who want to refresh their knowledge about Finance & Accounting
  • Students without MBA / business school education
  • What You Need to Know?


  • Basic or intermediate Excel
  • More details


    Description

    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 conclusions about a specific company. This is especially true during due diligence, strategic projects, and turn-arounds. Financial analyses require a relatively good understanding of finance and accounting. Business Analysts and Management Consultants who 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 on how to do certain analyses 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 and businesses. 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 the 80/20 rule and I want to teach you the most useful (from a business analyst/consultant perspective) things that will enable you to understand the financial data and analyze them.

    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 out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in 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 224 000 students including people working in EY, 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, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and 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 modifications, 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 School and sometimes struggled 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 who studied finance & accounting at university/college 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 financial statements, analyze them, and draw conclusions from them. You will also master the basics of 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 who did not finish business school or Economics.

    In what way will you benefit from this course?

    The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve your knowledge of finance and accounting. There is little theory – mainly examples, and 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 questions through the discussion field or by messaging me directly.

    How the course is organized?

    The course is divided into the following sections:

    • Introduction. We begin with a little intro to 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 the profit & loss statement (P&L). I will show you step by step all the elements of the profit and loss statement. We will also look at examples of P&Ls for firms like Amazon, Disney, P&G, and LPP. We will devote a lot of time to depreciation and amortization

    • Modeling of Profit & Loss Statement for FMCG Firm. In this section, I will show you an example of how to model the profit & loss statement in Excel for the 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 every element of the Balance Sheet. We will also discuss the difference between the USA and European balance sheets. We will also look at examples of balance sheets for firms like Amazon, Disney, P&G, and LPP.

    • Cash flow statement/statement of cash flows. In this section, I will concentrate on the last financial statement – the cash flow. I will show you step by step all elements of cash flow. We will also look at examples of cash flows for firms like Amazon, Disney, P&G, and 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, and 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 evaluating 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 also be able to download many additional resources

    1. Excels with analyses shown in the course

    2. Presentation of slides shown 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 the financial statements of a firm, especially income statements, balance sheets, and cash flows

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

    • Analyze in Excel financial indicators and draw conclusions from that

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

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

    • You will master the main bookkeeping/accounting principles

    Who should take this course? Who should not?

    • Management Consultants

    • Business Analysts

    • Startups founders

    • Managers

    • Students who did not finish business school

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

    Who this course is for:

    • Management Consultants
    • Business Analysts
    • Startups founders
    • Managers
    • Students who want to refresh their knowledge about Finance & Accounting
    • Students without MBA / business school education

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    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, marketplacesCountries: Poland, Serbia, Russia, Ukraine
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 106
    • duration 4:17:59
    • English subtitles has
    • Release Date 2024/02/03