| Company Name: | Comcast Corporation | | Ticker Symbol: | CMCSA | | | WWW Address: | www.comcast.com | | CEO: | Brian L. Roberts | | No. of Employees: | 100,000 | | Common Issue Type: | CS | | Business Description: | The company is a provider of cable services, offering a variety of entertainment, information and communications services to residential and commercial customers.
|
| | | Industry Information: | MEDIA - CATV Systems [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 15.12 |  0.03 | 15.02 | 15.19 | 15.05 | 15.35 | 14.80 | 26616267 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 43,163.1 | 2,854.7 | 0.86 | 0.86 | 0.19 | 14.1 | 1.8 | 18.10 - 11.10 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 15.09 | $ | | PE Ratio - LTM | 14.1 | |
| Market Capitalisation | 31,116.5 | mil |
| Latest Shares Outstanding | 2,854.7 | mil |
| Earnings pS (EPS) | 0.86 | $ |
| Dividend pS (DPS) | 0.19 | ¢ |
| Dividend Yield | 1.8 | % |
| Dividend Payout Ratio | 22 | % |
| Revenue per Employee | 342,560 | $ |
| Effective Tax Rate | 37.8 | % |
| Float | 2,061.8 | mil |
| Float as % of Shares Outstanding | 71.5 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 19.50 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 58.2 | % |
| EBITDA Margin | 38.7 | % |
| Pre-Tax Profit Margin | 12.3 | % |
| Assets Turnover | 0.3 | % |
| Return on Assets (ROA) | 2.8 | % |
| Return on Equity (ROE) | 7.3 | % |
| Return on Capital Invested (ROCI) | 4.4 | % |
| Current Ratio | 0.5 | |
| Leverage Ratio (Assets/Equity) | 2.7 | |
| Interest Cover | 2.8 | |
| Total Debt/Equity (Gearing Ratio) | 0.70 | |
| LT Debt/Total Capital | 40.0 | % |
| Working Capital pS | -1.29 | $ |
| Cash pS | 0.30 | $ |
| Book-Value pS | 14.82 | $ |
| Tangible Book-Value pS | -12.71 | $ |
| Cash Flow pS | 3.37 | $ |
| Free Cash Flow pS | 1.40 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 1.02 | |
| Price/Tangible Book Ratio | -1.19 | |
| Price/Cash Flow | 4.5 | |
| Price/Free Cash Flow | 10.8 | |
| P/E as % of Industry Group | 195.0 | % |
| P/E as % of Sector Segment | 0.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 11/04/2009 |
| Dividend Ex-Date | 01/03/2010 |
| Dividend Record Date | 01/05/2010 |
| Dividend Pay Date | 01/26/2010 |
| Dividend Amount | 67 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.27 |
| Current Dividend Yield | 1.8 |
| 5-Y Average Dividend Yield | 0.0 |
| Payout Ratio | 22.0 |
| 5-Y Average Payout Ratio | 4.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 | - | - | - | 0.5 | 99 | 270,615 | 368,470 |
| 4 Weeks | 15.86 | 13.95 | 14.50 | 4.1 | 97 | 282,272 | 4,516,350 |
| 13 Weeks | 17.68 | 13.95 | 15.71 | -3.9 | 89 | 254,058 | 15,243,510 |
| 26 Weeks | 17.68 | 13.04 | 13.77 | 9.6 | 91 | 225,134 | 27,916,637 |
| 52 Weeks | 18.10 | 11.10 | 17.34 | -13.0 | 71 | 230,760 | 57,228,398 |
| YTD | 18.10 | 11.10 | - | -10.6 | 73 | 231,251 | 52,262,641 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 15.16 | 15.23 | 15.45 | 15.04 | 14.63 | 0.86 | 0.83 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 12.70 | 96.0 | 12.08 |
| Income | 32.42 | 80.8 | 9.11 |
| Dividend | 0.00 | 0.0 | 0.00 |
| Capital Spending | 16.83 | NA | 17.41 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 32.93 | NA | 13.27 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 4.3 | 3.0 | 10.9 |
| Earnings % | 25.7 | 22.4 | -1.5 |
| EPS % | 29.2 | 26.9 | 3.6 |
| EPS $ | 0.21 | 0.07 | 0.03 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | -4.62 |
| Current Ratio | 0.4 |
| Quick Ratio (Acid Test) | 0.3 |
| Liquidity Ratio (Cash) | 0.14 |
| Receivables Turnover | 20.9 |
| Average Collection Period | 17 |
| Working Capital/Equity | -12.9 |
| Working Capital pS | -1.81 |
| Cash-Flow pS | 3.11 |
| Free Cash-Flow pS | 0.93 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 0.73 |
| Financial Leverage Ratio (Assets/Equity) | 2.8 |
| Debt Ratio | 64.2 |
| Total Debt/Equity (Gearing Ratio) | 0.80 |
| LT Debt/Equity | 0.75 |
| LT Debt/Capital Invested | 90.1 |
| LT Debt/Total Liabilities | 41.6 |
| Interest Cover | 2.7 |
| Interest/Capital Invested | 2.34 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 133.77 |
| Tobin's Q Ratio | 0.28 |
| Current P/E Ratio - LTM | 14.10 |
| Enterprise Value (EV)/EBITDA | 7.80 |
| Enterprise Value (EV)/Free Cash Flow | 24.02 |
| Dividend Yield | 1.8 |
| Price/Tangible Book Ratio - LTM | -1.19 |
| Price/Book Ratio - LTM | 1.02 |
| Price/Cash Flow Ratio | 4.5 |
| Price/Free Cash Flow Ratio - LTM | 10.8 |
| Price/Sales Ratio | 1.22 |
| P/E Ratio (1 month ago) - LTM | 14.1 |
| P/E Ratio (26 weeks ago) - LTM | 15.6 |
| P/E Ratio (52 weeks ago) - LTM | 19.1 |
| 5-Y High P/E Ratio | 83.9 |
| 5-Y Low P/E Ratio | 10.7 |
| 5-Y Average P/E Ratio | 43.1 |
| Current P/E Ratio as % of 5-Y Average P/E | 33 |
| P/E as % of Industry Group | 195.0 |
| P/E as % of Sector Segment | 0.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 14.1 |
| PER SHARE FIGURES |
| LT Debt pS | 10.48 |
| Current Liabilities pS | 3.10 |
| Tangible Book Value pS - LTM | -12.71 |
| Book Value pS - LTM | 14.82 |
| Capital Invested pS | 24.74 |
| Cash pS - LTM | 0.30 |
| Cash Flow pS - LTM | 3.37 |
| Free Cash Flow pS - LTM | 1.40 |
| Earnings pS (EPS) | 0.86 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 7.79 |
| Free Cash Flow Margin 5YEAR AVG | 2.52 |
| Net Profit Margin | 7.4 |
| Net Profit Margin - 5YEAR AVRG. | 7.2 |
| Equity Productivity | 0.85 |
| Return on Equity (ROE) | 6.3 |
| Return on Equity (ROE) - 5YEAR AVRG. | 4.7 |
| Capital Invested Productivity | 0.49 |
| Return on Capital Invested (ROCI) | 3.6 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 2.9 |
| Assets Productivity | 0.30 |
| Return on Assets (ROA) | 2.3 |
| Return on Assets (ROA) - 5YEAR AVRG. | 1.8 |
| Gross Profit Margin | 58.2 |
| Gross Profit Margin - 5YEAR AVRG. | 63.1 |
| EBITDA Margin - LTM | 38.7 |
| EBIT Margin - LTM | 19.2 |
| Pre-Tax Profit Margin | 11.8 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 11.8 |
| Effective Tax Rate | 37.8 |
| Effective Tax Rate - 5YEAR AVRG. | 42.4 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 17 |
| Revenue per Employee | 342,560 |
| Net Income per Employee | 25,470 |
| Average Collection Period | 17 |
| Receivables Turnover | 20.9 |
| Day's Inventory Turnover Ratio | 0 |
| Inventory Turnover | 0.0 |
| Inventory/Sales | 0.0 |
| Accounts Payble/Sales | 9.90 |
| Assets/Revenue | 3.33 |
| Net Working Capital Turnover | -6.56 |
| Fixed Assets Turnover | 0.31 |
| Total Assets Turnover | 0.3 |
| Revenue per $ Cash | 28.67 |
| Revenue per $ Plant | 1.40 |
| Revenue per $ Common Equity | 0.85 |
| Revenue per $ Capital Invested | 0.49 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 22.3 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 25.0 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
| | |  |  | |
| |