Make rows on a spreadsheet for each of the first 12 months, starting with the month the first payment is due.
In a separate column, list all payment amounts that will be paid out of the escrow account in the months they are due.
Divide the total amount of payments from Step 2 by 12.
Enter the figure from Step 3 in another column for each month as the tentative amount that will be paid into escrow monthly.
Calculate the initial balance for each month. The initial balance is the initial balance from the preceding month (zero for the first month) plus the escrow deposit minus the month’s payments.
Find the amount of additional funds that would be needed to bring the lowest initial balance up to zero.
Determine the “cushion,” or lowest positive balance, that the lender requires for the account. Under federal rules, this cannot be more than one sixth of the total payments in Step 2, except that mortgage insurance paid monthly cannot be included in the total payments for this purpose.
Compute the initial escrow payment under aggregate adjustment rules by adding together the amounts from Steps 6 and 7.
Subtract the amount from Step 8 from the sum of the escrow amounts using single-item accounting on Lines 1001 through 1006 of the HUD-1.
Enter the amount from Step 9 as a credit, or negative amount, on Line 1007, Aggregate Adjustment. However, if the calculation from Step 9 results in a negative number or zero, enter zero on Line 1007.