The aggregate adjustment is a mathematical process that lenders use to determine how much must be deposited in escrow by the borrower. In 1997, the Department of Housing and Urban Development outlined rules that prohibit lenders from collecting more than two months' cushion in escrow; however, depending on when property taxes and hazard insurance is paid, the amount that's deposited may exceed the two month cushion. To calculate the total, you'll need to know when your insurance and property tax bills are due.
Prepare and Escrow Calculation Worksheet
Start by making the calculation trial balance table. The first column should be headed "months" and the first entry in the column should be the month that your loan closes. The first payment is due the month following the close. The next columns should be labeled "deposits" and "payments", respectively. The last column should be labeled "total."
Populate the Escrow Analysis Worksheet
Begin making entries. In the first column, list the 12 months following the closing month, in order. In the second column, next to each month, write the amount of your monthly escrow payment. For example, if your annual property taxes are $2,000 and your insurance is $400, your annual tax and insurance payments total $2,400. The monthly escrow payments are $200, because $2,400 divided by 12 months is $200. Therefore, in this example, each entry in the "deposit" column should read $200.
Write the tax and insurance payments in the appropriate months. Hazard insurance is paid out of escrow once per year, while property taxes are usually paid twice per year. The lender will pay these bills on the borrower's behalf, regardless of the escrow account balance.
Calculate Trial Balances
Calculate the initial trial balance. The month of the close, the balance should equal the escrow cushion, which may equal as much as two months' escrow payments (in our example, this total is $400, which is $200 times 2 months). No, calculate the subsequent trial balances. Beginning with the month following the close, add the first escrow payment to the trial balance, continuing until the first insurance or tax payment appears. When this occurs, add in the monthly escrow payment and then subtract from the new trial balance the amount of the payment made. Repeat this process for all 12 months.
Analyze the Results
Analyze the chart. The low balance is the amount that must be brought to close in addition to the two-month cushion. Be patient here, and if you get frustrated, remember that the bank attorney will be happy to provide an accounting of how the escrow aggregate adjustment was calculated. You can also use an online calculator if you need help but don't want to engage in multiple mathematical operations.
- Standard Solutions: Aggregate Escrow Calculations
- Cornell Law School. "Escrow." Accessed March 15, 2020.
- Los Angeles County Consumer and Business Affairs. "Escrow." Accessed March 15, 2020.
- Consumer Financial Protection Bureau. "What Is an Escrow or Impound Account?" Accessed March 15, 2020.
- The People's Law Library of Maryland. "Rent Escrow: When the Landlord Fails to Make Repairs." Accessed March 15, 2020.
- California Department of Business Oversight. "Online Escrow Fraud Questions and Answers." Accessed March 15, 2020.
- Consumer Financial Protection Bureau. "Mortgages Key Terms." Accessed March 15, 2020.
- FindLaw. "Connecticut Security Deposit Laws." Accessed March 15, 2020.
- Be patient, and if you get frustrated, remember that the bank attorney will be happy to provide an accounting of how the escrow adjustment was calculated. You can also use an online calculator if you need help but don't want to engage in multiple mathematical operations.
Lisa Bigelow is an independent writer with prior professional experience in the finance and fitness industries. She also writes a well-regarded political commentary column published in Fairfield, New Haven and Westchester counties in the New York City metro area.