In Part 1, we learned that working capital isn’t cash – it’s speed. Here, we take the first practical step toward optimising that speed: a simple cash flow forecast.<\/p>\n\n
If we’re brutally honest, most businesses\u2014even well-run ones\u2014struggle to answer two simple questions with confidence:<\/p>\n
Ask this in any month-end review, and the room becomes uneasy. Sales confidently lists expected collections. Accounts shows pending invoices. Purchase highlights “urgent” supplier dues. Finance reminds you that bank limits are tight. Everyone has pieces of information but no one has a single, clear picture. And it’s not because the business is weak. It’s because the information sits everywhere: in Tally, WhatsApp, emails, Excel sheets, and inside people’s heads.<\/p>\n\n
What’s missing is not intelligence. What’s missing is visibility. Without knowing who will pay, who must be paid, and when, everything collides, and working capital becomes a guessing game. Businesses don’t fail because they lack profit. They struggle because they can’t see the road ahead.<\/p>\n\n
Working capital problems don’t start with banks, limits, interest costs, delayed customers, or inventory decisions. They start with something far simpler: Not knowing what lies in the next 8-13 weeks. You may have solid sales, healthy margins, loyal customers, and efficient operations, but if the timing of inflows and outflows is invisible, month-end becomes a gamble.<\/p>\n\n
\n Consultant\u2019s Note: Profit vs. Liquidity<\/strong>
\n It is a common misconception that cash flow problems are caused by low profit. In reality, a company can be highly profitable on paper and still face a liquidity crisis. Profit is an accounting metric; liquidity is an operational rhythm. If your cash-to-cash cycle is broken, no amount of profit can compensate for a lack of available cash when your suppliers or statutory dues are waiting.\n<\/blockquote>\n\nOne delayed payment, one bunching of supplier dues, one unplanned raw material purchase, or one GST or salary cycle landing in the wrong week, and suddenly the entire month flips. Visibility is not a luxury. Visibility is oxygen. Without it, businesses don’t manage working capital\u2014they simply survive it, month after month.<\/p>\n\n
How Lack of Visibility Impacts Different Business Models<\/h3>\n\n
Cash stress looks different across industries, but the pattern is identical: poor visibility leading to cash pressure, bad decisions, and margin erosion.<\/p>\n\n
\n
\n Industry Model<\/th>\n Primary Cash Pressure<\/th>\n Key Risk Factor<\/th>\n <\/tr>\n \n Manufacturing<\/strong><\/td>\n Bulk procurement & delayed recovery<\/td>\n Production stoppages due to inventory timing<\/td>\n <\/tr>\n \n Trading<\/strong><\/td>\n The 7-day vs. 45-day gap<\/td>\n Emergency borrowing costs & margin erosion<\/td>\n <\/tr>\n \n Seasonal\/Export<\/strong><\/td>\n Heavy front-end spend<\/td>\n Financing costs during long lean periods<\/td>\n <\/tr>\n<\/table>\n\n Different models, same root cause: When you cannot see timing clearly, working capital bleeds quietly.<\/p>\n\n
The Lens That Finally Brings Cash Into Focus: Cash Flow Forecasting<\/h3>\n\n
Many people imagine “cash flow forecasting” as a complicated spreadsheet. But here’s the truth: Cash Flow Forecasting (CFF) is not a model. It’s not a finance tool. It’s simply a weekly cash calendar.<\/p>\n\n
\n
\n Category<\/th>\n Week 1<\/th>\n Week 2<\/th>\n Week 3<\/th>\n Week 4<\/th>\n <\/tr>\n \n Cash In<\/strong><\/td>\n 20,000<\/td>\n 71,000<\/td>\n 10,000<\/td>\n 25,000<\/td>\n <\/tr>\n \n Cash Out<\/strong><\/td>\n -13,000<\/td>\n -21,000<\/td>\n -13,000<\/td>\n -17,000<\/td>\n <\/tr>\n \n Closing Balance<\/strong><\/td>\n 11,290<\/td>\n 6,993<\/td>\n 12,000<\/td>\n 4,599<\/td>\n <\/tr>\n<\/table>\n\n It shows expected customer collections, planned supplier payments, salaries and wages, GST, TDS, EMI cycles, inventory purchase timings, and upcoming commitments. Put all of this on one page, and something shifts instantly: You stop guessing. You stop reacting. You start seeing.<\/p>\n\n
The Three Speeds That Control Your Cash (DSO, DPO, DIO)<\/h3>\n\n
Once you prepare an 8-13 week forecast, you’ll notice something interesting: Your working capital is driven by three speeds:<\/p>\n
\n
- Customer Payment Speed – DSO (Days Sales Outstanding):<\/strong> How fast customers return your money after billing.<\/li>\n
- Inventory Speed – DIO (Days Inventory Outstanding):<\/strong> How long your cash stays “as stock” before becoming a sale.<\/li>\n
- Supplier Payment Speed – DPO (Days Payables Outstanding):<\/strong> How long you can hold cash before paying suppliers.<\/li>\n<\/ul>\n\n
In simple terms: Working Capital = DSO + DIO – DPO. Slow customer payments bend the forecast, long inventory days stretch the cash, and fast supplier payments tighten liquidity. CFF makes these three speeds visible\u2014sometimes for the first time. And visibility is what begins improvement.<\/p>\n\n
Cash Forecasting Is Not Difficult. It’s a Coordination Problem.<\/h3>\n\n
The formula is simple. The difficulty lies in team coordination. Most ERPs already have payment terms, credit days, supplier due dates, and purchase commitments. But masters are not updated, terms are missing, and data is scattered.<\/p>\n\n
Here’s all that needs to happen: Sales updates realistic payment expectations; Purchase updates supplier terms; Stores flag upcoming bulk purchases; HR shares salary timings; and Finance adds statutory dues and EMIs. Pull this into one simple weekly sheet, and “cash forecasting” becomes a consolidated view of what your own system already knows. Most businesses don’t lack tools; they lack coordination and consistency.<\/p>\n\n
Why Organisations Avoid Forecasting: A Behavioural Economics View<\/h3>\n\n
People don’t resist forecasting because it’s difficult. They resist it because human behaviour is predictable:<\/p>\n
\n
- Status quo bias: “We’ve survived without it.”<\/li>\n
- Optimism bias: “The customer will pay soon.”<\/li>\n
- Present bias: Today’s fire > next month’s crisis.<\/li>\n
- Loss aversion: Fear of being wrong.<\/li>\n
- Complexity aversion: Forecasting seems big, so they avoid starting.<\/li>\n
- Diffusion of responsibility: Everyone assumes someone else is tracking cash.<\/li>\n<\/ul>\n\n
Cash flow forecasting isn’t just a finance tool\u2014it is a behavioural intervention. It forces clarity, honesty, and coordination.<\/p>\n\n
How to Start Small (and Choose the Right Method)<\/h3>\n\n
Start with the direct method: a simple 8-week cash calendar. Then grow into 13 weeks, add more customers\/suppliers, and add the indirect method for a management view. The goal is not perfection. The goal is consistency.<\/p>\n\n
Turning Forecasting Into a Habit (Not Just a File)<\/h3>\n\n
Here’s how you make it stick: One shared sheet, one owner, a 20-minute Monday ritual, an 8-13 week window, using Green\/Yellow\/Red weeks, reviewing deviations, and starting with big buckets. Forecasting works when it becomes a rhythm, not an event.<\/p>\n\n
The Real Message: Working Capital Changes When People Change<\/h3>\n\n
If there’s one insight this entire journey reveals, it’s this: Cash stress doesn’t come from low profit\u2014it comes from low visibility. When a business finally sees its next 13 weeks clearly, decisions become proactive instead of reactive. Cash Flow Forecasting is not a data tool. It is the first step of working capital management. It brings every stakeholder\u2014sales, purchase, finance, stores, HR\u2014to the same table, with the same understanding, looking at the same future. That single act of shared visibility is what starts the journey of working capital optimisation.<\/p>\n","protected":false},"excerpt":{"rendered":"
The First Step to Mastering Working Capital: Cash Flow Forecasting In Part 1, we learned that working capital isn’t cash – it’s speed. Here, we…<\/p>\n","protected":false},"author":1,"featured_media":18,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-working-capital"],"_links":{"self":[{"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":1,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions"}],"predecessor-version":[{"id":19,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions\/19"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=\/wp\/v2\/media\/18"}],"wp:attachment":[{"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fxcapitalindia.in\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}