Business Analysis Lifecycle ebook: Conceptual Modelling

Business Analysis Lifecycle ebook: Conceptual Modelling

Author:

Andrew Berkley

Published:

31 Aug 2017

Comments:

1 Comment

Category:

We have taught analysts from hundreds of companies to build financial models. Financial modelling proficiency requires skills that take time to acquire, develop and perfect.

Sometimes the difficulties students have are related to how to build their model. More often, difficulties relate to what it is they need to model. Once the modeller understands how a particular area of a business works commercially, it is much more straightforward to create a spreadsheet model.

We recommend that students begin with a sound conceptual understanding of what it is they must model. If they are confident that they understand how an area of the business works, they may press on and open up Excel. If not, they should spend the time required up front to acquire that understanding.

Conceptual understanding may be acquired by talking to people within the business who do understand the business situation, or by creating flow diagrams that set out the commercial and financial ingredients of the business.

It is helpful to start with the line item being modelled—for example “Revenue”—and to keep asking the question “what drives that?” until you cannot go any further. The sample flow chart below shows what this might be like.

Andrew Berkley
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.
Andrew Berkley
Andrew has spent one half of his career as a finance professional and the other half in learning and development running finance-based training courses. Andrew leads the senior team at F1F9. He has been with F1F9 since 2013.