Charts    
       
       
  Fig 1. Cashflows for Year
 
 
Fig 2. Short-Term Cashflows
Fig 3. Working Capital
 
   
         
         
         
       
  Fig 4. Sales Analysis
 
 
Fig 5. Sales & Income
Fig 6. Cost Analysis
 
   
         
         
         
       
   
Fig 7. Performance Ratios
Fig 8. Headcount
Fig 9. Cashflow vs Income
 
   
       
       
         
       
       
       
       
 
     
       
        Top
 
 
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
 
 
   
       
        Top
 
 
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
 
 
   
       
        Top
 
 
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
 
     
         
      Top
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
 
  Top
 
 
 
     
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
 
  Top
 
 
 
 
     
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
 
  Top
 
 
 
 
 
     
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
 
  Top
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
 
  Top
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Chart Values - These items will not be printed.  
Note that the values below have been mainly derived from the Income and BalSheet worksheets used for the US/Canadian version.
If major structural changes are made to the P&L and Balances worksheets for the UK/International version,   
some changes to formulae below may be required.  
Any Corp Inc       Fig. 4 - Sales Analysis      
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
 Subgroup a 17.0 17.5 18.0 18.5 19.0 19.5 20.0 20.5 21.0 21.5 22.0 22.5  
 Subgroup b 5.0 5.3 5.5 5.8 6.1 6.4 6.7 7.0 7.4 7.8 8.1 8.6  
 Subgroup c                          
 Subgroup d                          
 Subgroup e                          
  12 months commencing in Jan 2004    
  $ 000    
Any Corp Inc       Fig. 2 - Short-Term Cashflows    
Any Corp Inc       Fig. 5 - Sales & Income    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Total sales 22 23 24 24 25 26 27 28 28 29 30 31  
Gross margin 9 9 10 10 10 10 10 11 11 12 12 12  
Income from operations 1 1 2 2 2 2 2 3 3 3 4 4  
Net income before taxes 0 1 3 1 1 2 2 2 3 3 3 3  
  12 months commencing in Jan 2004    
  $ 000    
Any Corp Inc       Fig. 6 - Cost Analysis    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cost of sales 58.6 58.4 58.3 59.9 59.7 59.5 61.0 60.7 60.5 60.3 60.0 59.8  
Selling & freight 4.3 4.2 4.1 4.1 4.0 3.9 3.9 3.8 3.8 3.7 3.7 3.6  
Management/admin staff 12.5 12.1 11.7 11.3 11.0 10.6 10.3 10.0 9.7 9.4 9.1 8.9  
Admin/establish 11.8 11.4 11.1 10.7 10.4 10.0 9.7 9.4 9.2 8.9 8.6 8.4  
  12 months commencing in Jan 2004    
  As % sales    
Any Corp Inc        Fig. 7 - Performance Ratios    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Net debt as % owners' equity 93.2 78.6 77.2 77.9 73.0 67.4 62.0 56.2 87.2 80.2 72.7 64.9  
Net income before taxes (% sales) 2.2 3.5 13.4 4.6 5.9 7.2 6.9 8.1 8.8 8.6 9.8 11.0  
Gross margin (% sales) 41.4 41.6 41.7 40.1 40.3 40.5 39.0 39.3 39.5 39.7 40.0 40.2  
Current asset ratio (Right axis) 1.2 1.4 1.8 1.8 1.9 2.0 1.9 2.1 1.3 1.3 1.4 1.5  
  12 months commencing in Jan 2004    
Any Corp Inc        Fig. 1 - Cashflows for Year    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Net cashflow -11 5 9 -6 3 3 -2 3 -26 -1 4 5  
Closing net cash balance (deficit) -33 -28 -20 -26 -24 -21 -23 -19 -46 -47 -43 -38  
  12 months commencing in Jan 2004    
  $ 000    
Any Corp Inc        Fig. 8 - Headcount    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Direct 1.0 1.0 1.0 1.5 1.5 1.5 2.0 2.0 2.0 2.0 2.0 2.0  
Clerical 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0  
Management 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0  
  12 months commencing in Jan 2004    
  Persons    
Any Corp Inc        Fig. 3 - Working Capital    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Inventory 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0  
Receivables 34.6 29.9 28.1 30.2 31.1 32.2 33.2 34.2 35.3 36.4 37.5 38.6  
Payables 23.7 20.2 17.2 15.3 15.8 16.3 16.8 17.3 17.8 18.4 19.0 19.5  
  12 months commencing in Jan 2004    
  $ 000    
Any Corp Inc        Fig. 9 - Cashflow vs Income    
  Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Net cashflow -11.1 4.7 8.6 -6.2 2.5 2.9 -1.9 3.3 -26.5 -1.2 4.2 4.6  
Net income before taxes 0.5 0.8 3.1 1.1 1.5 1.9 1.8 2.2 2.5 2.5 2.9 3.4  
  12 months commencing in Jan 2004    
  $ 000