MSG Team's other articles

10189 What is Litigation Funding?, Its Advantages and Disadvantages

Legal costs have long been a deterrent for people wanting to file lawsuits. In a country like America, the legal fees can be significant. A lot of good lawyers charge hourly fees. Many plaintiffs believe that in an hourly fee system, the lawyer is incentivized to drag the case for as long as possible. This […]

12169 Pros and Cons of Banking as a Platform (BaaP)

We know the way in which Banking as a Platform (BaaP) is using technology to revolutionize the commercial banking industry. We also know how Banking as a Platform (BaaP) is different from Banking as a Service (BaaS). However, it is still important to understand the various pros and cons of Banking as a Platform (BaaP). […]

10892 Limitations of Ratio Analysis

Ratio analysis, without a doubt, is amongst the most powerful tools of financial analysis. Any investor, who wants to be more efficient at their job, must devote more time towards understanding ratios and ratio analysis. However, this does not mean that it is free of limitations. Like all techniques, financial ratios have their limitations too. […]

9338 Financial Modelling: Advantages and Limitations

Financial models are used by corporations almost every day. These models help while making several key strategic decisions. For instance, if a company plans to enter a new country or even take over another company, it is likely that it will create a financial model first. This model is a way of generating “What-If” information […]

12603 Calculating Free Cash Flow to Equity

We studied the different methods to calculate the free cash flow to the firm (FCFF) in the previous articles. In this article, we will learn about how to derive free cash flow to equity (FCFE). Here too there are multiple methods involved. However, since we already have a background in calculating cash flows, we need […]

Search with tags

  • No tags available.

A heuristic is a technological term for what is known as a “thumb rule” in common parlance. In the previous article, we discussed the guidelines which need to be followed from a conceptual point of view.

However, in this article, we will discuss heuristics more from a technical standpoint. The common points which need to be taken care of and the common mistakes which need to be avoided have been discussed in detail.

Never Use Constant Values

One of the biggest mistake made by financial modeling amateurs is that they often forget to separate the inputs from the calculations. For, instance, many times companies begin their cash flow calculations from their net profit after tax number.

For simplicity sake, a financial modeler may assume that the net profit percentage is 25%. However, it is important that this 25% is not directly entered into the formula in the form of a constant value. Instead, a variable called net profit after taxes should be created. The value 25% should then be entered into that variable. This variable should then be present in the input sheet.

Avoiding the use of constant values is essential to ensure that downstream calculations are not affected.

For instance, tomorrow if the company wants to change the assumption and enter a 30% net profit after tax, it would mean chaos if the input was not separated from the calculation. The financial modeler will have to find out each and every point in the model where this 25% number was entered and then change it to 30%.

On the other hand, if a variable was used instead of a constant, the value just needs to be changed at one place i.e., the input screen. All variables in the calculation automatically link to the input screen. Hence, if the value is changed once on the input screen, all the values get updated automatically.

Using constant values can be disastrous from a long term point of view. Constant values make the model static. Variables help to keep the model dynamic as they allow their underlying assumptions to be changed.

Managing Circular References

A circular reference is when the value of a variable is dependent upon itself. In most cases, this is a mistake being made by the financial modeler. However, there are some calculations which legitimately require circular references.

For instance, the interest expense which will be borne by a company depends upon the outstanding loan balance that the company has. However, the outstanding loan balance itself may depend upon the interest expense in a given year! In places like this, circular calculations are not conceptually incorrect.

The financial modeler needs to use his/her skill to ensure that circular references are managed correctly.

Building Flexibility

A model is said to be flexible when it can be used by many different users to manage many different situations. Building financial models is an expensive proposition. As a result, companies cannot afford to build a new model every time. Hence, they need models to be flexible.

It is, therefore, important for the modeler to ensure that the inputs and outputs of the model can be changed to suit different decision-making needs. Otherwise, building a financial model is just an elaborate, roundabout way of creating a decision model which will only be used one time!

Building Intuitiveness

Financial models are built by people who are well versed with both technical as well as finance functions. However, these models are almost exclusively used by finance personnel. Hence, they need to be built to be intuitive to finance personnel.

For instance, it is important that the model has drill-down functionality. This is because costs and revenues at the company level are nothing but an aggregation of the costs and revenues at the plant level or the store level. Therefore, if a decision-maker wants to have a closer look at the costs at a lower level, they should be able to do so.

Hence, it would be a good idea to build the model in such a way that if a user clicks on a cost or revenue, they are taken to a lower level. Then, the system should allow them to keep on going at successively lower levels until they reach the absolute granular level.

This will allow companies to understand the distribution of their costs and revenue amongst various business units such as stores and departments. This information is required for better decision making. This is the reason why a financial model must provide it.

Ensuring Presentability

Lastly, the financial model must be visually appealing and presentable. Nobody likes information to be cluttered when they want to make decisions. A good financial model provides clear and demarcated information about the inputs which the user has put into the model and the underlying assumptions which are built into the model.

The conclusion is that there are many thumb rules which need to be taken into account while creating a financial model. The above points are only a representative list and by no means an exhaustive list.

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