Accounting › Section T · Budgeting › Topic T.3

Financial budgets and the cash budget

A profitable plan can still run out of cash, because customers pay later than sales are made and big purchases fall due all at once. The financial budgets show when cash will be short, how much to borrow, and what the balance sheet should look like at the end of the year.

From operating plans to cash and position

The financial budgets are the capital expenditures budget, the cash budget and the budgeted balance sheet. They continue Brackley Paddle Works' 2027 plan from "Operating budgets": sales of $920,000, cost of goods sold of $460,000 and operating income of $174,000. Brackley starts the year with cash of $50,000, accounts receivable (Accts Receivable in the tables) of $45,000, materials of $2,640, finished paddles of $16,000, and equipment of $400,000 less $120,000 of accumulated depreciation. It owes accounts payable (Accts Payable) of $12,000 and income tax of $30,000, and its equity is Common Stock of $200,000 and Retained Earnings of $151,640.

The capital expenditures budget

The capital expenditures budget, or capital asset budget, lists planned purchases of long-term assets, when they will happen and how they will be paid for. Brackley plans to buy a $90,000 moulding press for cash in Q2. These purchases are planned years ahead, because they are large, they change depreciation for years to come, and they may need a loan. The budget is prepared before the cash budget, since the payment is often the biggest single outflow; if the cash budget shows it cannot be afforded, the purchase is delayed or financed. Depreciation on the press is assumed to be included in the fixed costs already budgeted.

The cash collections schedule

Credit sales become cash later. Brackley collects 70% of each quarter's sales in that quarter and 30% in the next, and expects no bad debts; a company that does expect some leaves them out of collections, as "Uncollectible accounts and the allowance method" explains. Q1 collects the opening receivables plus 70% of Q1 sales: \(45{,}000 + 112{,}000 = 157{,}000\). Q2 collects \(48{,}000 + 168{,}000 = 216{,}000\), Q3 collects 296,000 and Q4 collects 236,000, a total of $905,000. Ending receivables are 30% of Q4 sales, $60,000. Check: \(45{,}000 + 920{,}000 - 905{,}000 = 60{,}000\).

The cash payments schedule for materials

Brackley pays for half of each quarter's material purchases in that quarter and half in the next. Q1 pays the opening payables plus half of Q1 purchases: \(12{,}000 + 13{,}800 = 25{,}800\). The schedule continues:

\begin{array}{lrr} \text{Quarter} & \text{Bought} & \text{Paid} \\ \hline \text{Q1} & 27{,}600 & 25{,}800 \\ \text{Q2} & 39{,}000 & 33{,}300 \\ \text{Q3} & 42{,}888 & 40{,}944 \\ \text{Q4} & 29{,}232 & 36{,}060 \\ \hline \text{Year} & 138{,}720 & 136{,}104 \end{array}

Half of Q4's purchases, $14,616, is still owed at the year-end. Check: \(12{,}000 + 138{,}720 - 136{,}104 = 14{,}616\).

Other cash payments

Direct labour is paid in the quarter worked. Overhead and selling and administrative costs are paid as incurred, except depreciation, which is a noncash expense and is left out of the cash budget. Overhead payments are therefore each quarter's total less $5,000: $34,850, $39,850, $42,350 and $36,050. Selling and administrative (S&A) payments are $63,000, $67,000, $71,000 and $65,000. Brackley will also pay last year's income tax of $30,000 in Q1 and a dividend of $20,000 in Q4. Every planned payment belongs in the cash budget, whether or not it appears on the income statement.

How the cash budget works

Each period follows the same steps:

\text{Excess} = \text{Opening} + \text{In} - \text{Out}

Opening cash plus receipts gives cash available; subtracting payments gives the excess or deficiency. Brackley wants at least $40,000 of cash at every quarter-end. Its bank provides a line of credit at 8% a year: it borrows in multiples of $5,000 at the start of a quarter when needed, and repays at the end of a quarter, with interest, once the excess allows it while keeping the minimum. The budget therefore shows not only whether the company will be short, but when, by how much and for how long.

Worked example: Q1 and Q2

1. Q1: cash available is \(50{,}000 + 157{,}000 = 207{,}000\) and payments total 182,250, leaving 24,750. 2. That is \(40{,}000 - 24{,}750 = 15{,}250\) short of the minimum, so Brackley borrows 20,000, the next multiple of $5,000. 3. Q2 adds the press, leaving a deficiency of 11,000; reaching 40,000 needs 51,000, so it borrows 55,000.

\begin{array}{lrr} & \text{Q1} & \text{Q2} \\ \hline \text{Opening} & 50{,}000 & 44{,}750 \\ \text{Receipts} & 157{,}000 & 216{,}000 \\ \text{Materials} & (25{,}800) & (33{,}300) \\ \text{Labour} & (28{,}600) & (41{,}600) \\ \text{Overhead} & (34{,}850) & (39{,}850) \\ \text{S\&A costs} & (63{,}000) & (67{,}000) \\ \text{Tax, press} & (30{,}000) & (90{,}000) \\ \hline \text{Excess} & 24{,}750 & (11{,}000) \\ \text{Borrowing} & 20{,}000 & 55{,}000 \\ \hline \text{Closing} & 44{,}750 & 44{,}000 \end{array}

Worked example: Q3 and Q4

1. Q3: \(44{,}000 + 296{,}000 = 340{,}000\) available, payments 202,394, excess 137,606. 2. Interest at 8% a year: \(20{,}000 \times 8\% \times \tfrac{9}{12} = 1{,}200\) and \(55{,}000 \times 8\% \times \tfrac{6}{12} = 2{,}200\), so 3,400. 3. Repaying all 75,000 plus interest leaves 59,206, above the minimum. 4. Q4: \(59{,}206 + 236{,}000 - 188{,}830 = 106{,}376\), after the $20,000 dividend.

\begin{array}{lrr} & \text{Q3} & \text{Q4} \\ \hline \text{Opening} & 44{,}000 & 59{,}206 \\ \text{Receipts} & 296{,}000 & 236{,}000 \\ \text{Payments} & (202{,}394) & (188{,}830) \\ \hline \text{Excess} & 137{,}606 & 106{,}376 \\ \text{Repayment} & (75{,}000) & 0 \\ \text{Interest} & (3{,}400) & 0 \\ \hline \text{Closing} & 59{,}206 & 106{,}376 \end{array}

The budgeted income statement

With interest known, the budgeted income statement can be finished. Assume an income tax rate of 25%, payable early in 2028:

\begin{array}{lr} \text{Sales} & 920{,}000 \\ \text{Cost of goods sold} & (460{,}000) \\ \text{S\&A costs} & (286{,}000) \\ \hline \text{Operating income} & 174{,}000 \\ \text{Interest} & (3{,}400) \\ \text{Income tax} & (42{,}650) \\ \hline \text{Net income} & 127{,}950 \end{array}

Income before tax is \(174{,}000 - 3{,}400 = 170{,}600\), and tax is 25% of that. Net income of $127,950 sits beside an ending cash balance of $106,376: profit and cash differ because of receivables, payables, inventory, depreciation, the press, the loan and the dividend.

The budgeted balance sheet

Each line comes from a schedule: cash from the cash budget, receivables from collections, payables from material payments, inventories from the operating budgets (480 kg at $6 and 440 paddles at $40), and equipment from the capital budget less $40,000 of depreciation. Retained earnings are \(151{,}640 + 127{,}950 - 20{,}000 = 259{,}590\).

\begin{array}{lr} \text{Cash} & 106{,}376 \\ \text{Accts Receivable} & 60{,}000 \\ \text{Inventory} & 20{,}480 \\ \text{Equipment, net} & 330{,}000 \\ \hline \text{Total assets} & 516{,}856 \\ \hline \text{Accts Payable} & 14{,}616 \\ \text{Income Tax Payable} & 42{,}650 \\ \text{Common Stock} & 200{,}000 \\ \text{Retained Earnings} & 259{,}590 \\ \hline \text{Total} & 516{,}856 \end{array}

The two totals agree, which proves the schedules tie together.

Common mistakes to avoid

First, treating sales as cash received: collections lag sales, and bad debts are never collected. Second, putting depreciation in the cash budget. Third, forgetting payments that are not expenses, such as equipment, loan repayments, last year's tax and dividends. Fourth, borrowing only up to zero instead of up to the minimum balance. Fifth, charging a full year's interest on a loan held for part of a year. Sixth, preparing the cash budget only annually, which hides a mid-year shortage such as Brackley's in Q2.

Key takeaways

The financial budgets are the capital expenditures budget, the cash budget and the budgeted balance sheet. Collections follow the customers' payment pattern; payments follow the supplier terms, and depreciation is excluded because it uses no cash. The cash budget adds receipts to opening cash, subtracts payments, then borrows or repays to keep the minimum balance, with interest for the time each loan is outstanding. Interest completes the budgeted income statement, and the budgeted balance sheet draws every line from the schedules; when it balances, the master budget ties together.

Flashcards

Flashcard

Financial budgets

Capital expenditures budget, cash budget, budgeted balance sheet

They plan cash and financial position.

Test your understanding

Question 1 of 5

A company collects 60% of sales in the quarter of sale and 35% in the next quarter; 5% is never collected. Sales are $100,000 in Q1 and $150,000 in Q2. What are Q2 cash collections?

Question 2 of 5

Budgeted overhead for a quarter is $39,850, including $5,000 of depreciation. What amount of overhead goes in the cash budget, and why?

Question 3 of 5

Opening cash is $30,000, receipts are $200,000 and payments are $215,000. The minimum balance is $25,000 and loans are taken in multiples of $5,000. How much should be borrowed?

Question 4 of 5

A company borrows $60,000 at the start of Q1 at 10% a year and repays it at the end of Q3. How much interest is paid?

Question 5 of 5

Opening receivables are $20,000, budgeted sales are $300,000 and budgeted collections are $290,000. What receivables appear on the budgeted balance sheet?

← Previous topicNext topic →