| 12 Months |
|
|
|
|
|
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2006 |
05-06 |
| to end Jan |
|
|
|
|
|
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
Year |
| MONTHLY
ASSUMPTIONS No. 6 - FUNDING, INTEREST RATES & RELATED ITEMS |
|
|
|
|
| Interest |
|
|
| Interest rates (% pa): |
|
|
|
|
|
|
|
|
|
|
|
|
|
Avg/Tot |
| -Cash at bank |
|
->> |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0 |
4.0
|
| -Short-term loans/Line of credit |
|
->> |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5 |
13.5
|
| -Longterm debt/notes |
|
->> |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5 |
12.5
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Debt |
|
|
|
Enter all increases and
repayments as positive values |
|
|
|
|
|
| Increases
in longterm debt/notes ($000) |
|
->> |
|
|
10.0 |
|
10.0 |
| Longterm
debt/note repayments ($000) |
|
->> |
5.0 |
|
5.0 |
|
5.0 |
|
5.0 |
|
20.0 |
| |
|
Opening |
|
|
Opening values entered
via opening balance sheet |
|
|
|
|
|
| Total
longterm debt/notes ($000) |
|
30.0 |
25.0 |
25.0 |
35.0 |
30.0 |
30.0 |
30.0 |
25.0 |
25.0 |
25.0 |
20.0 |
20.0 |
20.0 |
|
| Proportions payable within one
year: |
|
Opening |
|
|
On first use, set cells
below to zero and revise later |
|
|
|
|
|
| -Longterm debt/notes (as % total) |
->> |
|
66.7 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Various Items |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Miscellaneous
income ($000) |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
12.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Operating
lease payments ($000) |
|
->> |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
1.1 |
13.2 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Intangible
asset amortization ($000) |
|
->> |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
12.0 |
| |
|
|
|
On first use, set cells
below to zero and revise later |
|
|
|
|
Total |
| Changes
(+/-) in accrued expenses ($000) |
->> |
|
(4.0) |
|
(4.0) |
| Changes
(+/-) in prepaid expenses ($000) |
->> |
(2.0) |
|
(2.0) |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Approximate % of
total payroll costs relating to |
|
|
On first use, set cells
below in range 20-40% and revise later |
|
|
|
|
| taxes & benefits for all staff (%) |
|
|
->> |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Stocks, Shares &
Investment |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Proceeds
of new stock issues ($000) |
|
->> |
|
5.0 |
|
5.0 |
| No.
of new shares issued (000s) |
|
->> |
|
3.0 |
|
3.0 |
| No
of shares issued & fully-paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| at opening balance sheet date (000s) |
|
->> |
100.0 |
<<- |
|
|
| |
|
|
| Taxes
& Dividends |
|
|
| Effective
federal/state tax rate for year (%) |
->> |
7.0 |
<<- |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends
for current year ($000) |
|
|
->> |
|
|
|
| * Set row to zeros for Ltd Co |
|
->> |
|
|
| * Set row to zeros for Ltd Co |
|
->> |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|