Calculation guide
Enter forecast cash flow before new financing and its fees.
facility = max(0, minimum cash − min(opening cash and cumulative period-end cash))
Inputs
Opening unrestricted cash
Example entry 10000 (in the selected currency).
Minimum operating cash
Example entry 5000 (in the selected currency).
Net period cash flow before new borrowing
Example entry -8000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening unrestricted cash | 10,000 |
| Minimum operating cash | 5,000 |
Net cash forecast in time order
| Net period cash flow before new borrowing |
|---|
| -8,000 |
| -8,000 |
| 4,000 |
| Result | Value |
|---|---|
| Peak required financing facility | 11,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 |
|---|---|---|---|---|---|
| Opening unrestricted cash | 10,000 | 11,000 | Peak required financing facility | 11,000 | 10,000 |
| Minimum operating cash | 5,000 | 5,500 | Peak required financing facility | 11,000 | 11,500 |
| Net period cash flow before new borrowing (row 1) | -8,000 | -7,200 | Peak required financing facility | 11,000 | 10,200 |
