TEXTUAL SUMMARY REPORT
First-Year Financial Report
Three-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 this 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 61.0 66.0 74.0 86.0 287.0  
   - Group2 57.0 64.0 69.0 76.0 266.0  
  Total sales 118.0 130.0 143.0 162.0 553.0  
  % Quarterly changes NA 10.2 10.0 13.3    
   
  This shows that Group1 will account for 52% of projected sales and that Group2 will  
  account for the balance of 48%.  
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  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  
       
  Materials/goods 43.0 43.0 43.0 43.0 43.0  
   
  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 41.0 41.0 41.0 41.0 41.0  
  Group2 39.0 39.0 39.0 39.0 39.0  
  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 1 2 2 2  
   - Group2 1 2 2 2  
  Total direct labor 2 3 4 4  
  Indirect labor 2 2 2 2  
  Sales 1 1 1 1  
  Clerical 1 1 1 1  
  Management   1 1 1 1  
  Total headcount   7 8 9 9  
   
  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 47.2 52.0 57.3 64.9 221.4  
  Direct labor 5.2 6.9 9.5 10.4 32.0  
  Other direct 21.3 26.2 29.1 33.0 109.6  
  Total Cost of sales 73.7 85.1 95.9 108.3 363.1  
  Overhead expenses:    
  Operational (indirect) 8.9 8.9 8.9 8.9 35.4  
  Selling & freight 11.9 12.1 12.4 12.7 49.1  
  Management/admin staff 8.3 8.3 8.3 8.3 33.0  
  Administration 5.3 5.3 5.3 5.3 21.0  
  Occupancy/general 2.6 2.6 2.6 2.6 10.2  
  Total overhead expenses 36.8 37.0 37.3 37.6 148.7  
  Total direct costs & expenses 110.5 122.2 133.1 145.9 511.7  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  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 30.0 30.0  
  Plant, equipment & vehicles 10.0 10.0  
  Total capital expenditure 10.0   30.0   40.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 10.0 50.0 50.0 110.0  
  Longterm debt/note repayments 5.0 5.0 5.0 5.0 20.0  
  Net changes in longterm debt/notes 5.0 (5.0) 45.0 45.0 90.0  
       
  Increases in leases 15.0 15.0  
  Lease repayments 6.0 7.3 7.3 1.3 21.9  
  Net changes in leases (6.0) 7.7 (7.3) (1.3) (6.9)  
       
  Overall changes in loans & leases (1.0) 2.7 37.7 43.7 83.1  
   
  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 5.0 5.0  
       
  Proceeds of fixed asset sales 10.0 10.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 287.0 98.5 34.3  
   - Group2 266.0 91.4 34.4  
  Total 553.0 189.9 34.3  
   
  This shows that Group1 will account for 52% of projected sales  
  (52% of total gross margin) and that Group2 will account for the   
  balance of 48% of sales (48% of total gross margin).  
   
  The projected overall gross margin is 34%.  
   
  Based on projected sales of $553 000, ANY CORP INC  
  expects to report a pretax profit of $11 000 for the year.  
  The following table analyses these projections:  
   
  Year to end Jan 2006   $000 % Sales  
  Sales 553.0 100  
  Cost of sales 363.1 66  
  Gross Margin 189.9 34  
  Overhead expenses:    
   -Operational (indirect) 35.4 6  
   -Selling & freight 49.1 9  
   -Management/admin staff 33.0 6  
   -Administration 21.0 4  
   -Occupancy/general 10.2 2  
  Depreciation 13.1 2  
  Operating lease payments 13.2 2  
  Total operating expenses 174.9 32  
  Income from operations 15.0 3  
  Other income/expenses:    
   -Profit (loss) disposal of fixed assets 8.0 1  
   -Intangible asset amortization 12.0 2  
   -Miscellaneous income 24.0 4  
  Total other income (expenses) 20.0 4  
  Earnings before interest & taxes 35.0 6  
  Interest expense/income:    
   -Interest expense 12.0 2  
   -Lease interest expense 12.0 2  
   -Interest income 0.3 0  
  Net interest expense (income) 23.7 4  
  Net income before taxes 11.3 2  
   
  Based on detailed monthly projections, the net cash inflow  
  for the twelve months will be $44 000. The projected year-end bank  
  position will be a $31 000 cash balance.  
   
  The next table compares the projected results with those for   
  the previous year which ended in Jan 2005.  
  Years ending:     Jan 2005   Jan 2006  Change  
    $000 $000 %  
       
  Sales 335.0 553.0 65  
  Cost of sales 260.0 363.1 40  
  Gross margin 75.0 189.9 153  
  Total operating expenses 144.0 174.9 21  
  Income from operations (69.0) 15.0    
  Other income, interest expense etc. (7.0) (3.7)    
  Net income before taxes (76.0) 11.3    
  Taxes 0.8    
  Net income (76.0) 10.5    
  Dividends declared    
  Transferred to reserves   (76.0) 10.5    
   
  This indicates that sales could increase by $218 000 while  
  net income could improve by $87 000 over the year.  
   
  The following table summarizes cashflows for the year by quarter.  
   
        Quarters in Year to Jan 2006 Annual  
  Cashflows    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Total cash receipts 155.9 133.0 201.7 231.4 722.0  
  Total cash payments 172.2 147.3