12 Months         Opening 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004   2004
to end Dec         Values Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec   Year
ASSUMPTIONS No. 6 - RECEIVABLES, PAYABLES & PHASING OF OPENING BALANCES Help with Entering Assumptions
 
   
   
Table 1 - Phasing Out of Opening Balance Sheet Items *  
          Opening values must be entered via opening balance sheet before the table below can be completed                           Total
Accounts receivable ($000) ->> 285.0 135.0 100.0 50.0     285.0
Accounts payable ($000) ->> 210.0 95.0 75.0 40.0     210.0
Capital expend. creditors ($000) ->> 45.0   45.0     45.0
Payroll taxes/benefits payable ($000) ->> 25.0 25.0     25.0
Interest payable ($000) ->>        
Taxes due ($000) ->>        
Dividends due ($000) ->>        
            *12-month total for each item must equal opening value in first column, otherwise ERR is indicated in Column B - Press F9 to check                          
   
Table 2 - Credit Distributions for Payables & Receivables for Current Year *    
   
        Months of credit given/taken:   Total*  
          Under 1 1-2 2-3 3-4 4-5 5-6 %  
Accounts payable for material/packaging & goods (% distribution *):                
 - Group1 ->> 20.0 50.0 15.0 10.0 5.0   100.0  
 - Group2 ->> 20.0 50.0 15.0 10.0 5.0   100.0  
Accounts receivable (% distribution *):                
 - Group1 ->> 15.0 65.0 10.0 5.0 5.0   100.0  
 - Group2 ->> 15.0 65.0 10.0 5.0 5.0   100.0  
      *Total for each row must equal 100%, otherwise an ERROR is indicated - Press F9 to check 100.0                
Supplementary Data & Calculations: