Cash Flow Calculator Formula
Learn how net cash flow, total cash out, closing balance, and cash ratios are calculated for a monthly or annual period.
The cash flow formula helps you estimate whether cash coming in covers cash going out during a chosen period. Understanding the math behind the calculator makes it easier to spot a surplus, a shortfall, and your expected ending cash position.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Net Cash Flow
Where:
Add all cash outflows together, then subtract that total from cash received. A positive result means a surplus, and a negative result means a shortfall.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| cashIn - Total Cash In | All cash received during the selected period. | currency |
| fixedExpenses - Fixed Expenses | Recurring cash costs that tend to stay similar each period. | currency |
| variableExpenses - Variable Expenses | Cash costs that can change from period to period. | currency |
| otherOutflows - Other Cash Outflows | Additional cash leaving during the period, such as debt payments or one-off costs. | currency |
| openingBalance - Opening Cash Balance | Cash available at the start of the selected period. | currency |
| totalCashOut - Total Cash Out | The sum of all cash outflows during the period. | currency |
| netCashFlow - Net Cash Flow | The difference between total cash in and total cash out. | currency |
Step-by-Step Calculation
Calculate total cash out
Combine all cash outflows for the selected month or year.
totalCashOut = fixedExpenses + variableExpenses + otherOutflows
Calculate net cash flow
Subtract total cash out from total cash in to find the period surplus or shortfall.
netCashFlow = cashIn - totalCashOut
Calculate closing cash balance
Add the period's net cash flow to the starting balance to estimate the ending balance.
closingBalance = openingBalance + netCashFlow
Calculate expense ratio
This shows what share of cash received is used by outflows.
expenseRatio = (totalCashOut / cashIn) * 100
Calculate cash surplus rate
This shows what share of cash received remains after outflows. If negative, it represents a cash shortfall rate.
savingsRate = (netCashFlow / cashIn) * 100
Worked monthly cash flow example
Add total cash out
$2,000 + $1,500 + $300
$3,800
Find net cash flow
$5,000 - $3,800
$1,200
Find closing cash balance
$1,000 + $1,200
$2,200
Calculate expense ratio
($3,800 / $5,000) × 100
76.0%
Calculate cash surplus rate
($1,200 / $5,000) × 100
24.0%
Final Result
Estimated net cash flow is $1,200, total cash out is $3,800, and closing cash balance is $2,200 for the month.
Assumptions
- ✓All values entered are cash movements during one selected monthly or annual period.
- ✓Cash inflows and outflows are treated at face value without non-cash accounting adjustments.
- ✓Opening cash balance is the actual available cash at the start of the period.
- ✓Taxes, financing costs, and irregular payments are only reflected if they are included in the inputs.
Limitations
- !The formula does not model the timing of payments within the period.
- !It does not distinguish between operating, investing, and financing cash flows.
- !Percentage outputs may be misleading if cash in is very low relative to outflows.
- !Results are estimates and may differ from actual cash movement due to delays, missed payments, or unexpected costs.
Common Mistakes to Avoid
Entering profit instead of actual cash received.
Leaving out one-off payments such as tax bills, debt payments, or equipment purchases.
Mixing monthly income with annual expenses in the same calculation.
Using an opening balance that does not match the selected period start.
Interpreting a positive net cash flow as guaranteed future liquidity without considering payment timing.
Related Formulas
Frequently Asked Questions
What is the formula for net cash flow?
Net cash flow is calculated as total cash in minus total cash out. Total cash out is the sum of fixed expenses, variable expenses, and other outflows.
How do you calculate closing cash balance?
Closing cash balance equals opening cash balance plus net cash flow for the period.
What does the expense ratio formula show?
It shows total cash out as a percentage of total cash in, which helps you see how much incoming cash is being used up by outflows.
What happens if net cash flow is negative?
A negative result means cash out is higher than cash in for the period, which reduces the closing cash balance.
Can the formula be used for both personal and business cash flow?
Yes. The same calculation works as long as all cash inflows and outflows are entered consistently for the same period.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.