Enjoy complimentary shipping and easy returns on all USA and AU orders

The Arcis Man

5 secrets of great financial modelling

11 October 2019

By Dermott J. McVeigh

 

“Life is really simple, but we insist on making it complicated”

Confucius

 

The most effective financial models follow five common rules and as a result are practical and useable.  Their builders are seen as having the right blend of commercial and technical knowledge and inevitably become a core part of the management team.  So let’s have a look at these five rules:

 


1. Logic is everything

The biggest mistake people make when they try to build even the simplest of financial models is that they don’t fully understand how the business they’re trying to model actually works.  If you can’t explain it on a blank sheet of paper, then you’re not ready to open a spreadsheet to start modeling.  Starting before you’re ready inevitably results in a model that has severe structural problems and will likely need to be rebuilt.

So before you start, take a piece of paper and map out the main drivers that affect the performance of the business you’re looking at.  Include these 5 things:

If you’ve got a good grasp of the business’ operations you have the foundation to start modeling but please don’t ignore the second rule.


2. Keep it simple

Building a financial model is not your opportunity to show off your Excel formula skills. The key to building a successful model is to keep everything as simple as possible.  As you build several small layers of complexity, you’ll quickly have a complex model.  If any of your steps are too complex, the model will be unusable by anyone else and even you will struggle to retrace your steps next time you open it.

Make each step as simple as possible.  If you can easily break a step into two parts, do it.  Set your workings out in a logical manner so that one calculation leads to the next.  Remember math class at school?  There were no prizes for doing the sums in your head!

You need to assume that the next person to use your model won’t be you and won’t know what was going on in your head when you built it.  If it’s not logical with simple steps at each stage of your calculation process, the user will quickly give up and rather than getting recognized as a modeling guru, you’ll be branded as an un-commercial technician.


3. The format isn’t just for looks

Some people might think that using a consistent color scheme, font, and cell format is a waste of time.  They’re wrong.  Making sure your model looks tidy with neat formatting is crucial for most people to be able to understand it.  It doesn’t look neat and consistent, other users will quickly switch off and assign it to the corporate archives.  Here are some tips:

  1. Think about how you want people to read each sheet. You should design each page to lead the user’s eye to where you want them to start and then lead them down the page.  Try to avoid leading the user to scroll right as this breaks their train of thought

  2. Headings should be clear with a soft colouring and consistent formatting. Be careful with freezing frames, only do this to freeze information that’s relevant to the whole page.

  3. Think about naming each sheet. It should be logical and describe what the sheet is for.

If your model looks good, other users will be much more inclined to spend the time to understand it.  They’ll also find it much easier to follow what you’ve done.  You don’t need to be a graphic designer, just don’t let all your hard work get wasted because it looks unprofessional.  This is especially important for the output section of your model and you should invest some time to think through how the output dashboard will look.


4. Structure – keeping your house in order

A financial model needs structure, just like a house needs different rooms.  Your model should have three completely separate components:

  1. Input – this is where all the assumptions that drive the model are kept in a logical order

  2. Calculation – this is the engine room of the model where all the workings are performed

  3. Output – hey presto, the results of all your work are displayed on as many output sheets as necessary.

Keeping these components separate is one of the golden rules of modeling.  You need to resist the temptation to mix them when you are in the build phase as this will cause you major headaches later.  Just as you wouldn’t mix the bathroom and kitchen in a house, don’t mix your model.


5. Deadly modeling sins

I’ve seen all manner of modeling sins in my time, but there are two that stand out for their ability to confuse users and camouflage themselves:

So here’s a thought – don’t do it.  Regardless of how insignificant the formula driver is, put it on your main assumptions sheet.

It’s a poor practical joke and an even worse modeling practice.  The only conceivable exception is if you’re constructing a data table.  Otherwise, don’t do it.

So there you have it. Modeling isn’t that hard after all.  If you understand the business you’re looking at then you don’t need a PhD in Microsoft Excel.  Just keep it simple, logical and looking good.  Be disciplined with your structure and don’t commit one of the deadly modeling sins.  Like anything, the more you do it, the better you’ll get.

If you would like to learn more about financial modeling using Microsoft Excel, please click here to download our Financial modeling manual (developed in partnership with Avior Consulting).

You may also like...

Stay organized in style with our minimalistic top- Stay organized in style with our minimalistic top-grain leather card holder, carefully designed to hold 5 essentials cards so you are always ready to go.
•
#ArcisMen #PursueYourOwnLegend #giftidea #premiumleathergoods #travel #cardholder #cardholders #wallet #leatheraccessories #buyforlife #leathercraft #leather #travelgear #travellifestyle #fashion #style #gq #shopping #accessories #Essential #mensweardaily #minimalist #luxuryproducts
The Leeuwin is a writing instrument with a presenc The Leeuwin is a writing instrument with a presence reflective of the ocean current from which its name is inspired. Strong, powerful and creator of its own destiny. The Leeuwin is a weighted piece that has presence in the hand. This presence is continued through its rollerball tip leaving a deliberate and authoritative mark as you purse your own legend.
•
The Leeuwin pairs perfectly with the Arcis Journal. 🖤
•
#Arcis #arcismen #arciswomen #shoparcis #myarcis #PursueYourOwnLegend #giftidea #sterlingsilver #writing #buyforlife #writinginstruments #pencollector #penoftheday #penaddict #handwriting #Journaling #fashion #style #gq #shopping #accessories #Essential #mensweardaily #minimalist #luxuryproducts
Every detail in the Sirocco Series has been carefu Every detail in the Sirocco Series has been carefully crafted so no matter the occasion you will always make your mark. From the unique date display, surgically cut insets in both the hour and minute hands to the symmetrical chronograph dials, the Sirocco’s attention to detail will never go unnoticed.
•
#Arcis #PursueYourOwnLegend #swissmade #luxury #watches #WatchTime #WatchTimeMagazine #fashion #style #gq #WatchGang #watchesofinstagram #instawatches #watchfam #watchaddict #ilovewatches #watchlover #watchcollector #watchcollection #watchbox #watchgame #watchgamestrong #watchaddiction #watchesofinsta  #watchcommunity
The first step on any journey is to start taking a The first step on any journey is to start taking action in the direction of your goals however when our goals are big and audacious it can be daunting to start. The Arcis 12-Week Planner & Journal has been designed to get you started by providing a simple challenge. If you did one thing each week In the direction of your goals, where would you be In 12 weeks? The answer Is that you would be on a roll. You would have momentum!
•
#Arcis #arcismen #arciswomen #shoparcis #myarcis #PursueYourOwnLegend #giftidea #writing #buyforlife #Journaling #fashion #style #gq #shopping #accessories #Essential #mensweardaily #minimalist #luxuryproducts
We understand you are not here to just make up the We understand you are not here to just make up the numbers, to go along for the ride.  You want to make a difference, make your mark. We get this drive, this fierce desire to achieve. 
•
Because it’s people with this determination that make the world better. 
•
We also know your journey is unique to you. It’s your vision, your goals.
•
Arcis is here to support and inspire you along this journey with our premium collection of high-quality executive tools that are a reflection of your commitment to the journey ahead.
•
#Arcis #arcismen #arciswomen #shoparcis #myarcis  #PursueYourOwnLegend
Our writing instruments have been designed to inno Our writing instruments have been designed to innovative. We have taken the users needs in mind, resulting in the collection having offerings in fountain, rollerball and ballpoint.
•
#Arcis #arcismen #arciswomen #shoparcis #myarcis #PursueYourOwnLegend #giftidea #sterlingsilver #writing #buyforlife #writinginstruments #pencollector #penoftheday #penaddict #handwriting #Journaling #fashion #style #gq #shopping #accessories #Essential #mensweardaily #minimalist #luxuryproducts