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
| Input | Value |
|---|---|
| Opening bank balance | 100 |
| Annual overdraft rate | 10% |
Successive periods
| Cash receipts | Cash payments | Days at resulting balance |
|---|---|---|
| 50 | 300 | 30 |
| 250 | 50 | 30 |
| Result | Value |
|---|---|
| Peak overdraft principal | 150 |
| Accrued overdraft interest | 1.232877 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening bank balance | 100 | 110 | Peak overdraft principal | 150 | 140 |
| Annual overdraft rate | 10% | 11% | Accrued overdraft interest | 1.232877 | 1.356164 |
| Cash receipts (row 1) | 50 | 55 | Peak overdraft principal | 150 | 145 |
| Cash payments (row 1) | 300 | 330 | Peak overdraft principal | 150 | 180 |
| Days at resulting balance (row 1) | 30 | 33 | Accrued overdraft interest | 1.232877 | 1.356164 |
