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 |