Open calculator ↗

Peak working capital financing requirement · Calculation guide

For each forecast date, add inventory and customer receivables and subtract trade payables and customer advances.

Calculation guide

Deduct available internal funding from the peak requirement.

Peak = max(0, inventory + receivables − payables − advances across periods)

Inputs

Internal funding available

Example entry 40 (in the selected currency).

Inventory

Example entry 100 (in the selected currency).

Trade receivables

Example entry 100 (in the selected currency).

Trade payables

Example entry 70 (in the selected currency).

Customer advances

Example entry 10 (in the selected currency).

Worked example

InputValue
Internal funding available40

Forecast periods

InventoryTrade receivablesTrade payablesCustomer advances
1001007010
1501206020
ResultValue
Peak operating working capital190
Maximum external funding gap150

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Internal funding available4044Maximum external funding gap150146
Inventory (row 2)150165Peak operating working capital190205
Trade receivables (row 2)120132Peak operating working capital190202
Trade payables (row 2)6066Peak operating working capital190184
Customer advances (row 2)2022Peak operating working capital190188
Peak working capital financing requirement →

Sources