================================================================================
DATA INTEGRITY & VALIDATION REPORT
================================================================================

Stock: CP
Company: CP
Sector: Industrials | Industry: Railroads

Validation Date: 2026-01-22T08:46:50.079492
Data Sources: FinQual (10-year annual) + fiscal.ai (quarterly real-time) + Alpha Vantage
Source Priority: fiscal.ai (real-time) > FinQual (API)

--------------------------------------------------------------------------------

📊 FORMULA VERIFICATIONS
--------------------------------------------------------------------------------

✓ Gross Margin Verification (FY 2024 GAAP):
  Formula: Gross Profit / Revenue × 100
  Calculation: $12,338,000,000 / $14,546,000,000 × 100 = 84.82%
  Status: ✅ VALID (0-100%)

✓ Operating Margin Verification (FY 2024 GAAP):
  Formula: Operating Income / Revenue × 100
  Calculation: $5,179,000,000 / $14,546,000,000 × 100 = 35.60%
  Hierarchy Check: Operating Margin (35.60%) ≤ Gross Margin (84.82%)
  Status: ✅ VALID

⚠️ P/E Ratio: Not calculable (insufficient data)


📋 METRIC CLASSIFICATIONS
--------------------------------------------------------------------------------

[HISTORICAL DATA AVAILABILITY]:
  Annual Statements: 10 years (2016 - 2025)
  Quarterly Data: 10 periods (latest: LTM)
  Source: FinQual 10-K + fiscal.ai scraping

[TTM - Trailing Twelve Months] (as of LTM):
  Revenue: $15,029,000,000
  Net Income: $4,265,000,000
  EPS (Diluted): $4600000.00
  Source: fiscal.ai quarterly scraping

[FY 2024 GAAP] (Annual Audited):
  Revenue: $14,546,000,000
  Net Income: $3,713,000,000
  EPS (Diluted): $3.98
  Source: FinQual 10-K filings

[Current Market Data]:
  Stock Price: $72.38
  Market Cap: $65,860,000,000
  Source: fiscal.ai real-time scraping (verified)


⚠️ DATA DISCREPANCIES & RESOLUTIONS
--------------------------------------------------------------------------------

✅ No significant discrepancies between data sources
   All metrics validated within tolerance thresholds


🔍 DATA QUALITY ASSESSMENT
--------------------------------------------------------------------------------

🔴 Issue 1 [HIGH]: Invalid revenue data
   Detail: Revenue for 2025: None


📝 DATA EXCLUSIONS & ADJUSTMENTS
--------------------------------------------------------------------------------

The following adjustments were made to ensure data accuracy:
• Non-GAAP metrics clearly labeled as [Adjusted]
• Forward estimates labeled as [Forward Estimate] with source attribution
• Missing or invalid data points marked as 'N/A' rather than estimated
• fiscal.ai quarterly data preferred over annual for recency


================================================================================
VALIDATION SUMMARY
================================================================================

❌ Overall Status: FAILED

📊 Data Completeness:
   • Annual Statements: 10 years
   • Quarterly Data: 10 quarters
   • Balance Sheet: 10 years

🔒 Data Integrity:
   • Formula Verifications: Completed
   • Margin Validations: Completed
   • Cross-Source Checks: 0 discrepancies resolved

✓ Institutional-Grade Standards:
   • All metrics labeled with data type (FY GAAP/TTM/Adjusted/Forward)
   • Source attribution for all data points
   • Formula calculations shown and verified
   • Data hierarchy validated (Operating ≤ Gross margins)

================================================================================