Master Budget: Components, Worked Example and Cash Bridge

A master budget is the coordinated set of operating and financial schedules used to plan one business period. It connects expected sales, required resources, planned income, cash timing and the projected financial position. A single expense list is only one piece.

For an owner, the practical question is whether the same plan works in three places: the sales diary, the delivery schedule and the bank account. A profitable plan can still need funding before customers pay. Start with a shared set of assumptions and make every schedule use the same dates, currency and business boundary.

What belongs in a master budget?

The operating side plans sales and the costs of delivering them. The financial side plans collections, payments, capital spending, financing and the resulting balance sheet. Inventory businesses need additional schedules that a simple service company may not use. The following is a working checklist, not permission to omit a schedule that matters to your business.

The usual starting point: the sales budget

Expected sales normally drive the initial operating schedules. Record quantity and net price by offer rather than applying one growth percentage to every expense. Then check whether delivery capacity, materials, customer demand and credit terms support the proposal. A sales target remains an assumption until supported by evidence.

For example, a fictional service company plans 200 equivalent visits at $180, giving $36,000 net sales. Each visit requires $80 of variable operating inputs, and monthly fixed cash operating costs are $14,000. The unit is a completed comparable visit, not an inquiry, invoice line or unpaid quotation. Combining different services requires separate unit economics and a realistic sales mix.

Master budget example: service operating schedules

The miniature example below assumes no inventory, no depreciation and all included operating expenses paid in the same month. Its deliberately narrow assumptions make the profit-to-cash bridge visible; it is not a complete set of financial statements.

Suppose delivery takes 1.5 paid hours per visit. The plan requires 300 delivery hours, plus time outside that task boundary. A $32 loaded delivery rate would consume $9,600 of the $16,000 variable budget only if those hours and costs actually vary with visits. Do not add that $9,600 again on top of the $80 per visit if it is already included. Use the direct-labor budget boundary to distinguish job hours from a full annual hiring cost.

The planned contribution of $100 per visit covers $14,000 at 140 visits, under unchanged assumptions. That break-even check tests the operating target, while the delivery-hours check tests a different constraint. Neither proves that 200 customers will book. Keep the contribution format linked to the same expense list so a wage or subscription is not counted twice.

Why $6,000 profit can leave a cash gap

Opening cash is $5,000. The company collects 80% of current sales, or $28,800, and $3,000 from opening receivables. It pays the $30,000 operating expenses above, $1,000 of other cash obligations outside this operating result and $2,000 for equipment. The $1,000 could include a debt-principal payment; it is explicitly not another operating expense in this example.

The uncollected $7,200 of current sales remains outside this month's receipts. Opening receivable collections are cash now but not new sales now. A $2,000 equipment purchase uses cash without automatically becoming a $2,000 operating expense. If depreciation exists, include its appropriate income effect and exclude it from cash payments; the small worksheet above intentionally does not model that additional schedule.

If current collections fall to 70%, receipts decrease by $3,600. Closing cash becomes $200 while the stated operating income remains $6,000; the cash-floor gap grows to $3,800. This is a timing scenario, not a forecast. A funding gap does not create an approved loan, and borrowed principal does not become sales revenue. Record financing, interest and covenants in a separate schedule.

Complete the example with a budgeted balance sheet

To extend the same service example, assume opening receivables of $3,000, equipment at a $10,000 carrying amount, debt principal of $6,000 and equity of $12,000, alongside the $5,000 opening cash. For this illustration, the entire $1,000 of other cash payments is debt principal. There are no payables, inventory, depreciation, interest, tax, owner contributions or distributions.

The $7,200 closing receivable is the uncollected part of current sales, not additional cash. Principal repayment reduces debt, while the equipment payment increases the asset under these assumptions. The balance sheet now agrees with the cash budget and income plan. This is an explanatory extension of the example; the calculator and CSV do not automatically generate these balance-sheet schedules.

How manufacturing changes the plan

A manufacturer must connect sales to production and inventory. For an independent illustration, planned sales of 500 units, desired ending finished goods of 80 and opening finished goods of 50 require 530 units of production: 500 + 80 − 50. Materials purchases then depend on production requirements and raw-material inventory, not sales alone. Product costs, inventory valuation and payment timing need separate reconciliations.

A service-delivery worksheet cannot silently stand in for those inventory schedules. Likewise, a cash budget alone cannot supply a budgeted balance sheet. Start from the opening balances, bridge receivables, inventory, payables, equipment, financing and equity, then check that projected assets equal liabilities plus equity. The complete master-budget checklist above retains that final check even though the embedded tool does not automate it.

Prepare, approve and review the plan

1. Choose the period and accountable owner for each assumption. Separate an approved budget from later forecast versions.
2. Build sales quantities and prices, then check resources and the relevant cost range.
3. Prepare the operating schedules and an income statement with all costs accounted for once.
4. Map collections, payments, equipment and financing to actual expected dates. For weekly timing, extend the cash-flow forecast.
5. Complete the projected balance-sheet bridge and reconcile cash to the cash budget.
6. Keep the approved starting plan. Use a flexible budget at actual activity to distinguish activity changes from same-activity performance.

A master budget coordinates the plan before the period. A flexible budget recalculates allowed revenue and cost at another activity level. A rolling forecast updates expectations. Do not overwrite the original target and then call the revised plan a favorable variance.

Download the editable operating-to-cash bridge

Download the formula-based operating-to-cash bridge CSV. Import into Excel or Google Sheets, replace the labeled input rows and recalculate. Incomplete, nonnumeric or invalid inputs leave results blank. This file follows the same fictional example and stated scope as the calculator; a CSV cannot preserve spreadsheet styling.

Check the imported sheet: keep the row positions and formulas in column B unchanged. Enter the collection percentage as 80, not 0.8. The default results should show $6,000 operating income, $3,800 closing cash and a $200 cash-floor gap. If an input is missing, the status requests numeric inputs and calculated results remain blank; an explicit zero is a valid entry where the input permits it.

Build a delivery and labor schedule behind the sales target

The existing 200-visit plan has $80 of variable inputs per visit. To make that assumption operational, suppose each comparable visit needs 1.5 paid delivery hours at $24 and $44 of other variable inputs. This is an original breakdown of the same illustrative $80, not an additional expense: $36 labor + $44 other inputs = $80. The period requires 300 delivery hours, $7,200 variable labor and $8,800 other variable inputs. Together they reproduce the original $16,000 variable expense.

Check the available delivery hours before accepting the sales plan. If only 280 hours can be used under the same service standard, capacity is 280 ÷ 1.5 = 186.6667 equivalent visits, or 186 complete visits if partial jobs cannot be sold. The original 200 visits require 20 more delivery hours. Do not quietly assume those hours are available at the original $24 rate: overtime, subcontracting, scheduling changes or an additional employee can change both costs and feasibility. Capacity is a ceiling under the assumptions, not a forecast of demand.

This labor breakdown assumes hours and their payments genuinely vary with visits. A guaranteed monthly payroll cannot be charged here and again inside the $14,000 fixed commitment. Review paid non-delivery time, employer costs and owner delivery work explicitly. The cost-behavior guide owns that classification question; this schedule shows how the agreed classifications feed the master plan.

What if current-month collections fall from 80% to 60%?

Keep the original sales, expenses, opening balances, equipment purchase and debt repayment unchanged. At 60% current-period collection, current receipts fall to $21,600. Adding the same $3,000 collection of opening receivables gives $24,600 total receipts. Closing cash becomes $5,000 + $24,600 − $33,000 = −$3,400 before financing. Meeting a $4,000 minimum cash floor would require $7,400 of additional funding or other justified cash changes.

Operating income stays $6,000 because this scenario changes collection timing, not recognized sales or expenses. Closing receivables rise to $14,400: $3,000 opening + $36,000 sales − $24,600 collections. Relative to the 80% case, cash is $7,200 lower and receivables are $7,200 higher. The negative cash figure is a funding requirement in a planning schedule, not a claim that a bank will permit an overdraft.

If a new $7,400 borrowing is explicitly approved and received in the period, closing cash becomes $4,000 and closing debt becomes $12,400: original $6,000 debt − $1,000 principal paid + $7,400 new borrowing. With $14,400 receivables and $12,000 equipment, assets total $30,400; $12,400 debt plus $18,000 equity also totals $30,400. This simplified extension still excludes interest and fees. Add their actual terms before treating a financing proposal as complete. Never force a balance-sheet tie by entering an unexplained cash plug.

Use a handoff check between schedules

Match the sales schedule's revenue to the income budget and its collection basis to the cash budget. Match labor hours to the delivery schedule, and labor cost to the correct wage and employer-cost scope. Match the cash budget's equipment payments to additions in the asset schedule, and principal payments to debt rather than operating expense. Each handoff should name its source assumption and period.

The existing calculator and downloadable cash bridge can reproduce the 60% scenario by changing the collection input to 60. They do not calculate the new borrowing or extended balance sheet automatically. Keep those supporting schedules separately. Use the rolling forecast for updated forward expectations and flexible budgeting for the same-activity performance review after the period closes. Preserve the approved master-budget baseline.

Method and sources

OpenStax explains the relationship among operating budgets and the financial-budget schedules. This guide's scenarios, figures, tables and simplified calculator are original fictional illustrations.