Chapter 13 Exercises

Regulatory Reporting: From XBRL to API-Based Reporting

Exercise 13.1: XBRL Concept Identification

Difficulty: Introductory

For each of the following data elements, identify: - Whether it would likely be found in COREP, FINREP, or both - What data type it would have in XBRL (monetary, percentage, integer, date, string) - Whether it is a "duration" (covering a period) or "instant" (a point-in-time) fact

a) Common Equity Tier 1 capital as of December 31, 2023 b) Net interest income for the year ended December 31, 2023 c) Liquidity Coverage Ratio for the month ended November 30, 2023 d) Number of non-performing loans as of September 30, 2023 e) Credit risk exposure to EU central governments, standardized approach, CQS 1 f) Total impairment losses on financial assets for Q3 2023

Exercise 13.2: Regulatory Reporting Timeline Management

Difficulty: Introductory

A mid-size EU bank (significant institution supervised by the ECB) has the following reporting requirements:

For the reporting period ending March 31, 2025 (assume all weekdays, no public holidays in the calculation):

a) Calculate the filing deadline for each report. (Note: business days = calendar days minus weekends. Start from April 1, 2025.)

b) Identify the earliest-deadline report and the latest-deadline report for this quarter.

c) Design a quarterly reporting calendar: working backward from each deadline, identify the latest date on which each of the following steps can begin: - Data extraction from source systems (assume 5 business days needed) - Calculation engine run (assume 3 business days needed) - Internal review and sign-off (assume 4 business days needed) - XBRL generation and validation (assume 2 business days needed)

d) What is the risk of the LCR report (monthly) being published before the quarterly capital report if both cover the same reporting date?

Exercise 13.3: Risk Weight Calculation

Difficulty: Intermediate

Using the Basel III standardized approach risk weights (simplified: Sovereign CQS1=0%, CQS2=20%, CQS3=50%; Institution CQS1=20%, CQS2=50%; Corporate CQS1-2=20-50%, CQS3-4=100%; Retail=75%; Residential Real Estate=35%):

Calculate the risk-weighted assets (RWA) for the following portfolio. Show your workings.

a) Calculate RWA for each exposure. b) Calculate total portfolio RWA. c) If CET1 capital is £18M and Total Capital is £22M, calculate CET1 ratio, Tier 1 ratio, and Total Capital ratio. d) Does this institution meet Basel III minimum capital requirements (CET1 ≥ 4.5%, T1 ≥ 6%, Total ≥ 8%)?

Exercise 13.4: Data Quality Assessment

Difficulty: Intermediate

A bank's internal audit team has reviewed the regulatory reporting process and identified the following findings. For each finding, identify: (1) which BCBS 239 principle is violated, (2) which data quality dimension is affected, and (3) a recommended control to address it.

Finding A: The credit risk exposure for counterparty "Acme Holdings Ltd" appears in the COREP large exposures report as £45M but appears in the FINREP balance sheet as £42M. Both figures were taken from different source systems without reconciliation.

Finding B: The calculation of Risk-Weighted Assets under the IRB approach is documented in a spreadsheet named "RWA_calc_FINAL_v3_updated_use_this_one.xlsx." The formula in cell D147 references external spreadsheets that no longer exist in the network drive location specified.

Finding C: The regulatory reporting team could not produce an ad hoc report requested by the CFO showing the institution's total exposure to the technology sector, broken down by geography. The response was: "We can get that data but it would take 3 weeks to compile manually."

Finding D: The Q4 2023 FINREP submission used source data extracted on December 28, 2023 — three days before the reporting date of December 31, 2023. Three large loans that were originated on December 29–31 were not included.

Finding E: The regulatory data store reconciliation to the general ledger has not been run for the past two months because the reconciliation script "broke" after a GL system upgrade and has not yet been fixed.

Coding Exercise 13.5: Build a Reporting Data Validation Tool

Difficulty: Coding — Intermediate

Extend the CapitalReportValidator class from the chapter to add more sophisticated validation rules.

1. Add the following validation rules to the validator: - CR-007: Leverage Ratio check. The leverage ratio = Tier 1 Capital / Total Exposure Measure. Minimum requirement: 3.0%. (For this exercise, assume Total Exposure Measure = Total RWA / 0.7, a simplification.) - CR-008: Capital Conservation Buffer. Institutions must maintain an additional 2.5% CET1 buffer above the 4.5% minimum. Flag a warning (not error) if CET1 ratio is below 7.0%. - CR-009: Data completeness check. Verify that at least one exposure exists in each of the following exposure classes: CORPORATE, RETAIL, INSTITUTION. (An institution with no retail or corporate exposure may have a data completeness gap.) - CR-010: Negative exposure check. No individual exposure should have a negative exposure_amount. Flag any violating exposure by ID.

2. Create a ValidationSummary class that takes a list of ValidationResult objects and: - Counts passing/failing rules by severity - Returns a summary string indicating overall status: "CLEAN" (all rules pass), "WARNINGS" (only warnings fail), or "ERRORS" (one or more errors fail) - Returns a DataFrame of only the failing rules

3. Test your implementation with: - A valid exposure book (all rules pass) - A portfolio with a negative exposure amount - A portfolio missing the RETAIL exposure class - A portfolio where CET1 ratio falls between 4.5% and 7.0% (conservation buffer warning)

Research Exercise 13.6: The Bank of England TDC Initiative

Difficulty: Research-required

The Bank of England's Transforming Data Collection (TDC) initiative was launched in 2022 and is one of the most significant regulatory reporting modernization programs globally.

a) What is the current status of the TDC initiative? Which reporting frameworks are in scope for the first phase? (Search for Bank of England TDC publications and updates from 2024–2025.)

b) The TDC initiative involves establishing "Common Data Standards" — shared definitions that institutions and the Bank of England both use. What is the governance model for these standards? Who decides the definitions, and how are institutions consulted?

c) A critic of API-based reporting argues: "Near-real-time regulatory reporting creates regulatory surveillance risk — regulators will have continuous visibility into bank positions, creating pressure on institutions to manage to regulatory metrics rather than to business objectives." Evaluate this criticism. Is it valid? What safeguards could address it?

d) Write a 300-word analysis comparing the Bank of England's TDC approach to the EU's IReF approach. Which approach is more ambitious? Which is more likely to succeed in the near term?