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 285.0 320.0 345.0 380.0 1,330.0  
  Total sales 830.2 995.3 1,175.2 1,320.0 4,320.7  
  % Quarterly changes NA 19.9 18.1 12.3    
   
  This shows that Group1 will account for 33% of projected sales; that Group2 will account for   
  a further 24%; that Group3 will account  for 12%; and that Group4 will account  for 31%.  
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  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 125.0 165.6 195.4 225.3 244.8  
  Materials/goods 120.0 120.0 120.0 120.0 120.0  
  Total inventory 245.0 285.6 315.4 345.3 364.8  
   
  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 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 10 13 16 19  
  Total direct labor 38 51 58 66  
  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   83 96 103 111  
   
  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 299.5 333.8 411.5 453.9 1,498.6  
  Direct labor 108.3 140.4 170.3 202.9 621.9  
  Other direct 76.2 97.7 107.8 124.4 406.1  
  Total Cost of sales 484.0 571.9 689.6 781.1 2,526.6  
  Overhead expenses:    
  Operational (indirect) 88.5 88.5 88.5 88.5 354.0  
  Selling & freight 89.3 94.1 99.8 102.3 385.3  
  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 461.3 466.1 471.8 474.3 1,873.3  
  Total direct costs & expenses 945.3 1,037.9 1,161.3 1,255.4 4,399.9  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  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, equipment & machinery 150.0 150.0  
  Automobiles, vehicles etc. 50.0 50.0  
  Total capital expenditure     300.0 50.0 350.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 135.0 135.0  
  Lease repayments 30.0 40.0 40.0 10.0 120.0  
  Net changes in leases (30.0) 95.0 (40.0) (10.0) 15.0  
       
  Overall changes in loans & leases (5.0) 195.0 185.0 190.0 565.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 25.0 50.0 75.0  
       
  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 593.3 41.3  
   - Group2 1,042.2 369.8 35.5  
   - Group3 513.5 177.3 34.5  
   - Group4 1,330.0 653.7 49.2  
  Total 4,320.7 1,794.1 41.5  
   
  This shows that Group1 will account for 33% of projected sales  
  (33% of total gross margin); that Group2 will account for a further  
  24% of sales (21% of total gross margin); that Group3 will account   
  for 12% of sales (10% of total gross margin); that Group4 will account   
  for the balance of 31% of sales (36% of total gross margin).  
   
  The projected overall gross margin is 42%.  
   
  Based on projected sales of $4321 000, ANY CORP INC  
  expects to report a LOSS of $272 000 for the year.  
  The following table analyses these projections:  
   
  Year to end Jan 2006   $000 % Sales  
  Sales 4,320.7 100  
  Cost of sales 2,526.6 58  
  Gross Margin 1,794.1 42  
  Overhead expenses:    
   -Operational (indirect) 354.0 8  
   -Selling & freight 385.3 9  
   -Management/admin staff 600.0 14  
   -Research & development 252.0 6  
   -Administration 108.0 2  
   -Occupancy/general 174.0 4  
  Bad debts 21.6 1  
  Depreciation 87.6 2  
  Operating lease payments 66.0 2  
  Total operating expenses 2,048.5 47  
  Income from operations (254.4) (6)  
  Other income/expenses:    
   -Profit (loss) disposal of fixed assets 60.0 1  
   -Intangible asset amortization 60.0 1  
   -Miscellaneous income 120.0