| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 36
Months |
|
|
|
|
|
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2006 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2007 |
2005 |
2006 |
2007 |
|
| to end Dec
2007 |
|
|
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Year |
Year |
Year |
|
| MONTHLY
ASSUMPTIONS No. 6 - FUNDING, INTEREST RATES & RELATED ITEMS |
|
|
|
|
|
|
| Interest |
|
|
|
|
|
| Interest rates (% pa): |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Avg/Tot |
Avg/Tot |
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 |
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 |
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 |
|
->> |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
|
| -Longterm debt/notes |
|
->> |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
|
| Int
payable on 'other loans' ($000) |
|
->> |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Debt & Loans |
|
|
|
Enter all increases and
repayments as positive values |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| Increases
in longterm debt/notes ($000) |
|
->> |
|
|
50.0 |
|
250.0 |
250.0 |
|
550.0 |
|
|
|
| Longterm
debt/note repayments ($000) |
|
->> |
25.0 |
|
25.0 |
|
25.0 |
|
25.0 |
|
50.0 |
|
50.0 |
|
100.0 |
50.0 |
50.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| Increases
in 'other loans' ($000) |
|
->> |
|
125.0 |
|
125.0 |
|
|
|
| 'Other
loan' repayments ($000) |
|
->> |
|
25.0 |
|
20.0 |
|
20.0 |
|
25.0 |
20.0 |
20.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Leases |
|
|
|
|
|
| Leases
from prior years ($000): |
|
|
|
Set cells below to zero
if no finance leases outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| -Interest expense |
|
->> |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
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 |
60.0 |
60.0 |
|
| -Repayments |
|
->> |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
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 |
120.0 |
120.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Allocation of Debt |
|
Opening |
|
Opening values 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 |
650.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
600.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.0 |
550.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 |
150.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
130.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
110.0 |
|
|
|
|
| Total
leases ($000) |
|
90.0 |
72.0
|
62.0
|
52.0
|
250.0
|
224.0
|
214.0
|
202.0
|
176.0
|
166.0
|
154.0
|
128.0
|
118.0
|
208.0
|
288.0
|
278.0
|
268.0
|
258.0
|
229.0
|
219.0
|
209.0
|
199.0
|
170.0
|
160.0
|
150.0
|
140.0
|
111.0
|
101.0
|
391.0
|
381.0
|
352.0
|
342.0
|
332.0
|
322.0
|
293.0
|
283.0
|
273.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 |
25.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 |
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 |
20.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 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
|
|
|
|
| -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 |
30.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 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
30.0 |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Various Items |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
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 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
10.0 |
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 |
120.0 |
120.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
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 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
9.0 |
66.0 |
108.0 |
108.0 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
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 |
5.0 |
5.0 |
|
60.0 |
10.0 |
|
|
| Purchases
of intangible assets ($000) |
|
->> |
|
|
|
|
|
| |
|
|
|
On first use, set cells
below to zero and revise later |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| Changes
(+/-) in accrued expenses ($000) |
->> |
|
(20.0) |
|
(20.0) |
|
|
|
| Changes
(+/-) in prepaid expenses ($000) |
->> |
(10.0) |
|
(10.0) |
|
|
|
| |
|
|
On first use, set
cells below to zero. Revise later if you wish to fine tune the receivable or
payable levels automatically calculated using the credit assumptions in the
second table at worksheet M_B |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| Adjustments
(+/-) to receivable levels ($000) |
->> |
|
|
|
|
|
| Adjustments
(+/-) to payable levels ($000) |
|
->> |
|
|
|
|
|
| |
|
|
The above adjustments
will automatically modify relevant cash flows in worksheet M_CF and balances
in M_BS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Approx
% 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 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
40.0 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| Proceeds
of new stock issues ($000) |
|
->> |
|
1,000.0 |
|
|
2,000.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1,000.0 |
|
|
|
|
|
|
|
1,000.0 |
2,000.0 |
1,000.0 |
|
| No.
of new shares issued (000s) |
|
->> |
|
300.0 |
|
400.0 |
|
150.0 |
|
300.0 |
400.0 |
150.0 |
|
| No.
of shares issued & fully-paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| at opening balance sheet date (000s) |
|
->> |
500.0 |
<<- |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| Tax
& Dividends |
|
Years: |
2005 |
2006 |
2007 |
|
|
|
|
|
| Effective
federal/state tax rate for each year (%) |
->> |
7.0 |
7.0 |
8.0 |
<<- |
Enter tax payments relating to
periods prior to start date of projections in sheet M_B |
|
Total |
Total |
Total |
|
| Federal/state
tax payments ($000) |
|
->> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
X = 0 to 4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
Total |
Total |
|
| Dividends
for each year ($000) |
1 |
|
<<->> |
|
|
300.0 |
|
|
300.0 |
|
| * Set row to zeros for Ltd Co |
|
->> |
|
|
|
|
|
| * Set row to zeros for Ltd Co |
|
->> |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
