| 6 Months |
|
|
|
|
Opening |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
|
2005 |
| to end Jul |
|
|
|
|
Values |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
|
6-Mths |
| MONTHLY
ASSUMPTIONS No. 7 - OPENING BALANCE SHEET ITEMS, RECEIVABLES & PAYABLES |
| |
|
|
|
|
| |
|
|
| Phasing out of opening |
|
|
|
|
Opening values below entered via
opening balance sheet |
|
|
|
|
|
|
|
|
| balance sheet items* |
|
|
|
|
*Six-month totals
for each item must equal opening value |
|
|
|
|
|
|
|
Total |
| Accounts
receivable ($000) |
->> |
|
35.0 |
20.0 |
10.0 |
5.0 |
|
|
35.0 |
| Accounts
payable ($000) |
->> |
|
30.0 |
15.0 |
7.0 |
5.0 |
3.0 |
|
|
30.0 |
| Capital
expend. creditors ($000) |
->> |
|
9.0 |
|
9.0 |
|
|
9.0 |
| Payroll
taxes/benefits payable ($000) |
->> |
|
5.0 |
5.0 |
|
|
5.0 |
| Taxes
due ($000) |
->> |
|
|
|
|
|
| Dividends
due ($000) |
->> |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Collection
patterns for payables |
|
|
|
Months of
credit given/taken: |
|
Total |
|
|
| & receivables (during the 6 months)* |
|
|
|
Under 1 |
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
% |
|
|
| Accounts payable
for material/packaging & goods |
|
|
|
|
|
|
|
|
|
| (% distribution *) |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| Accounts receivable |
|
|
|
|
|
|
|
|
|
|
| (% distribution *) |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| *Total for each row must equal 100%,
otherwise an ERROR is indicated - Press F9 to check |
|
100.0 |
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|