How to use this calculator
Enter opening cash, matching lists of period receipts and payments, then user-assumed upside and downside percentage changes.
Formula and method
Ending balanceₜ = ending balanceₜ₋₁ + receiptsₜ − paymentsₜ. Upside scales receipts by (1+u) and payments by (1−v); downside scales receipts by (1−d) and payments by (1+e).
Worked example
Opening 10,000, receipts 5,000/6,000/7,000 and payments 6,000 each period gives base ending cash 10,000. With +10% receipts/−5% payments, upside ends at 12,700.
Assumptions and supported scope
All future data are hypothetical user assumptions, not actual executions or promises. Equal periods, up to 36 periods. No intra-period cash timing, tax model or external data feed.
Method references
Method and worked example checked against the calculator implementation. About our methods · Report a correction