Year 1
 
    Year 2 >>>
 
    Year 3 >>>
 
    Years 1-3 >>>
 
    <<< Year 1
 
    Year 2
 
    Year 3 >>>
 
    Years 1-3 >>>
 
    <<< Year 1
 
    <<< Year 2
 
    Year 3
 
    Years 1-3 >>>
 
    <<< Year 1
 
     
36 Months           2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2005 2006 2007  
to end Dec 2007           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Year Year Year  
MONTHLY ASSUMPTIONS No. 6 - FUNDING, INTEREST RATES & RELATED ITEMS
Help with Entering Assumptions
   
Interest    
Interest rates (% pa):                                                                         Avg/Tot Avg/Tot 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 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 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 ->> 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0  
 -Longterm debt/notes ->> 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0  
Int payable on 'other loans' ($000) ->>        
                                                                             
Debt & Loans     Enter all increases and repayments as positive values                                                         Total Total Total  
Increases in longterm debt/notes ($000) ->>     50.0   250.0 250.0   550.0    
Longterm debt/note repayments ($000) ->> 25.0   25.0   25.0   25.0   50.0   50.0   100.0 50.0 50.0  
                                                                          Total Total Total  
Increases in 'other loans' ($000) ->>   125.0   125.0    
'Other loan' repayments ($000) ->>   25.0   20.0   20.0   25.0 20.0 20.0  
                                                                             
Leases    
Leases from prior years ($000):     Set cells below to zero if no finance leases outstanding                                                         Total Total Total  
 -Interest expense ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 60.0 60.0 60.0  
 -Repayments ->> 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 120.0 120.0 120.0  
                                                                             
Allocation of Debt Opening Opening values entered via opening balance sheet    
Total longterm debt/notes ($000) 200.0 175.0 175.0 225.0 200.0 200.0 200.0 175.0 175.0 425.0 650.0 650.0 650.0 650.0 600.0 600.0 600.0 600.0 600.0 600.0 600.0 600.0 600.0 600.0 600.0 600.0 550.0 550.0 550.0 550.0 550.0 550.0 550.0 550.0 550.0 550.0 550.0    
Total 'other loans' ($000) 50.0 50.0 50.0 50.0 50.0 50.0 175.0 175.0 175.0 175.0 150.0 150.0 150.0 150.0 130.0 130.0 130.0 130.0 130.0 130.0 130.0 130.0 130.0 130.0 130.0 130.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0 110.0    
Total leases ($000) 90.0 72.0 62.0 52.0 250.0 224.0 214.0 202.0 176.0 166.0 154.0 128.0 118.0 208.0 288.0 278.0 268.0 258.0 229.0 219.0 209.0 199.0 170.0 160.0 150.0 140.0 111.0 101.0 391.0 381.0 352.0 342.0 332.0 322.0 293.0 283.0 273.0    
Proportions payable within one year: Opening     On first use, set cells below to zero and revise later                                                            
 -Longterm debt/notes (as % total) ->> 50.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0 25.0      
 -'Other loans' (as % total) ->> 50.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0      
 -Leases (as % total) ->> 100.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0      
                                                                             
Various Items                                                                         Total Total Total  
Miscellaneous income ($000) ->> 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 120.0 120.0 120.0  
                                                                          Total Total Total  
Operating lease payments ($000)  ->> 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 5.5 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 9.0 66.0 108.0 108.0  
                                                                          Total Total Total  
Intangible asset amortization ($000) ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0   60.0 10.0    
Purchases of intangible assets  ($000) ->>        
      On first use, set cells below to zero and revise later                                                         Total Total Total  
Changes (+/-) in accrued expenses ($000) ->>   (20.0)   (20.0)    
Changes (+/-) in prepaid expenses ($000) ->> (10.0)   (10.0)    
  On first use, set cells below to zero. Revise later if you wish to fine tune the receivable or payable levels automatically calculated using the credit assumptions in the second table at worksheet M_B                                 Total Total Total  
Adjustments (+/-) to receivable levels ($000) ->>        
Adjustments (+/-) to payable levels ($000) ->>        
  The above adjustments will automatically modify relevant cash flows in worksheet M_CF and balances in M_BS                                                      
Approx % 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 40.0 40.0 40.0 40.0 40.0 40.0 40.0 40.0 40.0 40.0 40.0 40.0 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                                                                         Total Total Total  
Proceeds of new stock issues ($000) ->>   1,000.0     2,000.0                             1,000.0               1,000.0 2,000.0 1,000.0  
No. of new shares issued (000s) ->>   300.0   400.0   150.0   300.0 400.0 150.0  
No. of shares issued & fully-paid                                                                            
    at opening balance sheet date (000s) ->> 500.0 <<-    
     
Tax & Dividends Years: 2005 2006 2007    
Effective federal/state tax rate for each year (%)  ->> 7.0 7.0 8.0 <<- Enter tax payments relating to periods prior to start date of projections in sheet M_B Total Total Total  
Federal/state tax payments ($000)  ->>                                                                              
     X = 0 to 4                                                                         Total Total Total  
Dividends for each year ($000) 1 <<->>     300.0   300.0  
    * Set row to zeros for Ltd Co ->>        
    * Set row to zeros for Ltd Co ->>        
                                                                                           
Supplementary Data & Calculations: