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

Investors know that capitalizing earnings or evaluating a company's dividend history is just the beginning of any true investment analysis. After all, the capital structure is often not appropriately captured in a P/E ratio (capitalizing earnings), and there's very little helpful information to whether a company will raise its dividend next year if it did so in 1979, for example. That's why as part of our process, we perform a rigorous discounted cash-flow methodology that dives into the true intrinsic worth of companies. We think knowing what a company is worth on the basis of its future free cash flow stream is the best way to get an idea of its intrinsic value. Let's dig into this analysis for Walgreen (NYSE:WAG).

But first, a little background. We think a comprehensive analysis of a firm's discounted cash-flow valuation and relative valuation versus industry peers is the best way to identify the most attractive stocks at the best time to buy. This process culminates in what we call our Valuentum Buying Index, which ranks stocks on a scale from 1 to 10, with 10 being the best. Essentially, we're looking for firms that overlap investment methodologies, thereby revealing the greatest interest by investors (we like firms that fall in the center of the diagram below). Savvy investors know that more interest in a stock equals more buying, which often translates into a higher stock price. In order for a stock to converge to intrinsic value, buying must occur.

(click to enlarge)

If a company is undervalued both on a DCF and on a relative valuation basis, it scores high on our scale. Walgreen posts a VBI score of 7 on our scale, reflecting our "fairly valued" DCF assessment of the firm and its attractive relative valuation versus peers. We compare Walgreen to peers Costco (NASDAQ:COST), Target (TGT) and Wal-Mart (NYSE:WMT).

Our Report on Walgreen

(click to enlarge)

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 firm is trading at attractive valuation multiples relative to peers, but our DCF process indicates a less compelling opportunity. We'd wait for a clearer signal on valuation before jumping into the firm's shares.

• 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.8% 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.

• Although we think there may be a better time to dabble in the firm's shares based on our DCF process, the firm's stock has outperformed the market benchmark during the past quarter, indicating increased investor interest in the company.

• Walgreen operates the largest drugstore chain in the US, with prescription drug sales representing about two thirds of its business. If participation in any of the programs run by one or more of the large PBMs is terminated, results would suffer.

Business Quality

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 ((NASDAQ:ROIC)) with its weighted average cost of capital (OTC: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.4%, which is above the estimate of its cost of capital of 9%. 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 gray 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.8% 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. At Walgreen, cash flow from operations increased about 18% from levels registered two years ago, while capital expenditures expanded about 53% over the same time period.

Valuation Analysis

Our discounted cash flow model indicates that Walgreen's shares are worth between $33.00 - $49.00 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 $41 per share represents a price-to earnings (P/E) ratio of about 17 times last year's earnings and an implied EV/EBITDA multiple of about 8.6 times last year's EBITDA. Our model reflects a compound annual revenue growth rate of 3.4% during the next five years, a pace that is lower than the firm's 3-year historical compound annual growth rate of 4.2%. Our model reflects a 5-year projected average operating margin of 6.4%, 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.7% for the next 15 years and 3% in perpetuity. For Walgreen, we use a 9% 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 $41 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 $33 per share (the green line), but quite expensive above $49 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 $41 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 $50 per share in Year 3 represents our existing fair value per share of $41 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

(click to enlarge)

(click to enlarge)

(click to enlarge)

Source: Walgreen Priced Attractively On A Relative Value Basis