Weekly Cash Forecast Worksheet Return To Tutorial              
                   
 
                 
  Instructions                
  This worksheet is where you can pick a month and estimate      
  your cash flow by each week within the month.        
                   
  Once again , the yellow highlighted area is where you enter      
  information.                
                   
  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 thecategories. 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 CapitalM to use the Manual Budget A
Calculated Amounts or a CapitalA 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          
  (2,690) (2,690) (2,690)    
             
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 (2,690) (2,690) (2,690)      
             
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 usedin 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 (2,690) (2,690)   (2,690) (2,690)   (2,690) (2,690)                    
                                     
                                     
Plus:                                    
Cash Collections                                    
                                     
Less:                                    
Cash Payments                                    
                                     
Ending Cash (2,690) (2,690)   (2,690) (2,690)   (2,690) (2,690)              
                                     
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 thecategories. 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/RCash 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
CashCollected 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/PBy 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          
Return To Tutorial