“I built the worst financial model in the world!”

Blog

Blog

Blog

Blog

all posts

tags

“I built the worst financial model in the world!”

by Rickard Warnelid on July 22 2009

There are numerous awards in the financial industry for strong performance and market leading developments and they are followed with a great deal of interest. This is not to dissimilar to the entertainment industry where awards are so common it is hard to keep up to date with them all.

One key differentiator between the types of awards between these two industries is that in the financial industry there are (to my knowledge) no awards for the worst performance.

Annual award night for the worst financial models

The financial modelling industry really needs some officially bad models to use as warning examples to junior modelers just joining the industry. At present most people are afraid of sticking their head out by saying that such and such build really bad models as it is not a very nice thing to say. It would be SO refreshing to hear this discussion in a bank negotiation:

“Did you hear that MegaBank won the award for the worst model of the year?”

“I am not surprised! They have never had any in-house capability for financial modelling and I am happy that this knowledge is now made public.”

The prize for the overall award - the worst financial model of the year - should be a hefty amount of money so that the person who built the model simply retires straight away without any intention of transferring his/her knowledge to someone else.

Special awards for particularly bad financial modelling

  • The longest Excel formula
  • The most confusing summary sheet
  • The largest number of named ranges (I know who would win this one….)
  • The longest recorded VBA macro
  • The worst colour scheme
  • The most incorrect model
  • The biggest balance-sheet imbalance

Award night 2009 - send your nomination!

If no one else volunteers to host this event for 2009, I will do what I can to get this going.

Nominations anyone?

COMMENTS

Andy: Ha ha, classic!

Andy: Ha ha, classic! TimB: That is certainly a very interesting approach... I have seen something similar with *1 to convert TRUE/FALSE to integers but your example takes financial modelling creativity to a new level!

I was expecting the classic

I was expecting the classic punchline "that's why I became a model auditor!

Maybe we could start off with

Maybe we could start off with just formulae, that way no one gets offended and confidentiality is assured - just came across this belter today =(100%*D20)/((100%-E20)*100%)+((100%*E20)/(100%-E20)*100%) I must admit it had never occurred to me to add into a modelling training course the rule "don't multiply every term of a formula by 100%" so no wonder this type of thing occurs!

Hi Patrick, Eusprig 2010

Hi Patrick, Eusprig 2010 would definitely be a good forum for an event like this! I have had a few nominations already and the challenge will be to overcome the confidentiality issues. Also, it is hard to nominate someone as it is likely to be your client, colleague or boss who has built the financial model... All of those three categories are likely to cause a bit of tension... Sorry about the faint grey colour scheme...

If no one else volunteers to

If no one else volunteers to host this event for 2009, I will do what I can to get this going. hey let's do it at Eusprig 2010 I hope I wrote Eusprig 20 10 vbecause I cant see my typoing on this damn faint grey coloyr scheme

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