Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment.
Financial modeling is a general term that means different things to different users; the reference usually relates either to accounting and corporate finance applications, or to quantitative finance applications. While there has been some debate in the industry as to the nature of financial modeling.
- Overview of financial modeling
- Understanding projections
- Excel best practices foundation and exercises
- Useful Excel shortcuts and functions
- Gathering historical documents / information
- Preparation of Income and Cash Flow statements and Balance Sheet
- Ratio Analysis
- Du Pont Analysis
- Financial Statement Analysis
- Valuation of Companies
- Valuation of IPOs
- Valuation of Merger & Acquisitions
- Valuation of Bonds
- Valuation of Equity
- Leverage Buyout Analysis (LBOs)
- Sensitivity/Scenario Analysis
- Monte Carlo Simulation
- Case Study
Anyone can attend this course with basic excel knowledge.