| Company Name: | Aetna Inc | | Ticker Symbol: | AET | | | WWW Address: | www.aetna.com |
| CEO: | Mark T. Bertolini | | No. of Employees: | 35,000 |
| Common Issue Type: | CS | | Business Description: | Aetna Inc. is a health care benefit company, which offers traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life and disability plans.
|
| | | Industry Information: | HEALTH SERVICES - Health Care Plans [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 59.14 |  -0.9 | - | - | 59.85 | 59.93 | 58.97 | 2110503 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 19,273.7 | 325.9 | 1.21 | 4.81 | 0.70 | 12.2 | 1.4 | 60.26 - 34.58 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 59.14 | $ | | PE Ratio - LTM | 12.2 | |
| Market Capitalisation | 19,273.7 | mil |
| Latest Shares Outstanding | 325.9 | mil |
| Earnings pS (EPS) | 4.81 | $ |
| Dividend pS (DPS) | 0.70 | ¢ |
| Dividend Yield | 1.4 | % |
| Dividend Payout Ratio | 15 | % |
| Revenue per Employee | 1,039,114 | $ |
| Effective Tax Rate | 34.9 | % |
| Float | 303.6 | mil |
| Float as % of Shares Outstanding | 93.0 | % |
| Foreign Sales | - | |
| Domestic Sales | - | |
| Selling, General & Adm/tive (SG&A) as % of Revenue | - | |
| Research & Devlopment (R&D) as % of Revenue | - | |
| Gross Profit Margin | - | |
| EBITDA Margin | 8.1 | % |
| Pre-Tax Profit Margin | 6.7 | % |
| Assets Turnover | 0.9 | % |
| Return on Assets (ROA) | 2.8 | % |
| Return on Equity (ROE) | 11.0 | % |
| Return on Capital Invested (ROCI) | 6.9 | % |
| Current Ratio | - | |
| Leverage Ratio (Assets/Equity) | 4.0 | |
| Interest Cover | 8.2 | |
| Total Debt/Equity (Gearing Ratio) | 0.62 | |
| LT Debt/Total Capital | 38.0 | % |
| Working Capital pS | - | |
| Cash pS | - | |
| Book-Value pS | 32.77 | $ |
| Tangible Book-Value pS | 11.31 | $ |
| Cash Flow pS | 3.62 | $ |
| Free Cash Flow pS | 2.26 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 1.80 | |
| Price/Tangible Book Ratio | 5.23 | |
| Price/Cash Flow | 16.3 | |
| Price/Free Cash Flow | 26.1 | |
| P/E as % of Industry Group | 58.0 | % |
| P/E as % of Sector Segment | 80.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 02/18/2013 |
| Dividend Ex-Date | 04/08/2013 |
| Dividend Record Date | 04/10/2013 |
| Dividend Pay Date | 04/25/2013 |
| Dividend Amount | 200 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.80 |
| Current Dividend Yield | 1.4 |
| 5-Y Average Dividend Yield | 0.7 |
| Payout Ratio | 15.0 |
| 5-Y Average Payout Ratio | 5.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.5 | 99 | 29,692 | 21,072 |
| 4 Weeks | 60.26 | 56.05 | 57.01 | 3.7 | 99 | 32,014 | 512,224 |
| 13 Weeks | 60.26 | 46.05 | 47.58 | 24.3 | 113 | 32,806 | 1,968,383 |
| 26 Weeks | 60.26 | 42.12 | 42.99 | 37.6 | 116 | 33,735 | 4,081,907 |
| 52 Weeks | 60.26 | 34.58 | 41.20 | 43.5 | 114 | 39,829 | 9,758,143 |
| YTD | 60.26 | 44.38 | - | 27.7 | 109 | 32,798 | 3,148,576 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 59.59 | 59.42 | 55.64 | 49.34 | 46.41 | 1.21 | 0.99 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 3.99 | 77.7 | 1.82 |
| Income | 11.51 | 62.3 | 12.59 |
| Dividend | 102.27 | 73.5 | 209.55 |
| Capital Spending | 0.00 | NA | 0.00 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 0.00 | NA | 0.00 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 7.1 | 7.1 | 8.1 |
| Earnings % | -3.9 | -3.9 | -16.5 |
| EPS % | 3.5 | 3.5 | -7.9 |
| EPS $ | 0.05 | 0.05 | -0.41 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| |
| |
| |
| |
| FINANCIAL STRUCTURE RATIOS |
| Financial Leverage Ratio (Assets/Equity) | 3.99 |
| Debt Ratio | 74.92 |
| Total Debt/Equity (Gearing Ratio) | 0.62 |
| LT Debt/Equity | 0.62 |
| LT Debt/Capital Invested | 38.38 |
| LT Debt/Total Liabilities | 20.85 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 0.00 |
| Tobin's Q Ratio | 0.48 |
| Current P/E Ratio - LTM | 12.20 |
| Enterprise Value (EV)/EBITDA | 0.06 |
| Enterprise Value (EV)/Free Cash Flow | 9.62 |
| Dividend Yield | 1.4 |
| Price/Tangible Book Ratio - LTM | 5.23 |
| Price/Book Ratio - LTM | 1.80 |
| Price/Cash Flow Ratio | 16.3 |
| Price/Free Cash Flow Ratio - LTM | 26.1 |
| P/E Ratio (1 month ago) - LTM | 11.5 |
| P/E Ratio (26 weeks ago) - LTM | 8.2 |
| P/E Ratio (52 weeks ago) - LTM | 8.0 |
| 5-Y High P/E Ratio | 21.1 |
| 5-Y Low P/E Ratio | 5.0 |
| 5-Y Average P/E Ratio | 9.2 |
| Current P/E Ratio as % of 5-Y Average P/E | 132 |
| P/E as % of Industry Group | 58.0 |
| P/E as % of Sector Segment | 80.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 10.2 |
| PER SHARE FIGURES |
| Tangible Book Value pS - LTM | 11.31 |
| Book Value pS - LTM | 32.77 |
| Capital Invested pS | 51.82 |
| Cash Flow pS - LTM | 3.62 |
| Free Cash Flow pS - LTM | 2.26 |
| Earnings pS (EPS) | 4.81 |
| | | | OPERATING RATIOS | | PROFITABILITY |
| Return on Equity (ROE) | 15.93 |
| Return on Equity (ROE) - 5YEAR AVRG. | 10.5 |
| Return on Capital Invested (ROCI) | 9.82 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 6.5 |
| Return on Assets (ROA) | 4.00 |
| Return on Assets (ROA) - 5YEAR AVRG. | 2.6 |
| EBIT Margin - LTM | 7.5 |
| EBITDA Margin - LTM | 8.1 |
| |
| |
| |
| |
| |
| |
| EFFICIENCY RATIOS |
| Revenue per Employee - LTM | 1,063,683 |
| Net Income per Employee - LTM | 33,720 |
| Assets/Revenue - LTM | 111.11 |
| |
|
|  
| | |  |  | |
| |
