Understand the Fundamentals of Financial Modeling and Valuation.
Have you ever wondered how do investment banks and M&A practices build financial models, in order to value businesses? What are the components of such a financial model? How can YOU build a financial model in order to value a business?
What you’ll learn
- Fundamentals of Financial Modeling and Valuation.
- Common Size Analysis to Forecast Financial Statement Figures.
- Financial Statement Forecasting.
- Valuation Using the Discounted Cash Flow (DCF) and Trading Multiples Methods.
- Perform Sensitivity Analysis.
- Create Financial Analysis Graphs.
Course Content
- Top Financial Modeling and Valuation (DCF and Trading Multiples) – Overview –> 1 lecture • 11min.
- Analysing Historical Data and Creating Assumptions –> 3 lectures • 59min.
- Forecasting Financial Performance and Position Figures –> 1 lecture • 27min.
- Valuation of the Company (DCF and Trading Multiples) and Sensitivity Analysis –> 3 lectures • 58min.
- Performing Financial Analysis and Creating Graphs –> 1 lecture • 13min.
- Excel Figure Updates and Mistake Corrections –> 1 lecture • 2min.
Requirements
Have you ever wondered how do investment banks and M&A practices build financial models, in order to value businesses? What are the components of such a financial model? How can YOU build a financial model in order to value a business?
This course provides the answers to all questions above. This course caters to those that seek to understand the fundamentals of Financial Modeling and Valuation. While some basic Accounting and Corporate Finance knowledge would help anyone who takes this course, it is not essential.
This course is great for those that have little to no knowledge about Valuation and Financial Modeling, as well as for those that understand the basics of a Financial Model but need assistance and guidance with building one. In this course, students will learn how to:
1) Interpret Historical Financial Data and Perform Common Size Analysis
1) Create Assumptions and Time Based Assumptions to Help Forecast Income Statement and Balance Sheet Figures
2) Forecast Financial Statements and Create Schedules for Property, Plant and Equipment, as well as Debt
3) Extract Comparable Company Samples and Damodaran Data
3) Calculate Returns, Such as the WACC and Cost of Equity
4) Perform Sensitivity Analysis
5) Create Financial Analysis Graphs