ORIGINAL COMPANY-CONTEXT PRACTICE
Aggregate facility and collateral records without duplicating exposure
Original practice scenario: A hypothetical banking analytics dataset links borrowers to facilities and facilities to several collateral records. Explain how to produce a borrower-level exposure summary.
Written for independent practice using company context; this is not a verified question from a company interview.
A REASONED APPROACH
Model answer.
Define the exposure measure at facility grain and treat collateral allocation as a separate relationship. Joining raw facility amounts to every collateral record can multiply the apparent exposure.
Work through it
- Validate facility identity, borrower ownership and the reporting cutoff, aggregating any transaction-level amounts to one intended facility measure first.
- Prepare collateral and allocation summaries independently, preserving shared collateral relationships and any approved allocation weights rather than assigning full value repeatedly.
- Join compatible summaries to borrowers and reconcile total exposure before and after enrichment, returning missing ownership or allocation evidence separately.
Tradeoffs to discuss
- Borrower summaries are easier to review but can conceal facility-specific constraints; retained detail supports drill-down and reconciliation.
Common pitfalls
- Do not sum collateral values as though they were interchangeable with exposure amounts.
- This practice report describes data assembly, not a lending decision or a verified valuation methodology.