Cash Operating Expense Payments Worksheet Return To Tutorial                
                             
                             
 
      Instructions                    
        This worksheet is where you enter your other cash payments.             
        The worksheet provides you with two methods for entering your estimates.            
                             
        (1) The first method allows you to enter estimate amounts for 4 week and 5 week periods OR        
        enter a percentage of sales to use to calculate the expense. This information is then transferred        
        to the Cash Projection Worksheet and entered in each of the monthly columns based on the        
        percentage entered or whether the amounts entered represent a 4 week or 5 week period.          
        If entering amounts, both the 4 Week and 5 Week amounts need to be entered.          
        The percentage of sales figures or the monthly estimated amounts are entered in          
        the Estimated Monthly Totals Table.                
                             
        (2) The second method allows you to enter amounts for each of the months that you are estimating.        
        This information is entered in the Estimate Each Month Table.            
                             
        You can combine the two methods and enter some disbursements as a percentage or monthly        
         four (4) and five (5) week periods in the Estimated Monthly Totals Table and enter other data individually        
         for each month in the Each Month Table or you can enter all your data in either table.          
                             
                             
Do not enter data for the same type of payment in both tables.  In other words if you use the Estimated Monthly Totals Table to enter your Salaries and Wages        
Estimate don't also enter Salaries and Wages in the Estimate Each Month Table.                  
                             
Enter Your Estimates in the Yellow Highlighted Areas of the tables.                    
                             
Additional space has been provided in the table below for you to add up to 25 additional expenses that you want to include..            
Add your new categories to the yellow highlighted portion of the Estimated Monthly Totals Table. These same categories              
are automatically added to your Estimate Each Month Table. The added categories will then be displayed and available to use            
to enter data for the new categories in both tables.                      
                             
Introduction                            
CashProjection Worksheet                          
Sales Forecast Worksheet                          
Weekly Forecast Worksheet                          
Charts Worksheet                            
                             
Cash Operating ExpensePayments  
Estimated Monthly Totals Table  
This is a quick method for entering your estimated  cash operating payments (expenses).
Enter an amount for both a 4 week and 5 week period OR a percentage of sales amount
for any or all of the listed payment types. Items not entered in this table should be entered in the
Estimate Each Month Table.  If you enter amounts or a percentage for a category in this sheet
don't also enter an amount for the same category in the Estimate Each Month Table.
If you want to add some additional payment categories, add the new categories in the
yellow highlighted portion of the table below.
Note: Categories added in this table are also automatically added to the Estimate Each Month Table.
4-Week 5-Week Percentage
Period Period OR of Sales
Cash Operating Expense Payments          
Salaries and Wages              
Employee Benefits              
Worker's Compensation              
Rent-Property              
Rent-Equipment              
Utilities              
Repairs and Maintenance            
Insurance              
Car & Truck Expenses              
Travel              
Entertainment              
Telephone              
Postage              
Office Supplies              
Advertising              
Marketing/Promotion              
Professional Fees              
Training and Development            
Bank Charges              
Credit Card Fees              
Miscellaneous              
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
  Total Monthly Cash Operating Expense Disbursements    
Estimate Each Month Table  
This method requires the user to enter the estimated amounts for the number.
of periods that the user wants to prepare an estimate for. The number of periods
that need to be entered is the number of periods that you entered in the
Cash Projection Worksheet and appears at the top of the worksheet.
that need to be entered is the number of periods that you entered in the
If you enter amounts for a category in this sheet don't also enter an amount
for the same category in the Estimated Monthly Totals Table.
Estimate Each Month Table     Number Of Periods Needing To Entered:   12
Cash Operating Expense Payments       Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total
Salaries and Wages                                
Employee Benefits                                
Worker's Compensation                                
Rent-Property                                
Rent-Equipment                                
Utilities                                
Repairs and Maintenance                              
Insurance                                
Car & Truck Expenses                                
Travel                                
Entertainment                                
Telephone                                
Postage                                
Office Supplies                                
Advertising                                
Marketing/Promotion                                
Professional Fees                                
Training and Development                              
Bank Charges                                
Credit Card Fees                                
Miscellaneous                                
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
  Total Cash Operating Expense Payments By Month                                
Return To Tutorial