12 Months           2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004
to end Dec           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Year
ASSUMPTIONS No. 5 - 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
                           
Interest Payment Months     For each row below, enter "1" to signify a payment month, otherwise leave blank                    
Cash at bank ->> 1 1 1 1 1 1 1 1 1 1 1 1  
Short-term loans/Line of credit ->> 1 1 1 1 1 1 1 1 1 1 1 1  
Longterm debt/notes ->> 1 1 1 1 1 1 1 1 1 1 1 1  
                           
Debt & Loans     Enter increases and repayments as positive values         Total
Increases in longterm debt/notes ($000) ->>     10.0   10.0
Longterm debt/notes repayments ($000) ->> 5.0   5.0   5.0   5.0   20.0
                           
Allocation of Debt Opening Opening values must be 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  
                           
Miscellaneous Items                         Total
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
Revenue grant/subsidy receipts ($000) ->>      
                          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                          
Proceeds of new stock issues ($000) ->>   5.0   5.0
                           
Tax & Dividends  
Effective federal/state tax rate for year (%)  ->> 7.0 7.0  
Federal/state tax payments ($000)  ->>                          
     X = 0 to 4                          
Dividends for current year ($000) 4 <<->>      
    * Set row to zeros for Ltd Co ->>    
    * Set row to zeros for Ltd Co ->>    
                                     
Supplementary Data & Calculations: