|Dates||February 14 2013|
|City||Johannesburg, South Africa|
|Contact Name||Shannon Aitken|
|Local Phone||+61 8 9211 8674 |
|Fax||+61 8 9322 2576|
|Main Body||ADVANCED FINANCIAL MODELLING|
This one-day course has been designed for master/power-users in Excel-based cash flow modelling, specifically aligned to the needs of
the mining industry. The course covers technical and financial modelling from rock face to product; quick builds for auditable nominal
and real models; multiple scenario modelling; methodologies for depreciation, stockpiles, closure cost funding, data tables (tornado
plots/sensitivity analysis); along with some tricks of the trade.
The key concepts covered are:
• The science of Cash Flow Modelling - overview of the current and new thinking regarding Cash Flow Modelling;
• Building Cash Flow Models quickly - workable easy-to-understand short-cuts; and Tricks of the Trade;
• Cash Flow Modelling Best Practice - layout and structure (workbook setup and worksheet structuring of inputs, calculations, outputs
and appropriate level of detail); contents (formulae, modules, time series); scenario modelling ; building auditable nominal and real
models; version control ; use of flags; “corkscrew” structures for tax, depreciation, stockpiles, closure cost funding and working capital
modelling; and friendly and dangerous Excel functions.
• Advanced modelling techniques - variable time series; indexation; risk analysis; automated scenario comparison; sensitivity analysis,
including cost of project delay.
Laptops are required for this course and delegates will need a good working knowledge of Excel.
|Fees||Special Discount Offers: |
PLEASE NOTE - SPECIAL DISCOUNTS OFF REGISTRATION FEE:
A 10% discount is offered to members of the professional associations listed on the registration form.
PLUS A 5% discount is offered if 2 or more delegates, from the same company, register on a course, or if 1 delegate books on more
than one course.
PLUS A 5% discount is offered if paying by credit card
The course fee includes a comprehensive course reference manual, refreshments and lunch.
|Additional Info||CONTACT AND REGISTRATION |
For more information on Snowden’s Training and Mentoring programmes, please contact:
Diana Titren, Training Division Manager Tel: +61 8 9211 8670 Email firstname.lastname@example.org
Please complete the following form and either fax it or email it to Shannon Aitken, Training Coordinator
Fax +61 8 9322 2576 Email email@example.com
Please visit www.snowdengroup.com for more information about our training courses