{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["WME Broker SFS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"WME Broker SFS","index":0,"n_rows":67,"n_cols":31,"rows_kept":67,"cut":false,"hidden":false,"merged":[[3,2,3,30],[6,1,6,31],[47,29,47,30],[48,18,48,28],[49,18,49,28],[48,3,48,13],[26,2,26,15],[39,14,39,15],[8,17,8,20],[8,27,8,30],[9,27,9,30],[8,22,8,25],[9,22,9,25],[8,9,8,10],[9,9,9,10],[41,3,41,13],[13,22,13,25],[23,23,23,25],[18,23,18,25],[19,23,19,25],[9,2,9,7],[12,6,12,8],[15,12,15,13],[11,2,11,4],[11,6,11,8],[12,2,12,4],[38,3,38,13],[40,3,40,13],[28,2,28,30],[40,18,40,28],[35,18,35,28],[36,18,36,28],[37,18,37,28],[38,18,38,28],[39,26,39,27],[33,18,33,28],[34,18,34,28],[26,17,26,30],[11,27,11,30],[9,12,9,13],[8,12,8,13],[56,18,56,28],[45,18,45,28],[46,18,46,28],[12,22,12,25],[12,27,12,30],[11,17,12,21],[47,3,47,13],[46,3,46,13],[41,26,41,27],[42,18,42,28],[45,3,45,13],[9,17,9,20],[13,27,13,30],[11,22,11,25],[65,6,65,12],[42,3,42,13],[43,3,43,13],[44,3,44,13],[61,15,61,30],[62,15,67,30],[50,18,50,28],[51,18,51,28],[52,18,52,28],[53,18,53,28],[54,18,54,28],[66,6,66,12],[0,20,0,30],[63,6,63,12],[64,6,64,12],[37,3,37,13],[49,3,49,13],[33,3,33,13],[1,14,1,15],[20,23,20,25],[34,3,34,13],[19,19,19,21],[20,19,20,21],[21,11,21,12],[21,15,21,17],[57,18,57,28],[55,18,55,28],[8,2,8,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WME Broker Submission Fee Sheet"]
[]
[]
[null,null,{"$f":"IF(C9=\"\",\"Enter Borrower's Last Name\",IF(J9=\"\",\"Enter Axos Bank Loan Number\",IF(M9=\"\",\"Enter Subject Property's Abbreviated State\",IF(P9=\"\",\"Enter Interest Rate\",IF(R9=\"\",\"Select answer from 'Is Loan Locked' field\",IF(W9=\"\",\"Select Loan Type\",IF(AB9=\"\",\"Choose COMP selection below\",IF(AND(AB9=\"Borrower-Paid Comp\",W9=\"VA\"),\"STOP!  VA loans cannot be submitted as Borrower-Paid Comp.  Verify/correct the Loan Type or choose Lender-Paid Comp.\",IF(C12=\"\",\"Enter Base Loan Amount\",IF(AND(G12=\"\",OR(W9=\"FHA\",W9=\"VA\")),\"Enter Total Loan Amount\",IF(G12<C12,\"Review Base Loan Amount and Total Loan Amount.  Total Loan Amount should not be less than the Base Loan Amount.\",IF(AND(W9=\"Conventional\",P12=\"\"),\"Select answer for 'Escrows/Impounds' below\",IF(AND(W9=\"VA\",OR(W12=\"\",AB12=\"\")),\"Answer both VA questions (funding fee option and type of veteran)\",IF(OR(G64=\"\",G65=\"\",G66=\"\",G67=\"\"),\"Complete the 'Contact Information' section at the bottom of this page\",IF(W9=\"VA\",\"If VA refi, upload VA IRRRL Cert.  Enter fees below, PDF this completed Broker Submission Fee Sheet, and upload to the 'Submission Fee Sheets' condition in the B2B site prior to loan submission.\",\"Enter fees below, PDF this completed Broker Submission Fee Sheet, and upload to the 'Submission Fee Sheets' condition in the B2B site prior to loan submission.\")))))))))))))))","v":"Enter Borrower's Last Name"}]
[]
[]
[null,"LOAN INFORMATION"]
[]
[]
[null,null,"Borrower Last Name",null,null,null,null,null,null,"Loan #",null,null,"Subj State",null,null,"Rate",null,"Is Loan Locked?",null,null,null,null,"Loan Type",null,null,null,null,"Comp Selection (choose one)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Escrows/Impounds?",null,null,null,null,null,"Answer these 2 questions only on VA loans: "]
[null,null,"Base Loan Amt",null,null,null,"Total Loan Amt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funding Fee Option",null,null,null,null,"Type of Veteran (choose one)"]
[]
[]
[null,null,"BCP & VA?",null,{"$f":"IF(AND(AB9=\"Borrower-Paid Comp\",W9=\"VA\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W9=\"Conventional\",C12*X19,IF(OR(W9=\"FHA\",W9=\"VA\"),G12*X19,\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PRICING EXPECTED ON THE LOAN (not your lender paid compensation figure)"]
[null,null,null,null,null,null,null,null,null,null,null,"Enter total expected pricing on the loan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Credit/rebate to borrower (above par):  ",{"$f":"IF(P16<0,P16,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount fee charged to borrower (below par):  ",{"$f":"IF(P16<=0,\"\",P16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"Credit/rebate to borrower\",\"\",\"Discount fee charged to borrower\")","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"IF(T20<0,\"Credit/rebate to borrower\",IF(X19=0,\"Par Pricing\",\"Discount fee charged to borrower\"))","v":"Par Pricing"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T20<0,\"Credit/rebate to borrower  \",IF(X19=0,\"Par Pricing  \",\"Discount fee charged to borrower  \"))","v":"Par Pricing  "},{"$f":"MAX(T20:V21)","v":0}]
[]
[]
[null,null,"LENDER-PAID COMP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BORROWER-PAID COMP"]
[]
[null,null,"** Indicate fees paid by:  S=Seller, L=Lender, B=Broker (if paying for specific fees versus flat credit amt), or leave blank if charged to BORROWER."]
[]
[null,null,"A.","ORIGINATION CHARGES",null,null,null,null,null,null,null,null,null,null,"**","Amount",null,"A.","ORIGINATION CHARGES",null,null,null,null,null,null,null,null,null,null,"**","Amount"]
[null,null,null,"All Inclusive Lender Fee (Axos Bank)",null,null,null,null,null,null,null,null,null,"(required) ",null,815,null,null,"All Inclusive Lender Fee (Axos Bank)",null,null,null,null,null,null,null,null,null,null,null,815]
[null,null,null,"Loan Discount Fee (only a charge to borrower is disclosed here)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":""},null,null,"Loan Discount Fee (only a charge to borrower is disclosed here)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":""}]
[null,null,null,"Foreign National Due Dil Fee, if applicable (Axos Bank) - $250",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foreign National Due Dil Fee, if applicable (Axos Bank) - $250"]
[null,null,null,"Privacy Mortgage Fee (Axos Bank) - $350",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Privacy Mortgage Fee (Axos Bank) - $350"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," SUB-TOTAL (for Section A)  ",{"$f":"SUM(P32:P35)","v":815},null,null,"Broker Admin Fee"]
[null,null,"B.","SERVICES YOU CANNOT SHOP FOR",null,null,null,null,null,null,null,null,null,null,"**","Amount",null,null,"Broker Application Fee"]
[null,null,null,"Appraisal Fee # 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broker Processing Fee"]
[null,null,null,"Appraisal Fee # 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Broker Origination Fee (as flat fee amount)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the subject a unique or complex property? (select one)  ",null,null,null,null,"* Broker Origination Fee (as percentage)",null,null,null,null,null,null,null,null,null,"%",null,{"$f":"IF(W9=\"Conventional\",C12*AA40%,IF(W9=\"FHA\",G12*AA40%,\"\"))","v":""}]
[null,null,null,"Appraisal Re-inspection (1004D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"** Mortgage Broker Fee (as flat fee amount)"]
[null,null,null,"Broker Credit Report Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"** Mortgage Broker Fee (as percentage)",null,null,null,null,null,null,null,null,null,"%",null,{"$f":"IF(W9=\"Conventional\",C12*AA42%,IF(W9=\"FHA\",G12*AA42%,\"\"))","v":""}]
[null,null,null,"Broker Flood Verif Fee"]
[null,null,null,"Broker Tax Service Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," SUB-TOTAL (for Section A)  ",{"$f":"SUM(AE32:AE43)","v":815}]
[null,null,null,"Third Party Processing Fee (must provide invoice)",null,null,null,null,null,null,null,null,null,null,null,null,null,"B.","SERVICES YOU CANNOT SHOP FOR",null,null,null,null,null,null,null,null,null,null,"**","Amount"]
[null,null,null,"HOA Cert Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraisal Fee # 1"]
[null,null,null,"Single Premium Mortgage Insurance (SPMI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraisal Fee # 2"]
[null,null,null,"Subordination Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the subject a unique or complex property? (select one)  "]
[null,null,null,"Texas Attorney Review Fee (Axos Bank) - $150",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraisal Re-inspection (1004D)"]
[null,null,null,"Trust/LLC Review Fee (Axos Bank) - $300",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broker Credit Report Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," SUB-TOTAL (for Section B)  ",{"$f":"SUM(P38:P50)","v":0},null,null,"Broker Flood Verif Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broker Tax Service Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Third Party Processing Fee (must provide invoice)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOA Cert Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Premium Mortgage Insurance (SPMI)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subordination Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas Attorney Review Fee (Axos Bank) - $150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trust/LLC Review Fee (Axos Bank) - $300"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," SUB-TOTAL (for Section B)  ",{"$f":"SUM(AE46:AE58)","v":0}]
[]
[]
[null,null,"CONTACT INFORMATION:",null,null,null,null,null,null,null,null,null,null,null,null,"SPECIAL NOTES TO AXOS BANK:"]
[null,null,"  This form was completed by:"]
[null,null,"  Company Name:"]
[null,null,"  Contact Name:"]
[null,null,"  Phone Number:"]
[null,null,"  Email Address:"]