Monthly Cash Balance

Calculate using the labelled inputs: Monthly Cash Balance.

Monthly net flow
-20000.00
Closing balance
30000.00
Minimum balance including opening
30000.00
First negative month if flows continue
8
Monthly schedule
MonthOpeningInflowOutflowClosing

Calculation and assumptions

net=inflow−outflow; balance(n)=opening+n·net; first_negative=floor(opening/(−net))+1 if net<0.

Constant monthly flows are an entered scenario. The minimum includes the opening balance. The first negative month may lie beyond the table; a zero balance is not negative. Amounts use exact cents. No interest, taxes or seasonal changes are assumed. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

net=inflow−outflow; balance(n)=opening+n·net; first_negative=floor(opening/(−net))+1 if net<0.

What assumptions apply?

Constant monthly flows are an entered scenario. The minimum includes the opening balance. The first negative month may lie beyond the table; a zero balance is not negative. Amounts use exact cents. No interest, taxes or seasonal changes are assumed. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →