Bank Loan Analytics

Comprehensive financial analysis and risk assessment dashboard

Bank Data • Updated Dec 2021

Primary KPIs

Total Applications
38,576

+12.5% from last month

MTD Applications
4,314

+8.2% from last MTD

Total Funded Amount
$435.79M

+15.3% growth

MTD Funded Amount
$53.98M

+9.7% from last MTD

Total Amount Received
$473.07M

+11.8% growth

MTD Amount Received
$58.07M

+7.4% from last MTD

Average Interest Rate
12.05%

+0.3% from last month

Average DTI Ratio
13.33%

-0.5% improvement

Loan Performance Metrics

Good Loan Performance

Good Loan Applications
33,243
Funded Amount
$370.22M
Total Received
$435.79M
Percentage of Applications
86.18%

Bad Loan Performance

Bad Loan Applications
5,333
Funded Amount
$65.53M
Total Received
$37.28M
Percentage of Applications
13.82%

Analytics Overview

Monthly Funding Trends

Track loan funding performance over time

Monthly Trends in Loan Funded Amount showing growth from Jan 2021 to Nov 2021
Loan Term Distribution

Breakdown of loan applications by term length

Loan Applications by Term Length showing 73.2% for 36 months and 26.8% for 60 months
Home Ownership Impact

Loan funding distribution by home ownership status

Loan Funded Amount by Home Ownership showing distribution between Mortgage, Rent, and Own
Geographic Distribution

Loan funding amounts across different states

Loan Funded Amount by State showing funding distribution across US states
Employment Length Impact

Relationship between employment history and loan funding

Loan Funded Amount by Employment Length showing funding patterns across different employment durations

Code Analysis

Python Analysis Code

View the complete Python code used to generate these analytics

Python • Collab Notebook

Complete analysis workflow including data processing, KPI calculations, and visualizations

Analysis Features:
  • • Data loading and preprocessing with pandas
  • • Primary KPI calculations (applications, funding, interest rates)
  • • Good vs Bad loan analysis and risk assessment
  • • Interactive visualizations with Plotly Express
  • • Monthly trends, geographic, and demographic analysis

© 2021 Bank Loan Analytics Dashboard.

Build and Analyse by Vishal Kumar