CNQ (NYSE) - Fundamental Data Analysis

Return on Equity 17.98% ✓ Free Cash-Flow Yield 8.96% ✓ Debt / EBITDA 0.71 ✓ RoIC 12.77% and many other metrics.

VR Fundamental Rating 3.77

VR Piotroski Score 5.00
Tobins Q Ratio 0.50
Free-Cash-Flow Yield 8.96%
Free-Cash-Flow Margin 16.90%
Net Margin 17.31%
Gross Margin 25.11%
Current Ratio 0.91
Debt / Equity 0.29
Debt / EBITDA 0.71
Debt / Free-Cash Flow 1.67
Interest Expense / Debt 1.61%
WACC 8.33%
RoE Return on Equity 17.98%
RoCE Return on Cap. Employed 12.91%
RoA Return on Assets 9.34%
RoIC Return on Inv. Cap. 12.77%
Analysts Rating 4.09
Analysts Target Price
(is above last close by
71.45 USD
13.1%)

VR Piotroski 5

Yes: Net Income TTM (7126.0m) > 10m and > 3% of Revenue TTM (3% = 1235.0m)
No: FCF TTM (6956.0m) > 1m and > FCF prev (97%) (13698.3m)
No: RoA TTM 9.34% (Net Income TTM 7126.0m / Total Assets 76313.0m) >3% and > RoA prev (97%) 13.69% (10937.0m / 77479.0m)
Yes: Total Cash from Operating Activities TTM 12082.0m > 1m and > Net Income TTM 7126.0m
Yes: Net Debt (Debt 11.64km - CCE 125.0m) to EBITDA TTM (16.27km) ratio: 0.71 < 3.5
No: Current Ratio 0.91 (Total Current Assets 7513.0m / Total Current Liabilities 8251.0m) >= 1 and > Current Ratio prev (97%) 0.78 (7150.0m / 9125.0m)
Yes: Shares Outstanding last Quarter 1101 m < 12m ago 1131 m
No: Gross Margin 25.11% (Total Revenue 41168.0m - Cost Of Revenue 30832.0m / Total Revenue) > 15% and > Gross Margin prev (97%) 0.37%
No: Asset Turnover 0.54 (Total Revenue 41168.0m / Total Assets 76313.0m) > 0.1 and similiar or better than previous period
Yes: Interest Coverage Ratio 27.34 (EBITDA TTM 16266.0m / Interest Expense TTM 595.0m) > 5

VR Altman 6.81

-0.010 (A) = (Total Current Assets 7513.0m - Total Current Liabilities 8251.0m) / Total Assets 76313.0m
1.471 (B) = Retained Earnings TTM 112259.0m / Total Assets 76313.0m
0.115 (C) = EBIT TTM 8785.0m / Total Assets 76313.0m
4.221 (D) = Book Value of Equity 154831.0m / Total Liabilities 36679.0m
0.539 (E) = Revenue TTM 41168.0m / Total Assets 76313.0m
Total Rating: 6.810 = (2.6 * A) + (1.5 * B) + (4.9 * C) + (0.95 * D) + (0.1 * E)

Current Fundamental Values

Market Capitalization = 66131.41m USD
Market Capitalization in USD = 66131.41m (66131.41m USD * 1 USDUSD)
Revenue TTM = 41168.0m
Ebit TTM = 8785.0m
Long Term Debt = 10040.0m (last quarter)
Short Term Debt = 1604.0m (last quarter)
Debt = 11644.0m (Short Term 1604.0 + Long Term 10040.0)
CCE Cash And Equivalents = 125.0m (last quarter)
Enterprise Value = 77650.4m (Market Cap 66131.4m + Debt 11.64km - CCE 125.0m)
Net Debt = 11.52km (11.64km Debt - 125.0m Cash and Cash Equivalents)
EBITDA = 16266.0m (TTM)
Interest Coverage Ratio = 27.34 (EbitDA TTM 16.27km / Interest Expense TTM 595.0m)
FCF Yield = 8.96% (FCF TTM 6956.0m / Enterprise Value 77650.4m)
FCF Margin = 16.9% (FCF TTM 6956.0m / Revenue TTM 41168.0m)
Net Margin = 17.31% (Net Income TTM 7126.0m / Revenue TTM 41168.0m)
Gross Margin = 25.11% ((Revenue TTM 41168.0m - Cost of Revenue TTM 30832.0m) / Revenue TTM)
Tobins Q-Ratio = 0.502 (Enterprise Value 77650.4m / Book Value Of Equity 154831.0m)
Interest Expense / Debt = 1.61% (Interest Expense 187.0m / Debt 11.64km)
Taxrate = 25.52% (Income Tax Expense 803.0m / Income Before Tax 3147 m, last quarter)
NOPAT Net Operating Profit after Tax = 6543.4m (Operating Income TTM 8785 m * (1 - Taxrate 0.26))
Current Ratio = 0.91 (Total Current Assets 7513 m / Total Current Liabilities 8251 m)
Debt / Equity = 0.29 (Debt 11644m / last Quarter total Stockholder Equity 39634m)
Debt / EBITDA = 0.71 (Debt 11.64km - Cash and Cash Equivalents 125.0m / EBITDA 16.27km)
Debt / FCF = 1.67 (Debt 11644m / FCF TTM 6956m)
RoA = 9.34%
RoE = 17.98% (Net Income TTM 7126m / Total Stockholder Equity 39634m)
RoCE = 12.91% (Ebit TTM 8785 m / x)
RoIC = 12.77% (Ebit TTM 8785 m / (Total Assets 76.31km - Total Current Assets 7513 m) )
WACC = 8.33% ((Market Cap / EV) * CAPM 0.10) + (Debt / EV) * Interest Expense on Debt * (1 - Taxrate)
Shares Correlation 10-Years: 6.67 | Cagr: 0.06%
Discount Rate = 8.33% (= WACC)
Revenue Correlation 4-Years: 57.89 | Revenue CAGR: 4.04%
EPS Correlation 4-Years: 41.52 | EPS CAGR: 5.29%