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
| Input | Value |
|---|---|
| Operating cash receipts | 140,000 |
| Operating payments | 30,000 |
| Scheduled debt service | 60,000 |
| Existing reserve | 10,000 |
| Reserve target | 30,000 |
| Distribution coverage threshold | 1.3 |
| Result | Value |
|---|---|
| Permitted distribution | 30,000 |
| Reserve contribution | 20,000 |
| Residual cash retained | 0 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Operating cash receipts | 140,000 | 154,000 | Permitted distribution | 30,000 | 44,000 |
| Operating payments | 30,000 | 33,000 | Permitted distribution | 30,000 | 27,000 |
| Scheduled debt service | 60,000 | 66,000 | Permitted distribution | 30,000 | 24,000 |
| Existing reserve | 10,000 | 11,000 | Permitted distribution | 30,000 | 31,000 |
| Reserve target | 30,000 | 33,000 | Permitted distribution | 30,000 | 27,000 |
| Distribution coverage threshold | 1.3 | 2.3 | Permitted distribution | 30,000 | 0 |
