Description
In this course, you will learn :
- COMPREHEND the distinction between an asset sale and a share sale.
- LEARN WHO is involved in an M&A Process and what their responsibilities are.
- PRINT your Excel documents correctly.
- MAKE USE OF PowerPoint Slide Master.
- LEARN TO READ A BALANCE SHEET.
- UNDERSTAND what it means to have a non-controlling interest.
- JOIN the three financial statements.
- CALCULATE the inventory turnover ratio and the number of days inventory is outstanding.
- RUN a financial model with multiple scenarios.
- In a financial model, CALCULATE the revolver.
- IN DCF valuation methodology, CREATE sensitivity tables and RUN sensitivity analysis.
- CALCULATE a company's fully diluted shares.
- CREATE waterfall charts in Microsoft Excel.
Syllabus :
- What is the difference between share sale and asset sale?
- Who are involved in M&A transactions and what are their duties?
- How to print in excel properly?
- How to use Microsoft PowerPoint Slide Master?
- What is a balance sheet?
- What is non controlling interest?
- How the 3 financial statements are linked?
- How to calculate inventory turnover ratio?
- What is financial modeling?
- How to use index-match formula to run multiple scenarios in financial models?
- How to calculate revolver in financial modeling?
- How to create sensitivity tables in DCF Analysis in excel?
- How to calculate fully diluted shares outstanding?
- How to create waterfall charts in excel?