Become an M&A Analyst: the Complete Skillset
''the best investment you will ever make on yourself''
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.
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.
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.
During this course, you will
Students / Career Changers
Junior Employees
Business Owners/ Entrepreneurs
Ali Ilci
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 PREVIEWLecture 10: Cash-in vs. cash-out
Lecture 11: Financial vs. strategic investors
Section 2 Quiz
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 PREVIEWSection 3 Quiz
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 PREVIEWLecture 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
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 PREVIEWLecture 45: Header and footers
Lecture 46: A potential investor list
Lecture 47: A Company organization chart
Lecture 48: Introduction to balance sheet
Lecture 49: Overview of balance sheet
FREE PREVIEWLecture 50: Current assets
Lecture 51: Fixed assets
Lecture 52: Current liabilities
Lecture 53: Long-term liabilities
Lecture 54: Shareholders' equity
Bonus Lecture: What is non-controlling interest
FREE PREVIEWSection 6 Quiz
Ryanair balance sheet
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
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 PREVIEWSection 8 Quiz
Ryanair statement of cash flows
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 PREVIEWLecture 80: Working capital ratios: Payables turnover
Section 9 Quiz
Starbucks financial statements
Lecture 81: Introduction to financial modeling
Lecture 82: Overview of financial modeling
FREE PREVIEWLecture 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 PREVIEWRevolver
Lecture 94: Interest calculations
Interest calculations
Bonus Lecture: How to use index match to run multiple scenarios?
FREE PREVIEWSection 10 Quiz
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 PREVIEWSensitivity analysis
Lecture 106: Ups and downs of the DCF analysis
Bonus Lecture: Fully diluted shares outstanding
FREE PREVIEWFully diluted shares outstanding
Section 11 Quiz
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 PREVIEWSpread 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
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
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 PREVIEWSum 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 PREVIEWLecture 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