Calculation guide
Enter actual settlement offsets and signed cash flows. Combine all entries settling the same day. Intraday sequencing, unsettled credit and interest are excluded.
Daily closing cash = preceding balance + net cash settling that day.
Inputs
Available settled cash before flows
Example entry 500 (in the selected currency).
Days from today
Example entry 1. Allowed range 0 to 3650. Use whole numbers.
Signed settlement cash
Example entry -400 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Available settled cash before flows | 500 |
Net settlements by settlement day
| Days from today | Signed settlement cash |
|---|---|
| 1 | -400 |
| 2 | 900 |
| 1 | -200 |
| Result | Value |
|---|---|
| Final settled cash | 800 |
| Lowest daily balance including opening | -100 |
| Maximum cash top-up needed | 100 |
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 |
|---|---|---|---|---|---|
| Available settled cash before flows | 500 | 550 | Final settled cash | 800 | 850 |
| Days from today (row 1) | 1 | 2 | Lowest daily balance including opening | -100 | 300 |
| Signed settlement cash (row 1) | -400 | -360 | Final settled cash | 800 | 840 |
