Lesson Objective: To develop a granular working capital budget that accurately reflects the company’s cash conversion cycle, integrates seasonal and cyclical fluctuations, and provides a robust monthly/quarterly cash flow forecast for liquidity management.

In-Depth Notes:

1. The Working Capital Budget (The “Cash Conversion” Engine):
Working capital is the short-term operating liquidity of the business. A poorly forecasted working capital budget is the leading cause of corporate cash flow crises and, in extreme cases, bankruptcy. The budget must be built using the efficiency ratios established in Module 4.

• Budgeting for Accounts Receivable (AR): The AR budget is driven by the forecasted revenue and the DSO assumption.

  • The “Credit Policy” Assumption: The budget must include a separate assumption for the company’s credit policy. If the company expects to tighten credit (to reduce bad debts), DSO should decline. If the company expects to offer extended terms to win a large new customer, DSO should increase. This is a direct management decision that must be modeled explicitly.

  • The Bad Debt Reserve: Under IFRS 9 and US GAAP CECL (Current Expected Credit Losses), companies must forecast expected credit losses on their AR portfolio based on historical loss rates and forward-looking macroeconomic factors (e.g., projected unemployment rates). The budget must include a “Bad Debt Expense” schedule that is calculated as a percentage of AR (e.g., 2% of gross AR), which flows through the P&L and reduces the net AR balance.

• Budgeting for Inventory: The inventory budget must reconcile the “flow” of goods.

  • The Inventory Roll-Forward: Opening Inventory + Purchases - COGS = Closing Inventory. The budget must explicitly forecast “Purchases” (which is often the largest use of cash in the operating cycle).

  • The “Safety Stock” Buffer: In volatile supply chains (common in European manufacturing), companies maintain a safety stock of critical raw materials. The inventory budget must specify the safety stock level in days of production, and the model must automatically increase inventory levels if the safety stock assumption is increased to mitigate supply chain risk.

• Budgeting for Accounts Payable (AP): The AP budget is driven by the forecasted purchases and the DPO assumption.

  • The “Supplier Terms” Policy: Management’s decision to extend payment terms (increase DPO) provides a short-term cash benefit. However, under European payment reporting directives, companies must disclose their average payment terms; excessively long DPO is now a reputational risk.

2. The Monthly/Quarterly Cash Flow Forecasting Model:
The operating budget (P&L) and the working capital budget are combined to create the cash flow forecast.

• The “Direct” vs. “Indirect” Cash Flow Budget:

  • The Indirect Method (starts with Net Income) is used for external reporting and annual budgets.

  • The Direct Method is increasingly used for internal monthly cash flow forecasting. It lists actual cash receipts and cash disbursements (e.g., “Cash received from customers,” “Cash paid to suppliers,” “Cash paid for salaries”). This provides a more accurate picture of daily liquidity. Under IFRS, companies are encouraged to use the Direct Method, though it is rarely used in practice due to the difficulty of collecting the data.

• The “Cash Flow Waterfall” (Phasing): The model must phase revenues, costs, and working capital based on historical cash collection patterns. For example, if 80% of customers pay within 30 days and 20% pay within 60 days, the monthly cash receipts schedule must reflect this lag.

• The “Minimum Cash Balance” Constraint: The cash flow budget must include a minimum operating cash balance (e.g., 2 months of operating expenses). If the model projects cash dropping below this minimum, it triggers a “liquidity event,” requiring the company to draw down its revolving credit facility or delay CAPEX.

3. Covenant Compliance and Liquidity Ratios:
The cash flow budget is not just an internal document; it is often provided to lenders to demonstrate compliance with loan covenants.

• The Debt Service Coverage Ratio (DSCR): (EBITDA - Cash Taxes - Maintenance CAPEX) / (Principal Repayments + Interest Expense). European banks require a DSCR of at least 1.25x. If the budget projects a DSCR below 1.25x, the model must flag a potential covenant breach, prompting the management to reduce leverage or increase profitability.

• The Cash Flow Leverage Ratio: Total Debt / Operating Cash Flow. A ratio above 6.0x is considered highly leveraged and risky in both US and European credit markets.

• The “Covenant Headroom” Analysis: The budget calculates the “headroom” (the difference between the projected ratio and the covenant threshold). If the headroom is less than 10%, the model must alert the treasury team to negotiate covenant waivers or amend the loan agreement before a technical default occurs.