6 Months           2005 2005 2005 2005 2005 2005 2005
to end Jul           Feb Mar  Apr May Jun Jul 6-Mths
MONTHLY ASSUMPTIONS No. 6 - FUNDING, INTEREST RATES & RELATED ITEMS  
  Help with Entering Assumptions
 
Interest  
Interest rates (% pa):             Avg/Tot
 -Cash at bank ->> 4.0 4.0 4.0 4.0 4.0 4.0 4.0
 -Short-term loans/Line of credit ->> 13.5 13.5 13.5 13.5 13.5 13.5 13.5
 -Longterm debt/notes ->> 12.5 12.5 12.5 12.5 12.5 12.5 12.5
              Total
Debt Enter all increases and repayments as positive values    
Increases in longterm debt/notes ($000) ->>     10.0   10.0
Longterm debt/note repayments ($000) ->> 5.0   5.0   10.0
  Opening Opening values entered via opening balance sheet    
Total longterm debt/notes ($000) 30.0 25.0 25.0 35.0 30.0 30.0 30.0  
Proportions payable within one year: Opening On first use, set cells below to zero and revise later    
 -Longterm debt/notes (as % total) ->> 66.7 25.0 25.0 25.0 25.0 25.0 25.0  
              Total
Various Items              
Miscellaneous income ($000) ->> 1.0 1.0 1.0 1.0 1.0 1.0 6.0
              Total
Operating lease payments ($000)  ->> 1.1 1.1 1.1 1.1 1.1 1.1 6.6
              Total
Intangible asset amortization ($000) ->> 1.0 1.0 1.0 1.0 1.0 1.0 6.0
  On first use, set cells below to zero and revise later   Total
Changes (+/-) in accrued expenses ($000) ->>   (4.0)   (4.0)
Changes (+/-) in prepaid expenses ($000) ->> (2.0)   (2.0)
               
Approximate % of total payroll costs relating to  On first use, set cells below in range 20-40% and revise later    
  taxes & benefits for all staff (%)  ->> 40.0 40.0 40.0 40.0 40.0 40.0  
               
Stocks, Shares & Investment              
Proceeds of new stock issues ($000) ->>   5.0   5.0
               
Taxes & Dividends  
Effective federal/state tax rate (%)  ->> 10.0 <<-  
               
Dividends ($000) ->>   5.0   5.0
    * Set row to zeros for Ltd Co ->>    
    * Set row to zeros for Ltd Co ->>    
                         
Supplementary Data & Calculations: