| |
|
|
|
|
|
|
|
|
|
| |
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 |
285.0 |
320.0 |
345.0 |
380.0 |
1,330.0 |
|
|
|
| |
Total sales |
830.2 |
995.3 |
1,175.2 |
1,320.0 |
4,320.7 |
|
|
|
| |
% Quarterly changes |
NA |
19.9 |
18.1 |
12.3 |
|
|
|
|
| |
|
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
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 |
143.7
|
172.9
|
200.4
|
219.6
|
|
|
|
| |
Materials/goods |
120.0 |
120.0 |
120.0 |
120.0 |
120.0 |
|
|
|
| |
Total inventory |
246.3 |
263.7
|
292.9
|
320.4
|
339.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 |
31.1
|
31.4
|
30.9
|
31.2
|
31.1
|
|
|
|
| |
|
|
|
| |
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 |
292.3 |
345.5 |
408.6 |
453.9 |
1,500.4
|
|
|
| |
Direct labor |
|
35.0 |
43.9 |
53.5 |
64.1 |
196.5
|
|
|
| |
Other direct |
|
79.9 |
97.2 |
107.4 |
123.8 |
408.2
|
|
|
| |
Total cost of sales |
|
407.2
|
486.6
|
569.5
|
641.8
|
2,105.1
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
| |
Operational (indirect) |
|
96.0 |
96.0 |
96.0 |
96.0 |
384.0 |
|
|
| |
Selling & freight |
|
110.4 |
115.4 |
120.8
|
125.1
|
471.6
|
|
|
| |
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 |
489.9
|
494.9
|
500.3
|
504.6 |
1,989.6
|
|
|
| |
Total direct costs &
expenses |
897.1
|
981.5
|
1,069.8
|
1,146.4
|
4,094.7
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
| |
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) |
25 |
Based on full-yr sales |
|
|
|
| |
Accounts payable (days costs/exs) |
29 |
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 $501 000. The projected year-end bank position will |
|
|
|
| |
be
a $391 000 cash balance. |
|
|
|
| |
|
|
|
| |
The following table analyses
cashflows for the year: |
|
|
|
| |
|
|
|
| |
Year
to end Dec 2004 |
|
|
|
$000 |
|
|
|
| |
|
|
|
|
|
|
| |
CASH RECEIPTS |
|
|
|
|
|
| |
Cash sales &
accounts receivable |
|
4,288.9
|
|
|
|
| |
Proceeds
of new stock issues |
|
325.0 |
|
|
|
| |
Increases in longterm
debt/notes |
|
550.0 |
|
|
|
| |
Increases in other loans |
|
125.0 |
|
|
|
| |
Proceeds from sale of
fixed assets |
|
50.0 |
|
|
|
| |
VAT
recovered from State |
|
36.1
|
|
|
|
| |
Capital grants/subsidies
received |
|
|
|
|
|
| |
Revenue grants/subsidies
received |
|
|
|
|
|
| |
Miscellaneous income
received |
|
120.0 |
|
|
|
| |
Interest received |
|
4.8
|
|
|
|
| |
Total cash receipts |
|
5,499.8
|
|
|
|
| |
|
|
|
|
|
|
| |
CASH PAYMENTS |
|
|
|
|
|
| |
Materials/goods accounts
payable |
|
1,843.6
|
|
|
|
| |
Total direct cost
payments |
|
557.9 |
|
|
|
| |
Total overhead expense
payments |
|
1,864.4
|
|
|
|
| |
Taxes paid |
|
|
|
|
|
| |
Dividends paid |
|
|
|
|
|
| |
Finance lease debt
repayments |
|
114.0 |
|
|
|
| |
Finance lease interest
paid |
|
60.0 |
|
|
|
| |
Capital expenditure
payments |
|
195.0 |
|
|
|
| |
Operating lease payments |
|
66.0 |
|
|
|
| |
Longterm debt/note
repayments |
|
100.0 |
|
|
|
| |
'Other loan' repayments |
|
25.0 |
|
|
|
| |
VAT
paid on overheads, capex etc. |
|
|
|
|
|
| |
VAT paid to State |
|
20.5
|
|
|
|
| |
Opening payroll
taxes/benefits paid |
|
25.0 |
|
|
|
| |
Changes in prepaid
expenses |
|
(10.0) |
|
|
|
| |
Changes in accrued
expen |