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  
Group1 100.0 110.0 95.0 115.0 85.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0  
Group2 85.0 105.0 95.0 100.0 110.0 110.0 115.0 110.0 120.0 125.0 120.0 135.0  
  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 185 215 190 215 195 240 220 235 260 270 255 285  
Gross margin 121 142 122 138 119 154 135 147 166 170 153 173  
Income from operations -21 -0 -21 -4 -24 9 -9 3 21 24 7 27  
Net income before taxes -25 -4 -25 -9 -34 5 -14 -6 16 24 1 50  
  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 34.6 33.8 36.0 35.6 39.1 36.0 38.8 37.4 36.3 37.1 40.2 39.4  
Operational (indirect) exs 13.0 11.2 12.6 11.2 12.3 10.0 10.9 10.2 9.2 8.9 9.4 8.4  
Selling & freight 17.4 15.3 17.0 15.3 16.6 13.9 15.0 14.1 13.0 12.6 13.2 12.0  
Management/admin staff 27.0 23.3 26.3 23.3 25.6 20.8 22.7 21.3 19.2 18.5 19.6 17.5  
Administration 4.9 4.2 4.7 4.2 4.6 3.8 4.1 3.8 3.5 3.3 3.5 3.2  
Occupancy/general 7.8 6.7 7.6 6.7 7.4 6.0 6.6 6.2 5.6 5.4 5.7 5.1  
  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 71.8 64.3 79.0 86.0 97.8 101.1 66.2 70.9 68.9 60.8 83.5 67.3  
Net income before taxes (% sales) -13.5 -2.0 -13.0 -4.1 -17.4 1.9 -6.2 -2.5 6.3 8.9 0.2 17.7  
Gross margin (% sales) 65.4 66.2 64.0 64.4 60.9 64.0 61.2 62.6 63.7 62.9 59.8 60.6  
Current asset ratio (Right axis) 0.9 1.0 1.0 0.9 0.8 0.9 1.0 1.0 1.1 1.4 1.6 1.8  
  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 -71 24 -6 -52 -24 -19 76 -21 249 255 -131 59  
Closing net cash balance (deficit) -181 -157 -163 -215 -239 -258 -182 -204 46 301 170 229  
  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 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0 22.0 23.0  
Indirect operational 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0  
Sales 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0  
Clerical 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0  
Management 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.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 145.0 145.0 145.0 145.0 145.0 145.0 145.0 145.0 145.0 145.0 145.0 145.0  
Receivables 316.8 283.0 236.4 266.7 252.6 290.6 281.1 294.3 320.3 335.2 327.2 353.4  
Payables 215.9 202.7 167.6 176.3 178.5 187.4 190.2 192.0 197.5 204.2 207.7 217.8  
  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 -70.6 24.0 -6.1 -52.1 -23.7 -19.4 75.7 -21.2 249.5 255.4 -131.1 59.2  
Net income before taxes -24.9 -4.3 -24.7 -8.7 -33.9 4.6 -13.7 -5.8 16.3 24.0 0.5 50.4  
  12 months commencing in Jan 2004    
  $ 000