Are you trying to identify what is ‘priced in’ to a current stock price or work out a terminal value in a DCF analysis? A target valuation multiple calculation may be the answer. We present a simple interactive model.
Many dismiss valuation multiples as being too simplistic; however, multiples are just DCF in disguise. You can derive a price earnings ratio with the same value drivers as you would use in a discounted equity cash flow model.
Target multiples represent a deserved value, expressed in the form of a multiple, that reflects specified value driver inputs. The model we include in this article derives a prospective target price earnings ratio. It is a two-stage model with specified growth, return on capital and cost of capital inputs for an initial forecast period and then in perpetuity thereafter. The model is clearly simplistic as it captures the complexities of a company in only a handful of value drivers, but we believe it is still extremely useful for:
We explain more about using the model below. First the interactive model itself:
Interactive model: Price earnings ratio implied by value drivers
Please enter your email address to receive an excel version of this model
The target price earnings ratio is based on an underlying discounted equity cash flow valuation. The cash flows are derived from earnings, combined with a cash conversion that is a function of a forecast incremental return on equity and forecast growth inputs.
Understanding the model inputs
This is the expected rate of growth in earnings. For the initial phase it may be simplistic to assume that growth is constant when actual growth forecasts differ for each period. However, in most cases, using an average expected rate will not have a significant effect on the target multiple. If the initial phase is long and growth is high and volatile then using an average rate could be a problem and a more sophisticated multi-period approach would be necessary.
For the long-term growth rate it is important to include a sustainable rate, considering the market and economy as a whole. Remember that this rate is applied in perpetuity. The model will not accept a rate greater than the cost of equity. It is an impossible scenario anyway because, theoretically, such a rate produces an infinite valuation and the entity would eventually end up bigger than the economy.
Excess return on equity
This should be a return premium over the cost of equity, not the full expected return. Entering zero would mean that a return equal to the cost of equity capital is earned. You could even enter a negative amount if the entity is expected to generate returns below the cost of equity. The return should be a measure of the incremental return expected to be earned on incremental investment in future periods. The historical return or standard return on equity calculation of earnings divided by shareholders’ equity should not be used, although this may help in estimating forecast incremental returns.
Incremental returns used in the model are accounting returns, which may not necessarily be the same as economic returns. The additional investment used in the calculation of incremental returns should be what is capitalised in the financial statements. The reason is that the model uses this return to determine the difference between reported earnings and the cash flow that ultimately determines value.
The difference between accounting and economic returns is often due to the limited recognition of intangible investment in financial reporting; most investment in intangible assets is immediately expensed rather than capitalised and amortised. As a result, the returns used in the model would generally be high for a company where it is primarily intangible investment that drives value . Unfortunately, the relationship between accounting and economic returns is a complex one (and perhaps a subject for a future article).
Cost of equity
This is the normal economic cost of equity capital; in other words, it is the required return of equity investors in respect of their investment in the entity. Make sure this reflects differences in risk and leverage. CAPM may be a good starting point.
The earnings metric should be forecast not historical. To be precise, a 12-month prospective earnings should be used (usually a combination of first and second year prospective earnings). However, in practice, using the first-year prospective metric is generally good enough. Whatever earnings figure is chosen, remember the forecast growth input applies to future periods beyond the period of that forecast earnings. You should also ensure that the earnings measure is realistic and comprehensive. Do not exclude expenses that have a non-zero expected value in future periods merely because they are volatile, or that they are so-called ‘non-cash’, or because a company has excluded them from their adjusted ‘non-GAAP’ metrics.
Although earnings is not itself an input of the above model, it is important to apply the model output to the correct earnings metric, hence the inclusion in this list.
How to use a target multiple model
What is in the price analysis
How do you determine whether a particular valuation multiple is deserved or not? One approach is to try and construct a set of value drivers that replicates the multiple. Consider whether you think those implied value drivers look conservative or aggressive and that will help you reach better conclusions on value.
For example, at the time of publication of this article, Amazon trades on a forward price earnings ratio of 59x based on analyst consensus earnings forecasts provided by Reuters. Use the model above to try and identify a set of value drivers that replicates this multiple. Now consider whether you believe Amazon is likely to achieve this or not. Remember that your implied value drivers need to be mid points in a distribution, they should not be the ‘success scenario’. One of the common mistakes in valuation is to consider value based only on the assumed successful implementation of a company’s strategy. Values need to reflect potential downside as well as upside, which is why forecasts need to be true expected values allowing for differing outcomes.
Terminal value calculations
A terminal value in DCF analysis can be calculated based on an implied multiple derived from value drivers, instead of the more commonly applied constant terminal rate of growth. The advantage of a target multiple approach is that it effectively adjusts implied reinvestment to reflect the selected growth. This is a common mistake in DCF where changes in terminal growth are done without considering the effect this has on required reinvestment and hence on the terminal cash flow itself.
Quantify a valuation premium or discount
How do you know whether a multiple is too high or too low? Comparisons with other companies or with historical ranges helps, but it is difficult to explicitly allow for differences in value drivers. You may think that a stock is higher quality than the comparable companies, but what valuation premium does that justify? Using the target multiple approach to identify what is priced into comparable company stock prices and then adjusting for value driver differences can help in estimating that premium or discount.
Model limitations and assumptions
A target multiple model, such as this for price earnings ratios, is an excellent way to better understand how key value drivers impact value and multiples, but it is obviously simplistic and has its limitations. For example, the model is based on simplistic growth assumptions and does not allow for a more complex development of earnings and equity. Clearly the approach should not be your only basis for equity analysis and valuation.
Also remember that this model assumes:
No advertising, no spam, just new articles. Unsubscribe anytime.
Or see suggested related articles below: