CDP (Financial Data) 3 — Questions and Answers
Question 1: Which financial statement reports a company's revenues, expenses, and net income over a specific period?
- Income Statement (Correct answer)
- Balance Sheet
- Statement of Cash Flows
- Statement of Retained Earnings
Correct answer: Income Statement
The Income Statement (Profit & Loss Statement) summarizes revenues and expenses over a defined reporting period.
Question 2: In financial time-series data, what is 'survivorship bias'?
- Analyzing only companies that survived to the present, excluding failed ones (Correct answer)
- Carrying forward the last known value in a series
- Weighting recent data more heavily than historical data
- Excluding outlier transactions from analysis
Correct answer: Analyzing only companies that survived to the present, excluding failed ones
Survivorship bias occurs when a dataset only includes entities that still exist, inflating apparent average performance.
Question 3: What is the purpose of a 'wash sale rule' in financial data compliance?
- Disallow a tax loss deduction if the same security is repurchased within 30 days (Correct answer)
- Require immediate settlement of all equity trades
- Mandate daily reconciliation of trading accounts
- Prevent double-counting of dividend income
Correct answer: Disallow a tax loss deduction if the same security is repurchased within 30 days
The IRS wash sale rule disallows claiming a capital loss if a substantially identical security is bought within 30 days before or after the sale.
Question 4: Which cash flow category includes payments for acquiring property, plant, and equipment?
- Investing Activities (Correct answer)
- Operating Activities
- Financing Activities
- Non-cash Activities
Correct answer: Investing Activities
Capital expenditures on long-term assets like PP&E are classified under Investing Activities in the cash flow statement.
Question 5: A data professional is integrating market data from multiple vendors and finds different prices for the same security at the same timestamp. What is the most likely cause?
- Different consolidation methodologies for trade and quote data across exchanges (Correct answer)
- Data vendor API rate limiting
- Time zone conversion errors in the ETL pipeline
- Duplicate record insertion in the staging table
Correct answer: Different consolidation methodologies for trade and quote data across exchanges
Securities trade on multiple exchanges with varying reporting methodologies, causing price discrepancies across market data vendors.
Question 6: What does EBITDA stand for and why is it commonly used in financial analysis?
- Earnings Before Interest, Taxes, Depreciation, and Amortization; used as a proxy for operating cash flow (Correct answer)
- Earnings Before Income Tax, Dividend, and Amortization; used for dividend coverage analysis
- Equity Balance Including Total Debt and Assets; used for balance sheet analysis
- Estimated Base Income Tax, Depreciation, and Adjustment; used for tax planning
Correct answer: Earnings Before Interest, Taxes, Depreciation, and Amortization; used as a proxy for operating cash flow
EBITDA removes non-cash charges and financing effects to approximate the cash earnings power of a business.
Question 7: In financial data governance, what is the role of a 'golden record' for security master data?
- A single authoritative version of a financial instrument's attributes reconciled from multiple sources (Correct answer)
- The highest-value transaction in a trading day
- A historical record of a company's best earnings performance
- An audited version of a financial statement approved by regulators
Correct answer: A single authoritative version of a financial instrument's attributes reconciled from multiple sources
A golden record consolidates and reconciles instrument attributes from multiple data vendors into one trusted, authoritative source.
CDP (Financial Data) 3
Which financial statement reports a company's revenues, expenses, and net income over a specific period?