Tools Finance & Business Cash Flow Calculator

Cash Flow Calculator: Ending Cash Balance

Finance & Business Active

Track cash moving in and out over a period. See net cash flow, your ending balance, the percent change, and the inflow coverage ratio.

Cash Flow Calculator

$
$
$
$75,000.00
Forecasted Ending Cash Balance
Net Period Cash Flow
+$25,000.00
Inflow / Outflow Coverage Ratio
1.26x Coverage
Net Cash Change %
+50.0% Change
Cash Runway (Periods of Outflows)
0.79 Periods

Rate This Tool

Your feedback helps others discover great tools

–
out of 5
No ratings yet

Tap a star to rate:

About This Tool

A business can show a profit on paper and still run out of cash before payday. That is why owners watch cash flow, the money actually moving in and out of the bank. The Cash Flow Calculator takes your opening balance, inflows, and outflows and shows where your cash ends up.

You get the ending cash balance, net cash flow, percent change in cash, and a coverage ratio. It also estimates how many periods of spending your ending cash could cover. It works for a small business, a freelancer, or a household tracking a month of income and bills.

Table of Contents

  • What the Calculator Does
  • How to Use It, Step by Step
  • The Cash Flow Formulas
  • Worked Example
  • How to Read the Results
  • What Moves Your Ending Cash
  • Limitations and Assumptions
  • FAQs About the Cash Flow Calculator

What the Calculator Does

The tool updates live as you type. Each result comes from three dollar amounts.

  • Forecasted Ending Cash Balance: your opening cash plus the net flow.
  • Net Period Cash Flow: inflows minus outflows, with a plus sign when positive.
  • Inflow / Outflow Coverage Ratio: how many dollars come in for each dollar that goes out.
  • Net Cash Change %: net flow as a share of opening cash.
  • Cash Runway (Periods of Outflows): ending cash divided by outflows.
  • Input Checks: a red message and N/A results appear if a field is blank, negative, or too large.
  • Copy Cash Flow Statement and Reset buttons.

How to Use It, Step by Step

  1. Enter the cash in the bank at the start of the period in Beginning Cash Balance ($).
  2. Enter all money received in Total Cash Inflows ($). Include sales collected, loan proceeds, and deposits.
  3. Enter all money paid out in Total Cash Outflows ($). Include payroll, rent, supplies, taxes, and loan payments.
  4. Read the ending balance first, then the four cards. Fix any red message before you trust a result.
  5. Press Copy Cash Flow Statement to copy a text summary, or Reset to restore the sample figures.

Use one period for all three amounts. The runway card counts periods, so monthly figures give months of runway.

The Cash Flow Formulas

The math is plain arithmetic. Net flow is what changes your balance, and the balance is where you end up.

Beginning Cash+Inflows-Outflows=Ending Cash
  • Net flow = inflows - outflows.
  • Coverage ratio = inflows ÷ outflows. With 0 outflows it shows N/A (no outflows), or N/A (no cash flow) if inflows are also 0.
  • Net cash change % = net flow ÷ beginning cash × 100. It shows N/A (no starting cash) if beginning cash is 0.
  • Cash runway = ending cash ÷ outflows, shown in periods. It shows N/A (no outflows) when outflows are 0.

Worked Example

Dale runs a landscaping company. In March he started with $22,000 in the bank. Customers paid $86,400 during the month, and he paid out $79,300 for payroll, fuel, equipment, and insurance.

ResultCalculationOutput
Net Period Cash Flow$86,400 - $79,300+$7,100.00
Ending Cash Balance$22,000 + $7,100$29,100.00
Coverage Ratio$86,400 ÷ $79,3001.09x Coverage
Net Cash Change %$7,100 ÷ $22,000 × 100+32.3% Change
Cash Runway$29,100 ÷ $79,3000.37 Periods

Dale added cash this month, but 0.37 of a month covers only about 11 days of spending. A thin cushion like that is worth watching.

How to Read the Results

Ending Cash Balance is your projected bank position at the end of the period. If it is negative, you would need a credit line, a loan, or an owner deposit to cover the gap.

Net Period Cash Flow shows direction. Positive means cash grew. Negative means you burned through cash during the period.

Coverage Ratio above 1.00x means inflows exceeded outflows. Below 1.00x means you spent more than you collected.

Net Cash Change % compares the change with where you started. The same $7,100 gain looks bigger against a $22,000 base than a $200,000 one.

Cash Runway shows how many periods of the current spending your ending cash would cover. If ending cash is negative, it reads None (ending cash is negative). Aim for a few months of cushion if your income is uneven.

What Moves Your Ending Cash

Timing matters as much as totals. Unpaid customer invoices raise sales but not cash, while prepaid expenses drain cash early. Our working capital calculator shows whether your short-term assets can cover your short-term bills.

To separate day-to-day cash from one-time items, try the operating cash flow calculator. If you are spending more than you collect, the burn rate calculator shows the monthly drain. The startup runway calculator then estimates how long your cash lasts at that pace.

Cash flow also differs from profit. Check your bottom line with the net profit calculator, then compare it with the cash result here. Find related tools in the finance and business calculator hub.

Limitations and Assumptions

  • The tool uses totals you supply. It does not split operating, investing, and financing cash flows.
  • The runway card divides ending cash by outflows for the same period. It counts periods, so enter monthly figures for a true month count.
  • Each field must be a number from 0 to $1,000,000,000,000. Blank, negative, or larger entries show a red message and N/A results.
  • Negative beginning cash, an overdraft, is not accepted. Enter 0 if your account starts empty.
  • Negative results show the minus sign first, for example -$7,700.00.
  • Percent change needs a beginning balance above 0, so it shows N/A (no starting cash) at 0.

FAQs About the Cash Flow Calculator

What is net cash flow?

Net cash flow is the money that came in minus the money that went out over a set period. A positive number means your cash balance grew. A negative one means it shrank.

Is cash flow the same as profit?

No. Profit counts sales when you earn them, while cash flow counts money when it moves. A company can be profitable and still run short of cash.

What should I include in cash inflows?

Include every deposit that adds cash: customer payments, loan proceeds, owner contributions, and asset sales. Leave out unpaid invoices until the money actually arrives.

What does a coverage ratio of 1.26x mean?

It means you took in $1.26 for every $1.00 you spent during the period. The extra $0.26 is the cash you added to your balance.

Why does the runway card say N/A?

It shows N/A (no outflows) when your outflows are 0, because dividing by zero has no answer. Any other outflow amount gives a real number of periods, even a large one.

How often should I run a cash flow check?

Monthly is common for small businesses. Weekly checks help when cash is tight or customers pay late. Keep the same period each time so results compare fairly.

This calculator gives planning estimates only and is not financial advice. Reviewed for general accuracy by Prof. Dr. Khalil Mudassar, PhD.

Category: Finance & Business

You May Also Like

View All