Canadian Pacific Kansas City Limited (CP)
Quantitative Summary
DeterministicStrong operational fundamentals (Piotroski 7/9).
Generated deterministically from quant metrics and financial statements. Not a recommendation.
DCF Sandbox
InteractiveSensitivity Matrix
| TG ↓ / WACC → | 8% | 10% | 12% |
|---|---|---|---|
| 2% | $16 | $6 | $1 |
| 3% | $22 | $9 | $3 |
| 4% | $31 | $13 | $5 |
Center = base case. Green = >10% upside, Red = >10% downside vs —.
Pre-computed DCF: WACC=10.0%, terminal growth 3%. Fair value $9 (+0.0%). Not investment advice.
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
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 VEA or SPDW, the fund manager is mechanically forced to buy or sell CP shares regardless of Canadian Pacific Kansas City Limited's individual fundamentals. We estimate $2.2B of passive capital is structurally linked to CP through 6 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 6 tracked ETFs. Actual passive ownership is larger (includes mutual funds). Not investment advice.
ETF Contagion Visualizer
Simulate a price drop in Canadian Pacific Kansas City Limited to visualize passive redemption contagion across ETFs and collateral stocks.
If Canadian Pacific Kansas City Limited (CP) experiences a significant drawdown, ETF redemptions can create collateral selling pressure on co-held stocks. Our model identifies Taiwan Semiconductor Manufacturing Co. Ltd. (2330) as the most exposed collateral stock, sharing 2 ETFs with CP. This is the "Passive Contagion" effect described in the Inelastic Market Hypothesis.
Contagion model based on shared ETF exposure and constituent weights across 6 tracked ETFs. Estimated selling pressure is a simplified model — actual impact depends on market liquidity, ETF redemption mechanics, and market-maker activity.
CP Ownership Dynamics
ETFs with Highest CP Exposure
Float lock-up computed from 6 ETFs tracked by SecuritiesDB. Actual passive ownership is higher (includes mutual funds, pension funds, etc.).
CP Capital Efficiency
How efficiently does Canadian Pacific Kansas City Limited convert operating profits into free cash? The FCF Conversion ratio measures the gap between accounting earnings and real cash generation.
Canadian Pacific Kansas City Limited converts 26% 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 74% reinvestment rate signals aggressive capacity expansion.
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-13 | 888 | $85.82 | $76,208.16 |
| 2026-05-11 | 3,466 | $86.04 | $298,214.64 |
| 2026-05-08 | 106,798 | $85.22 | $9.1M |
| 2026-05-07 | 118 | $85.98 | $10,145.64 |
| 2026-05-05 | 10,965 | $83.13 | $911,520.45 |
| 2026-05-04 | 12,351 | $86.22 | $1.1M |
| 2026-04-29 | 15,904 | $86.75 | $1.4M |
| 2026-04-22 | 6,036 | $82.49 | $497,909.64 |
| 2026-04-20 | 138,982 | $81.48 | $11.3M |
| 2026-04-17 | 21,970 | $80.14 | $1.8M |
| 2026-04-09 | 113 | $81.65 | $9,226.45 |
| 2026-04-08 | 329 | $80.08 | $26,346.32 |
| 2026-04-07 | 13,402 | $79.50 | $1.1M |
| 2026-04-06 | 1,967 | $78.97 | $155,333.99 |
| 2026-04-01 | 433 | $78.66 | $34,059.78 |
| 2026-03-26 | 3,986 | $80.06 | $319,119.16 |
| 2026-03-25 | 104,237 | $79.24 | $8.3M |
| 2026-03-24 | 32,342 | $79.46 | $2.6M |
| 2026-03-23 | 4,776 | $78.24 | $373,674.24 |
| 2026-03-19 | 580 | $79.94 | $46,365.2 |
| 2026-03-16 | 67,269 | $81.36 | $5.5M |
| 2026-03-13 | 1,019 | $81.17 | $82,712.23 |
| 2026-03-09 | 36,566 | $82.96 | $3.0M |
| 2026-03-03 | 34,485 | $89.39 | $3.1M |
| 2026-03-02 | 1 | $87.59 | $87.59 |
| 2026-02-27 | 59,325 | $87.12 | $5.2M |
| 2026-02-25 | 5 | $86.29 | $431.45 |
| 2026-02-24 | 17,865 | $84.75 | $1.5M |
| 2026-02-23 | 11,729 | $85.10 | $998,137.9 |
| 2026-02-20 | 235 | $84.70 | $19,904.5 |
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 CP 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.