Financial Modelling Course: Integrated Financial Statements
Finance. Boost your financial know-how.
Take your financial modelling skills to the next level by learning how to build an integrated three-way financial statement model (a ‘3-Way Model’). If you intend on pursuing a career in financial modelling and have not yet learnt a systematic approach to building a 3-Way Model, then this is the course for you.
One of the cornerstone skills in financial modelling is being able to go from a blank spreadsheet and build a model that can forecast the Operating Statement, Balance Sheet and Cash Flow Statement in such a way that they are all linked and maintain the fundamental integrity of a balancing balance sheet.
Whether you are modelling an existing company with historical financial statements, or a new company, this course will provide you a framework to be able to design, build, error check and modify a 3-Way Model. Using best practice modelling practices, and introducing practical uses of more advanced functionality such as scenario and sensitivity modelling, this one-day course will give you a step-by-step approach you can use to apply to any 3-Way Model task you might encounter in your career.
Aims
This course aims to provide you with a systematic approach to building a 3-Way Model in Microsoft Excel for any kind of business, irrespective of industry.
Outcomes
By the end of this course, you should be able to:
- explain why a 3-Way Model can be more powerful than simply forecasting a stand-alone P