| 12 Months |
|
|
|
|
Opening |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
|
2004 |
| to end Dec |
|
|
|
|
Values |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
Year |
| ASSUMPTIONS
No. 6 - RECEIVABLES, PAYABLES & PHASING OF OPENING BALANCES |
|
|
|
|
| |
|
|
| |
|
|
| Table
1 - Phasing Out of Opening Balance Sheet Items * |
|
|
| |
|
|
|
|
Opening values must be entered via
opening balance sheet before the table below can be completed |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
| Accounts
receivable ($000) |
->> |
|
285.0 |
135.0 |
100.0 |
50.0 |
|
|
|
285.0 |
| Accounts
payable ($000) |
->> |
|
210.0 |
95.0 |
75.0 |
40.0 |
|
|
|
210.0 |
| Capital
expend. creditors ($000) |
->> |
|
45.0 |
|
45.0 |
|
|
|
45.0 |
| Payroll
taxes/benefits payable ($000) |
->> |
|
25.0 |
25.0 |
|
|
|
25.0 |
| Interest
payable ($000) |
->> |
|
|
|
|
|
|
| Taxes
due ($000) |
->> |
|
|
|
|
|
|
| Dividends
due ($000) |
->> |
|
|
|
|
|
|
| |
|
|
|
|
*12-month total
for each item must equal opening value in first column, otherwise ERR is
indicated in Column B - Press F9 to check |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
| Table
2 - Credit Distributions for Payables & Receivables for Current Year * |
|
|
|
| |
|
|
| |
|
|
|
|
Months of
credit given/taken: |
|
Total* |
|
|
| |
|
|
|
|
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
|
|
|
| - Group3 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group4 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group5 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group6 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group7 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group8 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group9 |
->> |
|
20.0 |
50.0 |
15.0 |
10.0 |
5.0 |
|
100.0
|
|
|
| - Group10 |
->> |
|
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
|
|
|
| - Group3 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group4 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group5 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group6 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group7 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group8 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group9 |
->> |
|
15.0 |
65.0 |
10.0 |
5.0 |
5.0 |
|
100.0
|
|
|
| - Group10 |
->> |
|
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: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|