This intensive one-day 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. As part of the course, we will address fundamental aspects of valuation to refresh and extend delegates’ knowledge. The course will be delivered online with excel models on screen interspersed with content delivery by Professor Ken Lee.
What will I gain?
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.
An overview of contemporary valuation methodologies, including DCF.
When and where is this course running?
The Financial Modelling course is running on the below dates. If you cannot attend any of the below training dates or your preferred modality is not yet scheduled, please do 'Register Interest' in the course.
Course 1 2024: In-Person, City of London
- Monday 03 June 2024 (09:30 - 16:30)
Course 2 2024: In-Person, City of London
- Thursday 05 December 2024 (09:30 - 16:30)
"I enjoyed the course and found it to be a useful overview. The main challenge is that it's a topic with so much to cover but some useful practical elements were covered in one day."
"The course was engaging and useful, pitched at the right level. An excellent tutor too, and the exercises and materials provided were great - both to guide the course itself, keeping it practical and also for future reference."
"Good session. Very well presented and exercises are very to the point and helpful."
Course tutor: Kenneth Lee
Director of Postgraduate Taught programmes at Loughborough Business School
Kenneth is a Professor in the Accounting and Finance research group of Loughborough Business school and the Director of Postgraduate Taught programmes. Prior to this he was an Associate Professorial Lecturer at the London School of Economics and Political Science, for 5 years. He is a member of the Capital Markets Advisory Committee (CMAC), a body supported by the IFRS Foundation, which interprets proposed accounting changes from the perspective of capital market participants.
Before academia Kenneth was a Managing Director & Head of European Equity Research at Barclays Capital, where he worked for 8 years before leaving in August 2017 to take up a number of academic positions. Prior to this he was also a Managing Director and a ranked accounting and valuation analyst at Citi Investment Research in London. During this time Kenneth published extensively on accounting and valuation topics for investors and was ranked in the top 3 in the Institutional Investor Survey over more than a continuous 10-year period.
He holds a doctorate from Aston Business School, a Fellow of the Institute of Chartered Accountants, a member of the Institute of Taxation and a CFA Charterholder. He is the co-author of Financial Statement Analysis under IFRS (2018, 6th Ed.) and Company Valuation under IFRS (2020, 3rd ed.).
- Financial Modelling House Keeping
- The model starting point: An integrated set of P&L, Balance Sheet & Cash Flow forecasts
- Analysis of Business Performance
- An overview of valuation methodologies: Absolute & Relative approaches to valuation
- Discounted Cash Flow
- Relative Valuation approaches
- Putting it all together: A case study
(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).
3 June 2024
5 December 2024
- IR Society members (£750 + VAT)
- IR Society Premium members (course allowance included in membership package)
- Non-members (£990 + VAT)
Discounts for multiple bookings
We offer a 10% discount on course fees when booking two professional development courses, and 20% when you book three or more.