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 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0  
Group5 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0  
Group6 85.0 105.0 95.0 100.0 110.0 110.0 115.0 110.0 120.0 125.0 120.0 135.0  
Group7                          
Group8                          
Group9                          
Group10                          
  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 265 330 325 360 330 395 390 420 455 460 465 485  
Gross margin 139 175 183 193 180 204 211 219 242 249 243 252  
Income from operations -46 -12 -4 4 -8 14 21 28 50 55 50 58  
Net income before taxes -53 -19 -11 -4 -21 2 11 15 42 50 38 92  
  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 47.7 46.9 43.6 46.5 45.5 48.4 45.9 48.0 46.7 45.9 47.7 48.0  
Operational (indirect) exs 12.1 9.7 9.8 8.9 9.7 8.1 8.2 7.6 7.0 7.0 6.9 6.6  
Selling & freight 16.8 14.1 14.2 13.1 14.1 12.2 12.4 11.7 11.0 10.9 10.8 10.5  
Management/admin staff 18.9 15.1 15.4 13.9 15.1 12.7 12.8 11.9 11.0 10.9 10.8 10.3  
Research & development 7.9 6.4 6.5 5.8 6.4 5.3 5.4 5.0 4.6 4.6 4.5 4.3  
Administration 3.4 2.7 2.8 2.5 2.7 2.3 2.3 2.1 2.0 2.0 1.9 1.9  
Occupancy/general 5.5 4.4 4.5 4.0 4.4 3.7 3.7 3.5 3.2 3.2 3.1 3.0  
  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 78.7 78.1 94.0 101.3 110.7 115.4 35.0 35.8 32.8 26.1 37.1 24.4  
Net income before taxes (% sales) -20.0 -5.7 -3.4 -1.0 -6.5 0.6 2.9 3.6 9.2 10.9 8.2 18.9  
Gross margin (% sales) 52.3 53.1 56.4 53.5 54.5 51.6 54.1 52.0 53.3 54.1 52.3 52.0  
Current asset ratio (Right axis) 1.0 1.1 1.1 1.0 1.0 1.2 1.8 1.8 1.7 1.9 2.1 2.3  
  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 -88 -1 -25 -60 -25 99 273 -11 262 245 -115 100  
Closing net cash balance (deficit) -198 -199 -224 -283 -308 -209 64 53 314 559 445 544  
  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 266.3 284.2 291.4 305.0 301.4 321.6 327.5 336.6 348.7 359.2 363.4 367.6  
Receivables 388.4 403.0 390.5 442.0 425.0 480.9 488.7 520.2 561.0 575.7 586.7 608.0  
Payables 294.3 342.3 310.7 345.1 321.1 372.9 365.3 387.4 407.2 410.7 416.7 426.6  
  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 -88.1 -0.7 -25.1 -59.6 -24.7 99.1 273.0 -11.1 261.5 245.1 -114.8 99.6  
Net income before taxes -52.9 -18.8 -11.1 -3.6 -21.3 2.5 11.1 15.0 41.8 50.3 38.2 91.7  
  12 months commencing in Jan 2004    
  $ 000