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 25938 Reviews
Being custom arranged for what is used in this workplace was a large benefit and Steven use the Nexacu examples but made sure he referred to how it related to QR examples. -Excel Customised Brisbane
Phoebe - Excel Customised, .
Course was use full. Step by step analysis of formulas and executing them was very much usefull. -Excel Customised Brisbane
Karan - Excel Customised, .
Good course -Excel Customised Brisbane
Mark - Excel Customised, .
Well constructed 1 day course. I felt it was at a good pace, worth while in certain items and excellent presentation. Steven did not go too far without ensuring everyone was up to date! Time to get some practice! -Excel Customised Brisbane
Colin - Excel Customised, .
Good and efficient training. -Excel Customised Brisbane
Sabine - Excel Customised, .
Very well run course -Excel Customised Brisbane
Sam - Excel Customised, .
A very informative course. -Excel Customised Brisbane
Andrew - Excel Customised, .
Steven was great, thank you -Excel Customised Brisbane
Tahlia - Excel Customised, .
Very useful -Excel Customised Brisbane
Nadia - Excel Customised, .
Great Session,Steven was very knowledgeable, kept us on track, willing to answer questions and very engaging. Thank you Steven. -Excel Customised Brisbane
Caralee - Excel Customised, .
Well presented and informative -Office365 Advanced Adelaide
Annie - Office365 Advanced, .
The instructor (Michael) is very good in explanation and has a good example to make everything clear and easy to understand. -SharePoint Site Owner Sydney
Nawaporn - SharePoint Site Owner, .
This has been a thorough learning experience covering all aspects SharePoint. The training was delivered professionally and was easy to understand. -SharePoint Site Owner Sydney
David - SharePoint Site Owner, .
Course was well run. -Office365 Advanced Adelaide
Stacey - Office365 Advanced, .
Great! Very easy to follow and informative -Power BI Beginner Melbourne
Connie - Power BI Beginner, .
Progressed at a good pace but Ken was happy to go back over something if required. Came away with a good foundation to start working with data. -Power BI Beginner Melbourne
James - Power BI Beginner, .
Thank you -Power BI Beginner Melbourne
Phill - Power BI Beginner, .
A Good Start for Power BI -Power BI Beginner Melbourne
Peter - Power BI Beginner, .
very well presented. great pace, easy to understand and keep up -Power BI Beginner Melbourne
Wendy - Power BI Beginner, .
Great session for learning how to navigate p/bi at the foundation level. -Power BI Beginner Melbourne
catherine - Power BI Beginner, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us