Financial Dataset.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Loan_ID	Issue_Date	Repayment_Period(Months)	Loan_Amount	Interest_Rate (%)	Annual_Income	Debt_to_Income_Ratio (%)	Employment_Length (Years)	Home_Ownership	Loan_Purpose	Credit_Score	Loan_Grade	Loan_Status
2	L00001	4/7/2019	36	2632	13.57	102164	23.63	16	Own	Home Improvement	798	A	Fully Paid
3	L00002	9/11/2020	36	27324	23.11	63016	22.55	15	Own	Home Improvement	630	D	Charged Off
4	L00003	4/8/2020	36	14194	22.1	56900	28.17	5	Mortgage	Business	615	D	Charged Off
5	L00004	17/5/2020	60	28551	9.21	146868	24.97	12	Rent	Car	729	B	Fully Paid
6	L00005	27/6/2018	60	22671	17.75	72806	8.98	19	Own	Debt Consolidation	702	B	Fully Paid
7	L00006	1/3/2021	36	34930	16.36	110387	15.47	17	Own	Medical	706	B	Fully Paid
8	L00007	3/11/2019	48	10971	22.21	37425	8.13	2	Rent	Debt Consolidation	683	C	Fully Paid
9	L00008	29/1/2020	60	15440	14.79	123604	16.8	19	Mortgage	Home Improvement	633	D	Fully Paid
10	L00009	9/10/2022	60	24806	21.36	124411	14.99	2	Own	Education	799	A	Fully Paid
11	L00010	27/12/2022	60	6771	24.14	32444	6.06	6	Rent	Business	634	D	Fully Paid
12	L00011	17/3/2023	60	23311	22.95	86345	39.11	9	Mortgage	Debt Consolidation	611	D	Default
13	L00012	26/1/2020	60	24067	11.34	89550	28.59	2	Own	Car	562	E	Default
14	L00013	19/1/2020	60	11176	24.22	98449	19.08	11	Own	Medical	634	D	Charged Off
15	L00014	1/2/2023	48	8660	8.56	56235	19.67	6	Rent	Education	589	E	Default
16	L00015	6/11/2020	48	36240	17.58	108232	14.56	2	Own	Medical	797	A	Fully Paid
17	L00016	3/1/2023	36	20137	17.91	27373	23.95	18	Own	Education	625	D	Charged Off
18	L00017	29/9/2018	60	38799	22.52	43942	39.16	0	Mortgage	Medical	725	B	Fully Paid
19	L00018	3/11/2022	60	24826	9.22	61183	21.63	17	Rent	Car	742	B	Fully Paid
20	L00019	9/9/2020	60	15420	8.56	145535	15.96	16	Rent	Education	785	A	Fully Paid
21	L00020	26/5/2018	60	21704	5.27	35895	13.07	6	Mortgage	Home Improvement	669	C	Fully Paid
22	L00021	12/5/2019	60	3536	19.2	91964	7.03	14	Rent	Education	654	C	Fully Paid
23	L00022	26/6/2022	36	17889	19.32	90985	10.39	7	Own	Debt Consolidation	769	A	Fully Paid
24	L00023	27/6/2023	36	14846	22.29	55178	30.06	0	Mortgage	Car	747	B	Fully Paid
25	L00024	2/12/2022	48	31082	23.37	28700	8.95	12	Mortgage	Medical	668	C	Fully Paid
26	L00025	15/3/2018	36	22094	18.7	130187	29.01	7	Own	Car	559	E	Default
27	L00026	1/8/2018	60	36710	22.44	149115	11.02	4	Rent	Education	597	E	Charged Off
28	L00027	9/12/2021	60	31738	7.87	143961	32.62	16	Mortgage	Car	751	A	Fully Paid
29	L00028	13/5/2021	60	23765	21.79	82943	6.29	7	Own	Business	671	C	Fully Paid
30	L00029	19/7/2018	36	33188	20.97	130814	15.96	7	Own	Education	570	E	Default
31	L00030	3/1/2023	60	4253	23.54	115834	7.56	5	Rent	Debt Consolidation	758	A	Fully Paid
32	L00031	1/10/2021	36	6840	12.38	45273	39.88	14	Own	Home Improvement	551	E	Default
33	L00032	17/2/2020	36	26425	7.23	149087	19.35	6	Own	Car	591	E	Default
34	L00033	16/1/2019	36	17425	24.82	71995	10.61	18	Rent	Home Improvement	656	C	Fully Paid
35	L00034	29/1/2023	48	34594	5.18	51648	12.74	14	Own	Debt Consolidation	663	C	Fully Paid
36	L00035	21/2/2018	48	24962	8.01	111081	34.79	1	Rent	Debt Consolidation	633	D	Charged Off
37	L00036	5/10/2019	36	14572	23.32	101222	25.59	19	Mortgage	Debt Consolidation	724	B	Fully Paid
38	L00037	6/5/2022	36	10148	6.79	81850	32.73	0	Mortgage	Business	667	C	Fully Paid
39	L00038	23/5/2018	36	29197	6.45	138284	14.4	8	Rent	Business	736	B	Fully Paid
40	L00039	19/6/2019	60	27641	15.35	32297	13.11	3	Mortgage	Home Improvement	698	C	Fully Paid
41	L00040	8/5/2023	60	32876	11.45	58990	5.66	3	Own	Business	657	C	Fully Paid
42	L00041	12/3/2022	48	3880	12.87	127414	16.91	14	Rent	Debt Consolidation	754	A	Fully Paid
43	L00042	24/7/2019	36	17920	15.09	34904	8.9	14	Own	Car	572	E	Default
44	L00043	24/7/2020	36	31055	20.8	89874	24.2	9	Mortgage	Business	719	B	Fully Paid
45	L00044	17/11/2018	60	3552	6.26	74630	21.39	14	Mortgage	Home Improvement	753	A	Fully Paid
46	L00045	7/6/2019	60	37152	21.17	40457	12.85	14	Mortgage	Home Improvement	713	B	Fully Paid
47	L00046	25/3/2019	36	16199	19.46	77026	25.95	7	Rent	Car	749	B	Fully Paid
48	L00047	27/9/2023	60	10352	8.52	98374	15.36	9	Rent	Education	762	A	Fully Paid
49	L00048	29/1/2020	48	34330	21.94	129992	35.73	8	Rent	Debt Consolidation	576	E	Default
50	L00049	23/3/2018	36	15951	5.46	33165	34.97	1	Mortgage	Education	628	D	Charged Off
51	L00050	1/10/2018	60	34685	9.36	149292	15.21	12	Rent	Education	712	B	Fully Paid
52	L00051	19/3/2020	48	29650	18.89	43945	25.1	5	Mortgage	Medical	646	D	Fully Paid
53	L00052	24/1/2021	48	33358	15.47	123189	38.37	20	Own	Debt Consolidation	560	E	Default
54	L00053	11/6/2020	60	2706	12.03	46392	26.49	6	Mortgage	Business	798	A	Fully Paid
55	L00054	16/5/2020	60	28451	24.47	53646	20.45	20	Own	Home Improvement	710	B	Fully Paid
56	L00055	3/10/2019	36	31308	18.75	124937	37.47	16	Own	Car	780	A	Fully Paid
57	L00056	5/3/2020	48	21754	24.28	62306	5.14	1	Rent	Car	790	A	Fully Paid
58	L00057	5/1/2022	60	19651	17.08	90946	16.93	11	Own	Home Improvement	641	D	Fully Paid
59	L00058	22/8/2021	60	21983	12.3	109733	17.26	2	Own	Business	696	C	Fully Paid
60	L00059	10/1/2023	48	9427	21.57	52753	38.7	19	Rent	Home Improvement	789	A	Fully Paid
61	L00060	22/5/2019	60	10701	17.2	35417	30.98	14	Own	Car	630	D	Charged Off
62	L00061	25/12/2019	36	37950	7.4	71371	14.87	10	Mortgage	Car	724	B	Fully Paid
63	L00062	5/11/2023	36	8655	6.9	74911	11.26	12	Mortgage	Medical	600	D	Charged Off
64	L00063	12/11/2018	36	17758	15.27	131566	29.86	18	Rent	Car	740	B	Fully Paid
65	L00064	26/1/2023	36	36050	16.23	69458	15.79	8	Rent	Debt Consolidation	659	C	Fully Paid
66	L00065	24/1/2021	48	35850	12.58	37751	38.51	3	Mortgage	Education	762	A	Fully Paid
67	L00066	31/10/2019	36	23169	5.91	57719	29.76	15	Rent	Debt Consolidation	781	A	Fully Paid
68	L00067	8/1/2020	60	34034	13.71	43805	16.81	18	Rent	Medical	678	C	Fully Paid
69	L00068	16/5/2019	60	9926	19.06	126700	17.04	4	Mortgage	Home Improvement	553	E	Default
70	L00069	18/2/2021	60	27133	11.69	104599	30.08	8	Mortgage	Medical	790	A	Fully Paid
71	L00070	9/10/2019	60	9887	19.51	49916	11.06	10	Own	Medical	787	A	Fully Paid
72	L00071	21/4/2022	36	14233	6.29	140004	14.84	19	Own	Education	569	E	Default
73	L00072	7/9/2020	36	22655	12.1	44939	21.56	2	Own	Home Improvement	717	B	Fully Paid
74	L00073	7/7/2020	36	15701	5.76	31264	19.01	13	Own	Car	550	E	Default
75	L00074	1/10/2019	48	26105	13.89	79179	6	9	Own	Medical	554	E	Default
76	L00075	13/11/2020	48	24663	10.14	88554	29.9	15	Mortgage	Medical	682	C	Fully Paid
77	L00076	9/7/2023	36	6653	18.57	102879	5.85	17	Rent	Education	778	A	Fully Paid
78	L00077	1/12/2023	48	32539	24.76	51004	17.21	3	Rent	Medical	596	E	Charged Off
79	L00078	4/5/2023	60	23684	24.43	74406	11.07	5	Rent	Medical	596	E	Charged Off
80	L00079	27/4/2018	60	22318	8.38	58473	36.59	8	Rent	Medical	679	C	Fully Paid
81	L00080	31/12/2020	36	24294	21.38	130675	18.65	15	Own	Car	767	A	Fully Paid
82	L00081	1/4/2023	60	14089	16.65	53292	28.54	13	Mortgage	Home Improvement	560	E	Default
83	L00082	28/2/2019	60	18296	15.91	136029	37.35	0	Rent	Business	574	E	Default
84	L00083	3/12/2019	48	6794	20.89	26424	38.08	17	Own	Business	674	C	Fully Paid
85	L00084	3/6/2023	36	16052	10.59	125166	7.08	6	Mortgage	Car	620	D	Charged Off
86	L00085	9/2/2021	60	2569	14.39	92195	32.93	14	Mortgage	Debt Consolidation	601	D	Default
87	L00086	3/10/2020	60	18814	23.93	74037	36.71	3	Own	Home Improvement	743	B	Fully Paid
88	L00087	28/10/2023	48	1231	9.7	51335	35.08	0	Mortgage	Home Improvement	675	C	Fully Paid
89	L00088	8/4/2023	36	28859	15.59	60977	18.88	14	Own	Business	688	C	Fully Paid
90	L00089	20/10/2022	48	8225	5.92	113589	17.46	0	Own	Debt Consolidation	552	E	Default
91	L00090	19/4/2023	60	6094	14.44	148462	25.21	16	Own	Home Improvement	720	B	Fully Paid
92	L00091	26/2/2020	36	18354	14.76	40498	8.79	18	Rent	Education	592	E	Charged Off
93	L00092	13/4/2019	60	30878	20.67	107878	25.6	3	Mortgage	Home Improvement	707	B	Fully Paid
94	L00093	20/12/2020	36	15562	17.14	50098	13.26	0	Own	Debt Consolidation	775	A	Fully Paid
95	L00094	6/6/2020	48	9793	19.95	36925	14.46	18	Mortgage	Car	756	A	Fully Paid
96	L00095	14/5/2021	60	1530	19.41	56638	10.15	0	Own	Education	772	A	Fully Paid
97	L00096	22/10/2023	60	5518	17.26	82668	16.47	3	Own	Medical	799	A	Fully Paid
98	L00097	13/4/2023	60	36995	24.02	54927	14.68	1	Own	Business	579	E	Default
99	L00098	14/6/2023	48	1377	12.53	40571	39.25	1	Rent	Medical	582	E	Default
100	L00099	3/4/2019	48	12937	8.53	82478	28.81	0	Rent	Debt Consolidation	697	C	Fully Paid