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. 4 - FIXED ASSETS Help with Entering Assumptions
 
  Opening values must be entered via opening balance sheet  
  Opening Calculated values will be automatically inserted into the monthly balance sheets  
Cost or valuation ($000) 850.0 850.0 850.0 850.0 925.0 925.0 925.0 925.0 925.0 1,075.0 1,075.0 1,075.0 1,055.0  
Accumulated depreciation ($000) 175.0 182.1 189.2 196.3 203.3 211.0 218.8 226.5 234.2 241.9 250.8 259.8 258.8  
Average depreciation rate (% pa)  ->> 10.0 10.0  
Base depreciation on cost (enter 0) or  
  use double declining balance (enter 1) ->>   Total
Depreciation for period ($000) 7.1 7.1 7.1 7.1 7.7 7.7 7.7 7.7 7.7 9.0 9.0 9.0 93.8
     X = 0 to 4     After entering capital expenditure, press F9 to update cost of the fixed assets above   Total
Capital expend excl. leases ($000) 2 <<->>     150.0   150.0
      Set cells below to zero if leasing is not being used to acquire fixed assets      
New finance lease debt ($000) ->>   75.0   75.0
Interest paid on new  leases ($000) ->>   5.0   5.0   5.0   15.0
New  lease capital repayments ($000)  ->>   8.0   8.0   8.0   24.0
      If leasing used, press F9 to update the cost of the fixed assets above        
Capital grant/subsidy receipts ($000)  ->>    
Capital grant/subsidy amortization ($000)  ->>    
                           
Sale of fixed assets ($000):     Set cells below to zero if no fixed asset sales           Total
  -Proceeds ->>   35.0 35.0
  -Cost ->>   20.0 20.0
  -Accumulated depreciation ->>   10.0 10.0
                                     
Supplementary Data & Calculations: