What is Cost Modelling?
February 12, 2025
We often read about how electronic and software based trading is the norm in stock or equity markets as well as currency and other financial markets. Indeed, anyone who is remotely connected with the stock market or for that matter any financial market would know that there are trading systems and trading software that help […]
In the previous articles, we have already seen that sporting franchises are required to raise a lot of capital at regular intervals. Hence, they are required to regularly raise debt from the marketplace. However, it is important to note that the decision regarding how much debt can be raised by a sporting franchise is not […]
The sharing economy has been one of the major themes when it comes to start-up investing in the past decade. Investors and entrepreneurs have woken up to the idea that resources can be utilized in a much more optimal manner if they are shared between various people. The mega-success of the co-working business model is […]
Asset bubbles have always been a testimony to the bizarre things that humans can accomplish when they abandon their own rational thinking and a herd mentality sets in. However, the case in point of the first asset bubble in recorded history i.e. the tulip mania brings this to light. The sheer absurdity of the situation […]
From the previous articles, we now know that sports franchises across the world are now being viewed as commercial entities. Hence, it is vital to derive the correct valuation for them in order to ensure that buy and sell as well as restructuring transactions can take place at the correct valuation. However, we also know […]
A financial model is often called a “model of models.” This is because there are several parameters which go through a series of complex calculations themselves. Revenue is a perfect example of one such parameter. For the financial model as a whole, the revenue number is just one of the many inputs required for the calculations to be run. However, there are a lot of calculations that go into arriving at the revenue number itself.
This article provides a detailed analysis of the complexities involved in revenue modeling.
From a financial modeler’s point of view, the revenue number may be the most important input in the financial model. This is because revenues form the top line of the financial model. Expenses are subtracted from revenues to arrive at profits. Profits are then adjusted to arrive at cash flows. All investment and financing decisions are taken based on this cash flow. Hence, if a firm has made a big error while forecasting revenues, they will face a trickle-down effect of their mistake. All the subsequent calculations will be incorrect, and the company may end up making some really bad decisions since they did not have the correct information at hand.
Revenue modeling is important. However, it is also extremely challenging. This is because there are multiple ways of arriving at the revenue number. Some examples have been listed below:
Each of the above formulae provides a different way of looking at the same number. For instance, the first method is very production oriented. At the same time, the second way of arriving at revenue focuses on competition. This method is external oriented and brings the management’s attention to the change in market share.
The third method derives the number based on the previous year’s actuals. This method is used if the past forecasts of the company have proven to be accurate and only minor adjustments need to be made to arrive at the new number. Lastly, the fourth formula expresses the revenues as a factor of the number of stores. This viewpoint encourages the company to increase the number of stores in operation if the revenue has to be maximized.
Therefore, a financial modeler has to decide an approach which is most suitable for their specific case. This is what makes revenue modeling extremely challenging.
The above-mentioned methods are amongst the most basic techniques which can be used for revenue modeling. In real life, companies use much more complex parameters to be able to accurately model revenue. Some examples have been provided below:
There are some factors which negatively affect the revenue model. They need to be managed to ensure that the model and the results that it gives are accurate.
Your email address will not be published. Required fields are marked *