| Short-Term Cashflow
Projections & Chart |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Covering First Three Months |
% Profile of Monthly Cashflows |
Feb |
Mar |
Apr |
|
| in
Year to Jan 2006 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Total |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
|
| |
% |
% |
% |
% |
% |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
|
| Cash
receipts |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash sales
& accounts receivable (Note 1) |
10.0 |
10.0 |
50.0 |
30.0 |
100.0 |
17.6 |
17.6 |
87.9 |
52.8 |
32.8
|
32.8
|
163.9 |
98.4 |
34.8 |
34.8 |
173.8 |
104.3 |
|
| Proceeds of
new stock issues |
|
100.0 |
|
100.0 |
|
|
|
|
|
|
25.0 |
|
|
|
|
|
|
| Increases
in longterm debt/notes |
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
50.0 |
|
| Increases
in other loans |
|
|
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Proceeds
from disposals of fixed assets |
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
50.0
|
|
| Sales Tax
recovered from State |
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Miscellaneous
income received |
|
100.0 |
|
100.0 |
|
|
10.0 |
|
|
|
10.0 |
|
|
|
10.0 |
|
|
| Interest
received |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|
|
|
|
|
|
|
|
|
| Total
cash receipts |
|
|
|
|
|
17.6
|
17.6
|
97.9
|
52.8
|
32.8 |
32.8 |
198.9
|
98.4
|
34.8
|
34.8
|
183.8
|
204.3
|
|
| |
|
|
|
|
|
| Cash
payments |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Materials/goods
accounts payable (Note 2) |
50.0 |
30.0 |
10.0 |
10.0 |
100.0 |
59.3 |
35.6 |
11.9 |
11.9 |
78.0
|
46.8 |
15.6 |
15.6 |
68.3 |
41.0 |
13.7 |
13.7 |
|
| Total
direct cost payments (Note 3) |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
6.1 |
6.1 |
6.1 |
6.1 |
14.3 |
14.3 |
14.3 |
14.3 |
18.2 |
18.2 |
18.2 |
18.2 |
|
| Total
overhead expense payments (Note 4) |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
16.8 |
16.8 |
16.8 |
16.8 |
34.5 |
34.5 |
34.5 |
34.5 |
43.3 |
43.3 |
43.3 |
43.3 |
|
| Taxes paid |
|
|
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends
paid |
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lease
repayments |
|
100.0 |
|
100.0 |
|
|
10.0 |
|
|
|
10.0 |
|
|
|
10.0 |
|
|
| Lease
interest expense |
|
100.0 |
|
100.0 |
|
|
5.0 |
|
|
|
5.0 |
|
|
|
5.0 |
|
|
| Total
capital expend. payments (Note 5) |
|
50.0 |
|
50.0 |
100.0 |
|
|
|
|
|
|
|
|
|
22.5
|
|
22.5
|
|
| Operating
lease payments |
|
50.0 |
|
50.0 |
100.0 |
|
2.8
|
|
2.8
|
|
2.8 |
|
2.8 |
|
2.8
|
|
2.8
|
|
| Longterm
debt/note repayments |
|
100.0 |
100.0 |
|
|
|
25.0
|
|
|
|
|
|
|
|
|
|
| Other loan
repayments |
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Purchases
of intangible assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales Tax
paid on o/h expense, capex etc. inputs |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales Tax
paid to State |
|
100.0 |
|
100.0 |
|
|
20.0 |
|
|
|
8.6 |
|
|
|
10.5 |
|
|
| Opening
payroll taxes/benefits paid |
|
100.0 |
|
100.0 |
|
|
25.0 |
|
|
|
|
|
|
|
|
|
|
| Changes in
prepaid expenses |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
(2.5) |
(2.5) |
(2.5) |
(2.5) |
|
|
|
|
|
|
|
|
|
| Changes in
accrued expenses |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
|
|
|
|
5.0 |
5.0 |
5.0 |
5.0 |
|
|
|
|
|
| Interest
paid |
|
100.0 |
100.0 |
|
|
|
3.9 |
|
|
|
4.5 |
|
|
|
5.0 |
|
| Total
cash payments |
|
|
|
|
|
79.7
|
58.7
|
92.2
|
63.9
|
131.8
|
103.4
|
93.1
|
76.7
|
129.8
|
127.7
|
100.6
|
105.4
|
|
| |
|
|
|
|
|
| Net cashflow |
|
|
(62.1) |
(41.1) |
5.7 |
(11.1) |
(99.1) |
(70.6) |
105.9
|
21.7 |
(95.0) |
(92.9) |
83.2 |
98.9
|
|
| |
|
|
|
|
|
| Opening net cash balance
(deficit) |
|
|
(110.0) |
(172.1) |
(213.2) |
(207.6) |
(218.7) |
(317.8) |
(388.4) |
(282.5) |
(260.8) |
(355.8) |
(448.8) |
(365.6) |
|
| Closing net cash balances
(deficit) |
|
|
(172.1) |
(213.2) |
(207.6) |
(218.7) |
(317.8) |
(388.4) |
(282.5) |
(260.8) |
(355.8) |
(448.8) |
(365.6) |
(266.7) |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Notes refer
to Monthly Cashflow Projections (M_CF) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chart
Values - These items will not be printed |
|
| |
Feb |
|
Mar |
|
Apr |
|
| |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
|
| Net cashflow |
(62.1) |
(41.1) |
5.7 |
(11.1) |
(99.1) |
(70.6) |
105.9 |
21.7 |
(95.0) |
(92.9) |
83.2 |
98.9 |
|
| Closing net cash balance |
(172.1) |
(213.2) |
(207.6) |
(218.7) |
(317.8) |
(388.4) |
(282.5) |
(260.8) |
(355.8) |
(448.8) |
(365.6) |
(266.7) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
