Back to Solutions Library
Solution 25 of 25PWS · Report GenerationFO · Credit Reform Act

Multi-Program Portfolio Risk Reporting

RD's $224B portfolio spans RHS, RBCS, and RUS with materially different risk profiles per program (Section 502 Direct subsidy 45.76%; 502 Guaranteed at 90% guarantee; B&I Guaranteed FY24 blended subsidy 2.38%; IRP 30.35%; Water & Waste Disposal Direct 8.35%) and OBP must produce portfolio-level risk reporting for the Acting Under Secretary, OMB, and the AFR — but cross-program risk aggregation today is largely manual.

Why It Matters

Portfolio-level risk reporting is the strategic-management lens through which RD leadership and OMB allocate scarce capital and policy attention. Weak portfolio risk reporting drives suboptimal program-mix decisions and erodes RD's standing on the OMB exam side.

HSG's Approach

  • 1Build a portfolio-risk reporting framework that aggregates each program's subsidy rate, default rate, prepayment rate, recovery rate, financing-account interest, and cohort heat map into a single management view.
  • 2Apply HSG's capital-markets-grade analytics from the Ginnie Mae / FHA / HUD bench — vintage analysis, scenario stress tests, default / prepay / recovery curves — to RD's portfolio.
  • 3Stand up a quarterly portfolio risk review with senior leadership and the three program-agency Administrators.
  • 4Maintain a portfolio risk dashboard tied to BICS / Essbase / CSC outputs with drill-down to program and cohort level.
  • 5Document Treasury USSGL Credit Reform Guidance, OMB A-129, and OMB A-11 §185 traceability throughout.

Expected Deliverables

  • Portfolio-risk reporting framework document
  • Quarterly portfolio risk dashboard
  • Vintage analysis and scenario-stress-test workbooks
  • Quarterly portfolio risk review charter
  • Documented traceability to A-11 §185, A-129, and USSGL Credit Reform Guidance

Expected Outcome

Equip RD leadership with a portfolio-risk lens that supports strategic capital and policy allocation, with quarterly cadence and full audit-ready data lineage.