Public training courses for financial model auditors?

Blog

Blog

Blog

Blog

all posts

tags

Public training courses for financial model auditors?

by Rickard Warnelid on May 8 2009

When I have been presenting courses in the past for Terrapinn (project finance modelling) and Navigator Project Finance (financial modelling)  is has not been uncommon to have 1-2 model auditors from ‘the competition’ participating. This is not strange in any way as it is quite important for any financial model auditor to have a good understanding of why financial models have been constructed in a certain way.

The feedback has constantly been something like ‘well, it certainly was useful however it doesn’t cover everything I need in my role as a financial model auditor’. The obvious question to ask would be ‘are there courses that caters especially for model auditors’? There are certain topics that financial model auditors are interested in which I don’t think are covered in any one training course offered in the market (please let me know if I am mistaken here!).

Suggested agenda for a tailored course for financial model auditors

  • Time-line of a model audit
  • Discussion around suitable Scope of Works for a financial model audit
  • Reliance standards (professional indemnity insurance, partnership structures, ‘agreed upon procedures’)
  • Model audit (spreadsheet investigation) tools - benefits and differences (OAK, Spreadsheet detective, Spreadsheet professional etc)
  • Efficient communication with the team performing the Tax and Accounting review
  • Common audit processes (cell-by-cell, analytical review, model design etc)
  • Pragmatic documentation standards
  • Techniques to break down complex formulae (and tools for that (like BPM Traverse and similar)
  • How to communicate issues with circularities to clients
  • How to assist a client in preparing a model for audit (cleaning up, restructuring, documentation, commenting macros, etc)

Should Corality launch a ‘financial model audit’ course?

We have been discussing internally converting our internal model audit training program for new joiners into a public course, but so far haven’t done much about it. It would be interesting to know if anyone else has done this already or if the sector, which is dominated by ultra-traditional accounting firms, is protecting the intellectual property and are reluctant to sharing knowledge and procedures with the competition. I don’t really believe in protecting intellectual property to build sustainable advantage so maybe this is a good idea for us to pursue?

COMMENTS

Update: I just found thing

Update: I just found thing website of William J McKibbin who offers a course on "Spreadsheet Auditing- Detect and Prevent Errors on Microsoft® Excel® (1-day)) which sounds pretty much like what I was looking for. http://wjmc.blogspot.com/ Or, check out his blog: http://wjmc.blogspot.com/

Hi Alastair, That is very

Hi Alastair, That is very interesting, thanks for your comment! Would you mind telling us more about the agenda in this financial model audit course and who the target audience was? Did you get attendees from the accounting firms or were they financial modellers from banks/corporates just wanting to learn how to reduce spreadsheet errors?

Rickard I have presented

Rickard I have presented one day workshops on auditing and there definitely is a market for the above. Alastair Day

Post new comment

The content of this field is kept private and will not be shown publicly.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

Need a financial model audit?

Need a financial model audit?

Do you want to find our more about our financial model audit services??

Read more about Corality

Upcoming Courses

Best Practice Project Finance Modelling
Sydney
30 May - 31 May 2012
Best Practice Project Finance Modelling
London
11 June - 12 June 2012
Advanced Project Finance Modelling
London
13 June - 14 June 2012

Bloggers

Laura Dean

Laura Dean

Laura is our creative and motivated Marketing Coordinator.

Rickard Warnelid

Rickard Warnelid

Rickard Warnelid is the Managing Director of Corality Financial Group.

Peter Weatherston

Peter Weatherston

Peter is a UK qualified accountant with 10+ years experience in financial modelling and financial model auditing.

Bing Chien Quek

Bing Chien Quek

Bing is Corality's in-house VBA expert. He has worked on numerous projects as well as facilitated VBA training courses internationally.

Caroline Wiroth

Caroline Wiroth

Caroline has over 8 years of experience in marketing and Public Relations.

Tim Heng

Tim Heng

Tim has a wide range of experience in analytics and modelling across a number of different industry sectors (corporate banking, vehicle finance, credit risk and marketing analytics).

Blake McNaughton

Blake McNaughton

Blake McNaughton is an Associate based in Corality’s Head Office in Sydney, Australia.

Haydn Palliser

Haydn Palliser

Haydn is an Associate at Corality with a wealth of experience in structured finance, consulting and is a chartered professional engineer.

Cathryn Fish

Cathryn Fish

Cathryn is our energetic and super organised Training Experience Manager.

Nick Crawley

Nick Crawley

Nick Crawley is the Chairman and Head of Consulting of Corality Financial Group.

Grace Utama

Grace Utama

Grace Utama is a financial modelling expert, with particular expertise in advanced Excel techniques and VBA Macros.

Have a question or comment? We would love to hear from you. More contact options

We respect your email privacy.

Sitemap | Terms | Privacy © Copyright 2012 Corality Financial Group