Financial Modelling - Comprehensive

BPP Professional Education
Course summary
12 hours
1,450 GBP excl. VAT 1,087.50 GBP excl. VAT
Birmingham, London, Online courses
Next available date: Online delivery option may be available - Please contact provider. - Online courses
Professional Training

Course description

Financial Modelling - Comprehensive

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.

Suitability - Who should attend?

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 - Excel Essentials. Laptops (excel v.2013) are provided.

Outcome / Qualification etc.

  • 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


Special Offer:

This course is eligible for 25% discount for dates starting before 1st September 2020. For more information, please contact us with the form below!

Get Inspired! Watch the Video


About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Financial Modelling - Comprehensive.

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number

Request information

Find out more about this Financial Modelling - Comprehensive course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here