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

Stock: BMY
Validation Date: 2025-12-23T18:17:41.927993
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: $34,332,000,000 / $48,300,000,000 × 100 = 71.08%
  Status: ✅ VALID (0-100%)

✓ Operating Margin Verification (FY 2024 GAAP):
  Formula: Operating Income / Revenue × 100
  Calculation: $0 / $48,300,000,000 × 100 = 0.00%
  Hierarchy Check: Operating Margin (0.00%) ≤ Gross Margin (71.08%)
  Status: ✅ VALID

⚠️ P/E Ratio: Not Meaningful (negative or zero earnings)


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

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

[TTM - Trailing Twelve Months] (as of LTM):
  Revenue: $48,034,000,000
  Net Income: $6,039,000,000
  EPS (Diluted): $3000000.00
  Source: fiscal.ai quarterly scraping

[FY 2024 GAAP] (Annual Audited):
  Revenue: $48,300,000,000
  Net Income: $-8,933,000,000
  EPS (Diluted): $-4.40
  Source: FinQual 10-K filings

[Current Market Data]:
  Stock Price: $54.28
  Market Cap: $111274263000
  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
--------------------------------------------------------------------------------

✅ All data quality checks passed
   - Historical data: 10 years available
   - Quarterly data: 10 quarters available
   - Current price: Verified from fiscal.ai real-time scraping


📝 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: PASSED

📊 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)

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