Components of Cash Flow

Five Components of Murray's 200X Forecasted Cash Flow Statement:

1. THE HEADING
The heading is an extremely important part of the Cash Flow Statement. It communicates to the reader the name of the company, the type of statement that will follow (in this case, the statement will be the forecasted cash flow statement), and the date or range of months the statement pertains to.

SCHOLARSHIP INFORMATION SERVICES
FORECASTED CASH FLOW STATEMENT
From JULY 1, 200X to DECEMBER 31, 200X

2. THE ASSUMPTIONS
The Assumptions section basically sets the tone for the Cash Flow Statement. It highlights various pieces of data or information used to develop the Forecasted Cash Flow Statement. As a result, readers can better understand and comprehend the numbers and values presented throughout the statement. Below illustrates Murray's 200X Assumptions:

ASSUMPTIONS: JULY AUG. SEPT. OCT. NOV. DEC. TOTALS
Forecasted Sales in units 4,000 4,000 4,000 4,000 4,000 4,000 4000 units
Monthly Sales Percentages 18% 23% 24% 13% 10% 12% 100%
Units Sales per Month 720 920 960 520 400 480 4000 units
Selling Price Per Unit Sold $26 $26 $26 $26 $26 $26
Total Cost per Unit $3 $3 $3 $3 $3 $3

Please Note: some business plan writers do NOT include an Assumptions Section as part of their Forecasted Cash Flow Statement. In this case, the business plan writer simply places their Cash-Flow Statement Assumptions under the Appendices Section of their Business Plan.

3. CASH INFLOWS
The third component of Murray's Forecasted Cash Flow Statement is Cash Inflows. Cash Inflows represent the cash coming into a company. More importantly, cash inflows predicts when (which months) money will enter the business. Examples of possible cash inflows include; sales from customers, bank loans, loans from family members for business use only, government grants, government loans, cash invested into the business by its owners, and interest earned on the businesses' cash in the bank. Below illustrates Murray's Forecasted Cash Inflows from July through to December 31, 200X:

CASH INFLOWS: JULY AUG. SEPT. OCT. NOV. DEC. TOTALS
From Sales $18,720 $23,920 $24,960 $13,520 $10,400 $12,480 $104,000
Cash at Beginning of Month $ 7,500 $ 2,237 $10,056 $18,690 $17,060 $12,767
Total Cash Available $26,220 $26,157 $35,016 $32,210 $27,460 $25,247

As you can see, Murray anticipates $26,220 will enter the company in July, 200X - resulting from sales of $18,720, and from a personal cash investment of $7,500. And so on...

4. CASH OUTFLOWS
Cash Outflows, also referred to as Cash Disbursements, represent the cash leaving a company for payment on bills/expenses, for equipment purchases, for withdraws, or for paying dividends. More importantly, however, cash outflows predicts when (which month) money will leave the company. Examples of cash outflows include, cash for advertising, rent, utilities, business registration, telephone, bank & service charges, wages & salaries, employer costs, correspondence materials, office supplies, income taxes, owner's cash drawings, purchases of equipment, dividends paid to shareholders, and the list goes on and on. The general rule of thumb is that all expenses appearing on the income statement (except for depreciation expenses), office equipment purchases, income taxes, drawings by owners, and dividends paid to shareholders are all considered cash outflows. Below illustrates Murray's Cash Outflows from July to December 31, 200X.

CASH DISBURSEMENTS: JULY AUG. SEPT. OCT. NOV. DEC. TOTALS
Direct Material Purchases $ 0 $4,644 $2,868 $1,692 $1,236 $1,416 $11,856
Promotional Pamphlets $4000 $ 0 $ 0 $ 0 $ 0 $ 0 $ 4,000
University Advertising $ 0 $ 0 $2000 $2,000 $2,000 $2,000 $ 8,000
Newspaper Advertising $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $25,998
Office Salaries $2,600 $2,600 $2,600 $2,600 $2,600 $2,600 $15,600
Employer Costs $ 286 $ 286 $ 286 $ 286 $ 286 $ 286 $ 1,716
Office Supplies $2,500 $ 0 $ 0 $ 0 $ 0 $ 0 $ 2,500
Business Cards, etc. $ 250 $ 0 $ 0 $ 0 $ 0 $ 0 $ 250
Printing of Checks $ 75 $ 0 $ 0 $ 0 $ 0 $ 0 $ 75
Telephone $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 1,200
Legal Fees $1,200 $ 0 $ 0 $ 0 $ 0 $ 0 $ 1,200
Message Centre $ 767 $ 767 $ 767 $ 767 $ 767 $ 767 $ 4,600
Toll Free Services $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $ 9,600
Credit Card Service $ 832 $ 832 $ 832 $ 832 $ 832 $ 832 $ 4,992
Bank Charges $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 240
Miscellaneous $ 300 $ 300 $ 300 $ 300 $ 300 $ 300 $ 1,800
Income Taxes $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Cash Withdrawals $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 3,000
Equipment Purchased $4,500 $ 0 $ 0 $ 0 $ 0 $ 0 $ 4,500
Total Disbursements $23,983 $16,102 $16,326 $15,150 $14,694 $14,874 $101,127

As you can see, Murray anticipates $23,983 cash will be needed in July for paying corporate bills, purchasing office equipment, and for owner withdraws. In August, $16,102 in cash is expected to "leave" the company, and so on.. Note: deprecation expenses are NEVER considered a cash outflow. Moreover, cash does not leave the company to pay depreciation - it is a non-cash expense.

5. ENDING CASH BALANCE
The ending cash balance is calculated by subtracting the "Total Cash Outflows" FROM the "Total Cash Inflows". Below illustrates Murray's Forecasted Ending Cash from July to December 31, 200X.

JULY AUG. SEPT. OCT. NOV. DEC.
ENDING CASH BALANCE $ 2,237 $10,056 $18,690 $17,060 $12,767 $10,373

As you can see, Murray is forecasting to have $2,237 in his bank account AT THE END OF July, 200X. On August 31, 200X, he is forecasting to have $10,056 in his bank account, and so on. Notice that all of Murray' ending cash balances are positive. This means that he is forecasting to have money in his bank account each month during the six month period (July to December). If in any month, however, the ending cash balance was negative, then Murray would require some sort of financing for that month. The financing might include a loan from the bank, a loan from a family member, a government loan or grant, etc. For more information on how to account for negative ending cash balances, please refer to the section entitled "The Cash Flow Statement".

ONE FINAL NOTE ON THE ENDING CASH BALANCE:

Your Ending Cash balance ALWAYS becomes your Beginning Cash for the following month. Therefore, Murray's July 31 Forecasted Ending Cash of $2,237 becomes his August 1 Beginning Cash. Murray's August 31 Forecasted Ending Cash of $10,056 becomes his September 1 Beginning Cash, and so on... Think of it this way, a company's ending cash will be used in the next month to pay bills, to purchase equipment, to pay taxes, to pay dividends, etc.

Your Cash Flow statement must account for the transition of ending cash to beginning cash. This transition can be seen in Murray's "Cash Inflow" section of his forecasted cash flow statement; labeled "Cash at Beginning of Month" - shown below.

CASH INFLOWS: JULY AUG. SEPT. OCT. NOV. DEC.
From Sales $18,720 $23,920 $24,960 $13,520 $10,400 $12,480
Cash at Beginning of Month $ 7,500 $ 2,237 $10,056 $18,690 $17,060 $12,767
Total Cash Available $26,220 $26,157 $35,016 $32,210 $27,460 $25,247

As you can see, the Cash at the beginning of July simply refers to Murray's personal cash investment into the company. The Cash at the beginning of the August, however, represents Murray's forecasted ending cash balance in July. The cash at the beginning of September refers Murray's forecasted ending cash balance in August, and so on... When developing your Forecasted Cash Flow Statement(s), be sure to account for this transition of ending cash to beginning cash.

Categories: Forecasting