| 12 Months |
|
|
|
|
Opening |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
2006 |
|
05-06 |
| to end Jan |
|
|
|
|
Values |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Jan |
|
Year |
| MONTHLY
ASSUMPTIONS No. 7 - OPENING BALANCE SHEET ITEMS, RECEIVABLES & PAYABLES |
|
|
| |
|
|
|
|
| |
|
|
| Phasing out of opening |
|
|
|
|
Opening values entered via opening
balance sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| balance sheet items* |
|
|
|
|
*12 month total
for each item must equal opening value in first column, otherwise ERR is
indicated in Column B - Press F9 to check |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Accounts
receivable ($000) |
->> |
|
57.0 |
27.0 |
20.0 |
10.0 |
|
|
|
57.0 |
| Accounts
payable ($000) |
->> |
|
30.0 |
15.0 |
10.0 |
5.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 for current year* |
|
|
|
Under 1 |
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
% |
|
|
| Accounts
payable for material/packaging & goods (%
distribution *): |
|
|
|
|
|
|
|
|
|
| - Group1 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group2 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| Accounts
receivable (% distribution *): |
|
|
|
|
|
|
|
|
|
|
| - Group1 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group2 |
->> |
|
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: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|