Spreadsheet Modelling

Experts in Spreadsheet Modelling

If your business needs a complex business model, financial model or any type of spreadsheet model, especially in a short period of time, we can help.  For the last 30 years we have been building rich, data-driven, parameterised and robust models for corporates and medium sized businesses.   We often provide these services to management consultancies but we also work directly with businesses themselves.

How We Do It

Firstly, if you would like us to sign any confidentiality agreement we are more than happy to do so.  We handle your data and information extremely carefully and confidentially.

Once we have access to your data we then collate all the relevant data sources and make sure that these are structured in a way so that this data can either be appended to or refreshed, paying particular attention to how the data sources may change over time.  From this we can start to identify all the business drivers and organise these business drivers into categories.  These will be the assumptions driving the model.

Of course, if you have an existing model we can certainly also work with that.  If new components are needed they might be added in the manner described here.  However, if there are existing templates/conventions we will work with those - whatever makes the most sense.

We then start to prepare the formulae that extract information, depending on how the information is structured and what we need to extract, we may use pivot tables or we may use Excel formulae to drive the calculations.  Named ranges are set up with our hierarchical naming structure which makes the formulae far easier to read and to know from where the inputs are coming.  If appropriate we will use array formulae which acts as a safeguard against accidentally editing a formulae whilst also reducing the size of the model.

All changes made to the model are documented using in our version control process so that we know what changes were made when and by whom.  Where possible we will validate the models accuracy using existing data sets so we can be confident in the results as well as doing sanity checks throughout the model.  We typically share the development of the model with our client as it is being built to make sure nothing has been missed and that methodology we are following is sound.  Development of these models is a very rapid process, usually completed in 6-12 weeks.

Our models are typically structured so that we can run sensitivities if required and to allow for future enhancements or developments.  When working with other team members we set up interface contracts at the start of the project so that the models can be quickly integrated.

Lastly, we document how the model works, how it is run and how it can be updated so that anyone else can pick up the model and use it.  Whenever we do any modelling work, the results of that modelling work belong to you.  You have full access to all the worksheets and code, if any is required.  We do not retain any intellectual property rights on what we build for you.

Many of our models continue to be used by the business for years to come which attests to their robust design and ongoing relevance to the business.

What Our Customers Are Saying

First used your services back in Feb 2019 for assistance with Google ad words, and your professionalism and the results you got were excellent. Your punctuality and reliability in doing a wide range of analytical work now, often ad hoc, for us and our clients is truly appreciated. You guys are amazing!

Growth Potential Greg Betty - Managing Director

Council Jobs’ ability to provide councils with detailed subscriber profiling information than the big job seeking sites such as Seek and CareerOne make it more attractive site for councils as they can better target prospects. Analytical Models has helped Council Jobs to deliver on that key point of differentiation. Analytical Models’ extensive experience in working with data has been central to delivering insights we can share with councils allowing us to set ourselves as a superior destination than the larger players. Their ability to handle dirty data was certainly very handy as there was more than enough to cause problems for a company less experienced. We have found them to be extremely professional but also very easy to work with. Am already planning our next tranche of work with them and highly recommend them to others.

Council Jobs Tony Miller - Director

Andrew has been consulting to our company for since 2019 and his work has improved consistency in liability estimating, financial management reporting and intellectual property protection across a range of self insurance programs.
Andrew is very customer service orientated and we recommend his services to our clients across Australia

Health and Injury Management Solutions (HIMS) Chris Douglas - Managing Director

Andrew is one of those rare breeds where he can traverse effortlessly between the complex with strong attention to detail, but with the ability to communicate in a simple, understandable and value orientated manner. His professionalism is unquestionnable.

Engage Energy Solutions and Energy Bill Doctor Tim Wolfenden - Managing Director and Owner

I have had the pleasure of working with Andrew on a variety of projects since 2017. He is a highly reliable and vastly experienced expert in his field and always managed to impress me with his customer centricity and outstanding professionalism. His excellent, accurate and detail-oriented models often were a key factor in the successful delivery of our projects.
Furthermore, he is an excellent communicator and team player with an easy going and friendly nature who is always willing to go the extra mile to make a project a success. Highly recommended!

Detecon Dennis Juchem - Senior Consultant

Analytical Models has been a saving grace for our business. Their reports are accurate and reliable, which saves us time on tedious tasks like data crunching by providing quick updates about how things stand in Google AdWords or Marketing campaigns; not only do they provide this information but also insights into what needs adjusting so that we can improve results further down the line! Their marketing reporting and AdWords capabilities are second to none! We highly recommend them.

Sales SEO & Social Media Kaylene Grieve - Managing Director

Thanks for getting the AdWords set up so quickly. Very much appreciated!

MBE Parramatta and Australian Christmas Cards Charles Batt- Managing Director

Definitely a big improvement in a very short amount of time! Thank you so much for the updates, I really appreciate you checking in!

Mindful Me Kara Markovics - Business Owner

Analytical Models impressed us with their professionalism in being able to very quickly understand, extract the key information from our financial team with minimal effort from them and to quickly build an easy-to-use model which accurately modelled our complex business.  Without a doubt they plugged the key gap and created fantastic value for us, love their work and cannot recommend them highly enough.

Muscle Meals Direct Jochen Bonitz - Owner

Landcare’s very successful data migration was largely attributed to the expertise of our data migration partner Analytical Models.  Analytical Models’ extensive experience with complex data migration exercises was clear throughout the project as they led the migration effort with minimal involvement needed from Landcare.  They were responsive, professional and pro-active in the way they ran the project, we are very pleased with the outcome achieved.

Landcare Tessa Jakszewicz - CEO

Why We Do It

Our passion is helping businesses unlock insights about their markets, industry and customers through analysing their data and using those insights to guide the business to more profitable opportunities and helping with the management of those opportunities.  We model the world in which you operate and create a rich, parameterised and well designed spreadsheet model of your business.  Through that model you can explore, evaluate and identify the key factors that need to be managed.  We get a real buzz out of being able to build that model for you, seeing how the profitability of the business can be impacted by different combinations of business drivers is endlessly fascinating.

Some of Our Clients

Vodafone
Virgin Mobile
Detecon Consulting

What Best Describes Your Situation?

  • Modelling expert needed: whether it be Microsoft Excel or Google Sheets we have extensive expertise working with both tools to build rich, robust, parameterised and data driven models.
  • Need a Consultant: we have an upcoming project and we need a financial/commercial expert to join our consulting team.
  • Need to build a model for potential investors: we are looking to raise capital and need a model we can share with investors to show the drivers for our business and the value of the opportunity at hand.

How Best Can We Help?