| 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.7 |
17.7 |
88.5 |
53.1 |
33.5 |
33.5 |
167.3 |
100.4
|
35.7 |
35.7 |
178.4 |
107.0 |
|
| 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 |
|
|
|
|
Error |
17.7
|
17.7
|
98.5
|
53.1
|
33.5
|
33.5
|
202.3
|
100.4 |
35.7
|
35.7
|
188.4
|
207.0
|
|
| |
|
|
|
|
|
| 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 |
|
|
|
16.8 |
|
|
|
20.9 |
|
|
| 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
|
101.2
|
76.7
|
129.8
|
127.7
|
111.0
|
105.4
|
|
| |
|
|
|
|
|
| Net cashflow |
|
|
(62.0) |
(41.0) |
6.3 |
(10.8) |
(98.4) |
(69.9) |
101.1 |
23.7 |
(94.1) |
(92.0) |
77.4 |
101.6
|
|
| |
|
|
|
|
|
| Opening net cash balance
(deficit) |
|
|
(110.0) |
(172.0) |
(213.0) |
(206.7) |
(217.5) |
(315.8) |
(385.8) |
(284.6) |
(260.9) |
(355.0) |
(447.0) |
(369.6) |
|
| Closing net cash balances
(deficit) |
|
|
(172.0) |
(213.0) |
(206.7) |
(217.5) |
(315.8) |
(385.8) |
(284.6) |
(260.9) |
(355.0) |
(447.0) |
(369.6) |
(268.0) |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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.0) |
(41.0) |
6.3 |
(10.8) |
(98.4) |
(69.9) |
101.1 |
23.7 |
(94.1) |
(92.0) |
77.4 |
101.6 |
|
| Closing net cash balance |
(172.0) |
(213.0) |
(206.7) |
(217.5) |
(315.8) |
(385.8) |
(284.6) |
(260.9) |
(355.0) |
(447.0) |
(369.6) |
(268.0) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
