Creating a Revenue Model
February 12, 2025
In the previous article, we became aware that the value of a stock can be split into two parts. One part is the horizon period i.e. the period chosen by the analyst for which they believe they can accurately forecast the financials of the company and therefore its dividends. This part remains the same when […]
The topic of investment banking is fascinating. This is because some of the biggest banks in the world i.e., Barclays, JP Morgan, Citi, Morgan Stanley, etc. all have investment banking divisions. In fact, they have had investment banking divisions for a very long time. The average age of these investment banks is often said to […]
It is a myth that financial ratios are to be used only by investors and analysts in deriving a fair valuation for the firm. In reality, financial ratios are used by a wide variety of people for a wide variety of reasons. A common usage is by the sales department. Usually sales departments in large […]
Before the advent of globalization, every country in the world was working in a vacuum when it came to taxes. This is because the companies which operate in these countries did not have any choice when it came to tax rates. Their only choices were to accept the tax rates or to stop production. If […]
Valuing a corporation is a complex exercise. This is partly because there are multiple ways of looking at the same information. One such example is mentioned in this article. Dividend discount valuation and present value of growth opportunities may seem to be two completely different topics. However, there exists a link between them. In fact […]
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 which should ideally be the part of any due diligence.
However, financial modeling isn’t perfect, either. It is not the answer to all the problems being faced by the finance department of any company. Therefore, before using financial modeling, it is imperative that a student is made aware of its pros and cons.
In this article, we will explain some of the important advantages as well as the biggest limitations which users face when they use financial models.
Some of the major advantages of using financial models are as follows:
The process also forces the business to think about the various changes that may happen internally as well as in the external environment. Hence, it would be fair to say that companies which create financial models are somehow forced to do more due diligence as compared to their counterparts. This creates a better understanding of the business. Creation of financial models, therefore, has a spillover effect which leads to a better understanding of the underlying business.
Using financial modeling, they can decide on the amount of money that they need to have on hand in order to ensure that they survive till the revenues start flowing in. Therefore, start companies are able to ascertain the amount of equity stake they should sell so as to reach the next milestone.
Financial models make it possible to ascertain the exact amount of free cash flow that will accrue to the firm at different points in time. This helps companies to know their exact worth when they are selling out their stakes to third party investors such as investment bankers and private equity funds.
The process of financial modeling is riddled with disadvantages as well. Some of the important ones have been listed below.
The data needs to collected, the underlying factors have to be identified, and the model needs to be tested for financial as well as technical irregularities. This model then needs to be made intuitive and user-friendly.
Needless to say, all this costs a lot of time and money. Many companies, particularly smaller ones, may not have the resources to spare for this exercise. Hence, in many cases, financial models have very limited applicability.
Nobody has the knowledge required to predict factors such as interest rates, tax rates, and market shares with utmost precision. If a person did have such an ability, they would make a killing by trading in the stocks and derivatives market and would not need to create financial models!
Therefore, the numbers provided by the financial model need to be taken with a pinch of salt. If numbers are being projected far into the future, then one can be almost certain that these numbers will not be met.
However, on the other hand, they do not take into account the expenses which will arise due to lack of cultural compatibility. This leads to an overvaluation of assets in the long run. Many mergers have failed in the past even though the financial models had predicted that these models would be successful.
Any student of financial modeling must make an attempt to capitalize on the strengths which have been listed above. However, they also need to be mindful of the limitations of the model while making decisions based on data derived from it.
Your email address will not be published. Required fields are marked *