Reading the Cash Flow statement

In this article, we'll learn to read a cash flow statement. Cash flow is the measure of how much cash is moving in or out of your business in a given period of time. For example, during one month, you might pay $5,000 in bills and receive $8,000 in cash from your customers. In this case, your total cash flow would be $3,000. Cash flow calculations are essentially this simple:

Cash Received – Cash Paid Out = Cash Flow

A cash flow statement is a record of the increase or decrease in your business's cash balance at any given time. It's a valuable tool for understanding and planning your cash flow. The cash flow statement is a report of changes, not totals. It measures the change in cash during a period. How much money did you start and end with? What changed in between to make it go up or down?

This view of future cash is one of the most important things about business planning. It enables you to see whether your plans if executed well, will produce and maintain a sustainable business. You will also need to constantly monitor cash flow when your business is up and running. 

Note: None of the lines in the cash flow statement can be edited directly. To edit the cash flow numbers, go to the Forecast page and make changes to your entries there. The cash flow statement will recalculate automatically.

 

For additional reading about cash flow, we recommend these articles:

 

Reading a Cash Flow statement

To locate the cash flow statement in LivePlan, click the Forecast section and then select Cash Flow:

forecast section with arrow pointing to cash flow.png

 

Here's a line-by-line explanation of the LivePlan cash flow statement: 

Screen_Shot_2022-04-18_at_11.46.10_AM.png

 

Net Cash from Operations

  • Net Profit - The net profit here is the same as the one in the bottom line of your Profit and loss (P and L) statement. Net profit, also referred to as net income or net earnings, is your "bottom line." If this number is negative, you’ll know that you are running at a loss. Either your expenses are too high, your revenue is in a slump, or both.

  • Gain or Loss from Sale of Assets - The gain or loss on the sale of an asset is the difference between the amount of cash your company receives and the asset's book value at the time of the sale. If an asset is set to a depreciation schedule and is sold for an amount over or under the linearly depreciated asset value, then that gain or loss will be shown here in the month and year in which it occurs.
  • Depreciation and Amortization - This line will only be included if you've added an asset to your forecast. Short-term assets amortize, and long-term assets depreciate. On the profit and loss statement, depreciation is an expense that reduces your net profit. On the cash flow statement, it is added back in as positive cash flow just to offset the fact that the net profit calculation — the starting point for the cash flow statement — has already deducted it.

  • Change in Accounts Receivable - This line explains how the payment terms you’ve agreed on with your customers affect your cash. It accounts for when you sell a product or service, but your customer doesn't pay you immediately. If this number is negative, your customers owe more than they have paid you, so your cash decreases to account for the money you have not yet received. If this number is positive, your customers have paid you more than they owe, so your cash increases to account for the extra money.

  • Change in Inventory - If you have inventory management turned on in your forecast, then you'll be purchasing inventory before it is actually sold. That purchase's effect must be adjusted in the cash flow statement. A negative change in the inventory number means that you have purchased more inventory than you have sold, and a positive change means that you have purchased less inventory than you have sold for that period.

  • Change in Accounts Payable - Accounts payable refers to money you owe to your creditors or suppliers but have not paid yet. If this number is positive, you have incurred more expenses (which were taken out of your net profit) than you have actually paid, so you still have the cash on hand for these expenses. If this number is negative, you have paid more on previous bills owed than you have incurred in new expenses, so you have less cash on hand.

  • Change in Income/Sales Tax Payable - Any tax you collect and pay to the government affects your cash balance, not your net profit. A positive value means that you have collected more sales tax or VAT from your customers than you have paid to the government, so you have extra cash on hand for that period. A negative value means that you have paid out more sales tax/VAT to the government than you have collected from your customers during that period and so have less cash on hand.

  • Change in Prepaid Revenue - Deferred income (sometimes known as Prepaid revenue) is money your company has already received for a product or service it has not yet delivered. When you enter a Recurring charges revenue stream into your forecast and set its payments, so you're collecting them every 2 to 12 months, LivePlan will automatically calculate the change in prepaid revenue.

Net Cash from Investing

  • Assets Purchased or Sold - This line comes from the total assets you have purchased for your business. This is a negative number representing the cash being paid out for purchasing those assets. Note that the purchase of an asset and the source of the cash used to pay for it (such as a loan) are handled separately.

 

Net Cash from Financing

  • Investments Received - This line comes directly from any investments you added to the Financing area of the forecast.
  • Dividends and Distributions - This line represents the total of any dividends you entered into the forecast to represent payments to your investors.

  • Change in Short-Term Debt/Change in Long-Term Debt - These lines come directly from any loans or custom funding entered into the Financing area of the forecast. They are split out depending on whether the funding is short-term debt (to be paid within 12 months) or long-term debt. 

 

Totaling It All Up

  • Cash at Beginning of Period - This is the previous period's Cash at End of Period total, carried over.

  • Net Change in Cash - This is Net Cash Flow from Operations plus Net Cash Flow from Investing and Net Cash Flow from Financing from this period.

  • Cash at End of Period - This is the Cash at Beginning of Period plus the Net Change in Cash, giving the total amount of cash on hand for this period.

 

Editing the Cash Flow table

In LivePlan, you can't edit the Cash Flow table directly - instead, you'd edit the individual forecast entries that are calculating into the Cash Flow table. Click on the Forecast page of LivePlan, and then navigate to the page of entries you need to edit. You can click on any entry to update its contents.

 

Was this article helpful?
8 out of 9 found this helpful