Cash Budgets — Prepare cash budget (intro-to-standard) - Cost Accounting

SECTION 1

Historical Context & Motivation

The practice of projecting future cash flows has deep roots in commercial history, stretching back to the earliest merchant houses that needed to anticipate whether they could meet obligations to creditors and employees. As firms grew in scale and complexity during the Industrial Revolution, informal cash projections gave way to more structured budgeting processes that distinguished between accrual-based profitability and the actual timing of cash receipts and disbursements. The cash budget became a critical tool because a profitable firm can still fail if it cannot pay its bills on time — a reality that has driven countless business bankruptcies throughout economic history.

1850s–1900s • Rise of Industrial Cash Planning

Large railroad and manufacturing firms began tracking cash reserves separately from profit, recognizing that capital-intensive operations required precise timing of payments for labor, raw materials, and debt service.

1920s • Formal Budgeting Emerges

James O. McKinsey's 'Budgetary Control' (1922) popularized systematic budgeting in corporate management. Cash budgets became a distinct component of the master budget framework.

1950s–1970s • Integration into Master Budgets

Managerial accounting textbooks codified the cash budget as the final schedule in the operating budget sequence, linking sales, production, and capital expenditure budgets to a single liquidity forecast.

2000s–Present • Technology-Enabled Cash Forecasting

ERP systems (SAP, Oracle) and treasury management software now automate cash budget preparation in real time, but the fundamental logic — cash in minus cash out plus beginning balance — remains unchanged.

The central question the cash budget addresses is deceptively simple: Will we have enough cash at the end of each period to meet our obligations, or will we need to arrange financing? Answering this question requires converting accrual-based revenue and expense estimates into their cash-basis equivalents, accounting for the timing lags inherent in credit sales, supplier payment terms, and the scheduling of capital outlays.

SECTION 2

Core Principles & Definitions

A cash budget is a detailed schedule that projects expected cash inflows, expected cash outflows, and the resulting cash balance for each sub-period (usually monthly or quarterly) within a planning horizon. Unlike an income statement — which records revenues when earned and expenses when incurred — the cash budget records transactions only when cash actually changes hands. This distinction is crucial: a company might recognize $500,000 of revenue in March on its income statement, yet collect only $300,000 in cash during that same month because its customers pay on 30-day terms.

Beginning Cash Balance

The cash on hand at the start of each budget period. For the first period, this is the actual cash balance; for subsequent periods, it equals the prior period's ending balance.

Cash Receipts (Inflows)

All sources of incoming cash — collections from credit sales, cash sales, asset disposals, loan proceeds, and interest income — timed to the period in which cash is actually received.

Cash Disbursements (Outflows)

All cash payments — for materials, labor, overhead, selling and administrative expenses, capital expenditures, income taxes, dividends, and debt repayments — timed to the period when payment occurs.

Minimum Cash Balance

A management-set safety cushion (e.g., $25,000). If the projected ending balance falls below this threshold, borrowing is required; if it exceeds it by a significant margin, excess cash can be invested or used to repay debt.

Financing Section

The final section of the cash budget records borrowings needed to maintain the minimum balance, scheduled repayments, and related interest charges, producing the adjusted ending cash balance.

✦

KEY TAKEAWAY

Think of the cash budget like a household checking-account register projected forward in time. You know your paycheck arrives on the 1st and the 15th; your rent is due on the 1st; your car payment hits on the 10th. Even if your annual salary exceeds your annual expenses, you might overdraw your account if a large expense lands before your next paycheck. A corporate cash budget performs the same function at scale — it ensures the company's 'checking account' never drops below a safe level.

SECTION 3

Visual Explanation — Structure of a Cash Budget

The diagram above shows the five-section structure of a cash budget. Cash flows vertically from the beginning balance through receipts and disbursements, yielding an excess or deficiency, which is then adjusted by the financing section to arrive at the ending cash balance.

Notice how the structure mirrors a simple equation: Beginning Cash + Receipts − Disbursements = Excess (or Deficiency). This intermediate figure is then compared against the firm's desired minimum cash balance. If the excess falls short, borrowing must occur; if it exceeds the minimum by a comfortable margin, the firm can repay prior borrowings or invest the surplus. The ending cash balance after financing adjustments becomes the beginning balance for the next period, creating a rolling, period-by-period forecast.

SECTION 4

Mathematical Framework

The cash budget rests on a small set of equations. The first governs the overall structure; the remaining equations address the most critical input — cash collections from credit sales, which require a collections schedule based on historical payment patterns.

CORE CASH BUDGET EQUATION

Ending Cash = Beginning Cash + Total Receipts − Total Disbursements ± Financing

Where Financing = Borrowings − Repayments − Interest Paid. This equation is computed for each sub-period (e.g., each month of a quarter).

CASH COLLECTIONS FROM CREDIT SALES

Collections₍ₜ₎ = (Sales₍ₜ₎ × %collected in month of sale) + (Sales₍ₜ₋₁₎ × %collected one month later) + (Sales₍ₜ₋₂₎ × %collected two months later) − Bad debts

For example, if a firm collects 20% in the month of sale, 50% one month later, 25% two months later, and writes off 5% as uncollectible, then for any given month t the collections depend on sales from the current and two prior months.

EXCESS OR DEFICIENCY

Excess (Deficiency) = Beginning Cash + Total Receipts − Total Disbursements

If this figure is below the desired minimum cash balance, the firm must borrow: Required Borrowing = Minimum Balance − Excess (Deficiency). Borrowings are typically rounded up to the nearest increment required by the lender (e.g., nearest $1,000).

⚠

Accrual vs. Cash Timing

A common error in preparing cash budgets is including non-cash items such as depreciation in cash disbursements. Depreciation is an allocation of a past cash outlay and does not represent a current period cash flow. Always exclude depreciation (and amortization) from the disbursements section of the cash budget.

SECTION 5

Detailed Breakdown — The Collections Schedule

The most challenging input to the cash budget is projecting when credit sales will convert into cash. Most firms sell on terms (e.g., net 30), meaning revenue recognized today will not generate cash for 30 or more days. A collections schedule translates budgeted sales into expected cash receipts by applying historical collection percentages to each month's credit sales. The table below illustrates a typical pattern where 25% is collected in the month of sale, 50% one month after, 20% two months after, and 5% is written off as uncollectible.

This diagram illustrates how March cash collections of $115,000 are assembled from three different months' sales. The staggered collection pattern is the key bridge between the sales budget and the cash budget.

The collections schedule must extend backward into months before the budget period. In the example above, to calculate January collections you would need November and December sales data from the prior year. When exam problems provide an accounts receivable balance at the beginning of the budget period, this balance typically represents the uncollected portions of prior months' sales and can be mapped directly into the first one or two months' collections.

SECTION 6

Worked Example — Preparing a Quarterly Cash Budget

Greenfield Manufacturing is preparing its cash budget for Q2 (April, May, June). The following data are available:

Budgeted sales: February $80,000; March $100,000; April $120,000; May $110,000; June $130,000.
Collection pattern: 30% in month of sale, 60% one month later, 10% two months later. No bad debts.
Cash disbursements: April $105,000; May $98,000; June $115,000 (these already exclude depreciation).
Beginning cash balance (April 1): $30,000.
Minimum desired cash balance: $25,000.
Borrowings are in multiples of $1,000 at 12% annual interest. Repayments occur as soon as cash permits, interest is paid when the loan is repaid.

Greenfield Manufacturing — Q2 Cash Budget

1
Step 1 — Build the Collections Schedule

April collections: 30% × $120,000 (Apr sales) = $36,000; 60% × $100,000 (Mar sales) = $60,000; 10% × $80,000 (Feb sales) = $8,000. Total April collections = $104,000. May collections: 30% × $110,000 = $33,000; 60% × $120,000 = $72,000; 10% × $100,000 = $10,000. Total May = $115,000. June collections: 30% × $130,000 = $39,000; 60% × $110,000 = $66,000; 10% × $120,000 = $12,000. Total June = $117,000.

April $104,000 | May $115,000 | June $117,000
2
Step 2 — Compute Excess (Deficiency) for Each Month

April: $30,000 (beg.) + $104,000 (receipts) − $105,000 (disbursements) = $29,000. Since $29,000 ≥ $25,000 minimum, no borrowing is needed. May: $29,000 + $115,000 − $98,000 = $46,000. June: $46,000 + $117,000 − $115,000 = $48,000.

April: $29,000 | May: $46,000 | June: $48,000 — all above the $25,000 minimum
3
Step 3 — Financing Section

Because the excess never drops below $25,000 in any month, no borrowing is required during Q2. If, say, April's excess had been $18,000, the firm would need to borrow at least $25,000 − $18,000 = $7,000 (rounded to $7,000 since multiples of $1,000). Interest on a $7,000 loan at 12% annual for one month would be $7,000 × 0.12 × 1/12 = $70.

No financing needed — all ending balances exceed the $25,000 minimum.
4
Step 4 — Final Cash Budget Summary

The completed budget shows ending cash balances of $29,000 (April), $46,000 (May), and $48,000 (June). Notice how May's beginning balance is April's ending balance ($29,000), and June's beginning balance is May's ending ($46,000). This rolling linkage is a hallmark of cash budget construction.

Ending balances: April $29,000 → May $46,000 → June $48,000

SECTION 7

Strengths and Limitations of Cash Budgets

Strengths	Limitations
Provides early warning of cash shortfalls, allowing managers to arrange financing in advance rather than scrambling at the last minute.	Relies heavily on sales forecasts; if the sales budget is inaccurate, the cash budget will be misleading regardless of how well it is constructed.
Identifies periods of excess cash, enabling the firm to plan short-term investments and maximize returns on idle funds.	Assumes a fixed collection pattern; in reality, customer payment behavior can shift due to economic conditions, industry trends, or changes in credit policy.
Forces coordination across departments — sales, production, purchasing, and finance must agree on timing assumptions.	Typically limited to short horizons (3–12 months); beyond that, uncertainty in inputs makes the budget unreliable without rolling updates.
Serves as a benchmark for performance evaluation — actual cash flows can be compared against the budget to identify variances.	Does not capture qualitative factors such as reputational risk, supplier relationship dynamics, or strategic flexibility.

Key strengths and limitations of cash budgets

✦

KEY TAKEAWAY

A cash budget is like a weather forecast for your finances: it is most accurate in the near term and becomes less reliable the further out you project. Just as a meteorologist updates forecasts daily with new data, effective cash budgeting requires continuous revision as actual results replace estimates. The tool's value lies not in perfect prediction but in disciplined forward-looking analysis that prevents liquidity surprises.

SECTION 8

Connection to Advanced Cash Management

The standard cash budget introduced in this lesson is a foundational tool, but managerial practice extends its logic in several directions. Understanding where the introductory model ends and advanced techniques begin helps you place this topic within the broader landscape of corporate financial planning.

Standard Cash Budget	Advanced Extensions
Uses a single point estimate for sales and collections.	Probabilistic (Monte Carlo) simulation models generate a distribution of possible cash balances, enabling risk-adjusted planning.
Static — prepared once for the period.	Rolling budgets are updated monthly, adding a new month to the end as one month drops off, maintaining a constant planning horizon.
Monthly or quarterly granularity.	Daily cash position reports (treasury dashboards) track intraday liquidity for firms managing billions in receipts and payments.
Financing limited to simple borrowing / repayment.	Optimization models determine the best mix of credit lines, commercial paper, factoring, and short-term investments to minimize net financing costs.

Standard vs. advanced cash management approaches

As you advance in cost accounting and corporate finance, you will encounter models like the Baumol model and the Miller-Orr model, which optimize the target cash balance by trading off the opportunity cost of holding idle cash against the transaction cost of converting securities to cash. These models build directly on the cash budget's output — they take the projected cash flows and determine how much cash to keep on hand versus investing in short-term securities.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

A company reports net income of $50,000 for the quarter, yet its cash budget shows a cash deficiency requiring $20,000 in borrowing. Explain how a profitable company can experience a cash shortfall, and identify at least two factors that could cause this discrepancy.

Show answer

Net income is computed on an accrual basis, meaning revenues are recorded when earned and expenses when incurred, regardless of when cash changes hands. A company can be profitable yet cash-poor for several reasons. First, if customers pay on credit (e.g., net 60 terms), revenue is recognized immediately but cash is not collected for two months, creating a timing lag that depletes the cash balance. Second, large cash disbursements that do not appear on the income statement — such as capital expenditures, loan principal repayments, or dividend payments — consume cash without reducing reported net income. Third, depreciation, which reduces net income, is a non-cash expense; conversely, expenditures for inventory buildup require cash outflows but are not expensed until goods are sold.

Question 2: BASIC CALCULATION

Apex Corp. had the following sales: October $60,000; November $80,000; December $90,000. Collections are 20% in the month of sale, 55% one month later, and 25% two months later. What are total cash collections in December?

Show answer

December collections come from three months' sales. From December sales: 20% × $90,000 = $18,000. From November sales: 55% × $80,000 = $44,000. From October sales: 25% × $60,000 = $15,000. Total December collections = $18,000 + $44,000 + $15,000 = $77,000. Note that the collection percentages sum to 100%, implying no bad debts. If a bad-debt percentage existed, it would reduce the collectible portion and the percentages would still sum to 100% with the bad-debt rate included.

Question 3: INTERMEDIATE

Using the Apex Corp. data from Problem 2, suppose the beginning cash balance on December 1 is $12,000, total cash disbursements for December are $82,000, and the desired minimum cash balance is $10,000. Borrowings must be in multiples of $5,000 at an annual interest rate of 9%. Determine (a) the excess or deficiency before financing, (b) the amount to be borrowed (if any), and (c) the ending cash balance after financing.

Show answer

Step (a): Excess (Deficiency) = Beginning Cash + Receipts − Disbursements = $12,000 + $77,000 − $82,000 = $7,000. Step (b): Since the excess of $7,000 is below the $10,000 minimum, borrowing is required. The shortfall is $10,000 − $7,000 = $3,000. Rounded up to the nearest $5,000, Apex must borrow $5,000. Step (c): Ending cash balance = $7,000 + $5,000 = $12,000. Interest on the $5,000 loan would be computed when the loan is repaid in a subsequent month: $5,000 × 9% × (months outstanding / 12). For December alone, the interest accrual would be $5,000 × 0.09 × 1/12 = $37.50, but this typically appears in the month of repayment.

Question 4: APPLIED

Riverside Services prepares a quarterly cash budget (Q1: Jan–Mar). Data: November sales $200,000; December sales $240,000; January sales $220,000; February sales $260,000; March sales $280,000. Collections: 10% in month of sale (cash discounts taken), 70% one month after sale, 15% two months after sale, 5% uncollectible. Cash disbursements: January $250,000; February $230,000; March $270,000. Beginning cash balance January 1: $40,000. Minimum cash balance: $30,000. Borrowings in $10,000 increments at 10% annual. Prepare the complete cash budget for Q1, including any required borrowing and repayment.

Show answer

Collections schedule: January receipts = (10% × $220K) + (70% × $240K) + (15% × $200K) = $22,000 + $168,000 + $30,000 = $220,000. February receipts = (10% × $260K) + (70% × $220K) + (15% × $240K) = $26,000 + $154,000 + $36,000 = $216,000. March receipts = (10% × $280K) + (70% × $260K) + (15% × $220K) = $28,000 + $182,000 + $33,000 = $243,000. January: $40,000 + $220,000 − $250,000 = $10,000 (deficiency vs. minimum). Need $30,000 − $10,000 = $20,000 borrowing. Ending balance = $30,000. February: $30,000 + $216,000 − $230,000 = $16,000. Need $30,000 − $16,000 = $14,000, rounded to $20,000 borrowing. Ending balance = $36,000. March: $36,000 + $243,000 − $270,000 = $9,000 before repayment adjustments. With $40,000 in outstanding loans, the firm needs to stay above $30,000. Since $9,000 is below minimum, borrow $30,000 − $9,000 = $21,000, rounded to $30,000. Alternatively, if March permits, repay prior loans. In this case, $9,000 < $30,000, so borrow $30,000 (rounded from $21,000). Ending = $39,000. Total outstanding loans = $70,000. Interest on January borrowing (2 months outstanding by March) = $20,000 × 10% × 2/12 = $333. Repayments would occur when ending balances sufficiently exceed the minimum.

Question 5: CRITICAL THINKING

A CFO argues that the company's cash budget is unnecessary because the firm has a $500,000 revolving credit facility that can cover any shortfall. Evaluate this argument. In your response, discuss at least three reasons why a cash budget remains valuable even when a credit facility is available, and explain how the absence of a cash budget could increase the effective cost of relying on the credit line.

Show answer

While a revolving credit facility provides a safety net, relying on it without a cash budget is strategically and financially suboptimal for several reasons. First, a cash budget enables proactive rather than reactive financing — by forecasting shortfalls weeks or months in advance, management can negotiate more favorable terms, time borrowings optimally, and avoid unnecessary draws on the credit line, each of which typically triggers fees and interest charges. Second, many revolving credit agreements include financial covenants (e.g., minimum interest coverage ratios, maximum leverage) that must be maintained; without a cash budget, the firm may inadvertently violate these covenants by drawing too aggressively, triggering default provisions. Third, the cash budget reveals periods of excess cash that could be invested in short-term instruments, earning returns that offset borrowing costs — without the budget, this opportunity cost goes unrecognized. Fourth, the cash budget forces cross-departmental coordination, uncovering unrealistic sales forecasts or unplanned expenditures before they create crises. Finally, by relying solely on the credit facility, the firm loses the disciplinary benefit of budgeting: departments may overspend, knowing that the credit line will absorb the consequences, creating a moral hazard that erodes financial discipline across the organization.

SUMMARY

Summary — Cash Budgets

Summary

A cash budget projects period-by-period cash inflows and cash outflows to determine whether the firm will maintain its desired minimum cash balance or require short-term financing. Its five-section structure — beginning balance, receipts, disbursements, excess or deficiency, and financing — produces a rolling forecast in which each period's ending balance becomes the next period's beginning balance.

The most critical input is the collections schedule, which converts accrual-based credit sales into cash receipts using historical collection percentages. Remember to exclude non-cash items such as depreciation from disbursements, include only the cash portions of expenses, and account for bad debts that will never be collected. Mastering the standard cash budget equips you for advanced topics including rolling budgets, probabilistic forecasting, and optimal cash management models.