Calculation guide
need = billings/365*max(0,actual-target)
Inputs
Annual collectible net billings
Example entry 365000.0 (in the selected currency).
Current days to collection
Example entry 60.0.
Target days to collection
Example entry 30.0.
Worked example
| Input | Value |
|---|---|
| Annual collectible net billings | 365,000 |
| Current days to collection | 60 |
| Target days to collection | 30 |
| Result | Value |
|---|---|
| Incremental working capital tied up | 30,000 |
Calculation steps
Incremental working capital tied up = ((Annual collectible net billings ÷ 365) × max(0, (Current days to collection − Target days to collection)))
((365,000 ÷ 365) × max(0, (60 − 30))) = 30,000
Interpreting the result
The result estimates cash a practice could release by reducing collection time to its target.
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 |
|---|---|---|---|---|---|
| Annual collectible net billings | 365,000 | 401,500 | Incremental working capital tied up | 30,000 | 33,000 |
| Current days to collection | 60 | 66 | Incremental working capital tied up | 30,000 | 36,000 |
| Target days to collection | 30 | 33 | Incremental working capital tied up | 30,000 | 27,000 |
