| Company Name: | RCN Corporation | | Ticker Symbol: | RCNI | | | WWW Address: | www.rcn.com | | CEO: | Peter D. Aquino | | No. of Employees: | 1,500 | | Common Issue Type: | CS | | Business Description: | The Company is a broadband services provider, which delivers all-digital and high-definition video, high-speed internet and premium voice services mainly to Residential and Small and Medium Business customers.
|
| | | Industry Information: | TELECOMMUNICATIONS - Wireless Communications [more like this] |
|
| Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 8.92 |  0.28 | 6.26 | 9.28 | 8.81 | 9.00 | 8.81 | 64600 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 318.7 | 35.7 | 1.61 | -1.91 | 0.00 | 0.0 | 0.0 | 10.12 - 3.09 |
|
| KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 8.92 | $ | | PE Ratio - LTM | 0.0 | |
| Market Capitalisation | 318.7 | mil |
| Latest Shares Outstanding | 35.7 | mil |
| Earnings pS (EPS) | -1.91 | $ |
| Dividend pS (DPS) | 0.00 | ¢ |
| Dividend Yield | 0.0 | % |
| Dividend Payout Ratio | 0 | % |
| Revenue per Employee | 492,829 | $ |
| Effective Tax Rate | 0.0 | % |
| Float | 33.4 | mil |
| Float as % of Shares Outstanding | 93.4 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 36.80 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 64.5 | % |
| EBITDA Margin | 27.6 | % |
| Pre-Tax Profit Margin | -4.9 | % |
| Assets Turnover | 0.8 | % |
| Return on Assets (ROA) | -3.8 | % |
| Return on Equity (ROE) | 0.0 | % |
| Return on Capital Invested (ROCI) | -5.2 | % |
| Current Ratio | 1.1 | |
| Leverage Ratio (Assets/Equity) | 196.9 | |
| Interest Cover | 0.2 | |
| Total Debt/Equity (Gearing Ratio) | 146.95 | |
| LT Debt/Total Capital | 99.0 | % |
| Working Capital pS | 0.57 | $ |
| Cash pS | 1.05 | $ |
| Book-Value pS | 0.14 | $ |
| Tangible Book-Value pS | -3.30 | $ |
| Cash Flow pS | 4.56 | $ |
| Free Cash Flow pS | 1.01 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 63.54 | |
| Price/Tangible Book Ratio | -2.70 | |
| Price/Cash Flow | 2.0 | |
| Price/Free Cash Flow | 8.8 | |
| P/E as % of Industry Group | 0.0 | % |
| P/E as % of Sector Segment | 0.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 05/24/2007 |
| Dividend Ex-Date | 06/11/2007 |
| Dividend Record Date | 06/03/2007 |
| Dividend Pay Date | 06/10/2007 |
| Dividend Amount | 9330 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.00 |
| Current Dividend Yield | 0.0 |
| 5-Y Average Dividend Yield | 0.0 |
| Payout Ratio | 0.0 |
| 5-Y Average Payout Ratio | 0.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 | - | - | - | 3.2 | 102 | 882 | 575 |
| 4 Weeks | 9.00 | 8.00 | 8.34 | 7.0 | 100 | 978 | 15,652 |
| 13 Weeks | 10.12 | 8.00 | 9.41 | -5.2 | 88 | 1,013 | 60,778 |
| 26 Weeks | 10.12 | 5.59 | 5.50 | 62.2 | 135 | 1,260 | 156,261 |
| 52 Weeks | 10.12 | 3.09 | 6.98 | 27.8 | 104 | 1,591 | 394,459 |
| YTD | 10.12 | 3.09 | - | 51.2 | 123 | 1,541 | 348,272 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 8.81 | 8.56 | 8.97 | 7.65 | 6.61 | 1.61 | 1.56 |
|
| |
| GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 64.47 | 40.9 | 8.98 |
| Income | 0.00 | 0.0 | 0.00 |
| Dividend | 0.00 | 0.0 | 0.00 |
| Capital Spending | 42.49 | NA | 26.84 |
| 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 % | 4.0 | 2.6 | 16.2 |
| Earnings % | 0.0 | 0.0 | 0.0 |
| EPS % | 0.0 | 0.0 | 0.0 |
| EPS $ | 0.86 | 0.24 | 2.19 |
|
| |
| SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | -1.51 |
| Current Ratio | 0.9 |
| Quick Ratio (Acid Test) | 0.8 |
| Liquidity Ratio (Cash) | 0.39 |
| Receivables Turnover | 10.8 |
| Average Collection Period | 33 |
| Working Capital/Equity | -94.5 |
| Working Capital pS | -0.42 |
| Cash-Flow pS | 3.53 |
| Free Cash-Flow pS | -0.07 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 0.72 |
| Financial Leverage Ratio (Assets/Equity) | 62.6 |
| Debt Ratio | 98.4 |
| Total Debt/Equity (Gearing Ratio) | 45.36 |
| LT Debt/Equity | 44.91 |
| LT Debt/Capital Invested | 112.6 |
| LT Debt/Total Liabilities | 72.9 |
| Interest Cover | 0.0 |
| Interest/Capital Invested | 6.18 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 10.67 |
| Tobin's Q Ratio | 0.31 |
| Current P/E Ratio - LTM | 0.00 |
| Enterprise Value (EV)/EBITDA | 6.92 |
| Enterprise Value (EV)/Free Cash Flow | -415.32 |
| Dividend Yield | 0.0 |
| Price/Tangible Book Ratio - LTM | -2.70 |
| Price/Book Ratio - LTM | 63.54 |
| Price/Cash Flow Ratio | 2.0 |
| Price/Free Cash Flow Ratio - LTM | 8.8 |
| Price/Sales Ratio | 0.42 |
| P/E Ratio (1 month ago) - LTM | 0.0 |
| P/E Ratio (26 weeks ago) - LTM | 0.0 |
| P/E Ratio (52 weeks ago) - LTM | 0.0 |
| 5-Y High P/E Ratio | 0.0 |
| 5-Y Low P/E Ratio | 0.0 |
| 5-Y Average P/E Ratio | 0.0 |
| Current P/E Ratio as % of 5-Y Average P/E | 0 |
| P/E as % of Industry Group | 0.0 |
| P/E as % of Sector Segment | 0.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 0.0 |
| PER SHARE FIGURES |
| LT Debt pS | 20.03 |
| Current Liabilities pS | 4.44 |
| Tangible Book Value pS - LTM | -3.30 |
| Book Value pS - LTM | 0.14 |
| Capital Invested pS | 21.04 |
| Cash pS - LTM | 1.05 |
| Cash Flow pS - LTM | 4.56 |
| Free Cash Flow pS - LTM | 1.01 |
| Earnings pS (EPS) | -1.91 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | -0.32 |
| Free Cash Flow Margin 5YEAR AVG | -55.39 |
| Net Profit Margin | -9.6 |
| Net Profit Margin - 5YEAR AVRG. | -14.9 |
| Equity Productivity | 45.16 |
| Return on Equity (ROE) | 0.0 |
| Return on Equity (ROE) - 5YEAR AVRG. | 0.0 |
| Capital Invested Productivity | 0.98 |
| Return on Capital Invested (ROCI) | -9.4 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | -8.2 |
| Assets Productivity | 0.70 |
| Return on Assets (ROA) | -6.9 |
| Return on Assets (ROA) - 5YEAR AVRG. | -6.6 |
| Gross Profit Margin | 64.5 |
| Gross Profit Margin - 5YEAR AVRG. | 65.2 |
| EBITDA Margin - LTM | 27.6 |
| EBIT Margin - LTM | 1.2 |
| Pre-Tax Profit Margin | -9.6 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | -15.4 |
| Effective Tax Rate | 0.0 |
| Effective Tax Rate - 5YEAR AVRG. | -22.7 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 35 |
| Revenue per Employee | 492,829 |
| Net Income per Employee | -47,151 |
| Average Collection Period | 35 |
| Receivables Turnover | 10.8 |
| Day's Inventory Turnover Ratio | 0 |
| Inventory Turnover | 0.0 |
| Inventory/Sales | 0.0 |
| Accounts Payble/Sales | 5.11 |
| Assets/Revenue | 1.43 |
| Net Working Capital Turnover | -47.77 |
| Fixed Assets Turnover | 0.84 |
| Total Assets Turnover | 0.7 |
| Revenue per $ Cash | 18.08 |
| Revenue per $ Plant | 1.03 |
| Revenue per $ Common Equity | 45.16 |
| Revenue per $ Capital Invested | 0.98 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 39.8 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 45.6 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
|
| |
 |  |