MODULE BREAKDOWN
1: Introduction to Financial Modeling
- Overview of Financial Modeling
- Significance of financial modeling
- Financial Modeling best Practices
- Key principles and applications
2: Master Forecasting Techniques and Advanced Financial Excel Tools
- Moving Average
- High-Low Method
- Multiple Linear Regression
- Sensitivity Analysis
- Scenario Analysis
- Goal Seek
- Excel Solve
3- Building Comprehensive Financial Models
- Setting up Integrated financial statements
- Modeling debt and equity financing
- CAPEX modeling including different depreciation methodologies
- Sensitivity analysis to assess the impact of changes in key input variables on the output
- Scenario Analysis to test different business strategies on the model
- Different approaches to modeling corporate taxation
- Model structure, layout, and assumptions
- OPEX modeling including forecasting of revenue, operational cost, and working capital
- Building a comprehensive Model from start to finish
4: Presenting and Communicating Financial Models
- Dashboard Summaries
- IRR and NPV Calculations
- Free Cash Flow
- Industry KPIs
- Creating Charts and Graphs
- Cost of Capital
- Horizontal and Vertical analysis
5- Business Valuation
- Different techniques of valuing a company
- Why value a company
- Main value drivers when valuing a company
- DCF Modeling
6: Financial Model Audit and Error Checking
- Error checking and troubleshooting
- Ensuring accuracy and reliability
- Reviewing and auditing financial models