Introduction to financial modelling
Event type: Mastercourse
How to construct financial models
|
Date
|
Location
|
Price
|
|
|
14 June 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
12 July 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
29 August 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
10 September 2012 - 09:00
|
London - 2 day event
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
4 October 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
29 October 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
15 November 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
|
12 December 2012 - 09:00
|
London - 2 day course
|
Price: GBP 1,390.00
Members: £1,251
Corporate discount scheme: £1,120
+ VAT, excluding accommodation, on all prices
|
|
Who will benefit
Those who have a basic knowledge of Excel and are, or expect to be, involved in any type of financial modelling and forecasting. The workshop is particularly relevant to corporate and project financiers, finance and project managers, accountants and bankers.
What you can gain
Learn how to build an integrated balance sheet, profit and loss and cash flow forecasting model appropriate for equity valuation and debt related analysis.
Speaker Details
The speaker will be drawn from a pool of qualified professionals who specialise in this subject. Having worked for leading organisations they will relate the course content to real life case studies.
Outline
- some Excel basics and the basics of design: ten essential Excel shortcuts; design principles; key elements of model structure; group edit tools.
- building the framework: setting up the model structure; input versus formulae conventions; absolute versus relative references;
- building the schedules: using naming conventions; using 'corkscrews' and 'BASE' calculations; using 'if' to create flexibility; operations schedule; fixed-asset schedule.
- building the debt schedule: a simple approach to debt; using 'if' to solve more complex problems; using the function wizard.
- balancing - straight away: integrating the financials and balancing the balance sheet as we go - a stepwise approach; building in a balance check; a structured approach to model development.
- cash flows: linking cash from operations; linking fixed assets and financing; implementing some simple checking calculations.
- tax and valuation: modelling UK corporate tax in more detail; tax loss schedules; valuation and related functions; building the valuation module.
- analysis and presentation: dynamic labelling/text strings; number formatting; Excel's handy analytical tools - data tables; goal seek; print management.
Delegates have exclusive use of a pc throughout the course. Numbers are restricted to twelve to ensure you receive the most effective training during your session.
12 CPD hours (where applicable)
Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.
CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more.
Prerequisites
A basic knowledge of financial statements and Excel is assumed.