This dataset includes 1 table containing debt collection information of partners by month in 2020 and 2021.
Know the debt collection situation in general and each partner's as well as their strengths: Amount of debt collected, success rate of debt collection by month, by year, by product
Apply 5 steps of Design Thinking
Overview:
- 44% of debts in group 1080+; 27% belongs to 720 - 1080 debt group and 22% is bad debt
- SP credit card has the highest payout ratio (0.17%) and overdraft (0.10%)
- Secured Loan product has the lowest payment ratio (0.02%) and has the third highest outstanding balance, worth 41T. NDC company ranks TOP 1 in terms of debt recovery for this product, debt recovery rate = 0.03%. In December 2020, this product has the best debt recovery, %payment = 0.06%. In October 2020, NDC company collected many debt payments for this product worth more than 950 million, in December 2020, FBI company obtained many debt payments for this product worth more than 1.1 billion
- Unsecured Loan product has the highest outstanding balance among products (accounting for nearly 50%, worth 136T), the average debt recovery rate is 0.07%, well recovered by GLX, HMK, and ASA
- Debt recovery rates in 2021 of GLX, HNA, DK and AMG companies tend to increase compared to 2020
- FBI company has a fairly low average debt recovery rate = 0.03%, the main product is HHB. In December 2020, the FBI ranked first in bad debt collection, worth more than 1.2 billion
TOP 1 Partner: NDC Company
- 1st in balance 45T billion
- Average debt recovery rate: 0.09%
- From October 2020 (0.15%, up 0.06% compared to September 2020), NDC has had a breakthrough in the ratio of payment to total outstanding loans.
- As a result, from March to May 2021, NDC company ranked first in terms of the amount recovered, nearly 5.5 billion (March 2021).
- Products that this company can collect well are Other (0.32%) and Credit card (0.26%)
- Able to recover bad debts, continuously ranked in TOP in bad debt recovery in October 2020 (nearly 1.3 billion), April 2020 (> 640 million) and 3/2021 (> 370 million)
TOP 2 Partner: ASA Company
- Average debt recovery rate: 0.11%
- ASA has an unstable debt collection rate compared to the same period last year:
- January and 2: The debt collection rate of 2021 is much lower than 2020, specifically January 2020 = 0.2%, January 2021 = 0.14%; February 2020 = 0.28%, February 2021 = 0.06%
- March, April, and May: The debt recovery rate of 2021 is higher than that of 2020, specifically, the rate of 2021/2020 of the months of March, April, and May is 0.17%/0.15%, respectively; 0.12%/0.08% ; 0.11%/0.06%
- The strength of this company is the Overdraft product, with a payment/debt ratio of 0.26%
TOP 3 Partner: GLX Company
- Average debt recovery rate: 0.11%
- GLX has a sharp decrease in debt recovery rate in 2021 compared to 2020
- Strength SP is Overdraft and HHB
- Allocation of debt portfolio according to the strengths of each company:
- NDC: Other, Credit Card, Secured Loan
- ASA: Overdraft, Unsecure Loan
- GLX: Overdraft, HHB, Unsecured Loan
- FBI: HHB, Secured Loan
- Implement ranking policy: allocate better portfolio to partners with good recovery rate