|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Short-Term Cashflow Projections & Chart |
|
|
|
|
|
|
|
|
|
|
| Covering First 12 Periods |
|
Jan |
Feb |
Mar |
|
|
| in
Year to Dec 2004 |
|
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
|
|
| |
|
|
|
|
| Table
1 - Percentage Distribution of Cashflows for Initial Three Months |
|
|
|
|
| |
|
|
|
|
|
| CASH RECEIPTS |
|
% |
% |
% |
% |
% |
% |
% |
% |
% |
% |
% |
% |
|
|
| Cash sales
& accounts receivable (Note 1) |
|
10.0 |
10.0 |
50.0 |
30.0 |
10.0 |
10.0 |
50.0 |
30.0 |
10.0 |
10.0 |
50.0 |
30.0 |
|
|
| Proceeds of new
stock issues |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
| Increases in
longterm debt/notes |
|
|
100.0 |
|
|
100.0 |
|
|
100.0 |
|
|
| Proceeds from
sale of fixed assets |
|
|
100.0 |
|
|
100.0 |
|
|
100.0 |
|
|
| VAT recovered
from State |
|
|
100.0 |
|
|
100.0 |
|
|
100.0 |
|
|
| Capital
grants/subsidies received |
|
|
100.0 |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
|
| Revenue
grants/subsidies received |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
|
| Miscellaneous
income received |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
| Interest
received |
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| CASH PAYMENTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Materials/goods
accounts payable (Note 2) |
|
50.0 |
30.0 |
10.0 |
10.0 |
50.0 |
30.0 |
10.0 |
10.0 |
50.0 |
30.0 |
10.0 |
10.0 |
|
|
| Total direct
cost payments (Note 3) |
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
|
| Total overhead
expense payments (Note 4) |
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
|
| Taxes paid |
|
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
| Dividends paid |
|
|
100.0 |
|
|
100.0 |
|
|
100.0 |
|
|
| Finance lease
debt repayments |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
| Finance lease
interest paid |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
| Capital
expenditure payments |
|
|
50.0 |
|
50.0 |
|
50.0 |
|
50.0 |
|
50.0 |
|
50.0 |
|
|
| Operating
lease payments |
|
|
50.0 |
|
50.0 |
|
50.0 |
|
50.0 |
|
50.0 |
|
50.0 |
|
|
| Longterm
debt/note repayments |
|
|
100.0 |
|
|
100.0 |
|
|
100.0 |
|
|
| VAT paid on
overheads, capex etc. |
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
|
| VAT paid to
State |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
| Opening payroll
taxes/benefits paid |
|
|
100.0 |
|
|
|
100.0 |
|
|
|
100.0 |
|
|
|
| Changes in
prepaid expenses |
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
|
| Changes in
accrued expenses |
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
|
| Interest paid |
|
|
100.0 |
|
|
100.0 |
|
|
100.0 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
| Table
2 - Distribution of Cashflows for Initial Three Months |
|
|
|
|
| |
|
|
|
|
|
| CASH
RECEIPTS |
|
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| Cash sales
& accounts receivable (Note 1) |
|
16.4 |
16.4 |
82.2 |
49.3 |
26.2 |
26.2 |
130.9
|
78.5 |
24.8 |
24.8 |
124.0
|
74.4 |
|
|
| Proceeds of
new stock issues |
|
|
|
|
|
|
|
25.0 |
|
|
|
|
|
|
|
| Increases
in longterm debt/notes |
|
|
|
|
|
|
|
|
|
|
|
|
50.0 |
|
|
| Proceeds
from sale of fixed assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| VAT
recovered from State |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Capital
grants/subsidies received |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue
grants/subsidies received |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Miscellaneous
income received |
|
|
|
10.0 |
|
|
|
10.0 |
|
|
|
10.0 |
|
|
|
| Interest
received |
|
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|
|
|
|
|
|
| Total
cash receipts |
|
16.5
|
16.5
|
92.2
|
49.3
|
26.2
|
26.2
|
165.9 |
78.5
|
24.8
|
24.8
|
134.0 |
124.4 |
|
|
| |
|
|
|
|
|
|
|
|
|
| CASH
PAYMENTS |
|
|
|
|
|
| Materials/goods
accounts payable (Note 2) |
|
52.4 |
31.4 |
10.5 |
10.5 |
55.4 |
33.2 |
11.1 |
11.1 |
43.2 |
25.9 |
8.6 |
8.6 |
|
|
| Total
direct cost payments (Note 3) |
|
1.7 |
1.7 |
1.7 |
1.7 |
2.9 |
2.9 |
2.9 |
2.9 |
6.3 |
6.3 |
6.3 |
6.3 |
|
|
| Total
overhead expense payments (Note 4) |
|
12.4 |
12.4 |
12.4 |
12.4 |
25.7 |
25.7 |
25.7 |
25.7 |
32.5 |
32.5 |
32.5 |
32.5 |
|
|
| Taxes paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends
paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Finance
lease debt repayments |
|
|
|
10.0 |
|
|
|
10.0 |
|
|
|
10.0 |
|
|
|
| Finance
lease interest paid |
|
|
|
5.0 |
|
|
|
5.0 |
|
|
|
5.0 |
|
|
|
| Capital
expenditure payments |
|
|
|
|
|
|
|
|
|
|
22.5 |
|
22.5 |
|
|
| Operating
lease payments |
|
|
2.8 |
|
2.8 |
|
2.8 |
|
2.8 |
|
2.8 |
|
2.8 |
|
|
| Longterm
debt/note repayments |
|
|
|
|
25.0 |
|
|
|
|
|
|
|
|
|
|
| VAT paid
on overheads, capex etc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| VAT paid
to State |
|
|
|
20.0 |
|
|
|
3.2 |
|
|
|
3.4 |
|
|
|
| Opening
payroll taxes/benefits paid |
|
|
|
25.0 |
|
|
|
|
|
|
|
|
|
|
|
| Changes in
prepaid expenses |
|
(2.5) |
(2.5) |
(2.5) |
(2.5) |
|
|
|
|
|
|
|
|
|
|
| Changes in
accrued expenses |
|
|
|
|
|
5.0 |
5.0 |
5.0 |
5.0 |
|
|
|
|
|
|
| Interest
paid |
|
|
|
|
3.7 |
|
|
|
3.9 |
|
|
|
3.9 |
|
|
| Total
cash payments |
|
63.9 |
45.7
|
82.0
|
53.5
|
89.0
|
69.6
|
62.8
|
51.3
|
81.9 |
89.9 |
65.8 |
76.5
|
|
|
| |
|
|
|
|
|
|
| Net cashflow |
|
(47.5) |
(29.3) |
10.2 |
(4.1) |
(62.8) |
(43.4) |
103.0
|
27.2 |
(57.1) |
(65.1) |
68.3 |
47.9
|
|
|
| |
|
|
|
|
|
| Opening net cash balance
(deficit) |
|
(110.0) |
(157.5) |
(186.7) |
(176.5) |
(180.6) |
(243.5) |
(286.9) |
(183.8) |
(156.6) |
(213.8) |
(278.9) |
(210.6) |
|
|
| Closing net cash balances
(deficit) |
|
(157.5) |
(186.7) |
(176.5) |
(180.6) |
(243.5) |
(286.9) |
(183.8) |
(156.6) |
(213.8) |
(278.9) |
(210.6) |
(162.7) |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Notes refer
to Cashflow Projections at the CASH worksheet. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
(47.5) |
(29.3) |
10.2 |
(4.1) |
(62.8) |
(43.4) |
103.0 |
27.2 |
(57.1) |
(65.1) |
68.3 |
47.9 |
|
| Closing net cash balance
(deficit) |
|
(157.5) |
(186.7) |
(176.5) |
(180.6) |
(243.5) |
(286.9) |
(183.8) |
(156.6) |
(213.8) |
(278.9) |
(210.6) |
(162.7) |
|
| Initial
3 months (12 weeks) commencing in Jan 2004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
