Spreadsheet Modeling: Dividend Discount Model
In the past few articles, we have studied about the various models that are available to help us predict the value of a firm based on the dividends that it provides. However, all these models had one flaw. They expected that the dividends of the firm will follow some set pattern. For instance, the assumptions were that that the dividend of a firm will continue to rise for 5% for the next 3 years.
Now, the reasons behind these assumptions were twofold. Firstly, dividends are difficult to predict. Hence, assuming a pattern reduces the risk of making mistakes. Thus, the ease of forecasting is one of the reasons. Also, calculations related to valuation of stocks have to be conducted at a fast pace. Hence, the formulas assume simplistic patterns in which dividends are expected to behave in the future. This is for calculation ease.
However, both the forecasting ease and the calculation ease make the formula less effective and less accurate. Therefore, in real life, analysts almost always use more complex tool like spreadsheet models to come up with a more accurate valuation.
Real Life Scenarios Are Complex:
Real life scenarios are much more complex. Almost no company is able to follow a predictable pattern when it comes to making dividend payments. Companies may experience a 5% growth this year but may soon experience a 3% decline the next year. Multiple factors like macro-economy, the nature of competition, the changing purchasing powers etc determine the stability of the dividends. For most companies, these factors will not be stable and hence their dividends are unlikely to match the trends which are built in any of the formulas.
Valuation Is Sensitive To Inputs:
Some degree of error is always present in all calculations. If the error is small then the effort required to correct it may not be worth the while. However, valuation models are extremely sensitive to changes in inputs. This is because they are calculating values of cash flows over a very long period of time. Hence, the inputs need to be perfect and errors cannot be ignored. Thus analysts simply cannot work with the suboptimal results that the formula provides and a better mechanism is required.
Infinite Possibilities Can Be Built In:
This is where spreadsheet modeling comes to the rescue. Spreadsheet tools have advanced calculation capabilities. They can process millions of bits of data and provide the relevant answer in a few seconds. Also, spreadsheet modeling allows separating the inputs from the calculations. Thus, scenario analysis can be conducted with extreme ease and in a matter of minutes.
Scenario analyses have become more and more important in the recent past. Analysts and investors have realized that it is almost impossible to predict the exact movement in the valuation of a company. Hence, instead of looking for one value, they are usually looking at a range of values. These ranges provide a more accurate estimate of what the future is expected to be like. It is here that scenario analysis helps a lot. Analysts can vary the inputs in different combinations and note down the effect of the change in these inputs in the valuation of the firm.
While conducting the scenario analysis, analysts can also understand the relationship between individual inputs and the valuation derived. In some cases, growth rate may be the most important factor whereas in other cases the discount rate may be of more importance. Either ways, spreadsheet models help uncover these relationships in real time with almost no effort.
In conclusion, it needs to be understood that there is really nothing that cannot be done manually which the spreadsheet models do for us. Spreadsheet models just help us to automate the whole process and increase the speed at which these calculations can be conducted. But, in the financial markets, speed is what is of utmost importance and hence spreadsheets have become an integral part of the business.
Any analyst who wishes to have a fruitful career in finance ought to be aware of and skilled in the use of spreadsheets to create financial models.
|❮❮ Previous||Next ❯❯|
Authorship/Referencing - About the Author(s)
The article is Written By Prachi Juneja and Reviewed By Management Study Guide Content Team. MSG Content Team comprises experienced Faculty Member, Professionals and Subject Matter Experts. We are a ISO 2001:2015 Certified Education Provider. To Know more, click on About Us. The use of this material is free for learning and education purpose. Please reference authorship of content used, including link(s) to ManagementStudyGuide.com and the content page url.
- Equity Valuation: Definition, Importance and Process
- Market Value, Intrinsic Value and Investment Value
- Applications of Equity Valuation
- Assumptions Used In Equity Valuation
- Qualitative Issues While Conducting Equity Valuation
- Intrinsic Value and Mispricing
- Absolute Valuation Models Vs Relative Valuation Models
- Choosing a Valuation Model
- Sum of the Parts Valuation
- Dividend Discount Model: Advantages
- Dividend Discount Model: Disadvantages
- Single Period Dividend Discount Model
- Two Period Dividend Discount Model
- Dividend Discount Generic Model
- Dividend Discount Model: Gordon Growth Rate
- Gordon Growth Model: Pros and Cons
- Valuing Preference Shares Using Dividend Discount Model
- Link between Present Value of Growth Opportunities (PVGO) and Dividend Valuation
- Dividend Discount Valuation: H Model
- Phases of Growth and Valuation Models
- Dividend Discount Model: Share Repurchase Programs
- Implied Dividend Growth Rate
- Sustainable Growth Rate: Concept
- Sustainable Growth Rate and the Du-Pont Analysis (PRAT Model)
- Spreadsheet Modeling: Dividend Discount Model
- Estimating Future Dividends
- Dividend Discount Models: Some Points to Consider
- Introduction: Concept of Free Cash Flow
- Why Is Free Cash Flow Approach Better Than Dividend Discount Models?
- Free Cash Flow to the Firm vs. Free Cash Flow to Equity
- Calculating Free Cash Flow to Firm: Method #1 (Contd): Treatment of Fixed Capital Expenditure
- Calculating Free Cash Flow to the Firm: Method #2: Cash Flow From Operations
- Calculating Free Cash Flow to Firm: Method 3: EBIT
- Calculating Free Cash Flow to Equity
- Calculating Free Cash Flows: The Case of Preferred Shares
- Changes in Financing Policy: Effect on Free Cash Flow
- Single Stage FCFF Model
- Single Stage FCFF Model to Equity Valuation
- Variations in Cash Flow Models
- How to Value Companies like Netflix?
- Debt to Equity Swaps