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: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|