| |
TEXTUAL SUMMARY REPORT |
|
|
|
|
| |
|
|
| |
Date prepared: |
31-Dec-03 |
|
|
| |
|
|
|
|
| |
The
following three operational & financial reports for ANY CORP INC cover |
|
|
| |
the
months and years commencing in Feb 2005. They have been derived |
|
|
| |
from the detailed
assumptions in Exl-Plan's Monthly, Quarterly and Annual |
|
|
| |
Reports. |
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
| |
1. FIRST-YEAR OPERATIONAL REPORT - ANY CORP INC |
|
|
| |
|
|
| |
This
First-Year Operational Report covers the twelve months to end Jan 2006 |
|
|
| |
based on detailed monthly
projections and assumptions. The |
|
|
| |
following table summarizes quarterly
sales projections for this year: |
|
|
| |
|
|
| |
|
Quarter
Ends in Year to Jan 2006 |
|
Annual |
|
|
| |
Sales |
1 Qtr |
2 Qtr |
3 Qtr |
4 Qtr |
Total |
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
Product Group: |
|
|
|
|
| |
Group
1 |
52.5 |
57.0 |
61.5 |
66.0 |
237.0 |
|
|
| |
Group
2 |
15.8 |
18.2 |
21.1 |
24.5 |
79.6 |
|
|
| |
Group
3 |
|
|
|
|
|
|
|
| |
Group
4 |
|
|
|
|
|
|
|
| |
Group
5 |
|
|
|
|
|
|
|
| |
Total sales |
68.3 |
75.2 |
82.6 |
90.5 |
316.6 |
|
|
| |
% Quarterly changes |
NA |
10.2 |
9.8 |
9.5 |
|
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Projected inventory levels for the
four quarters are as follows: |
|
|
| |
|
|
| |
|
Opening |
Quarter Ends in Year to Jan 2006 |
|
|
| |
Inventories |
Levels |
1st |
2nd |
3rd |
4th |
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Materials/goods |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
|
|
| |
|
|
| |
The projected average
materials/goods cost percentages for the four quarters are |
|
|
| |
as follows: |
|
|
| |
|
|
| |
Materials/Goods |
Quarterly Averages for Year
to Jan 2006 |
Annual |
|
|
| |
Costs |
1st |
2nd |
3rd |
4th |
Averages |
|
|
| |
|
% Sales |
% Sales |
% Sales |
% Sales |
% Sales |
|
|
| |
|
|
|
|
|
| |
Materials/goods costs |
41.0 |
41.0 |
41.0 |
41.0 |
41.0 |
|
|
| |
|
|
| |
The projected headcounts at quarter
ends are as follows: |
|
|
| |
|
|
| |
|
|
Quarter Ends in Year to Jan 2006 |
|
|
| |
Headcount |
|
1st |
2nd |
3rd |
4th |
|
|
| |
|
|
Nos |
Nos |
Nos |
Nos |
|
|
| |
Direct |
|
1 |
2 |
2 |
2 |
|
|
| |
Clerical |
|
1 |
1 |
1 |
1 |
|
|
| |
Management |
|
1 |
1 |
1 |
1 |
|
|
| |
Total headcount |
|
3 |
4 |
4 |
4 |
|
|
| |
|
|
| |
Direct costs and overhead expenses
are summarized below. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Cost Analysis |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Materials/packaging/goods |
28.0 |
30.9 |
33.9 |
37.1 |
129.8
|
|
| |
Direct labor |
|
2.6 |
3.9 |
5.2 |
5.2 |
16.9 |
|
| |
Other direct |
|
9.3 |
10.2 |
11.1 |
12.0 |
42.6 |
|
| |
Total Cost of sales |
|
39.9
|
44.9
|
50.2
|
54.3
|
189.3
|
|
| |
Selling |
|
2.9 |
3.0 |
3.2 |
3.3 |
12.3
|
|
| |
Management/admin staff |
8.3 |
8.3 |
8.3 |
8.3 |
33.0 |
|
| |
General |
|
7.8 |
7.8 |
7.8 |
7.8 |
31.2 |
|
| |
Total overhead expenses |
18.9 |
19.1
|
19.2
|
19.4
|
76.5
|
|
| |
Total direct costs &
expenses |
58.8
|
64.0
|
69.4
|
73.6
|
265.8
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Proposed capital expenditure is
summarized in the next table. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Capital Expenditure |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Capital expenditure |
|
|
|
30.0 |
|
30.0 |
|
| |
|
|
| |
Changes in longterm debt are
summarized below. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Longterm Debt |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Increase in longterm
debt/notes |
10.0 |
|
|
|
10.0 |
|
| |
Longterm debt/note
repayments |
5.0 |
5.0 |
5.0 |
5.0 |
20.0 |
|
| |
Net changes in longterm
debt/notes |
5.0 |
(5.0) |
(5.0) |
(5.0) |
(10.0) |
|
| |
|
|
| |
Other significant transactions
during the year include the following: |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Other Transactions |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Proceeds of share issues |
5.0 |
|
|
|
5.0 |
|
| |
|
|
|
|
|
| |
Proceeds of fixed asset
sales |
6.0 |
|
|
|
6.0 |
|
| |
|
|
|
|
|
| |
Dividends declared |
|
|
|
|
|
|
|
| |
|
|
| |
|
|
|
| |
2. FIRST-YEAR FINANCIAL REPORT - ANY CORP INC |
|
|
|
| |
|
|
| |
This
First-Year Financial Report covers the twelve months to end Jan 2006 |
|
|
| |
based on detailed monthly
projections and assumptions. |
|
|
| |
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
|
|
| |
Based
on projected sales of $317 000, ANY CORP INC |
|
|
| |
expects
to report a pretax profit of $29 000 for the year. |
|
|
| |
|
|
| |
The following table analyses these
projections: |
|
|
| |
|
|
| |
Year
to end Jan 2006 |
|
$000 |
% Sales |
|
|
| |
Sales |
|
316.6
|
100 |
|
|
|
|
| |
Cost of sales |
|
189.3
|
60 |
|
|
|
|
| |
Gross Margin |
|
127.3
|
40 |
|
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
|
|
| |
-Selling |
|
12.3
|
4 |
|
|
|
|
| |
-Management/admin staff |
33.0 |
10 |
|
|
|
|
| |
-General |
|
31.2 |
10 |
|
|
|
|
| |
Depreciation |
|
2.3 |
1 |
|
|
|
|
| |
Operating lease payments |
13.2 |
4 |
|
|
|
|
| |
Total operating expenses |
92.1
|
29 |
|
|
|
|
| |
Income from operations |
35.2
|
11 |
|
|
|
|
| |
Other income/expenses: |
|
|
|
|
|
|
| |
-Profit (loss) disposal of fixed assets |
2.0 |
1 |
|
|
|
|
| |
-Intangible asset amortization |
12.0 |
4 |
|
|
|
|
| |
-Miscellaneous income |
12.0 |
4 |
|
|
|
|
| |
Total other income
(expenses) |
2.0 |
1 |
|
|
|
|
| |
Earnings before interest
& taxes |
37.2
|
12 |
|
|
|
|
| |
Interest expense/income: |
|
|
|
|
|
|
| |
-Interest expense |
|
8.1
|
3 |
|
|
|
|
| |
-Interest income |
|
0.1
|
0 |
|
|
|
|
| |
Net interest expense
(income) |
8.0
|
3 |
|
|
|
|
| |
Net income before taxes |
29.2
|
9 |
|
|
|
|
| |
|
|
| |
Based
on detailed monthly projections, the net cash OUTFLOW |
|
|
| |
for
the twelve months will be $21 000. The projected year-end bank |
|
|
| |
position
will be a $43 000 short-term loan (line of credit) requirement. |
|
|
| |
|
|
| |
The
next table compares the projected results with those for |
|
|
| |
the
previous year which ended in Jan 2005. |
|
|
| |
|
|
| |
Years ending: |
|
Jan 2005 |
Jan 2006 |
Change |
|
|
| |
|
|
$000 |
$000 |
% |
|
|
| |
|
|
|
|
|
| |
Sales |
|
165.0 |
316.6
|
92 |
|
|
| |
Cost of sales |
|
125.0 |
189.3
|
51 |
|
|
| |
Gross margin |
|
40.0 |
127.3
|
218 |
|
|
| |
Total operating expenses |
78.0 |
92.1
|
18 |
|
|
| |
Income from operations |
(38.0) |
35.2
|
|
|
|
| |
Other income, interest
expense etc. |
5.4 |
(6.0) |
|
|
|
| |
Net income before taxes |
(32.6) |
29.2
|
|
|
|
| |
Taxes |
|
|
2.0
|
|
|
|
| |
Net income |
|
(32.6) |
27.1
|
|
|
|
| |
Dividends
declared |
|
|
|
|
|
|
| |
Transferred
to reserves |
|
(32.6) |
27.1
|
|
|
|
| |
|
|
| |
This
indicates that sales could increase by $152 000 while |
|
|
| |
net
income could improve by $62 000 over the year. |
|
|
| |
|
|
| |
The following table summarizes
cashflows for the year by quarter. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Cashflows |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Total cash receipts |
|
102.6 |
77.9 |
86.6 |
94.7 |
361.9 |
|
| |
Total cash payments |
|
105.0 |
79.0 |
112.0 |
87.3 |
383.3 |
|
| |
Net cashflow |
|
(2.4) |
(1.1) |
(25.4) |
7.4
|
(21.5) |
|
| |
|
|
|
|
|
| |
Closing cash balance
(deficit) |
(24.4) |
(25.5) |
(50.9) |
(43.5) |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
The following key assumptions
regarding rates etc. were used |
|
|
| |
in
compiling the projections for the year to end Jan 2006. |
|
|
| |
|
|
| |
Items |
|
Value |
Basis |
|
|
| |
Headcount: |
|
|
|
|
| |
Direct workers |
|
1.6 |
Avg monthly numbers |
|
|
|