Calculation Tools

Operating budget

An annual master budget that shows, month by month, how profit and cash diverge when sales, inventory policy and collections change.

Build a full-year master budget from sales through production or purchases, inventory, cash, the budgeted income statement and the balance sheet. Profit and the bank balance are calculated from the same assumptions.

Planning assumptions

Leave blank for no ceiling. Zero means no new borrowing.

Opening balances

Collection of sales (%)

Payment of purchases (%)

Pressure scenario

What the budget says

    Ending cash and the minimum balance

    Products

    How the budget is built

    1. Annual sales quantity is spread with the monthly weights. Weights do not need to sum to 100; they are scaled.
    2. Production, or merchandise purchases, equals sales plus the target ending stock minus opening stock. The target is a percentage of the next month’s sales. December uses January sales of this same budget year, on the assumption that the policy continues.
    3. If that formula would produce a negative quantity, output is set to zero and the stock target is reduced. The sales plan is kept.
    4. For a manufacturer, unit cost is direct material plus direct labor plus variable overhead plus a fixed-overhead rate. The rate is annual cash fixed overhead and depreciation divided by annual units produced. A monthly volume variance is expensed; over the year it nets to zero whenever production is not zero. Inventory uses a weighted average, so opening unit cost can differ from the budgeted cost.
    5. For a merchandiser, stock is carried at purchase cost and depreciation is a period expense.
    6. Collection and payment shares are scaled to 100%. Opening receivables are assumed collected in January and opening payables paid in January.
    7. Interest accrues on the short-term debt outstanding at the start of the month. A draw during the month starts accruing next month. Tax is accrued and paid in December if profit before tax for the year is positive. Provisional tax is not modelled. A loss does not create a tax refund here.
    8. Cash below the minimum draws on the credit line up to the limit, and cash above the minimum repays debt. A blank limit means no ceiling.
    9. Equity is the figure that balances the opening balance sheet. Closing equity equals that figure plus net income minus the dividend. The tool is for teaching and planning; it is not a financing recommendation.

    Results follow the assumptions you enter. They are not an audit, a tax filing or a credit decision.