preview

Valuing Wal-Mart

Good Essays

Assessment of Wal-Mart valuation using different methods To test the assumption of a discount rate of 7% as given in the outline of the case, we calculated the required rate of return for the Wal-Mart stock using CAPM . Using rWalMart = Rf + βWalMart [E(RM) – RF], we find the required rate of return to be 7.01% and in line with the information given in the case outline. Perpetual dividend growth model: The standard method of calculating a stock price using the perpetual dividend growth model is done by assessing a company’s dividend one year into the future adding the future expected growth rate. The formula is written as: P0 = D1/(Ke − g), where Ke is the investor required return, D1 is next year’s dividend and g is the expected …show more content…

We prefer to use the P/E multiple to assess how Wal-Mart is perceived and valuated against peers. In addition we use S&P500 as reference index and benchmark. Using the data in exhibit 6, we have identified Wal-mart, Target, The Gap and Costco to be peers. We have concluded this after examining key financial data of all the companies provided in the exhibit. We realize that Wal-Mart is not directly comparable with the peers mentioned given the much larger market capitalization and turn-over, but knowing this a comparability study still adds value in our opinion. Detailed data of the comparison is brought in appendix 5. Looking at the graphical representation we see a clear trend in the peer group of declining P/E-ratios. The trend is confirmed by further lower P/E-projections for the coming year. We are not overly concerned with the declining P/E ratios as it seems to be an industry wide trend and not isolated to Wal-Mart. Hence when assessing relative attractiveness of the grocery industry players, we do not see Wal-Mart having worse financial performance than the peers. As argued in the beginning of this paper in the section when discussing the steady state phase of Wal-Mart, we believe we can make a rough estimation of whether the P/E-ratio reflects a fair value of the stock or not. The method we employ is a rewritten method of the DDM. By arguing steady state we can also defend arguing Wal-Mart to be a zero

Get Access