Home  |  Contact Us  |  About Us

How to Order  |  Survey  |  Support


Order online or call (480) 460-9311
Quick Activation! Priority Mail Shipping....

 

Home > Free > Info > HowTo

How to calculate the Escrow Adjustment by Hand
FREE Information


The following steps and example to help you estimate the amount of money you may be required to put into your own escrow account, either a new or existing account, under aggregate accounting:

  1. Determine the first payment date.  The first payment date is usually 2-months after the closing date.  Write the first payment date down on paper.  For our purposes, let's assume the first payment date is in June.
     
  2. List all the payment amounts for items that will be paid out of your escrow account, and when paid, for the next 12 months.  Consider the example where city taxes of $1,557.48 is due in September and $1,557.48 is due in March; and $807 in hazard insurance is paid in March.  [If you have a payment like flood insurance, which is paid every 3 years, you must project a trial balance over that 3-year period.]
     
  3. Divide this total amount by 12 monthly payments ($3,921.96 / 12 = 326.83).
     
  4. Create a trial running balance for the next 12 months listing all payments to the escrow account and all payments out of the account, when these items are paid.
     
  5. Increase all the monthly balances to bring the lowest point in the account (March -$653.66) up to 0.
     
                                             In        Out     Balance Balance
    June   326.83 0 326.83 980.49
    July   326.83 0 653.66 1307.32
    August   326.83 0 980.49 1634.15
    September   326.83 1557.48 -250.16 403.50
    October   326.83 0 76.67 730.33
    November   326.83 0 403.50 1057.16
    December   326.83 0 730.33 1383.99
    January   326.83 0 1057.16 1710.82
    February   326.83 0 1383.99 2037.65
    March   326.83 2364.48 *-653.66 *0
    April   326.83 0 -326.83 326.83
    May   326.83 0 0 653.66

     

  6. Add any cushion your lender requires to the monthly balances. The cushion may be a maximum of 1/6 of the total escrow charges or 2 * 326.83 = $653.66.  The account should fall to the cushion at least once during the year.  In our example, it is in March.
     
  7. The initial payment is the amount the lender is allowed to collect at closing to established the escrow account.  It is the sum of the low point plus the cushion amount.  For our example, $1,307.32 is the initial payment.
     
  8. The aggregate escrow adjustment is the difference between the deposit required under aggregate accounting and the sum of the deposits required under single-item accounting.  We just calculated the deposit of $1,307.32 which is required under aggregate accounting.  Looking at our HUD-1 Settlement Statement, we see the following reserves deposited with the lender at closing:

Hazard Insurance   5 x $67.25  =    336.25
City Tax               4 x $259.58 = 1,038.32

For a total of $1,374.57 under single item analysis.

Aggregate Escrow Adjustment is -67.25 or $1,307.32 - 1,374.57.

By law, the lender is not allowed to collect more than the initial payment.  The aggregate adjustment (line 1008 of the settlement statement) is the amount the lender must 'credit' the borrower at closing, so that they don't collect more than the initial payment amount.

Please do not hesitate to send us an e-mail (info@ruthtechnology.com) if you have questions, comments or if you come across something that would contribute to this section.

 Copyright © 1999-2007 Ruth Technology Corporation
 All rights reserved.