12 Months         Opening 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2006   05-06
to end Jan         Values Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Jan   Year
MONTHLY ASSUMPTIONS No. 7 - OPENING BALANCE SHEET ITEMS, RECEIVABLES & PAYABLES  
  Help with Entering Assumptions
 
   
Phasing out of opening          Opening values entered via opening balance sheet                            
   balance sheet items*           *12 month total for each item must equal opening value in first column, otherwise ERR is indicated in Column B - Press F9 to check                           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
Taxes due ($000) ->>        
Dividends due ($000) ->>          
                                       
Collection patterns for payables       Months of credit given/taken:   Total*  
 & receivables for current year*       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  
 - Group3 ->> 20.0 50.0 15.0 10.0 5.0   100.0  
 - Group4 ->> 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  
 - Group3 ->> 15.0 65.0 10.0 5.0 5.0   100.0  
 - Group4 ->> 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: