160 likes | 320 Views
Discount, Variety Stores. Module 6: Cost of Capital and Valuation Claire ( Lan ) Lin. Cost of Equity Capital Using CAPM. Cost of Equity Capital Using CAPM. Market β : Regression. Data : m onthly r eturns from 03 /02/2009 to 02/03/2014. β =0.441. Beta Estimates. Regression : β =0.44
E N D
Discount, Variety Stores Module 6: Cost of Capital and Valuation Claire (Lan) Lin
Market β: Regression Data: monthly returns from 03/02/2009 to 02/03/2014 β=0.441
Beta Estimates Regression: β=0.44 Estimates: β=0.40 About 10% difference
Market β 0.495? 0.44? 0.40? • β from Bloomberg: 0.495 • Which β number is better • Regression: historical data may not well forecast future performance • Estimates: can be subjective; range from 0.31 to 0.6 • Bloomberg number may be a better indication
Cost of Capital Equity Using CAPM • =+β*(- )
Cost of Debt Capital Is the classification of NFL and NEA correct (ex: 2% cash needed for operation)? 10K footnotes may be a better indication
Cost of Enterprise Capital Three Beta numbers are from regression, finance website estimates and Bloomberg respectively
Cost of Enterprise Capital • No significant difference among these numbers • However, a slight difference can result in a huge change in valuation • Bloomberg(6.60%) may be the best indication
Valuating Walmart Bloomberg 6.60% is the highest of the four estimated WACC WACC=6.60%
Valuating Walmart 6.04% (derived from average estimated Beta) is the lowest of the four estimated WACC WACC=6.04%
Valuating Walmart The enterprise value calculated from Bloomberg WACC approximates the current enterprise value