| 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 |
|
|
|
|
| |
|
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) |
|
|
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.6 |
26.3 |
24.9 |
25.5 |
26.0
|
26.6 |
27.2
|
27.8 |
28.3
|
29.2 |
30.0
|
30.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) |
|
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.6 |
0.8 |
0.8 |
0.8 |
7.8 |
| |
X = 0 to 4 |
|
|
After entering capital
expenditure, press F9 to update cost of the fixed assets above |
|
Total |
| Capital
expenditure ($000) |
|
|
<<->> |
|
|
30.0 |
|
30.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
->> |
|
6.0 |
|
6.0 |
| -Cost |
|
->> |
|
6.0 |
|
6.0 |
| -Accumulated depreciation |
|
->> |
|
2.0 |
|
2.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|