{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Borrower:","                     Texas Home Equity 2% Cap Fee Test"]
[null,null,null,null,"Section B or Section C, depending on shopping"]
[null,"Loan Number:",null,null,"Title - Closing/Escrow Fee",0,null,"2% Fee Cap",{"$f":"B6*0.02","v":0}]
[null,null,null,null,"Title - Doc Prep Fees",0,null,"Total Includable Fees",{"$f":"SUM(F27:F29,F20,F3:F17,C22:C27,C13:C19)","v":0}]
[null,"Loan Amount:",null,null,"Title - Notary Fee",0]
[null,null,null,null,"Title - Courier Fee",0,null,"Over the 2% cap?",{"$f":"IF(I3<I4,\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,"Title - Tax Cert",0,null,"If YES, by how much?",{"$f":"IF(I3<I4,I4-I3,\"n/a\")","v":"n/a"}]
[null,null,null,null,"Title - Guaranty Fee",0]
[null,null,null,null,"Title - E-Recording Fee",0]
[null,null,null,null,"Title - Wire Fee",0]
[null,"Section A, Origination Charges",null,null,"Title - Download Fee",0]
[null,"Points","Exclude",null,"Title - Copy/Phone/Fax Fee",0]
[null,"Origination Fee",0,null,"Title - Lender's Title Insurance","Exclude"]
[null,"Processing Fee",0,null,"Title - Endorsements","Exclude"]
[null,"Underwriting Fee",0,null,"Survey Fee","Exclude"]
[null,"Administration Fee",0,null,"Other",0]
[null,"Escrow Waiver Fee",0,null,"Other",0]
[null,"Other",0]
[null,"Other",0,null,"Section E - Recording Fees"]
[null,null,null,null,"Recording Fees",0]
[null,"Section B, Services The Borrower Did Not Shop For"]
[null,"Credit Report Fee",0,null,"Section F - Prepaids","Exclude"]
[null,"Inspection Fee",0]
[null,"Flood Certification Fee",0,null,"Section G - Initial Escrow Payment at Closing","Exclude"]
[null,"Tax Service Fee",0]
[null,"Appraisal Mgmt. Co. Fee",0,null,"Section H - Other"]
[null,"Texas Doc Prep Legal Review",0,null,"HOA Fees",0]
[null,"Title Search Fee","Exclude",null,"Misc. Doc Prep",0]
[null,"Appraisal Fee","Exclude",null,"Other",0]