MSG Team's other articles

11823 What are Unicorns?

In our day-to-day life, we often use the term unicorn to refer to a mythical horse-like creature. In the year 2013, a venture capital investor named Aileen Lee borrowed the term to describe a particular kind of startup company. The unicorn term was used to describe the startup companies which were thought to be so […]

10804 Pros and Cons of Convertible Notes

In the previous article, we studied what convertible notes are and how they are used in the context of financing a startup firm. The various terms and conditions which are generally a part of the convertible notes agreement were also explained along with the working of the note. However, before investors and founders make a […]

12408 The Barnewall Model

The traditional financial theory assumes that all investors are rational. Hence, they believe that all investors will reach the exact same conclusion with regard to investment decisions. However, we see evidence of the opposite happening in the marketplace. Even if different people have the same information, they tend to process the information differently and come […]

11862 What is FinTech and How it Enables Banking and Financial Firms to Leverage Technology

What is FinTech and how is it a Game Changer for BFSI firms? Anybody with a passing curiosity about the world of banking and finance and how technology plays an important role in the operations of such firms would surely have come across the term FinTech. Used in multiple contexts and with a wide variety […]

8973 Disadvantages of Securitization in Sports

In the previous articles, we have already seen how the use of securitization has grown in sports. We also know that the increasing use of securitization is because of certain benefits that are provided by this method of raising capital. However, it is important to note that securitization is a part of structured finance. Structured […]

Search with tags

  • No tags available.

Making assumptions is an integral part of every financial calculation. It is a known fact that if the assumptions are modified even slightly, the numbers on the model tend to change dramatically. The problem is that financial modeler is forced to make several assumptions while creating the model. When several of these assumptions are being made, it is important to create a mechanism which allows these assumptions to be managed in a coherent and easy to understand manner.

Financial modelers often do not pay attention to the management of assumptions. Since it does not involve any calculations, this is often thought to be an administrative task and is often delegated to the newest member of the team. However, the reality is that managing the assumptions is probably the most crucial task in the financial modeling process. In this article, we will explain why this task is important and also explain the mechanism which is used to manage this process.

Why is it Important to Manage Assumptions during the Financial Modelling Process?

There are several assumptions which have to be made during the process of financial modeling. If these assumptions are not properly documented, then they will remain in the mind of the modeler. As a result, people using the model and interpreting its results will have no idea where the results came from.

Several things can go wrong while documenting the assumptions related to a financial modeling project.

  • The assumptions may not be available in a written and easily comprehensible format

  • The assumptions may be scattered, and hence, the user of the financial model may not be able to find all the relevant information at the same time.

Best Practices for Managing These Assumptions

  • All assumptions related to a financial modeling project should be stored and tracked centrally. An assumptions database should be created for this purpose.

  • The assumption database should be a part of the model itself. If the model and database are two different files, the user may not download the assumption database, and hence, the entire purpose may be defeated. Also, the assumptions file may be lost or may not be updated as time progresses.

  • Also, financial models are often created in several different versions. Each version is an improvement over the previous version. In many cases, the underlying assumptions in the model also change. If the assumptions are attached to the model itself, the user need not be trained about the assumptions that have been changed. Instead, they can simply refer the document which explains the basis for various calculations which are taking place in the model.

  • It is important to ensure that the assumption document is also version controlled. This means that the initial set of assumptions should be given a number. Then when changes are made in the assumptions, the number should be changed to reflect a version change. The correct assumption document should then be mapped to the financial template. This will create a system wherein the assumptions of the model will be self-explanatory. This also makes it possible to quickly revert back to an earlier set of assumptions if the newer ones are found to be unrealistic.

Procedure for Creating an Assumptions Database

  • There are several users who may be involved in using the financial model on a day to day basis. Each of these users may have a different opinion about what should be the assumptions which form the basis of the financial model. The financial modeler needs to first identify important stakeholders whose opinions should actually be considered during the financial modeling process. These stakeholders should then be consulted to finalize a list of assumptions.

  • The financial modelers also need to include an entry date and due date in the assumptions database. This will help understand the date at which the assumptions were made and the information which the company had on hand on that given date. For instance, a lot of assumptions will be made during the initial few days. However, a lot of them may overlap with other assumptions and may hence be discarded.

  • The final set of assumptions should be given some sort of numerical ID. This ID must be updated as per the version control norms mentioned above. Also, this ID must be attached to the specific worksheets where they affect any calculation. As a result, whenever a user views any calculation, they can simply refer to the assumption ID and cross-reference it with the database to find out the exact nature of assumptions which have been made.

  • The financial modeler also has to make a decision regarding the level of detail which needs to be included in the assumption database. For instance, if the modeler assumes a 5% discount rate, he/she should explain how this rate was derived. The end-user may or may not agree with the opinion of the financial modeler. However, they will at least understand their point of view and as a result, may be able to make adjustments to their own calculations if they don’t agree with the modeler.

The reality is that financial modeling is about predicting the future. Everyone’s beliefs about the future are bound to be different. These beliefs are presented to the end-user using the assumptions database. If the user does not agree with the assumptions, they can change the calculation themselves.

Article Written by

MSG Team

An insightful writer passionate about sharing expertise, trends, and tips, dedicated to inspiring and informing readers through engaging and thoughtful content.

Leave a reply

Your email address will not be published. Required fields are marked *

Related Articles

Creating a Revenue Model

MSG Team

What is Cost Modelling?

MSG Team

Circular References in Financial Modelling

MSG Team