12 CFR Part 1024, Appendix E to Part 1024 - Arithmetic Steps

View PDF at GPO Pt. 1024, App. E
Appendix E to Part 1024—Arithmetic Steps
I. Example Illustrating Aggregate Analysis
Assumptions
Disbursements:
$360 for school taxes disbursed on September 20
$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
Step 1—Initial Trial Balance
Aggregate
pmt disb bal
Jun 0 0 0
Jul 130 500 −370
Aug 130 0 −240
Sep 130 360 −470
Oct 130 0 −340
Nov 130 0 −210
Dec 130 700 −780
Jan 130 0 −650
Feb 130 0 −520
Mar 130 0 −390
Apr 130 0 −260
May 130 0 −130
Jun 130 0 0
Step 2—Adjusted Trial Balance
[Increase monthly balances to eliminate negative balances]
Aggregate
pmt disb bal
Jun 0 0 780
Jul 130 500 410
Aug 130 0 540
Sep 130 360 310
Oct 130 0 440
Nov 130 0 570
Dec 130 700 0
Jan 130 0 130
Feb 130 0 260
Mar 130 0 390
Apr 130 0 520
May 130 0 650
Jun 130 0 780
Step 3—Trial Balance With Cushion
Aggregate
pmt disb bal
Jun 0 0 1040
Jul 130 500 670
Aug 130 0 800
Sep 130 360 570
Oct 130 0 700
Nov 130 0 830
Dec 130 700 260
Jan 130 0 390
Feb 130 0 520
Mar 130 0 650
Apr 130 0 780
May 130 0 910
Jun 130 0 1040
II. Example Illustrating Single-Item Analysis
Assumptions
Disbursements:
$360 for school taxes disbursed on September 20
$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
Step 1—Initial Trial Balance
Single-item
Taxes School taxes
pmt disb bal pmt disb bal
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]
Single-item
Taxes School taxes
pmt disb bal pmt disb bal
Jun 0 0 600 0 0 270
Jul 100 500 200 30 0 300
Aug 100 0 300 30 0 330
Sep 100 0 400 30 360 0
Oct 100 0 500 30 0 30
Nov 100 0 600 30 0 60
Dec 100 700 0 30 0 90
Jan 100 0 100 30 0 120
Feb 100 0 200 30 0 150
Mar 100 0 300 30 0 180
Apr 100 0 400 30 0 210
May 100 0 500 30 0 240
Jun 100 0 600 30 0 270
Step 3—Trial Balance With Cushion
Single-item
Taxes School taxes
pmt disb bal pmt disb bal
Jun 0 0 800 0 0 330
Jul 100 500 400 30 0 360
Aug 100 0 500 30 0 390
Sep 100 0 600 30 360 60
Oct 100 0 700 30 0 90
Nov 100 0 800 30 0 120
Dec 100 700 200 30 0 150
Jan 100 0 300 30 0 180
Feb 100 0 400 30 0 210
Mar 100 0 500 30 0 240
Apr 100 0 600 30 0 270
May 100 0 700 30 0 300
Jun 100 0 800 30 0 330

Title 12 published on 2014-01-01

no entries appear in the Federal Register after this date.