Stock Valuation models
The Basics Behind Stock Evaluation
All businesses have an intrinsic value, and this value is based on the extent of free cash flow they have available during their lifetime. Money generated in the future is worth less than it is in present time, therefore projected free cash flows have to be discounted at a rate that is deemed appropriate.
Most stock evaluation methods work on the theory that a business’ value is equal to the total financial worth of all future free cash flows put together. Due to the time value of money, these future cash flows must be discounted accordingly. If the future cash flows of a business are already known, and there is a target rate of return on your money, then you have the tools to work out the exact amount of money you should pay for the business.
However, in practice, stock evaluation is not so simple. This is because one can only estimate the value of future free cash flows. The inputs are also estimates themselves and need the appropriate skills and experiences to predict them as accurately as possible.
In order to reduce the difficulties and be more accurate, conservative estimates should be used and a margin of safety should be provided.
The Three Primary Stock Evaluation Models:
Discounted Cash Flow Analysis
The discounted cash flow analysis method treats the business as a large free cash flow machine. One would evaluate the whole business for all of its worth and hold it for all of its projected free cash flows indefinitely. When we evaluate a company’s worth, we look at its current market capitalisation compared to the company itself in order to determine whether it is profitable and worthy. An alternative method would be to divide the total estimated value by the number of shares, then compare this to the current real price of shares.
The Dividend Discount Model
The Dividend Discount Model treats individual shares as one small cash flow machine. The free cash flow is the dividends, as that is the money investors receive. A business could spend their free cash flows on repurchasing shares, dividends, acquisitions, or even not spend it at all and let it build up on the balance sheet. In reality however, management decides what to do with it. The dividend takes all of this into account, as the present dividend along with the predicted growth of said dividend takes all free cash flows of the business into account and how management decides to use them.
Earnings Multiple Approach
The Earnings Multiple Approach is one that can be used if a company pays a dividend or not. The financier predicts future earnings over a time period (for example 10 years), and puts a hypothetical earnings multiple onto the final predicted EPS value. Cumulative dividends are then taken into account and the difference in the stock price at present, and the total hypothetical value at the end of the time period, are distinguished to calculate the expected rate of return.
If you'd like to learn more about Stock Valuation, check out these links:
- A complete dividend discount model that can do stable growth, 2-stage or 3-stage valuation.143 remove_red_eye21
movieEstimating a beta (Corporate Finance)Compute and estimate a beta for a firm's stock/market index122 remove_red_eye19
movieBetas and LeverageObtain a table of betas at different debt ratios62 remove_red_eye11
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.89 remove_red_eye11
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables76 remove_red_eye14
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet1,185 remove_red_eye150
Stock Analysis Excel ModelAnalyze past company performance and arrive at its intrinsic value in 30 minutes or less188 remove_red_eye17
How to Calculate Volatility in ExcelA simple methodology and excel file to learn how to compute stock volatility80 remove_red_eye9
Stock Analysis Excel Model (Ver. 3.0) - Safal NiveshakA 16 tab Stock Analysis Excel Model Template to analyse the past performance of a company and determine its valuation.34 remove_red_eyeLike!
VWAP Template Calculator Excel Model (Volume Weighted Average Price)Simple, ready-to-use VWAP template calculator.21 remove_red_eyeLike!
- Have a Stock Valuation Model to Share?
Your Stock Valuation Excel ModelPublish your Model
Any questions on Stock Valuation?
The user community is here to help. Go ahead!