90 likes | 246 Views
VALUATION OF EQUITY. Discount, Variety Store - Costco Aileen Huang. Costco. Established in 1983 71,200 members 451 Warehouses/stores in U.S. Sales: $103m; Net income: $2m Competitors: Sam’s Club, BJ Wholesale Started same time, only three big wholesale clubs still in operation
E N D
VALUATION OF EQUITY Discount, Variety Store - Costco Aileen Huang
Costco • Established in 1983 • 71,200 members • 451 Warehouses/stores in U.S. • Sales: $103m; Net income: $2m • Competitors: Sam’s Club, BJ Wholesale • Started same time, only three big wholesale clubs still in operation • Market share 67% Sam’s Club; 17% Costco
Assumption • WACC 8% • Growth rate • 2014-2018 5.6% • Perpetual growth rate 4.00% • EPM from sales 2.20% • EATO 10.2
Perpetual growth rate? • Growth rate=5.25% • Feel like too high for Costco • Adjust to 4%
Residual income model • Perpetual growth rate: 4% • Share price: $81.88, lower than actual price $114.93
Sensitivity Analysis • Overvalued
DCF Model • Adjusting date: $56,351 (53,967*1.08 205/365) • Adjusting mid-year: $58,605 (56,351*1.04)
Sensitivity Analysis • Market cap $50,070 • NFL $732 • Enterprise value $50,802 • Undervalued