Lockbox acceleration value · Calculation guide

Compare annual funding benefit with the cost of a bank collection service.

Calculation guide

Use average receipts per calendar day and days saved on each receipt. One-time reduction in cash tied up earns the annual funding rate. Subtract annual service charges.

net = daily*days*rate/100-fee · released = daily*days · interest = released*rate/100

Inputs

Average daily receipts

Example entry 20000 (in the selected currency).

Collection days saved

Example entry 2.

Annual funding rate

Example entry 6 %. Allowed range 0 to 100.

Annual service fees

Example entry 1500 (in the selected currency).

Worked example

InputValue
Average daily receipts20,000
Collection days saved2
Annual funding rate6%
Annual service fees1,500
ResultValue
Annual net benefit900
Cash released from float40,000
Annual funding benefit2,400

Calculation steps

Annual net benefit = ((((Average daily receipts × Collection days saved) × Annual funding rate) ÷ 100) − Annual service fees)

((((20,000 × 2) × 6) ÷ 100) − 1,500) = 900

Cash released from float = (Average daily receipts × Collection days saved)

(20,000 × 2) = 40,000

Annual funding benefit = ((Cash released from float × Annual funding rate) ÷ 100)

((40,000 × 6) ÷ 100) = 2,400

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Average daily receipts20,00022,000Annual net benefit9001,140
Collection days saved23Annual net benefit9002,100
Annual funding rate6%7%Annual net benefit9001,300
Annual service fees1,5001,650Annual net benefit900750
Lockbox acceleration value →