The Demand for Financial Modelling Skills Reaches new Heights

Finance Roles with new requirements

Have you noticed lately how many finance roles have “financial modelling” listed as a core skill? Financial modelling is now one of the most sought after skills in today’s corporate world and demand for financial modelling 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 modelling emerging as one of the most highly sought after pre-requisites. Even the term “financial modelling” 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 modelling 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 modelling consulting firm, but also joining Banjo as their CFO and consulting for a leading professional services firm within their financial and business modelling team.

Why financial modelling?

In recent years I have developed a theory that financial modelling 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 modelling 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 modelling 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 modelling becomes critical. But, no financial modelling 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 modelling 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 modelling consultancy firm and changed the way we recruited with a strong focus on financial modelling, even asking candidates to build a financial model as part of the recruitment process.

If you want to hire staff with financial modelling 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 modelling.

Conclusion

I encourage you to also take a peak at my past/present articles on financial modelling which is the foundation of business decision making, planning and forecasting.

We have also redesigned our website to help you along your journey of levelling up in this space.

We will continue to discuss this topic and you can click to follow me on Twitter or LinkedIn or subscribe to our short but sweet newsletter.

Be sure to check out our pods and video page.

Here are also some past/present blogs that might be of interest.

Forecasting skills doesn't guarantee good modelling skills

How Technology Will Change FP&A Forever

Why so many unemployed accountants are already struggling..and how I can help?

Father battles cancer, son battles career extinction

Why being a 1-man/women VCFO business is a really bad idea?

Why Vlookup (vs Index(match) shows your lack of embracing change, innovation and better Excel skills

Why a Truly Integrated Business Planning Solution Requires a Flexible Dual Architecture known as Core and Edge.

Excel is dead!

Financial Modelling Innovation: Predictive analytics vs Financial Modelling

Financial Modelling: Diamonds in the rough

Why Monte Carlo will change the way you make financial decisions and think about scenarios?

Driver Based Planning & Forecasting in the context of FP&A

Inside the mind of a spreadsheeter vs a financial modeler

Virtual CFO the Good, Bad and the Ugly

Part 3 of Finance Innovation – The Airbnb of spreadsheets - first major wave of spreadsheet innovation

Do You Model Off against the Masters of Financial Modelling?

NEED HELP searching for the best advisory tool in the market?

Part 2 of Finance Innovation - Data Analytics / Big Data is not Financial Modelling

Why I disrupted my own role and you should do the same?

Consulting, Advisory, Finance and the art of influencing is about to change forever.

Your Financial Model can save lives !

The Machines Are Not Coming… they are here!

Why financial modelling skills will be a big career door opener for emerging accounting and finance talent.

Lance Rubin is the Founder of Model Citizn, partner of theOutperformer, approved training provider to the Financial Modelling Institute and Group CFO for SequelCFO.

I have more than 20 years of combined experience working in model audit, investment banking, corporate finance, finance business partner and Fintech CFO.

Organisations I have worked with include PwC, KPMG, National Australia Bank, Investec Bank and Banjo small business lender.

I have a YouTube channel dedicates to the Future of Financial Modelling and also provide access to Models via Eloquens with thousands of viewers and downloads.