Open calculator ↗

Medical practice collection lag funding need · Calculation guide

Estimate additional receivables tied up by collection delay above the target, assuming even daily net billings and unchanged collection rates.

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

InputValue
Annual collectible net billings365,000
Current days to collection60
Target days to collection30
ResultValue
Incremental working capital tied up30,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Annual collectible net billings365,000401,500Incremental working capital tied up30,00033,000
Current days to collection6066Incremental working capital tied up30,00036,000
Target days to collection3033Incremental working capital tied up30,00027,000
Medical practice collection lag funding need →

Sources