All courses available in-class or via remote login

Coins and pens

8 SMART Tips for Financial Modelling

January 18, 2018

See below for our 8 top picks of smart financial modelling guidelines to live by

 

1- Ownership & Protection

In order to minimise risk and error it’s important that only one analyst builds and owns the model. Make sure that all old model versions are saved in a separate folder, these act as a back-up. If you password protect your cells containing formulas this will help to minimise end-user errors.

 

2- Set-Up

In the set-up of your workbooks make sure that you avoid having multiple workbooks where possible. All references to external links should be clearly identified and imported to an “input sheet”. Once this is complete reference as required.

Setting up your work books correctly is important in order to provide more transparency.

 

3- Structure

One of the best ways to structure your financial modelling workbooks is to set up your menu, inputs, calculations and outputs &reports in that order. In your menu make sure there are hyperlinks to all relevant sheets. For your inputs make sure that you clearly identify your cells for data entry. Your calculations are the engine room of the model and should be protected. Finally set up your outputs and reports.

 

4- Inputs

When setting up your inputs it’s important to make sure that they are separated from your calculations. This way users know exactly where they need to enter data. It also reduces the likelihood of a user inadvertently tampering with calculations. When inputting data it’s also important to make sure that you only input the data once and then always refer back to this cell. Therefore, future changes to this input only have to be updated once and this in turn avoids potential inconsistencies.

 

5- Formatting

When formatting your work books make sure that you are consistent in your formatting. This makes it easier for co-workers to get a handle on a new model if they are familiar with the formatting.

Consistent color coding and formatting of inputs is also a must.

 

6- Calculations

When it comes to calculations there are a number of things to keep in mind. Have a look at our list below:

- Simple is best - Always opt for formulas over VBA where possible - Aim to have one consistent formula on each row or column - Keep column and row headings consistent - Test your calculations as you build, add error checks - Limit the use of modelling tools such as spinners as they introduce an extra layer of complexity

7- Outputs

For your outputs, we recommend one summary sheet displaying all key results and metrics. You can always add additional reports, charts and dashboards to suit business needs.


8- Documentation

Models should be logical and self-explanatory but may require supporting documentation. Make use of comments and add user guidelines where necessary for more complex calculations.

 

Take a look at out Specialist Microsoft Excel Financial Modelling course to learn more skills.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 24317 Reviews
It was very educational. Steven explained all very clear. I definitely will use it in my work. cheers -Excel Advanced Brisbane
Olga - Excel Advanced, .
Found a number of things that I will be able to take back to the office and use. Steven presented and kept things flowing well. -Excel Advanced Brisbane
Amanda - Excel Advanced, .
The session was delivered in efficient way. Gained so many knowledge, new way of creating report based on data available. -Excel Advanced Brisbane
Ratih - Excel Advanced, .
Steven is a great tutor -Excel Advanced Brisbane
Donna - Excel Advanced, .
Great session. Very helpful. -Excel Advanced Brisbane
Jacinta - Excel Advanced, .
Steven was very patient, very knowledgeable and I learnt a lot while having a great time. Thanks heaps :) -Excel Advanced Brisbane
Chris - Excel Advanced, .
great course thank you -Excel Advanced Brisbane
Jodi - Excel Advanced, .
Good Course -Power BI Advanced Brisbane
Sunmeen - Power BI Advanced, .
Well done, knowledgeable presenter -Excel Advanced Brisbane
Chester - Excel Advanced, .
Great pace and content, trainer explained everything very well. -Power BI Advanced Brisbane
Ana - Power BI Advanced, .
Another very informative day with a full morning on DAX, a good look at dynamic row level security and other useful tools. A lot of information, but very helpful! -Power BI Advanced Brisbane
Karen - Power BI Advanced, .
It went a bit fast for topics that were new to me. For topics that I had a good understanding the pace was fine. -Power BI Advanced Brisbane
Robin - Power BI Advanced, .
Very informative, learnt a lot in one day! -Power BI Advanced Brisbane
Ashlee - Power BI Advanced, .
very good session -Power BI Advanced Brisbane
Lucy - Power BI Advanced, .
great session, very informative Jason is a great teacher! -Power BI Advanced Brisbane
Peter - Power BI Advanced, .
valuable session and definitely learnt some new things around our reporting presentations moving forward but also around our animations. Loved how interactive it was and that it is hands on being able to do the live training. -PowerPoint Level 2 Brisbane
Charmaine - PowerPoint Level 2, .
Stuart was a fantastic presenter. He really engaged everyone. I learnt a lot of great tips and tricks and can see them being used on a regular basis. Certainly some "ah ha!" moments too. Run really well and highly recommend Stuart as a presenter. -PowerPoint Level 2 Brisbane
Katrina - PowerPoint Level 2, .
Good presentation. Kept the day interesting and lots of learnings even though this is not my first powerpoint training session. Learnt some great useful skills I'm looking forward to trying out soon! -PowerPoint Level 2 Brisbane
Celia - PowerPoint Level 2, .
Stuart was very personable and an engaging presenter. -PowerPoint Level 2 Brisbane
John - PowerPoint Level 2, .
thank you Stuart, enjoyed the course very much, had a lot of take away. -PowerPoint Level 2 Brisbane
Susanna - PowerPoint Level 2, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us