| Cash Projection Summary | |||||
| The Cash Projection Summary Section | |||||
| summarizes the results of all the detailed schedules, | |||||
| calculations, analysis, and assumptions used in developing | |||||
| your Cash Forecast. | |||||
| Cash Projection Summary | Totals | Month 1 | Month 2 | Month 3 | |
| Enter Beginning Cash Amount | This line is used to enter the Beginning Cash | ||||
| Beginning Cash | Balance which is then used to automatically calculate | ||||
| the Beginning Cash Balance for future periods based. | |||||
| on the Cash Collections and Cash Payments made in | |||||
| each period. | |||||
| Plus: | |||||
| Cash Collections | This section is used to summarize and identify | ||||
| the sources of your estimated cash inflows (receipts). | |||||
| Accounts Receivable-Collections Prior Period | This line summarizes and identifies the collections | ||||
| from your prior year's customer balances that were | |||||
| not collected as of the end of the year or beginning | |||||
| of your Cash Forecast. The balance is brought | |||||
| forward from the Accounts Receivable Prior Period Schedule. | |||||
| Accounts Receivable-Collections Current Periods | This line summarizes the estimated collections | ||||
| by month that are calculated and brought forward | |||||
| from the calculation section called | |||||
| Current Year Accounts Receivable Collections. | |||||
| Cash Sales | This line summarizes and brings forward the estimated | ||||
| "cash" sales a business anticipates from the calculation | |||||
| section named Current Year Cash Sales . | |||||
| Sale Of Equipment | This line summarizes your estimated receipts resulting | ||||
| from the sale of any equipment. The amounts are | |||||
| brought forward from the Other Cash Receipts Section. | |||||
| Loans | This line summarizes your estimated receipts resulting | ||||
| from any needed or planned loans during the | |||||
| periods estimated. The amounts are brought forward | |||||
| from the Other Cash Receipts Section. | |||||
| Owner's Investments / Stock Sales | This line summarizes your estimated receipts resulting | ||||
| from any owner contributions or sale of stock | |||||
| planned for during the periods estimated. The amounts | |||||
| are brought forward from the Other Cash Receipts Section. | |||||
| Other Receipts and Collections | This line summarizes any other collections that your | ||||
| business anticipates will occur during the periods estimated. | |||||
| The amounts are brought forward from the | |||||
| Other Cash Receipts Section. | |||||
| Total Cash Collections | This line just totals up and provides the total estimated | ||||
| Cash Collections for the estimated periods. | |||||
| Less: | |||||
| Cash Payments | This section is used to summarize and identify | ||||
| what you will have to pay out (cash outflow) during | |||||
| the periods estimated and what the payment was for. | |||||
| Accounts Payable Payments-Prior Periods | This line summarizes and identifies the payments | ||||
| on amounts owed to your suppliers that were not paid | |||||
| as of the end of the year or beginning of your forecast. | |||||
| The amounts are brought forward from the Accounts Payable | |||||
| Prior Periods Payments Section. | |||||
| Other Amounts Owed Prior Period | This line summarizes and identifies the payments | ||||
| on other amounts owed and not paid as of the end of the | |||||
| year or beginning of your forecast period. The amounts | |||||
| are brought forward from the Other Amounts Owed | |||||
| Prior Period Payments Section. | |||||
| Accounts Payable Payments-Current Periods | This line summarizes the estimated payments | ||||
| made for purchases made on credit during your | |||||
| forecast periods. The amounts are brought forward from | |||||
| the Accounts Payable Payments Current Periods Section | |||||
| Cash Purchases | This line summarizes and brings forward the estimated | ||||
| cash purchases a business anticipates from the calculation | |||||
| section named Cash Purchases Current Periods. | |||||
| Payroll Expenses | This line summarizes your estimated payments needed for | ||||
| your payroll expenses including payroll taxes and | |||||
| fringe benefits. A total of your payroll expenses is | |||||
| automatically calculated that sums your estimated | |||||
| salaries and wages,employee benefits, social | |||||
| security and medicare taxes, and federal and state | |||||
| unemployment. The calculated amounts are brought | |||||
| forward from the section named Cash Operating | |||||
| Expense Payments. | |||||
| Operating Expense Payments | This line summarizes your estimated payments needed for | ||||
| your operating expenses excluding payroll expenses. | |||||
| These amounts are totalled and brought forward | |||||
| from the Cash Operating Payments Section | |||||
| based on the amounts that you estimated by | |||||
| period for each type of expense. | |||||
| Sales Tax | This line summarizes the estimated payments | ||||
| that you need to pay during the periods estimated | |||||
| based on your estimated sales and sales tax rate. | |||||
| These amounts are calculated and brought forward from | |||||
| Sales Tax Payments Section. | |||||
| Note Payments | This line summarizes the estimated payments | ||||
| needed by period to pay any current and / or | |||||
| additional notes that you planned on obtaining | |||||
| during any of the forecast periods. The amounts | |||||
| include principal and interest. These amounts are brought | |||||
| forward from Other Payments Section. | |||||
| Equipment Purchases | This line summarizes the estimated payments | ||||
| needed by period to pay for any planned equipment | |||||
| purchases. These amounts are brought forward | |||||
| from the Other Payments Section. | |||||
| Owner's Draws / Dividends | This line summarizes the estimated payments | ||||
| needed by period to pay for owner draws or dividends | |||||
| paid to shareholders. These amounts are brought forward | |||||
| from the Other Payments Section. | |||||
| Income and Other Taxes | This line summarizes the estimated payments | ||||
| needed by period to pay for income and other | |||||
| business taxes. These amounts are brought forward | |||||
| from the Other Payments Section. | |||||
| Other Miscellaneous Payments | This line summarizes any other estimated payments | ||||
| your business anticipates will occur during the | |||||
| periods estimated.These amounts are summarized and | |||||
| brought forward from the Other Miscellaneous | |||||
| Payments Section. | |||||
| Total Cash Payments | This line just totals up and provides the total estimated | ||||
| Cash Payments for the estimated periods. | |||||
| Ending Cash | This line is calculated by adding the Beginning Cash | ||||
| Balance plus the Total Cash Collections and subtracting | |||||
| the Total Cash Payments. | |||||
| Increase / <Decrease> For Period | This line is calculated by subtracting the | ||||
| Total Cash Payments from the Total Cash Collections. | |||||
| A positive amount indicates an increase in the Cash | |||||
| Balance for a period while a negative amount indicates | |||||
| a decrease in the Cash Balance for a period. | |||||
| Additional Cash Needed | |||||
| Supplied By: | |||||
| Short Term Borrowing Needs | This line is automatically calculated if any future | ||||
| period's calculated cash balance is negative. | |||||
| Short Term Repayments | This line is automatically calculated if any future | ||||
| borrowings were needed in prior periods and | |||||
| an open balance still remains. | |||||
| Current Loan Balance | This line is automatically calculated and | ||||
| is the current balance of your short tem borrowings. | |||||
| Cash Including Short Term Loans | This line is automatically calculated and | ||||
| is the balance of your cash plus any current | |||||
| loan balance outstanding. | |||||