I. Example
Illustrating Aggregate Analysis Assumptions
Disbursements:
$360 for school taxes disbursed on
$1,200 for county property taxes:
$500 disbursed on July 25
$700 disbursed on December 10
Cushion: One-sixth of estimated annual
Settlement:
May 15
First Payment: July 1
Example Illustrating
Aggregate Analysis
Aggregate |
|
Pmt. |
Disb. |
Bal. |
Step 1—Initial Trial Balance |
June
|
0 |
0 |
0 |
July
|
130 |
500 |
−370 |
August
|
130 |
0 |
−240 |
September
|
130 |
360 |
−470 |
October
|
130 |
0 |
−340 |
November
|
130 |
0 |
−210 |
December
|
130 |
700 |
−780 |
January
|
130 |
0 |
−650 |
February
|
130 |
0 |
−520 |
March
|
130 |
0 |
−390 |
April
|
130 |
0 |
−260 |
May
|
130 |
0 |
−130 |
June
|
130 |
0 |
0 |
Step
2—Adjusted Trial Balance (Increase monthly balances to
eliminate negative balances) |
|
June
|
0 |
0 |
780 |
July
|
130 |
500 |
410 |
August
|
130 |
0 |
540 |
September
|
130 |
360 |
310 |
October
|
130 |
0 |
440 |
November
|
130 |
0 |
570 |
December
|
130 |
700 |
0 |
January
|
130 |
0 |
130 |
February
|
130 |
0 |
260 |
March
|
130 |
0 |
390 |
April
|
130 |
0 |
520 |
May
|
130 |
0 |
650 |
June
|
130 |
0 |
780 |
Step 3—Trial Balance with Cushion |
June
|
0 |
0 |
1040 |
July
|
130 |
500 |
670 |
August
|
130 |
0 |
800 |
September
|
130 |
360 |
570 |
October
|
130 |
0 |
700 |
November
|
130 |
0 |
830 |
December
|
130 |
700 |
260 |
January
|
130 |
0 |
390 |
February
|
130 |
0 |
520 |
March
|
130 |
0 |
650 |
April
|
130 |
0 |
780 |
May
|
130 |
0 |
910 |
June
|
130 |
0 |
1040 |
II. Example
Illustrating Single-item Analysis Assumptions Disbursements:
$360 for school taxes disbursed on
$1,200 for county property taxes:
$500 disbursed on July 25
$700 disbursed on December 10
Cushion: One-sixth of estimated annual disbursements
Settlement: May 15
First Payment:
July 1
Example Illustrating
Single-item Analysis
|
Single-item |
|
Taxes |
School taxes |
|
Pmt. |
Disb. |
Bal. |
Pmt. |
Disb. |
Bal. |
Step 1— Initial Trial Balance |
June |
0 |
0 |
0 |
0 |
0 |
0 |
July |
100 |
500 |
−400 |
30 |
0 |
30 |
August |
100 |
0 |
−300 |
30 |
0 |
60 |
September |
100 |
0 |
−200 |
30 |
360 |
−270 |
October |
100 |
0 |
−100 |
30 |
0 |
−240 |
November |
100 |
0 |
0 |
30 |
0 |
−210 |
December |
100 |
700 |
−600 |
30 |
0 |
−180 |
January |
100 |
0 |
−500 |
30 |
0 |
−150 |
February |
100 |
0 |
−400 |
30 |
0 |
−120 |
March |
100 |
0 |
−300 |
30 |
0 |
−90 |
April |
100 |
0 |
−200 |
30 |
0 |
−60 |
May |
100 |
0 |
−100 |
30 |
0 |
−30 |
June |
100 |
0 |
0 |
30 |
0 |
0 |
Step 2—Adjusted Trial Balance (Increase Monthly Balances
to Eliminate Negative Balances) |
June |
0 |
0 |
600 |
0 |
0 |
270 |
July |
100 |
500 |
200 |
30 |
0 |
300 |
August |
100 |
0 |
300 |
30 |
0 |
330 |
September |
100 |
0 |
400 |
30 |
360 |
0 |
October |
100 |
0 |
500 |
30 |
0 |
30 |
November |
100 |
0 |
600 |
30 |
0 |
60 |
December |
100 |
700 |
0 |
30 |
0 |
90 |
January |
100 |
0 |
100 |
30 |
0 |
120 |
February |
100 |
0 |
200 |
30 |
0 |
150 |
March |
100 |
0 |
300 |
30 |
0 |
180 |
April |
100 |
0 |
400 |
30 |
0 |
210 |
May |
100 |
0 |
500 |
30 |
0 |
240 |
June |
100 |
0 |
600 |
30 |
0 |
270 |
Step 3—Trial Balance with Cushion |
June |
0 |
0 |
800 |
0 |
0 |
330 |
July |
100 |
500 |
400 |
30 |
0 |
360 |
August |
100 |
0 |
500 |
30 |
0 |
390 |
September |
100 |
0 |
600 |
30 |
360 |
60 |
October |
100 |
0 |
700 |
30 |
0 |
90 |
November |
100 |
0 |
800 |
30 |
0 |
120 |
December |
100 |
700 |
200 |
30 |
0 |
150 |
January |
100 |
0 |
300 |
30 |
0 |
180 |
February |
100 |
0 |
400 |
30 |
0 |
210 |
March |
100 |
0 |
500 |
30 |
0 |
240 |
April |
100 |
0 |
600 |
30 |
0 |
270 |
May |
100 |
0 |
700 |
30 |
0 |
300 |
June |
100 |
0 |
800 |
30 |
0 |
330 |