Cash flow forecasting

Last updated

Cash flow forecasting [1] is the process of obtaining an estimate of a company's future financial position; the cash flow forecast is typically based on anticipated payments and receivables. There are two types of cash flow forecasting methodologies, direct cash forecasting and indirect cash forecasting.

Contents

Function

Cash flow forecasting is an element of financial management. A company's Cash flow is a central part of managing the business and the financing of ongoing operations — particularly for start-ups and small enterprises. If the business runs out of cash and is not able to obtain new finance, it will become insolvent, and eventually declare Bankruptcy.

Cash flow forecasting helps management forecast (predict) cash levels to avoid insolvency. The frequency of forecasting is determined by several factors, such as characteristics of the business, the industry and regulatory requirements. [2] In a stressed situation, where insolvency is near, forecasting may be needed on a daily basis.

Key items and aspects of cash flow forecasting:

Corporate finance

In the context of corporate finance, cash flow forecasting is the modeling of a company or entity's future financial liquidity over a specific timeframe: short term generally relates to working capital management, and longer term to asset and liability management. Cash usually refers to the company's total bank balances, but often what is forecast is treasury position which is cash plus short-term investments minus short-term debt. Cash flow is the change in cash or treasury position from one period to the next period.The cash flow projection is an important input into valuation of assets, budgeting and determining appropriate capital structures in LBOs and leveraged recapitalizations. Depending on the organization, then, this modeling may sit with "FP&A" or with corporate treasury. (See also Owner earnings.)

Methods

Cashflows may be forecast directly, as well as by several indirect methods.

The direct method of cash flow forecasting schedules the company's cash receipts and disbursements (R&D). Receipts are primarily the collection of accounts receivable from recent sales, but also include sales of other assets, proceeds of financing, etc. Disbursements include payroll, payment of accounts payable from recent purchases, dividends and interest on debt. This direct R&D method is best suited to the short-term forecasting horizon of 30 days ("or so") because this is the period for which actual, as opposed to projected, data is available. [3]

The three indirect methods are based on the company's projected income statements and balance sheets.

Both the ANI and PBS methods are suited to the medium-term (up to one year) and long-term (multiple years) forecasting horizons. Both are limited to the monthly or quarterly intervals of the financial plan, and need to be adjusted for the difference between accrual-accounting book cash and the often-significantly-different bank balances. [5]

Entrepreneurial

In the context of entrepreneurs or managers of small and medium enterprises, cash flow forecasting may be somewhat simpler, planning what cash will come into the business or business unit in order to ensure that outgoing can be managed so as to avoid them exceeding cashflow coming in. Entrepreneurs need to learn quickly that "Cash is king" and, therefore, they must become good at cashflow forecasting.

Methods

The simplest method is to have a spreadsheet that shows cash coming in from all sources out to at least 90 days, and all cash going out for the same period. This requires that the quantity and timings of receipts of cash from sales are reasonably accurate, which in turn requires judgement honed by experience of the industry concerned, because it is rare for cash receipts to match sales forecasts exactly, and it is also rare for customers all to pay on time. (These principles remain constant whether the cash flow forecasting is done on a spreadsheet or on paper or on some other IT system.) A danger of using entirely theoretical methods in cash flow forecasting for managing a business is that there can be non cash items in the cashflow as reported under financial accounting standards.[ example needed ] This goes to the heart of the difference between financial accounting and management accounting.

For short term cash flow forecasting there are a number of AI driven low cost software applications available. While AI tools can offer automation and predictive capabilities, there are limitations to their accuracy, especially in areas that involve human behaviour or subjective factors. For instance, predicting when customers will pay their bills accurately can be challenging due to various factors that influence payment behaviour. AI tools heavily rely on historical patterns and predefined rules, which may not always capture the complexities of real-world situations accurately.

Moreover, AI tools may lack the flexibility and customization options provided by Excel. They are typically designed to work within predefined frameworks and may not easily adapt to unique business requirements.

If a business is running to the limits of its overdraft and cash management is an issue, using an app is not the best way to manage it. An app, even an AI enabled application will only look at historic data and make predictions using learned patterns. The app will not be able to tell you when a customer will pay his bill, it might guess, but will invariably be wrong. A business running close to the wire, needs a human to guide it, only a human being will know who is screaming loudest for a payment, who must be paid to keep the show on the road.There is only one tool fit for purpose, Excel, with Excel you can cut and paste and move predicted payments and receipts with ease so that your balance will not exceed your facilities. It will take more work than relying on an app, but it will be more accurate and if you don’t need that accuracy then you don’t need the app.

Related Research Articles

<span class="mw-page-title-main">Bookkeeping</span> Recording financial transactions or events

Bookkeeping is the recording of financial transactions, and is part of the process of accounting in business and other organizations. It involves preparing source documents for all transactions, operations, and other events of a business. Transactions include purchases, sales, receipts and payments by an individual person or an organization/corporation. There are several standard methods of bookkeeping, including the single-entry and double-entry bookkeeping systems. While these may be viewed as "real" bookkeeping, any process for recording financial transactions is a bookkeeping process.

<span class="mw-page-title-main">Balance sheet</span> Accounting financial summary

In financial accounting, a balance sheet is a summary of the financial balances of an individual or organization, whether it be a sole proprietorship, a business partnership, a corporation, private limited company or other organization such as government or not-for-profit entity. Assets, liabilities and ownership equity are listed as of a specific date, such as the end of its financial year. A balance sheet is often described as a "snapshot of a company's financial condition". It is the summary of each and every financial statement of an organization.

<span class="mw-page-title-main">Debits and credits</span> Sides of an account in double-entry bookeeping

Debits and credits in double-entry bookkeeping are entries made in account ledgers to record changes in value resulting from business transactions. A debit entry in an account represents a transfer of value to that account, and a credit entry represents a transfer from the account. Each transaction transfers value from credited accounts to debited accounts. For example, a tenant who writes a rent cheque to a landlord would enter a credit for the bank account on which the cheque is drawn, and a debit in a rent expense account. Similarly, the landlord would enter a credit in the rent income account associated with the tenant and a debit for the bank account where the cheque is deposited.

<span class="mw-page-title-main">Cash conversion cycle</span> Length of time it takes a company to convert resource inputs to cash flows

In management accounting, the Cash conversion cycle (CCC) measures how long a firm will be deprived of cash if it increases its investment in inventory in order to expand customer sales. It is thus a measure of the liquidity risk entailed by growth. However, shortening the CCC creates its own risks: while a firm could even achieve a negative CCC by collecting from customers before paying suppliers, a policy of strict collections and lax payments is not always sustainable.

<span class="mw-page-title-main">Factoring (finance)</span> Financial transaction and a type of debtor finance

Factoring is a financial transaction and a type of debtor finance in which a business sells its accounts receivable to a third party at a discount. A business will sometimes factor its receivable assets to meet its present and immediate cash needs. Forfaiting is a factoring arrangement used in international trade finance by exporters who wish to sell their receivables to a forfaiter. Factoring is commonly referred to as accounts receivable factoring, invoice factoring, and sometimes accounts receivable financing. Accounts receivable financing is a term more accurately used to describe a form of asset based lending against accounts receivable. The Commercial Finance Association is the leading trade association of the asset-based lending and factoring industries.

<span class="mw-page-title-main">Accounts receivable</span> Claims for payment held by a business

Accounts receivable, abbreviated as AR or A/R, are legally enforceable claims for payment held by a business for goods supplied or services rendered that customers have ordered but not paid for. The accounts receivable process involves customer onboarding, invoicing, collections, deductions, exception management, and finally, cash posting after the payment is collected. These are generally in the form of invoices raised by a business and delivered to the customer for payment within an agreed time frame. Accounts receivable is shown in a balance sheet as an asset. It is one of a series of accounting transactions dealing with the billing of a customer for goods and services that the customer has ordered. These may be distinguished from notes receivable, which are debts created through formal legal instruments called promissory notes.

<span class="mw-page-title-main">Cash flow statement</span> Financial statement

In financial accounting, a cash flow statement, also known as statement of cash flows, is a financial statement that shows how changes in balance sheet accounts and income affect cash and cash equivalents, and breaks the analysis down to operating, investing and financing activities. Essentially, the cash flow statement is concerned with the flow of cash in and out of the business. As an analytical tool, the statement of cash flows is useful in determining the short-term viability of a company, particularly its ability to pay bills. International Accounting Standard 7 is the International Accounting Standard that deals with cash flow statements.

In financial accounting, free cash flow (FCF) or free cash flow to firm (FCFF) is the amount by which a business's operating cash flow exceeds its working capital needs and expenditures on fixed assets. It is that portion of cash flow that can be extracted from a company and distributed to creditors and securities holders without causing issues in its operations. As such, it is an indicator of a company's financial flexibility and is of interest to holders of the company's equity, debt, preferred stock and convertible securities, as well as potential lenders and investors.

Asset-based lending is any kind of lending secured by an asset. This means, if the loan is not repaid, the asset is taken. In this sense, a mortgage is an example of an asset-based loan. More commonly however, the phrase is used to describe lending to business and large corporations using assets not normally used in other loans. Typically, the different types of asset-based loans include accounts receivable financing, inventory financing, equipment financing, or real estate financing. Asset-based lending in this more specific sense is possible only in certain countries whose legal systems allow borrowers to pledge such assets to lenders as collateral for loans.

Working capital (WC) is a financial metric which represents operating liquidity available to a business, organisation, or other entity, including governmental entities. Along with fixed assets such as plant and equipment, working capital is considered a part of operating capital. Gross working capital is equal to current assets. Working capital is calculated as current assets minus current liabilities. If current assets are less than current liabilities, an entity has a working capital deficiency, also called a working capital deficit and negative working capital.

<span class="mw-page-title-main">Financial plan</span> Evaluation of ones financial state

In general usage, a financial plan is a comprehensive evaluation of an individual's current pay and future financial state by using current known variables to predict future income, asset values and withdrawal plans. This often includes a budget which organizes an individual's finances and sometimes includes a series of steps or specific goals for spending and saving in the future. This plan allocates future income to various types of expenses, such as rent or utilities, and also reserves some income for short-term and long-term savings. A financial plan is sometimes referred to as an investment plan, but in personal finance, a financial plan can focus on other specific areas such as risk management, estates, college, or retirement.

Foreign exchange risk is a financial risk that exists when a financial transaction is denominated in a currency other than the domestic currency of the company. The exchange risk arises when there is a risk of an unfavourable change in exchange rate between the domestic currency and the denominated currency before the date when the transaction is completed.

The following outline is provided as an overview of and topical guide to finance:

<span class="mw-page-title-main">Asset</span> Economic resource, from which future economic benefits are expected

In financial accounting, an asset is any resource owned or controlled by a business or an economic entity. It is anything that can be used to produce positive economic value. Assets represent value of ownership that can be converted into cash . The balance sheet of a firm records the monetary value of the assets owned by that firm. It covers money and other valuables belonging to an individual or to a business.

Net operating assets (NOA) are a business's operating assets minus its operating liabilities. NOA is calculated by reformatting the balance sheet so that operating activities are separated from financing activities. This is done so that the operating performance of the business can be isolated and valued independently of the financing performance. Management is usually not responsible for creating value through financing activities unless the company is in the finance industry, therefore reformatting the balance sheet allows investors to value just the operating activities and hence get a more accurate valuation of the company. One school of thought is that there is no such security as an operating liability. All liabilities are a form of invested capital, and are discretionary, so the concept of net operating assets has no basis because operating assets are not discretionary.

WorkingPoint is a web-based application providing a suite of small business management tools. It is designed to offer a single point-of-access for all business management needs while offering a user-friendly interface. WorkingPoint’s functionalities include double-entry bookkeeping, contact management, inventory management, invoicing and bill & expense management.

A project finance model is a specialized financial model, the purpose of which is to assess the economic feasibility of the project in question. The model's output can also be used in structuring, or "sculpting", the project finance deal.

Securitization is the financial practice of pooling various types of contractual debt such as residential mortgages, commercial mortgages, auto loans or credit card debt obligations and selling their related cash flows to third party investors as securities, which may be described as bonds, pass-through securities, or collateralized debt obligations (CDOs). Investors are repaid from the principal and interest cash flows collected from the underlying debt and redistributed through the capital structure of the new financing. Securities backed by mortgage receivables are called mortgage-backed securities (MBS), while those backed by other types of receivables are asset-backed securities (ABS).

<span class="mw-page-title-main">Corporate finance</span> Framework for corporate funding, capital structure, and investments

Corporate finance is the area of finance that deals with the sources of funding, and the capital structure of corporations, the actions that managers take to increase the value of the firm to the shareholders, and the tools and analysis used to allocate financial resources. The primary goal of corporate finance is to maximize or increase shareholder value.

<span class="mw-page-title-main">Supply chain finance</span>

Supply chain financing is a form of financial transaction wherein a third party facilitates an exchange by financing the supplier on the customer's behalf. The term also refers to the techniques and practices used by banks and other financial institutions to manage the capital invested into the supply chain and reduce risk for the parties involved.

References

  1. Martin Gillespie (2016). What is Cash Flow Forecasting?, cashanalytics.com
  2. "Should I do Monthly, Weekly or Daily Cash Flow Forecasting?". simplycashflow.com. Archived from the original on 2019-11-05. Retrieved 2013-05-27.
  3. Tony de Caux, "Cash Forecasting", Treasurer's Companion, Association of Corporate Treasurers, 2005
  4. Richard Bort, "Medium-Term Funds Flow Forecasting", Corporate Cash Management Handbook, Warren Gorham & Lamont, 1990
  5. Cash Flow Forecasting, Association for Financial Professionals, 2006

See also