Financial Modelling

• Share

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 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 date. If you cannot attend the date or your preferred modality is not yet scheduled, please do 'Register Interest' in the course. 

In-Person, City of London

• Monday 02 December 2024 (09:30 - 16:30)

Course tutor: Professor Ken 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. 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.
He holds a doctorate from Aston Business School, is 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.), Company Valuation under IFRS (2020, 3rd ed.) and The Valuation Book (2024, Harriman House). He has published in a number of academic journals including Contemporary Accounting research, European Accounting Review and The British Accounting Review.  

Programme

• 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).

Register interest