Course Description

About this course

Become an M&A Analyst: the Complete Skillset is the most detailed and hands on course about M&A advisory skills you can find anywhere online!

This series offers 140+ lectures across 14 sections where everything is done from scratch with an incredible 24 hours of extensive video content. There are also 70+ supporting Excel and PowerPoint documents and 60+ quiz questions.

In this course, we will be covering all the necessary skills to land a job and to survive in the world of M&A advisory.

What are the course requirements?

There is absolutely no prerequisite!

The course will cover everything from scratch with extensive video explanations.

You will need Microsoft Excel and Power Point (in PC or Mac) and to be eager to learn.

Who is this course for?

Ambitious undergraduate and masters students - regardless of major - who want to pursue a career in investment banking/ M&A advisory.

Junior investment bankers, consultants, venture capitalists and equity analysts who want to hone their skills.

Business owners who want to learn about corporate finance and M&A process.

What will you learn?

During this course, you will

  • LEARN what mergers and acquisitions are
  • UNDERSTAND why companies buy each other
  • GET a very good understanding of the entire M&A process with every single document executed at each stage of the deal
  • MASTER Excel and Power Point skills necessary to become a star M&A Analyst
  • READ financial statements
  • UNDERSTAND a company's financial position
  • ANALYSE a company's performance metrics
  • MEASURE a company's financial risk
  • BUILD a financial model from scratch with extremely practical methods
  • CONDUCT a full Discounted Cash Flow valuation
  • CONDUCT a full Precedent Transaction Analysis valuation
  • CONDUCT a full Comparable Companies Analysis valuation
  • UNDERSTAND the advantages and shortcomings of each mentioned valuation methodology
  • MAKE 20+ graphs and charts in Excel that are widely used in M&A presentations
  • MAKE some first class, clean and beautiful presentations

What should you expect from this course?

Students / Career Changers

  • You will be ready to rock any analyst/associate level M&A interview
  • Deliver top notch work when you are recruited as if you have been employed for a few years

Junior Employees 

  • You will get better and faster, eyeing your next promotion

Business Owners/ Entrepreneurs

  • You will get in-depth knowledge about what it really means to buy or sell a business/ asset and how it is actually executed

Instructor

Ali Ilci

Hi everyone my name is Ali and I am a former M&A analyst and later associate who worked on various M&A deals ranging from thirty million up to over a billion dollars.I worked on the sell-side and on the buy-side in deals across 8 countries including the UK, the US, Italy, Spain, France, the Netherlands, Dubai and Turkey. I have deal experience in various industries including power generation, electricity and natural gas distribution, hospitality, food & beverage and tender process of concession assets such as tool roads, ports and marinas.I graduated with a degree in economics and finance from a top-tier university in the UK and started my career in a US based Bulge Bracket investment bank and worked at several institutions before I quit advisory business and moved to buy-side. With days and nights (very, very late nights) of hands on experience for more than 6 years, I will teach you all the necessary skills to land a job on and to survive in M&A Advisory business!

Course curriculum

  • 1

    Section 1: Introduction

  • 2

    Section 2: The World of Mergers & Acquisitions

    • Lecture 2: Introduction to Section 2

    • Lecture 3: What is mergers and acquisitions?

    • Lecture 4: Why do companies buy each other?

    • Lecture 5: What are the main types of mergers and acquisitions?

    • Lecture 6: Friendly vs. hostile takeovers

    • Lecture 7: Defending against hostile takeovers

    • Lecture 8: Case Study: Succesfull hostile takeover

    • Lecture 9: Share vs. asset sale

      FREE PREVIEW
    • Lecture 10: Cash-in vs. cash-out

    • Lecture 11: Financial vs. strategic investors

    • Section 2 Quiz

  • 3

    Section 3: M&A Process

    • Lecture 12: Introduction to Section 3

    • Lecture 13: How the M&A process works?

    • Lecture 14: Origination

    • Lecture 15: Preparation - Part 1

    • Lecture 15: Preparation - Part 2

    • Lecture 16: Marketing

    • Lecture 17: Receiving non-binding offers - Part 1

    • Lecture 17: Receiving nonbinding offers - Part 2

    • Lecture 18: Due diligence

    • Lecture 19: Binding offers, negotiations and selecting winner

    • Lecture 20: Closing

    • Lecture 21: M&A parties and their duties

      FREE PREVIEW
    • Section 3 Quiz

  • 4

    Section 4: Excel for M&A Analysts

    • Lecture 22: Introduction to Excel

    • Lecture 23: Spreadsheets

    • Lecture 24: Rows and columns

    • Lecture 25: Cells

    • Lecture 26: Linking cells

    • Lecture 27: Copy and paste options

    • Lecture 28: Sort and filter data

    • Lecture 28: Sort and filter data

    • Lecture 29: Printing excel files: page layout

      FREE PREVIEW
    • Lecture 29: Printing excel files: page layout

    • Lecture 30: Formulas for M&A analysts: Basic operations

    • Lecture 31: Formulas for M&A analysts: Statistical operations

    • Lecture 32: Formulas for M&A analysts: Conditional statements

    • Lecture 33: Formulas for M&A analysts: Count statements

    • Lecture 34: Formulas for M&A analysts: Database formulas

    • Lecture 35: Formulas for M&A analysts: Text formulas

    • Lecture 36: Formulas for M&A analysts: Financial formulas

    • Lecture 37: Using keyboard shortcuts

    • Excel Keyboard Shortcuts

  • 5

    Section 5: Power Point for M&A Analysts

    • Lecture 38: Introduction to Power Point

    • Lecture 39: View

    • Lecture 40: Texts

    • Lecture 41: Tables

    • Lecture 42: Shapes

    • Lecture 43: Pictures

    • Lecture 44: Slide master

      FREE PREVIEW
    • Lecture 45: Header and footers

    • Lecture 46: A potential investor list

    • Lecture 47: A Company organization chart

  • 6

    Section 6: Balance Sheet

  • 7

    Section 7: Income Statement

    • Lecture 55: Introduction to income statement

    • Lecture 56: Overview of income statement

    • Lecture 57: Revenues

    • Lecture 58: Cost of Goods sold (COGS)

    • Lecture 59: Operating Expenses (OPEX)

    • Lecture 60: Financial income / (costs)

    • Lecture 61: Extraordinary income / (cost)

    • Lecture 62: Tax expenses

    • Bonus Lecture: Earnings per share

    • Section 7 Quiz

    • Ryanair income statement

  • 8

    Section 8: Statement of Cash Flows

    • Lecture 63: Introduction to cash flow statement

    • Lecture 64: Overview of statement of cash flows

    • Lecture 65: Cash flow from operating activities

    • Lecture 66: Cash flow from investing activities

    • Lecture 67: Cash flow from financing activities

    • Bonus Lecture: Connecting 3 statements

      FREE PREVIEW
    • Section 8 Quiz

    • Ryanair statement of cash flows

  • 9

    Section 9: Ratio Analysis

    • Lecture 68: Introduction to ratio analysis

    • Lecture 69: Short-term liquidity ratios: Current ratio

    • Lecture 70: Short-term liquidity ratios: Quick ratio

    • Lecture 71: Debt and long-term liquidity ratios: Debt ratio

    • Lecture 72: Debt and long-term liquidity ratios: Debt to equity ratio

    • Lecture 73: Debt and long-term liquidity ratios: Interest rate coverage ratio

    • Lecture 74: Debt and long-term liquidity ratios: Net debt to EBITDA ratio

    • Lecture 75: Profitability ratios: Return on assets or ROA

    • Lecture 76: Profitability ratios: Return on capital or ROC

    • Lecture 77: Profitability ratios: Return on equity or ROE

    • Lecture 78: Working capital ratios: Receivables turnover

    • Lecture 79: Working capital ratios: Inventory turnover

      FREE PREVIEW
    • Lecture 80: Working capital ratios: Payables turnover

    • Section 9 Quiz

    • Starbucks financial statements

  • 10

    Section 10: Building Financial Models

    • Lecture 81: Introduction to financial modeling

    • Lecture 82: Overview of financial modeling

      FREE PREVIEW
    • Lecture 83: Financial modeling steps

    • Lecture 84: Financial modeling template

    • Financial modeling template

    • Lecture 85: Preparing historical income statement

    • Preparing historical income statement

    • Lecture 86: Preparing historical balance sheet

    • Preparing historical balance sheet

    • Lecture 87: Preparing other historical data

    • Preparing other historical data

    • Lecture 88: Calculating historical ratios

    • Calculating historical ratios

    • Lecture 89: Making assumptions

    • Making assumptions

    • Lecture 90: Income statement projections

    • Income statement projections

    • Lecture 91: Balance sheet projections

    • Balance sheet projections

    • Lecture 92: Creating the statement of cash flow

    • Creating the statement of cash flow

    • Lecture 93: Revolver

      FREE PREVIEW
    • Revolver

    • Lecture 94: Interest calculations

    • Interest calculations

    • Bonus Lecture: How to use index match to run multiple scenarios?

      FREE PREVIEW
    • Section 10 Quiz

  • 11

    Section 11: Disconted Cash Flow Analysis

    • Lecture 95: Introduction to DCF analysis

    • Lecture 96: Overview of DCF analysis

    • Lecture 97: Free cash flows

    • Free cash flows

    • Lecture 98: WACC calculation

    • WACC calculation

    • Lecture 99: PV of projection period

    • PV of projection period

    • Lecture 100: Terminal value

    • Terminal value

    • Lecture 101: PV of terminal value

    • PV of terminal value

    • Lecture 102: Adjusting discount rate for mid-year

    • Adjusting discount rate for mid-year

    • Lecture 103: Implied equity value

    • Implied equity value

    • Lecture 104: Implied share price

    • Implied share price

    • Lecture 105: Sensitivity analysis

      FREE PREVIEW
    • Sensitivity analysis

    • Lecture 106: Ups and downs of the DCF analysis

    • Bonus Lecture: Fully diluted shares outstanding

      FREE PREVIEW
    • Fully diluted shares outstanding

    • Section 11 Quiz

  • 12

    Section 12: Precedent Transactions Analysis

    • Lecture 107: Introduction to precedent transaction analysis

    • Lecture 108: Overview of precedent transaction analysis

    • Lecture 109: Peer universe selection

    • Peer universe selection

    • Lecture 110: Deal related data & financials

    • Deal related data & financials

    • Lecture 111: Spread key ratios and multiples

      FREE PREVIEW
    • Spread key ratios and multiples

    • Lecture 112: Benchmark comparable transactions

    • Benchmark comparable transactions

    • Lecture 113: Determine valuation

    • Determine valuation

    • Lecture 114: Ups and downs of precedent transactions analysis

    • Section 12 Quiz

  • 13

    Section 13: Comparable Companies Analysis

    • Lecture 115: Introduction to comparable companies analysis

    • Lecture 116: Overview of comparable companies analysis

    • Lecture 117: Peer universe selection

    • Peer universe selection

    • Lecture 118: Data & financials of comparables

    • Data & financials of comparables

    • Lecture 119: Spreading key ratios and multiples

    • Spreading key ratios and multiples

    • Lecture 120: Benchmark comparable companies

    • Benchmark comparable companies

    • Lecture 121: Determine valuation

    • Determine valuation

    • Lecture 122: Ups and downs of comparable companies analysis

    • Bonus Lecture: Valuation material

    • Valuation material

    • Section 13 Quiz

  • 14

    Section 14: Preparing Presentations

    • Lecture 123: Introduction to presentations

    • Lecture 124: Excel: What are we going to build?

    • Lecture 125: Column charts

    • Column charts

    • Lecture 126: Bar charts

    • Bar charts

    • Lecture 127: Pie charts

    • Pie charts

    • Lecture 128: Line charts

    • Line charts

    • Lecture 129: Scatter charts

    • Scatter charts

    • Lecture 130: Bubble charts

    • Bubble charts

    • Lecture 131: Sum of parts charts

      FREE PREVIEW
    • Sum of parts charts

    • Lecture 132: Charts with two vertical axis

    • Charts with two vertical axis

    • Lecture 133: Power Point: What are we going to build?

      FREE PREVIEW
    • Lecture 134: Preparing a teaser - Company overview page

    • Lecture 135: Preparing a teaser - Key investment highlights page

    • Lecture 136: Preparing a teaser - Brands and products page

    • Lecture 137: Preparing a teaser - Key financials page

    • The End