← All work← Back to quest log

Case study · Woolworths Financial ServicesCompleted quest · Woolworths Financial Services

Credit minimum instalments

During COVID, I rebuilt two years of card statements to test whether lowering minimum payments could ease pressure on struggling customers - and how these changes would impact the business.

CompanyFaction
Woolworths Financial Services
RoleClass
Senior Analyst, Customer Analytics
YearEra
2020
ToolsGear
SAS · SQL

The problemThe call

COVID put Woolworths Financial Services' store card and credit card customers under real financial strain. Lowering minimum payments was one way to give them breathing room - but the business needed a fast, complete read of what it would do to delinquency, liquidity and customer behaviour before it could decide.

ApproachThe run

Step 1

Rebuild the statements

Reconstructed two years of statements for every customer from balances, payments and spend.

Step 2

Replay each scenario

Applied each minimum-payment rule, for store cards and credit cards, to the same history.

Step 3

Measure the impact

Tracked delinquency roll rates, liquidity reserves, and payment and spend behaviour under each rule.

Step 4

Take it to the executive

Built the model end to end and presented the findings to my managers and the executive team.

ResultsRewards

5% → 3%Credit card minimum payment, as a share of the outstanding balance
8% → 5%Store card minimum payment, as a share of the outstanding balance
2 yearsof customer statements rebuilt to test every scenario
The trade-off: relief now, longer to clearIllustrative: R10,000 at 20% a year, paying only the minimum (R100 floor). Interest paid rises from about R2,400 to R4,400.
8% minimum - cleared in 46 months5% minimum - cleared in 71 months
R0kR2.5kR5kR7.5kR10k0122436486072Months8% minimum: cleared in 46 months5% minimum: cleared in 71 months

Looking backDebrief

I'd build more flexibility into the model. To meet the deadline, some decisions were kept deliberately simple - for example, grouping each customer's payment behaviour into only a handful of types.

ContextLore notes

Charts use illustrative balances and assumptions; the percentages are the actual policy change.