ADITYA TYAGI
Python Project
Bank Loan
Analysis
Report
Swipe Left
01
ADITYA TYAGI
Import Libraries
Import File Data
Swipe Left
02
ADITYA TYAGI
Upper Data
Output Data
Swipe Left
03
ADITYA TYAGI
Lower Data
Output Data
Swipe Left
04
ADITYA TYAGI
Metadata of Data
[Link]
Swipe Left
05
ADITYA TYAGI
Data Types
Total Loan Application
Swipe Left
06
ADITYA TYAGI
MTD Total Loan Applications
1 We need to calculate the total number of loan applications received during a specified
period. Additionally, it is essential to monitor the Month-to-Date (MTD) Loan Applications
Swipe Left
07
ADITYA TYAGI
Total Funded Amount
2 Understanding the total amount of funds disbursed as loans is crucial. We also want to
keep an eye on the MTD Total Funded Amount metric.
MTD - Total Funded Amount
Swipe Left
08
ADITYA TYAGI
${:.2f}M
Total Amount Received
Tracking the total amount received from borrowers is essential for assessing the bank's
cash flow and loan repayment. We should analyse the Month-to-Date (MTD) Total
Amount Receive.
Swipe Left
09
ADITYA TYAGI
${:.2f}M
Total Amount Received
Tracking the total amount received from borrowers is essential for assessing the bank's
cash flow and loan repayment. We should analyse the Month-to-Date (MTD) Total
Amount Receive.
Swipe Left
10
ADITYA TYAGI
MTD Total Amount Received
Average Interest Rate:
Calculating the average interest rate across all loans which will provide insights into our
lending portfolio's overall cost.
Swipe Left
11
ADITYA TYAGI
Average Debt-to-Income Ratio (DTI):
#Evaluating the average DTI for our borrowers helps us gauge their financial health. We
need to compute the average DTI for all loans.
Good loan metrices
Swipe Left
12
ADITYA TYAGI
Bad loan metrices
Swipe Left
13
Follow for
More If , It’s
Helpful