Forum List · Active Topics · Rules · Mark all Read · Help BankersOnline.com » Forums » Dodd-Frank Final Rules Discussions » TRID - TILA/RESPA Integrated Disclosures Rule » Cash to Close Table- Loan Amount Exceeds Purchase
 Topic Options
 #2199934 - 12/05/18 10:21 PM Cash to Close Table- Loan Amount Exceeds Purchase Katherine Junior Member Registered: 08/02/17 Posts: 42 Seriously in need of formula validation for the Calculating Cash to Close Table under 1026.37(h)(1)(v) for purchases when loan amount exceeds purchase price. If someone who has figured this out can reach out I'd appreciate it. We have bridge loans and I thought I had the relevant calculations in an Excel sheet (because system can't handle a loan amount exceeds purchase price scenario), but now I'm unsure and would appreciate being able to email someone.Background: Commentary to 1026.37(h)(1)(iii)-2 provides in short that when loan amount exceeds purchase price the amount of funds from customer is determined under 1026.37(h)(1)(v) [Funds for Borrower]Part of the issue, but not all of it, is the Funds for Borrower section includes some confusing language regarding the calculation of the Total Amount of Existing Debt being Satisfied - the only way I can make the formula work is if I treat the language that says "excluding and closing costs financed disclosed under 1026.37(h)(1)(ii)" as a double negative since 1026.37(h)(1)(ii) in a typical scenario is a negative number: Total Amount of Existing Debt Being Satisfied = (Sales price + Tangible Personal Property excluded from sales price (if any) + Payoffs/Construction Costs in Section K) Minus (Loan Amount - (Closing Costs Financed Disclosed as a Negative)) The Funds for Borrower Calculation appears to be: Total Amt of Existing Debt Satisfied = Sales Price + Personal Property (if any) + Payoffs;Constuction Costs;Other Costs Minus,Loan Amount + Assumptions (if any) excluding any closing costs financed disclosed under 1026.37(h)(1)(ii).--[/b][b][/b][b] Edited by Katherine (12/06/18 03:39 AM) Top
 TRID - TILA/RESPA Integrated Disclosures Rule

 Hop To: Special Instructions ------   Instructions for Accessing PRIVATE ForumsDodd-Frank Final Rules Discussions ------   Ability to Repay/Qualified Mortgage Rule   Escrows on Higher-Priced Mortgages   HOEPA and Homeowner Counseling Rule   HMDA Overhaul 2018   Interagency (Reg Z) and CFPB Reg B Appraisal Rules   Loan Originator Compensation Rule   Mortgage Servicing Rules    Remittance Transfer Rule   TRID - TILA/RESPA Integrated Disclosures Rule Banker Forums ------   Comments on Proposed Regulations   Article 9   Audit   BSA/AML/CIP/OFAC Forum   CRA   Deposits and Payments   Disaster Recovery   eBanking / Technology   Fair Lending   FCRA   Financial Reform   Flood Compliance   General Discussion   HMDA   Human Resources   Lending Compliance   Lending to Servicemembers (SCRA, JWNDAA), War, Terrorism   Marketing   Need to Remain Anonymous   Newbie Nook   Operations Compliance   Regulatory Rollback Forum   RESPA   Risk Management   S.A.F.E. Act Forum   Security - PUBLICState-Specific Compliance Issues ------   Other States - General   Puerto Rico   Arkansas   California    Colorado   Connecticut   Florida   Georgia   Illinois   Indiana   Iowa   Kentucky   Louisiana   Maryland   Massachusetts   Michigan   Minnesota   New Hampshire   New Jersey   New Mexico   New York   North Carolina   Ohio   Oklahoma   Pennsylvania   South Carolina   Tennessee   Texas   Virginia   Washington State   Washington, DC   Wisconsin   WyomingNon-Business Discussions ------   Chat! - BOL Watercooler   The BOL Couch