Cash Flow Forecast

Toolshero models cash flow forecast

This article describes the basics of Cash Flow Forecast in a practical way. After reading you will understand the basics of this powerful financial management tool.

What is a Cash Flow Forecast?

It has been said that to govern means to foresee. The Cash Flow Forecast is an essential tool for anticipating the surplus or future cash needs of a business. It’s a key aspect of financial management to avoid a lack of liquidities or, conversely, to avoid having huge amounts of idle cash.

How to draw up a Cash Flow Forecast?

First of all, the historical accounts of year t, namely the balance sheet and the P & L accounts (Profit and Loss) must be available. Then you have to set up forecast accounts (balance sheet + P & L) for year t + 1. After that, you only have to go through five calculation steps:

Free Toolshero ebook

1. Calculating the forecast operating cash flow

The estimated operating cash flow is calculated by adding to the forecasted net result (profit or loss) the undisbursed expenses and subtracting the non-cashed revenues.

Undisbursed expenses are depreciations, provisions and prepaid expenses. Non-cash income includes unrealized capital gains, reversals of depreciation, reversals of provisions and deferred income.

2. Calculating the forecasted change in working capital requirements

Receivables and inventories are locking in cash. This explains why their movements upwards or downwards have a negative or positive impact on cash flow. This is also why a growing business (and hence rising turnover and receivables) requires additional working capital funding. Commercial, fiscal and social debts represent a resource for the company. That is why their upward or downward movements will have a favourable or unfavourable impact on liquidity.

Some examples to illustrate:

The forecast change in the item “customer” (receivables at time t + 1 – receivables at time t)

If an increase in receivables is expected in t + 1 (for example, as a result of the expected increase in turnover), the change to be taken into account will have a negative impact on cash flow.

The forecast change in “inventories” (inventories at time t + 1 – stock at time t)

If “inventories” are assumed to increase in t + 1 (for example, more sales are planned, then more or more are bought), the variation to be taken into account will have a negative impact on cash flow.

The forecast change in “suppliers” (debts at time t + 1 – debts at time t)

If commercial debts are expected to decline (for example, suppliers require faster payment terms), their variation will have an unfavorable impact on the company’s liquidity.

The change in tax and social security debts (debts at time t + 1 – debts at time t)

If the forecasted tax and social security liabilities increase, their variation will have a positive influence on cash flow.

3. Taking into account investments and disvestments

Investing in new assets, on own funds, will result in a decrease in cash. While the sale of assets (disinvestment) will increase cash.

4. Consider changes in capital, current accounts and changes in financial liabilities

The positive change in the company’s capital, the shareholders’ current accounts (on the liabilities side of the balance sheet) and the increase in financial debts will have a positive impact on cash flow.

5. Calculating the free Cash Flow Forecast

Free cash flow in t + 1 is obtained by adding the current liquidity at time t to the forecast cash flow at time t + 1.

If positive, cash in t + 1 will be in excess. If, on the other hand, the sum gives a negative amount, we will face a cash requirement in t + 1.

Benefits

The Cash Flow Forecast is an important tool to manage properly the cash of any organisation or small business.

Whether to demonstrate its repayment capacity to its banker, to convince an investor or to make management decisions such as investing or hiring, the cash flow chart is a must.

The Cash Flow Forecast could be also useful to estimate the value of a start-up or an asset, thanks to the “discounted cash flows method”.

With this method, all cash flows are estimated and discounted by using cost of capital to calculate their present value.

Join the Toolshero community

It’s Your Turn

What do you think? Do you recognize the practical explanation about the Cash Flow Forecast or do you have more additions? What are your success factors for the good cash flow forecast set up?

Share your experience and knowledge in the comments box below.

More information

  1. ACCA (2017). Example of a cashflow. Available at https://www.accaglobal.com/uk/en/business-finance/business-plans/example-cashflow.html
  2. Fight, A. (2005). Cash Flow Forecasting (Essential Capital Markets). Butterworth-Heinemann.
  3. Jury, T. (2012). Cash flow analysis and forecasting: the definitive guide to understanding and using published cash flow data (Vol. 653). John Wiley & Sons.

How to cite this article:
Jorio, N. (2017). Cash Flow Forecast. Retrieved [insert date] from ToolsHero: https://www.toolshero.com/financial-management/cash-flow-forecast/

Add a link to this page on your website:
<a href=” https://www.toolshero.com/financial-management/cash-flow-forecast/”>ToolsHero.com: Cash Flow Forecast</a>

Did you find this article interesting?

Your rating is more than welcome or share this article via Social media!

Average rating 4 / 5. Vote count: 3

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Nawfal Jorio
Article by:

Nawfal Jorio

Nawfal Jorio, MSc. is a Financial Analyst for a Belgian Public Investor. He is an expert in Financial Management, Business Planning and Banking. His expertises are Start-ups, SME's and the Non-profit sector.

Tagged:

Leave a Reply