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. 5 - FIXED ASSETS Help with Entering Assumptions
 
   
Land, buildings & improvements <<- Opening These values will be inserted into the monthly balance sheets  
Cost or valuation ($000) ->> 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 130.0 130.0 130.0 130.0  
Accumulated depreciation ($000) ->> 10.0 10.3 10.5 10.8 11.0 11.3 11.5 11.8 12.0 12.3 12.6 12.9 13.2  
Depreciation rate (% pa)  ->> 3.0  <<-  
Base depreciation on cost (enter 0) or  
  use double declining balance (enter 1) ->>    Enter 0 or 1 Total
Depreciation for period ($000) 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 3.2
      After entering capital expenditure, press F9 to update cost of the fixed assets above   Total
Capital expenditure ($000) ->>     30.0   30.0
                           
Disposal of land, buildings & improvements ($000):     Set cells below to zero if no fixed asset sales in this category       Total
  -Proceeds ->>    
  -Cost ->>    
  -Accumulated depreciation ->>    
Plant, equipment & vehicles <<-       Opening     These values will be inserted into the monthly balance sheets        
Cost or valuation ($000) ->> 50.0 50.0 60.0 60.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 75.0 71.0  
Accumulated depreciation ($000) ->> 15.0 15.6 16.2 16.9 17.6 18.6 19.5 20.4 21.3 22.2 23.1 24.0 22.8  
Depreciation rate (% pa)  ->> 10.0  <<-  
Base depreciation on cost (enter 0) or  
  use double declining balance (enter 1) ->> 1.0  Enter 0 or 1 Total
Depreciation for period ($000) 0.6 0.6 0.7 0.7 1.0 0.9 0.9 0.9 0.9 0.9 0.9 0.9 9.8
      After entering capital expenditure, press F9 to update cost of the fixed assets above   Total
Capital expend excl lease ($000) ->>   10.0   10.0
      Set cells below to zero if finance leasing is not being used to acquire fixed assets in this category  
New leases ($000) ->>   15.0   15.0
Interest on new leases ($000) ->>   1.0   1.0   1.0   3.0
Repayments on new leases ($000)  ->>   1.3   1.3   1.3   3.9
                           
Disposal of plant, equipment & vehicles ($000):     Set cells below to zero if no fixed asset sales in this category       Total
  -Proceeds ->>   10.0 10.0
  -Cost ->>   4.0 4.0
  -Accumulated depreciation ->>   2.0 2.0
Fixed Asset Summary         Opening                          
Cost or valuation ($000) 150.0 150.0 160.0 160.0 175.0 175.0 175.0 175.0 175.0 205.0 205.0 205.0 201.0  
Accumulated depreciation ($000) 25.0 25.8 26.7 27.6 28.6 29.8 31.0 32.2 33.3 34.5 35.7 36.9 36.1 Total
Depreciation for period ($000) 0.8 0.8 1.0 1.0 1.2 1.2 1.2 1.2 1.1 1.2 1.2 1.2 13.1
  Total
Capital expenditure ($000) 10.0 30.0 40.0
  Total
New leases ($000) 15.0 15.0
Interest on new leases ($000) 1.0 1.0 1.0 3.0
Repayments on new leases ($000) 1.3 1.3 1.3 3.9
   
Disposal of fixed assets ($000): Total
  -Proceeds 10.0 10.0
  -Cost 4.0 4.0
  -Accumulated depreciation 2.0 2.0
                                     
Supplementary Data & Calculations: