Best Practice Financial Modelling

This course will train you in the skills of robust model building.  The programme assumes basic competency in Excel and accounting. By the end of the course, you will:

- Be faster and more efficient in the use of the Excel tools used in modelling
- Have a clear method for building reliable, robust and flexible models
- Understand design principles and best practice
- Be efficient in spotting inconsistencies when auditing other people's financial models
- Have a set of tools for analysing and sensitising financial models

You will need to provide your own laptop with excel throughout the course.

This course is eligible for CPD accreditation (13 hours) with:

Association of Chartered Certified Accountants (ACCA)
Chartered Institute of Management (CIMA)
Chartered Institute for Securities & Investment (CISI)

Institute of Chartered Accountants in England & Wales (ICAEW)


ACCA-Logo-2011  CIMA Logo 2011  CISI web logo

Content

This course will build on excel skills that will allow you to develop rigorous financial models and get the most from third party models. Key skills will be covered in the course such as scenario management techniques; switches and text wings to make models clear and flexible and data validation to control inputs. You will progressively build an integrated balance sheet, profit and loss and cash flow forecasting model for project analysis, company valuation, debt structuring and capital structure optimisation.

To download the full programme for this course, click here

Target Audience

Delegates should have a basic level of excel skills and accounting knowledge. Even intermediate and more experienced modellers will gain from learning techniques to improve their efficiency, speed and flexibility.

All training courses are available to members and non-members of the BVCA. For a full breakdown of training course prices click here.

Duration

2 days non-residential

Testimonials

A fantastic, fast moving  course, beneficial to most professionals within the VC industry ranging from Finance and legal, through to Investment professionals.  I never knew how interesting Microsoft Excel could be!
(Helen Barton, Fidelity Growth Partners)

Top rate - very knowledgeable and helpful lecturer. Would thoroughly recommend.
(Diarmuid Kelly, ISIS Equity Partners)

Great course and very useful content! Very engaging and competent course director.
(Vanela Bushi, Imperial Innovations Ltd)

Contact Details

For further information on BVCA Training, please contact Lisa Simpson.
lsimpson@bvca.co.uk

Telephone

020 7420 1823

Book Your Place

18 - 19 April 2012
Central London
To book your place, please at the top left hand corner of the screen.
Not yet signed up? Register here.
17 - 18 September 2012
Central London
To book your place, please at the top left hand corner of the screen.
Not yet signed up? Register here.

Maximum Attendees

11

Cost (per place)

£1650.00 + VAT