Weekly Cash Forecast Worksheet            
             
             
Once again , the yellow highlighted area is where you enter            
information.            
             
             
Instructions            
This worksheet is where you can pick a month and estimate            
your cash flow by each week within the month.            
             
You need to enter the number of the period that you want            
to see and analyze by week. If you want to work with period 1            
enter a 1, period 2 enter a 2, and so on.            
             
You can enter your actual cash balance or the estimated cash          
balance that is shown in the line- Cash Estimated in Worksheet.          
The Automatic Calculation uses all the information that you have previously entered and spreads the monthly amount evenly
to each of the weeks.            
             
The Manual Calculation allows the user to specify the monthly amounts that are spread or allocated to each week,  
I have provided you with two options. You can either (1) enter a percentage to use to spread the month's total amount or you can
(2) enter an actual dollar amount. Only use one of the options either the percentage method or the dollar input method  
for each of the  categories. You can use a different method for each of the categories but don’t enter a percentage and  
also a dollar amount for the same category.            
             
You need to enter a percentage or dollar amount (but not both) if you use the manual method to allocate     
your weekly receipts and payments.            
             
             
Introduction            
Cash Projection Worksheet            
Sales Forecast Worksheet            
Cash Payments Worksheet            
Charts Worksheet            
             
 
 
Cash Forecast For Specified Period
 
 
Enter Monthly Period (1,2,3, etc) 1
 
Number Of Weeks in Period 5
  Number of Weeks in the Period are automatically
  displayed based on the period you enter above.
 
 
Enter a Capital  M to use the Manual Budget  A
Calculated Amounts or a Capital  A to use 
the Automatic Budget Calculations.
 
 
 
 
Automatic Cash Forecast
 
This Cash Estimate is automatically calculated for you based on the data   
you have already entered earlier. The only amount the user is allowed to change is the
Beginning Cash Balance. The Beginning Cash Balance calculated for the month is 
displayed.You can enter this amount, or if known, enter your Actual Beginning
Cash Balance for the period. The calculated amounts used in this schedule
are contained in the Automatic Calculation and Allocation section of this worksheet.
The automatic calculation spreads the receipts and payments equally over
the number of weeks in the period.    
 
 
 
  Month
Cash Summary 1          
Automatic Total Week 1 Week 2 Week 3 Week 4 Week 5
             
Enter Beginning Cash Amount          
           
             
Plus:            
  Cash Collections            
Accounts Receivable-Collections             
Cash Sales            
Other Receipts and Collections            
  Total Cash Collections            
             
Less:            
  Cash Payments            
Accounts Payable Payments            
Other Amounts Owed Prior Period            
Cash Purchases            
Payroll Expenses            
Cash Operating Expenses            
Sales Tax            
Note Payments            
Equipment Purchases            
Owner's Draws / Dividends            
Income and Other Taxes            
Other Payments            
  Total Cash Payments            
             
Ending Cash            
             
Increase / <Decrease> For Period            
 
 
 
Manual Cash Forecast
 
The Beginning Cash Balance calculated for the month is displayed. You can 
enter this amount,  or if known, enter your Actual Beginning Cash Balance       
for the period. The calculated amounts used  in this schedule are    
contained in the Manual Allocation section of this worksheet.  
 
 
 
  Month
Cash Summary 1          
Manual Total Week 1 Week 2 Week 3 Week 4 Week 5
             
Enter Beginning Cash Amount          
             
             
Plus:            
  Cash Collections            
Accounts Receivable-Collections             
Cash Sales            
Other Receipts and Collections            
  Total Cash Collections            
             
Less:            
  Cash Payments            
Accounts Payable Payments            
Other Amounts Owed Prior Period            
Cash Purchases            
Payroll Expenses            
Cash Operating Expenses            
Sales Tax            
Note Payments            
Equipment Purchases            
Owner's Draws / Dividends            
Income and Other Taxes            
Other Payments            
  Total Cash Payments            
             
Ending Cash            
             
Increase / <Decrease> For Period            
 
 
 
 
Actual Cash and Budget Comparison
 
Enter your actual collections and payments
for each weekly period in the yellow highlighted cells.
 
  Month
  1 Totals   Week 1 Week 1   Week 2 Week 2   Week 3 Week 3   Week 4 Week 4   Week 5 Week 5  
  Budget Actual Difference Budget Actual Difference Budget Actual Difference Budget Actual Difference Budget Actual Difference Budget Actual Difference
                                     
Beginning Cash                                    
                                     
                                     
Plus:                                    
  Cash Collections                                    
                                     
Less:                                    
  Cash Payments                                    
                                     
Ending Cash                            
                                     
Increase / <Decrease> For Period                                    
 
 
 
Calculations and Allocations
 
Automatic Calculation and Allocation
 
This calculation is done automatically and spreads the totals for the month  
evenly between the weeks. In other words each week's receipts and  
payments are assumed to be the same. These figures are the weekly amounts
used in the Automatic Cash Forecast.    
 
 
 
  Total Week 1 Week 2 Week 3 Week 4 Week 5
  Cash Collections            
Accounts Receivable-Collections Prior Period            
Accounts Receivable-Collections Current Periods            
Cash Sales            
Other Receipts and Collections            
  Total Cash Collections            
             
             
  Cash Payments            
Accounts Payable Payments-Prior Periods            
Accounts Payable Payments-Current Periods            
Other Amounts Owed Prior Period            
Cash Purchases            
Payroll Expenses            
Cash Operating Expenses            
Sales Tax            
Note Payments            
Equipment Purchases            
Owner's Draws / Dividends            
Income and Other Taxes            
Other Payments            
  Total Payments            
 
 
 
Manual Allocation 
             
I have provided you with two options. You can either (1) enter a percentage to use to spread the month's total amount or you can
(2) enter an actual dollar amount. Only use one of the options either the percentage method or the dollar input method  
for each of the  categories. You can use a different method for each of the categories but don’t enter a percentage and  
also a dollar amount for the same category.            
             
  Total Week 1 Week 2 Week 3 Week 4 Week 5
             
Cash Collected Accounts Receivable
  Weeks %            
  Amounts Calculated Based On %            
OR  
A/R  Cash Collected By Week Input By User            
   
   
Cash Collected Cash Sales  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Cash Sales Collected By Week Input By User            
   
Cash Collected Other Receipts and Collections  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Cash  Collected Other Receipts Input By User            
   
Payments For Cash Purchases  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Payments For Cash Purchases By Week Input By User            
   
Payments For Accounts Payable  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Payments For A/P  By Week Input By User            
   
Cash Payroll Expense Payments  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Cash Payroll Expense Payments By Week Input By User            
   
Cash Operating Expense Payments  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Cash Operating Expense Payments By Week Input By User            
   
Sales Tax Payments  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Sales Tax Payments By Week Input By User            
   
Other Prior Amounts Owed Payments  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Other Prior Amount Payments By Week Input By User            
   
Note Payments  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Note Payments By Week Input By User            
   
Equipment Purchases  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Equipment Purchases Input By Week By User            
   
Owner's Draws / Dividends  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Owner's Draws / Dividends Input By Week By User            
   
Income and Other Taxes  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Income and Other Taxes Input By Week By User            
   
Other Payments  
  Weeks %            
  Amounts Calculated Based On %            
OR  
Other Payments Input By Week By User