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.
Next loan amount
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 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 loan | Change to step |
|---|---|
| < 8 | One step up |
| 8 … 29 | Stay on step |
| ≥ 30 | One step down |
| Step | Loan 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.