返回 Skill 列表
extension
分类: 效率与办公无需 API Key

managing-community-reinvestment

构建CRA合规监控,包括贷款、投资和服务测试分析。在管理CRA合规性、分析贷款模式或记录社区投资时使用。

person作者: jakexiaohubgithub

Managing Community Reinvestment

Structures CRA compliance monitoring with lending, investment, and service test analysis.

When To Use

  • Preparing for a CRA examination cycle or responding to examiner requests
  • Analyzing HMDA and small-business lending data for geographic and borrower distribution
  • Evaluating whether the bank's assessment area delineation remains appropriate
  • Documenting qualified community development loans, investments, and services
  • Producing board-level or executive CRA performance reports
  • Responding to public comment periods or community group inquiries about CRA performance

Inputs To Gather

  • Assessment area definition — current MSA/county delineation, any recent branch openings or closings that may require redrawing [VERIFY against current branch network]
  • HMDA LAR data — loan-level records for the review period covering originations, purchases, denials by census tract, income level, and race/ethnicity
  • Small-business and small-farm loan data — CRA reporter data (Schedule RC-C Part II or equivalent) with revenue and geography breakdowns
  • Community development activity log — all CD loans, qualified investments, CD services, and innovative/flexible lending products with dates, amounts, and purpose codes
  • Demographic and economic context — FFIEC census data, assessment area income distribution, unemployment rates, housing costs, and identified community credit needs
  • Prior CRA performance evaluation — last exam rating, cited strengths/weaknesses, any enforcement actions or commitments
  • Peer and aggregate comparators — FFIEC aggregate and peer group lending data for the same assessment areas

Workflow

  1. Validate assessment area boundaries — Confirm delineation includes all geographies where the bank has a substantial presence. Check that no low- or moderate-income (LMI) tracts are arbitrarily excluded. Flag any branch changes that may trigger redrawing. [VERIFY state-specific delineation rules if applicable]

  2. Run the Lending Test analysis

    • Calculate geographic distribution of home mortgage and small-business loans across LMI, middle-, and upper-income tracts
    • Calculate borrower distribution by applicant income level (low, moderate, middle, upper) relative to area median family income
    • Compare origination rates to FFIEC aggregate and designated peer institutions
    • Identify any conspicuous gaps — assessment area segments with lending substantially below demographic benchmarks
    • Catalog innovative or flexible lending products and their penetration in LMI segments
  3. Run the Investment Test analysis

    • Inventory all qualified investments: LIHTC equity, CDFI fund investments, municipal bonds benefiting LMI areas, charitable donations with CD purpose
    • Classify by responsiveness (addressing identified community needs), innovativeness, and complexity
    • Note unfunded commitments and prior-period investments still outstanding
    • Calculate total qualified investment volume as a ratio to Tier 1 capital or total assets for internal benchmarking
  4. Run the Service Test analysis

    • Map branch locations against LMI tract geography; calculate percentage of branches in LMI areas vs. percentage of LMI tracts in the assessment area
    • Review changes in branch availability (openings, closings, relocations) and their impact on LMI access
    • Document CD services: financial literacy programs, homebuyer counseling, small-business technical assistance, board service on CD organizations
    • Assess alternative delivery systems (ATMs, digital banking, mobile branches) and their effectiveness in serving LMI populations
  5. Synthesize performance rating projection

    • Map findings to the applicable rating matrix (Outstanding / Satisfactory / Needs to Improve / Substantial Noncompliance) for each test [VERIFY whether bank is evaluated under large-bank, intermediate small-bank, or small-bank framework]
    • Identify areas of strength to highlight and weaknesses requiring remediation before the next exam
    • Cross-reference against any strategic plan or prior commitments made to regulators or community groups
  6. Compile the management report

    • Executive summary with projected composite rating and test-level ratings
    • Data tables and heat maps for lending distribution and branch coverage
    • CD activity inventory with dollar amounts, purpose codes, and responsiveness ratings
    • Gap analysis with recommended corrective actions and timelines
    • Appendix with data sources, methodology notes, and any [VERIFY] items requiring follow-up

Output

A CRA compliance management report containing:

  • Assessment area profile with demographic context
  • Lending Test summary: geographic and borrower distribution tables, peer comparisons, gap flags
  • Investment Test summary: qualified investment inventory, dollar totals, responsiveness assessment
  • Service Test summary: branch distribution analysis, CD service catalog, alternative delivery review
  • Composite rating projection with test-level breakdowns
  • Remediation recommendations prioritized by exam risk
  • Data appendix and methodology notes

Quality Checks

  • Confirm HMDA and CRA reporter data reconcile to Call Report totals — unexplained variances invalidate the analysis
  • Verify census tract income classifications use the most current FFIEC designations [VERIFY effective year of census data]
  • Ensure CD activities meet the regulatory definition — loans, investments, and services must have community development as a primary purpose, not an incidental benefit
  • Check that peer and aggregate comparisons use the correct FFIEC-defined peer group and same reporting period
  • Validate that assessment area boundaries do not reflect illegal redlining or arbitrary exclusion of LMI geographies
  • Confirm all dollar figures and percentages are internally consistent across tables and narrative
  • Flag any data points sourced from estimates or third-party models with [VERIFY] for examiner transparency