Trade settlement cash availability ladder · Calculation guide

Track cash available after each day’s settlements and identify funding needs.

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

InputValue
Available settled cash before flows500

Net settlements by settlement day

Days from todaySigned settlement cash
1-400
2900
1-200
ResultValue
Final settled cash800
Lowest daily balance including opening-100
Maximum cash top-up needed100

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Available settled cash before flows500550Final settled cash800850
Days from today (row 1)12Lowest daily balance including opening-100300
Signed settlement cash (row 1)-400-360Final settled cash800840
Trade settlement cash availability ladder →