What is Cost Modelling?
February 12, 2025
In the previous few articles we understood how to calculate free cash flows which accrue to the firm as a whole as well as to equity shareholders. However, while conducting this analysis we made an implicit assumption. We assumed that there are only two classes of funds available to the firm, this is equity and […]
The valuation of a sports franchise is a very difficult task. This is because a lot of the rules that are applicable while valuing other businesses are not relevant when it comes to valuing sports franchises. One such example is the widespread usage of the price-to-revenue ratio in deriving the valuation of a franchise. In […]
Financial modeling can be considered to be the science of making informed decisions regarding a company based on data simulations. Most financial models pay keen attention to a variable such as revenue and expenses as well as their drivers. Data regarding these variables is extensively collated as well as analyzed. However, it turns out that […]
Return on Invested Capital (ROIC) is another popular metric that is used widely in financial analysis. The reason for its popularity is that like ROA, ROIC can be used by both equity and debt holders. Also, like ROA, it provides data about return to the company as a whole and is not affected by leverage. […]
The banking industry is a highly specialized field. To the layman, it may appear like all banks perform the same function. However, this is not the case. There are a wide variety of departments within a bank that perform different functions. Commercial banking is one such department. In most banks, it functions like a different […]
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 *