| |
|
|
|
|
|
|
|
|
|
| |
TEXTUAL SUMMARY REPORT |
|
|
|
| |
|
|
|
| |
Date prepared: |
05-Jan-04 |
|
|
|
| |
|
|
|
|
|
| |
The
following assumption and financial reports for ANY CORP INC |
|
|
|
| |
cover
the year commencing in Jan 2004. They have been derived from |
|
|
|
| |
the detailed assumptions in Cashflow
Plan's monthly reports. |
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
| |
ASSUMPTIONS - ANY CORP INC |
|
|
|
| |
|
|
|
| |
This
report covers the twelve months to end Dec 2004 and has been |
|
|
|
| |
based on detailed monthly
projections and assumptions. |
|
|
|
| |
|
|
|
| |
The following table and chart
summarize sales projections for the year: |
|
|
|
| |
|
|
|
| |
|
Quarter
Ends in Year to Dec 2004 |
|
Annual |
|
|
|
| |
Sales |
1 Qtr |
2 Qtr |
3 Qtr |
4 Qtr |
Total |
|
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
|
| |
Product Group: |
|
|
|
|
|
| |
-
Group1 |
305.0 |
330.0 |
370.0 |
430.0 |
1,435.0 |
|
|
|
| |
-
Group2 |
160.9 |
231.3 |
308.3 |
341.7 |
1,042.2 |
|
|
|
| |
-
Group3 |
79.3 |
114.0 |
151.9 |
168.3 |
513.5 |
|
|
|
| |
-
Group4 |
30.0 |
30.0 |
30.0 |
30.0 |
120.0 |
|
|
|
| |
-
Group5 |
60.0 |
60.0 |
60.0 |
60.0 |
240.0 |
|
|
|
| |
-
Group6 |
285.0 |
320.0 |
345.0 |
380.0 |
1,330.0 |
|
|
|
| |
-
Group7 |
|
|
|
|
|
|
|
|
| |
-
Group8 |
|
|
|
|
|
|
|
|
| |
-
Group9 |
|
|
|
|
|
|
|
|
| |
-
Group10 |
|
|
|
|
|
|
|
|
| |
Total sales |
920.2 |
1,085.3 |
1,265.2 |
1,410.0 |
4,680.7 |
|
|
|
| |
% Quarterly changes |
NA |
17.9 |
16.6 |
11.4 |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
| |
Projected inventory levels for the
four quarters are as follows: |
|
|
|
| |
|
|
|
| |
|
Opening |
Quarter Ends in Year to Dec 2004 |
|
|
|
| |
Inventories |
Levels |
1st |
2nd |
3rd |
4th |
|
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
|
| |
|
|
|
|
|
|
| |
Finished goods |
126.3 |
151.4
|
181.6
|
208.7
|
227.6
|
|
|
|
| |
Materials/goods |
140.0 |
140.0 |
140.0 |
140.0 |
140.0 |
|
|
|
| |
Total inventory |
266.3 |
291.4
|
321.6
|
348.7
|
367.6
|
|
|
|
| |
|
|
|
| |
The projected average
materials/goods cost percentages are as follows: |
|
|
|
| |
|
|
|
| |
|
Quarterly Averages for Year
to Dec 2004 |
Annual |
|
|
|
| |
Product Groups |
1st |
2nd |
3rd |
4th |
Averages |
|
|
|
| |
|
% Sales |
% Sales |
% Sales |
% Sales |
% Sales |
|
|
|
| |
|
|
|
|
|
|
| |
Group1 |
35.4
|
39.8
|
37.0
|
36.8
|
37.3
|
|
|
|
| |
Group2 |
46.7
|
40.2
|
41.3
|
38.4
|
40.9
|
|
|
|
| |
Group3 |
43.0
|
37.0
|
38.0
|
35.3
|
37.7
|
|
|
|
| |
Group4 |
28.0
|
28.0
|
28.0
|
28.0
|
28.0
|
|
|
|
| |
Group5 |
25.0
|
25.0
|
25.0
|
25.0
|
25.0
|
|
|
|
| |
Group6 |
31.1
|
31.4
|
30.9
|
31.2
|
31.1
|
|
|
|
| |
Group7 |
|
|
|
|
|
|
|
|
| |
Group8 |
|
|
|
|
|
|
|
|
| |
Group9 |
|
|
|
|
|
|
|
|
| |
Group10 |
|
|
|
|
|
|
|
|
| |
|
|
|
| |
The projected headcounts at quarter
ends are as follows: |
|
|
|
| |
|
|
|
| |
|
|
Quarter Ends in Year to Dec 2004 |
|
|
|
| |
Functions |
|
1st |
2nd |
3rd |
4th |
|
|
|
| |
|
|
Nos |
Nos |
Nos |
Nos |
|
|
|
| |
|
|
|
|
|
|
| |
Direct labor |
|
12 |
15 |
18 |
21 |
|
|
|
| |
Indirect labor |
|
10 |
10 |
10 |
10 |
|
|
|
| |
Supervisory staff |
|
5 |
5 |
5 |
5 |
|
|
|
| |
Sales |
|
5 |
5 |
5 |
5 |
|
|
|
| |
Clerical |
|
10 |
10 |
10 |
10 |
|
|
|
| |
Management |
|
10 |
10 |
10 |
10 |
|
|
|
| |
Research
& development |
5 |
5 |
5 |
5 |
|
|
|
| |
Total headcount |
|
57 |
60 |
63 |
66 |
|
|
|
| |
|
|
|
| |
Direct costs and overhead expenses
are summarized below. |
|
|
|
| |
|
|
|
| |
|
|
|
Quarters
in Year to Dec 2004 |
Annual |
|
|
| |
Cost Analysis |
|
1st |
2nd |
3rd |
4th |
Total |
|
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Materials/packaging/goods |
310.1 |
367.8 |
432.0 |
477.3 |
1,587.3 |
|
|
| |
Direct labor |
|
34.4 |
43.9 |
53.7 |
64.2 |
196.2 |
|
|
| |
Other direct |
|
78.3 |
97.3 |
107.7 |
123.9 |
407.2 |
|
|
| |
Total cost of sales |
|
422.9 |
509.0 |
593.4 |
665.4 |
2,190.6
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
| |
Operational (indirect) |
|
96.0 |
96.0 |
96.0 |
96.0 |
384.0 |
|
|
| |
Selling & freight |
|
137.1 |
142.1
|
147.5 |
151.8
|
578.4 |
|
|
| |
Management/admin staff |
150.0
|
150.0
|
150.0
|
150.0
|
600.0 |
|
|
| |
Research
& development |
63.0 |
63.0 |
63.0 |
63.0 |
252.0 |
|
|
| |
Administration |
|
27.0 |
27.0 |
27.0 |
27.0 |
108.0 |
|
|
| |
Occupancy/general |
|
43.5
|
43.5
|
43.5
|
43.5
|
174.0 |
|
|
| |
Total overhead expenses |
516.6
|
521.6
|
527.0
|
531.3 |
2,096.4 |
|
|
| |
Total direct costs &
expenses |
939.5
|
1,030.6
|
1,120.3
|
1,196.7
|
4,287.1
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
| |
Proposed capital expenditure
(excluding finance leasing) is summarized in the next table. |
|
|
|
| |
|
|
|
| |
|
|
|
Quarters
in Year to Dec 2004 |
Annual |
|
|
| |
Capital Expenditure |
|
1st |
2nd |
3rd |
4th |
Total |
|
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Total capital
expenditure |
|
|
150.0
|
|
150.0 |
|
|
| |
|
|
|
| |
Changes in longterm debt and leasing
are summarized below. |
|
|
|
| |
|
|
|
| |
|
|
|
Quarters
in Year to Dec 2004 |
Annual |
|
|
| |
Debt & Leasing |
|
1st |
2nd |
3rd |
4th |
Total |
|
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Increase in longterm
debt/notes |
50.0 |
|
250.0 |
250.0 |
550.0 |
|
|
| |
Longterm debt/note
repayments |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
|
|
| |
Net changes in longterm
debt/notes |
25.0 |
(25.0) |
225.0 |
225.0 |
450.0 |
|
|
| |
|
|
|
|
|
|
| |
Increases in 'other
loans' |
|
125.0 |
|
|
125.0 |
|
|
| |
'Other loan' repayments |
|
|
|
|
25.0 |
25.0 |
|
|
| |
Net changes in 'other
loans' |
|
125.0 |
|
(25.0) |
100.0 |
|
|
| |
|
|
|
|
|
|
| |
Increases in leases |
|
|
75.0 |
|
|
75.0 |
|
|
| |
Lease repayments |
|
30.0 |
38.0 |
38.0 |
8.0 |
114.0 |
|
|
| |
Net changes in leases |
|
(30.0) |
37.0 |
(38.0) |
(8.0) |
(39.0) |
|
|
| |
|
|
|
|
|
|
| |
Overall changes in loans
& leases |
(5.0) |
137.0 |
187.0 |
192.0 |
511.0 |
|
|
| |
|
|
|
| |
Other significant transactions
during the year include the following: |
|
|
|
| |
|
|
|
| |
|
|
|
Quarters
in Year to Dec 2004 |
Annual |
|
|
| |
Other Transactions |
|
1st |
2nd |
3rd |
4th |
Total |
|
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Revenue grants/subsidies |
|
|
|
|
|
|
|
| |
|
|
|
|
|
| |
Proceeds
of new stock issues |
25.0 |
|
300.0 |
|
325.0 |
|
|
| |
|
|
|
|
|
|
| |
Proceeds of fixed asset
sales |
|
|
|
50.0 |
50.0 |
|
|
| |
|
|
|
|
|
|
| |
Dividends
for current year |
|
|
|
|
|
|
|
| |
|
|
|
| |
The following key assumptions
regarding rates etc. were used |
|
|
|
| |
in
compiling the projections for the year to end Dec 2004. |
|
|
|
| |
|
|
|
| |
Items |
|
Value |
Basis |
|
|
|
| |
Bad debts |
|
0.5 |
As percent sales |
|
|
|
| |
Depreciation |
|
10.0 |
Annual % rates |
|
|
|
| |
Interest rates (% pa): |
|
|
|
|
|
|
|
| |
Cash at bank |
|
4.0 |
Monthly average |
|
|
|
| |
Short-term loans/line of credit |
13.5 |
Monthly average |
|
|
|
| |
Longterm debt/notes |
|
12.5 |
Monthly average |
|
|
|
| |
Working capital: |
|
|
|
|
|
|
|
| |
Accounts receivable (days sales) |
38 |
Based on full-yr sales |
|
|
|
| |
Inventory (days sales) |
26 |
Based on full-yr sales |
|
|
|
| |
Accounts payable (days costs/exs) |
30 |
Based on full-yr costs |
|
|
|
| |
|
|
|
|
|
| |
The projected monthly levels of
inventory, receivables and payables |
|
|
|
| |
are indicated below: |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
|
| |
CASHFLOW &
FINANCIALS - ANY CORP INC |
|
|
|
|
| |
|
|
|
| |
CASHFLOW PROJECTIONS |
|
|
|
| |
|
|
|
|
| |
Based
on detailed monthly projections, the net cash inflow for the |
|
|
|
| |
year
will be $654 000. The projected year-end bank position will |
|
|
|
| |
be
a $544 000 cash balance. |
|
|
|
| |
|
|
|
| |
The following table analyses
cashflows for the year: |
|
|
|
| |
|
|
|
| |
Year
to end Dec 2004 |
|
|
|
$000 |
|
|
|
| |
|
|
|
|
|
|
| |
CASH RECEIPTS |
|
|