TEXTUAL SUMMARY REPORT
First-Year Financial Report
Five-Year Financial Report
 
   
  Date prepared: 31-Dec-03  
  The following three operational & financial reports for ANY INC cover  
  the months and years commencing in Jan 2005. They have been derived  
  from the detailed assumptions in Exl-Plan's Monthly and Quarterly Reports.      
  1.  FIRST-YEAR OPERATIONAL  REPORT - ANY INC  
   
  This First-Year Operational Report covers the initial twelve months to end Dec 2005  
  based on detailed monthly projections and assumptions.  
   
  The following table summarizes quarterly sales projections for the year:  
   
                                      Quarters in Year to Dec 2005   Annual  
  Sales 1 Qtr 2 Qtr 3 Qtr 4 Qtr Total  
    $000 $000 $000 $000 $000  
  Product Group:    
   - Group1 305.0 330.0 370.0 430.0 1,435.0  
   - Group2 160.9 231.3 308.3 342.8 1,043.3  
   - Group3 79.3 114.0 151.9 177.2 522.4  
   - Group4 30.0 30.0 30.0 30.0 120.0  
   - Group5 60.0 60.0 60.0 60.0 240.0  
   - Group6 164.4 166.2 168.0 168.0 666.7  
   - Group7    
   - Group8    
   - Group9    
   - Group10    
  Total sales 799.6 931.5 1,088.2 1,208.0 4,027.4  
  % Quarterly changes NA 16.5 16.8 11.0    
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Projected inventory levels for the four quarters are as follows:  
   
    Opening              Quarters in Year to Dec 2005  
  Inventories Levels  1st 2nd 3rd 4th  
    $000 $000 $000 $000 $000  
  Finished goods 401.3 158.2 185.8 214.2 233.8  
  Materials/goods 202.0 204.5 204.5 204.5 204.5  
  Total inventory 603.3 362.7 390.3 418.7 438.3  
   
  The projected average materials/goods cost percentages for the four quarters are:  
   
                     Quarterly Averages for Year to Dec 2005 Annual  
  Product Groups  1st 2nd 3rd 4th Averages  
    % Sales % Sales % Sales % Sales % Sales  
  Group1 30.2 39.4 36.9 36.8 36.0  
  Group2 39.4 40.0 41.0 38.4 39.7  
  Group3 41.6 42.1 43.1 42.1 42.3  
  Group4 40.0 40.0 40.0 40.0 40.0  
  Group5 40.0 40.0 40.0 40.0 40.0  
  Group6 37.3 34.7 35.0 35.3 35.6  
  Group7    
  Group8    
  Group9    
  Group10            
   
  The projected headcounts at quarter ends are as follows:  
   
                   Quarters in Year to Dec 2005  
  Functions    1st 2nd 3rd 4th  
    Nos Nos Nos Nos  
  Direct labor:    
   - Group1 12 15 18 21  
   - Group2 11 13 14 16  
   - Group3 5 10 10 10  
   - Group4 1 1 1 1  
   - Group5 2 3 4 4  
   - Group6 8 8 8 8  
   - Group7    
   - Group8    
   - Group9    
   - Group10    
  Total direct labor 39 49 54 59  
  Indirect labor 10 10 10 10  
  Supervisory staff 5 5 5 5  
  Sales 5 5 5 5  
  Clerical 10 10 10 10  
  Management 10 10 10 10  
  Research & development 5 5 5 5  
  Total headcount   84 94 99 104  
   
  Direct costs and overhead expenses are summarized below.  
   
        Quarters in Year to Dec 2005 Annual  
  Cost  Analysis    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Materials/packaging/goods 416.3 347.7 406.1 448.3 1,618.4  
  Direct labor 189.3 139.6 161.6 186.3 676.8  
  Other direct 128.7 97.9 108.0 124.2 458.8  
  Total Cost of sales 734.3 585.1 675.7 758.9 2,754.0  
  Operational (indirect) 96.0 96.0 96.0 96.0 384.0  
  Selling & freight 133.5 137.4 142.1 145.7 558.8  
  Management/admin staff 150.0 150.0 150.0 150.0 600.0  
  Research & development 63.0 63.0 63.0 63.0 252.0  
  Administration 27.0 27.0 27.0 27.0 108.0  
  Occupancy/general 43.5 43.5 43.5 43.5 174.0  
  Total overhead expenses 513.0 516.9 521.6 525.2 2,076.8  
  Total direct costs & expenses 1,247.3 1,102.1 1,197.3 1,284.2 4,830.9  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Proposed capital expenditure (excluding leasing) is summarized in the next table.  
   
        Quarters in Year to Dec 2005 Annual  
  Capital Expenditure    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Land, buildings & improvements 150.0 150.0  
  Plant & machinery 150.0 150.0  
  Computers & equipment 100.0 100.0  
  Automobiles, vehicles etc. 50.0 50.0  
  Total capital expenditure     400.0 50.0 450.0  
   
  Changes in longterm debt and leasing are summarized below  
   
        Quarters in Year to Dec 2005 Annual  
  Debt & Leasing    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Increase in longterm debt/notes 50.0 250.0 250.0 550.0  
  Longterm debt/note repayments 25.0 25.0 25.0 25.0 100.0  
  Net changes in longterm debt/notes 25.0 (25.0) 225.0 225.0 450.0  
       
  Increases in 'other loans' 125.0 125.0  
  'Other loan' repayments 25.0 25.0  
  Net changes in 'other loans' 125.0 (25.0) 100.0  
       
  Increases in leases 210.0 210.0  
  Lease repayments 38.0 48.0 48.0 48.0 182.0  
  Net changes in leases (38.0) 162.0 (48.0) (48.0) 28.0  
       
  Overall changes in loans & leases (13.0) 262.0 177.0 152.0 578.0  
   
  Other significant transactions during the year include the following:  
   
        Quarters in Year to Dec 2005 Annual  
  Other Transactions    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Proceeds of share issues 1,000.0 1,000.0  
       
  Proceeds of fixed asset sales 25.0 100.0 125.0  
       
  Purchases of intangible assets    
       
  Dividends declared              
   
  2.  FIRST-YEAR FINANCIAL  REPORT - ANY INC
Top
 
   
  This First-Year Financial Report covers the twelve months to end Dec 2005  
  based on detailed monthly projections and assumptions.  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  The following table analyses sales and gross margins by  
  main product group for the full year:  
   
    Total Gross Gross  
  Year to end Dec 2005 Sales Margin Margin  
    $000 $000 % Sales  
  Product Group:    
   - Group1 1,435.0 577.5 40.2  
   - Group2 1,043.3 273.3 26.2  
   - Group3 522.4 78.4 15.0  
   - Group4 120.0 50.0 41.7  
   - Group5 240.0 75.9 31.6  
   - Group6 666.7 218.2 32.7  
   - Group7    
   - Group8