Financial modelling - Intermediate

14 August 2018
Edinburgh, London

Member price in Scotland: £714 + VAT
Non-member price in England: £840 + VAT

Please note, the ICAS member discount will be applied after checkout.

Member price in England: £1,181.50 + VAT
Non-member price in England: £1,390 + VAT

Please note, the title of this course in England is 'Financial Modelling - Comprehensive'. Due to differences regarding external costs, courses outside of Scotland are priced separately. ICAS members are eligible for a discounted price on all courses running in England & Wales

London, 14-15 August 2018
London, 17-18 September 2018 
London, 16-17 October 2018
London, 13-14 November 2018
London, 18-19 December 2018

Email to book

Edinburgh, 8-9 November 2018

Book with BPP

This two-day course is designed for financial professionals needing to build, interpret, review and audit financial models (forecast integrated income statement, cash flow statement and balance sheet).

Learn how a forecast integrated set of financial statements is constructed, from scratch, for a real company (based on published historic data). Once the forecast is complete a basic discounted cash flow (DCF) valuation is performed in order to demonstrate the sensitivity analysis.

This course is suitable for both accountants and non-accountants, but an existing understanding of basic accounting concepts and terminology would be helpful. Delegates concerned about their basic excel ability should first attend the one-day Financial Modelling - Essential Introduction. Laptops (excel v.2007) are provided.

Full speaker list


All of the presenters have extensive experience in accountancy training, specialising in financial accounting under IFRS and UK Financial Reporting. Having also worked in industry our speakers bring the wealth of their experience to the practical issues which can arise when reporting on an accounting framework. All of the speakers therefore have strong technical knowledge of financial accounting.

View full event details


  • Financial modelling "Golden Rules": Best practice DOs and DON'Ts
  • Model set-up
  • Model planning
  • Worksheet grouping
  • Date functionality
  • Historic data: cleaning up the numbers
  • Integrating the statements
  • Balancing the balance sheet
  • Forecasting techniques: pros and cons
  • Forecasting the numbers and populating the financial statements
  • Valuation
  • Enterprise vs equity value
  • Essential financial maths
  • Discounted cash flow valuation
  • Scenario analysis
  • Sensitivity analysis
  • Rolling forward the forecast
  • Model audit and review
  • Circularity and trouble shooting


Edinburgh, London


Tel: 0330 060 3303


  • Corporate and financial reporting
  • England and Wales
  • Scotland
  • Training courses
  • Edinburgh
  • London and Home Counties

Previous Page