The Inherent Folly of Cash Forecasting

May 4, 2011

by Gavin Swindell

Here's a contrarian view on the apparently hot topic of cash forecasting amongst the CFO's agenda. Our sister company, The Hackett Group, recently published a survey of CFOs, and 70 percent rated cash flow forecasting as their top priority to be worked upon in 2011. Now, maybe I am being a little simplistic, but I find this strange.

Fast forward to the production planning department where we have been working with MRP and ERP planning systems for many years. One of the first lessons we learn is the immense difficulty it is to properly forecast. The only thing we can truly forecast for sure is that it will be wrong.

The one thing I have learned in this business is CFO's don't like (and can't afford) to be wrong very often. Some will joke that we just have to forecast the unforecastable and make the best of it. Right?

Wrong. The second lesson we learn down in the production planning department is don't forecast what you don't have to. Enter the concept of "dependent" and "independent" demand. Here in production when making widgets for chairs, for example, we quickly learn that we don't need to forecast the number of chair legs. If we are forecasting the number of chairs (A) we need (independent demand), then we automatically know that the number of chair legs (L) (dependent demand) we need will be L= A X 4.

Or perhaps we are selling dining room sets (B) that come with six chairs, which in this scenario the dining room set is independent and needs forecasting, the chairs and the legs are both dependent items. L = D X 6A X 4

It's simply unnecessary to apply any forecasting process or efforts to the legs. Just apply all the effort to the chairs (or dining sets in the second example), get that right, and the legs will follow. Of course, if you are making three legged stools too it gets more complicated.

Now, do you think "cash" is an independent demand item that needs forecasting at all? Or maybe it's a function of your sales patterns allied to production, purchasing, inventory control and collections.

All of these functions contain processes which should be reasonably under control and either governed by externally facing contracts with suppliers and customers telling us when and how much to pay, or by internal targets indicating policies and objectives on things like how much inventory we should have at any point in our supply chain. The cash balance is a function of the policy, efficiency and effectiveness of these processes.

The point is there is no need to forecast cash in a well-run business. It should be calculated. Anyone who is applying serious effort or cost to do so is papering over a business weakness presumably because they feel they have to or because they cannot fix the underlying causes.

In many businesses, the cash flow from operations and the inherent working capital will week in week out account for the majority of transactional volume and value that businesses find it hard to plan and predict accurately.

If the processes surrounding payables, receivables and inventories are effective and efficient, a business should be able to confidently predict the levels of cash required to run the business sensibly and the likely cash needs or balances at any given point. This is equally true in growth, decline, recession, or in the face of seasonal adjustments.

Rather than introducing another forecasting model that will no doubt be wrong, maybe a better priority would be to fix the underlying causes and better understand why it needs forecasting at all.

Gavin Swindell is a Principal for REL Consulting, a division of The Hackett Group, that specializes in cash flow improvement from working capital and across business operations.

Average: 7.3 (7 votes)

Thank you for such a

Thank you for such a fantastic blog. Where else could anyone get that kind of info written in such a perfect way? I have a presentation that I am presently working on, and I have been on the look out for such information.
paper placemats

Computer Accessories Wine

Computer Accessories

Wine Carriers

Waterproof Beach Case Arts Crafts 0.57645963
Wholesale Pin

Wholesale Badge

Wholesale Calendar Wholesale Keyboard 0.811360022
Pet Poo Pick Bag

Muslim Hat

Wholesale Lighter Wholesale Thermometer 0.149165074
Money Clip

Stamp

Wholesale Racks Wholesale Compressed Products 0.694880808
Wholesale Glasses

Wholesale Binoculars

Fishing Supplies Wholesale USB Flash Drive 0.793919436
Ice Bottle

Highlighter

Gift Box Entertainment Supplies 0.904101225
Wholesale Cap

Stamp Pen

Pet Dog Leash Safety Products 0.614382157
Coca Cola Gifts

GPS Watch

Christmas Gifts Wholesale Stress Ball 0.9309328
Poncho Keychain

Silicone Cake Mould

Valentine Gifts Pet Dog Leash 0.257637945
Wholesale Ruler

Hair Products

Valentine Gifts Crystal Gifts 0.230784763
Wholesale Vuvuzela

Shaving Set

Bingo Bag Wholesale Glove 0.303521265
Glass Rimmers

Poncho Keychain

Inflatable Products Wholesale Album 0.104901251
Highlighter Pen

Foldable Frisbee In Pouch

Wholesale Massager Automotive Products 0.014376294
Wholesale Binoculars

Promotional Products

Baby Products Suppliers Business Gift 0.890360039
Wholesale Halloween Gift

Shaving Brush

Entertainment Supplies Spare Tire Cover 0.389674909
Wholesale Waterproof Case

Pet Waste Bag Dispenser

Patient Care Products Hockey Stick 0.369784141
Newtons Cradle

Survival Card

Wholesale Ashtray Wholesale Stapler 0.016617237
Wholesale Compressed Products

Mini Hockey Stick

Wholesale Dartboard Bar Caddy 0.407978856
Wholesale Swimming Products

Bag Clip

Wholesale Furniture Wholesale Bag 0.36478133
Wholesale Mouse

Wholesale Fan

Wholesale Puzzle Wholesale Scissors 0.246348113

Great

I always find such amazing posts on this website and today’s post was really amazing. Now I have become a regular user of this website. Thanks for giving us so much knowledge. buy unique articles

Not bad considering the slow

Not bad considering the slow decline of European economy. This just goes to show that even though we are facing a tough financial situation, there is still glimmer of hope for growth. - Anatesha Dunn

cash forecasting folly

While you certainly peak interest by saying there is no need to forecast cash in a well run business, what you really seem to be saying is that the cash forecast should be an output of a planning system that reflects the companies key operating parameters. . The best run businesses have some form of financial planning to support their strategic and operational plans. The policy, efficiency, and effectiveness of a company's processes are built into any good financial model, whose output includes the full set of proforma financials (so cash balances are provided much like the legs needed are derived by the # of tables). The process of building the model I believe provides key insights into these issues (the process is more important than a static output.)

Growth companies are constrained by capital, and cash is a key measure in testing a range of investment scenarios. Well run companies deploy "excess" cash. Certainly the key operating processes and policies drive the results, but cash forecasting provides critical insight into investment policy which may substantially modify your future processes and policies to the better. No one has a perfect crystal ball, but anticipating the magnitude of a cash crunch 15 months out due to an unexpected key project disruption can be addressed with a rescheduling of priorities. Don't know how to do this without some kind of financial planning cycle that includes a cash forecast.

Thanks for such a nice and

Thanks for such a nice and updated information. I got some interesting tips from this post.
donna cerca uomo verona
donna cerca uomo milano
donna cerca uomo napoli
donna cerca uomo brescia