| 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 |
|
|
|
|
| |
|
|
| 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: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|