Study guide

5.4 Cash Budgets & Cash Flow Forecasting

CIMA BA2: Fundamentals of Management Accounting Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: The Context of Management Accounting

1.1 The Need for Management Accounting, the GMAP Definition & Comparison with Financial Accounting 1.2 Qualities of Good Management Information: From Data to Decisions 1.3 Information for Operational, Managerial and Strategic Levels 1.4 The Role of the Management Accountant: CIMA's View, IFAC's Domain & Position in the Organisation 1.5 CIMA as a Professional Body: Members, Candidates, the Profession & Society

2 Chapter 2: Cost Identification, Classification and Behaviour

2.1 Cost Classification by Nature, Function, and Element 2.2 Cost Behaviour Patterns and Relevant Range 2.3 The High-Low Method and Cost Prediction 2.4 Scattergraph and Least-Squares Regression for Cost Estimation

3 Chapter 3: Overheads and Absorption Costing

3.1 Production Overheads: Allocation and Apportionment 3.2 Overhead Absorption Rates (OAR) & Under/Over-Absorption

4 Chapter 4: Marginal Costing, Profit Reconciliation and Cost-Based Pricing

4.1 Marginal Costing vs Absorption Costing Principles 4.2 Reconciling Marginal and Absorption Costing Operating Profits 4.3 Pricing with Cost Information: Full-Cost-Plus, Marginal-Cost-Plus, Mark-Ups, Margins and Return Targets

5 Chapter 5: Budget Preparation: Functional, Master and Cash Budgets

5.1 Purposes of Budgeting & The Budgeting Process 5.2 The Principal Budget Factor & Functional Budgets 5.3 The Master Budget: Budgeted Profit or Loss, Financial Position and Cash Flow 5.4 Cash Budgets & Cash Flow Forecasting

6 Chapter 6: Budgetary Control: Flexible Budgets, Behaviour and Budgeting Approaches

6.1 Fixed vs Flexible Budgeting and Budget Flexing 6.2 Budgetary Control Systems, Participation & Behavioural Aspects 6.3 Alternative Budgeting Approaches: Incremental, ZBB & Rolling Budgets

7 Chapter 7: Standard Costing and Cost Variances

7.1 Standard Costing Principles and Types of Standards 7.2 Direct Material Price and Usage Variances 7.3 Direct Labour Rate, Efficiency, and Idle Time Variances 7.4 Variable and Fixed Overhead Variances

8 Chapter 8: Sales Variances, Operating Statements and Interpreting Variances

8.1 Sales Variances and Operating Statements (Marginal and Absorption Formats) 8.2 Interpreting Variances: Causes, Interrelationships and Deciding What to Investigate

9 Chapter 9: Performance Measurement

9.1 The Need for Performance Measures: Responsibility Accounting, Controllability and Service Industries 9.2 Financial and Non-Financial Performance Measures in Manufacturing and Service Organisations

10 Chapter 10: Integrated Accounts, Job and Batch Costing and Management Reports

10.1 Integrating Cost and Financial Accounts: Control Accounts and the Manufacturing Account 10.2 Integrated Ledgers with Under- and Over-Absorption and Standard Cost Variances 10.3 Job and Batch Costing: Job Cost Cards, Job Accounts and Pricing a Job 10.4 Cost Reports for Manufacturing, Service and Not-for-Profit Organisations

11 Chapter 11: Risk, Probability and Statistics for Decision-Making

11.1 Risk, Uncertainty and Probability: Rules and Joint Probabilities for Decisions 11.2 Expected Values, Expected Value Tables and Their Limitations 11.3 Averages and Dispersion: Mean, Median, Mode, Range, Variance, Standard Deviation and Coefficient of Variation 11.4 The Normal Distribution: Z-Scores, Normal Distribution Tables and Business Probabilities

12 Chapter 12: Relevant Costing and Short-Term Decisions

12.1 Relevant Cost Concepts: Future, Incremental, and Opportunity Costs 12.2 Relevant Costs of Materials, Labour, and Overheads 12.3 Short-Term Operational Decisions: Make-or-Buy, Shutdowns, Special Orders

13 Chapter 13: Breakeven Analysis and Limiting Factor Analysis

13.1 Single-Product Break-Even Analysis & Margin of Safety 13.2 Target Profit Calculations, Operating Gearing & CVP Assumptions 13.3 Multi-Product CVP Analysis & Break-Even Charts 13.4 Limiting Factor Analysis (Key Factor Analysis)

14 Chapter 14: Long-Term Decisions: Time Value of Money, Payback, NPV and IRR

14.1 Time Value of Money: Compounding, Discounting, Annuities & Perpetuities 14.2 Payback Period Method: Constant and Uneven Cash Flows 14.3 Net Present Value (NPV): Methodology and Decision Rules 14.4 Internal Rate of Return (IRR) and Interpolation

5.4 Cash Budgets & Cash Flow Forecasting

Key Takeaways Explain This Topic AI

Cash solvency and accounting profit are fundamentally distinct; profitable enterprises frequently face insolvency through overtrading and cash flow timing mismatches.

Cash budgets incorporate only actual cash inflows and outflows, strictly excluding non-cash accounting adjustments such as depreciation, bad debt provisions, and paper disposal profits.

Credit sales and supplier credit create timing lags between revenue/cost recognition and actual liquid cash settlement, requiring detailed debtor and creditor payment lag profiles.

Management must proactively address projected cash deficits through short-term financing (overdrafts, debt factoring) or operational adjustments, while deploying temporary surpluses in short-term money market instruments.

Last updated: September 2026

Cash is the ultimate liquidity constraint of any commercial enterprise. While an organization can survive for extended periods while reporting accounting losses, it cannot survive for a single day if it runs out of cash and cannot meet its statutory liabilities, employee payroll, or supplier commitments as they fall due.

A cash budget is a detailed estimate of cash receipts and payments over a defined future period, showing the resulting projected cash balance. The cash budget is one of the most critical operational schedules within the Master Budget, serving as an early-warning radar for liquidity deficits and cash surpluses.

Accounting Profit vs. Cash Solvency: The Danger of Overtrading

A fundamental tenet of financial and management accounting is that profit does not equal cash :

Profitability (Accrual Concept): Under International Financial Reporting Standards (IFRS) and accrual accounting, revenues are recognized when performance obligations are satisfied (invoiced), and expenses are recognized when incurred, regardless of when cash physically moves.

Solvency (Cash Flow Concept): Solvency depends strictly on liquid cash balances available to discharge immediate legal liabilities.

Why Profitable Companies Fail: The Overtrading Trap

Rapidly growing companies frequently plunge into insolvency through overtrading (also termed under-capitalization ):

The business successfully secures massive new customer sales orders, generating large projected accounting profits.

To fulfill these orders, the business must immediately disburse cash to buy raw materials, pay shop-floor wages, and fund delivery logistics.

The commercial customers demand 30 to 60 days credit; trade receivables balloon on the balance sheet, but no cash has arrived.

Meanwhile, trade suppliers demand payment, workers demand weekly wages, and tax authorities demand corporation tax.

The business exhausts its liquid cash and credit lines. Despite reporting record profits on paper, the company becomes technically insolvent and is forced into administration.

Important

Management accountants summarize this operational reality with the classic commercial maxim: "Profit is an opinion, but cash is a fact." A business must manage cash flow with equal or greater rigor than accounting profit.

Structure and Components of the Cash Budget

A standard cash budget classifies cash flows into chronological monthly or quarterly columns across four distinct operational streams:

Operating Cash Receipts:

Cash sales collected immediately.

Collections from credit customers (trade receivables) reflecting specific credit payment lag patterns.

Sundry operating receipts (scrap material sales, licensing royalties received).

Operating Cash Disbursements:

Payments to trade payables for raw material purchases.

Cash disbursements for direct labour wages and supervisory salaries.

Cash payments for factory variable overheads, administrative rent, utilities, and sales commissions.

Capital Transactions:

Cash outflows for purchasing property, plant, machinery, or IT infrastructure ( Capital Expenditure ).

Cash inflows from the sale or disposal of obsolete non-current assets (gross cash proceeds received).

Taxation and Financing:

Corporation tax payments (typically paid in lump-sum quarterly installments according to statutory tax calendars).

Dividend payments distributed to equity shareholders.

Cash inflows from new bank loans or equity share issues.

Cash outflows for loan interest payments and loan principal repayments.

The Balancing Mechanism Net Cash Flow for Period = Total Cash Receipts − Total Cash Disbursements \text{Net Cash Flow for Period} = \text{Total Cash Receipts} - \text{Total Cash Disbursements} Net Cash Flow for Period = Total Cash Receipts − Total Cash Disbursements Closing Cash Balance = Opening Cash Balance + Net Cash Flow for Period \text{Closing Cash Balance} = \text{Opening Cash Balance} + \text{Net Cash Flow for Period} Closing Cash Balance = Opening Cash Balance + Net Cash Flow for Period

The closing cash balance of the current month automatically becomes the opening cash balance of the subsequent month.

Absolute Exclusion of Non-Cash Accounting Items

A common exam point is the identification of non-cash accounting adjustments . Because the cash budget measures only the physical movement of currency into and out of enterprise bank accounts, all non-cash accounting entries must be strictly excluded :

Accounting Item Accounting P&L Treatment Cash Budget Treatment Operational Rationale

Depreciation & Amortisation Deducted as an operating expense to reflect asset consumption over time. Completely Excluded Depreciation is a non-cash internal cost allocation; no cash leaves the bank account when an asset depreciates.

Allowance for Bad & Doubtful Debts Deducted as an administrative expense in the statement of profit or loss. Completely Excluded An accounting provision is a book entry. In cash budgets, bad debts are reflected simply by not collecting cash from credit customers.

Profit or Loss on Asset Disposal Included in operating profit as the difference between net disposal proceeds and carrying book value. Completely Excluded The accounting profit/loss is a book calculation. The cash budget records only the actual gross cash proceeds received from the buyer under cash receipts.

Credit Sales Invoiced Recognized immediately in total revenue when goods are delivered. Timing Lag Applied Recorded only when cash is collected from customers in according months.

Raw Material Purchases Recorded in cost of sales / inventory when goods are received. Timing Lag Applied Recorded only when payments are disbursed to suppliers according to credit terms.

Corporate Tax Accruals Accrued smoothly across monthly accounting periods. Lump-Sum Disbursed Recorded strictly in the specific calendar month when the bank transfer to tax authorities occurs.

Modelling Cash Flow Timing: Debtor Lags and Settlement Discounts

In commercial practice, credit customers do not pay on the day of delivery. Management accountants model customer collection patterns using historical payment profiles:

Debtor Payment Lag Structure

Assume an enterprise generates credit sales where historical data indicates:

25% of customers pay in the month of sale, capturing a 2% prompt settlement cash discount.

50% pay in the month following the sale (Month M + 1 M+1 M + 1 ).

23% pay in the second month following the sale (Month M + 2 M+2 M + 2 ).

2% of credit sales represent irrecoverable bad debts that are never collected. Cash Collected in Month M = ( Month M Credit Sales × 25 % × 0.98 ) + ( Month M − 1 Sales × 50 % ) + ( Month M − 2 Sales × 23 % ) \text{Cash Collected in Month } M = (\text{Month } M \text{ Credit Sales} \times 25\% \times 0.98) + (\text{Month } M-1 \text{ Sales} \times 50\%) + (\text{Month } M-2 \text{ Sales} \times 23\%) Cash Collected in Month M = ( Month M Credit Sales × 25% × 0.98 ) + ( Month M − 1 Sales × 50% ) + ( Month M − 2 Sales × 23% )

Note

Irrecoverable bad debts (the 2%) are permanently lost; they never appear in any cash collection calculation. Notice also that the 2% settlement discount reduces the cash inflow received by the enterprise: if a customer owes $10,000 and takes a 2% discount, the cash budget records $ 10 , 000 × 0.98 = $ 9 , 800 \text{\textdollar}10,000 \times 0.98 = \text{\textdollar}9,800 $ 10 , 000 × 0.98 = $ 9 , 800 .

Comprehensive Worked Multi-Month Cash Budget: Meridian Technologies Ltd

Meridian Technologies Ltd is preparing its quarterly cash budget for April, May, and June . The management accountant compiles the following operating forecasts:

1. Sales Forecasts (Actual and Projected):

  • February (Actual): $100,000
  • March (Actual): $120,000
  • April (Forecast): $140,000
  • May (Forecast): $160,000
  • June (Forecast): $180,000

2. Customer Credit Terms and Payment Patterns:

25% of total sales are cash sales, collected immediately in the month of sale.

The remaining 75% are credit sales, collected as follows:

60% collected in the month following the sale ( M + 1 M+1 M + 1 ).

38% collected in the second month following the sale ( M + 2 M+2 M + 2 ).

2% are irrecoverable bad debts.

3. Material Purchases and Supplier Credit Terms:

Raw material purchases: March (Actual) $50,000; April $60,000; May $70,000; June $75,000.

Trade suppliers extend one month of credit (all purchases are paid in full in Month M + 1 M+1 M + 1 ).

4. Payroll and Operating Expenses:

Direct wages: April $30,000; May $34,000; June $36,000 (paid in the month incurred).

Variable overheads: April $15,000; May $18,000; June $20,000 (paid in the month incurred).

Fixed overheads: $17,000 per month, which includes $5,000 monthly plant depreciation. The balance ($12,000 cash overhead) is paid in the month incurred.

5. Capital Transactions and Financing:

In April, the company sells an obsolete delivery van for $8,000 cash (carrying book value was $6,000; the $2,000 profit on disposal is an accounting non-cash item).

In May, the company purchases a high-precision CNC milling machine for $50,000 cash.

In June, an interim corporation tax installment of $25,000 is due for payment.

Opening bank cash balance at 1 April is $15,000.

Working 1: Schedule of Customer Cash Collections

First, break down sales into cash sales (25%) and credit sales (75%):

February: Credit Sales = 75 % × $ 100 , 000 = $ 75 , 000 75\% \times \text{\textdollar}100,000 = \text{\textdollar}75,000 75% × $ 100 , 000 = $ 75 , 000

March: Credit Sales = 75 % × $ 120 , 000 = $ 90 , 000 75\% \times \text{\textdollar}120,000 = \text{\textdollar}90,000 75% × $ 120 , 000 = $ 90 , 000

April: Cash Sales = 25 % × $ 140 , 000 = $ 35 , 000 25\% \times \text{\textdollar}140,000 = \text{\textdollar}35,000 25% × $ 140 , 000 = $ 35 , 000 ; Credit Sales = 75 % × $ 140 , 000 = $ 105 , 000 75\% \times \text{\textdollar}140,000 = \text{\textdollar}105,000 75% × $ 140 , 000 = $ 105 , 000

May: Cash Sales = 25 % × $ 160 , 000 = $ 40 , 000 25\% \times \text{\textdollar}160,000 = \text{\textdollar}40,000 25% × $ 160 , 000 = $ 40 , 000 ; Credit Sales = 75 % × $ 160 , 000 = $ 120 , 000 75\% \times \text{\textdollar}160,000 = \text{\textdollar}120,000 75% × $ 160 , 000 = $ 120 , 000

June: Cash Sales = 25 % × $ 180 , 000 = $ 45 , 000 25\% \times \text{\textdollar}180,000 = \text{\textdollar}45,000 25% × $ 180 , 000 = $ 45 , 000 ; Credit Sales = 75 % × $ 180 , 000 = $ 135 , 000 75\% \times \text{\textdollar}180,000 = \text{\textdollar}135,000 75% × $ 180 , 000 = $ 135 , 000

  • Collection Stream April May June
  • Immediate Cash Sales (25%) $35,000 $40,000 $45,000

Debtors: Month M + 1 M+1 M + 1 (60% of prior month credit sales) $ 90 , 000 × 60 % = $ 54 , 000 \text{\textdollar}90,000 \times 60\% = \text{\textdollar}54,000 $ 90 , 000 × 60% = $ 54 , 000 $ 105 , 000 × 60 % = $ 63 , 000 \text{\textdollar}105,000 \times 60\% = \text{\textdollar}63,000 $ 105 , 000 × 60% = $ 63 , 000 $ 120 , 000 × 60 % = $ 72 , 000 \text{\textdollar}120,000 \times 60\% = \text{\textdollar}72,000 $ 120 , 000 × 60% = $ 72 , 000

Debtors: Month M + 2 M+2 M + 2 (38% of 2-month prior credit sales) $ 75 , 000 × 38 % = $ 28 , 500 \text{\textdollar}75,000 \times 38\% = \text{\textdollar}28,500 $ 75 , 000 × 38% = $ 28 , 500 $ 90 , 000 × 38 % = $ 34 , 200 \text{\textdollar}90,000 \times 38\% = \text{\textdollar}34,200 $ 90 , 000 × 38% = $ 34 , 200 $ 105 , 000 × 38 % = $ 39 , 900 \text{\textdollar}105,000 \times 38\% = \text{\textdollar}39,900 $ 105 , 000 × 38% = $ 39 , 900

  • Total Operating Customer Receipts $117,500 $137,200 $156,900
  • Working 2: Schedule of Cash Disbursements

Payments for Purchases (Month M + 1 M+1 M + 1 ):

  • April pays March purchases: $50,000
  • May pays April purchases: $60,000
  • June pays May purchases: $70,000

Cash Fixed Overheads:

Fixed overheads = $ 17 , 000 − $ 5 , 000 (depreciation) = $ 12 , 000 \text{\textdollar}17,000 - \text{\textdollar}5,000 \text{ (depreciation)} = \text{\textdollar}12,000 $ 17 , 000 − $ 5 , 000 (depreciation) = $ 12 , 000 per month.

The Completed Master Cash Budget Statement

  • Budget Line Item April May June
  • Opening Cash Balance $15,000 $33,500 –$3,300

Receipts:

  • Cash Sales $35,000 $40,000 $45,000
  • Collections from Credit Debtors $82,500 $97,200 $111,900
  • Sale of Delivery Van (Gross Proceeds) $8,000 — —
  • Total Cash Receipts $125,500 $137,200 $156,900

Disbursements:

  • Payments to Trade Creditors (Materials) $50,000 $60,000 $70,000
  • Direct Labour Payroll $30,000 $34,000 $36,000
  • Variable Production Overheads $15,000 $18,000 $20,000
  • Cash Fixed Overheads (excluding depreciation) $12,000 $12,000 $12,000
  • Capital Expenditure (CNC Milling Machine) — $50,000 —
  • Corporation Tax Installment — — $25,000
  • Total Cash Disbursements $107,000 $174,000 $163,000
  • Net Monthly Cash Flow +$18,500 –$36,800 –$6,100
  • Closing Cash Balance +$33,500 –$3,300 –$9,400
  • Managing Cash Deficits and Surpluses

The cash budget reveals that Meridian Technologies operates with a comfortable cash surplus of $33,500 at the end of April, but plunges into an overdraft deficit of –$3,300 in May , which deepens to –$9,400 in June due to the capital equipment purchase and tax liability.

Management must adopt proactive strategies based on whether cash shortfalls or surpluses are short-term or long-term:

Financial Condition Short-Term Operational Strategy Long-Term Strategic Strategy

Cash Deficit (Shortfall) - Arrange an authorized bank overdraft facility to absorb fluctuations.; - Offer prompt settlement discounts to accelerate debtor receipts.; - Utilize debt factoring or invoice discounting for immediate liquid cash.; - Negotiate extended credit terms with cooperative suppliers.; - Postpone non-critical discretionary capital expenditure. - Issue new equity share capital to institutional investors.; - Secure long-term debentures or fixed-rate bank loans.; - Execute sale-and-leaseback agreements on corporate property.; - Divest non-core, loss-making business units or product lines.

Cash Surplus (Excess Liquidity) - Invest surplus cash in short-term money market deposits or Treasury bills.; - Take advantage of supplier early settlement discounts.; - Pre-purchase raw material buffer stocks to hedge expected price rises. - Fund positive Net Present Value (NPV) capital growth projects.; - Repay expensive long-term debt early to de-gear the corporate balance sheet.; - Increase dividend distributions or execute share buyback programmes.; - Pursue strategic mergers or corporate acquisitions.

Tip

In examination scenario evaluations, always apply the Matching Principle : Short-term cash deficits (like seasonal working capital fluctuations or temporary capital disbursements) should be financed with short-term flexible debt (such as an overdraft). Long-term deficits must never be funded with overdrafts, which are repayable on demand; they require long-term capital (equity or long-term loans).

Loading diagram... Cash Budget Architecture and Liquidity Decision Dynamics