PD - 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.

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

Who should attend?

IR professionals who review and/or interpret analyst models
The next course having completed the Valuation Essentials for IR Professionals course