| Company Name: | Walgreen Company | | Ticker Symbol: | WAG | | | WWW Address: | www.walgreens.com | | CEO: | Gregory D. Wasson | | No. of Employees: | 166,000 | | Common Issue Type: | CS | | Business Description: | The company is in the retail drugstore business and the drugstores are engaged in the retail sale of prescription and non-prescription drugs and general merchandise.
|
| | | Industry Information: | RETAIL - Drug Stores [more like this] |
|
| Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 38.97 |  -0.06 | 38.23 | 39.77 | 38.75 | 39.05 | 38.59 | 6374522 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 38,533.5 | 988.8 | 0.77 | 2.02 | 0.48 | 19.3 | 1.4 | 40.69 - 21.39 |
|
| KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 38.97 | $ | | PE Ratio - LTM | 19.3 | |
| Market Capitalisation | 38,534.6 | mil |
| Latest Shares Outstanding | 988.8 | mil |
| Earnings pS (EPS) | 2.02 | $ |
| Dividend pS (DPS) | 0.48 | ¢ |
| Dividend Yield | 1.4 | % |
| Dividend Payout Ratio | 24 | % |
| Revenue per Employee | 381,536 | $ |
| Effective Tax Rate | 36.6 | % |
| Float | 984.1 | mil |
| Float as % of Shares Outstanding | 99.5 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 22.70 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 29.3 | % |
| EBITDA Margin | 6.7 | % |
| Pre-Tax Profit Margin | 5.0 | % |
| Assets Turnover | 2.7 | % |
| Return on Assets (ROA) | 8.0 | % |
| Return on Equity (ROE) | 14.0 | % |
| Return on Capital Invested (ROCI) | 12.0 | % |
| Current Ratio | 1.8 | |
| Leverage Ratio (Assets/Equity) | 1.7 | |
| Interest Cover | 39.1 | |
| Total Debt/Equity (Gearing Ratio) | 0.16 | |
| LT Debt/Total Capital | 14.0 | % |
| Working Capital pS | 5.34 | $ |
| Cash pS | 2.11 | $ |
| Book-Value pS | 14.54 | $ |
| Tangible Book-Value pS | 13.06 | $ |
| Cash Flow pS | 3.01 | $ |
| Free Cash Flow pS | 1.35 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 2.68 | |
| Price/Tangible Book Ratio | 2.98 | |
| Price/Cash Flow | 12.9 | |
| Price/Free Cash Flow | 28.9 | |
| P/E as % of Industry Group | 72.0 | % |
| P/E as % of Sector Segment | 73.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 10/15/2009 |
| Dividend Ex-Date | 11/11/2009 |
| Dividend Record Date | 11/15/2009 |
| Dividend Pay Date | 12/11/2009 |
| Dividend Amount | 137 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.55 |
| Current Dividend Yield | 1.4 |
| 5-Y Average Dividend Yield | 1.0 |
| Payout Ratio | 24.0 |
| 5-Y Average Payout Ratio | 17.0 |
|  | | Share price performance previous 3 years |
|
 | | | Share price performance intraday |
|
 | |
| |
| PRICE/VOLUME | High | Low | Close | % Price Chg | % Price Chg vs. Mkt. | Avg. Daily Vol | Total Vol |
| 1 Week | - | - | - | -1.0 | 99 | 66,108 | 317,953 |
| 4 Weeks | 40.26 | 36.98 | 39.05 | -0.2 | 99 | 78,912 | 1,578,240 |
| 13 Weeks | 40.69 | 31.26 | 31.63 | 23.2 | 116 | 76,001 | 4,864,071 |
| 26 Weeks | 40.69 | 27.89 | 29.56 | 31.8 | 107 | 72,901 | 9,258,392 |
| 52 Weeks | 40.69 | 21.39 | 23.16 | 68.3 | 123 | 78,415 | 19,682,044 |
| YTD | 40.69 | 21.39 | - | 58.0 | 131 | 79,190 | 17,817,856 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 39.16 | 39.33 | 37.93 | 33.30 | 31.36 | 0.77 | 0.86 |
|
| |
| GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 11.32 | 99.2 | 10.10 |
| Income | 10.08 | 85.9 | 5.64 |
| Dividend | 22.22 | 99.9 | 22.28 |
| Capital Spending | 23.89 | NA | 7.57 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 10.02 | NA | 5.61 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 7.3 | 7.6 | 7.3 |
| Earnings % | -7.0 | -1.6 | -7.0 |
| EPS % | -6.9 | -2.2 | -6.9 |
| EPS $ | -0.15 | -0.01 | -0.15 |
|
| |
| SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 21.00 |
| Current Ratio | 1.8 |
| Quick Ratio (Acid Test) | 0.8 |
| Liquidity Ratio (Cash) | 0.38 |
| Receivables Turnover | 25.2 |
| Average Collection Period | 14 |
| Working Capital/Equity | 36.7 |
| Working Capital pS | 5.34 |
| Cash-Flow pS | 3.02 |
| Free Cash-Flow pS | 1.35 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 5.46 |
| Financial Leverage Ratio (Assets/Equity) | 1.7 |
| Debt Ratio | 42.8 |
| Total Debt/Equity (Gearing Ratio) | 0.16 |
| LT Debt/Equity | 0.16 |
| LT Debt/Capital Invested | 23.9 |
| LT Debt/Total Liabilities | 21.7 |
| Interest Cover | 39.1 |
| Interest/Capital Invested | 0.45 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 7.91 |
| Tobin's Q Ratio | 1.53 |
| Current P/E Ratio - LTM | 19.30 |
| Enterprise Value (EV)/EBITDA | 11.06 |
| Enterprise Value (EV)/Free Cash Flow | 74.48 |
| Dividend Yield | 1.4 |
| Price/Tangible Book Ratio - LTM | 2.98 |
| Price/Book Ratio - LTM | 2.68 |
| Price/Cash Flow Ratio | 12.9 |
| Price/Free Cash Flow Ratio - LTM | 28.9 |
| Price/Sales Ratio | 0.61 |
| P/E Ratio (1 month ago) - LTM | 19.8 |
| P/E Ratio (26 weeks ago) - LTM | 14.1 |
| P/E Ratio (52 weeks ago) - LTM | 10.7 |
| 5-Y High P/E Ratio | 32.2 |
| 5-Y Low P/E Ratio | 10.5 |
| 5-Y Average P/E Ratio | 23.0 |
| Current P/E Ratio as % of 5-Y Average P/E | 84 |
| P/E as % of Industry Group | 72.0 |
| P/E as % of Sector Segment | 73.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 19.3 |
| PER SHARE FIGURES |
| LT Debt pS | 2.36 |
| Current Liabilities pS | 6.85 |
| Tangible Book Value pS - LTM | 13.06 |
| Book Value pS - LTM | 14.54 |
| Capital Invested pS | 16.90 |
| Cash pS - LTM | 2.11 |
| Cash Flow pS - LTM | 3.01 |
| Free Cash Flow pS - LTM | 1.35 |
| Earnings pS (EPS) | 2.02 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 2.10 |
| Free Cash Flow Margin 5YEAR AVG | 0.16 |
| Net Profit Margin | 3.2 |
| Net Profit Margin - 5YEAR AVRG. | 3.6 |
| Equity Productivity | 4.41 |
| Return on Equity (ROE) | 14.0 |
| Return on Equity (ROE) - 5YEAR AVRG. | 16.6 |
| Capital Invested Productivity | 3.79 |
| Return on Capital Invested (ROCI) | 12.0 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 15.6 |
| Assets Productivity | 2.70 |
| Return on Assets (ROA) | 8.0 |
| Return on Assets (ROA) - 5YEAR AVRG. | 9.6 |
| Gross Profit Margin | 29.3 |
| Gross Profit Margin - 5YEAR AVRG. | 29.4 |
| EBITDA Margin - LTM | 6.7 |
| EBIT Margin - LTM | 5.1 |
| Pre-Tax Profit Margin | 5.0 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 5.6 |
| Effective Tax Rate | 36.6 |
| Effective Tax Rate - 5YEAR AVRG. | 36.5 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 70 |
| Revenue per Employee | 381,536 |
| Net Income per Employee | 12,084 |
| Average Collection Period | 14 |
| Receivables Turnover | 25.2 |
| Day's Inventory Turnover Ratio | 56 |
| Inventory Turnover | 6.4 |
| Inventory/Sales | 10.7 |
| Accounts Payble/Sales | 6.80 |
| Assets/Revenue | 0.37 |
| Net Working Capital Turnover | 12.00 |
| Fixed Assets Turnover | 4.84 |
| Total Assets Turnover | 2.7 |
| Revenue per $ Cash | 30.35 |
| Revenue per $ Plant | 5.86 |
| Revenue per $ Common Equity | 4.41 |
| Revenue per $ Capital Invested | 3.79 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 22.7 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 22.4 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
|
| |
 |  |