Cash Operating Expense Payments Worksheet    
     
     
 
  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 [1] 5-Week [2] Percentage[3]
Period Period OR of Sales
Cash Operating Expense Payments          
Salaries and Wages     3200 4000  
Employee Benefits     640 800  
Worker's Compensation     116 145  
Rent-Property     2200 2200  
Rent-Equipment          
Utilities     700 900  
Repairs and Maintenance         1.34%
Insurance     625 625  
Car & Truck Expenses     350 450  
Travel          
Entertainment         1.34%
Telephone     450 550  
Postage     75 100  
Office Supplies     90 115  
Advertising         2.68%
Marketing/Promotion          
Professional Fees     475 600  
Training and Development     300 300  
Bank Charges     10 10  
Credit Card Fees         0.34%
Miscellaneous          
Refinishing Supplies             1.57%
Shipping & Packing Supplies         1.79%
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
           
               
  Total Monthly Cash Operating Expense Disbursements 9,231 10,795
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 Be 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                              
Refinishing Supplies                                
Shipping & Packing Supplies                              
                                 
                               
                               
                               
                               
                               
                               
                                 
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                                 
  Total Cash Operating Expense Payments By Month                                
[1]
Enter your estimated payment amounts for a 4 week period for each of the different types of payments.
[2]
Enter your estimated payment amounts for a 5 week period for each of the different types of payments.
[3]
Enter a percentage of sales figure or amounts in the 4 and 5 week columns to the left  for the type of expense.