Financial Analytics Case Study for Lending Portfolio Performance

Customer Background

A $1B+ bank with a large indirect consumer portfolio needed a consolidated view of lending performance across originations, risk segments, and vendor channels. Rising delinquencies and charge-offs had driven annual consumer loan losses above $8M, significantly compressing margins and ROA.

Objectives

The engagement focused on implementing a Lending Performance Management framework that would: (1) quantify portfolio profitability by credit tier using a robust IRR-based model, (2) validate that scorecards and risk models were correctly ranking loss risk, (3) deploy static pool analysis for vintages, vendors, and collateral segments, and (4) support best-practice scorecards and dashboards for executives and examiners.

Approach

• Profitability Review & IRR Modeling - Built a portfolio profitability model incorporating origination volumes, weighted yields, life-of-loan loss curves, repayment curves, fee income, and funding costs, with IRR and NPV comparison against alternative investments.
• Static Pool Performance Analytics - Implemented static pool loss and repayment analysis by origination month, year, credit tier, collateral type, vendor, and member type to identify deteriorating vintages and high-risk segments early.
• Risk Ranking Validation - Used static pool loss experience stratified by score tier to confirm that FICO and pooled risk models were correctly ranking loss risk and to pinpoint anomalies for underwriting and pricing adjustments.
• Vendor & Channel Scorecards - Deployed vendor management reports and market- intelligence scorecards to compare vendor performance and benchmark the portfolio against peer lenders.

Outcomes

• Reduced annual comsumer loan losses from over $8M to approximately $1M while maintaining competitive indirect volumes and portfolio growth.
• Validated and fine-tuned risk-based pricing so that each credit tier covered expected losses and costs, improving risk-adjusted ROA across nine of ten tiers.
• Demonstrated to regulators that scorecards and risk models were appropriately ranking risk, supported by static-pool-based risk-ranking validation reports.
• Established a best-practices reporting program with monthly, quarterly, and annual scorecards for originations, performance, static pools, and vendor quality, enabling proactive portfolio steering rather than reactive policy changes.

Related Services:

• Business Data Intelligence - Portfolio analytics, profitability modeling, and risk scorecard validation.
• Data Engineering Services - Lending data warehouse design, static pool modeling, and ETL pipelines.