All courses available in-class or via remote login

The Bespoke Nature of Financial Models

I have built and worked with countless financial models over the years. Financial modelling requires bespoke models, predominantly built to evaluate or assess a specific type of project. This doesn’t imply that they are static. In fact that are often quite dynamic and enable the user to run a multitude of scenarios and sensitivity tests. The bespoke nature does however, mean no two models look the same. Whether building a model to value a business, assess an investment opportunity or run scenario analysis. However, keep in find a few key elements:

1. One Owner

Although circumstances don’t always permit, it is better to have one person take ownership of the model from start to finish. Having one person responsible for the full build helps to reduce any gaps in the model or error arising from misunderstandings.

2.  Clear Structure

It sounds logical but you would be amazed by the amount of poorly structured models I have come across. This often arises because a model has grown overtime and has moved away from its initial humble beginnings but poorly structured models are difficult for others to use and understand. When constructing your model remember to lay it out clearly. Most models can be broken into the following sections:

  • Menu
  • Inputs
  • Calculations
  • Outputs

3. Separate Inputs

It’s vital to clearly identify and separate inputs from calculations. Ideally all inputs are set up on one tab and then the model refers back to these as required. Avoid entering inputs or hard values in formulas buried in the model as this makes changing them in the future very difficult and limits the flexibility of your model.

4. Formatting

Formatting should not be overlooked. Having well formatted models that use consistent formatting e.g. shading all input cells in the same colour or laying out reports in the same format will make your model easier for others to use and understand. Consistent formatting applied across an organisation also makes it easier for other team members to get to grips with your models quickly. They intuitively know where to look.

5. Keep it Simple

Above all else in keep it simple! Yes, at times we need to use nested ifs and more complex formulas but where possible break them down into simple steps. This limits the potential for error, helps you to troubleshoot more quickly and makes auditing and understanding the model more straightforward. We don’t need to dazzle with complexity, we need to produce robust and accurate models.

Good luck!

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23724 Reviews
Very detailed and has given me a good start with Power BI. -Power BI Beginner Brisbane
Jessica - Power BI Beginner, .
Terrific course. Well explained. Thoroughly enjoyed -Power BI Beginner Brisbane
Keirin - Power BI Beginner, .
Excellent course, well run and good topic coverage. Looking forward to the intermediate course. -Power BI Beginner Brisbane
Allister - Power BI Beginner, .
Steven is always a great trainer, a lot of content I can use at work. -Power BI Beginner Brisbane
Tys - Power BI Beginner, .
Very good advanced information. -Power BI Intermediate Adelaide
Rhett - Power BI Intermediate, .
Great session. Jagg is brilliant in the way he is able to present in an online forum. -Power BI Intermediate Remote Online
Brett - Power BI Intermediate, .
Great session -Power BI Intermediate Adelaide
Emily - Power BI Intermediate, .
Excellent -Power BI Intermediate Adelaide
Hikkaduwa - Power BI Intermediate, .
Good beginner's introduction to Office 365. Thank you John! I would like a certificate of completion please. -Office365 Beginner Remote Online
Yieng - Office365 Beginner, .
I learned a few new things which was great -Office365 Beginner Remote Online
Jacqui - Office365 Beginner, .
thank you -Office365 Beginner Remote Online
Cindy - Office365 Beginner, .
John provided very good training and it will really helpful to myself and our organization. We have learn a lot new things. really useful -Office365 Beginner Remote Online
Chetankumar - Office365 Beginner, .
good overview of Office 365. Good use of MS Teams to deliver training. -Office365 Beginner Remote Online
Nathaniel - Office365 Beginner, .
Great session that was easy to understand - thank you -Office365 Beginner Remote Online
Aaron - Office365 Beginner, .
thanks John he was really engaging and clear on how we can use Office 365 -Office365 Beginner Remote Online
Marc - Office365 Beginner, .
Great training. John was very engaging and covered a lot of content. Customised to our needs and where we are up to in our O365 journey. Thank you! -Office365 Beginner Remote Online
Emily - Office365 Beginner, .
loved it, very clearly explained good interaction and very helpful -Office365 Beginner Remote Online
amy - Office365 Beginner, .
Well rehearsed. Very informative. Very knowledgeable. -Power BI DAX Brisbane
Julian - Power BI DAX, .
Great presenter, willingness to answer questions (even when off topic) was appreciated. -Power BI DAX Brisbane
Bill - Power BI DAX, .
Enjoyed the course, plenty of content to digest. -Power BI DAX Brisbane
Tim - Power BI DAX, .

Trusted by Business

Procured by Government

Map of Australia

Follow us