120 likes | 296 Views
Drug Stores. Trevor Yerrick Section 2. Agenda. Quick Background Drug Stores Industry Walgreen Co. Weighted Average Cost of Capital Re-estimate Value of WAG – DCF vs. REI Models Issues Residual Enterprise Income Model Discounted Cash Flow Model. Quick Background. Drug Store Industry
E N D
Drug Stores Trevor Yerrick Section 2
Agenda • Quick Background • Drug Stores Industry • Walgreen Co. • Weighted Average Cost of Capital • Re-estimate Value of WAG – DCF vs. REI Models • Issues • Residual Enterprise Income Model • Discounted Cash Flow Model
Quick Background • Drug Store Industry • Traditional vs. In-store • Pharmacy Benefit Managers (PBMs) • “Nation’s largest drugstore chain” • 8,582 locations, including 8,116 drug stores • 2013: $72.2 B in sales, $45.5 B in prescription sales • Recent trend of expansion through acquisitions • Alliance Boots (45%) acquisition in 2012, option to purchase remaining 55% in 2015
Weighted Average Cost of Capital • For WAG: • VD = $4,385 million (book value of NFL) • VEq = $54,578 million (stock price of $57.44 at December 31, 2013 * 950,170,000 common shares outstanding) • Implied VEnt = $58,963 million ($4,385 + $54,578)
Issues with Re-estimation First pass at re-estimation with calculated WACC Changing growth rates
Issues with Re-estimation First pass at re-estimation with calculated WACC Changing growth rates
Issues with Re-estimation First correction of re-estimation (for last Monday) Changed growth rates to be the same
Issues with Re-estimation First correction of re-estimation (for last Monday) Changed growth rates to be the same
Issues with Re-estimation Final Discounted Cash Flow Model Extended forecasts out to 2020 (3 more years)
Issues with Re-estimation Final Residual Enterprise Income Model Extended forecasts out to 2020 (3 more years)