MANAGERIAL ACCOUNTING • BUDGETING AND PLANNING

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

Master the systematic forecasting of cash inflows and outflows to ensure organizational liquidity and strategic financial planning.

Historical Context & Motivation

The practice of cash budgeting evolved alongside the broader development of management accounting as a discipline distinct from financial accounting. While merchants and traders have always tracked money coming in and going out, the formalization of cash budgets as structured managerial tools emerged during the industrial era, when the scale and complexity of business operations demanded forward-looking financial planning rather than merely retrospective record-keeping. The central problem a cash budget solves is deceptively simple yet critically important: ensuring that an organization has enough cash on hand to meet its obligations while simultaneously avoiding the opportunity cost of holding excessive idle cash.

1920s
Rise of Scientific Management
Frederick Taylor's efficiency movement inspired firms to apply systematic planning to finances. Early corporate budgets emerged at companies like DuPont and General Motors, establishing budgetary control as a core management function.
1950s
Master Budget Frameworks
Management accounting textbooks formalized the master budget structure, positioning the cash budget as the culminating schedule that integrates operating and capital budgets into a single liquidity forecast.
1980s
Spreadsheet Revolution
The advent of Lotus 1-2-3 and later Microsoft Excel enabled rapid scenario analysis. Cash budgets became dynamic tools rather than static documents, allowing managers to model 'what-if' scenarios for collection rates and payment timing.
2000s–Present
ERP Integration & Real-Time Forecasting
Enterprise Resource Planning systems like SAP and Oracle automated much of the data feeding into cash budgets. Modern treasury management platforms now generate rolling cash forecasts updated daily, though the underlying logic remains grounded in the principles of the traditional cash budget.

Despite these technological advances, the fundamental question persists: given projected revenues, expenses, and the timing lags between accrual events and actual cash movements, will the firm have sufficient cash each period to operate smoothly? The cash budget provides a structured, period-by-period answer to this question and signals when borrowing is needed or when surplus cash can be invested.

Core Principles & Definitions

A cash budget is a detailed projection of cash receipts and cash disbursements over a specified planning horizon, typically broken into monthly or quarterly periods. Unlike the income statement, which operates under accrual accounting, the cash budget focuses exclusively on the timing of actual cash flows. A company may report strong accrual profits while simultaneously facing a cash crisis if receivables are slow to collect or if large capital expenditures are scheduled. Understanding the structural components and guiding principles of the cash budget is essential before constructing one.

1

Cash Receipts

All sources of cash inflow during a period, including collections from customers (adjusted for collection patterns), cash sales, loan proceeds, interest income, and asset disposals. The collection schedule is typically the most complex component.
2

Cash Disbursements

All cash outflows, including payments for direct materials, direct labor, manufacturing overhead (excluding depreciation), selling and administrative expenses, capital expenditures, tax payments, and loan repayments.
3

Net Cash Flow

The difference between total cash receipts and total cash disbursements for a given period. A positive net cash flow indicates the firm generated more cash than it spent; a negative figure signals a cash deficit requiring financing.
4

Minimum Cash Balance

A policy-determined floor that management maintains as a safety margin. If the projected ending cash balance falls below this minimum required balance, the firm must arrange short-term borrowing to cover the shortfall.
5

Financing Section

The final section of the cash budget captures borrowing, repayment, and interest transactions needed to maintain the minimum cash balance. Borrowings are typically assumed to occur at the beginning of the period and repayments at the end.
KEY TAKEAWAY
Think of a cash budget like a personal checking account forecast. You know your paycheck arrives on certain dates, your rent is due on the first, and your credit card bill hits mid-month. Even if your annual salary exceeds your annual expenses, you could still overdraft in a specific week if the timing is misaligned. The cash budget performs exactly this timing analysis for a business, ensuring management never gets caught off-guard by a gap between earning revenue and actually receiving the cash.

Visual Explanation — Cash Budget Structure

The following diagram illustrates how the cash budget fits within the broader master budget framework and shows the flow of data from supporting schedules into the four major sections of the cash budget. Notice that the cash budget draws inputs from the sales budget, the purchases budget, and the operating expense budgets, making it one of the last schedules prepared in the master budget sequence.

The cash budget integrates data from the sales budget (driving receipts via the collection schedule), the purchases budget (driving materials payments), and operating expense budgets (driving administrative and selling disbursements). The four sections flow sequentially from receipts through financing to the projected ending cash balance.

As the diagram shows, the cash budget is not a standalone document — it is the integrative capstone of the master budget process. Each upstream schedule must be completed before the cash budget can be assembled. The sales budget determines how much revenue is expected, and the collection schedule translates those accrual sales into cash receipts by period, accounting for the fact that credit customers rarely pay in the same month as the sale. Similarly, the purchases budget must be converted into a payment schedule reflecting supplier credit terms.

Mathematical Framework

The cash budget can be expressed through a series of interconnected equations. While the calculations are arithmetic in nature, understanding the formal relationships ensures you can adapt the framework to any scenario and avoids common errors when timing lags are introduced.

TOTAL CASH RECEIPTS
Cash Receipts = Cash Sales + Collections from Credit Sales + Other Cash Inflows
Where Cash Sales = Sales × (1 − Credit Sale %). Collections from Credit Sales = Σ (Credit Sales of prior periods × Collection rate for that lag period). Other inflows include asset sales, loan proceeds, and interest received.
TOTAL CASH DISBURSEMENTS
Cash Disbursements = Materials Payments + Labor + Overhead (excl. Depreciation) + S&A Expenses + CapEx + Taxes
Note that depreciation is a non-cash expense and must be excluded from cash disbursements. Materials payments follow a payment schedule similar to the collection schedule for receipts.
CASH EXCESS (DEFICIENCY)
Cash Available − Minimum Cash Balance = Excess (Deficiency)
Where Cash Available = Beginning Cash Balance + Total Cash Receipts − Total Cash Disbursements. If this value is negative or below the minimum required balance, financing must be arranged.
ENDING CASH BALANCE
Ending Cash = Cash Available + Borrowings − Repayments − Interest
Borrowings are added in the period cash is needed. Repayments and interest reduce cash when paid. The ending balance of one period becomes the beginning balance of the next period, creating the rolling nature of the cash budget.
📊 Collection Schedule Logic
Suppose 70% of credit sales are collected in the month of sale, 25% in the following month, and 5% are uncollectible. For January credit sales of $100,000: January collections = $100,000 × 0.70 = $70,000; February collections from January sales = $100,000 × 0.25 = $25,000. The remaining $5,000 becomes bad debt expense — a non-cash item excluded from the cash budget.

Detailed Breakdown of Cash Budget Components

Each section of the cash budget requires careful attention to timing assumptions and source data. The diagram below provides a detailed period-by-period view of how cash flows through a quarterly cash budget, showing the interplay between the collection schedule and the payment schedule across three months.

A three-month cash budget illustrating how the ending balance of each month becomes the beginning balance of the next. Notice that January and February maintain adequate cash above the $25,000 minimum, while March's heavy disbursements (including capital expenditure) create a deficit requiring $33,000 in borrowing.

The detailed breakdown above reveals the critical role of timing differences. In March, total disbursements spike due to a capital expenditure, while collections decline as the sales cycle may be entering a seasonal trough. The cash budget's value lies precisely in surfacing these timing mismatches well in advance, giving management time to negotiate a line of credit, delay discretionary spending, or accelerate collections through early-payment discounts.

Cash budget components and their source schedules
ComponentSource ScheduleKey Timing Consideration
Collections from customersSales budget → Collection scheduleLag between sale date and cash receipt; varies by credit terms (Net 30, Net 60)
Materials paymentsProduction budget → Purchases budgetPayment may lag purchase by one month depending on supplier terms
Direct laborDirect labor budgetTypically paid in the period incurred (weekly or bi-weekly payroll)
Manufacturing overheadManufacturing overhead budgetExclude depreciation; paid in the period incurred or with slight lag
Selling & admin expensesS&A expense budgetFixed component paid monthly; variable component tracks sales volume
Capital expendituresCapital budgetLarge, lumpy outflows; timing is management's discretion

Worked Example — Preparing a Quarterly Cash Budget

Nexus Manufacturing is preparing a cash budget for Q2 (April, May, June). The following information is available:

  • Budgeted sales: March $120,000; April $140,000; May $160,000; June $150,000
  • All sales are on credit. Collections: 60% in the month of sale, 35% in the following month, 5% uncollectible
  • Direct materials purchases: April $55,000; May $62,000; June $58,000. Paid 50% in month of purchase, 50% in the following month. March purchases were $50,000
  • Direct labor: April $30,000; May $34,000; June $32,000 (paid in month incurred)
  • Manufacturing overhead: $20,000/month (includes $4,000 depreciation)
  • Selling & administrative expenses: $15,000/month (includes $2,000 depreciation)
  • Equipment purchase of $40,000 planned for May
  • Beginning cash balance (April 1): $35,000. Minimum required balance: $25,000
  • Borrowing available in $1,000 increments at 12% annual interest. Borrowing at beginning of month, repayment at end of month
Nexus Manufacturing — Q2 Cash Budget
1
Step 1 — Prepare the Collection ScheduleCollections in April: 60% of April sales ($140,000 × 0.60 = $84,000) + 35% of March sales ($120,000 × 0.35 = $42,000) = $126,000. May: 60% of $160,000 ($96,000) + 35% of $140,000 ($49,000) = $145,000. June: 60% of $150,000 ($90,000) + 35% of $160,000 ($56,000) = $146,000.
April: $126,000 | May: $145,000 | June: $146,000
2
Step 2 — Prepare the Disbursement ScheduleMaterials payments in April: 50% of April purchases ($55,000 × 0.50 = $27,500) + 50% of March purchases ($50,000 × 0.50 = $25,000) = $52,500. May: 50% of $62,000 ($31,000) + 50% of $55,000 ($27,500) = $58,500. June: 50% of $58,000 ($29,000) + 50% of $62,000 ($31,000) = $60,000. Add labor, overhead (less depreciation: $20,000 − $4,000 = $16,000), and S&A (less depreciation: $15,000 − $2,000 = $13,000). May also includes the $40,000 equipment purchase.
April: $52,500 + $30,000 + $16,000 + $13,000 = $111,500 | May: $58,500 + $34,000 + $16,000 + $13,000 + $40,000 = $161,500 | June: $60,000 + $32,000 + $16,000 + $13,000 = $121,000
3
Step 3 — Compute Cash Available (Excess/Deficiency)April: Beginning $35,000 + Receipts $126,000 − Disbursements $111,500 = $49,500. Less minimum $25,000 → Excess of $24,500. No borrowing needed. May: Beginning $49,500 + $145,000 − $161,500 = $33,000. Less minimum $25,000 → Excess of $8,000. No borrowing needed. June: Beginning $33,000 + $146,000 − $121,000 = $58,000. Less minimum $25,000 → Excess of $33,000. No borrowing needed.
April ending: $49,500 | May ending: $33,000 | June ending: $58,000
4
Step 4 — Determine Financing NeedsIn this scenario, Nexus maintains an excess above the $25,000 minimum in all three months, so no borrowing is required. However, consider a variation: if the equipment purchase were $80,000 instead of $40,000, May's cash available would drop to $33,000 + $145,000 − $201,500 = $(23,500). The deficiency below the minimum would be $25,000 − (−$23,500) = $48,500, requiring borrowing of $49,000 (rounded up to the nearest $1,000).
Base case: $0 borrowing needed across all three months
5
Step 5 — Compile the Final Cash BudgetThe completed cash budget presents four sections vertically for each month: (1) Total cash receipts of $126,000 / $145,000 / $146,000; (2) Total cash disbursements of $111,500 / $161,500 / $121,000; (3) Cash excess/(deficiency) over the $25,000 minimum; (4) Financing activity (none in this case). The ending balances — $49,500, $33,000, and $58,000 — roll forward sequentially, and each exceeds the minimum required balance.
Q2 Ending Cash Balance: $58,000 — No external financing required.

Strengths, Limitations & Best Practices

The cash budget is one of the most practically valuable tools in managerial accounting, yet it is subject to important limitations. Understanding both sides equips managers to use the tool wisely and supplement it with additional analysis when conditions are uncertain.

Strengths vs. limitations of the cash budget
StrengthsLimitations
Identifies cash shortfalls before they occur, enabling proactive financing arrangementsRelies on estimated inputs (sales forecasts, collection rates) that may prove inaccurate
Highlights periods of excess cash that can be invested for returns rather than sitting idleDoes not capture unexpected cash events (lawsuits, equipment failures, economic shocks)
Forces coordination across departments since it integrates all operating and capital budgetsCan become overly complex in multi-division or multinational organizations with currency exposures
Serves as a performance benchmark: actual vs. budgeted cash flows reveal operational variancesStatic budgets become stale quickly; must be updated regularly or replaced with rolling forecasts
Provides essential input for bank loan applications and credit facility negotiationsMay induce dysfunctional behavior if managers manipulate inputs to avoid showing deficits
KEY TAKEAWAY
The cash budget functions much like a navigation chart for a ship's captain. It plots the expected course — showing where shallow waters (cash deficits) lie and where deep harbors (cash surpluses) offer opportunities. No chart can predict every storm, but a captain who sails without one is far more likely to run aground. The cash budget's true value is not in its precision but in the disciplined thinking process it imposes: managers must articulate assumptions about collection timing, payment patterns, and capital needs, making those assumptions explicit and therefore debatable, testable, and improvable.

Connection to Advanced Cash Management

The introductory cash budget you have learned to prepare is the foundation for more sophisticated treasury management techniques. As organizations grow, the static periodic cash budget evolves into dynamic, technology-driven systems that incorporate probability distributions, scenario analysis, and real-time data feeds. Understanding how the basic cash budget connects to these advanced approaches ensures that the skills you build now remain relevant throughout your career.

Introductory vs. advanced cash management approaches
FeatureIntroductory Cash BudgetAdvanced Cash Management
Time horizonFixed quarter or year, divided into monthsRolling 13-week forecast updated weekly; daily cash position reports
Input dataDeterministic: single-point estimates of sales, collections, etc.Stochastic: Monte Carlo simulations model probability distributions of key inputs
Financing decisionsSimple borrowing/repayment against a minimum balanceOptimized working capital strategies: factoring, supply chain finance, commercial paper
TechnologySpreadsheet-based with manual data entryERP-integrated treasury management systems with AI-driven anomaly detection
Surplus investmentIdentified but not optimizedAutomated sweep accounts, money market investments, yield curve analysis

Courses in corporate finance and treasury management build directly on the cash budget framework by introducing concepts such as the Baumol model and the Miller-Orr model for optimal cash holdings, as well as cash conversion cycle analysis that links receivables, inventory, and payables management into an integrated working capital strategy. The fundamental logic, however, remains identical to what you have practiced here: project inflows, project outflows, identify gaps, and plan financing.

Practice Problems

PROBLEM 1CONCEPTUAL
Explain why a company that is profitable on an accrual basis might still experience a cash deficit in a given month. Identify at least two specific timing factors from the cash budget framework that could cause this situation.
PROBLEM 2BASIC CALCULATION
A company's October credit sales are $200,000. Its collection pattern is: 50% collected in the month of sale, 40% in the following month, and 10% two months after the sale. How much cash will be collected from October's sales in (a) October, (b) November, and (c) December?
PROBLEM 3INTERMEDIATE
Sterling Corp has the following data for March: beginning cash balance $20,000; total cash receipts $95,000; total cash disbursements $108,000; minimum required cash balance $15,000. Borrowing is available in $1,000 increments at 12% annual interest, borrowed at the beginning of the month and repaid at the end. (a) Calculate the cash excess or deficiency before financing. (b) Determine the amount Sterling must borrow. (c) If Sterling repays the loan at the end of March, calculate the interest payment and the ending cash balance.
PROBLEM 4APPLIED
Riverside Electronics is preparing its July cash budget. Budgeted sales: May $180,000; June $200,000; July $220,000. Collections: 20% cash sales (collected immediately), 80% credit. Of credit sales: 70% collected in the month of sale, 30% in the following month. Purchases are 45% of sales, paid 60% in the month of purchase and 40% the next month. Operating expenses are $42,000/month (including $6,000 depreciation). The beginning cash balance July 1 is $28,000 and the minimum balance is $20,000. Prepare the July cash budget and determine whether financing is needed.
PROBLEM 5CRITICAL THINKING
A CFO reviews the company's quarterly cash budget and notices that the projected ending balance in every month comfortably exceeds the minimum by at least $150,000, yet the budget assumes a 70% same-month collection rate based on historical data. The company is about to enter a new market where customers typically negotiate Net 90 payment terms. Critically analyze how this strategic change would affect the cash budget and recommend at least two managerial actions to mitigate the impact.

Cash Budgets — Summary

The cash budget is a forward-looking financial schedule that projects cash receipts and cash disbursements by period to determine whether the organization will maintain adequate liquidity. It is the integrative capstone of the master budget, drawing inputs from the sales budget (via the collection schedule), the purchases budget (via the payment schedule), and the operating expense and capital budgets. The key insight is that profitability does not guarantee liquidity — timing differences between accrual recognition and actual cash flow can create dangerous gaps that only the cash budget reveals.

The four structural sections of every cash budget — receipts, disbursements, cash excess or deficiency, and financing — flow sequentially to produce the projected ending cash balance, which must meet or exceed the minimum required balance. When it does not, the financing section calculates the necessary borrowing. Remember to exclude non-cash items like depreciation from disbursements, to apply collection and payment lags accurately, and to round borrowing to the increment specified by the lender. Mastering the cash budget provides the analytical foundation for advanced treasury management techniques including rolling forecasts, working capital optimization, and scenario-based financial planning.

Varsity Tutors • Managerial Accounting • Cash Budgets — Prepare cash budget (intro-to-standard)