Skip Header

Federal Deposit
Insurance Corporation

Each depositor insured to at least $250,000 per insured bank

FDIC Law, Regulations, Related Acts

[Table of Contents] [Previous Page] [Next Page] [Search]

6500 - Consumer Financial Protection Bureau


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

Single-item
Taxes School taxes
pmt disb bal pmt disb bal
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

[Codified to 12 C.F.R. Part 1024, Appendix E]


[Table of Contents] [Previous Page] [Next Page] [Search]