Canadian Natural Resources Limited (CNQ)
Quantitative Summary
DeterministicAt 13.5x earnings — a 61% discount to the sector average of 34.8x — CNQ is in the lower valuation range. Strong operational fundamentals (Piotroski 7/9) with Altman Z of 2.8.
Generated deterministically from quant metrics and financial statements. Not a recommendation.
Algorithmic Teardown
AI-GeneratedThe company exhibits robust fundamental economics characterized by a high-quality capital allocation profile, evidenced by an ROIC of 13.3% and a strong Piotroski F-Score of 7/9 which signals consistent financial health and operational improvement. The earnings power is driven primarily by exceptional profitability rather than asset efficiency or leverage; the DuPont decomposition reveals that a net margin of 24.5% serves as the dominant engine, outperforming an asset turnover ratio of just 0.48x while maintaining a conservative equity multiplier of 2.07x. Furthermore, the Beneish M-Score of -2.48 suggests earnings are highly credible with low manipulation risk, reinforcing the validity of these margin-driven returns in an environment where revenue growth is modest at 6.4% year-over-year.
Valuation metrics indicate a significant discount relative to historical norms and sector peers, as the current P/E ratio of 13.5x trades well below typical expansion multiples for firms with such superior margins. A DCF analysis places fair value at $32, implying that the market is currently pricing in subdued growth expectations rather than recognizing the full potential of its high-margin business model. This discrepancy between intrinsic valuation and current trading levels suggests the stock may be undervalued relative to its cash flow generation capabilities, though this opportunity must be weighed against broader macroeconomic variables not explicitly detailed here.
Significant insider activity provides a notable risk-reward delta; net buying totaling over $103 million within the last 90 days demonstrates strong internal confidence and aligns management's incentives with shareholder returns. While the Fama-French alpha is not provided in the data, the combination of high ROIC, low manipulation scores, and substantial insider accumulation creates a compelling case for long-term value accretion, assuming the current valuation gap persists relative to historical averages.
Generated by LLM from quantitative data inputs. May contain inaccuracies. Not investment advice.
DCF Sandbox
InteractiveSensitivity Matrix
| TG ↓ / WACC → | 8.4% | 10.4% | 12.4% |
|---|---|---|---|
| 2% | $39 | $29 | $22 |
| 3% | $46 | $32 | $24 |
| 4% | $55 | $36 | $26 |
Center = base case. Green = >10% upside, Red = >10% downside vs —.
Pre-computed DCF: WACC=10.4%, terminal growth 3%. Fair value $32 (+0.0%). Not investment advice.
Valuation Context
Price Chart with Moving Averages
Quant Health Deep Dive
Profitability & Value Creation
✅ Conservative payout — room for dividend increases.
DuPont Analysis — ROE Decomposition
Breaking down Return on Equity to see how the company generates its ROE — efficiency, margins, or leverage.
Balance Sheet Health
Insider Activity (Last 90 Days)
Open-market buys vs sells by company insiders. Source: yfinance.
Earnings Surprise History
EPS estimates vs actuals for the most recent reported quarters. Source: yfinance.
Underwater (Drawdown from Peak)
How far below the all-time high the price has been over time. Deeper = more pain for holders.
Rolling 60-Day Beta vs S&P 500 (VOO)
How the stock's sensitivity to market moves changes over time. β > 1 = more volatile than the market.
Fundamentals
Passive Flow Attribution
ETF Draft EffectWhen investors buy or sell ETFs like VYMI or CWI, the fund manager is mechanically forced to buy or sell CNQ shares regardless of Canadian Natural Resources Limited's individual fundamentals. We estimate $2.8B of passive capital is structurally linked to CNQ through 7 tracked ETFs. Index rebalances and ETF creation/redemption cycles can create noticeable volume spikes unrelated to company news.
Passive exposure = Σ (ETF AUM × stock weight in ETF) across 7 tracked ETFs. Actual passive ownership is larger (includes mutual funds). Not investment advice.
ETF Contagion Visualizer
Simulate a price drop in Canadian Natural Resources Limited to visualize passive redemption contagion across ETFs and collateral stocks.
If Canadian Natural Resources Limited (CNQ) experiences a significant drawdown, ETF redemptions can create collateral selling pressure on co-held stocks. Our model identifies SAMSUNG ELECTR GDR REG S (SMSN) as the most exposed collateral stock, sharing 2 ETFs with CNQ. This is the "Passive Contagion" effect described in the Inelastic Market Hypothesis.
Contagion model based on shared ETF exposure and constituent weights across 7 tracked ETFs. Estimated selling pressure is a simplified model — actual impact depends on market liquidity, ETF redemption mechanics, and market-maker activity.
CNQ Ownership Dynamics
ETFs with Highest CNQ Exposure
Float lock-up computed from 7 ETFs tracked by SecuritiesDB. Actual passive ownership is higher (includes mutual funds, pension funds, etc.).
CNQ Capital Efficiency
How efficiently does Canadian Natural Resources Limited convert operating profits into free cash? The FCF Conversion ratio measures the gap between accounting earnings and real cash generation.
Canadian Natural Resources Limited converts 38% of its EBITDA into free cash flow, a moderate conversion rate — significant EBITDA is consumed by capital expenditures, working capital changes, or interest payments. The 62% reinvestment rate signals aggressive capacity expansion. The positive ROIC-WACC spread of 3.1% confirms that reinvested capital creates shareholder value.
Capital efficiency = Free Cash Flow ÷ EBITDA. Reinvestment = (EBITDA − FCF) ÷ EBITDA. Metrics from latest annual filings. Not investment advice.
Fails-to-Deliver (FTD) History
SEC-reported settlement failures. Elevated FTDs can indicate high short-selling pressure, operational settlement issues, or naked shorting activity.
| Date | Failed Shares | Close Price | Notional Value |
|---|---|---|---|
| 2026-05-14 | 20 | $47.20 | $944 |
| 2026-05-08 | 189 | $44.74 | $8,455.86 |
| 2026-05-05 | 23,400 | $47.58 | $1.1M |
| 2026-05-04 | 47,881 | $46.96 | $2.2M |
| 2026-04-28 | 2,311,655 | $45.02 | $104.1M |
| 2026-04-24 | 264 | $45.43 | $11,993.52 |
| 2026-04-22 | 263 | $44.28 | $11,645.64 |
| 2026-04-17 | 3,565 | $46.31 | $165,095.15 |
| 2026-04-15 | 249,483 | $45.65 | $11.4M |
| 2026-04-14 | 238,420 | $46.85 | $11.2M |
| 2026-04-13 | 300 | $46.35 | $13,905 |
| 2026-04-10 | 37,561 | $45.70 | $1.7M |
| 2026-04-09 | 55,595 | $46.43 | $2.6M |
| 2026-04-07 | 2,051 | $48.25 | $98,960.75 |
| 2026-04-02 | 593,070 | $46.56 | $27.6M |
| 2026-04-01 | 231 | $48.73 | $11,256.63 |
| 2026-03-30 | 2,504 | $50.09 | $125,425.36 |
| 2026-03-27 | 1,204,900 | $48.67 | $58.6M |
| 2026-03-23 | 16,795 | $49.02 | $823,290.9 |
| 2026-03-20 | 6,209 | $50.55 | $313,864.95 |
| 2026-03-19 | 34,697 | $49.10 | $1.7M |
| 2026-03-16 | 27 | $48.44 | $1,307.88 |
| 2026-03-13 | 142,562 | $48.56 | $6.9M |
| 2026-03-12 | 45,032 | $47.26 | $2.1M |
| 2026-03-11 | 499 | $45.72 | $22,814.28 |
| 2026-03-10 | 783,547 | $46.24 | $36.2M |
| 2026-03-09 | 26,828 | $46.31 | $1.2M |
| 2026-03-06 | 456 | $45.32 | $20,665.92 |
| 2026-03-04 | 91,019 | $44.13 | $4.0M |
| 2026-03-02 | 4,100 | $43.77 | $179,457 |
Source: SEC Regulation SHO FTD data. Data is reported with a ~30 day delay. High FTD quantities relative to average daily volume may indicate settlement stress.
Compare CNQ to Peers
Quant metrics computed deterministically from financial statements and price data. Updated: N/A.
SecuritiesDB provides programmatic data aggregation for informational purposes only. None of the metrics, summaries, or algorithmic flags constitute a recommendation to buy or sell any security.