Projecting the Timing and Amount of Cash Outflows (2024)

From the information listed above, Scott has determined that his cost of goods sold has been averaging about 59.95 percent of his total sales over the last four years. Scott will use this percentage to predict his cash outflows for the six month cash flow budget he is preparing for 2014. In his budget he will assume that his cash outflows for the cost of goods sold will continue to average about 59.95 percent of his forecasted sales. The following chart summarizes his budgeted cash outflows for the cost of goods sold.

Projecting outflows for expenses

A cash outflow falls under this category if it is cash paid out for operating expenses. Operating expenses are all the expenses you incur while operating your business. Examples of operating expenses include payroll and payroll taxes, utilities, rent, insurance, repairs and maintenance. A good rule of thumb is that if the cash outflow doesn't fit under any of the other three categories (debt payments, cost of goods sold, or major purchases), it's probably an operating expense.

Predicting cash outflows for operating expenses when preparing a cash flow budget can be quite easy in some instances, and difficult in others. Rent, for example, is one operating expense that should be fairly easy to predict since it is usually the same amount month after month. Other operating expenses, such as payroll and utilities, may not be so easy to predict.

As when you predict cash outflows for the cost of goods sold, the best way to predict operating expense outflows is to base them on your sales forecast. This prediction is based on a simple relationship—in order to achieve a certain level of sales, your business will have to incur a given amount of operating expenses.

Using sales information and operating expense information from prior years should allow you to determine this relationship and express your operating expenses as a certain percentage of your sales. Industry information may be available for your type of business if you don't have prior sales and operating expense information to work with. This information may serve as a starting point for predicting your operating expense cash outflows.

Projecting outflows for major purchases and reconciling all of the projections

They say the devil is in the details, but sometimes, it's in the big picture. When preparing a cash flow budget, you must predict the cash outflows for major purchases, such as property or equipment, vehicles, computers or other office equipment. Sometimes it's easy to obsess about the little things and forget about the large purchases you'll need down the road.

Major purchases are usually the result of a business expansion, a business improvement or a business replacement expenditure. Cash outflows in this category are generally large and don't occur that often during your business year.

As the owner of your business, you are probably the best predictor of the cash outflows in this category. If you look for your business to expand during the budget period, then you probably have a pretty good feel for the additional equipment, office space or office equipment needed to undertake the expansion. You also probably know when it's time to replace the old delivery van with a newer model, or when it's time to get rid of an aging computer and replace it with a new one. For more information on how to analyze major purchase decisions, see major purchases and projects.

Tip

The cash flow budget is an excellent tool to help you determine when or when not to make major purchases. If your cash flow budget shows that additional funds may be available at a certain point, this should provide you with the opportunity to make advance purchase decisions.

Planning ahead may allow you to take advantage of lower prices, discounts or better financing options. Likewise, if your cash flow budget shows that your cash supply might be a little tight, it's probably not a good idea to make a major purchase, or take on an additional monthly loan payment.

Putting the inflow and outflow projections together

The final step in preparing a cash flow budget is putting together your projected cash inflows and outflows to come up with your cash flow bottom line. In its basic form, the competed cash flow budget combines the following information on a month-by-month basis: