Seeking Alpha
Long/short equity, newsletter provider, valuentum
Profile| Send Message|
( followers)  

As part of our process, we perform a rigorous discounted cash-flow methodology that dives into the true intrinsic worth of companies. In Walgreen's (NYSE:WAG) case, we think the firm is fairly valued at $35 per share, near where it is currently trading.

For some background, we think a comprehensive analysis of a company's discounted cash-flow valuation, relative valuation versus industry peers, as well as an assessment of technical and momentum indicators is the best way to identify the most attractive stocks at the best time to buy. This process culminates in what we call our VBI, Valuentum Buying Index (click here for an in-depth, narrated presentation of our methodology), which ranks stocks on a scale from 1 to 10, with 10 being the best.

If a company is undervalued both on a DCF and on a relative valuation basis and is showing improvement in technical and momentum indicators, it scores high on our scale. Walgreen posts a VBI score of 6 on our scale, reflecting our "fair value" DCF assessment, neutral relative valuation, and very bullish techinicals. Walgreen's very bullish technicals is the only positive that makes it stand apart from its peers: Costco (NASDAQ:COST), Kroger (NYSE:KR), Target (NYSE:TGT), and Wal-Mart (NYSE:WMT).

Our Report on Walgreen

click to enlarge images

Investment Considerations

Investment Highlights

Walgreen's business quality (an evaluation of our ValueCreation™ and ValueRisk™ ratings) ranks among the best of the firms in our coverage universe. The firm has been generating economic value for shareholders with relatively stable operating results for the past few years, a combination we view very positively.

The company looks fairly valued at this time. We expect the firm to trade within our fair value estimate range for the time being. If the firm's share price fell below $28, we'd take a closer look.

Walgreen's cash flow generation and financial leverage aren't much to speak of. The firm's free cash flow margin has averaged about 3.6% during the past three years, lower than the mid-single-digit range we'd
expect for cash cows. However, the firm's cash flow should be sufficient to handle its low financial leverage.

The firm's share price performance has been roughly in line with that of the market during the past quarter. We'd expect the firm's stock price to converge to our fair value estimate within the next three years, if our forecasts prove accurate.

The firm's technicals look very attractive. If current prices hold, the firm's moving averages could create a golden cross, a very bullish technical pattern.

Economic Profit Analysis

The best measure of a firm's ability to create value for shareholders is expressed by comparing its return on invested capital (ROIC) with its weighted average cost of capital (WACC). The gap or difference between ROIC and WACC is called the firm's economic profit spread. Walgreen's 3-year historical return on invested capital (without goodwill) is 15.7%, which is above the estimate of its cost of capital of 9.4%. As such, we assign the firm a ValueCreation™ rating of EXCELLENT. In the chart below, we show the probable path of ROIC in the years ahead based on the estimated volatility of key drivers behind the measure. The solid grey line reflects the most likely outcome, in our opinion, and represents the scenario that results in our fair value estimate.

Cash Flow Analysis

Firms that generate a free cash flow margin (free cash flow divided by total revenue) above 5% are usually considered cash cows. Walgreen's free cash flow margin has averaged about 3.6% during the past 3 years. As such, we think the firm's cash flow generation is relatively MEDIUM. The free cash flow measure shown above is derived by taking cash flow from operations less capital expenditures and differs from enterprise free cash flow (FCFF), which we use in deriving our fair value estimate for the company. For more information on the differences between these two measures, please visit our website here. At Walgreen, cash flow from operations decreased about 11% from levels registered two years ago, while capital expenditures fell about 37% over the same time period.

Valuation Analysis

Our discounted cash flow model indicates that Walgreen's shares are worth between $28 and $42 each. The margin of safety around our fair value estimate is driven by the firm's LOW ValueRisk™ rating, which is derived from the historical volatility of key valuation drivers. The estimated fair value of $35 per share represents a price-to-earnings (P/E) ratio of about 11.9 times last year's earnings and an implied EV/EBITDA multiple of about 6.6 times last year's EBITDA. Our model reflects a compound annual revenue growth rate of 1.8% during the next five years, a pace that is lower than the firm's 3-year historical compound annual growth rate of 6.9%. Our model reflects a 5-year projected average operating margin of 5.7%, which is above Walgreen's trailing 3-year average. Beyond year 5, we assume free cash flow will grow at an annual rate of 2.6% for the next 15 years and 3% in perpetuity. For Walgreen, we use a 9.4% weighted average cost of capital to discount future free cash flows.

Margin of Safety Analysis

Our discounted cash flow process values each firm on the basis of the present value of all future free cash flows. Although we estimate the firm's fair value at about $35 per share, every company has a range of probable fair values that's created by the uncertainty of key valuation drivers (like future revenue or earnings, for example). After all, if the future was known with certainty, we wouldn't see much volatility in the markets as stocks would trade precisely at their known fair values. Our ValueRisk™ rating sets the margin of safety or the fair value range we assign to each stock. In the graph below, we show this probable range of fair values for Walgreen. We think the firm is attractive below $28 per share (the green line), but quite expensive above $42 per share (the red line). The prices that fall along the yellow line, which includes our fair value estimate, represent a reasonable valuation for the firm, in our opinion.

Future Path of Fair Value

We estimate Walgreen's fair value at this point in time to be about $35 per share. As time passes, however, companies generate cash flow and pay out cash to shareholders in the form of dividends. The chart below compares the firm's current share price with the path of Walgreen's expected equity value per share over the next three years, assuming our long-term projections prove accurate. The range between the resulting downside fair value and upside fair value in Year 3 represents our best estimate of the value of the firm's shares three years hence. This range of potential outcomes is also subject to change over time, should our views on the firm's future cash flow potential change. The expected fair value of $43 per share in Year 3 represents our existing fair value per share of $35 increased at an annual rate of the firm's cost of equity less its dividend yield. The upside and downside ranges are derived in the same way, but from the upper and lower bounds of our fair value estimate range.

Pro Forma Financial Statements

Source: Our Margin Of Safety Captures Risk At Walgreen