5.2 Financial Budgets & Cash Flow Forecasting

Financial Budgets & Cash Flow Forecasting

Operational budgets quantify the physical activities of an enterprise—units manufactured, hours worked, and kilograms of material processed. However, operational success does not guarantee commercial survival. An enterprise can report robust operating profits on an accrual accounting basis while simultaneously spiraling into technical insolvency due to acute cash flow deficits—a phenomenon frequently termed overtrading. The financial budgets represent the culmination of the master budget process, translating operational plans into projected cash flows, liquidity positions, and pro forma financial statements.

---

The Architecture of the Cash Budget

The cash budget projects cash receipts and disbursements over specified time horizons (monthly or quarterly), enabling management to anticipate cash shortages, plan external borrowings, optimize short-term cash investments, and ensure compliance with debt covenants.

A rigorous cash budget comprises four discrete sections:

1. Total Cash Receipts (Inflows): Projected cash collections from customers, cash sales, receipts from accounts receivable factoring, asset divestments, investment income, and capital injections.
2. Total Cash Disbursements (Outflows): Projected cash expenditures for direct materials (settlement of trade payables), payroll payments, manufacturing overhead disbursements, operating expenses, capital expenditures (CapEx), income tax payments, and shareholder dividends. Non-cash expenses—most notably depreciation and asset impairment charges—must be excluded.
3. Net Operating Cash Flow (Surplus or Deficiency): Total cash receipts minus total cash disbursements. Adding the beginning cash balance determines the net cash position before financing.
4. Financing Section: If the projected cash balance falls below management's mandatory minimum operating cash balance, the financing section specifies the required short-term borrowings (e.g., revolving credit facility drawdowns) and associated interest charges. Conversely, if an excess exists, it models debt repayments or temporary liquid investments.

$$\text{Ending Cash Balance} = \text{Beginning Cash} + \text{Cash Receipts} - \text{Cash Disbursements} \pm \text{Net Financing Movements}$$

---

Modeling Cash Receipts: Debtor Collection Patterns

In business-to-business (B2B) and retail operations with credit accounts, revenue does not equal immediate cash inflow. Management accountants construct an accounts receivable collection matrix to model collection timing, prompt-payment cash discounts, and uncollectible debts.

Consider an enterprise where 80% of sales are on credit, and historical credit collection patterns demonstrate:

• 60% collected in the month of sale (with customers taking advantage of a 2% settlement discount for payment within 10 days).
• 30% collected in the first month following sale.
• 7% collected in the second month following sale.
• 3% proved uncollectible (bad debt written off).

If total sales in March are $500,000 (credit sales = $400,000), cash collected in March from March sales is:

$$\text{Cash Collected (March Sales)} = \text{\textdollar}400,000 \times 60\% \times (1 - 0.02) = \text{\textdollar}240,000 \times 0.98 = \text{\textdollar}235,200$$

The $4,800 discount reduces the first collection; the remaining credit-sale balance is collected later or written off. Do not confuse the discount with the remaining receivable. The discount is a reduction in the proceeds, while $120,000 (30%) is collected in April and $28,000 (7%) in May.

---

The Cash Conversion Cycle (CCC)

Working capital management directly governs cash flow velocity. The Cash Conversion Cycle (CCC) quantifies the time span (in days) required for an enterprise to convert its cash investments in raw materials and operational inputs back into cash inflows from customer collections:

$$CCC = \text{Days Inventory Outstanding (DIO)} + \text{Days Sales Outstanding (DSO)} - \text{Days Payable Outstanding (DPO)}$$

Where:

$$\text{Days Inventory Outstanding (DIO)} = \frac{\text{Average Inventory}}{\text{Cost of Goods Sold}} \times 365$$ $$\text{Days Sales Outstanding (DSO)} = \frac{\text{Average Accounts Receivable}}{\text{Total Credit Sales}} \times 365$$ $$\text{Days Payable Outstanding (DPO)} = \frac{\text{Average Accounts Payable}}{\text{Total Credit Purchases}} \times 365$$

Strategic Implications of the CCC

• Compressing the CCC: Reducing DIO through Just-in-Time (JIT) inventory management or compressing DSO via stringent credit control accelerates liquidity generation, reducing working capital financing costs.
• Extending DPO: Delaying supplier payments increases DPO and shortens the CCC. However, excessive extension risks damaging supplier goodwill, losing early payment discounts, or triggering credit holds.
• Negative CCC: Working capital powerhouses (such as Dell or Amazon) maintain a negative CCC by collecting customer cash before paying suppliers, effectively financing their daily operations using supplier credit.

---

Cash Budget vs. Accrual Statements Comparison

---

Pro Forma Financial Statements

Once the operating schedules and cash budget are synthesized, management prepares three integrated pro forma (budgeted) financial statements:

1. Budgeted Statement of Profit or Loss (Income Statement): Evaluates projected operational profitability. It combines budgeted sales revenue, budgeted absorption COGS, selling and administrative expenses, financing charges (derived from cash budget borrowings), and income tax expense.
2. Budgeted Statement of Financial Position (Balance Sheet): Projects the enterprise's asset structure, financial leverage, and net worth at the close of the budget period:
   • Current Assets: Closing cash (from cash budget), closing receivables (uncollected sales), and closing inventories (from DM and FG budgets).
   • Non-Current Assets: Opening property, plant, and equipment (PP&E) plus budgeted CapEx minus budgeted depreciation.
   • Liabilities: Closing accounts payable (unpaid purchases), accrued expenses, tax liabilities, and outstanding short/long-term debt.
   • Equity: Opening share capital and retained earnings plus budgeted net profit after tax minus budgeted dividend declarations.
3. Budgeted Statement of Cash Flows: Formats cash movements into Operating, Investing, and Financing activities in compliance with international reporting standards (AASB 107 / IAS 7), demonstrating the sources and applications of liquidity.

---

Corporate Application: Tasman Medical Supplies Pty Ltd

Tasman Medical Supplies Pty Ltd is a distributor of specialized clinical diagnostic kits. The management accountant is finalizing the cash budget for Quarter 2 (spanning April, May, and June).

Forecasted Operational Data

1. Monthly Sales Revenue:
   • February (Actual): $400,000
   • March (Actual): $500,000
   • April (Budget): $600,000
   • May (Budget): $750,000
   • June (Budget): $900,000
   • July (Budget): $650,000
2. Sales Terms & Debtor Collection Profile:
   • 20% of sales are cash transactions settled immediately.
   • 80% of sales are credit sales. Historical collections follow:
     • 60% collected in the month of sale (customers receive a 2% prompt settlement discount).
     • 30% collected in the month following the sale.
     • 8% collected in the second month following the sale.
     • 2% uncollectible bad debts.
3. Purchases & Disbursements:
   • Merchandise purchases equal 65% of the next month's sales revenue. Creditors are paid 100% in the month following purchase.
   • Monthly warehouse operating expenses: $85,000 (including $15,000 monthly depreciation).
   • Monthly sales commissions: 4% of current month's sales revenue, paid in cash during the month.
   • Corporate income tax quarterly installment of $65,000 is due in May.
   • Capital expenditure: Specialized cold-storage refrigeration unit costing $120,000 will be acquired and paid for in April.
4. Financing & Liquidity Policy:
   • Beginning cash balance on 1 April: $45,000.
   • Policy requires a minimum ending cash balance of $40,000 at the end of each month.
   • The company maintains a revolving line of credit. Borrowings and repayments must occur in increments of $10,000. Interest is charged at 1% per month on outstanding loan balances at the start of the month and is paid in cash at month-end. Outstanding loan balance on 1 April is $0.

Schedule 1: Collections from Credit Sales

• Credit Sales: Feb: $320,000; Mar: $400,000; Apr: $480,000; May: $600,000; June: $720,000.

Calculations for April: Cash sales: 20% × $600,000 = $120,000. April credit: 480,000 × 60% × 0.98 = $282,240. March credit: 400,000 × 30% = $120,000. February credit: 320,000 × 8% = $25,600. Total April = $547,840.

Schedule 2: Merchandise Purchases & Supplier Payments

• March Purchases (paid in April): 65% × $600,000 = $390,000.
• April Purchases (paid in May): 65% × $750,000 = $487,500.
• May Purchases (paid in June): 65% × $900,000 = $585,000.

Schedule 3: Master Cash Budget for Quarter 2

In April, borrowing of $60,000 raises the pre-financing deficit of $11,160 above the $40,000 minimum. In May, opening cash must equal April's $48,840 closing cash. Interest is 1% of the opening $60,000 loan. Assume the company repays as much as possible in $10,000 increments: it can repay $30,000 and retain $44,540. June therefore opens with $44,540 cash and $30,000 debt; interest is $300. Paying off the remaining loan leaves $145,000. Quarter-end cash also reconciles as 45,000 + 2,048,400 − 1,948,400 + 60,000 − 60,000 = 145,000. The quarterly pre-financing position uses only the quarter's opening cash, not a sum of monthly cash balances.

---

Exam Traps to Avoid