Financial Modelling - Comprehensive


Cost for BPP PD Members: £1150 + VAT 12 CPD Hours
(£1435.00 + VAT for non BPP PD Members Click Here for details of our membership scheme).

Please click below to watch our short course introduction video


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). It 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 - Introduction. Laptops (excel v.2013) are provided. Courses are limited to a maximum of twelve delegates, allowing each attendee to experience outstanding tutor support throughout the two days.

Please Note: Financial Modelling vs Data Analysis:

Financial Modelling typically involves building a financial forecasting model in order to answer a particular question, such as which project should we invest in, or what rate of return might we expect from a particular investment.

Data Analysis on the other hand involves analysing large amounts of data, often via summarisation, in order to make informed decisions based on the results.Please refer to our Data Analysis series if this is better suited to your needs.


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.

Learning outcomes include obtaining a greater understanding of:

  • Financial modeling “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

"A CPD certificate of completion will be provided by BPP Professional Education Limited upon request, following attendance."

Course Dates

Location Dates Time Availability  
London 02 - 03 Apr 2019 9:30 AM - 5:00 PM  Spaces Book Now
London 14 - 15 May 2019 9:00 AM - 5:00 PM  Spaces Book Now
Manchester 21 - 22 May 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 11 - 12 Jun 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 11 - 12 Jul 2019 9:30 AM - 5:00 PM  Spaces Book Now
London 13 - 14 Aug 2019 9:30 AM - 5:00 PM  Spaces Book Now
London 10 - 11 Sep 2019 9:00 AM - 5:00 PM  Spaces Book Now
Birmingham 01 - 02 Oct 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 08 - 09 Oct 2019 9:30 AM - 5:00 PM  Spaces Book Now
London 31 Oct - 01 Nov 2019 9:00 AM - 5:00 PM  Spaces Book Now
London 03 - 04 Dec 2019 9:00 AM - 5:00 PM  Spaces Book Now

Membership Scheme

You and your firm could be saving £000's on your CPD training. Find out how to join our membership scheme and receive immediate benefits.

Tailored training

We can tailor any of our public courses to meet your needs as well as providing completely bespoke training solutions. Learn more about tailored training.

Special Assistance Policy