0% found this document useful (0 votes)
34 views4 pages

EDA for Loan Default Risk Analysis

Uploaded by

kiran
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
34 views4 pages

EDA for Loan Default Risk Analysis

Uploaded by

kiran
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

0

upGrad & IIITB |


Data Science Learn Live Jobs Discussions
Program -
August 2023
Navigate Q&A

Problem Statement - I

Introduction
This assignment aims to give you an idea of applying EDA in a real business scenario. In

this assignment, apart from applying the techniques that you have learnt in the EDA

module, you will also develop a basic understanding of risk analytics in banking and

financial services and understand how data is used to minimise the risk of losing money

while lending to customers.

Business Understanding
The loan providing companies find it hard to give loans to the people due to their
insufficient or non-existent credit history. Because of that, some consumers use it to
their advantage by becoming a defaulter. Suppose you work for a consumer finance

company which specialises in lending various types of loans to urban customers. You
have to use EDA to analyse the patterns present in the data. This will ensure that the

applicants capable of repaying the loan are not rejected.

When the company receives a loan application, the company has to decide for loan
approval based on the applicant’s profile. Two types of risks are associated with the

bank’s decision:
If the applicant is likely to repay the loan, then not approving the loan results in a loss of

business
upGrad &to the| company
IIITB
Learn Live Jobs Discussions
Data Science
Program -
If the applicant
August 2023
is not likely to repay the loan, i.e. he/she is likely to default, then

approving the loan may lead to a financial loss for the company.

The data given below contains the information about the loan application at the time of
applying for the loan. It contains two types of scenarios:

The client with payment difficulties: he/she had late payment more than X days on at
least one of the first Y instalments of the loan in our sample,
All other cases: All other cases when the payment is paid on time.

When a client applies for a loan, there are four types of decisions that could be taken by

the client/company):
Approved: The Company has approved loan Application

Cancelled: The client cancelled the application sometime during approval. Either the

client changed her/his mind about the loan or in some cases due to a higher risk of the

client, he received worse pricing which he did not want.


Refused: The company had rejected the loan (because the client does not meet their

requirements etc.).

Unused offer: Loan has been cancelled by the client but at different stages of the

process.
In this case study, you will use EDA to understand how consumer attributes and loan

attributes influence the tendency to default.

Business Objectives
This case study aims to identify patterns which indicate if a client has difficulty paying

their instalments which may be used for taking actions such as denying the loan,

reducing the amount of loan, lending (to risky applicants) at a higher interest rate, etc.
This will ensure that the consumers capable of repaying the loan are not rejected.
Identification
upGrad & IIITB |of such applicants using EDA is the aim of this case study.
Learn Live Jobs Discussions
Data Science
Program -
August 2023

In other words, the company wants to understand the driving factors (or driver

variables) behind loan default, i.e. the variables which are strong indicators of default.
The company can utilise this knowledge for its portfolio and risk assessment.

To develop your understanding of the domain, you are advised to independently research

a little about risk analytics - understanding the types of variables and their significance

should be enough.

Data Understanding
Download the dataset from below.

Dataset Download

This dataset has 3 files as explained below:

1. 'application_data.csv' contains all the information of the client at the time of

application.

The data is about whether a client has payment difficulties.

2. 'previous_application.csv' contains information about the client’s previous loan data. It

contains the data on whether the previous application had been Approved, Cancelled,

Refused or Unused offer.

3. 'columns_description.csv' is data dictionary which describes the meaning of the variables.


Report an error

upGrad & IIITB |


Data Science
Learn
PREVIOUS Live Jobs Discussions
Program - NEXT
August 2023
Course 1 - Honesty
Problem Statement - II
Pledge

Common questions

Powered by AI

A company can leverage insights from EDA by identifying patterns and risk factors associated with loan defaults, allowing them to make more informed lending decisions. Based on these insights, the company can implement strategies such as denying loans to high-risk applicants, adjusting loan amounts, or setting higher interest rates for risky profiles. This proactive approach minimizes potential defaults and financial losses by tailoring loan products and underwriting criteria based on data-driven insights .

Identifying clients with payment difficulties during initial loan applications is crucial as it prevents financial losses due to defaults. If such clients are overlooked, the company may inadvertently approve loans to high-risk individuals, resulting in defaults that lead to significant financial strain and loss of revenue. Conversely, accurately identifying and either denying or adjusting loan terms for these clients helps in maintaining a healthy loan portfolio and financial stability .

EDA can be utilized to ensure consumers capable of repaying loans are not unjustly denied by analyzing data to distinguish between low and high-risk applicants accurately. Through detailed examination of applicant profiles and patterns in the data, EDA can highlight positive indications of repayment capability, allowing the company to approve loans for good customers who might otherwise have been rejected based on inadequate traditional assessments .

EDA helps in identifying patterns and variables that are indicators of a potential loan default. By analyzing consumer attributes and loan attributes, EDA can highlight characteristics or behaviors that are common in clients who default on loans. This allows companies to make informed decisions, such as denying loans to risky applicants, reducing loan amounts, or offering loans at higher interest rates .

Companies face significant challenges when lending to individuals with insufficient credit histories due to the lack of predictive information on their ability to repay loans, making it harder to assess risk and avoid losses. Data-driven approaches, such as EDA, allow companies to identify other predictive factors or patterns in consumer behavior and loan characteristics that can act as surrogates for credit history, enabling more accurate risk assessment and decision-making .

Credit history significantly aids in assessing a potential borrower's reliability in repaying loans. A solid credit history generally leads to approval, while an insufficient or non-existent history may result in denial. Some consumers exploit the absence of credit history by obtaining loans while intending to default, as lenders may not have enough information to accurately assess their creditworthiness, causing potential financial risks .

The four types of decisions a loan application might go through include: Approved, where the company agrees to provide the loan; Cancelled, where the client cancels the application during approval due to changing their mind or receiving unfavorable terms; Refused, where the company rejects the application, often because the client does not meet requirements; and Unused offer, where the loan is canceled by the client at some stage of the process .

There are two types of risks associated with a bank's decision regarding a loan application. First, if an applicant is likely to repay the loan but the company denies the application, the business loses potential revenue. Second, if an applicant is likely to default and the company approves the loan, it may lead to a financial loss. These risks can severely affect the company's financial standing, either through lost business opportunities or through losses incurred from defaults .

The case study utilizes three datasets: 'application_data.csv', which contains client information at the time of application, particularly on whether they have payment difficulties; 'previous_application.csv', which details the client's previous loan data including application outcomes such as Approved, Cancelled, Refused, or Unused Offer; and 'columns_description.csv', serving as a data dictionary that explains the meaning of variables in the datasets. These datasets collectively provide comprehensive insights into loan applications and defaults .

Understanding 'driver variables' behind loan defaults is crucial because they serve as strong indicators or predictors of default risk. Identifying these variables allows finance companies to refine their risk assessment strategies by focusing on key factors that signal higher likelihood of default. This, in turn, helps in portfolio management and in making informed decisions on whether to approve or deny loans, set loan amounts, and determine appropriate interest rates .

You might also like