Don’t build financial models that look like @$%*&

I had a meeting in Soho house the other day. It was a sunny Wednesday afternoon. It was packed with beautiful people, media and PR types, chilling by the pool. Seemingly their job are to see and be seen – a triumph of style over substance. I was there in my suit, a slightly overweight middle aged man, attracting nothing but awkward sideways glances from the beautiful people. What are YOU doing here with US?

It is a sad fact, but in this world, appearances can count for a lot. For many people, if it looks good, it is good. If it looks bad, it is BAD.

And so it goes with financial models.

I have seen many financial models, which are beautifully presented, but when you take a look under the hood at the substance, they are shockingly put together, badly structured and filled with horrific formulae.

And guess what……..people love them. Many senior managers do not have the time (or the inclination) to delve into the detail of financial models and so, if it looks good they will take as read that the answer is right and they don’t care about the underlying structure. As we all know, this often does not end well.

On the other hand, I have seen many financial models that are beautifully structured, the calculation logic is simple, robust, transparent and easy to understand, but…….no time and effort has been given to the look and feel. Output information has not been well laid out and charts and summary information are either not present or are poorly presented. Guess what, many senior managers don’t like them at all. If it looks bad at a superficial level, it is BAD. If the model looks bad, trust in its output will be low.

Do yourself a favour, build models with substance AND style. When it comes to financial modelling, as in life, good looks can get you a long way.

Share:

More Posts

Empty road at night with lights spread across the screen from a fast moving vehicle

The FAST and the Furious

Are you furious? Are you spending your days staring at spreadsheets trying to work out what the hell is going

financial modelling done right

Those who can, audit

In the past, financial model audit has been treated as a training ground. Traditionally the brightest and best start in