Cash flow forecasting

Last updated

Cash flow forecasting is the process of obtaining an estimate of a company's future cash levels, and its financial position more generally. [1] A cash flow forecast is a key financial management tool, both for large corporates, and for smaller entrepreneurial businesses. The forecast is typically based on anticipated payments and receivables. Several forecasting methodologies are available.

Contents

Function

Cash flow forecasting is an element of financial management. Maintaining 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. [3]

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.

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. [4]

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. [6]

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 will be aware that "Cash is king" and, therefore, invest time and effort in cashflow forecasting.

Methods

A common approach here is to build a spreadsheet, typically in Excel, showing cash coming in from all sources out to at least 90 days, and all cash going out for the same period; any shortfall or mismatch can then be addressed, with e.g. a bridge loan or via increased collections activity. For short term cash flow forecasting there are also a number of AI driven low cost software applications available.

Applying the "spreadsheet approach" 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.) Relatedly, it is noted that when using theoretical methods in cash flow forecasting for managing a business - i.e. using financial accounting as opposed to management accounting standards - non-cash items may be included in the cashflow, [ example needed ] skewing the result.

One observation, [ citation needed ] re the commercial tools available is that while these 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, as they are typically designed to work within predefined frameworks and may not easily adapt to unique business requirements.

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.

<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.

In finance, bad debt, occasionally called uncollectible accounts expense, is a monetary amount owed to a creditor that is unlikely to be paid and for which the creditor is not willing to take action to collect for various reasons, often due to the debtor not having the money to pay, for example due to a company going into liquidation or insolvency. A high bad debt rate is caused when a business is not effective in managing its credit and collections process. If the credit check of a new customer is not thorough or the collections team isn't proactively reaching out to recover payments, a company faces the risk of a high bad debt. There are various technical definitions of what constitutes a bad debt, depending on accounting conventions, regulatory treatment and the institution provisioning. In the United States, bank loans with more than ninety days' arrears become "problem loans". Accounting sources advise that the full amount of a bad debt be written off to the profit and loss account or a provision for bad debts as soon as it is foreseen.

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.

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.

Valuation using discounted cash flows is a method of estimating the current value of a company based on projected future cash flows adjusted for the time value of money. The cash flows are made up of those within the “explicit” forecast period, together with a continuing or terminal value that represents the cash flow stream after the forecast period. In several contexts, DCF valuation is referred to as the "income approach".

Financial management is the business function concerned with profitability, expenses, cash and credit. These are often grouped together under the rubric of maximizing the value of the firm for stockholders. The discipline is then tasked with the "efficient acquisition and deployment" of both short- and long-term financial resources, to ensure the objectives of the enterprise are achieved.

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.

<span class="mw-page-title-main">Financial ratio</span> Numerical value to determine the financial condition of a company

A financial ratio or accounting ratio states the relative magnitude of two selected numerical values taken from an enterprise's financial statements. Often used in accounting, there are many standard ratios used to try to evaluate the overall financial condition of a corporation or other organization. Financial ratios may be used by managers within a firm, by current and potential shareholders (owners) of a firm, and by a firm's creditors. Financial analysts use financial ratios to compare the strengths and weaknesses in various companies. If shares in a company are traded in a financial market, the market price of the shares is used in certain financial ratios.

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.

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 practices used by banks and other financial institutions to manage 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, accessed 16 November 2023
  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. "Hotel Budget: Winning Tips and Best Practices for 2024". www.netsuite.com.
  4. Tony de Caux, "Cash Forecasting", Treasurer's Companion, Association of Corporate Treasurers, 2005
  5. Richard Bort, "Medium-Term Funds Flow Forecasting", Corporate Cash Management Handbook, Warren Gorham & Lamont, 1990
  6. Cash Flow Forecasting, Association for Financial Professionals, 2006

See also