# The Importance of Trade Credit and Working Capital in Planning

## Using Excel to Create the Short-Term Plan

By the end of this section, you will be able to:
1. Create a one-year budget.
2. Create a cash budget.
A cash budget is a tool of cash management and therefore assists financial managers in the planning and control of a critical asset. The cash budget, like any other budget, looks to the future. It projects the cash flows into and out of the company. The budgeting process of a company is a really an integrated process—it links a series of budgets together so that company objectives can be achieved. For example, in a manufacturing company, a series of budgets such as those for sales, production, purchases, materials, overhead, selling and administrative costs, and planned capital expenditures would need to be prepared before cash needs (cash budget) can be predicted.
Just as you might budget your earnings (salary, business income, investment income, etc.) to see if you will be able to cover your expected living expenses and planned savings amounts, to be successful and to increase the odds that sufficient cash will be available in the months ahead, financial managers prepare cash budgets to
1. meet payrolls;
2. allocate dollars for contingencies and emergencies;
3. analyze if planned collections and disbursements policies and procedures result in adequate cash balances; and
4. plan for borrowings on lines of credit and short-term loans that might be needed to balance the cash budget.
A cash budget is a model that often goes through several iterations before managers can approve it as the plan going forward. Changes in any of the “upstream” budgets—budgets that are prepared before the cash budget, such as the sales, purchases, and production budgets—may need to be revised because of changing assumptions. New economic forecasts and even cost-cutting measures will require a revision of the cash budget.
Although a budget might be prepared for each month of a future 12-month period, such as the upcoming fiscal year, a rolling budget is often used. A rolling budget changes often as the planning period (e.g., a fiscal year) plays out. When one month ends, another month is added to the end (the next column) of the budget. For example, if in your budget January is the first month of the planning period, once January is over, next January’s cash budget column would be added—right after December’s column (at the far right of the budget).

### Sample One-Year (Annual) Operating Budget

Preparing an annual operating budget can be a complex task. In essence, a company budget is a series of budgets, many of which are interrelated.
The sales budget is prepared first and has an impact on many other budgets. Take the example of a production budget of a manufacturer. The sales budget impacts what needs to be produced (production budget), and the production budget influences planned purchases of material (purchases budget), overhead resources (overhead budget), and the amount of labor costs for the year ahead (direct labor budget.)
For a merchant (such as a wholesaler or retailer), the annual budget would be less complex than that of a manufacturing firm but would still require an inventory purchases budget and an operating expense budget (such as selling and administrative expenses). For a service firm, a purchase budget for inventory would not be necessary, but an operating budget would be. All businesses need a cash budget, which is the topic of the next section of this chapter.
The example operating budget presented here is of a merchandising company. Budgets are prepared following a process that begins with a sales (or revenue) forecast. The sales forecast is normally based on information obtained from both internal and external sources and predicts the amount of units to be sold in the planning period—usually one year into the future.
A company’s management, in consultation with its marketing and sales executives, would prepare a sales budget by making assumptions about the number of units that are expected to be sold and the prices that will be charged. From the sales budget, projections are made as to cash receipts each month, and therefore assumptions have to be made as to how much of each month’s sales will be cash sales and how much cash will flow into the company from the collection credit sales (including cash flow in from the prior month’s sales).  provides an example of a sales budget and projected accounts receivable collections and cash sales for the months of January through December. Keep in mind that projected monthly sales amounts are not equal to cash collected from sales. Because of sales on credit, some cash from sales lags credit sales as collections can extend beyond the month of sale. Credit terms such terms such as net 30 (net amount owed to be paid in 30 days) have to be considered when developing a forecasted cash collection pattern.
Sales budgets “drive” the preparation of other budgets. If sales are expected to increase, purchases of inventory and some operating expenses would also increase. To meet the demand for goods and services (as defined in the sales budget), a purchases (inventory) budget would be prepared. In this example (), the purchases budget shows projected purchases of inventory (merchandise) and the projected payments (also called disbursements) for each month.
Cash outflows as a result of purchases often do not equal the projected purchase amount. That is because payments for purchases are usually on credit (accounts payable), and so purchases for one month typically get spread out over a period of time that encompasses the current month and the month (or months) thereafter. To keep this example simple, the assumption is that the purchases are paid for in the following month (an average days payable outstanding of 30 days). However, in other cases, payment patterns may be based on other payment periods such as 45, 60, or even 90 days, depending on the trade credit terms.
An operating expense budget is prepared next and is basically a prediction of the selling and administrative expenditures of the company. Notice in  that in the operating expense budget, cost of goods sold (an expense) is not included, nor are noncash expenses such as depreciation. The cash outlays related to goods sold, at least in a merchandising operation, are accounted for in the purchases budget (payments for purchases of inventory.)
With the sales, purchases, and operating expense budgets prepared, the cash budget can be prepared. Some of the “inputs” to the cash budget are from the sales (collections of cash), purchases (payments), and the operating expense budget (cash expenditures for selling and administrative expenses). A sample cash budget and a discussion of its preparation follows in the next section of this chapter.

### Sample Cash Budget

A cash budget is the last budget to be prepared and is often part of the financial budget (cash budget, budgeted income statement, and budgeted balance sheet). The purpose of the cash budget is to estimate cash flows, to help ensure sufficient cash balances are maintained during the planning period, and to plan for external financing during periods of cash deficits.
When a budget is prepared in Excel, cash budget analysts can play “what if” with different scenarios to see when cash surpluses and deficits are expected. Cash surpluses means that funds can be invested in marketable securities to earn a rate of return, while cash deficits mean that financing, such as a line of credit, will be necessary (assuming forecasts are accurate).
Although the example shown in  is a monthly cash budget, a cash budget could be prepared using any useful time elements: weekly, monthly, or quarterly.
One common practice is to use a rolling cash budget. A rolling cash budget is continually updated to add a new budget period, such as a month’s amount of cash flow activity, as the most recent budgeted month expires. For example, assume that a 12-month cash budget is prepared for a period covering January 20X1 to December 20X1. Once the month of January 20X1 has concluded, a 12-month planning period continues by add January 20X2 to the last column of the budget. The rolling cash monthly budget is an extension of the initial cash budget model, adding one month and thereby always extending cash flow projections one year into the future.
Using  as an example,  shows the formulas that form the skeleton of a monthly cash budget.

### 

Short-term plans of a business are funded with cash, with cash budgets being a critical tool of planning. The cash budget takes into account a target amount of cash, factoring in all the motives for holding cash. A cash budget looks ahead—predicting cash inflows and outflows, allocating for minimum cash balances to be maintained, and helping management determine short-term financing needed. Although it is the last budget prepared, the preparation of the cash budget is an important financial planning exercise of companies small and large.

### 
