Scoring Model v1.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	X	Y	AB	AC	AD	AE	AF
1
2					GRADE						Bureau : A GST + Invoice : A Banking : A Others : A	Bureau : B GST + Invoice : A Banking : B Others : A	Bureau : A GST + Invoice : B Banking : A Others : B	Bureau : B GST + Invoice : B Banking : B Others : B	Bureau : B GST + Invoice : C Banking : B Others : C	Bureau : C GST + Invoice : B Banking : C Others : B	Bureau : A GST + Invoice : C Banking : A Others : C	Bureau : C GST + Invoice : A Banking : C Others : A	Bureau : C GST + Invoice : C Banking : C Others : C	Bureau : A GST + Invoice : D Banking : A Others : D	NTC Borrower	Grade
3					D	C	B	A
4	Data Source	Parameters	CutOff criterias for Reject / LTV Restriction	Response for Criteria	100	200	400	800	Weightage														Criteria	CIBIL Range	Probability of default
5	Bureau Data	Score	< 670 except 0,-1	Reject	670-700	701-730	730-790, 0, -1	790 +	13.00%		104	52	104	52	52	26	104	26	26	104	52	B	Bureau Score	790+	1.40%
6		Unsecured Credit enquiries in last 90 days (excluding Invoice Financing / WC enquiries)	10 or More	Reject	>=10 - 8	7 - <=5	>=4 - 3	<=2	5.00%		40	20	40	20	20	10	40	10	10	40	40	A	Bureau Score	730-790, 0, -1	3.60%
7		Aggregate DPD instances across all open loans in last 6 months	6 or More instances	Reject	More than 2	2	1	0	10.00%		80	40	80	40	40	20	80	20	20	80	80	A	Bureau Score	701-730	6.66%
8		Unsecured No. of Loans disbursed in last 3 months (excluding Invoice Financing / WC loans)	4 or More new unsecured loans disbursed	Reject	More than 2	2	1	0	5.00%		40	20	40	20	20	10	40	10	10	40	40	A	Bureau Score	670-700	10.00%
9		Credit history (1st loan taken and reported in bureau)	No Loan history	Restrict LTV to 75%	Less than 6m	6m-2yr	2-5yr, Score 0,-1	>5yr	3.00%		24	12	24	12	12	6	24	6	6	24	12	B
10	Invoice Data + GST Data	Buyers value contribution in past as per GST Data (Last 12 month)	Nil	Restrict LTV to 50%	Less than 50%	Top 50% - Top 20%	Top 20% - Top10%	Top 10%	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	Lender offer recommendation summary :
11	Invoice Data + GST Data	No of past Invoices on same buyer as per GST Data (Last 12 month)	First timer	Restrict LTV to 50%	First Timer / Non significant	Top 50% - Top 20%	Top 20% - Top10%	Top 10%	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	SAHAY Score Range	Interest Rate p.a.	LTV on invoice value	Probability Of Default (PD)	Max Tenure upto
12	Invoice Data + GST Data	Buyer's Compliance Score of GST filing (GRC Score)	GRC Score less than 50%	Restrict LTV to 50%	<70%	70%-80%	80%-90%	>90%	5.00%		40	40	20	20	10	20	10	40	10	5	20	B	741-800	3M MCLR + 150 bps	90%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
13	Invoice Data + GST Data	Borrowers relationship with proposed Buyer as per GST Data (Last 12 month)	First timer	Restrict LTV to 50%	<6m	>6m - 1yr	>1 - 2yr	> 2yr	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	681-740	3M MCLR + 175 bps	90%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
14	Invoice Data + GST Data	Proposed Buyers concentration (No of buyers) as per GST Data (Last 12 month)	Single Buyer	Restrict LTV to 50%	<=3	>3 <=5	6 - <=10	>10	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	621-680	3M MCLR + 200 bps	85%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
15	Invoice Data + GST Data	Suppliers of Borrower : Aggregate Compliance Score of GST filing (GRC Score)	None		<70%	70%-80%	80%-90%	>90%	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	561-620	3M MCLR + 225 bps	85%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
16	Invoice Data + GST Data	Proposed Invoice Value to Past 12 month Avg Invoice value of same Buyer	More than 60% variance	Restrict LTV to 50%	More than 50%	30% -50% variance	20%-30% variance	Less than 20% variance	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	501-560	3M MCLR + 250 bps	80%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
17	Invoice Data	Credit period offered	More than 180 days	Reject	More than 120 days	90-120 days	60-90 days	Upto 60 days	4.00%		32	32	16	16	8	16	8	32	8	4	16	B	441-500	3M MCLR + 275 bps	80%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
18	Invoice Data + GST Data	HSN Code of Invoice Item : HSN code of last 12M invoices of same buyer	No Match	Restrict LTV to 50%	Less than 20%	20%-50%	50%-75%	Amongst more than 75% of past invoice value	3.00%		24	24	12	12	6	12	6	24	6	3	12	B	381-440	3M MCLR + 300 bps	75%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
19	Bank Statement Data	Sum Total of Bank credits of last 12m / GST Turnover last 12m	Below 50%	Reject	Less than 60%	60-75%	70-85%	>85%	8.00%		64	32	64	32	32	16	64	16	16	64	64	B	321-380	3M MCLR + 325 bps	75%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
20	Bank Statement Data	Cheque / ECS / NACH returns (Funds Insufficient/Exceed arrangement) in last 12m	More than 18 returns	Reject	>10x	>6 <=10	>3 <=6	0-3	8.00%		64	32	64	32	32	16	64	16	16	64	64	B	< 320	3M MCLR + 350 bps	70%	borrower bureau score = XX, then PD = As per table above	Invoice date + Credit period as per invoice + 15 days)
21	Bank Statement Data	Invoice amount / Daily Average balance	<20x	Reject	>10x	>3x - 10x	>1x-3x	>1x	8.00%		64	32	64	32	32	16	64	16	16	64	64	B
22	Borrower Data + GST Data	Borrower GST Compliance score (GRC score)	Less than 70	Restrict LTV to 50%	<70%	70%-80%	80%-90%	>90%	5.00%		40	40	20	20	10	20	10	40	10	5	20	B	Notes / References :
23	Borrower Data + GST Data	Business vintage : GST registration date	Less than 6 months	Restrict LTV to 50%	> 6m & < 12m	1-2yr	2-3yr	>3yr	5.00%		40	40	20	20	10	20	10	40	10	5	20	B	PD reference from CIBIL, Experian, Equifax & CRIF
24									100.00%		800	560	640	400	320	280	560	440	200	520	576		BBB rated invoices currently discounted on M1 Exchange @9.64%
25																							Banks invoice financing pricing grid ranges from 3M MCLR + premium (1.50%-3.00%)
26																					Pricing	3M MCLR + 225 bps	Reference 3 Month MCLR - SBI 6.65%, BOB 7.10%, HDFC Bank 6.95%, ICICI 7.10%
27																					LTV	75%	Normal LTV range is 75% - 90% of the Invoice value across Banks/NBFC's/Platforms
28																					PD	3.60%	NTC client LTV restricted to 75% on first / initial transactions, till bureau history is created. Post that program LTV gets applied.
29																							After moving out of NTC band, borrower moves to normal rating / grading grid.
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55									New to Credit - Decision tree
56									Bureau Score	PD
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100