Course Overview?
In this four (4) days course, delivered by subject matter experts with practical industry and training experience, participants will learn key tools of Excel useful for business analysis and practice how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).
This course adopts a case study approach and minimizing the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.
Target Group
The course is suitable for professionals working or aspiring to work in the field of investment banking, project consultancy, private equity, corporate finance, asset valuation and equity research. It is of particular benefit to corporate and project financiers, finance managers, accountants and bankers.
Course contents
- Improving efficiency by using Basic excel tools and shortcuts
- Excel fundamentals refresher
- Customizing Excel
- Useful tools in Excel for financial modelling such as: IF, AND OR, OFFSET, Named ranges, MAX, MIN, ABS
- Basic structure of a model
- Financial statements refresher
- Model design and consideration of inputs
- Forecasting EBITDA
- Integrity of financial model
- Including checks and balances
- Forecasting working capital
- Forecasting capex and depreciation
- Forecasting financing flows
- Trouble shooting circularity problems
- The camera functions
- Sensitivity analysis
- Charting the results
- Creating impressive output
