Cash Flow Management

Chapter 5
Cash Budgeting and Short-Term Liquidity Planning

Graduate Program in Entrepreneurship
Cash Flow Management   •   Graduate

Cash Budgeting and Short-Term Liquidity Planning

Introduction

Cash is the operating resource that allows an entrepreneurial firm to pay employees, suppliers, lenders, tax authorities, and owners when obligations fall due. A profitable enterprise can nevertheless fail if cash receipts arrive after payments are required. Cash budgeting therefore converts operating assumptions into a time-phased plan for liquidity. It is not merely a record of expected bank balances; it is a decision system for identifying funding gaps, prioritising payments, negotiating terms, and preserving financial resilience.

This chapter develops a practical framework for daily, weekly, monthly, and 13-week cash budgets. It addresses minimum cash balances, payment priorities, tax obligations, contingency reserves, forecasting uncertainty, governance, and technology-supported implementation.

Learning Objectives

By the end of this chapter, students should be able to:

  1. Distinguish cash budgeting from accrual accounting and profit forecasting.
  2. Construct daily, weekly, monthly, and 13-week cash forecasts.
  3. Calculate minimum operating cash requirements and funding gaps.
  4. Classify and prioritise payments under liquidity pressure.
  5. Incorporate payroll, tax, debt-service, and other statutory obligations.
  6. Design contingency reserves and scenario-based liquidity plans.
  7. Evaluate forecast accuracy, controls, ethics, and technology-enabled cash management.

1. Cash Budgeting as a Management System

A cash budget estimates cash inflows, cash outflows, and the resulting cash position over a specified horizon. The basic cash-flow identity is:

Ct = Ct−1 + It − Ot + Ft

where Ct is closing cash in period t, Ct−1 is opening cash, It is operating and investing cash inflows, Ot is operating and investing cash outflows, and Ft is net financing cash flow. All variables must be measured in the same currency and period.

A cash budget differs from an income statement. Revenue may be recognised when earned, while cash may be collected later. Similarly, an expense may be recognised before it is paid. Depreciation affects profit but not current cash; loan principal affects cash but is not an operating expense in the income statement. The cash budget must therefore model actual payment and receipt dates.

A useful budgeting architecture has three layers:

LayerMain questionTypical horizon
Strategic liquidity planHow much liquidity and funding capacity does the business require?12–36 months
Rolling cash forecastWhat cash will be available and required soon?13 weeks
Operating cash scheduleWhat must be collected or paid on each date?Daily, weekly, monthly

The 13-week forecast is particularly valuable because it is long enough to reveal recurring payroll, tax, rent, debt, and supplier cycles while remaining sufficiently short for managers to estimate individual transactions with reasonable confidence.

2. Forecast Structure and Time Granularity

Daily cash budgets

Daily budgets are appropriate when cash is scarce, receipts are volatile, or large payments have precise due dates. They should include opening bank balances, expected receipts by date, scheduled payments, financing movements, and the resulting closing balance. A daily schedule may be maintained for the next 30 to 45 days and then rolled forward each business day.

Daily forecasting is most useful for:

  • payroll and payroll-tax dates;
  • supplier payments and direct debits;
  • loan instalments;
  • tax remittances;
  • settlement of card or online-platform receipts; and
  • monitoring whether the minimum cash balance will be breached.

Weekly cash budgets

Weekly budgets balance detail with manageability. They are often the core format of a 13-week forecast. Each week should contain beginning cash, collections, other inflows, payments by category, financing, ending cash, and headroom above the minimum balance.

Monthly cash budgets

Monthly budgets support management accounts, board reporting, annual planning, and lender communication. Monthly forecasts are less precise about payment timing than daily forecasts but are useful for identifying seasonal working-capital requirements and evaluating the adequacy of committed facilities.

3. Building a 13-Week Cash Forecast

A disciplined forecast follows a transaction-based process rather than applying a broad percentage to revenue.

Step 1: Establish the opening position

Reconcile all bank accounts, petty cash, payment-platform balances, and restricted cash. Exclude restricted funds from available liquidity unless they can legally and practically be used. The opening balance should agree with bank statements and the accounting ledger after reconciling outstanding items.

Step 2: Forecast cash receipts

Receipts should be estimated from identifiable sources, including:

  • customer invoices and expected collection dates;
  • point-of-sale and online sales;
  • subscriptions and recurring payments;
  • grants, refunds, and insurance proceeds;
  • asset disposals; and
  • committed equity or debt funding.

For credit sales, a simple collection model can be used. If sales in period t are collected immediately at rate p0, one period later at rate p1, and two periods later at rate p2, expected collections in period t are:

Rt = p0 St + p1 St−1 + p2 St−2

Here St is credit sales in period t, Rt is cash collected, and p0 + p1 + p2 = 1 if all sales are eventually collected within the model. The rates must be based on historical evidence or a documented managerial assumption. The model should be adjusted for bad debts, disputes, seasonality, and customer-specific payment behaviour.

Step 3: Forecast cash payments

Payments should be classified by timing and controllability. Common categories are payroll, payroll taxes, suppliers, rent, utilities, marketing, capital expenditure, loan interest, loan principal, income taxes, sales taxes, insurance, and owner distributions.

The forecast should use contractual due dates, not merely invoice dates. Where a supplier historically receives payment after the contractual due date, that behaviour may be observed but should not be treated as a permanent financing strategy without governance approval.

Step 4: Calculate cash headroom

For each period, calculate the surplus above the minimum cash balance:

Ht = Ct − Cmin

where Ht is cash headroom and Cmin is the approved minimum cash balance. A negative value indicates a projected breach and requires action.

A funding requirement can be expressed as:

Gt = max(0, Cmin − Ct)

where Gt is the minimum additional funding required in period t, assuming no other corrective action. This formula identifies the size of a gap, not the preferred financing solution.

Step 5: Review, challenge, and roll forward

Every week, compare actual results with the prior forecast. Investigate material variances, replace outdated assumptions, and extend the forecast by one week. A forecast that is not updated from actual information soon becomes a historical document rather than a management tool.

4. Minimum Cash Balances and Liquidity Reserves

A minimum cash balance is the amount management deliberately retains to absorb timing uncertainty and protect essential operations. It should not be selected arbitrarily. Relevant factors include:

  • fixed cash commitments during the forecast horizon;
  • volatility of collections and payment timing;
  • access to overdrafts or committed credit;
  • supplier concentration and bargaining power;
  • payroll and statutory obligations;
  • seasonality;
  • business interruption risk; and
  • the cost of holding idle cash.

One practical approach is to define a base operating buffer plus a risk reserve:

Cmin = B + R

where B is the base buffer and R is the contingency reserve. This is a managerial policy equation, not a universal financial law. The base buffer may cover unavoidable payments until the next reliable collection cycle; the reserve reflects uncertainty and stress exposure.

A more analytical approach estimates a service-level reserve from forecast errors. If forecast error is represented by et = Actualt − Forecastt, managers may examine the distribution of errors and select a percentile consistent with their risk tolerance. For example, a reserve based on a high adverse-error percentile protects against a specified proportion of observed shortfalls. This approach requires sufficient, comparable historical data and should not be used mechanically when the business is changing rapidly.

Contingency reserves may be held as cash, undrawn committed credit, or highly liquid low-risk investments, subject to legal, banking, and treasury policies. Undrawn credit is useful but is not equivalent to cash: a lender may impose covenants, conditions, limits, or cancellation rights.

5. Payment Priorities Under Liquidity Pressure

When available cash is insufficient to pay every obligation, managers need a documented priority framework. A typical hierarchy is:

  1. payments necessary to protect life, safety, and legal compliance;
  2. payroll and legally required payroll remittances;
  3. taxes and other statutory obligations, subject to applicable law;
  4. debt service and payments whose default triggers severe contractual consequences;
  5. critical suppliers whose interruption would stop operations;
  6. essential utilities, insurance, and facilities;
  7. suppliers with lower operational criticality;
  8. discretionary marketing, capital expenditure, bonuses, and owner distributions.

This hierarchy is not a licence to delay creditors improperly. Payment deferrals should be transparent, authorised, consistent with contracts and law, and communicated early. Selectively paying insiders while withholding funds from vulnerable suppliers may create legal, ethical, and reputational risks.

A payment-priority matrix can score each obligation by legal urgency, operational criticality, consequence of default, and availability of alternatives. Qualitative scoring supports judgement but does not replace legal advice or board-approved policy.

6. Tax, Payroll, and Other Non-Discretionary Obligations

Tax obligations are a common source of liquidity failure because sales taxes, payroll taxes, and income taxes may be collected or accrued before their payment dates. The forecast should record the cash date and the tax category separately. A business should not treat taxes collected on behalf of a government as freely available operating cash.

Important controls include:

  • maintaining a tax calendar with filing and payment dates;
  • reconciling tax accounts monthly;
  • separating collected indirect taxes where practical;
  • forecasting payroll taxes with each payroll run;
  • reserving for estimated income-tax instalments; and
  • confirming jurisdiction-specific rules with qualified advisers.

Tax treatment varies by country and entity type. A textbook cash budget cannot determine the legal amount or due date of a particular tax. Managers must consult current legislation and professional advice.

Payroll requires special attention because missed payroll can immediately damage employee welfare, morale, retention, and legal compliance. Payroll should be forecast from approved headcount, pay rates, overtime, commissions, benefits, and statutory deductions rather than from a simple monthly average.

7. Worked Example: A Four-Week Liquidity Schedule

The following illustrative example uses weekly amounts in thousands of currency units. The business begins with cash of 40. Its approved minimum cash balance is 30.

WeekOpening cashReceiptsOperating paymentsTax and payroll remittancesFinancing inflowClosing cashHeadroom
14055381204515
245324118018−12
318704310357040
47048461405828

For week 2:

C2 = 45 + 32 − 41 − 18 + 0 = 18

The projected shortfall against the minimum is:

G2 = max(0, 30 − 18) = 12

The business therefore needs at least 12 of additional liquidity, or an equivalent reduction or deferral of payments, before the end of week 2. The planned financing inflow in week 3 does not solve the week 2 timing problem. Management could accelerate collections, negotiate a documented supplier extension, draw an approved facility, or reschedule discretionary spending. It should not assume that a future inflow automatically covers an earlier breach.

8. Scenario Analysis and Forecast Risk

A single-point forecast can create false confidence. A robust forecast contains at least a base case, downside case, and upside case. The downside case may assume slower customer collections, lower sales, unexpected repairs, higher refund rates, or delayed financing. The assumptions should be explicit and internally consistent.

Sensitivity analysis changes one assumption at a time, such as collection timing. Scenario analysis changes several linked assumptions, such as lower sales combined with slower collections and reduced supplier credit. Reverse stress testing asks: “What combination of events would cause the business to breach its minimum cash balance or debt covenant?”

A simple expected-cash model may be written as:

E[Ct] = Ct−1 + E[It] − E[Ot] + E[Ft]

The notation E[·] means an expected value based on stated probability or forecasting assumptions. Expected cash is not guaranteed cash; a business may need sufficient liquidity for adverse outcomes rather than merely the statistical average.

9. Applied Case: Meridian Meal Kits

Background

Meridian Meal Kits is an illustrative subscription-food enterprise. It has 2,400 customers, weekly card settlements, recurring ingredient purchases, a biweekly payroll, and a monthly sales-tax remittance. Growth has increased revenue but also increased inventory purchases before customer collections are received.

Problem

The finance manager’s monthly forecast showed adequate cash, yet the firm experienced a cash crisis during the second week of each month. The monthly model concealed the timing of payroll, ingredient purchases, and tax payments. The company also treated customer deposits as unrestricted cash and had no formally approved minimum balance.

Analysis

A 13-week forecast was prepared from bank reconciliations, subscription schedules, supplier statements, payroll records, tax calendars, and the loan agreement. The analysis identified three weaknesses:

  1. collections were forecast from invoiced sales rather than actual card-settlement dates;
  2. tax remittances were omitted from the weekly operating schedule; and
  3. the forecast recognised a planned equity investment before the investment agreement was signed.

The corrected base case showed a minimum cash balance below the required operating buffer in week 6. A downside case, involving a one-week collection delay and a 10% ingredient-price increase, produced a larger gap.

Approach and solution

Management adopted the following measures:

  • a rolling 13-week forecast updated every Monday;
  • daily monitoring for the next 21 days;
  • a minimum balance equal to essential payroll, taxes, and one week of critical ingredients;
  • a separate reserve for sales-tax remittances;
  • customer collection monitoring by settlement date;
  • a committed overdraft used only under an approved draw policy; and
  • a payment matrix distinguishing critical ingredients from discretionary expenditure.

The company negotiated a supplier schedule aligned with card settlements, postponed nonessential equipment purchases, and obtained a signed—not merely anticipated—equity commitment.

Outcome

The revised system revealed the timing problem before the next crisis. Meridian maintained payroll and tax compliance, reduced emergency borrowing, and improved the credibility of its lender reporting. The business did not eliminate uncertainty; it made uncertainty visible and governable.

Learning points

The case demonstrates that growth can increase liquidity risk, monthly profitability can conceal weekly cash deficits, and forecast integrity depends on verified dates and commitments. A cash budget is effective only when linked to decisions, controls, and accountable owners.

10. Governance, Technology, and Ethical Practice

Cash forecasting should have clear ownership. The preparer gathers evidence; the operations team validates timing; the finance manager challenges assumptions; and senior management approves funding and minimum-balance policies. Segregation of duties is important: the person creating payment instructions should not have unrestricted authority to approve and release them.

Technology can import bank transactions, match receipts to invoices, identify recurring payments, and produce rolling forecasts. Machine-learning tools may detect patterns in collection timing or forecast errors, but they require clean data, stable definitions, and human review. AI-generated forecasts should disclose assumptions, confidence limitations, data cut-off dates, and unusual events. Automation must not silently classify tax funds as available cash or approve payments without appropriate controls.

Key controls include bank reconciliation, dual approval for payments, payment-file verification, access controls, audit trails, exception reporting, and independent review of changes to forecast assumptions. Cybersecurity is a liquidity issue because payment fraud can create an immediate and irreversible cash loss.

Ethically, managers should avoid misleading lenders, investors, suppliers, or employees by presenting unsupported inflows, concealing overdue obligations, or manipulating payment timing around reporting dates. A forecast is a decision document and should communicate uncertainty honestly.

11. Limitations and Best Practices

Cash forecasts are estimates. They may be weakened by poor bookkeeping, incomplete bank data, changing customer behaviour, unrecorded commitments, seasonality, foreign-exchange movements, and management optimism. Precision beyond the quality of the underlying evidence is misleading.

Best practice is to:

  • reconcile opening cash before forecasting;
  • forecast actual dates where possible;
  • separate committed, probable, and speculative inflows;
  • model taxes, payroll, debt, and capital expenditure explicitly;
  • maintain daily detail for near-term risk;
  • use a rolling 13-week horizon;
  • compare forecast with actual outcomes;
  • document assumptions and owners;
  • perform downside and reverse-stress analysis;
  • define payment priorities before a crisis; and
  • review minimum balances and reserves periodically.

A mature liquidity process connects the cash forecast to pricing, credit policy, purchasing, inventory, financing, and strategic growth decisions. It does not simply ask whether the firm will have cash; it asks when cash will be available, who controls it, what obligations compete for it, and what action should be taken before a shortfall occurs.

Chapter Summary

Cash budgeting translates operational and financing assumptions into time-specific liquidity information. Daily schedules provide transaction-level control, weekly schedules support active management, monthly budgets assist planning, and 13-week forecasts reveal near-term funding gaps and recurring obligations. The fundamental identity is opening cash plus inflows, less outflows, plus financing, producing closing cash.

Effective forecasts distinguish accrual events from cash events, use verified collection and payment dates, include payroll and tax obligations, and calculate headroom against an approved minimum cash balance. Payment-priority frameworks help managers respond ethically and legally to shortages. Scenario analysis, reserves, committed facilities, and reverse stress testing improve resilience. Technology can strengthen forecasting and controls, but it cannot replace judgement, governance, data quality, or accountability.

Key Terms

Cash budget: A time-phased plan of expected cash inflows, outflows, financing, and balances.

Cash flow: The movement of cash into and out of an organisation.

Cash forecast: An estimate of future cash positions based on explicit assumptions.

13-week forecast: A rolling short-term liquidity forecast covering thirteen weeks.

Minimum cash balance: The lowest cash level management intends to maintain.

Cash headroom: Cash available above the approved minimum balance.

Funding gap: The additional liquidity required to avoid a projected minimum-balance breach.

Operating cash flow: Cash generated or consumed by normal business operations.

Working capital: Current operating resources and obligations, commonly including receivables, inventory, and payables.

Collection pattern: The timing distribution by which sales are converted into cash.

Payment priority: The ranking of obligations according to legal, operational, and financial consequences.

Contingency reserve: Liquidity retained to absorb unexpected cash shortfalls.

Committed facility: Financing contractually available subject to stated conditions.

Scenario analysis: Evaluation of cash outcomes under alternative linked assumptions.

Sensitivity analysis: Examination of the effect of changing one assumption.

Reverse stress test: Analysis of events that would cause a defined liquidity failure.

Forecast error: The difference between actual and forecast cash flow.

Restricted cash: Cash unavailable for general operating use because of legal or contractual constraints.

Cash conversion cycle: The time required to convert operating outlays into collected cash.

Liquidity risk: The risk that obligations cannot be paid when due.

Review Questions

Short Answer Questions

  1. Why can a profitable business experience a cash shortage?
  2. What is the purpose of a rolling 13-week cash forecast?
  3. Define cash headroom and explain how it is calculated.
  4. Why should tax obligations be shown explicitly in a cash budget?
  5. Distinguish sensitivity analysis from scenario analysis.

Long Answer Questions

  1. Explain how a business should construct and govern a 13-week cash forecast.
  2. Discuss the factors that should determine a firm’s minimum cash balance.
  3. Evaluate the ethical and operational issues involved in prioritising payments during a liquidity crisis.
  4. Compare daily, weekly, and monthly cash budgets, including their managerial uses and limitations.
  5. Explain how technology and AI can improve cash forecasting while creating new governance risks.

Analytical / Application Questions

  1. A firm begins a week with cash of 25, expects receipts of 60, operating payments of 42, tax payments of 18, and financing inflows of 5. If its minimum cash balance is 20, calculate closing cash and headroom.
  2. Design a downside scenario for a subscription business whose customers pay by card, identifying at least three linked assumptions and the management actions that should follow.
  3. A company projects a cash balance below its minimum in week 4 but expects an equity investment in week 5. Develop a practical response plan and explain why the future investment does not automatically resolve the earlier liquidity gap.

Multiple Choice Questions with Answers

Question 1

Which item is normally included in a cash budget but not treated as a cash payment when depreciation is recorded?

A. Depreciation expense

B. Supplier settlement

C. Payroll payment

D. Loan principal repayment

Correct Answer: A. Depreciation expense

Question 2

A business begins with cash of 25, receives 60, pays operating costs of 42, pays taxes of 18, and receives financing of 5. What is closing cash?

A. 20

B. 25

C. 30

D. 48

Correct Answer: B. 25

Question 3

If closing cash is 18 and the approved minimum cash balance is 30, what is the immediate funding gap before other actions?

A. 8

B. 10

C. 12

D. 48

Correct Answer: C. 12

Question 4

What is the principal advantage of a 13-week cash forecast?

A. It replaces annual financial statements

B. It combines near-term detail with visibility across recurring payment cycles

C. It guarantees that all forecasts will be accurate

D. It measures profit without considering cash timing

Correct Answer: B. It combines near-term detail with visibility across recurring payment cycles

Question 5

Which inflow should generally be classified as speculative rather than committed?

A. A signed loan drawdown available under existing conditions

B. A recurring card settlement supported by transaction records

C. An equity investment discussed but not yet agreed or documented

D. A customer payment with a confirmed settlement date

Correct Answer: C. An equity investment discussed but not yet agreed or documented

Question 6

Which obligation is generally among the highest payment priorities during a liquidity crisis?

A. Discretionary equipment purchase

B. Owner distribution

C. Nonessential advertising campaign

D. Payroll and legally required remittances

Correct Answer: D. Payroll and legally required remittances

Question 7

What does a reverse stress test ask?

A. Which past forecast was most accurate?

B. What combination of events would cause a defined liquidity breach?

C. How can accounting profit be maximised?

D. Which supplier offers the lowest price?

Correct Answer: B. What combination of events would cause a defined liquidity breach?

Question 8

Why should restricted cash normally be excluded from available operating liquidity?

A. It is always invested in equity securities

B. It cannot legally or practically be used for general obligations

C. It is never reported in financial records

D. It represents future revenue

Correct Answer: B. It cannot legally or practically be used for general obligations

Question 9

If a collection model assumes rates of 0.5 immediately, 0.3 one period later, and 0.2 two periods later, what condition is satisfied?

A. All sales are collected immediately

B. The collection rates sum to 1.0

C. The business has no bad debts

D. Cash collections equal reported profit

Correct Answer: B. The collection rates sum to 1.0

Question 10

Which control most directly reduces the risk that one employee can create and release an unauthorised payment?

A. Using a monthly forecast only

B. Increasing the minimum cash balance

C. Segregation of duties and dual payment approval

D. Recording depreciation daily

Correct Answer: C. Segregation of duties and dual payment approval

Cash Flow Management
Chapter 5 of 15