| 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 | |||||||||||||||||||
| Opening values entered via opening balance sheet | |||||||||||||||||||
| Opening | Values below will be inserted into the monthly balance sheets | ||||||||||||||||||
| Cost or valuation ($000) | 75.0 | 75.0 | 75.0 | 69.0 | 69.0 | 69.0 | 69.0 | 69.0 | 69.0 | 99.0 | 99.0 | 99.0 | 99.0 | ||||||
| Accumulated depreciation ($000) | 25.0 | 25.2 | 25.4 | 23.6 | 23.7 | 23.9 | 24.1 | 24.3 | 24.4 | 24.6 | 24.8 | 25.1 | 25.3 | ||||||
| Depreciation rate (% pa) | ->> | 3.0 | <<- | ||||||||||||||||
| Depreciation for period ($000) | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 2.3 | ||||||
| After entering capital expenditure, press F9 to update cost of the fixed assets above | Total | ||||||||||||||||||
| Capital expenditure ($000) | ->> | 30.0 | 30.0 | ||||||||||||||||
| Disposal of fixed assets ($000): | Set cells below to zero if no fixed asset sales | Total | |||||||||||||||||
| -Proceeds | ->> | 6.0 | 6.0 | ||||||||||||||||
| -Cost | ->> | 6.0 | 6.0 | ||||||||||||||||
| -Accumulated depreciation | ->> | 2.0 | 2.0 | ||||||||||||||||
| Supplementary Data & Calculations: | |||||||||||||||||||