Monthly Cash Balance
Calculate using the labelled inputs: Monthly Cash Balance.
Enter a finite value within the formula’s domain and supported numeric range.
| Month | Opening | Inflow | Outflow | Closing |
|---|
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.