12 Months           2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2006    
to end Jan     Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Jan    
MONTHLY ASSUMPTIONS No. 8 - SALES & RELATED TAXES Help with Entering Assumptions
   
     
Specify descriptive term for sales or input/output tax: Sales Tax  Press F9 to update        Set cells below to zero if sales taxes (or other similar taxes) are not applicable  
     e.g. enter "Sales Tax", "GST" for Goods & Services Tax, "VAT" for Value Added Tax etc.    
     
Average Sales Tax rates on sales (%):                            
 - Group1 ->> 7.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0    
 - Group2 ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0    
 - Group3 ->>                            
 - Group4 ->>                            
 - Group5 ->>                            
 - Group6 ->>                            
                             
Total Sales Tax on sales ($000):    
 - Group1 7.0 7.7 6.7 8.1 6.0 9.1 7.4 8.8 9.8 10.2 9.5 10.5    
 - Group2 1.7 2.9 3.5 3.9 3.5 4.2 4.7 5.2 5.5 5.4 6.0 5.7    
 - Group3    
 - Group4    
 - Group5    
 - Group6    
Total Sales Tax on sales ($000) 8.7 10.6 10.2 11.9 9.5 13.3 12.0 13.9 15.3 15.5 15.5 16.2    
     
Calculate Sales Tax on an invoice (enter 0)    
  or cash-received (enter 1) basis ? ->>    Enter 0 or 1    
  Enter "1" for each payment month                    
Mark months when Sales Tax paid to State ->> 1 1 1 1 1 1 1 1 1 1 1 1    
                             
Average Sales Tax rate for purchases of                            
  materials/packaging & goods (%) ->>        
                             
Percent of all other non-payroll expenses                            
  (operating exs etc) subject to Sales Tax (%) ->> 90.0 90.0 90.0 90.0 90.0 90.0 90.0 90.0 90.0 90.0 90.0 90.0    
Average Sales Tax rate for non-payroll exs (%) ->>        
Total Sales Tax on non-payroll expenses ($000)                            
     
Percent of capital expenditure, lease repayments                            
   and interest subject to Sales Tax (%) ->> 80.0 80.0 80.0 80.0 80.0 80.0 80.0 80.0 80.0 80.0 80.0 80.0    
Average Sales Tax rate for these items (%) ->>        
Sales Tax on capex & leases less disposals($000)                            
                                       
 
Supplementary Data & Calculations: