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.

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21505 Reviews
So much was covered and John stayed back to ensure we did not miss any of the curriculum, fantastic -Office365 Beginner Melbourne
Julie - Office365 Beginner, .
I was the only student so everything was tailored around me which was fantastic -Office365 Intermediate Perth
Julie - Office365 Intermediate, .
Overall training was good -Power BI Beginner Perth
Archie - Power BI Beginner, .
Great intro to Power BI -Power BI Beginner Perth
Ara - Power BI Beginner, .
Thanks David. Good start into the Power BI World. -Power BI Beginner Perth
Juanita - Power BI Beginner, .
Great course, I have learned a lot that I can implement in my workplace. Thanks Steven -Office365 Intermediate Brisbane
Jules - Office365 Intermediate, .
Great, while I knew most of it I obtained some golden ideas. See you in a month for the advanced course. -Office365 Intermediate Brisbane
David - Office365 Intermediate, .
Very useful thank you. Jagg has been very nice and helpful. -Excel Intermediate Adelaide
Cassia - Excel Intermediate, .
Great course. Learnt so much -Excel Intermediate Adelaide
Kacey - Excel Intermediate, .
It was great! Very great at explaining concepts. -Excel Intermediate Adelaide
James - Excel Intermediate, .
Course was very informational, however, I probably should have done the advanced class - it was a lot of stuff I already knew with a few hidden advantages. Course trainer Jagg is very knowledgeable and hosted a professional training session, -Excel Intermediate Adelaide
Chantelle - Excel Intermediate, .
clear and useful information, Jagg kept the course interesting and was very helpful. thank you. -Excel Intermediate Adelaide
Vanessa - Excel Intermediate, .
Course will be very useful for new role at work. -Power BI Beginner Melbourne
Alex - Power BI Beginner, .
Thank you -Power BI Beginner Melbourne
Amonrat - Power BI Beginner, .
Well done. Now I will practice -Power BI Beginner Melbourne
Jamie - Power BI Beginner, .
It was interesting. Learnt a few new things -Power BI Beginner Melbourne
Purva - Power BI Beginner, .
Great session, very simple to use and easy to follow along. Thanks for a great session. -Power BI Beginner Melbourne
Lindsey - Power BI Beginner, .
great beginner course! -Power BI Beginner Melbourne
Sarah - Power BI Beginner, .
John was really good at explaining and answering queries. Few technical difficulties with some students who is was able to sort out there problems. -Power BI Beginner Melbourne
Aaron - Power BI Beginner, .
Good session, very informative and took a lot from it -Power BI Intermediate Sydney
Nathan - Power BI Intermediate, .

Trusted by Business

Procured by Government

Map of Australia