Credit line utilization peak from dated draws · Calculation guide

Find the highest drawn balance and funding shortfall from dated entries.

Calculation guide

Use end-of-day balances; combine same-date draws and repayments before checking the peak. Include the opening balance. Negative closing balances are invalid.

Daily close = prior close + same-day draws − repayments; utilization = max(opening, daily closes)/limit × 100.

Inputs

Credit limit

Example entry 10000 (in the selected currency). Minimum 0.01.

Balance

Example entry 2000 (in the selected currency).

Transaction date

Enter the calendar date in the date field.

Amount drawn

Example entry 1000 (in the selected currency).

Principal repaid

Example entry 0 (in the selected currency).

Worked example

InputValue
Credit limit10,000
Balance2,000

Line transactions

Transaction dateAmount drawnPrincipal repaid
2026-01-016,0000
2026-01-0503,000
ResultValue
Peak utilization80%
Peak drawn balance8,000
Maximum excess above limit0
Final drawn balance5,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Credit limit10,00011,000Peak utilization80%72.727273%
Balance2,0002,200Peak utilization80%82%
Amount drawn (row 1)6,0006,600Peak utilization80%86%
Principal repaid (row 1)01Peak utilization80%79.99%
Credit line utilization peak from dated draws →

Sources