Become an M&A Analyst: the Complete Skillset Course

Become an M&A Analyst: the Complete Skillset

''the best investment you will ever make on yourself''

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. Lecture 1: What this course covers
  FREE PREVIEW
2. Course Glossary
1. Lecture 2: Introduction to Section 2
2. Lecture 3: What is mergers and acquisitions?
3. Lecture 4: Why do companies buy each other?
4. Lecture 5: What are the main types of mergers and acquisitions?
5. Lecture 6: Friendly vs. hostile takeovers
6. Lecture 7: Defending against hostile takeovers
7. Lecture 8: Case Study: Succesfull hostile takeover
8. Lecture 9: Share vs. asset sale
  FREE PREVIEW
9. Lecture 10: Cash-in vs. cash-out
10. Lecture 11: Financial vs. strategic investors
11. Section 2 Quiz
1. Lecture 12: Introduction to Section 3
2. Lecture 13: How the M&A process works?
3. Lecture 14: Origination
4. Lecture 15: Preparation - Part 1
5. Lecture 15: Preparation - Part 2
6. Lecture 16: Marketing
7. Lecture 17: Receiving non-binding offers - Part 1
8. Lecture 17: Receiving nonbinding offers - Part 2
9. Lecture 18: Due diligence
10. Lecture 19: Binding offers, negotiations and selecting winner
11. Lecture 20: Closing
12. Lecture 21: M&A parties and their duties
  FREE PREVIEW
13. Section 3 Quiz
1. Lecture 22: Introduction to Excel
2. Lecture 23: Spreadsheets
3. Lecture 24: Rows and columns
4. Lecture 25: Cells
5. Lecture 26: Linking cells
6. Lecture 27: Copy and paste options
7. Lecture 28: Sort and filter data
8. Lecture 28: Sort and filter data
9. Lecture 29: Printing excel files: page layout
  FREE PREVIEW
10. Lecture 29: Printing excel files: page layout
11. Lecture 30: Formulas for M&A analysts: Basic operations
12. Lecture 31: Formulas for M&A analysts: Statistical operations
13. Lecture 32: Formulas for M&A analysts: Conditional statements
14. Lecture 33: Formulas for M&A analysts: Count statements
15. Lecture 34: Formulas for M&A analysts: Database formulas
16. Lecture 35: Formulas for M&A analysts: Text formulas
17. Lecture 36: Formulas for M&A analysts: Financial formulas
18. Lecture 37: Using keyboard shortcuts
19. Excel Keyboard Shortcuts
1. Lecture 38: Introduction to Power Point
2. Lecture 39: View
3. Lecture 40: Texts
4. Lecture 41: Tables
5. Lecture 42: Shapes
6. Lecture 43: Pictures
7. Lecture 44: Slide master
  FREE PREVIEW
8. Lecture 45: Header and footers
9. Lecture 46: A potential investor list
10. Lecture 47: A Company organization chart
1. Lecture 48: Introduction to balance sheet
2. Lecture 49: Overview of balance sheet
  FREE PREVIEW
3. Lecture 50: Current assets
4. Lecture 51: Fixed assets
5. Lecture 52: Current liabilities
6. Lecture 53: Long-term liabilities
7. Lecture 54: Shareholders' equity
8. Bonus Lecture: What is non-controlling interest
  FREE PREVIEW
9. Section 6 Quiz
10. Ryanair balance sheet
1. Lecture 55: Introduction to income statement
2. Lecture 56: Overview of income statement
3. Lecture 57: Revenues
4. Lecture 58: Cost of Goods sold (COGS)
5. Lecture 59: Operating Expenses (OPEX)
6. Lecture 60: Financial income / (costs)
7. Lecture 61: Extraordinary income / (cost)
8. Lecture 62: Tax expenses
9. Bonus Lecture: Earnings per share
10. Section 7 Quiz
11. Ryanair income statement
1. Lecture 63: Introduction to cash flow statement
2. Lecture 64: Overview of statement of cash flows
3. Lecture 65: Cash flow from operating activities
4. Lecture 66: Cash flow from investing activities
5. Lecture 67: Cash flow from financing activities
6. Bonus Lecture: Connecting 3 statements
  FREE PREVIEW
7. Section 8 Quiz
8. Ryanair statement of cash flows
1. Lecture 68: Introduction to ratio analysis
2. Lecture 69: Short-term liquidity ratios: Current ratio
3. Lecture 70: Short-term liquidity ratios: Quick ratio
4. Lecture 71: Debt and long-term liquidity ratios: Debt ratio
5. Lecture 72: Debt and long-term liquidity ratios: Debt to equity ratio
6. Lecture 73: Debt and long-term liquidity ratios: Interest rate coverage ratio
7. Lecture 74: Debt and long-term liquidity ratios: Net debt to EBITDA ratio
8. Lecture 75: Profitability ratios: Return on assets or ROA
9. Lecture 76: Profitability ratios: Return on capital or ROC
10. Lecture 77: Profitability ratios: Return on equity or ROE
11. Lecture 78: Working capital ratios: Receivables turnover
12. Lecture 79: Working capital ratios: Inventory turnover
  FREE PREVIEW
13. Lecture 80: Working capital ratios: Payables turnover
14. Section 9 Quiz
15. Starbucks financial statements
1. Lecture 81: Introduction to financial modeling
2. Lecture 82: Overview of financial modeling
  FREE PREVIEW
3. Lecture 83: Financial modeling steps
4. Lecture 84: Financial modeling template
5. Financial modeling template
6. Lecture 85: Preparing historical income statement
7. Preparing historical income statement
8. Lecture 86: Preparing historical balance sheet
9. Preparing historical balance sheet
10. Lecture 87: Preparing other historical data
11. Preparing other historical data
12. Lecture 88: Calculating historical ratios
13. Calculating historical ratios
14. Lecture 89: Making assumptions
15. Making assumptions
16. Lecture 90: Income statement projections
17. Income statement projections
18. Lecture 91: Balance sheet projections
19. Balance sheet projections
20. Lecture 92: Creating the statement of cash flow
21. Creating the statement of cash flow
22. Lecture 93: Revolver
  FREE PREVIEW
23. Revolver
24. Lecture 94: Interest calculations
25. Interest calculations
26. Bonus Lecture: How to use index match to run multiple scenarios?
  FREE PREVIEW
27. Section 10 Quiz
1. Lecture 95: Introduction to DCF analysis
2. Lecture 96: Overview of DCF analysis
3. Lecture 97: Free cash flows
4. Free cash flows
5. Lecture 98: WACC calculation
6. WACC calculation
7. Lecture 99: PV of projection period
8. PV of projection period
9. Lecture 100: Terminal value
10. Terminal value
11. Lecture 101: PV of terminal value
12. PV of terminal value
13. Lecture 102: Adjusting discount rate for mid-year
14. Adjusting discount rate for mid-year
15. Lecture 103: Implied equity value
16. Implied equity value
17. Lecture 104: Implied share price
18. Implied share price
19. Lecture 105: Sensitivity analysis
  FREE PREVIEW
20. Sensitivity analysis
21. Lecture 106: Ups and downs of the DCF analysis
22. Bonus Lecture: Fully diluted shares outstanding
  FREE PREVIEW
23. Fully diluted shares outstanding
24. Section 11 Quiz
1. Lecture 107: Introduction to precedent transaction analysis
2. Lecture 108: Overview of precedent transaction analysis
3. Lecture 109: Peer universe selection
4. Peer universe selection
5. Lecture 110: Deal related data & financials
6. Deal related data & financials
7. Lecture 111: Spread key ratios and multiples
  FREE PREVIEW
8. Spread key ratios and multiples
9. Lecture 112: Benchmark comparable transactions
10. Benchmark comparable transactions
11. Lecture 113: Determine valuation
12. Determine valuation
13. Lecture 114: Ups and downs of precedent transactions analysis
14. Section 12 Quiz
1. Lecture 115: Introduction to comparable companies analysis
2. Lecture 116: Overview of comparable companies analysis
3. Lecture 117: Peer universe selection
4. Peer universe selection
5. Lecture 118: Data & financials of comparables
6. Data & financials of comparables
7. Lecture 119: Spreading key ratios and multiples
8. Spreading key ratios and multiples
9. Lecture 120: Benchmark comparable companies
10. Benchmark comparable companies
11. Lecture 121: Determine valuation
12. Determine valuation
13. Lecture 122: Ups and downs of comparable companies analysis
14. Bonus Lecture: Valuation material
15. Valuation material
16. Section 13 Quiz
1. Lecture 123: Introduction to presentations
2. Lecture 124: Excel: What are we going to build?
3. Lecture 125: Column charts
4. Column charts
5. Lecture 126: Bar charts
6. Bar charts
7. Lecture 127: Pie charts
8. Pie charts
9. Lecture 128: Line charts
10. Line charts
11. Lecture 129: Scatter charts
12. Scatter charts
13. Lecture 130: Bubble charts
14. Bubble charts
15. Lecture 131: Sum of parts charts
  FREE PREVIEW
16. Sum of parts charts
17. Lecture 132: Charts with two vertical axis
18. Charts with two vertical axis
19. Lecture 133: Power Point: What are we going to build?
  FREE PREVIEW
20. Lecture 134: Preparing a teaser - Company overview page
21. Lecture 135: Preparing a teaser - Key investment highlights page
22. Lecture 136: Preparing a teaser - Brands and products page
23. Lecture 137: Preparing a teaser - Key financials page
24. The End

About this course

$499.00
204 lessons
24.5 hours of video content

Buy $499.00