The Demand for Financial Modeling Skills Reaches new Heights

Finance Roles with new requirements

Have you noticed lately how many finance roles have “financial modeling” listed as a core skill? Financial modeling is now one of the most sought after skills in today’s corporate world and demand for financial modeling experience continues to outstrip supply! The changes we see in our everyday lives are reflected in the corporate world and the finance industry is no exception.

Over the past decade our lives and the way we interact with technology has changed significantly. Consider how we listen to music today compared to the past (Spotify), how we watch television (Netflix), how we travel (Uber) or how we communicate and talk to others (WhatsApp, Viber, Skype and social media).

It should therefore come as no surprise that the core skills of finance professionals too have changed significantly with proficiency in financial modeling emerging as one of the most highly sought after pre-requisites. Even the term “financial modeling” wasn’t as widely used as it is today nor was it easy to predict that the specialist skill that was previously contained within Corporate Finance or M&A transactional modeling teams would now become a core requirement of the mainstream finance role.

Over my 18 year career in financial services across professional accounting firms, corporate finance and advisory as well as retail and wholesale banking businesses, I have watched with interest the rise in the demand for “value add” services from a finance function. This interest has not only led me to establishing Model Citizn, a specialist financial modeling consulting firm, but also joining Banjo as their CFO and consulting for a leading professional services firm within their financial and business modeling team.

Why financial modeling?

In recent years I have developed a theory that financial modeling expertise has become the predominant talent requirement for career advancement in Finance and it seems I’m not the only one with this opinion. Two large professional firms previously published white papers on a related topic which is easy to understand but much more difficult to implement. The Ernst & Young paper “The DNA of the CFO” (published in 2010) and the Deloitte paper “Changing Focus: Finance business partnering in Australia” (published in 2013) both point to the changes in services and expectations on CFOs and their teams to deliver more insight and strategic decision making that is commercially on point. The words “insight”, “strategic decision making” and “trusted advisor” all rely on financial modeling as a key ingredient in both producing, extracting and delivering this value-add.

As a member of a Finance team it’s just not good enough anymore to simply deliver the historical results and explain what happened, (even with the ubiquitous fancy dashboard report!). The harsh reality is that no one cares unless that explanation can be used to make a strategic decision which will enable real value creation and hence incremental increase in the valuation of the company, its returns or efficiency in the capital structure.

In my experience those explanations, although valuable, generally arrive too late to be of any significant use as the business has already moved on. The rate and quantum of changes to business trading conditions are so rapid that even 24 hours to make a decision might be too long. Think about an importing or exporting business that has just witnessed the Aussie dollar drop below 80 cents to the US $ or a transport company seeing petrol prices drop below $1.10 per litre. A decision on the price at which to take advantage or hedge against these movements to manage business performance becomes critical. Whilst some larger businesses may have a treasury function, many don’t, and the finance function needs to understand the impact on the overall performance, updated forecasts or budget setting.

To be able to answer some of the businesses’ most complex questions, such as those above, and provide insight requires strong modeling skills to dynamically adjust the future performance of the business given changes to certain key assumptions like currency and petrol prices. Some of these assumptions are so sensitive that “back of the fag packet” just won’t work anymore. I’m not suggesting that a high level sense check isn’t worth doing — it is always good to cross check the more detailed bottom up analysis. A robust three-way model that is updated monthly to enable re-forecasting and iteratively refining the business algorithm of future performance becomes very powerful and at times critical for the survival of the business during difficult trading conditions

Transforming Finance isn’t easy, but incredibly valuable

Not so long ago I was charged with trying to transform the role of finance partners in a large banking institution. The evidence supporting the transformation was sound, and the road map had been laid out clearly, but multiple attempts at moving the teams towards the “trusted adviser” had failed. In my opinion it wasn’t the lack of drive, senior leadership buy-in or people’s interest that had led to the failure but something more fundamental. The crisp and clear articulation of what the change would look like on a practical level, once successful, was missing. The picture of what the new world looked and felt like was still too grey to enable people to trust the roadmap and the change itself.

On the surface it sounded great when we used words like “so what?” to help people understand insight, but this was still too obscure e.g. so what if revenue dropped? We then moved to words like “now what?”, which was closer to being more action and decision orientated but still not quite there.

However, to answer a question like, “now what?” one has to hypothesise by making a bunch of assumptions and testing these through time. It’s at this point that expertise in financial modeling becomes critical. But, no financial modeling training was ever provided to the team and it was assumed that everyone who used Excel (which is pretty much the entire function) were great modellers or analysts. I mean, why shouldn’t they be? They have all been using Excel for decades, so surely they can do it? This was the missing piece of the puzzle in executing this transformation and an assumption that was deeply flawed.

Of course, we know that the skills needed to be a good financial modeller go quite a bit further than simply having good Excel skills. If the person performing the analysis doesn’t have the ability to create a robust, dynamic, rolling driver based financial model to test hypothetical scenarios how can you ever answer a question like “now what?” accurately? The skills required to build a robust three-way model is as different to using Excel day to day as riding a bicycle is to MotoGP. One could try and assume that riding a bicycle is no different to riding a motorbike, but racing around a MotoGP track is very risky and dangerous if you don’t know how to control the bike around a bend.

If you can’t change them, hire them

When I was hiring finance professionals, in my previous role as the Head of Performance Management in a major banking institution, I soon discovered that the hires I made with strong financial modeling skills were able to add significantly more value and quicker than those without it. I subsequently started to roll out internal training courses with a leading financial modeling consultancy firm and changed the way we recruited with a strong focus on financial modeling, even asking candidates to build a financial model as part of the recruitment process.

If you want to hire staff with financial modeling skills use the interview scripts that I wrote on the Vervoe hiring platform.

As more of the finance production activities (preparing management and statutory reports) gets automated and offshored there will start to be an ever increasing focus on finance teams adding more value through insights and financial modeling.

Author, Lance Rubin is the CEO and Founder of Model Citizn ( a specialist financial modeling consulting firm.