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