Advanced Financial Modelling

DatesFebruary 14 2013
CityJohannesburg, South Africa
Contact NameShannon Aitken
Local Phone+61 8 9211 8674
Fax+61 8 9322 2576
Emailtraining@snowdengroup.com
Websitehttp://www.snowdengroup.com/Files/Intro_courses_Global-2013_JHB.pdf
Main BodyADVANCED 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.
FeesSpecial 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 InfoCONTACT 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 training@snowdengroup.com
TO REGISTER:
Please complete the following form and either fax it or email it to Shannon Aitken, Training Coordinator
Fax +61 8 9322 2576 Email training@snowdengroup.com
Please visit www.snowdengroup.com for more information about our training courses

Organizer

OrganizerSnowden Mining Industry Consultants
Address87 Colin Street, West Perth, Perth, Australia 6005
Phone+61 8 9211 8670
Fax+61 8 9322 2576
Emailrwatt@snowdengroup.com
Websitewww.snowdengroup.com