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!

What is Remote Training?

Valued by Individuals

4.8/5
Over 22036 Reviews
It has been a great experience. The reliance of subjects was related to my requirements. There was a great opportunity provided tailor an example to finish the course. -Excel Macros/VBA 2 Day Brisbane
Nicholas - Excel Macros/VBA 2 Day, .
Great Course, learnt alot and was easy to follow -Analysis & Dashboards Melbourne
Julia - Analysis & Dashboards, .
Excellent Training session -Analysis & Dashboards Melbourne
Rashmikant - Analysis & Dashboards, .
This course enhanced my knowledge in Excel -Excel Advanced Parramatta
Maria - Excel Advanced, .
Good Course -Excel Advanced Parramatta
Baminahannadige - Excel Advanced, .
Michael is a very good teacher, he is very thorough with his explanations. Knows how to deliver the message across very well, is clearly very experienced with Microsoft. I would definitely recommend him and would enrol for another one of his classes if need be. -Excel Advanced Parramatta
Estephanos - Excel Advanced, .
Course was quite good, I picked up quite a few things but as there is so much to cover some things were skipped through quite quickly. Jag was very good at making sure everyone understood. -Excel Intermediate Adelaide
Bev - Excel Intermediate, .
It was a great day - learnt a lot of new things :) -Excel Intermediate Adelaide
Deborah - Excel Intermediate, .
very well explained, easy to understand -Excel Intermediate Adelaide
Borbasi - Excel Intermediate, .
Very well Done -Excel Intermediate Adelaide
Vladimir - Excel Intermediate, .
Excellent. Good pace and learnt lots -Excel Intermediate Adelaide
Debra - Excel Intermediate, .
Jason covered the content well and was great at explained everything -Excel Intermediate Canberra
Lisa - Excel Intermediate, .
Great course & Jason was a great facilitator. Challenging working remotely on a laptop. I personally didn't have two screens available & I think that would make it a lot easier to navigate but that aside, the pace of the course allowed for minimal inconvenience. -Excel Intermediate Canberra
Kyle - Excel Intermediate, .
Very informative. Thank you for a great lesson -Excel Intermediate Canberra
Peter - Excel Intermediate, .
Great Course! Very informing and helpful! Great teacher who encouraged questions and answered them thoroughly; thank you! -Excel Intermediate Parramatta
Charbel - Excel Intermediate, .
good and prompt view of using excel -Excel Intermediate Parramatta
Vincent - Excel Intermediate, .
Very good and fast paced course with very key concepts covered. -Excel Intermediate Parramatta
Vladimir - Excel Intermediate, .
A great course to understand some extra perks on Excel Michael was very helpful and engaging! Would recommend this course -Excel Intermediate Parramatta
Joseph - Excel Intermediate, .
Good crash course and very helpful -Excel Intermediate Parramatta
Mohan - Excel Intermediate, .
Ken was really great, very passionate about experienced presenter. Really enjoyed the intermediate session. Got a lot of useful tips on how to work more efficiently in MS Project Professional. Thanks Ken -Project Beginner - Project Intermediate Remote Online
Therese - Project Beginner - Project Intermediate, .

Trusted by Business

Procured by Government

Map of Australia