HOME
 

Financial Modelling - Comprehensive

BPP Professional Education
Course summary
12 hours
1,450 GBP excl. VAT
English
Open / Scheduled
Next available date: 31/10/2019 - London
Course Dates
London
31/10/2019   (English)
1,450 GBP
03/12/2019  
1,450 GBP

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

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
www.bpp.com


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 first annual U.K. L&D Report!

UK 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