Accepting and Rejecting Data from Public Company Data Valuation analysts who, for whatever reason, eschew the publicly traded guideline company method but who would like to use option models for various aspects of the valuation assignment, face a conundrum. All option models require, as an input, a volatility factor in percentage format. Since the only place to derive such a volatility factor (usually defined as the standard deviation of total returns) is from public company data, how do you reject public company data on the one hand over here but use it on the other hand over there? Using non-public…
-
-
Visualized Financial Statement Analysis The use of Excel and graphics, commonly referred to as data visualization, can provide a fuller or more holistic view of changes in an entity. Does the traditional audit or report that is devoid of data visualization serve the client? In this article, the author “propos[es] not a replacement for ratios…but rather that financial statement analysis should return to a more holistic analysis of a set of financial statements.” The author showcases how Excel can be used to present a more holistic picture.