Applied case · Banking · about 75 minutes
Default rates in a loan book
Estimate default rates with honest intervals, compare segments, fit a logistic regression and interpret odds ratios — and keep risk prediction separate from causal claims.
The brief
Wahat Lending (a fictional consumer-finance company) approved 3,000 personal loans in 2023 and tracked each one for 24 months. 12.9% defaulted (90+ days past due). The credit committee is reviewing its approval policy and has asked the risk analytics team for:
- the book's default rate with a confidence interval, and default rates by credit-score band and loan purpose;
- a simple model of default risk that the committee can read (which factors matter, and how much);
- a view on a proposed rule: decline every applicant with a credit score below 620.
The committee will also ask whether lending for business purposes is “riskier because of what the money is used for” — be careful with causal language.
The data. loans has one row per approved loan: purpose, verified monthly income, years with the current employer, credit score (300–850), debt-to-income ratio (%), amount, term, interest rate and a 0/1 default flag. It is synthetic, generated from a documented risk model; it describes no real lender or borrower.
Stakeholders. The credit committee (sets policy), the sales team (worried about turning away good customers), and, in this scenario, a regulator that expects lending decisions to be explainable and checked for unfair impact on protected groups.
Fairness. The file contains no protected characteristics (such as sex, age band or nationality), so this case cannot tell you whether a cut-off or a model treats groups differently. Variables like credit score, income or loan purpose can act as proxies for such characteristics; a real fairness review needs that data, an agreed definition of fairness and legal/compliance input.
Dataset
Personal loan applications
3,000 rows · one row = one approved loan · synthetic data
| Loan | Application date | Purpose | Monthly income (SAR) | Employment length (years) | Credit score (points) | Debt-to-income (%) | Loan amount (SAR) | Term (months) | Interest rate (%) | Defaulted |
|---|---|---|---|---|---|---|---|---|---|---|
| L00001 | 2023-10-28 | debt_consolidation | 9790 | 1.2 | 548 | 35.6 | 54000 | 36 | 10.66 | 0 |
| L00002 | 2023-07-08 | education | 8900 | 21.5 | 646 | 27.6 | 30000 | 36 | 7.77 | 0 |
| L00003 | 2023-04-05 | car | 7080 | 0.6 | 619 | 26.9 | 99000 | 60 | 10.09 | 0 |
| L00004 | 2023-04-06 | debt_consolidation | 20190 | 15.4 | 664 | 23.9 | 51000 | 12 | 6.71 | 0 |
| L00005 | 2023-10-13 | home_improvement | 8720 | 4.4 | 651 | 37 | 8000 | 36 | 9.62 | 0 |
| L00006 | 2023-05-16 | business | 6410 | 2.5 | 566 | 47.5 | 24000 | 60 | 10.87 | 1 |
Included with a Formula Quest membership
This case has 4 stages and 10 graded tasks, ending with a written report.
View Formula Quest memberships