Financial Modelling
This course will help delegates build financial models through a range of practical model-building exercises. It will assist in the understanding of valuations and will review the most common methodologies used by the market. It is suitable for IR practitioners who have a sound understanding of accounting, an interest in valuation and basic excel skills. This practical, interactive course, runs in a workshop-style format, using Excel, so delegates will be expected to have access to a laptop rather than a tablet or handheld device during the course. The course will be delivered by Professor Ken Lee.
Programme
- Financial Modelling House Keeping – what makes a professional model?
- How do analysts go about forecasting?
- Choosing model design parameters
- The model starting point: An integrated set of P&L, Balance Sheet & Cash Flow forecasts
- Dealing with debt and circularities
- Reviewing analyst models for typical flaws and weak points
(Attendees will receive an information pack in advance containing the basic model to be used for the course, including historic P&L, Cash Flow and Balance Sheet statements).
What will I gain?
- The overall approach analysts take to a professional model
- The ability to build an integrated set of P&L, Balance Sheet and Cash Flow forecasts consistent with the methods taught to sell-side and investment banking analysts.
- Knowledge of key forecast metrics such as: EBITDA, EBIT, EPS etc.
- Turning a forecast model into a valuation
