Financial Management BizMove

Pro Forma Cash Flow Budget Example

XXXXXXX Free Small Business Templates and Tools
Here's a collection of business tools featuring dozens of templates, books, worksheets, tools, software, checklists, videos, manuals, spreadsheets, and much more. All free to download, no strings attached.
► Free Small Business Templates, Books, Tools, Worksheets and MoreGuide to pro forma cash flow


Cash Flow Management

If there is anything more important to the successful financial management of a business than the thorough, thoughtful preparation of Pro Forma Income Statements, it is the preparation of the Cash Flow Statement, sometimes called the Cash Flow Budget.

The Cash Flow Statement (Pro Forma Budget)

The cash flow management and cash flow statement identifies when cash is expected to be received and when it must be spent to pay bills and debts. It shows how much cash will be needed to pay expenses and when it will be needed. It also allows the manager to identify where the necessary cash will come from. For example, will it be internally generated from sales and the collection of accounts receivable - or must it be borrowed? (The Cash Flow Projection deals only with actual cash transactions; depreciation and amortization of goodwill or other non-cash expense items are not considered in this Pro Forma.)

The Cash Flow Statement, based on management estimates of sales and obligations, identifies when money will be flowing into and out of the business. It enables management to plan for shortfalls in cash resources so short term working capital loans may be arranged in advance.

It allows management to schedule purchases and payments in a way that enables the business to borrow as little as possible. Because all sales are not cash sales, management must be able to forecast when accounts receivable will become "cash in the bank" and when expenses - whether regular or seasonal - must be paid so cash shortfalls will not interrupt normal business operations.

The Pro Forma Cash Flow Statement may also be used as a Budget. permitting the manager increased control of the business through continuous comparison of actual receipts and disbursements against forecast amounts. This comparison helps the small business owner identify areas for timely improvement in financial management.

By closely watching the timing of cash receipts and disbursements, cash balance on hand, and loan balances, management can readily identify such things as deficiencies in collecting receivables, unrealistic trade credit or loan repayment schedules. Surplus cash that may be invested on a short-term basis or used to reduce debt and interest expenses temporarily can be recognized. In short, it is the most valuable tool management has at its disposal to refine the day-to-day operation of a business. It is an important financial tool bank lenders evaluate when a business needs a loan, for it demonstrates not only how large a loan is required but also when and how it can be repaid.

How to create cash flow proforma

A Cash Flow Statement or Budget can be prepared for any period of time. However, a one-year budget matching the fiscal year of your business is recommended. As in the preparation and use of the Pro Forma Statement of Income, the projected Cash Flow Statement should be prepared on a monthly basis for the next year. It should be revised not less than quarterly to reflect actual performance in the preceding three months of operations to check its projections.

In preparing the Cash Flow Statement or Budget start with the sales budget. Other budgets are related directly or indirectly to this budget.

Later on, before a cash budget can be compiled, you will need to know the estimated cash requirements for selling expenses. Therefore, you prepare a budget for selling expenses and another for cash expenditures for selling expenses (total selling expenses less depreciation):

Basic information for an estimate of administrative expenses for the coming year is easily compiled. Again, from that budget you can estimate cash requirements for those expenses to be used subsequently in preparing the cash budget.

Now, from the information budgeted so far, you can proceed to prepare the budget income statement. Assume you plan to borrow $10,000 at the end of the first quarter. Although payable at maturity of the note, the interest appears in the last three quarters of the year. The statement will resemble the following:

Estimating that 90 percent of your account sales is collected in the quarter in which they are made, that 9 percent is collected in the quarter following the quarter in which the sales were made, and that 1 percent of account sales is uncollectible, your accounts receivable budget of collections would look like this:

Going back to the sales budget in units, now prepare a production budget in units. Assume you have 2,000 units in the opening inventory and want to have on hand at the end of each quarter the following quantities: 1st quarter, 3,000 units; 2nd quarter, 3,500 units; 3rd quarter, 4,000 units; and 4th quarter, 4,500 units.

Next, based on the production budget, prepare a budget to show the purchases needed during each of the four quarters. Expressed in terms of dollars, you do this by taking the production and inventory figures and multiplying them by the cost of material (previously estimated at $1.50 per unit). You could prepare a similar budget expressed in units.

Pro forma cash flow template

Now suppose you pay 50 percent of your accounts in the quarter of the purchase and 50 percent in the following quarter. Carryover payables from last year were $5,000. Further, you always take the purchase discounts as a matter of good business policy. Since net purchases (less discount) were figured into the $1.50 cost estimate, purchase discounts do not appear in the budgets.

Taking the data for quantities produced from the production budget in units, calculate the direct labor requirements on the basis of units to be produced. (The number and cost of labor hours necessary to produce a given quantity can be set forth in supplemental schedules.)

Figure the cash payments for manufacturing overhead by subtracting depreciation, which requires no cash outlay, from the totals above, and you will have the following breakdown.

Now comes the all important cash budget. You put it together by using the Collection of Accounts Receivable Budget; Selling Expenses Budget-Cash Requirements; Administrative Expenses Budget-Cash Requirements; Payment of Purchases Budget; Direct Labor Budget-Cash Requirements: and Manufacturing Budget Cash Requirements.

Take $15,000 as the beginning balance, and assume that dividends of $20,000 are to be paid in the fourth quarter.

In order to make the most effective use of your budgets to plan profits, you will want to establish reporting devices. Throughout the time span you have set, you need periodic reports and reviews on both efforts and accomplishments. These let you know whether your budget plan is being attained and help you keep control throughout the process. It is through comparing actual performance with budgeted projections that you maintain control of the operations.

Your company should be structured along functional lines, with well identified areas of responsibility and authority. Then, depending upon the size of your company, the budget reports can be prepared to correspond with the organizational structure of the company.

Pro forma budgeted income statement

Remember, the Cash Flow Statement used as the business's Budget allows the owner/manager to anticipate problems rather than react to them after they occur. It permits comparison of actual receipts and disbursements against projections to identify errors in the forecast. If cash flow is analyzed monthly, the manager can correct the cause of the error before it harms profitability.

Sidebar: you are invited to visit our car insurance information section featuring a list of articles that may save you hundreds of dollars on your motor vehicles quotes. In full coverage auto insurance you'll discover helpful tips to getting cheap quotes. For information on how to get cheaper quotes on shorter terms see one month car insurance and also short term car insurance. For first time drivers information see cheap car insurance for new drivers. How about obtaining cheaper premium rates for mature women? no problem, look here, best insurance for new drivers over 25 year olds.

If you are interested in a half year duration see 6 month car insurance for helpful tips on the topic. How about getting more favorable premiums costs for younger drivers? see car insurance for 17 year olds and motor car insurance for under 21 and vehicle insurance for male and female under 25 years old. Here is another list of drivers insurance useful articles, As for helpful tips regarding no deposit premium payments see car insurance with no deposit and for a list of low cost brokers, agents and companies see car insurance with no deposit companies. Read the following informative article if you are looking for better rates for the young drivers in your family, cheaper vehicle insurance for young drivers. Now, for discovering new ways to get lower quotes go to general car insurance Read this article if your after high risk car insurance information.

How about getting a better deal on first time driver? just click the link. It may come a time that you'll be interested in canceling your policy, use this article for the instruction of how to do it. Our drivers insurance hub page features a list of guides that can surely help you get dirt cheap car insurance for teens drivers rates. For those of you who seek cheap quotes for a shorter term policy, read this article. and here are tips and advice for special interest groups such as young drivers and temporary insurance.

If you have first drivers in your family look here for useful advice regarding cheap drivers first car insurance on getting very very cheap car insurance quotes, other types of policies can include the following: no deposit car insurance, pay monthly, insuring classic cars for young drivers, getting better deal on cheap liability car insurance cost, locating good rates for new drivers. how about if you are interested in pay as you go auto insurance? yep there is a guide for you. And here is a list of car insurance companies cheapest. And the list concludes with a way to calculate car insurance estimate without personal information.

Disclaimer: While every effort is made to ensure that the content of this website is accurate, the website is provided “as is” and makes no representations or warranties in relation to the accuracy or completeness of the information found on it. While the content of this site is provided in good faith, we do not warrant that the information will be kept up to date, be true and not misleading, or that this site will always (or ever) be available for use. Nothing on this website should be taken to constitute professional advice or a formal recommendation and we exclude all representations and warranties relating to the content and use of this site.

Copyright © by Bizmove. All rights reserved.