Cash Flow Calculator

This adds up the cash that came in and the cash that went out over a week, month, quarter or year, and returns the net cash flow along with the opening and closing balance. Enter the receipts and the payments and it also gives the cash flow margin, the largest outflow, the break-even figure and, when you are spending more than you take, how long the closing balance lasts at that burn rate. A second tab builds the cash flow statement by the indirect method, starting from net income and working through depreciation, receivables, inventory and payables to operating, investing and financing cash flow and free cash flow. Cash is not profit, and this counts only money that actually moved.

Calculator Type
Leave at zero if you only want the flow and not the balance.
Money that actually landed, not money invoiced.
Interest, refunds, tax rebates, loan drawdowns, owner contributions, transfers in.
Stock, rent, utilities, software, marketing, professional fees.
Wages, contractors and the employer costs that go with them.
Equipment, drawings, dividends, one-off costs.
Widget
The bottom line of the income statement. A loss goes in as a negative number.
An expense that moved no cash, so it is added straight back.
How much more your customers owe you than at the start. More owed means less cash, so this is subtracted. Enter a negative number if receivables fell.
Cash turned into stock on the shelf. Subtracted. Negative if stock was run down.
Bills you have not paid yet, so the cash is still with you. Added. Negative if you paid suppliers down.
Stock compensation, deferred tax, provisions, a gain on a sale that belongs in investing. Positive adds cash back.
Property, plant, equipment and capitalised software bought in the period.
Securities bought or sold, acquisitions, loans made. Positive means cash came in.
Principal only. Interest belongs in operating.
Widget