12 CFR Appendix E to Part 1024, Arithmetic Steps

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

This is a list of United States Code sections, Statutes at Large, Public Laws, and Presidential Documents, which provide rulemaking authority for this CFR Part.

This list is taken from the Parallel Table of Authorities and Rules provided by GPO [Government Printing Office].

It is not guaranteed to be accurate or up-to-date, though we do refresh the database weekly. More limitations on accuracy are described at the GPO site.


United States Code