Bank Loan Performance & Risk Analysis Dashboard | Excel

Analyzed 38,576 loan applications totaling $435M+ to evaluate lending performance

and portfolio risk.

• Developed key financial KPIs including total funded amount, average interest rate

(12.05%), and average debt-to-income ratio (13.33%).

• Assessed loan status distribution (Charged Off, Current, Fully Paid) to measure credit

risk exposure.

• Built interactive dashboard using Pivot Tables and slicers to enable dynamic filtering

and reporting.

• Evaluated monthly trends and loan purposes to identify growth patterns and highvolume lending categories.