Calculation guide
Cap the sweep at outstanding debt and retain all residual cash.
Inputs
Eligible available cash
Example entry 100000 (in the selected currency).
Minimum retained cash
Example entry 40000 (in the selected currency).
Contractual sweep rate (%)
Example entry 50 %. Allowed range 0 to 100.
Eligible debt outstanding
Example entry 50000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Eligible available cash | 100,000 |
| Minimum retained cash | 40,000 |
| Contractual sweep rate (%) | 50% |
| Eligible debt outstanding | 50,000 |
| Result | Value |
|---|---|
| Cash sweep repayment | 30,000 |
| Remaining debt | 20,000 |
| Remaining cash | 70,000 |
Calculation steps
Cash sweep repayment = min(Eligible debt outstanding, ((max(0, (Eligible available cash − Minimum retained cash)) × Contractual sweep rate (%)) ÷ 100))
min(50,000, ((max(0, (100,000 − 40,000)) × 50) ÷ 100)) = 30,000
Remaining debt = (Eligible debt outstanding − Cash sweep repayment)
(50,000 − 30,000) = 20,000
Remaining cash = (Eligible available cash − Cash sweep repayment)
(100,000 − 30,000) = 70,000
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 |
|---|---|---|---|---|---|
| Eligible available cash | 100,000 | 110,000 | Cash sweep repayment | 30,000 | 35,000 |
| Minimum retained cash | 40,000 | 44,000 | Cash sweep repayment | 30,000 | 28,000 |
| Contractual sweep rate (%) | 50% | 55% | Cash sweep repayment | 30,000 | 33,000 |
| Eligible debt outstanding | 50,000 | 55,000 | Remaining debt | 20,000 | 25,000 |
