| Company Name: | Xcel Energy, Incorporated | | Ticker Symbol: | XEL | | | WWW Address: | www.xcelenergy.com | | CEO: | Richard C. Kelly | | No. of Employees: | 11,223 | | Common Issue Type: | CS | | Business Description: | A holding company, with its subsidiaries engaged in the generation, purchase, transmission, distribution and sale of electricity and in the purchase, transportation, distribution and sale of natural gas.
|
| | | Industry Information: | UTILITIES - Electric Utilities [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 20.5 |  0.08 | 19.92 | 21.07 | 20.44 | 20.61 | 20.31 | 1928946 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 9,360.3 | 456.6 | 0.44 | 1.46 | 0.94 | 13.9 | 4.8 | 20.61 - 16.01 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 20.50 | $ | | PE Ratio - LTM | 13.9 | |
| Market Capitalisation | 9,361.2 | mil |
| Latest Shares Outstanding | 456.6 | mil |
| Earnings pS (EPS) | 1.46 | $ |
| Dividend pS (DPS) | 0.94 | ¢ |
| Dividend Yield | 4.8 | % |
| Dividend Payout Ratio | 64 | % |
| Revenue per Employee | 998,232 | $ |
| Effective Tax Rate | 34.4 | % |
| Float | 454.5 | mil |
| Float as % of Shares Outstanding | 99.7 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 1.40 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 29.5 | % |
| EBITDA Margin | 25.0 | % |
| Pre-Tax Profit Margin | 10.7 | % |
| Assets Turnover | 0.4 | % |
| Return on Assets (ROA) | 2.7 | % |
| Return on Equity (ROE) | 9.4 | % |
| Return on Capital Invested (ROCI) | 4.4 | % |
| Current Ratio | 1.0 | |
| Leverage Ratio (Assets/Equity) | 3.5 | |
| Interest Cover | 2.8 | |
| Total Debt/Equity (Gearing Ratio) | 1.20 | |
| LT Debt/Total Capital | 52.0 | % |
| Working Capital pS | 0.01 | $ |
| Cash pS | 0.20 | $ |
| Book-Value pS | 15.75 | $ |
| Tangible Book-Value pS | 15.75 | $ |
| Cash Flow pS | 3.59 | $ |
| Free Cash Flow pS | -0.51 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 1.30 | |
| Price/Tangible Book Ratio | 1.30 | |
| Price/Cash Flow | 5.7 | |
| Price/Free Cash Flow | -40.1 | |
| P/E as % of Industry Group | 71.0 | % |
| P/E as % of Sector Segment | 74.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 08/26/2009 |
| Dividend Ex-Date | 09/21/2009 |
| Dividend Record Date | 09/23/2009 |
| Dividend Pay Date | 10/19/2009 |
| Dividend Amount | 245 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.98 |
| Current Dividend Yield | 4.8 |
| 5-Y Average Dividend Yield | 4.5 |
| Payout Ratio | 64.0 |
| 5-Y Average Payout Ratio | 71.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 | - | - | - | 2.4 | 101 | 37,546 | 70,904 |
| 4 Weeks | 20.61 | 18.53 | 18.86 | 8.7 | 101 | 35,902 | 646,235 |
| 13 Weeks | 20.61 | 18.53 | 19.89 | 3.1 | 95 | 31,485 | 1,952,080 |
| 26 Weeks | 20.61 | 17.25 | 17.15 | 19.5 | 99 | 28,804 | 3,629,278 |
| 52 Weeks | 20.61 | 16.01 | 18.81 | 9.0 | 88 | 31,156 | 7,788,899 |
| YTD | 20.61 | 16.01 | - | 10.5 | 90 | 31,401 | 7,159,462 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 20.26 | 20.05 | 19.51 | 18.99 | 18.69 | 0.44 | 0.39 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 4.27 | 61.1 | 0.96 |
| Income | 6.48 | 33.2 | 2.48 |
| Dividend | 3.95 | 98.0 | 3.08 |
| Capital Spending | 83.29 | NA | 18.13 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 0.79 | NA | 1.99 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | -17.3 | -18.8 | 11.7 |
| Earnings % | 6.3 | -0.9 | 11.8 |
| EPS % | 0.9 | -5.9 | 8.1 |
| EPS $ | 0.01 | -0.03 | 0.11 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | -0.12 |
| Current Ratio | 1.0 |
| Quick Ratio (Acid Test) | 0.6 |
| Liquidity Ratio (Cash) | 0.08 |
| Receivables Turnover | 6.7 |
| Average Collection Period | 54 |
| Working Capital/Equity | -0.4 |
| Working Capital pS | -0.07 |
| Cash-Flow pS | 3.49 |
| Free Cash-Flow pS | -1.80 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 0.96 |
| Financial Leverage Ratio (Assets/Equity) | 3.6 |
| Debt Ratio | 71.7 |
| Total Debt/Equity (Gearing Ratio) | 1.26 |
| LT Debt/Equity | 1.11 |
| LT Debt/Capital Invested | 100.3 |
| LT Debt/Total Liabilities | 43.2 |
| Interest Cover | 3.2 |
| Interest/Capital Invested | 2.06 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 73.47 |
| Tobin's Q Ratio | 0.38 |
| Current P/E Ratio - LTM | 13.90 |
| Enterprise Value (EV)/EBITDA | 11.63 |
| Enterprise Value (EV)/Free Cash Flow | -11.30 |
| Dividend Yield | 4.8 |
| Price/Tangible Book Ratio - LTM | 1.30 |
| Price/Book Ratio - LTM | 1.30 |
| Price/Cash Flow Ratio | 5.7 |
| Price/Free Cash Flow Ratio - LTM | -40.1 |
| Price/Sales Ratio | 0.96 |
| P/E Ratio (1 month ago) - LTM | 13.2 |
| P/E Ratio (26 weeks ago) - LTM | 11.5 |
| P/E Ratio (52 weeks ago) - LTM | 13.4 |
| 5-Y High P/E Ratio | 21.6 |
| 5-Y Low P/E Ratio | 10.5 |
| 5-Y Average P/E Ratio | 16.5 |
| Current P/E Ratio as % of 5-Y Average P/E | 85 |
| P/E as % of Industry Group | 71.0 |
| P/E as % of Sector Segment | 74.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 13.9 |
| PER SHARE FIGURES |
| LT Debt pS | 17.04 |
| Current Liabilities pS | 6.71 |
| Tangible Book Value pS - LTM | 15.75 |
| Book Value pS - LTM | 15.75 |
| Capital Invested pS | 32.41 |
| Cash pS - LTM | 0.20 |
| Cash Flow pS - LTM | 3.59 |
| Free Cash Flow pS - LTM | -0.51 |
| Earnings pS (EPS) | 1.46 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 0.00 |
| Free Cash Flow Margin 5YEAR AVG | 0.00 |
| Net Profit Margin | 5.8 |
| Net Profit Margin - 5YEAR AVRG. | 5.4 |
| Equity Productivity | 0.00 |
| Return on Equity (ROE) | 9.3 |
| Return on Equity (ROE) - 5YEAR AVRG. | 9.0 |
| Capital Invested Productivity | 0.00 |
| Return on Capital Invested (ROCI) | 4.4 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 4.2 |
| Assets Productivity | 0.50 |
| Return on Assets (ROA) | 2.6 |
| Return on Assets (ROA) - 5YEAR AVRG. | 2.4 |
| Gross Profit Margin | 29.5 |
| Gross Profit Margin - 5YEAR AVRG. | 24.3 |
| EBITDA Margin - LTM | 25.0 |
| EBIT Margin - LTM | 16.5 |
| Pre-Tax Profit Margin | 8.8 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 8.1 |
| Effective Tax Rate | 34.4 |
| Effective Tax Rate - 5YEAR AVRG. | 28.3 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 78 |
| Revenue per Employee | 998,232 |
| Net Income per Employee | 57,521 |
| Average Collection Period | 53 |
| Receivables Turnover | 6.7 |
| Day's Inventory Turnover Ratio | 25 |
| Inventory Turnover | 14.3 |
| Inventory/Sales | 6.0 |
| Accounts Payble/Sales | 0.00 |
| Assets/Revenue | 2.00 |
| Net Working Capital Turnover | 0.00 |
| Fixed Assets Turnover | 0.00 |
| Total Assets Turnover | 0.5 |
| Revenue per $ Cash | 44.96 |
| Revenue per $ Plant | 0.63 |
| Revenue per $ Common Equity | 1.61 |
| Revenue per $ Capital Invested | 0.76 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 0.0 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
| | |  |  | |
| |