The time zone advantage in financial model audit iterations

Blog

Blog

Blog

Blog

all posts

tags

The time zone advantage in financial model audit iterations

by Rickard Warnelid on December 1 2009

The Excel model audit team of Corality is based in Sydney, Australia. Most people appreciate that Sydney is one of the best places to live (in particular at this time of year - December - when Europe is not looking overly attractive and we have +28 degrees Celsius and sunshine) in the world but that is only one of the advantages of locating our financial model audit team here.

The model audit (model review) process of an Excel financial model

A typical model audit, or model review, of a financial model for a PPP/PFI/Project Finance transaction involves an initial spreadsheet review and an analytical review followed by additional iterations to resolve all outstanding spreadsheet issues satisfactorily. Typically in a bid tender process there are 3-5 Excel spreadsheet iterations in the model review process and the last two are often very minor.

Late nights of financial modelling for a bid tender process in PPP/PFI/Project Finance

By the nature of the high pressure environment of bid process in a PPP/PFI/Project Finance transaction the financial modeller in the deal team will be working on the financial model up until the very minute he leaves the office to go home a get a few hours well needed sleep. By that time the Excel project model is sent via email to the model auditors. This is obviously not a great structure from a bigger picture financial model risk perspective, but that is a different story.

The time zone advantage in using an Australian model audit company for European project finance/PPP/PFI projects

Unless you are working with a model audit team with seriously disturbed sleep patterns they are unlikely to be waiting at their desk at 1am waiting to potentially receive a new model…. (They probably would do this on the bid date, but not for the initial iterations). Should you work with an Australian model audit team then this would not be an issue. 1am in London is 11am Sydney time so we could get started straight away and complete the next model review iteration of the Excel financial model by 9am when the deal team modeller gets back to his/her desk to start the new day on the PPP/PFI/Project Finance model.

COMMENTS

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