| Short-Term Cashflow
Projections & Chart |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Covering First Three Months |
% Profile of Monthly Cashflows |
Jan |
Feb |
Mar |
|
| in
Year to Dec 2005 |
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) |
|
25.0 |
75.0 |
100.0 |
|
|
43.9 |
131.7 |
|
|
80.8 |
242.5 |
|
|
83.2 |
249.7 |
|
| Proceeds of
new stock issues |
|
100.0 |
|
100.0 |
|
|
|
|
|
|
1,000.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 |
|
|
|
|
|
|
|
|
|
25.0 |
|
|
|
| Sales tax
recovered from State |
|
100.0 |
|
100.0 |
|
5.0 |
|
|
|
|
|
|
|
|
|
|
|
| Miscellaneous
income received |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
|
| Interest
received |
|
100.0 |
|
100.0 |
|
0.0 |
|
|
|
1.6 |
|
|
|
2.4 |
|
|
|
| Total
cash receipts |
|
|
|
|
|
2.5 |
7.5
|
46.4
|
134.2
|
2.5 |
4.1
|
1,083.3
|
245.0
|
2.5 |
29.9
|
135.7
|
252.2
|
|
| |
|
|
|
|
|
| Cash
payments |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Materials/goods
accounts payable (Note 2) |
75.0 |
25.0 |
|
100.0 |
82.2 |
27.4 |
|
|
103.3 |
34.4 |
|
|
106.1 |
35.4 |
|
|
|
| Total
direct cost payments (Note 3) |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
5.9 |
5.9 |
5.9 |
5.9 |
13.7 |
13.7 |
13.7 |
13.7 |
17.4 |
17.4 |
17.4 |
17.4 |
|
| Total
overhead expense payments (Note 4) |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
16.1 |
16.1 |
16.1 |
16.1 |
33.9 |
33.9 |
33.9 |
33.9 |
42.9 |
42.9 |
42.9 |
42.9 |
|
| Taxes paid |
|
|
100.0 |
|
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends
paid |
|
100.0 |
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lease
repayments |
|
100.0 |
100.0 |
|
|
|
18.0 |
|
|
|
10.0 |
|
|
|
10.0 |
|
| Lease
interest expense |
|
100.0 |
100.0 |
|
|
|
10.0 |
|
|
|
5.0 |
|
|
|
5.0 |
|
| Total
capital expend. payments (Note 5) |
|
|
100.0 |
|
100.0 |
|
|
|
|
|
|
|
|
|
|
45.0 |
|
|
| Operating
lease payments |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
1.4 |
|
| Longterm
debt/note repayments |
|
100.0 |
|
100.0 |
|
|
25.0 |
|
|
|
|
|
|
|
|
|
|
| Purchases of intangible assets |
|
100.0 |
|
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Other loan
repayments |
|
100.0 |
|
100.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales tax
paid on o/h expense, capex etc. inputs |
|
|
100.0 |
|
100.0 |
|
|
18.4 |
|
|
|
16.8 |
|
|
|
13.3 |
|
|
| Sales tax
paid to State |
|
100.0 |
|
100.0 |
|
|
|
|
|
|
|
|
|
|
16.8 |
|
|
| 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 |
|
2.8 |
|
|
|
3.1 |
|
|
|
1.8 |
|
|
|
| Total
cash payments |
|
|
|
|
|
103.1
|
76.1
|
64.3
|
48.9
|
157.3
|
91.5
|
70.8
|
69.0
|
167.8
|
98.8
|
136.9
|
76.7
|
|
| |
|
|
|
|
|
|
|
| Net
cashflow |
|
|
(100.6) |
(68.6) |
(17.9) |
85.3 |
(154.8) |
(87.5) |
1,012.5
|
176.0
|
(165.3) |
(68.8) |
(1.1) |
175.5
|
|
| |
|
|
|
|
|
| Opening net cash balances
(overdraft) |
|
|
(110.0) |
(210.6) |
(279.2) |
(297.1) |
(211.8) |
(366.6) |
(454.1) |
558.4 |
734.4 |
569.2 |
500.3 |
499.2 |
|
| Closing
net cash balance (deficit) |
|
|
(210.6) |
(279.2) |
(297.1) |
(211.8) |
(366.6) |
(454.1) |
558.4
|
734.4
|
569.2
|
500.3 |
499.2
|
674.7
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Notes refer
to Monthly Cashflow Projections (M_CF) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chart
Values - These items will not be printed |
|
|
|
| |
Jan |
|
Feb |
|
Mar |
|
|
| |
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 |
(100.6) |
(68.6) |
(17.9) |
85.3 |
(154.8) |
(87.5) |
1,012.5 |
176.0 |
(165.3) |
(68.8) |
(1.1) |
175.5 |
|
|
| Closing net cash balance
(deficit) |
(210.6) |
(279.2) |
(297.1) |
(211.8) |
(366.6) |
(454.1) |
558.4 |
734.4 |
569.2 |
500.3 |
499.2 |
674.7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
