| 12 Months |
|
|
|
|
|
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
| to end
Dec |
|
|
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Year |
| ASSUMPTIONS
No. 5 - 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
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Interest
payable on 'other loans' ($000) |
|
->> |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
6.0 |
6.0 |
6.0 |
6.0 |
6.0 |
6.0 |
6.0 |
57.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Interest Payment Months |
|
|
|
|
For each row below, enter
"1" to signify a payment month, otherwise leave blank |
|
|
|
|
|
|
|
|
|
|
| Cash at bank |
|
->> |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
| Short-term
loans/Line of credit |
|
->> |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
| Longterm
debt/notes |
|
->> |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
| 'Other
loans' |
|
->> |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Debt & Loans |
|
|
|
Enter increases and
repayments as positive values |
|
|
|
|
Total |
| Increases
in longterm debt/notes ($000) |
|
->> |
|
|
50.0 |
|
250.0 |
250.0 |
|
550.0 |
| Longterm
debt/notes repayments ($000) |
|
->> |
25.0 |
|
25.0 |
|
25.0 |
|
25.0 |
|
100.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Increases
in 'other loans' ($000) |
|
->> |
|
125.0 |
|
125.0 |
| 'Other
loan' repayments ($000) |
|
->> |
|
25.0 |
|
25.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Finance Leases |
|
|
| Finance
leases from prior years ($000): |
|
|
|
|
Set cells below to zero
if no finance leases outstanding |
|
|
|
|
Total |
| -Interest expense |
|
->> |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
|
45.0 |
| -Debt repayments |
|
->> |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
|
90.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Allocation of Debt |
|
Opening |
|
Opening values must be
entered via opening balance sheet |
|
|
| Total
longterm debt/notes ($000) |
|
200.0 |
175.0 |
175.0 |
225.0 |
200.0 |
200.0 |
200.0 |
175.0 |
175.0 |
425.0 |
650.0 |
650.0 |
650.0 |
|
| Total
'other loans' ($000) |
|
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
50.0 |
175.0 |
175.0 |
175.0 |
175.0 |
150.0 |
150.0 |
150.0 |
|
| Total
finance leases ($000) |
|
90.0 |
80.0 |
70.0 |
60.0 |
125.0 |
107.0 |
97.0 |
87.0 |
69.0 |
59.0 |
59.0 |
51.0 |
51.0 |
|
| Proportions payable within one
year: |
|
Opening |
|
|
On first use, set cells
below to zero and revise later |
|
|
|
|
|
| -Longterm debt/notes (as % total) |
->> |
|
50.0
|
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
25.0 |
|
| -'Other loans' (as % total) |
->> |
|
50.0
|
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
|
| -Finance Leases (as % total) |
->> |
|
100.0
|
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Miscellaneous Items |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Miscellaneous
income ($000) |
|
->> |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
120.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Revenue
grant/subsidy receipts ($000) |
|
->> |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Operating
lease payments ($000) |
|
->> |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
5.5 |
66.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Intangible
asset amortization ($000) |
|
->> |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
60.0 |
| |
|
|
|
On first use, set cells
below to zero and revise later |
|
|
|
|
Total |
| Changes
(+/-) in accrued expenses ($000) |
->> |
|
(20.0) |
|
(20.0) |
| Changes
(+/-) in prepaid expenses ($000) |
->> |
(10.0) |
|
(10.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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Proceeds
of new stock issues ($000) |
|
->> |
|
25.0 |
|
300.0 |
|
325.0 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Tax
& Dividends |
|
|
| Effective
federal/state tax rate for year (%) |
->> |
7.0 |
7.0 |
|
|
| Federal/state
tax payments ($000) |
|
->> |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
X = 0 to 4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends
for current year ($000) |
4 |
|
<<->> |
|
|
|
| * Set row to zeros for Ltd Co |
|
->> |
|
|
| * Set row to zeros for Ltd Co |
|
->> |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|