10 Year Financial Data of Canadian Natural Resources Ltd (CNQ)

29.52 (1y: -2%)

Market Cap	31.87 B	P/E(ttm)	20.00
Enterprise Value	41.03 B	P/B	1.37

CNQ- NYSE (USA)
Canadian Natural Resources Ltd

Currently 2/5

Business Predictability Rank: 2-Star (On Watch)
Back Testing Results:
Average gain of all 2-Star stocks: 6% per year.
% of Stocks that are in still loss if held for 10yrs: 16%.
Read more:
What is Predictability Rank?
Performances of real portfolio
Top Ranked Predictable Companies

$29.52

3 Severe Warning Signs 3 Medium Warning Signs 2 Good Signs

Bookmark

Annual Rates (per share)	10 yrs*	5 yrs*	12 months*
Revenue Growth (%)	9.9	2.9	1.5
EBITDA Growth (%)	7.3	-0.9	-19.5
Free Cash Flow Growth (%)	0	0	-197
Book Value Growth (%)	17.7	7	5.2

*12-month growth rate is calculated with the per share revenue (EBITDA, FCF, earnings) of the last 12 months over the per share revenue (EBITDA, FCF, earnings) over the previous 12 months. 5-year and 10-year growth rates are calculated with least-square regression based on the 5-year and 10-year numbers.

Trendline:

Export:

Print This Table Print

See this page for the explanation of the data and charts * All numbers are in millions except for per share data

Per Share Data	Annuals											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	TTM	Mar12	Jun12	Sep12	Dec12	Mar13

Revenue per Share ($)	5.34	6.87	9.20	10.63	11.41	14.66	10.02	12.90	13.79	14.44	14.58	3.52	3.73	3.55	3.63	3.67
EBITDA per Share	2.89	3.96	5.16	5.87	4.73	8.52	4.34	6.23	6.68	6.58	5.71	1.40	1.11	1.53	1.64	1.43
Free Cashflow per Share	0.54	-0.81	-0.49	-2.82	-0.59	-0.60	2.56	0.86	0.04	0.09	-0.32	-0.06	0.29	-0.05	-0.10	-0.46
Earnings per Share ($)	1.24	1.27	0.96	2.30	2.37	4.52	1.43	1.53	2.35	1.69	1.49	0.38	0.67	0.32	0.31	0.19
Dividends Per Share	0.07	0.10	0.11	0.15	0.16	0.20	0.21	0.29	0.35	0.41	0.43	0.10	0.10	0.10	0.10	0.12
Book Value per Share	5.47	6.67	7.50	9.76	12.12	16.66	17.57	18.91	20.36	21.65	21.83	20.76	21.30	21.55	21.73	21.83
Month End Stock Price	6.37	10.69	24.81	26.62	36.57	19.99	35.98	44.42	37.37	28.87	32.13	33.18	26.85	30.79	28.87	32.13
Ratios	Annuals											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

Return on Equity %	22.80	19.20	12.70	23.60	19.60	27.10	8.10	8.10	11.50	7.80	3.60	7.20	12.40	6.00	5.60	3.60
Return on Assets %	9.80	7.60	4.80	7.60	7.20	11.70	3.90	4.00	5.60	3.90	1.60	3.60	6.40	3.20	2.80	1.60
Return on Capital - Joel Greenblatt %	13.00	15.50	20.40	13.50	7.20	17.10	5.00	7.20	9.60	6.70	4.00	5.60	1.60	6.00	5.60	4.00
Debt to Equity	0.46	0.51	0.40	1.03	0.82	0.71	0.53	0.44	0.37	0.36	0.38	0.35	0.36	0.35	0.36	0.38

Gross Margin %	60.80	64.70	67.40	60.20	71.50	60.40	53.60	53.60	50.30	46.90	43.00	44.60	23.90	46.70	46.60	43.00
Operating Margin %	28.00	34.10	36.20	34.70	18.60	41.50	17.80	20.10	25.20	18.90	11.00	15.30	3.80	16.40	15.20	11.00
Net Margin %	23.30	18.60	10.40	21.70	20.80	30.80	14.30	11.80	17.00	11.70	5.20	10.80	18.00	9.00	8.70	5.20

Days Sales Outstanding	45.90	56.90	55.80	61.00	48.30	34.20	37.80	37.70	48.90	27.00	32.00	30.80	33.20	31.20	26.80	32.00
Days Inventory	--	--	--	--	--	--	41.50	33.50	26.00	23.50	24.40	27.80	16.90	24.50	23.20	24.40
Inventory Turnover	--	--	--	--	--	--	8.80	10.90	14.00	15.50	3.70	3.20	5.30	3.60	3.80	3.70

Debt to Revenue	0.47	0.50	0.33	0.95	0.87	0.81	0.93	0.64	0.55	0.54	2.27	2.08	2.04	2.12	2.15	2.27
COGS to Revenue	0.39	0.35	0.33	0.40	0.29	0.40	0.46	0.46	0.50	0.53	0.57	0.55	0.76	0.53	0.53	0.57
Inventory to Revenue	--	--	--	--	--	--	0.05	0.04	0.04	0.03	0.15	0.17	0.14	0.14	0.14	0.15
Interest Exp. to Revenue %	-2.63	-2.51	-1.47	-1.20	-2.20	-0.79	-3.70	-3.14	-2.41	-2.25	-1.88	-2.42	-2.22	-2.31	-2.07	-1.88

Asset Turnover	0.42	0.41	0.46	0.35	0.35	0.38	0.27	0.34	0.33	0.33	0.08	0.08	0.09	0.08	0.08	0.08
Buyback Ratio	-6.50	-1.70	-0.90	-0.80	-0.80	-0.40	-1.50	-10.20	-9.80	-10.50	-14.10	-30.70	-1.20	-6.70	-8.50	-14.10
Dividend Payout Ratio	0.06	0.08	0.12	0.07	0.07	0.04	0.15	0.20	0.15	0.25	0.66	0.28	0.16	0.33	0.33	0.66
Income Statement	Annuals (USD $) View: $ %											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	TTM	Mar12	Jun12	Sep12	Dec12	Mar13

Revenue	5,855	7,399	9,909	11,414	12,298	15,856	10,861	14,041	15,203	15,877	16,005	3,893	4,105	3,900	3,979	4,021
Cost of Goods Sold	2,297	2,609	3,235	4,546	3,505	6,278	5,040	6,521	7,562	8,438	9,620	2,156	3,125	2,077	2,126	2,290
Gross Profit	3,558	4,790	6,674	6,869	8,792	9,578	5,821	7,521	7,641	7,439	6,385	1,737	979	1,823	1,853	1,730

Selling, General, &Admin. Expense	282	367	857	313	3,463	176	1,249	375	230	54.90	335	110	75.49	111	22.55	126
Earnings Before DDA	3,171	4,261	5,559	6,304	5,099	9,208	4,700	6,778	7,367	7,236	6,248	1,550	1,218	1,675	1,793	1,563

Depreciation, Depletion and Amortization	1,534	1,734	1,974	2,344	2,807	2,631	2,764	3,957	3,533	4,243	4,407	956	1,063	1,035	1,189	1,120

Operating Income	1,637	2,527	3,586	3,961	2,292	6,577	1,936	2,822	3,833	2,993	1,841	594	155	639	604	443
Interest Income/Expense	-154	-186	-146	-137	-271	-125	-402	-440	-366	-357	-339	-94.12	-91.18	-90.20	-82.35	-75.49
Net Income	1,366	1,378	1,030	2,475	2,557	4,888	1,549	1,664	2,591	1,855	1,645	419	738	353	345	209

Preferred dividends	5.05	4.71	--	--	--	--	--	--	--	--	--	--	--	--	--	--
Earnings per Share ($)	1.24	1.27	0.96	2.30	2.37	4.52	1.43	1.53	2.35	1.69	1.49	0.38	0.67	0.32	0.31	0.19
Total Shares Outstanding	1,096	1,077	1,077	1,074	1,078	1,081	1,084	1,088	1,103	1,100	1,094	1,105	1,101	1,097	1,095	1,094
Balance Sheet	Annuals (USD $) View: $ %											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

Cash and cash equivalents	102	27.06	17.10	22.84	20.45	26.19	12.75	21.57	33.33	36.27	17.65	12.75	9.80	20.59	36.27	17.65
Accounts Receivable	736	1,153	1,515	1,908	1,629	1,484	1,125	1,452	2,036	1,174	1,415	1,320	1,497	1,338	1,174	1,415
Inventory	--	--	--	--	--	--	573	598	539	543	615	658	581	559	543	615
Other Current Assets	2.01	34.65	479	264	489	1,816	143	58.27	118	124	148	125	171	188	124	148
Total Current Assets	839	1,214	2,011	2,195	2,138	3,326	1,854	2,129	2,726	1,876	2,195	2,115	2,259	2,105	1,876	2,195

Property, Plant and Equipment	13,009	16,729	19,308	30,163	33,237	38,201	38,348	39,678	40,815	45,725	46,291	43,728	44,050	44,494	45,725	46,291
Other Long Term Assets	71.99	106	105	152	30.18	287	17.65	24.51	2,810	419	379	361	340	331	419	379
Total Assets	13,920	18,049	21,424	32,510	35,406	41,814	40,220	41,832	46,351	48,020	48,866	46,204	46,649	46,930	48,020	48,866

Accounts Payable	1,153	1,408	2,308	2,412	1,908	2,141	1,727	2,389	3,157	2,964	3,077	3,040	2,835	2,917	2,964	3,077
Current Portion of Long-Term Debt	181	191	--	--	--	412	630	705	352	782	249	1,128	1,142	1,116	782	249
Other Current Liabilities	--	254	1,442	598	1,585	800	--	--	446	152	273	353	141	171	152	273
Total Current Liabilities	1,334	1,853	3,750	3,011	3,494	3,353	2,358	3,094	3,955	3,898	3,599	4,522	4,119	4,203	3,898	3,599

Long-Term Debt	2,593	3,469	3,256	10,826	10,725	12,349	9,469	8,332	8,051	7,782	8,890	6,951	7,213	7,135	7,782	8,890
Other Long-Term Liabilities	3,996	5,547	6,343	8,194	8,127	8,098	9,348	9,832	11,896	12,532	12,480	11,801	11,865	11,945	12,532	12,480
Total Liabilities	7,922	10,869	13,349	22,030	22,346	23,800	21,175	21,259	23,902	24,213	24,970	23,274	23,196	23,283	24,213	24,970

Common Stock	--	--	--	--	--	--	2,778	--	--	--	--	--	--	--	--	--
Preferred Stock	101	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--
Retained Earnings	3,573	4,825	5,690	7,981	10,368	15,043	16,369	17,652	18,985	20,114	20,161	19,271	19,797	19,983	20,114	20,161
Additional Paid-In Capital	2,307	2,361	2,394	2,512	2,621	2,714	2,778	3,085	3,438	3,636	3,669	3,602	3,598	3,619	3,636	3,669
Total Equity	5,998	7,181	8,075	10,480	13,060	18,014	19,045	20,574	22,449	23,807	23,896	22,930	23,453	23,647	23,807	23,896
Cashflow Statement	Annuals (USD $) View: $ %											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	TTM	Mar12	Jun12	Sep12	Dec12	Mar13

Net Income	1,366	1,378	1,030	2,475	2,557	4,888	1,549	1,664	2,591	1,855	1,645	419	738	353	345	209
Depreciation, Depletion and Amortization	1,534	1,734	1,974	2,344	2,807	2,631	2,764	3,957	3,533	4,243	4,407	956	1,063	1,035	1,189	1,120
Cash Flow from Others	169	506	1,700	-724	341	-884	1,385	540	-3.92	-10.78	-251	53.92	-218	104	49.02	-186
Cash Flow from Operations	3,070	3,617	4,703	4,094	5,705	6,634	5,698	6,161	6,121	6,087	5,801	1,428	1,583	1,492	1,583	1,142

Investment for Property, Plant & Equipement	-2,477	-4,493	-5,235	-7,123	-6,338	-7,287	-2,926	-5,230	-6,079	-5,984	-6,142	-1,490	-1,260	-1,542	-1,692	-1,648
Cash Flow from Acquisitions	--	--	--	-4,550	--	--	--	--	--	--	--	--	--	--	--	--
Cash Flow from Investing	-2,123	-4,571	-4,248	-11,505	-6,412	-7,037	-3,488	-5,096	-5,846	-5,811	-6,048	-1,252	-1,501	-1,454	-1,604	-1,489

Net Issuance of Stock	-54.30	-9.41	-140	-6.85	20.45	17.86	23.53	100.00	148	-122	-229	106	-103	-38.24	-86.27	-1.96
Net Issuance of Debt	-725	981	-225	7,537	850	550	-2,015	-855	-25.49	320	972	-203	-345	136	731	449
Cash Flow for Dividends	-84.61	-98.82	-119	-150	-174	-204	-221	-296	-371	-435	-451	-97.06	-113	-113	-113	-113
Other Financing	-10.10	7.06	18.24	35.41	8.76	44.04	-11.76	-4.90	-14.71	-36.27	-39.22	-2.94	475	-12.75	-496	-5.88
Cash Flow from Financing	-874	880	-465	7,416	705	408	-2,224	-1,056	-263	-274	252	-197	-85.29	-27.45	36.27	328

Net Change in Cash	71.99	-74.11	-10.26	4.57	-1.95	5.95	-13.73	8.82	11.76	2.94	4.90	-20.59	-2.94	10.78	15.69	-18.63

Free Cash Flow	594	-875	-532	-3,029	-633	-654	2,772	930	41.18	103	-341	-61.76	324	-50.00	-109	-506
Valuation Ratios (Daily)	Annuals											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

PE Ratio(ttm)
Price to Tangible Book
Price-to-Free-Cash-Flow ratio
PS Ratio
EV-to-Revenue
EV-to-EBITDA
EV-to-EBIT
Earnings Yield (Joel Greenblatt)
Forward Rate of Return
Shiller PE Ratio
Valuation and Quality	Annuals											Quarterly
Fiscal Period	Dec03	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

Market Cap
Enterprise Value
Month End Stock Price
Net Cash (per share)
Net Current Asset Value (per share)
DCF (per share)
Median PS (per share)
Peter Lynch Fair Value (per share)
Graham Number (per share)
Altman Z-Score
Piotroski F-Score
Beneish M-Score

Switch to Another Stock:

GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names

Home About Jobs Advertise Site Map Term of Use Privacy Policy RSS Email Alerts Affiliate Program FAQ Contact Us
Disclaimers: GuruFocus.com is not operated by a broker, a dealer, or a registered investment adviser. Under no circumstances does any information posted on GuruFocus.com represent a recommendation to buy or sell a security. The information on this site, and in its related newsletters, is not intended to be, nor does it constitute, investment advice or recommendations. The gurus may buy and sell securities before and after any particular article and report and information herein is published, with respect to the securities discussed in any article and report posted herein. In no event shall GuruFocus.com be liable to any member, guest or third party for any damages of any kind arising out of the use of any content or other material published or available on GuruFocus.com, or relating to the use of, or inability to use, GuruFocus.com or any content, including, without limitation, any investment losses, lost profits, lost opportunity, special, incidental, indirect, consequential or punitive damages. Past performance is a poor indicator of future performance. The information on this site, and in its related newsletters, is not intended to be, nor does it constitute, investment advice or recommendations. The information on this site is in no way guaranteed for completeness, accuracy or in any other way. The gurus listed in this website are not affiliated with GuruFocus.com, LLC. Stock quotes provided by InterActive Data. Fundamental company data provided by Morningstar, updated daily.

FocusBar

Home

Premium Membership

Value Screens

Model Portfolios

Guru Stocks

Market Valuation

By Country

Articles

Submit Articles