Cash Flow Forecasting: A Template-Based Guide from AFP - Association for Financial Professionals

Cash Flow Forecasting: A Template-Based Guide from AFP: Members:$95.00; Non-Members:$135.00; Format: E-document; + Add To Cart

Summary

At a limited-time introductory price, this cash flow forecasting guide offers the fundamentals needed to start or review a forecasting program. Techniques covered in the guide are supported with Excel templates that demonstrate direct, indirect and statistical forecasting methods.

As treasury disciplines become increasingly interrelated with other corporate finance activities, the objectives of cash flow forecasting programs become more strategic and vital to the economic health of an organization.

EXCERPT

The method a company uses for a given forecast depends greatly on the forecasting horizon. Many companies use short-term forecasts based on information relating to receipts and disbursements that will occur in the near future. There are a number of methods that incorporate individual cash flow details to develop accurate short-term cash projections.

DIRECT METHOD

When to Use
The direct method typically is best for forecasts with short-term horizons when data is available that is very close to real-time. This brings more "actual" data into the "forecast" estimate.

Limitations
There is still a need to forecast the difference between the known (cash flows that have happened, or will happen with a high degree of certainty), and the unknown and uncertain. For some organizations this difference may be very small, so the variances are likely small. Also, the model is heavily dependant on the accuracy, completeness and timeliness of data.

Receipts and Disbursements Forecast
Projecting receipts and disbursements is fundamental to short-term cash forecasting. This begins with the creation of separate schedules of cash receipts and disbursements. Both schedules are prepared on a cash basis rather than an accrual basis. This method tends to forecast cash accurately in the short-term and near medium-term, especially when accounts receivable and accounts payable data are incorporated.

Cash Reserves Up 10 Percent in 2012, Continue to Grow AbroadU.S. companies’ cash reserves rose 10 percent at the end of last year, according to a new report from Moody’s. Moreover, the rating agency noted that more than half of that money is stashed overseas.
Best Practices: Driver-Based ForecastingCurrent annual budgeting, in most companies, is a time-consuming task that lasts anywhere from six to nine months (or even more), and the budget is usually not accurate by the time the budgeted year begins. Forecasting is an ongoing core management process, not an annual event.
Case Study: Microsoft’s Treasury Mines Big Data and FP&AData overload, or big data, can quickly turn from a blessing into a curse if you do not have the capability to mine it for useful information. This is where FP&A procedures and business intelligence data mining tools can come to the aid of a treasury team seeking useful information from the huge data volumes common in business today.
Sequester Fears: Corporate Treasurers Brace for the WorstAlthough consumer confidence rebounded in February, those positive attitudes could sour quickly as federal spending cuts begin to take effect. What do treasurers think about the sequester? Those whose business depends on consumers fear the worst, as do firms that work directly with the federal government.
Credit Risk is Changing Canadian Corporate-Bank RelationshipsA persistent theme that emerged during a series of recent SCT roundtables was how the challenges of the banking sector are affecting bank relationships, counterparty credit and investment policies. The implementation of Basel III has caused banks to be much more concerned about the credit risk of their customers.

Summary

EXCERPT

You May Also Be Interesed In...