12 Months           2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2006 05-06
to end Jan           Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Jan Year
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 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 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 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   5.0   5.0   20.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 25.0 25.0 25.0 20.0 20.0 20.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 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 1.0 1.0 1.0 1.0 1.0 1.0 12.0
                          Total
Operating lease payments ($000)  ->> 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 13.2
                          Total
Intangible asset amortization ($000) ->> 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 12.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 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
No. of new shares issued (000s) ->>   3.0   3.0
No of shares issued & fully-paid                          
    at opening balance sheet date (000s) ->> 100.0 <<-  
   
Taxes & Dividends  
Effective federal/state tax rate for year (%)  ->> 7.0 <<-  
                           
Dividends for current year ($000) ->>      
    * Set row to zeros for Ltd Co ->>    
    * Set row to zeros for Ltd Co ->>    
                                     
Supplementary Data & Calculations: