The benefits of a “split role” approach to financial modelling

FINANCIAL MODELLING EXPERTS

Author:

Danny Leitch

Published:

31 Mar 2014

Comments:

0 Comments

Category:

We’ve been working with a client over the last few weeks recreating their in-house financial model, and this process has reinforced my views on the benefits of a ‘split role’ approach to financial modelling.

The problem in most cases, is that it’s just not realistic for staff to obtain and apply the required level of skill to building models, alongside their already full day-to-day workload. In the majority of cases their time would be better employed focussing on the business and not wrestling with the technicalities of spreadsheet modelling.

I think to many the prospect of bringing in an outsider to solve this problem can look equally problematic.  The key word we would use to allay their concerns, as simply as we can, is most definitely ‘collaboration’.

Split role modelling absolutely necessitates efficient collaborative working – the experts in the business must seamlessly combine with the modellers, with each focussing on their strengths and avoiding their weaknesses. There is a clear loss from applying the ‘split’ but a greater gain from people who know how to deal with this interface and from being able to apply people to what they are trained to do.

We’ll be presenting and handing over our model very shortly to the client’s management team (which should be more of a refresher than a crash course because of the split role process).  This will present another opportunity to get client feedback on how a process that’s new to them has worked out, and this must be one of the critical metrics of success for the split role process.




Download the Business Analysis Lifecycle ebook


 



Avatar
Do you have a better solution than this? I’m curious to know. If you do, or if you have any thoughts on my blog, join the discussion below.If you’d like to receive more information on data visualisation, please sign up to the topic-specific mailing list.
Danny Leitch
Danny Leitch no longer works for F1F9 but we really liked his blog so we have kept it.