Cash Projection Summary          
           
Return To Tutorial          
           
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.        
           
           
Return To Tutorial