|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
Increases in
other loans |
|
|
|
|
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 |
|
|
'Other loan'
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) |
|
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 |
|
|
|
|
|
|
|
25.0 |
|
|
|
|
|
|
|
Increases
in longterm debt/notes |
|
|
|
|
|
|
|
|
|
|
|
|
50.0 |
|
|
Increases
in other loans |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Proceeds
from sale of fixed assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
VAT
recovered from State |
|
|
|
|
|
|
|
|
0.8 |
|
|
|
5.7 |
|
|
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 |
|
17.7
|
17.7
|
98.5
|
53.1
|
33.5
|
33.5
|
202.3
|
101.2
|
35.7
|
35.7
|
188.4
|
162.7
|
|
|
|
|
|
|
|
|
|
|
|
|
CASH
PAYMENTS |
|
|
|
|
|
Materials/goods
accounts payable (Note 2) |
|
58.0 |
34.8 |
11.6
|
11.6
|
79.8 |
47.9 |
16.0 |
16.0 |
80.8 |
48.5 |
16.2 |
16.2 |
|
|
Total
direct cost payments (Note 3) |
|
1.7 |
1.7 |
1.7 |
1.7 |
6.7 |
6.7 |
6.7 |
6.7 |
10.1 |
10.1 |
10.1 |
10.1 |
|
|
Total
overhead expense payments (Note 4) |
|
16.3 |
16.3 |
16.3 |
16.3 |
34.4 |
34.4 |
34.4 |
34.4 |
43.2 |
43.2 |
43.2 |
43.2 |
|
|
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 |
|
|
|
|
|
|
|
|
|
|
'Other
loan' repayments |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
VAT paid
on overheads, capex etc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
VAT paid
to State |
|
|
|
20.0 |
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
6.8 |
|
|
|
7.1 |
|
|
|
7.4 |
|
|
Total
cash payments |
|
73.5
|
53.0
|
87.1
|
61.6
|
125.8
|
96.6
|
77.0
|
71.8
|
134.1
|
127.0
|
84.4
|
102.1
|
|
|
|
|
|
|
|
|
|
Net cashflow |
|
(55.8) |
(35.3) |
11.5 |
(8.5) |
(92.3) |
(63.2) |
125.4
|
29.4 |
(98.4) |
(91.3) |
104.0
|
60.6
|
|
|
|
|
|
|
|
|
Opening net cash balance
(deficit) |
|
(110.0) |
(165.8) |
(201.1) |
(189.6) |
(198.1) |
(290.4) |
(353.6) |
(228.2) |
(198.8) |
(297.2) |
(388.5) |
(284.5) |
|
|
Closing net cash balances
(deficit) |
|
(165.8) |
(201.1) |
(189.6) |
(198.1) |
(290.4) |
(353.6) |
(228.2) |
(198.8) |
(297.2) |
(388.5) |
(284.5) |
(223.9) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
(55.8) |
(35.3) |
11.5 |
(8.5) |
(92.3) |
(63.2) |
125.4 |
29.4 |
(98.4) |
(91.3) |
104.0 |
60.6 |
|
Closing net cash balance
(deficit) |
|
(165.8) |
(201.1) |
(189.6) |
(198.1) |
(290.4) |
(353.6) |
(228.2) |
(198.8) |
(297.2) |
(388.5) |
(284.5) |
(223.9) |
|
Initial
3 months (12 weeks) commencing in Jan 2004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|