| |
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: |
|
|
|
|
| |
-
Group1 |
61.0 |
66.0 |
74.0 |
86.0 |
287.0 |
|
|
| |
-
Group2 |
57.0 |
64.0 |
69.0 |
76.0 |
266.0 |
|
|
| |
Total sales |
118.0 |
130.0 |
143.0 |
162.0 |
553.0 |
|
|
| |
% Quarterly changes |
NA |
10.2 |
10.0
|
13.3 |
|
|
|
| |
|
|
| |
This
shows that Group1 will account for 52% of projected sales and that Group2
will |
|
|
| |
account
for the balance of 48%. |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
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 |
43.0 |
43.0 |
43.0 |
43.0 |
43.0 |
|
|
| |
|
|
| |
The projected average
materials/goods cost percentages for the four quarters are |
|
|
| |
as follows: |
|
|
| |
|
|
| |
|
Quarterly Averages for Year
to Jan 2006 |
Annual |
|
|
| |
Product Groups |
1st |
2nd |
3rd |
4th |
Averages |
|
|
| |
|
% Sales |
% Sales |
% Sales |
% Sales |
% Sales |
|
|
| |
|
|
|
|
|
| |
Group1 |
41.0
|
41.0
|
41.0
|
41.0
|
41.0
|
|
|
| |
Group2 |
39.0
|
39.0
|
39.0
|
39.0
|
39.0
|
|
|
| |
Based on Cost of
Materials (Assumption Report No. 2) as % Sales (Report No. 1) |
|
|
| |
|
|
| |
The projected headcounts at quarter
ends are as follows: |
|
|
| |
|
|
| |
|
|
Quarter Ends in Year to Jan 2006 |
|
|
| |
Functions |
|
1st |
2nd |
3rd |
4th |
|
|
| |
|
|
Nos |
Nos |
Nos |
Nos |
|
|
| |
Direct labor: |
|
|
|
|
| |
-
Group1 |
|
1 |
2 |
2 |
2 |
|
|
| |
-
Group2 |
|
1 |
2 |
2 |
2 |
|
|
| |
Total direct labor |
|
2 |
3 |
4 |
4 |
|
|
| |
Indirect labor |
|
2 |
2 |
2 |
2 |
|
|
| |
Sales |
|
1 |
1 |
1 |
1 |
|
|
| |
Clerical |
|
1 |
1 |
1 |
1 |
|
|
| |
Management |
|
1 |
1 |
1 |
1 |
|
|
| |
Total headcount |
|
7 |
8 |
9 |
9 |
|
|
| |
|
|
| |
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 |
47.2 |
52.0 |
57.3 |
64.9 |
221.4 |
|
| |
Direct labor |
|
5.2 |
6.9 |
9.5 |
10.4 |
32.0
|
|
| |
Other direct |
|
21.3 |
26.2 |
29.1 |
33.0 |
109.6 |
|
| |
Total Cost of sales |
|
73.7
|
85.1
|
95.9
|
108.3 |
363.1
|
|
| |
Overhead expenses: |
|
|
|
|
| |
Operational (indirect) |
|
8.9 |
8.9 |
8.9 |
8.9 |
35.4
|
|
| |
Selling & freight |
|
11.9 |
12.1 |
12.4 |
12.7 |
49.1 |
|
| |
Management/admin staff |
8.3 |
8.3 |
8.3 |
8.3 |
33.0 |
|
| |
Administration |
|
5.3 |
5.3 |
5.3 |
5.3 |
21.0 |
|
| |
Occupancy/general |
|
2.6 |
2.6 |
2.6 |
2.6 |
10.2 |
|
| |
Total overhead expenses |
36.8
|
37.0
|
37.3
|
37.6
|
148.7
|
|
| |
Total direct costs &
expenses |
110.5
|
122.2 |
133.1
|
145.9
|
511.7 |
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Proposed capital expenditure
(excluding leasing) 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 |
|
| |
|
|
|
|
| |
Land,
buildings & improvements |
|
|
30.0 |
|
30.0 |
|
| |
Plant,
equipment & vehicles |
10.0 |
|
|
|
10.0 |
|
| |
Total capital
expenditure |
10.0 |
|
30.0 |
|
40.0 |
|
| |
|
|
| |
Changes in longterm debt and leasing
are summarized below |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Debt & Leasing |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Increase in longterm
debt/notes |
10.0 |
|
50.0 |
50.0 |
110.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) |
45.0 |
45.0 |
90.0 |
|
| |
|
|
|
|
|
| |
Increases in leases |
|
|
15.0 |
|
|
15.0 |
|
| |
Lease repayments |
|
6.0 |
7.3 |
7.3 |
1.3 |
21.9 |
|
| |
Net changes in leases |
|
(6.0) |
7.7 |
(7.3) |
(1.3) |
(6.9) |
|
| |
|
|
|
|
|
| |
Overall changes in loans
& leases |
(1.0) |
2.7 |
37.7 |
43.7 |
83.1 |
|
| |
|
|
| |
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 |
|
|
|
10.0 |
10.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. |
|
|
| |
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
|
|
| |
The following table analyses sales
and gross margins by |
|
|
| |
main product group for the full
year: |
|
|
| |
|
|
| |
|
Total |
Gross |
Gross |
|
|
| |
Year
to end Jan 2006 |
Sales |
Margin |
Margin |
|
|
| |
|
$000 |
$000 |
% Sales |
|
|
| |
Product Group: |
|
|
|
|
| |
-
Group1 |
287.0 |
98.5
|
34.3 |
|
|
| |
-
Group2 |
266.0 |
91.4
|
34.4 |
|
|
| |
Total |
553.0 |
189.9 |
34.3 |
|
|
| |
|
|
| |
This
shows that Group1 will account for 52% of projected sales |
|
|
| |
(52%
of total gross margin) and that Group2 will account for the |
|
|
| |
balance
of 48% of sales (48% of total gross margin). |
|
|
| |
|
|
| |
The
projected overall gross margin is 34%. |
|
|
| |
|
|
| |
Based
on projected sales of $553 000, ANY CORP INC |
|
|
| |
expects
to report a pretax profit of $11 000 for the year. |
|
|
| |
The following table analyses these
projections: |
|
|
| |
|
|
| |
Year to end Jan 2006 |
|
$000 |
% Sales |
|
|
| |
Sales |
|
553.0 |
100 |
|
|
|
|
| |
Cost of sales |
|
363.1
|
66 |
|
|
|
|
| |
Gross Margin |
|
189.9
|
34 |
|
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
|
|
| |
-Operational
(indirect) |
|
35.4
|
6 |
|
|
|
|
| |
-Selling & freight |
|
49.1 |
9 |
|
|
|
|
| |
-Management/admin staff |
33.0 |
6 |
|
|
|
|
| |
-Administration |
|
21.0 |
4 |
|
|
|
|
| |
-Occupancy/general |
|
10.2 |
2 |
|
|
|
|
| |
Depreciation |
|
13.1
|
2 |
|
|
|
|
| |
Operating lease payments |
13.2 |
2 |
|
|
|
|
| |
Total operating expenses |
174.9
|
32 |
|
|
|
|
| |
Income from operations |
15.0
|
3 |
|
|
|
|
| |
Other income/expenses: |
|
|
|
|
|
|
| |
-Profit (loss) disposal of fixed assets |
8.0 |
1 |
|
|
|
|
| |
-Intangible asset amortization |
12.0 |
2 |
|
|
|
|
| |
-Miscellaneous income |
24.0 |
4 |
|
|
|
|
| |
Total other income
(expenses) |
20.0 |
4 |
|
|
|
|
| |
Earnings before interest
& taxes |
35.0
|
6 |
|
|
|
|
| |
Interest expense/income: |
|
|
|
|
|
|
| |
-Interest expense |
|
12.0
|
2 |
|
|
|
|
| |
-Lease interest expense |
12.0 |
2 |
|
|
|
|
| |
-Interest income |
|
0.3
|
0 |
|
|
|
|
| |
Net interest expense
(income) |
23.7
|
4 |
|
|
|
|
| |
Net income before taxes |
11.3
|
2 |
|
|
|
|
| |
|
|
| |
Based
on detailed monthly projections, the net cash inflow |
|
|
| |
for
the twelve months will be $44 000. The projected year-end bank |
|
|
| |
position
will be a $31 000 cash balance. |
|
|
| |
|
|
| |
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 |
|
335.0 |
553.0 |
65 |
|
|
| |
Cost of sales |
|
260.0 |
363.1
|
40 |
|
|
| |
Gross margin |
|
75.0 |
189.9
|
153 |
|
|
| |
Total operating expenses |
144.0 |
174.9
|
21 |
|
|
| |
Income from operations |
(69.0) |
15.0
|
|
|
|
| |
Other income, interest
expense etc. |
(7.0) |
(3.7) |
|
|
|
| |
Net income before taxes |
(76.0) |
11.3
|
|
|
|
| |
Taxes |
|
|
0.8
|
|
|
|
| |
Net income |
|
(76.0) |
10.5
|
|
|
|
| |
Dividends
declared |
|
|
|
|
|
|
| |
Transferred
to reserves |
|
(76.0) |
10.5
|
|
|
|
| |
|
|
| |
This
indicates that sales could increase by $218 000 while |
|
|
| |
net
income could improve by $87 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 |
|
155.9 |
133.0 |
201.7 |
231.4 |
722.0 |
|
| |
Total cash payments |
|
172.2 |
147.3 |
|