Open calculator ↗

Project cash waterfall with reserve triggers · Calculation guide

Pay operating costs and debt first. Fill any reserve deficit from remaining cash.

Calculation guide

Distribute residual cash only when the entered coverage test passes.

payout = if (cash − cost)/debt ≥ trigger, residual after reserve; otherwise 0 · fund = min(max(0,target − reserve),max(0,cash − cost − debt)) · locked = residual − payout

Inputs

Operating cash receipts

Example entry 140000.0 (in the selected currency).

Operating payments

Example entry 30000.0 (in the selected currency).

Scheduled debt service

Example entry 60000.0 (in the selected currency). Minimum 1e-12.

Existing reserve

Example entry 10000.0 (in the selected currency).

Reserve target

Example entry 30000.0 (in the selected currency).

Distribution coverage threshold

Example entry 1.3.

Worked example

InputValue
Operating cash receipts140,000
Operating payments30,000
Scheduled debt service60,000
Existing reserve10,000
Reserve target30,000
Distribution coverage threshold1.3
ResultValue
Permitted distribution30,000
Reserve contribution20,000
Residual cash retained0

Interpreting the result

Retained cash shows the amount left after the reserve that the coverage test prevents distributing.

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Operating cash receipts140,000154,000Permitted distribution30,00044,000
Operating payments30,00033,000Permitted distribution30,00027,000
Scheduled debt service60,00066,000Permitted distribution30,00024,000
Existing reserve10,00011,000Permitted distribution30,00031,000
Reserve target30,00033,000Permitted distribution30,00027,000
Distribution coverage threshold1.32.3Permitted distribution30,0000
Project cash waterfall with reserve triggers →

Sources