| Company Name: | Canadian Natural Resources, Limited | | Ticker Symbol: | CNQ | | | WWW Address: | www.cnrl.com | | CEO: | Steve W. Laut | | No. of Employees: | 3,461 | | Common Issue Type: | CS | | Business Description: | A Canadian based senior independent energy company, engaged in the acquisition, exploration, development, production, marketing and sale of crude oil, NGLs, natural gas and bitumen production.
|
| | | Industry Information: | ENERGY - Independant Oil & Gas [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 72.5 |  0.55 | 72.41 | 72.51 | 71.84 | 72.50 | 71.14 | 1548990 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 39,316.8 | 542.3 | 1.91 | 9.22 | 0.39 | 13.6 | 0.6 | 79.00 - 35.85 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 72.50 | $ | | PE Ratio - LTM | 13.6 | |
| Market Capitalisation | 39,316.4 | mil |
| Latest Shares Outstanding | 542.3 | mil |
| Earnings pS (EPS) | 9.22 | $ |
| Dividend pS (DPS) | 0.39 | ¢ |
| Dividend Yield | 0.6 | % |
| Dividend Payout Ratio | 4 | % |
| Revenue per Employee | 4,672,927 | $ |
| Effective Tax Rate | 29.7 | % |
| Float | 0.0 | mil |
| Float as % of Shares Outstanding | 0.0 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 10.60 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 55.2 | % |
| EBITDA Margin | 44.4 | % |
| Pre-Tax Profit Margin | 38.9 | % |
| Assets Turnover | 0.2 | % |
| Return on Assets (ROA) | 7.1 | % |
| Return on Equity (ROE) | 15.2 | % |
| Return on Capital Invested (ROCI) | 9.8 | % |
| Current Ratio | 0.5 | |
| Leverage Ratio (Assets/Equity) | 2.1 | |
| Interest Cover | 13.1 | |
| Total Debt/Equity (Gearing Ratio) | 0.55 | |
| LT Debt/Total Capital | 36.0 | % |
| Working Capital pS | -2.23 | $ |
| Cash pS | 0.03 | $ |
| Book-Value pS | 35.16 | $ |
| Tangible Book-Value pS | 35.16 | $ |
| Cash Flow pS | 9.70 | $ |
| Free Cash Flow pS | 2.42 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 2.06 | |
| Price/Tangible Book Ratio | 2.06 | |
| Price/Cash Flow | 7.5 | |
| Price/Free Cash Flow | 30.0 | |
| P/E as % of Industry Group | 51.0 | % |
| P/E as % of Sector Segment | 44.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 11/05/2009 |
| Dividend Ex-Date | 12/08/2009 |
| Dividend Record Date | 12/10/2009 |
| Dividend Pay Date | 12/31/2009 |
| Dividend Amount | 105 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.42 |
| Current Dividend Yield | 0.6 |
| 5-Y Average Dividend Yield | 0.5 |
| Payout Ratio | 4.0 |
| 5-Y Average Payout Ratio | 7.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.7 | 6510 | 14,287 | 45,331 |
| 4 Weeks | 73.15 | 66.51 | 70.22 | 3.2 | 6167 | 17,981 | 323,658 |
| 13 Weeks | 79.00 | 60.65 | 64.46 | 12.5 | 6760 | 17,994 | 1,097,631 |
| 26 Weeks | 79.00 | 52.71 | 64.71 | 12.0 | 6361 | 17,560 | 2,177,412 |
| 52 Weeks | 79.00 | 35.85 | 52.00 | 39.4 | 7076 | 21,757 | 5,395,704 |
| YTD | 79.00 | 35.85 | - | 48.7 | 7318 | 21,204 | 4,813,291 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 71.43 | 71.37 | 72.46 | 65.92 | 60.99 | 1.91 | 1.72 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 11.21 | 52.3 | 1.14 |
| Income | 27.98 | 68.9 | 9.32 |
| Dividend | 17.72 | 98.0 | 13.19 |
| Capital Spending | 22.95 | NA | 3.89 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 27.55 | NA | 9.36 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | -48.0 | -43.6 | 28.9 |
| Earnings % | -65.0 | -76.8 | 91.1 |
| EPS % | -65.2 | -77.0 | 90.5 |
| EPS $ | -3.88 | -4.04 | 4.38 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | -0.06 |
| Current Ratio | 1.0 |
| Quick Ratio (Acid Test) | 0.5 |
| Liquidity Ratio (Cash) | 0.01 |
| Receivables Turnover | 10.2 |
| Average Collection Period | 35 |
| Working Capital/Equity | -0.1 |
| Working Capital pS | -0.05 |
| Cash-Flow pS | 14.17 |
| Free Cash-Flow pS | -1.62 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 2.10 |
| Financial Leverage Ratio (Assets/Equity) | 2.3 |
| Debt Ratio | 56.9 |
| Total Debt/Equity (Gearing Ratio) | 0.71 |
| LT Debt/Equity | 0.69 |
| LT Debt/Capital Invested | 67.3 |
| LT Debt/Total Liabilities | 51.9 |
| Interest Cover | 56.9 |
| Interest/Capital Invested | 0.32 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 1,375.40 |
| Tobin's Q Ratio | 0.92 |
| Current P/E Ratio - LTM | 13.60 |
| Enterprise Value (EV)/EBITDA | 6.75 |
| Enterprise Value (EV)/Free Cash Flow | -63.46 |
| Dividend Yield | 0.6 |
| Price/Tangible Book Ratio - LTM | 2.06 |
| Price/Book Ratio - LTM | 2.06 |
| Price/Cash Flow Ratio | 7.5 |
| Price/Free Cash Flow Ratio - LTM | 30.0 |
| Price/Sales Ratio | 3.92 |
| P/E Ratio (1 month ago) - LTM | 13.9 |
| P/E Ratio (26 weeks ago) - LTM | 7.7 |
| P/E Ratio (52 weeks ago) - LTM | 7.0 |
| 5-Y High P/E Ratio | 31.8 |
| 5-Y Low P/E Ratio | 3.7 |
| 5-Y Average P/E Ratio | 14.6 |
| Current P/E Ratio as % of 5-Y Average P/E | 93 |
| P/E as % of Industry Group | 51.0 |
| P/E as % of Sector Segment | 44.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 13.4 |
| PER SHARE FIGURES |
| LT Debt pS | 23.28 |
| Current Liabilities pS | 6.32 |
| Tangible Book Value pS - LTM | 35.16 |
| Book Value pS - LTM | 35.16 |
| Capital Invested pS | 57.11 |
| Cash pS - LTM | 0.03 |
| Cash Flow pS - LTM | 9.70 |
| Free Cash Flow pS - LTM | 2.42 |
| Earnings pS (EPS) | 9.22 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | -5.40 |
| Free Cash Flow Margin 5YEAR AVG | -19.88 |
| Net Profit Margin | 30.8 |
| Net Profit Margin - 5YEAR AVRG. | 21.7 |
| Equity Productivity | 0.88 |
| Return on Equity (ROE) | 27.1 |
| Return on Equity (ROE) - 5YEAR AVRG. | 21.7 |
| Capital Invested Productivity | 0.52 |
| Return on Capital Invested (ROCI) | 16.1 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 12.6 |
| Assets Productivity | 0.40 |
| Return on Assets (ROA) | 11.7 |
| Return on Assets (ROA) - 5YEAR AVRG. | 8.3 |
| Gross Profit Margin | 55.2 |
| Gross Profit Margin - 5YEAR AVRG. | 64.5 |
| EBITDA Margin - LTM | 44.4 |
| EBIT Margin - LTM | 42.1 |
| Pre-Tax Profit Margin | 43.9 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 28.8 |
| Effective Tax Rate | 29.7 |
| Effective Tax Rate - 5YEAR AVRG. | 24.0 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 34 |
| Revenue per Employee | 4,672,927 |
| Net Income per Employee | 1,440,335 |
| Average Collection Period | 34 |
| Receivables Turnover | 10.2 |
| Day's Inventory Turnover Ratio | 0 |
| Inventory Turnover | 0.0 |
| Inventory/Sales | 0.0 |
| Accounts Payble/Sales | 2.36 |
| Assets/Revenue | 2.50 |
| Net Working Capital Turnover | -622.04 |
| Fixed Assets Turnover | 0.41 |
| Total Assets Turnover | 0.4 |
| Revenue per $ Cash | 599.00 |
| Revenue per $ Plant | 0.42 |
| Revenue per $ Common Equity | 0.88 |
| Revenue per $ Capital Invested | 0.52 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 1.1 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 9.1 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
| | |  |  | |
| |