| |
|
|
|
|
|
|
|
|
|
| |
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 |
285.0 |
320.0 |
345.0 |
380.0 |
1,330.0 |
|
|
|
| |
Total sales |
590.0 |
650.0 |
715.0 |
810.0 |
2,765.0 |
|
|
|
| |
% Quarterly changes |
NA |
10.2 |
10.0
|
13.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 |
|
|
|
| |
|
|
|
|
|
|
| |
Materials/goods |
145.0 |
145.0 |
145.0 |
145.0 |
145.0 |
|
|
|
| |
|
|
|
| |
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 |
15.0
|
15.0
|
15.0
|
15.0
|
15.0
|
|
|
|
| |
Group2 |
30.0
|
30.0
|
30.0
|
30.0
|
30.0
|
|
|
|
| |
|
|
|
| |
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 |
23 |
|
|
|
| |
Indirect labor |
|
10 |
10 |
10 |
10 |
|
|
|
| |
Sales |
|
5 |
5 |
5 |
5 |
|
|
|
| |
Clerical |
|
10 |
10 |
10 |
10 |
|
|
|
| |
Management |
|
10 |
10 |
10 |
10 |
|
|
|
| |
Total headcount |
|
47 |
50 |
53 |
58 |
|
|
|
| |
|
|
|
| |
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 |
131.3
|
145.5
|
159.0
|
178.5
|
614.3 |
|
|
| |
Direct labor |
|
36.3
|
46.2
|
56.1
|
70.4
|
209.0 |
|
|
| |
Other direct |
|
37.5
|
47.5
|
52.5
|
66.0 |
203.5 |
|
|
| |
Total cost of sales |
|
205.1 |
239.2 |
267.6 |
314.9 |
1,026.8 |
|
|
| |
Overhead expenses: |
|
|
|
|
|
| |
Operational (indirect) |
|
72.0 |
72.0 |
72.0 |
72.0 |
288.0 |
|
|
| |
Selling & freight |
|
97.3
|
98.5
|
99.8
|
101.7
|
397.3 |
|
|
| |
Management/admin staff |
150.0
|
150.0
|
150.0
|
150.0
|
600.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 |
389.8 |
391.0 |
392.3 |
394.2 |
1,567.3 |
|
|
| |
Total direct costs &
expenses |
594.9 |
630.2 |
659.9 |
709.1 |
2,594.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 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) |
12.0 |
187.0 |
217.0 |
411.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 |
|
100.0 |
|
125.0 |
|
|
| |
|
|
|
|
|
|
| |
Proceeds of fixed asset
sales |
|
|
|
35.0 |
35.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 |
|
|
|
| |
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) |
39 |
Based on full-yr sales |
|
|
|
| |
Inventory (days sales) |
19 |
Based on full-yr sales |
|
|
|
| |
Accounts payable (days costs/exs) |
26 |
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 $339 000. The projected year-end bank position will |
|
|
|
| |
be
a $229 000 cash balance. |
|
|
|
| |
|
|
|
| |
The following table analyses
cashflows for the year: |
|
|
|
| |
|
|
|
| |
Year
to end Dec 2004 |
|
|
|
$000 |
|
|
|
| |
|
|
|
|
|
|
| |
CASH RECEIPTS |
|
|
|
|
|
| |
Cash sales &
accounts receivable |
|
2,863.5
|
|
|
|
| |
Proceeds
of new stock issues |
|
125.0 |
|
|
|
| |
Increases in longterm
debt/notes |
|
550.0 |
|
|
|
| |
Proceeds from sale of
fixed assets |
|
35.0 |
|
|
|
| |
VAT
recovered from State |
|
|
|
|
|
| |
Capital grants/subsidies
received |
|
|
|
|
|
| |
Revenue grants/subsidies
received |
|
|
|
|
|
| |
Miscellaneous income
received |
|
120.0 |
|
|
|
| |
Interest received |
|
2.9
|
|
|
|
| |
Total cash receipts |
|
3,696.4
|
|
|
|
| |
|
|
|
|
|
|
| |
CASH PAYMENTS |
|
|
|
|
|
| |
Materials/goods accounts
payable |
|
852.3
|
|
|
|
| |
Total direct cost
payments |
|
356.4 |
|
|
|
| |
Total overhead expense
payments |
|
1,459.7 |
|
|
|
| |
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 |
|
|
|
| |
VAT
paid on overheads, capex etc. |
|
|
|
|
|
| |
VAT paid to State |
|
59.5 |
|
|
|
| |
Opening payroll
taxes/benefits paid |
|
25.0 |
|
|
|
| |
Changes in prepaid
expenses |
|
(10.0) |
|
|
|
| |
Changes in accrued
expenses |
|
20.0 |
|
|
|
| |
Interest paid |
|
59.2
|
|
|
|
| |
Total cash payments |
|
3,357.1
|
|
|
|
| |
|
|
|
|
|
|
| |
Net cashflow |
|
339.4
|
|
|
|
| |
|
|
|
|
|
|
| |
Closing net cash balance
(deficit) |
|
|
229.4
|
|
|
|
| |
|
|
|
|
| |
The following chart highlights the
monthly net cashflows and cash balances for the year: |
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|