LOANLENS · v1.0

Portfolio Risk
Console

A live regulatory-reporting view of 128,412 Lending Club loans · auto-refreshed 2026-06-04 18:18

Ingest
CSV → SQLite
Transform
SQL queries
Automate
Python + cron
Export
Excel report
Dashboard
This page
Total accounts
0
loans in portfolio
Total exposure
$0M
outstanding principal
NPA ratio
0%
non-performing exposure
Avg default rate
0%
across loan types

Portfolio Overview

Risk summary by loan type

loan_type total_accounts defaulted_accounts default_rate_pct total_exposure_mn npa_exposure_mn npa_ratio_pct avg_customer_income
Long Term Loan 40233 7124 17.71 879.93 156.41 17.78 87972.00
Short Term Loan 88179 10034 11.38 1170.98 139.46 11.91 80436.00

Risk Segment Deep Dive

Risk band breakdown

risk_band customer_count actual_default_rate exposure_mn avg_loan_size avg_interest_rate
High Risk 6450 27.60 91.55 14193.00 25.50
Medium Risk 48090 18.65 762.95 15865.00 16.73
Low Risk 73872 8.68 1196.41 16196.00 9.35