Introduction to Financial Modelling
- 2 Days
- Live Online or Classroom
- Flexible Sessions
- After Course Care
Learning outcomes
- Design & build professional, clear, and robust financial model in Excel
- Ensure data integrity and calculation transparency by applying best practice principles
- Minimise the risk of error in your workings
- Learn principal Excel formulae used in financial modelling
- Use Excel functionality efficiently, know which functionalities to use and which to avoid
- Manage model size
Course content
Excel functionality and its uses in basic modelling
- Creation of Custom Styles
- Key functions relevant to case study
- Named ranges & Data validation
- Working with dates
- Illustrations for mapping
- Macro recording
- Simple macro coding
Accounting/finance knowledge
- Profit & Loss account modelling
- Depreciation calculations
- Basic tax and tax losses
- Time value of money and NPV appraisal
Modelling skills
- Model set up - Designing model structure with model maps
- Timeline modelling - Single, annual
- Flags - Single condition flags and switches
- Checks - Building and connecting basic checks into a simple network
- Control accounts - Basic working capital (flexible daily method), tax loss accounts
- Scenarios - Setting out and switching between scenarios
- Change management - Tracking model changes, bridging model outputs
- Best practice - Using the best practice principles tailored to the case study
Who should attend
This course is applicable to any spreadsheet user who wishes to gain industry-recognised best-practice skills required for building new or restructuring old models. While there is a financial focus to the course, it is useful for anyone who uses Excel regularly. Investors, analysts, accountants, and any other finance professionals would find it beneficial, especially if they are self-taught Excel users.
Pre-requisites & equipment required
Attendees should have basic knowledge of Excel. All relevant functions will be included in handouts to be provided in advance of course start and will be refreshed briefly on the first day. A windows PC with web camera, microphone and speakers (internal or external) is required with Microsoft Excel and Zoom/Teams application installed.