TEXTUAL SUMMARY REPORT
Cashflow & Financials
 
   
  Date prepared: 05-Jan-04  
   
  The following assumption and financial reports for ANY CORP INC  
  cover the year commencing in Jan 2004. They have been derived from  
  the detailed assumptions in Cashflow Plan's monthly reports.  
                 
   
  ASSUMPTIONS  - ANY CORP INC  
   
  This report covers the twelve months to end Dec 2004 and has been  
  based on detailed monthly projections and assumptions.  
   
  The following table and chart summarize sales projections for the year:  
   
                                      Quarter Ends in Year to Dec 2004   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 285.0 320.0 345.0 380.0 1,330.0  
  Total sales 590.0 650.0 715.0 810.0 2,765.0  
  % Quarterly changes NA 10.2 10.0 13.3    
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Projected inventory levels for the four quarters are as follows:  
   
    Opening              Quarter Ends in Year to Dec 2004  
  Inventories Levels  1st 2nd 3rd 4th  
    $000 $000 $000 $000 $000  
       
  Materials/goods 145.0 145.0 145.0 145.0 145.0  
   
  The projected average materials/goods cost percentages are as follows:  
   
                     Quarterly Averages for Year to Dec 2004 Annual  
  Product Groups  1st 2nd 3rd 4th Averages  
    % Sales % Sales % Sales % Sales % Sales  
       
  Group1 15.0 15.0 15.0 15.0 15.0  
  Group2 30.0 30.0 30.0 30.0 30.0  
   
  The projected headcounts at quarter ends are as follows:  
   
                   Quarter Ends in Year to Dec 2004  
  Functions    1st 2nd 3rd 4th  
    Nos Nos Nos Nos  
       
  Direct labor 12 15 18 23  
  Indirect labor 10 10 10 10  
  Sales 5 5 5 5  
  Clerical 10 10 10 10  
  Management 10 10 10 10  
  Total headcount   47 50 53 58  
   
  Direct costs and overhead expenses are summarized below.  
   
        Quarters in Year to Dec 2004 Annual  
  Cost  Analysis    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Materials/packaging/goods 131.3 145.5 159.0 178.5 614.3  
  Direct labor 36.3 46.2 56.1 70.4 209.0  
  Other direct 37.5 47.5 52.5 66.0 203.5  
  Total cost of sales 205.1 239.2 267.6 314.9 1,026.8  
  Overhead expenses:    
  Operational (indirect) 72.0 72.0 72.0 72.0 288.0  
  Selling & freight 97.3 98.5 99.8 101.7 397.3  
  Management/admin staff 150.0 150.0 150.0 150.0 600.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 389.8 391.0 392.3 394.2 1,567.3  
  Total direct costs & expenses 594.9 630.2 659.9 709.1 2,594.1  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Proposed capital expenditure (excluding finance leasing) is summarized in the next table.  
   
        Quarters in Year to Dec 2004 Annual  
  Capital Expenditure    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Total capital expenditure     150.0   150.0  
   
  Changes in longterm debt and leasing are summarized below.  
   
        Quarters in Year to Dec 2004 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 leases 75.0 75.0  
  Lease repayments 30.0 38.0 38.0 8.0 114.0  
  Net changes in leases (30.0) 37.0 (38.0) (8.0) (39.0)  
       
  Overall changes in loans & leases (5.0) 12.0 187.0 217.0 411.0  
   
  Other significant transactions during the year include the following:  
   
        Quarters in Year to Dec 2004 Annual  
  Other Transactions    1st 2nd 3rd 4th Total  
    $000 $000 $000 $000 $000  
       
  Revenue grants/subsidies    
       
  Proceeds of new stock issues 25.0 100.0 125.0  
       
  Proceeds of fixed asset sales 35.0 35.0  
       
  Dividends for current year            
   
  The following key assumptions regarding rates etc. were used  
  in compiling the projections for the year to end Dec 2004.  
   
  Items   Value Basis  
  Depreciation 10.0   Annual % rates  
  Interest rates (% pa):    
      Cash at bank 4.0   Monthly average  
      Short-term loans/line of credit 13.5   Monthly average  
      Longterm debt/notes 12.5   Monthly average  
  Working capital:    
      Accounts receivable (days sales) 39   Based on full-yr sales  
      Inventory (days sales) 19   Based on full-yr sales  
      Accounts payable (days costs/exs) 26   Based on full-yr costs  
   
  The projected monthly levels of inventory, receivables and payables  
  are indicated below:  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  CASHFLOW & FINANCIALS - ANY CORP INC
Top
 
   
  CASHFLOW PROJECTIONS  
   
  Based on detailed monthly projections, the net cash inflow for the  
  year will be $339 000. The projected year-end bank position will  
  be a $229 000 cash balance.  
   
  The following table analyses cashflows for the year:  
   
  Year to end Dec 2004       $000  
       
  CASH RECEIPTS    
  Cash sales & accounts receivable 2,863.5  
  Proceeds of new stock issues 125.0  
  Increases in longterm debt/notes 550.0  
  Proceeds from sale of fixed assets 35.0  
  VAT recovered from State    
  Capital grants/subsidies received    
  Revenue grants/subsidies received    
  Miscellaneous income received 120.0  
  Interest received 2.9  
  Total cash receipts 3,696.4  
       
  CASH PAYMENTS    
  Materials/goods accounts payable 852.3  
  Total direct cost payments 356.4  
  Total overhead expense payments 1,459.7  
  Taxes paid    
  Dividends paid    
  Finance lease debt repayments 114.0  
  Finance lease interest paid 60.0  
  Capital expenditure payments 195.0  
  Operating lease  payments 66.0  
  Longterm debt/note repayments 100.0  
  VAT paid on overheads, capex etc.    
  VAT paid to State 59.5  
  Opening payroll taxes/benefits paid 25.0  
  Changes in prepaid expenses (10.0)  
  Changes in accrued expenses 20.0  
  Interest paid 59.2  
  Total cash payments 3,357.1  
       
  Net cashflow 339.4  
       
  Closing net cash balance (deficit)     229.4  
   
  The following chart highlights the monthly net cashflows and cash balances for the year:  
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  The next chart highlights the net cashflows and cash balances for the initial three months:  
   
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  The following table summarizes the net cashflows and balances over the full year and  
  for the initial three months:  
   
  Cashflow Summary   Full Year   Initial 3 Months  
    $000 $000  
       
  Peak cash surplus 301.3 0.0   
  Peak cash deficit (258.0) (286.9)  
       
  Net cashflow 339.4 (52.7)  
  Closing cash surplus (deficit) 229.4   (162.7)  
   
   
  INCOME STATEMENTS  
   
  The following chart summarizes sales and income projections for the year:  
 
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  Based on projected sales of $2765 000, ANY CORP INC  
  expects to report a LOSS of $20 000 for the year.  
  The following table analyses these projections:  
   
  Year to end Dec 2004   $000 % Sales  
  Sales 2,765.0 100  
  Cost of sales 1,026.8 37  
  Gross Margin 1,738.3 63  
  Overhead expenses 1,567.3 57  
  Depreciation 93.8 3  
  Operating lease payments 66.0 2  
  Total operating expenses 1,727.1 62  
  Income from operations 11.2 0  
  Other income/expenses:    
   -Profit (loss) disposal of fixed assets 25.0 1  
   -Intangible asset amortization 60.0 2  
   -Capital grant/subsidy amortization    
   -Revenue grants/subsidies    
   -Miscellaneous income 120.0 4  
  Total other income (expenses) 85.0 3  
  Earnings before interest & taxes 96.2 3  
  Interest expense/income:    
   -Interest expense 59.2 2  
   -Lease interest expense 60.0 2  
   -Interest income 2.9 0  
  Net interest expense (income) 116.3 4  
  Net income before taxes (20.1) (1)  
   
   
  BALANCE SHEETS  
   
  The next table shows the opening & projected balance sheets for the year.  
   
  Year to end Dec 2004     Opening Closing  
  ASSETS $000 $000  
  Current assets:    
    Cash 10.0 229.4  
    Other 505.0 563.4  
  Total Current Assets 515.0 792.8  
       
  Fixed & intang assets 745.0 806.3  
       
  Total assets 1,260.0 1,599.0  
       
  LIABILITIES    
  Current liabilities:    
    Short-term loans/credit 120.0    
    Other 520.0 451.0  
  Total Current Liabilities 640.0 451.0  
       
  Total longterm liabilities 100.0 523.2  
       
  Total provisions for liabilities    
       
  Total owners' equity 520.0 624.9  
       
  Total liabilities     1,260.0 1,599.0  
   
   
  PERFORMANCE RATIOS  
   
  The following key ratios have been derived from the 12-month  
  projections for the year ending Dec 2004:  
   
      Max/Min   Full Year  
  Ratios   Monthly   or Year End  
       
  Profitability:    
    Gross margin (% sales) 66.2 Max Value 62.9  
    Net income before taxes (% sales) 17.7 Max Value -0.7  
       
  Current asset ratio (times) 0.8 Min Value 1.8  
       
  Debt/equity (%)   101 Max Value 67  
   
  This table indicates that the following financial indicators  
  derived from the detailed projections, may be out-of-line with  
  generally-accepted norms:  
      * Current asset ratio may be too low  
      * Debt/equity ratio may be too high