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  
  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 for the four quarters 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  
  Based on Cost of Materials (Assumption Report No. 2) as % Sales (Report No. 1)  
   
  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  
  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 49.8  
  Total 4,680.7 1,992.8 42.6  
   
  The projected overall gross margin is 43%.  
   
  Based on projected sales of $4681 000, ANY CORP INC  
  expects to report a LOSS of $317 000 for the year.  
  The following table analyses these projections:  
   
  Year to end Jan 2006   $000 % Sales  
  Sales 4,680.7 100  
  Cost of sales 2,687.9 57  
  Gross Margin 1,992.8 43  
  Overhead expenses:    
   -Operational (indirect) 384.0 8  
   -Selling & freight 588.1 13  
   -Management/admin staff 600.0 13  
   -Research & development 252.0 5  
   -Administration 108.0 2  
   -Occupancy/general 174.0 4  
  Bad debts 23.4 1