Escrow Analysis
Updated 01/31/17
From David Dickinson and Banker's Compliance Consulting, there are now two versions of this Excel spreadsheet which calculates escrow deposits. Version 3.0 calculates escrow deposits as defined in Section 1024.17. It also tells you the amounts to disclose on the closing documents. Version 2.0 is for applications prior to October 3, 2015. It follows RESPA Section 3500.17 and the HUD-1/1A. Both are Excel documents.