Budgeting & Forecasting
The Master Budget
The master budget is the comprehensive, consolidated financial plan for the whole organization for a period, combining all operating and financial budgets. It culminates in three budgeted (pro forma) financial statements: the budgeted income statement, the budgeted balance sheet, and the budgeted cash flow (or cash budget).
Real-world example
The master budget brings sales, production, cash, and capex budgets together into pro forma financial statements.
Types of Budgets
Cash Budgeting
The Master Budget
The master budget has two parts: the operating budget (sales, production, materials, labor, overheads, and operating expenses, ending in the budgeted income statement) and the financial budget (the capital budget, cash budget, and budgeted balance sheet). The operating budget flows into the financial budget.
Real-world example
Operating budgets produce budgeted profit; financial budgets plan cash and the balance sheet.
Types of Budgets
Cash Budgeting
The Master Budget
Typically: sales budget first, then production budget, then direct materials, direct labor, and overhead budgets, then the ending-inventory and cost-of-goods-sold budgets, then selling and administrative expense budget, giving the budgeted income statement; then the cash budget and capital budget, and finally the budgeted balance sheet. Each step feeds the next.
Real-world example
Sales -> production -> materials/labor/overheads -> budgeted P&L -> cash -> budgeted balance sheet.
Types of Budgets
Cash Budgeting
The Master Budget
The budgeted (pro forma) income statement is built from the operating budgets: budgeted sales revenue less budgeted cost of goods sold (from production/inventory budgets) gives gross profit, less budgeted selling and administrative expenses gives operating profit, then less interest and tax gives budgeted net profit. It shows expected profitability for the period.
Sales 500,000 - COGS 300,000 = GP 200,000 - Opex 120,000 = Op profit 80,000.
Real-world example
The budgeted P&L projects an 80,000 operating profit from planned sales and costs.
Types of Budgets
Variance Analysis
The Master Budget
The budgeted balance sheet projects the period-end financial position by taking the opening balance sheet and applying the budgeted changes: profit adds to retained earnings, the cash budget gives closing cash, receivables/payables come from sales/purchase timing, inventory from the inventory budgets, and non-current assets from the capital budget less depreciation. It must balance (assets = liabilities + equity).
Real-world example
Closing cash, receivables, inventory, assets, and retained earnings are each derived from the supporting budgets.
Cash Budgeting
Capital Budgeting
The Master Budget
The cash budget is the financial-budget component that converts the operating plans and capital expenditure into cash inflows and outflows, considering timing (credit terms, payment lags). It produces the closing cash balance used in the budgeted balance sheet and flags financing needs, linking profit plans to liquidity.
Real-world example
The cash budget translates budgeted sales and costs into monthly cash flows and the year-end cash figure.
Cash Budgeting
The Master Budget
The Master Budget
Because the budgets are interlinked, a change in one flows through the rest. For example, raising the sales forecast increases production, which raises materials, labor, and overheads, changing costs, profit, receivables, payables, inventory, and cash—altering all three pro forma statements. This interdependence is why master budgets are best modeled so changes recalculate automatically.
Real-world example
Increasing the sales budget 10% ripples through production, purchasing, cash, and the budgeted balance sheet.
Types of Budgets
Cash Budgeting
The Master Budget
A pro forma statement is a projected/forecast financial statement—the budgeted income statement, balance sheet, or cash flow—built from the budget rather than actual historical results. 'Pro forma' means 'as a matter of form', i.e., a formatted projection of expected results.
Real-world example
The budget package includes pro forma income statement and balance sheet showing the expected year-end position.
The Master Budget
Cash Budgeting
The Master Budget
The COGS budget computes the cost of units sold using the production cost per unit and the sales volume, adjusted for opening and closing finished-goods inventory. It draws on the materials, labor, and overhead budgets (for unit cost) and the inventory budget, and feeds the budgeted income statement's cost of sales line.
Opening FG 40,000 + Production cost 300,000 - Closing FG 50,000 = COGS 290,000.
Real-world example
The COGS budget uses unit costs and inventory movements to derive cost of sales for the budgeted P&L.
Types of Budgets
The Master Budget
The Master Budget
A manufacturer's master budget centers on production, materials, labor, and inventory budgets. A service organization has no production/inventory budgets; its focus is on the revenue budget (billable hours/engagements), labor/staffing (the main cost), and overheads. The financial budgets (cash, capex, balance sheet) are similar, but the operating budget structure reflects the absence of physical inventory.
Real-world example
A consultancy budgets billable hours and staff costs rather than production and raw materials.
Types of Budgets
Cash Budgeting
The Master Budget