Open calculator ↗

Seasonal overdraft peak and interest · Calculation guide

Post each period’s receipts and payments at its beginning.

Calculation guide

Accrue simple actual/365 interest on the resulting constant drawn balance. Interest is settled separately at the end of the forecast.

Interest = Σ max(0, −period balance) × annual rate × days / 365

Inputs

Opening bank balance

Example entry 100 (in the selected currency).

Annual overdraft rate

Example entry 10 %. Allowed range 0 to 100.

Cash receipts

Example entry 200 (in the selected currency).

Cash payments

Example entry 150 (in the selected currency).

Days at resulting balance

Example entry 30. Use whole numbers.

Worked example

InputValue
Opening bank balance100
Annual overdraft rate10%

Successive periods

Cash receiptsCash paymentsDays at resulting balance
5030030
2505030
ResultValue
Peak overdraft principal150
Accrued overdraft interest1.232877

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening bank balance100110Peak overdraft principal150140
Annual overdraft rate10%11%Accrued overdraft interest1.2328771.356164
Cash receipts (row 1)5055Peak overdraft principal150145
Cash payments (row 1)300330Peak overdraft principal150180
Days at resulting balance (row 1)3033Accrued overdraft interest1.2328771.356164
Seasonal overdraft peak and interest →

Sources