7.1 Cash vs Profit and Cash Flow Forecasting

Cash vs Profit and Cash Flow Forecasting

In financial and management accounting, cash management is an indispensable core discipline. The classic business maxim "Profit is sanity, cash is reality" captures a fundamental truth: while accounting profit evaluates long-term commercial viability, physical bank cash is the vital operational liquidity required to pay employees, settle supplier invoices, honor bank debt obligations, and pay tax authorities on time.

---

Accounting Profit vs. Cash Flow: The Fundamental Distinction

Under accruals accounting (governed by the matching principle), revenue is recognized when goods or services are delivered to customers, and expenses are matched to the period in which they help generate that revenue—regardless of when cash actually changes hands. In contrast, cash flow measures physical monetary movements into and out of the corporate bank accounts.

---

The Mechanics of Overtrading

One of the most dangerous commercial traps tested in AAT Level 3 MATS is overtrading. Overtrading occurs when a business expands its sales volume rapidly without securing adequate long-term capital or working capital reserves to support the higher operating level.

The Overtrading Collapse Sequence:

1. Sales Order Surge: The business secures large new credit orders, generating impressive top-line revenue and reported accounting profits.
2. Upfront Cash Drain: To fulfill orders, the business must immediately buy raw materials, hire additional labor, and pay utility/operating costs in cash.
3. Credit Collection Delays: Customers demand standard credit terms (e.g. 30 to 60 days). Cash inflows lag significantly behind sales generation.
4. Liquidity Squeeze: Cash outflows for wages and stock exceed cash inflows from past receivables, depleting bank reserves.
5. Insolvency: Despite showing strong net profits on the Income Statement, the business runs out of cash, dishonors supplier payments, bounces payroll, and faces forced liquidation.

---

Reconciling Accounting Profit to Operating Cash Flow

To bridge net accounting profit to operating cash flow, management accountants perform specific non-cash and working capital reconciliations:

$\text{Operating Cash Flow} = \text{Net Profit} + \text{Non-Cash Expenses} - \text{Non-Cash Revenues} + \text{Working Capital Adjustments}$

---

Purpose and Objectives of Cash Flow Forecasting

A cash flow forecast (or cash budget) is a detailed schedule estimating future cash receipts and cash payments over a defined future period (e.g., 6 or 12 months ahead, broken down by month).

Core Management Objectives:

• Deficit Identification: Predicting upcoming cash shortfalls far enough in advance to negotiate bank overdraft limits, arrange short-term loans, or adjust spending.
• Surplus Optimization: Highlighting excess cash reserves to enable short-term interest-bearing investments or accelerate debt reduction.
• Capital Spending Timing: Coordinating major asset acquisitions (property, plant, equipment) with peak cash inflow periods.
• Operational Benchmark: Serving as a budget control tool to monitor actual cash receipts and payments against forecast benchmarks.

Standard Layout of a Cash Flow Forecast:

$\text{Net Cash Flow} = \text{Total Cash Receipts} - \text{Total Cash Payments}$ $\text{Closing Cash Balance} = \text{Opening Cash Balance} + \text{Net Cash Flow}$

Important Rule: The Closing Balance of one month automatically becomes the Opening Balance of the immediately following month. A negative cash balance indicates a bank overdraft requirement.

---

Worked Example 1: Sales Collection Lag Schedule

Scenario: Vanguard Trading Ltd projects total sales revenue for the first four months of the financial year as follows:

• January: £120,000
• February: £150,000
• March: £180,000
• April: £200,000

Historical customer payment patterns indicate:

• 30% of sales are collected in cash during the month of sale.
• 50% of sales are collected in the month following sale (1 month lag).
• 18% of sales are collected in the second month following sale (2 month lag).
• 2% are irrecoverable bad debts and are written off.

Task: Calculate the total cash receipts expected in March and April.

Step-by-Step Calculation:

March Cash Receipts:

1. From March Sales (30%): $30% \times \pounds 180,000 = \pounds 54,000$
2. From February Sales (50%): $50% \times \pounds 150,000 = \pounds 75,000$
3. From January Sales (18%): $18% \times \pounds 120,000 = \pounds 21,600$
4. Total March Cash Receipts: $\pounds 54,000 + \pounds 75,000 + \pounds 21,600 = \pounds 150,600$

April Cash Receipts:

1. From April Sales (30%): $30% \times \pounds 200,000 = \pounds 60,000$
2. From March Sales (50%): $50% \times \pounds 180,000 = \pounds 90,000$
3. From February Sales (18%): $18% \times \pounds 150,000 = \pounds 27,000$
4. Total April Cash Receipts: $\pounds 60,000 + \pounds 90,000 + \pounds 27,000 = \pounds 177,000$

(Note: The 2% bad debt portion generates ZERO cash and is completely omitted from cash receipt lines).

---

Worked Example 2: Master Cash Budget Preparation

Scenario: Apex Logistics Ltd prepares a cash budget for Q2 (April, May, June). The opening bank balance on April 1 is £15,000.

• Projected Cash Receipts: April £110,000 | May £135,000 | June £150,000.
• Materials Purchases: April £50,000 | May £65,000 | June £70,000 (Paid 1 month in arrears; March purchases paid in April were £45,000).
• Labor Wages: April £30,000 | May £35,000 | June £40,000 (Paid in the month incurred).
• Overheads (including £5,000 monthly depreciation): April £25,000 | May £25,000 | June £30,000 (Paid in month incurred).
• Rent: £12,000 paid quarterly in advance in April.
• Equipment Purchase: £20,000 cash paid in May.

Master Cash Forecast Schedule (£):

---

Proactive Management of Forecasted Cash Deficits and Surpluses

When a cash flow forecast highlights an impending cash deficit or surplus, management must take early action:

Deficit Management Strategies:

• Accelerating Cash Inflows: Offer early settlement discounts (e.g. 2/10 net 30) to credit customers, enforce tighter credit limits, or introduce debt factoring.
• Deferring Cash Outflows: Negotiate extended credit terms with key trade payables without damaging relationships; postpone non-critical capital expenditure.
• Securing Pre-Approved Facilities: Establish bank overdraft limits or flexible short-term revolving credit lines prior to the deficit period.

Surplus Management Strategies:

• Interest-Bearing Deposits: Transfer excess funds into money market deposit accounts or short-term treasury bills to earn yield.
• Early Settlement Discounts: Pay trade payables early to capture supplier prompt payment discounts.
• Debt Paydown: Settle high-interest short-term borrowings or overdraft balances to reduce ongoing finance costs.

---

Common AAT Exam Traps

• Exam Trap 1: Including Non-Cash Overhead Items: Candidates frequently forget to strip out depreciation or amortisation from total overhead charges in cash budgets. Always subtract non-cash elements before listing cash payments!
• Exam Trap 2: Including Bad Debt Percentages in Cash Receipts: When 2% of sales are bad debts, calculate receipts based on the collectible 98%. Never include bad debts as a cash inflow!
• Exam Trap 3: Forgetting Opening Balance Roll-Forward: The closing balance of April (£18,000) MUST become the opening balance of May. Failing to link balances ruins all subsequent closing totals.
• Exam Trap 4: Misinterpreting Advance / Arrears Payment Timing: Quarterly rent paid in advance in April covers April, May, and June—so May and June rent cash lines must be £0.