Repeat loan limit ladder calculator

Set the first loan, step up and cap, then enter a borrower’s days late to see the next loan amount.

Loan ladder
Late loan rules

Fewer days late than the hold limit counts as on time and moves the borrower up one step.

Past loans

Enter the days late for each past loan, oldest first, and 0 for a loan repaid on time.

This borrower and the demo numbers are made up.

Next loan amount

€391
Ladder step4 of 9
On-time loans to top5
Top loan amount€1,000

After 6 past loans, this borrower’s next loan is €391, against a first loan of €200.

5 more loans repaid on time take the borrower to the top step of €1,000.

Past loan results

Loan 10 days lateStep up€250
Loan 22 days lateStep up€313
Loan 312 days lateHeld€313
Loan 40 days lateStep up€391
Loan 535 days lateStep down€313
Loan 60 days lateStep up€391

Loan amount at each step

Ladder decision tables

These rows show the same rules as a decision table, ready to paste into your own rules.

Days late on last loanChange to step
< 8One step up
8 … 29Stay on step
≥ 30One step down
StepLoan amount
1€200
2€250
3€313
4€391
5€488
6€610
7€763
8€954
9€1,000

Get the result by email

Run this ladder in your own rules to read each borrower’s record and set the next loan amount. Start your trial

How the loan ladder works

Each step multiplies the first loan by the step up again, up to the cap. Each past loan moves the borrower up, holds them or moves them down based on days late.

Loan amount = min(Loan cap, First loan × (1 + Step up per on-time loan)^k)
k = 0 · First step
d ≥ Days late to move down → One step down
d ≥ Days late to hold → Stay on step
d < Days late to hold → One step up

The borrower’s record above, loan by loan.

k = 0 · €200
Loan 1: 0 days late → Step up → k = 1 · €250
Loan 2: 2 days late → Step up → k = 2 · €313
Loan 3: 12 days late → Held → k = 2 · €313
Loan 4: 0 days late → Step up → k = 3 · €391
Loan 5: 35 days late → Step down → k = 2 · €313
Loan 6: 0 days late → Step up → k = 3 · €391
Next loan amount = min(€1,000, €200 × 1.25^3) = €391

Amounts are rounded to whole money, and the ladder stops at the cap or after 20 steps. Only days late count, not the size of past loans or anything else in the record.

Repeat borrower loan limits

A repeat loan limit ladder sets a loan amount for each step. The first loan, step up, cap and days late on past loans determine the next amount.

The ladder shows how the borrower’s loan amount changes with each repayment. Use the result to review the next loan amount and copy the rules as decision table rows.

Common questions

What is a repeat loan limit ladder?

It is a list of loan amounts that rise by a set step up to a cap. A borrower moves up, stays on the same step or moves down based on days late on past loans.

How is a repeat borrower’s next loan limit worked out?

Start at the first loan and apply the days-late rule to each past loan, oldest first. The amount at the step reached is the next loan amount.

How much can a borrower get on the next loan?

The next loan amount is the amount at the step reached from the borrower’s past days late. Enter the first loan, step up, cap and repayment record to see it.

How do graduated loan limits work in microfinance?

The loan amount rises by a set step for loans repaid on time, up to a cap. Days late can hold the borrower on the same step or move them down.

How do late payments affect a repeat loan amount?

Days late determine whether a past loan moves the borrower up, holds them on the same step or moves them down. The amount at the resulting step is the next loan.