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 33.5 57.0 70.4 77.1 70.4 83.8 93.8 103.9 110.6 107.2 120.6 113.9  
Group3 16.5 28.1 34.7 38.0 34.7 41.3 46.2 51.2 54.5 52.8 59.4 56.1  
Group4 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 235 300 295 330 300 365 360 390 425 430 435 455  
Gross margin 109 152 162 170 159 180 190 196 220 227 221 230  
Income from operations -67 -26 -16 -9 -20 -1 9 14 37 43 37 44  
Net income before taxes -74 -33 -23 -18 -34 -13 -2 1 28 37 25 78  
  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 53.7 49.3 45.1 48.6 47.0 50.7 47.3 49.8 48.2 47.2 49.1 49.5  
Operational (indirect) exs 13.6 10.7 10.8 9.7 10.7 8.8 8.9 8.2 7.5 7.4 7.4 7.0  
Selling & freight 15.1 12.5 12.7 11.6 12.5 10.8 10.9 10.3 9.7 9.6 9.6 9.3  
Management/admin staff 21.3 16.7 16.9 15.1 16.7 13.7 13.9 12.8 11.8 11.6 11.5 11.0  
Research & development 8.9 7.0 7.1 6.4 7.0 5.8 5.8 5.4 4.9 4.9 4.8 4.6  
Administration 3.8 3.0 3.0 2.7 3.0 2.5 2.5 2.3 2.1 2.1 2.1 2.0  
Occupancy/general 6.2 4.8 4.9 4.4 4.8 4.0 4.0 3.7 3.4 3.4 3.3 3.2  
  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 85.5 90.6 113.8 128.8 148.6 163.3 53.1 56.6 54.7 47.9 62.7 47.2  
Net income before taxes (% sales) -31.4 -11.0 -8.0 -5.4 -11.2 -3.6 -0.5 0.2 6.6 8.6 5.6 17.1  
Gross margin (% sales) 46.3 50.7 54.9 51.4 53.0 49.3 52.7 50.2 51.8 52.8 50.9 50.5  
Current asset ratio (Right axis) 1.0 1.0 1.0 0.9 0.9 1.0 1.6 1.5 1.5 1.7 1.9 2.1  
  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 -90 -18 -37 -72 -38 85 259 -25 248 232 -128 86  
Closing net cash balance (deficit) -200 -219 -255 -327 -366 -280 -21 -46 201 433 305 391  
  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 20.0 21.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  
Indirect supervisory 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.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  
Research & development 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.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 238.5 255.4 263.7 276.6 274.3 292.9 299.8 308.4 320.4 331.3 335.5 339.6  
Receivables 361.2 369.5 353.8 403.7 386.7 442.6 450.3 481.9 522.7 537.4 548.4 569.7  
Payables 278.8 316.0 283.0 316.9 293.0 344.8 337.1 359.2 379.0 382.5 388.5 398.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 -90.1 -18.4 -36.7 -72.0 -38.5 85.2 259.1 -24.8 247.7 231.5 -128.4 85.9  
Net income before taxes -73.8 -33.0 -23.5 -17.8 -33.7 -13.0 -1.8 0.8 27.9 37.2 24.5 77.8  
  12 months commencing in Jan 2004    
  $ 000