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
| Input | Value |
|---|---|
| Internal funding available | 40 |
Forecast periods
| Inventory | Trade receivables | Trade payables | Customer advances |
|---|---|---|---|
| 100 | 100 | 70 | 10 |
| 150 | 120 | 60 | 20 |
| Result | Value |
|---|---|
| Peak operating working capital | 190 |
| Maximum external funding gap | 150 |
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 |
|---|---|---|---|---|---|
| Internal funding available | 40 | 44 | Maximum external funding gap | 150 | 146 |
| Inventory (row 2) | 150 | 165 | Peak operating working capital | 190 | 205 |
| Trade receivables (row 2) | 120 | 132 | Peak operating working capital | 190 | 202 |
| Trade payables (row 2) | 60 | 66 | Peak operating working capital | 190 | 184 |
| Customer advances (row 2) | 20 | 22 | Peak operating working capital | 190 | 188 |
