Become an M&A Analyst: The Complete Skillset Free Series

The most detailed and hands on online investment banking/M&A course ever created!

Created byAli Ilci

Last updated 7/2017

English

English [Auto],

What you'll learn

UNDERSTAND the difference between an asset sale and a share sale
LEARN who are involved in an M&A Process and what are their duties
PRINT excel documents properly
USE PowerPoint Slide Master
READ a balance sheet
UNDERSTAND the concept of non controlling interest
LINK the 3 financial statements
CALCULATE inventory turnover ratio and days inventory outstanding
RUN multiple scenarios in a financial model
CALCULATE revolver in a financial model
CREATE sensitivity tables and RUN sensitivity analysis in DCF valuation methodology
CALCULATE fully diluted shares of a company
CREATE waterfall charts in excel

Course content

1 section • 14 lectures • 2h 24m total length

What is the difference between share sale and asset sale?9:43
Explore the difference between share sales and asset sales, their advantages and drawbacks, with Cadbury by Kraft Foods and Lehman assets examples.
Who are involved in M&A transactions and what are their duties?11:57
Identify the buyer, seller, and their advisory teams in an m&a deal, and outline how legal, financial, tax, and technical due diligence guide the process from origination to closing.
How to print in excel properly?21:23
Design an item checklist in Excel, format cells and borders, use data validation and conditional formatting for status, then set print area and repeat headers for proper printing.
How to use Microsoft PowerPoint Slide Master?11:28
Learn to use the slide master in Microsoft PowerPoint to create, customize, and save reusable slide themes and layouts that keep your presentation aligned and time efficient.
What is a balance sheet?8:50
Explore how a balance sheet shows assets, liabilities, and shareholders' equity at a single date, and cross-check that assets equal liabilities plus equity, illustrated by Ryanair.
What is non controlling interest?6:41
Explain non-controlling or minority interest when a parent holds a majority stake but not 100 percent, and how consolidation includes the subsidiary while recording minority in equity and income.
How the 3 financial statements are linked?5:10
Explore how income statements, balance sheets, and cash flow statements interrelate by tracing net income to retained earnings and cash flows, and linking beginning and ending cash across periods.
How to calculate inventory turnover ratio?9:06
Learn to calculate the inventory turnover ratio using cost of goods sold and average inventories. Convert the ratio to inventory outstanding days to gauge operational efficiency.
What is financial modeling?2:49
Financial modeling builds a three statement financial model using historical information, ratio analysis, future assumptions, and forecasts to discount cash flows and perform a valuation.
How to use index-match formula to run multiple scenarios in financial models?11:33
Use index match to run multiple scenarios in a financial model, switching between worst, base, and best cases to see impacts on revenue, gross profit, and valuation in DCF framework.
How to calculate revolver in financial modeling?8:42
Learn how to model revolver lines of credit and link cash items to the balance sheet and the statement of cash flows, and forecast ending cash balance.
How to create sensitivity tables in DCF Analysis in excel?11:18
Learn to build sensitivity tables in a DCF analysis by testing key assumptions—growth rate, WACC, and exit multiples—and see their impact on share price and valuation in Excel.
How to calculate fully diluted shares outstanding?14:31
Learn to calculate the fully diluted shares outstanding using convertibles, stock options, and partnership exchange units in Restaurant Brands International, and assess the impact on earnings per share.
How to create waterfall charts in excel?11:03
Learn to build a waterfall chart in Excel from a regional revenue breakdown for 2016, using a custom stacked column setup, data labels, and axis formatting.

Requirements

No prerequisites. The course will cover everything from scratch with extensive video explanations.
You need Microsoft Excel and Power Point (in PC or Mac) and to be eager to learn...

Description

About this course

Become an M&A Analyst: the Complete Skillset is the most detailed and hands on course about investment banking/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.

Udemy Free Series offer 14 different free lectures from the Original Series.

These lectures are:

1) What is the difference between share sale vs. asset sale?

2) Who are involved in an M&A transaction and what are their duties?

3) How to print in excel properly?

4) How to use PowerPoint Slide Master?

5) What is non-controlling interest?

6) What is a balance sheet?

7) How the 3 financial statements are linked?

8) How to calculate inventory turnover?

9) What is financial modeling?

10) How to use index match formula to run multiple scenarios in excel?

11) How to calculate revolver in financial modeling?

12) How to create a sensitivity table in excel?

13) How to calculate fully diluted number of shares?

14) How to create a waterfall chart in excel?

Enroll the course for free and start watching the special Udemy Free Series of the legendary Become an M&A Analyst: the Complete Skillset course.

Who this course is for:

Anyone interested in the world of mergers and acquisitions.
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 / entrepreneurs who want to learn about corporate finance and M&A process.