TEXTUAL SUMMARY REPORT
First-Year Financial Report
Five-Year Financial Report
 
   
  Date prepared: 31-Dec-03  
   
  The following three operational & financial reports for ANY CORP INC cover  
  the months and years commencing in Feb 2005. They have been derived  
  from the detailed assumptions in Exl-Plan's Monthly, Quarterly and Annual  
  Reports.  
                 
   
  1.  FIRST-YEAR OPERATIONAL  REPORT - ANY CORP INC  
   
  This First-Year Operational Report covers the twelve months to end Jan 2006  
  based on detailed monthly projections and assumptions. The  
  following table summarizes quarterly sales projections for the year:  
   
                                      Quarter Ends in Year to Jan 2006   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 341.7 1,042.2  
   - Group3 79.3 114.0 151.9 168.3 513.5  
   - Group4 30.0 30.0 30.0 30.0 120.0  
   - Group5 60.0 60.0 60.0 60.0 240.0  
   - Group6 285.0 320.0 345.0 380.0 1,330.0  
   - Group7    
   - Group8    
   - Group9    
   - Group10    
  Total sales 920.2 1,085.3 1,265.2 1,410.0 4,680.7  
  % Quarterly changes NA 17.9 16.6 11.4    
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Projected inventory levels for the four quarters are as follows:  
   
    Opening              Quarter Ends in Year to Jan 2006  
  Inventories Levels  1st 2nd 3rd 4th  
    $000 $000 $000 $000 $000  
       
  Finished goods 150.0 176.6 206.4 236.4 255.9  
  Materials/goods 140.0 140.0 140.0 140.0 140.0  
  Total inventory 290.0 316.6 346.4 376.4 395.9  
   
  The projected average materials/goods cost percentages are as follows:  
   
                     Quarterly Averages for Year to Jan 2006 Annual  
  Product Groups  1st 2nd 3rd 4th Averages  
    % Sales % Sales % Sales % Sales % Sales  
       
  Group1 38.3 35.0 39.5 36.4 37.3  
  Group2 46.2 40.5 39.5 38.7 40.5  
  Group3 42.5 37.3 36.4 35.6 37.3  
  Group4 27.1 28.0 28.0 28.0 27.8  
  Group5 25.3 25.0 25.0 25.0 25.1  
  Group6 35.2 31.3 30.8 30.7 31.8  
  Group7    
  Group8    
  Group9    
  Group10            
   
  The projected headcounts at quarter ends are as follows:  
   
                   Quarter Ends in Year to Jan 2006  
  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 2 2 2 2  
   - Group5 2 2 2 2  
   - Group6 10 13 16 19  
   - Group7    
   - Group8    
   - Group9    
   - Group10    
  Total direct labor 42 55 62 70  
  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   87 100 107 115  
   
  Direct costs and overhead expenses are summarized below.  
   
        Quarters in Year to Jan 2006 Annual  
  Cost  Analysis    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Materials/packaging/goods 331.7 357.1 434.8 477.2 1,600.8  
  Direct labor 124.3 153.5 183.7 216.5 677.9  
  Other direct 78.7 98.0 108.0 124.5 409.2  
  Total Cost of sales 534.6 608.6 726.5 818.2 2,687.9  
  Overhead expenses:    
  Operational (indirect) 96.0 96.0 96.0 96.0 384.0  
  Selling & freight 140.0 144.8 150.5 153.0 588.1  
  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 519.5 524.3 530.0 532.5 2,106.1  
  Total direct costs & expenses 1,054.1 1,132.8 1,256.4 1,350.6 4,794.0  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Proposed capital expenditure (excluding leasing) is summarized in the next table.  
   
        Quarters in Year to Jan 2006 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 50.0 50.0  
  Automobiles, vehicles etc. 50.0 50.0  
  Total capital expenditure     300.0 100.0 400.0  
   
  Changes in longterm debt and leasing are summarized below.  
   
        Quarters in Year to Jan 2006 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 195.0 195.0  
  Lease repayments 30.0 42.0 42.0 12.0 126.0  
  Net changes in leases (30.0) 153.0 (42.0) (12.0) 69.0  
       
  Overall changes in loans & leases (5.0) 253.0 183.0 188.0 619.0  
   
  Other significant transactions during the year include the following:  
   
        Quarters in Year to Jan 2006 Annual  
  Other Transactions    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Proceeds of share issues 25.0 300.0 325.0  
       
  Proceeds of fixed asset sales 50.0 50.0 100.0  
       
  Purchases of intangible assets    
       
  Dividends declared              
   
   
  2.  FIRST-YEAR FINANCIAL  REPORT - ANY CORP INC
Top
 
   
  This First-Year Financial Report covers the twelve months to end Jan 2006  
  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 Jan 2006 Sales Margin Margin  
    $000 $000 % Sales  
  Product Group:    
   - Group1 1,435.0 602.9 42.0  
   - Group2 1,042.2 378.0 36.3  
   - Group3 513.5 181.8 35.4  
   - Group4 120.0 38.8 32.3  
   - Group5 240.0 129.4 53.9  
   - Group6 1,330.0 662.0