Search

07 November 2017

Financial modelling - comprehensive

Category: MASTER COURSE

Find out how to build, input, review and audit financial models (forecast integrated income statement, cash flow statement and balance sheet).

Who should attend?
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.

What you will gain
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.

Programme outline

  • 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

Laptops are provided.

An existing understanding of basic accounting concepts and terminology would be helpful. If you are concerned about your basic excel ability please first attend Financial modelling - introduction.

The course starts at 9.00am on each day. Lunch and refreshments are included, but not accommodation.
12 CPD hours (where applicable). 

Booking Information

Date Location Price
7 November 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
5 December 2017 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
18 January 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
13 February 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
20 March 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
23 April 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
17 May 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
19 June 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
18 July 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
14 August 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
17 September 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
16 October 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
13 November 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.
18 December 2018 - 09:00 London - 2 day course Price: GBP 1,390.00
Member price: £1,251. CDS member price: £1,120. Plus VAT on all prices. Accommodation not included.


Related Events

Project finance modelling

MASTER COURSE

  • Cost:
  • Location:
  • Speaker(s):

Gain a robust and flexible methods for building project models, plus training in the established design solutions to the challenges commonly encountered.

Find out more

22/11/2017 09:00:00

Venture capital and private equity - introduction

MASTER COURSE

  • Cost:
    GBP 1,845.00
    Member price: £1,661. CDS member price: £1,470. Plus VAT on all prices. Excluding accommodation.
  • Location:
    London - three day course
  • Speaker(s):

An explanation of the working of the venture capital and private equity industry, this course gives practical instructions on analysing and structuring transactions, including buy-outs and buy-ins.

Find out more

Financial modelling - comprehensive

CIMA members and students should log in to MY CIMA before booking to receive the appropriate discount. Save up to 30% with the CIMA Corporate Discount Scheme (CDS). Find out more at: www.cimamastercourses.com/CDS

Book Now

Tailored training 
We can tailor any of our Mastercourses to meet your needs as well as providing completely bespoke training solutions. Find out more

Find out more 
If you have any queries please email or phone us on: +44 (0)3332 221608. Visit our booking page for information on how to book and pay.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA Mastercourses are held in partnership with BPP.  

CIMA on demand is our range of online CPD courses specifically designed for busy finance and business professionals who need training that's convenient and will fit around their schedule. Find out more