{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NanQ ONE Program","Feed","Cover Page","Sheet1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":6,"defined_names":67,"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":"NanQ ONE Program","index":0,"n_rows":53,"n_cols":32,"rows_kept":53,"cut":false,"hidden":false,"merged":[[47,10,47,12],[50,14,50,16],[20,6,20,7],[2,14,2,16],[35,18,35,20],[35,21,35,25],[7,22,7,25],[20,22,20,25],[25,24,25,25],[26,22,26,25],[36,18,36,20],[20,18,20,19],[22,22,23,25],[22,14,22,16],[45,14,45,15],[41,18,49,25],[29,22,29,25],[36,21,36,25],[34,14,34,16],[35,14,35,15],[36,14,36,15],[38,14,38,15],[39,14,39,15],[30,22,30,25],[27,18,27,20],[28,18,28,20],[30,14,30,15],[31,14,31,15],[32,14,32,15],[29,14,29,15],[24,18,24,19],[26,18,26,20],[29,18,29,20],[30,18,30,20],[32,18,32,20],[26,10,26,11],[27,10,27,11],[28,10,28,11],[24,14,24,15],[26,14,26,15],[27,14,27,15],[25,14,25,15],[28,14,28,15],[24,10,24,11],[25,10,25,11],[17,26,17,28],[20,26,20,28],[22,26,22,28],[16,26,16,28],[16,18,16,19],[15,22,16,25],[17,22,17,25],[18,22,18,25],[19,22,19,25],[15,26,15,28],[21,26,21,28],[21,22,21,25],[15,18,15,19],[17,18,17,19],[7,26,7,28],[8,26,8,28],[9,26,9,28],[10,26,10,28],[12,26,12,28],[14,26,14,28],[11,26,11,28],[5,18,6,25],[8,23,8,25],[9,23,9,25],[10,23,10,25],[13,23,13,25],[9,18,9,19],[10,18,10,19],[14,22,14,25],[8,18,8,19],[7,18,7,19],[12,18,12,19],[11,18,11,19],[13,26,13,27],[10,0,13,0],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[28,6,28,7],[24,6,24,7],[26,6,26,7],[27,6,27,7],[22,6,22,8],[23,6,23,7],[19,6,19,7],[10,6,10,7],[11,6,11,7],[49,6,49,7],[46,6,46,7],[47,6,47,7],[48,6,48,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[42,6,42,7],[29,6,29,7],[30,6,30,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[31,6,31,7],[32,6,32,7],[51,6,51,7],[52,6,52,7],[0,7,1,10],[27,22,27,25],[39,18,40,25],[31,18,31,20],[37,6,37,7],[29,10,29,11],[35,10,35,11],[30,10,30,11],[31,10,31,11],[34,10,34,12],[36,10,36,11],[0,14,1,16],[2,7,2,10],[4,14,4,16],[13,18,13,19],[14,18,14,19],[24,22,24,25],[25,22,25,23],[25,18,25,19],[21,18,21,19],[50,6,50,7],[41,6,41,7],[41,14,41,15],[42,14,42,15],[37,14,37,15],[45,10,45,11],[44,14,44,16],[41,10,41,11],[42,10,42,11],[43,10,43,11],[44,10,44,11],[40,10,40,12],[40,14,40,15],[38,10,38,11],[37,10,37,11],[33,18,33,20],[34,18,34,20],[33,22,33,25],[37,18,37,20],[37,21,37,24],[38,18,38,20],[38,21,38,24],[34,22,34,25],[3,7,3,10],[3,13,3,16],[4,12,4,13],[9,6,9,7],[5,1,6,16],[8,6,8,16],[23,14,23,15],[22,10,22,12],[23,10,23,11],[18,18,18,19],[19,18,19,19],[22,18,22,19],[8,1,8,4],[23,18,23,19],[28,22,28,25],[32,10,32,11]]}
[null,null,null,null,null,null,null,{"$f":"[4]Calc!DQ80","v":"LoanStream Mortgage"},null,null,null,null,null,null,{"$f":"[4]Calc!EA84","v":"Wholesale Ratesheet"}]
[]
[null,null,null,null,null,null,null,{"$f":"[4]Calc!DQ81","v":"19000 MacArthur Blvd, Suite 200"},null,null,null,null,null,null,{"$f":"[4]Calc!$ED$86","v":"30 Day Lock Period"}]
[null,null,null,null,null,null,null,{"$f":"[4]Calc!DQ82","v":"Irvine, CA 92612"},null,null,null,null,null,{"$f":"[4]Calc!$EC$87","v":"Borrower Paid Compensation"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[5]Calc!BB90","v":"Effective Date:"},null,{"$f":"[4]Calc!$ED$88","v":"2021-09-13"}]
[null,"NanQ \"ONE\" Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[5]Calc!AT87","v":"PriceOne Calculator"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs",null,{"$f":"[4]Calc!$EA$95","v":"Wholesale Ratesheet"},null,null,null,"Full Doc Column Includes"]
[null,{"$f":"[4]Calc!$U$93","v":"Base Rate / Base Price"},null,null,null,null,{"$f":"[4]Calc!$DY$98","v":"FICO/LTV Price Adjustments"},null,null,null,null,null,null,null,null,null,null,null,"Interest Rate",null,"Rate",null,null,null,null,null,"Tax Returns"]
[null,"Rate",{"$f":"[4]Calc!AC94","v":"Full Doc"},{"$f":"[4]Calc!AD94","v":"Alt Doc"},{"$f":"[4]Calc!AE94","v":"DSCR"},null,null,null,{"$f":"[4]Calc!EA99","v":"<=50"},{"$f":"[4]Calc!EB99","v":"50.01-60"},{"$f":"[4]Calc!EC99","v":"60.01-65"},{"$f":"[4]Calc!ED99","v":"65.01-70"},{"$f":"[4]Calc!EE99","v":"70.01-75"},{"$f":"[4]Calc!EF99","v":"75.01-80"},{"$f":"[4]Calc!EG99","v":"80.01-85"},{"$f":"[4]Calc!EH99","v":"85.01-90"},{"$f":"[4]Calc!EI99","v":"90.01-95"},null,"LTV Range",null,"Choose a Selection",null,null,null,null,null,"VOE Only"]
[null,{"$f":"[4]Calc!AP95","v":3.25},{"$f":"[4]Calc!AC95","v":100},{"$f":"[4]Calc!AD95","v":99.5},{"$f":"[4]Calc!AE95","v":{"$error":"#N/A"}},null,{"$f":"[4]Calc!DY100","v":"780+"},null,{"$f":"[4]Calc!EA100","v":0},{"$f":"[4]Calc!EB100","v":0},{"$f":"[4]Calc!EC100","v":-0.25},{"$f":"[4]Calc!ED100","v":-0.5},{"$f":"[4]Calc!EE100","v":-0.75},{"$f":"[4]Calc!EF100","v":-1},{"$f":"[4]Calc!EG100","v":-1.5},{"$f":"[4]Calc!EH100","v":-2.5},{"$f":"[4]Calc!EI100","v":-4},null,"FICO Range",null,"Choose a Selection",{"$f":"IF(U11=\"Choose Selection\",0,(IF((ISERROR((IF(U15=\"Foreign Nat' With Fico\",0,(INDEX(I11:Q20,MATCH(U11,G11:G21,0),MATCH(U10,I10:Q10)))))))=TRUE,0,(INDEX(I11:Q20,MATCH(U11,G11:G21,0),MATCH(U10,I10:Q10))))))","v":0},null,null,null,null,"1099 Only"]
[null,{"$f":"[4]Calc!AP96","v":3.375},{"$f":"[4]Calc!AC96","v":100.25},{"$f":"[4]Calc!AD96","v":99.75},{"$f":"[4]Calc!AE96","v":{"$error":"#N/A"}},null,{"$f":"[4]Calc!DY101","v":"760-779"},null,{"$f":"[4]Calc!EA101","v":0},{"$f":"[4]Calc!EB101","v":0},{"$f":"[4]Calc!EC101","v":-0.5},{"$f":"[4]Calc!ED101","v":-0.75},{"$f":"[4]Calc!EE101","v":-1},{"$f":"[4]Calc!EF101","v":-1.25},{"$f":"[4]Calc!EG101","v":-1.75},{"$f":"[4]Calc!EH101","v":-3.25},{"$f":"[4]Calc!EI101","v":-4.5},null,"Grade",null,"Choose a Selection",{"$f":"IF(U12=\"Choose a Selection\",0,(INDEX(M23:M33,MATCH(U12,K23:K33,0))))","v":0},null,null,null,null,"Asset Utilization Only"]
[null,{"$f":"[4]Calc!AP97","v":3.4990000000000001},{"$f":"[4]Calc!AC97","v":100.5},{"$f":"[4]Calc!AD97","v":100},{"$f":"[4]Calc!AE97","v":{"$error":"#N/A"}},null,{"$f":"[4]Calc!DY102","v":"740-759"},null,{"$f":"[4]Calc!EA102","v":-0.125},{"$f":"[4]Calc!EB102","v":-0.25},{"$f":"[4]Calc!EC102","v":-0.5},{"$f":"[4]Calc!ED102","v":-1},{"$f":"[4]Calc!EE102","v":-1.25},{"$f":"[4]Calc!EF102","v":-1.5},{"$f":"[4]Calc!EG102","v":-1.75},{"$f":"[4]Calc!EH102","v":-3.75},{"$f":"[4]Calc!EI102","v":-5},null,"Doc Type",null,"Choose a Selection",null,null,null,null,null,"Asset Utilization W/ Full Doc"]
[null,{"$f":"[4]Calc!AP98","v":3.625},{"$f":"[4]Calc!AC98","v":100.75},{"$f":"[4]Calc!AD98","v":100.25},{"$f":"[4]Calc!AE98","v":{"$error":"#N/A"}},null,{"$f":"[4]Calc!DY103","v":"720-739"},null,{"$f":"[4]Calc!EA103","v":-0.25},{"$f":"[4]Calc!EB103","v":-0.25},{"$f":"[4]Calc!EC103","v":-0.75},{"$f":"[4]Calc!ED103","v":-1.25},{"$f":"[4]Calc!EE103","v":-1.5},{"$f":"[4]Calc!EF103","v":-1.75},{"$f":"[4]Calc!EG103","v":-2.25},{"$f":"[4]Calc!EH103","v":-4.25},{"$f":"[4]Calc!EI103","v":-6},null,"Additional Adjs",null,"Choose a Selection",{"$f":"IF(U14=\"Choose a Selection\",0,(IF(U14=\"None in this Dropdown\",0,IF(U14=\"12 Month Full / Alt Doc\",0,INDEX(I$24:I$50,MATCH(U14,G$24:G$50,0))))))","v":0}]
[null,{"$f":"[4]Calc!AP99","v":3.75},{"$f":"[4]Calc!AC99","v":101},{"$f":"[4]Calc!AD99","v":100.5},{"$f":"[4]Calc!AE99","v":{"$error":"#N/A"}},null,{"$f":"[4]Calc!DY104","v":"700-719"},null,{"$f":"[4]Calc!EA104","v":-0.625},{"$f":"[4]Calc!EB104","v":-1},{"$f":"[4]Calc!EC104","v":-1.25},{"$f":"[4]Calc!ED104","v":-1.5},{"$f":"[4]Calc!EE104","v":-1.75},{"$f":"[4]Calc!EF104","v":-2.25},{"$f":"[4]Calc!EG104","v":-2.5},{"$f":"[4]Calc!EH104","v":-5},{"$f":"[4]Calc!EI104","v":{"$error":"#N/A"}},null,"Citizenships",null,"Choose a Selection",{"$f":"IF(U15=\"US Citizen\",0,(IF(U15=\"Permanent Resident\",0,(IF(U15=\"Non Perm Resident\",0,(IF(U15=\"ITIN\",VLOOKUP(U15,G25:I51,3,0),(IF(U15=\"Foreign Nat' No Fico\",INDEX(I11:Q21,MATCH(U15,G11:G21,0),MATCH(U10,I10:Q10)),IF(U15=\"Foreign Nat' With Fico\",IF(U15=\"Foreign Nat' With Fico\",INDEX(G25:I51,(MATCH(U15,G25:G51,0)),3)),0))))))))))","v":0},"B Max LTV Exceeded for Foreign National",null,null,null,"Alt Doc Column Includes"]
[null,{"$f":"[4]Calc!AP100","v":3.875},{"$f":"[4]Calc!AC100","v":101.25},{"$f":"[4]Calc!AD100","v":100.75},{"$f":"[4]Calc!AE100","v":100},null,{"$f":"[4]Calc!DY105","v":"680-699"},null,{"$f":"[4]Calc!EA105","v":-0.875},{"$f":"[4]Calc!EB105","v":-1.25},{"$f":"[4]Calc!EC105","v":-1.5},{"$f":"[4]Calc!ED105","v":-2},{"$f":"[4]Calc!EE105","v":-2.25},{"$f":"[4]Calc!EF105","v":-2.5},{"$f":"[4]Calc!EG105","v":-3},{"$f":"[4]Calc!EH105","v":-6},{"$f":"[4]Calc!EI105","v":{"$error":"#N/A"}},null,"DTI",null,"Choose a Selection",{"$f":"IF(U16=\"Choose a Selection\",0,(IF(U16=\"DTI <50% - All Doc Types\",0,IF(U16=\"No DTI Program\",0,INDEX(I$24:I$50,MATCH(U16,G$24:G$50,0))))))","v":0},"Please reach out to the Lock Desk to Price Loans >5MM",null,null,null,"12 Bank Statements"]
[null,{"$f":"[4]Calc!AP101","v":3.9990000000000001},{"$f":"[4]Calc!AC101","v":101.5},{"$f":"[4]Calc!AD101","v":101},{"$f":"[4]Calc!AE101","v":100.25},null,{"$f":"[4]Calc!DY106","v":"660-679"},null,{"$f":"[4]Calc!EA106","v":-1.25},{"$f":"[4]Calc!EB106","v":-2},{"$f":"[4]Calc!EC106","v":-2.25},{"$f":"[4]Calc!ED106","v":-2.75},{"$f":"[4]Calc!EE106","v":-3},{"$f":"[4]Calc!EF106","v":-3.25},{"$f":"[4]Calc!EG106","v":-4},{"$f":"[4]Calc!EH106","v":-7},{"$f":"[4]Calc!EI106","v":{"$error":"#N/A"}},null,"Loan Balance",null,"Choose a Selection",{"$f":"IF(U17=\"Choose a Selection\",0,((IF(U17=\"$5,000,001-$7,500,000\",\"Call Lock Desk\",IF(U17=\"$7,500,001-$10,000,000\",\"Call Lock Desk\",INDEX(I$24:I$50,MATCH(U17,G$24:G$50,0)))))))","v":0},null,null,null,null,"12 or 24 CPA P&L"]
[null,{"$f":"[4]Calc!AP102","v":4.125},{"$f":"[4]Calc!AC102","v":101.75},{"$f":"[4]Calc!AD102","v":101.25},{"$f":"[4]Calc!AE102","v":100.5},null,{"$f":"[4]Calc!DY107","v":"640-659"},null,{"$f":"[4]Calc!EA107","v":-1.625},{"$f":"[4]Calc!EB107","v":-2.25},{"$f":"[4]Calc!EC107","v":-2.5},{"$f":"[4]Calc!ED107","v":-3},{"$f":"[4]Calc!EE107","v":-3.5},{"$f":"[4]Calc!EF107","v":-4},{"$f":"[4]Calc!EG107","v":-5},{"$f":"[4]Calc!EH107","v":-8},{"$f":"[4]Calc!EI107","v":{"$error":"#N/A"}},null,"Purpose",null,"Choose a Selection",{"$f":"IF(ISERROR(IF(OR(U18=\"Purchase\",U18=\"Rate/Term Refi\"),0,INDEX(I$24:I$53,MATCH(U18,G$24:G$53,0)))),0,INDEX(I$24:I$53,MATCH(U18,G$24:G$53,0)))","v":0},"Cashout must be for business purpose only",null,null,null,"Asset Utlization W/ Bank Stmt"]
[null,{"$f":"[4]Calc!AP103","v":4.25},{"$f":"[4]Calc!AC103","v":102},{"$f":"[4]Calc!AD103","v":101.5},{"$f":"[4]Calc!AE103","v":100.75},null,{"$f":"[4]Calc!DY108","v":"620-639"},null,{"$f":"[4]Calc!EA108","v":-1.875},{"$f":"[4]Calc!EB108","v":-2.5},{"$f":"[4]Calc!EC108","v":-3},{"$f":"[4]Calc!ED108","v":-3.5},{"$f":"[4]Calc!EE108","v":-4},{"$f":"[4]Calc!EF108","v":-4.75},{"$f":"[4]Calc!EG108","v":-6},{"$f":"[4]Calc!EH108","v":{"$error":"#N/A"}},{"$f":"[4]Calc!EI108","v":{"$error":"#N/A"}},null,"Occupancy",null,"Choose a Selection",{"$f":"IF(U19=\"Choose a Selection\",0,(IF(OR(U19=\"Primary\"),0,IF(OR(U19=\"Non-Owner (DSCR/No Ratio)\"),0,INDEX(I$24:I$50,MATCH(U19,G$24:G$50,0))))))","v":0},{"$f":"IF(U19=\"Non-Owner (N/A DSCR)\",AF36,IF(U19=\"Non-Owner (DSCR/No Ratio)\",AF32,\"\"))","v":""}]
[null,{"$f":"[4]Calc!AP104","v":4.375},{"$f":"[4]Calc!AC104","v":102.25},{"$f":"[4]Calc!AD104","v":101.75},{"$f":"[4]Calc!AE104","v":101},null,{"$f":"[4]Calc!DY109","v":"600-619"},null,{"$f":"[4]Calc!EA109","v":-2.625},{"$f":"[4]Calc!EB109","v":-3.25},{"$f":"[4]Calc!EC109","v":-3.75},{"$f":"[4]Calc!ED109","v":-4.25},{"$f":"[4]Calc!EE109","v":-5.5},{"$f":"[4]Calc!EF109","v":-6.5},{"$f":"[4]Calc!EG109","v":-7},{"$f":"[4]Calc!EH109","v":{"$error":"#N/A"}},{"$f":"[4]Calc!EI109","v":{"$error":"#N/A"}},null,"Property Type",null,"Choose a Selection",{"$f":"IF(U17=\"Choose a Selection\",0,(IF(OR(U20=\"SFR\",U20=\"1-2 Units\",U20=\"PUD\",U20=\"Condo\"),0,INDEX(I$24:I$50,MATCH(U20,G$24:G$50,0)))))","v":0}]
[null,{"$f":"[4]Calc!AP105","v":4.4989999999999997},{"$f":"[4]Calc!AC105","v":102.5},{"$f":"[4]Calc!AD105","v":102},{"$f":"[4]Calc!AE105","v":101.25},null,{"$f":"[4]Calc!DY110","v":"Foreign Nat' No Fico"},{"$f":"[4]Calc!DZ110","v":0},{"$f":"[4]Calc!EA110","v":-0.875},{"$f":"[4]Calc!EB110","v":-1.25},{"$f":"[4]Calc!EC110","v":-1.5},{"$f":"[4]Calc!ED110","v":-2},{"$f":"[4]Calc!EE110","v":-2.25},{"$f":"[4]Calc!EF110","v":{"$error":"#N/A"}},{"$f":"[4]Calc!EG110","v":{"$error":"#N/A"}},{"$f":"[4]Calc!EH110","v":{"$error":"#N/A"}},{"$f":"[4]Calc!EI110","v":{"$error":"#N/A"}},null,"Loan Term",null,"5/1 30YR ARM",{"$f":"INDEX(Q23:Q33,MATCH(U21,O23:O33,0))","v":0},"*TX Cash-out Min Ln Amt $250,000*",null,null,null,"DSCR/No Ratio Column Includes"]
[null,{"$f":"[4]Calc!AP106","v":4.625},{"$f":"[4]Calc!AC106","v":102.75},{"$f":"[4]Calc!AD106","v":102.25},{"$f":"[4]Calc!AE106","v":101.5},null,null,null,null,null,null,null,null,null,null,null,null,null,"Escrow",null,"Escrow Not Waived",{"$f":"IF(U22=\"Escrow Not Waived\",0,INDEX(I$24:I$50,MATCH(U22,G$24:G$50,0)))","v":0},"Impounds Required On HPML Loans, Ask Your AM",null,null,null,"DSCR"]
[null,{"$f":"[4]Calc!AP107","v":4.75},{"$f":"[4]Calc!AC107","v":103},{"$f":"[4]Calc!AD107","v":102.5},{"$f":"[4]Calc!AE107","v":101.75},null,{"$f":"[4]Calc!$DY$113","v":"Loan Level Price Adjustments"},null,null,null,{"$f":"[4]Calc!$EC$113","v":"Grades"},null,null,null,{"$f":"[4]Calc!$EC$124","v":"Loan Term"},null,null,null,"Prepayment Penalty",null,"36 Months PPP",{"$f":"IF(OR(U19=\"Primary\",U19=\"Second Home\"),0,INDEX(I$24:I$50,MATCH(U23,G$24:G$50,0)))","v":0},"Due to state statutes, LSM does not allow ARM loans in New Mexico",null,null,null,"No Ratio"]
[null,{"$f":"[4]Calc!AP108","v":4.875},{"$f":"[4]Calc!AC108","v":103.25},{"$f":"[4]Calc!AD108","v":102.75},{"$f":"[4]Calc!AE108","v":102},null,null,null,{"$f":"[5]Calc!$CA107","v":"LLPA"},null,{"$f":"[4]Calc!EC114","v":"Select - Standard"},null,{"$f":"[4]Calc!EE114","v":0.5},null,{"$f":"[4]Calc!EC125","v":"5/1 30YR ARM"},null,{"$f":"[4]Calc!EE125","v":0},null,"State",null,"All Other States",0]
[null,{"$f":"[4]Calc!AP109","v":4.9989999999999997},{"$f":"[4]Calc!AC109","v":103.5},{"$f":"[4]Calc!AD109","v":103},{"$f":"[4]Calc!AE109","v":102.25},null,{"$f":"[4]Calc!DY115","v":"DTI ≥50% - All Doc Types"},null,{"$f":"[4]Calc!EB115","v":-0.25},null,{"$f":"[4]Calc!EC115","v":"A+"},null,{"$f":"[4]Calc!EE115","v":0.25},null,{"$f":"[4]Calc!EC126","v":"5/1 30YR IO ARM"},null,{"$f":"[4]Calc!EE126","v":-0.125},null,"Lock Term",null,"30 Day",{"$f":"INDEX(M42:M46,MATCH(U25,K42:K46,0))","v":0},"UW Fee Buyout Calculator"]
[null,{"$f":"[4]Calc!AP110","v":5.125},{"$f":"[4]Calc!AC110","v":103.75},{"$f":"[4]Calc!AD110","v":103.25},{"$f":"[4]Calc!AE110","v":102.5},null,{"$f":"[4]Calc!DY116","v":"Non-Owner (N/A DSCR)"},null,{"$f":"[4]Calc!EB116","v":-1},null,{"$f":"[4]Calc!EC116","v":"A"},null,{"$f":"[4]Calc!EE116","v":-1},null,{"$f":"[4]Calc!EC127","v":"5/1 40YR IO ARM"},null,{"$f":"[4]Calc!EE127","v":-0.25},null,"Future Use",null,"Not Applicable",{"$f":"IF(U26<>\"xxx\",0,0)","v":0},"Loan Amount →",null,0,null,null,null,null,"Minimum rate rule",{"$f":"IF(U9>4.74,0,1)","v":0}]
[null,{"$f":"[4]Calc!AP111","v":5.25},{"$f":"[4]Calc!AC111","v":104},{"$f":"[4]Calc!AD111","v":103.5},{"$f":"[4]Calc!AE111","v":102.75},null,"ITIN",null,{"$f":"[4]Calc!EB117","v":-1.5},null,{"$f":"[4]Calc!EC117","v":"B"},null,{"$f":"[4]Calc!EE117","v":-2},null,{"$f":"[4]Calc!EC128","v":"7/1 30YR ARM"},null,{"$f":"[4]Calc!EE128","v":-0.125},null,"  Total LLPA",null,null,{"$f":"SUM(V11:V26)","v":0},{"$f":"IFERROR(1295/Y26*100,\"Input a Loan Amount\")","v":"Input a Loan Amount"},null,null,null,null,null,null,"Loan Amount rule",{"$f":"IF(V17<5,0,1)","v":0}]
[null,{"$f":"[4]Calc!AP112","v":5.375},{"$f":"[4]Calc!AC112","v":104.25},{"$f":"[4]Calc!AD112","v":103.75},{"$f":"[4]Calc!AE112","v":103},null,{"$f":"[4]Calc!DY118","v":"VOE Only"},null,{"$f":"[4]Calc!EB118","v":-1},null,{"$f":"[4]Calc!EC118","v":"B-"},null,{"$f":"[4]Calc!EE118","v":-2.5},null,{"$f":"[4]Calc!EC129","v":"7/1 30YR IO ARM"},null,{"$f":"[4]Calc!EE129","v":-0.25},null,"  Gross Rate Sheet Price (Prior to LLPAs)",null,null,{"$f":"INDEX(B11:E53,MATCH(U9,B11:B53,0),MATCH(U13,C10:E10,0)+1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Impounds rule",{"$f":"IF(NOT(U22=\"Escrow Waived\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AP113","v":5.4989999999999997},{"$f":"[4]Calc!AC113","v":104.5},{"$f":"[4]Calc!AD113","v":104},{"$f":"[4]Calc!AE113","v":103.25},null,{"$f":"[4]Calc!DY119","v":"1099 Only"},null,{"$f":"[4]Calc!EB119","v":-1},null,{"$f":"[4]Calc!EC119","v":"C"},null,{"$f":"[4]Calc!EE119","v":-3},null,{"$f":"[4]Calc!EC130","v":"7/1 40YR IO ARM"},null,{"$f":"[4]Calc!EE130","v":-0.375},null,"  Max YSP",null,null,{"$f":"Feed!E65","v":"ERROR"},{"$f":"CONCATENATE(S29,\" \",\"is\",\" \", V29)","v":"  Max YSP is ERROR"},null,null,null,null,null,null,"Texas rule",{"$f":"IF(NOT(U24=\"Texas\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AP114","v":5.625},{"$f":"[4]Calc!AC114","v":104.75},{"$f":"[4]Calc!AD114","v":104.25},{"$f":"[4]Calc!AE114","v":103.5},null,{"$f":"[4]Calc!DY120","v":"Asset Utilization"},null,{"$f":"[4]Calc!EB120","v":-1},null,{"$f":"[4]Calc!EC120","v":"Select - DSCR"},null,{"$f":"[4]Calc!EE120","v":0.5},null,{"$f":"[4]Calc!EC131","v":"15YR Fixed"},null,{"$f":"[4]Calc!EE131","v":0},null,"  Net Price: Rate Sheet - LLPA (Prior to Max YSP)",null,null,{"$f":"IFERROR(V28+V27,\"Minimum Rate\")","v":"Minimum Rate"},{"$f":"IF(V39=\"Lender Paid\",\"LPC Selected\",IF(AND(V39=\"Borrower Paid\",Z39=\"\",V39=\"Choose a Selection\"),\"BPC is Blank\",\"BPC Inputted\"))","v":"BPC Inputted"},null,null,null,null,null,null,"15 Day Rule",{"$f":"IF(U25=\"15 Day\",0,1)","v":1}]
[null,{"$f":"[4]Calc!AP115","v":5.75},{"$f":"[4]Calc!AC115","v":105},{"$f":"[4]Calc!AD115","v":104.5},{"$f":"[4]Calc!AE115","v":103.75},null,{"$f":"[4]Calc!DY121","v":"Debt Consol. >70% LTV"},null,{"$f":"[4]Calc!EB121","v":-0.25},null,{"$f":"[4]Calc!EC121","v":"DSCR (≥1.00)"},null,{"$f":"[4]Calc!EE121","v":0.25},null,{"$f":"[4]Calc!EC132","v":"30YR Fixed"},null,{"$f":"[4]Calc!EE132","v":-0.25},null,"  Net Rate Sheet Price - As Borrower Paid (BPC)",null,null,{"$f":"IFERROR(IF(V30>V29,V29,V30),\"Priced LPC\")","v":"ERROR"},{"$f":"CONCATENATE(Feed!B177,\" \",Feed!D177,\"%\" &\" @ \"&Feed!E177)","v":"Near Par Rate - BPC 0% @ 0"},null,null,null,null,null,null,"Cashout/PPP Rule",{"$f":"IF(AND(U18=\"Cash-out\",U23<>\"No Prepay\",U19<>\"primary\"),0,1)","v":1}]
[null,{"$f":"[4]Calc!AP116","v":5.875},{"$f":"[4]Calc!AC116","v":105.25},{"$f":"[4]Calc!AD116","v":104.75},{"$f":"[4]Calc!AE116","v":104},null,{"$f":"[4]Calc!DY122","v":"Cash-Out >70% LTV"},null,{"$f":"[4]Calc!EB122","v":-0.375},null,{"$f":"[4]Calc!EC122","v":"No Ratio (0.75-0.99)"},null,{"$f":"[4]Calc!EE122","v":-1},null,{"$f":"[4]Calc!EC133","v":"30YR IO Fixed"},null,{"$f":"[4]Calc!EE133","v":-0.375},null,"  Net Rate Sheet Price - BPC W/ UW Fee Buyout",null,null,{"$f":"IF(Y26=0,\"Missing TLA\",V31-W27)","v":"Missing TLA"},null,null,null,null,null,null,null,"DSCR",{"$f":"IF(U19=\"Non-Owner (N/A DSCR)\",0,IF(U19=\"Non-Owner (DSCR/No Ratio)\",0,1))","v":1},"You have Selected DSCR No Income Loan"]
[null,{"$f":"[4]Calc!AP117","v":5.9989999999999997},{"$f":"[4]Calc!AC117","v":105.5},{"$f":"[4]Calc!AD117","v":105},{"$f":"[4]Calc!AE117","v":104.25},null,{"$f":"[4]Calc!DY123","v":"3-4 Units"},null,{"$f":"[4]Calc!EB123","v":-0.5},null,{"$f":"[4]Calc!EC123","v":"No Ratio (<0.75)"},null,{"$f":"[4]Calc!EE123","v":-2},null,{"$f":"[4]Calc!EC134","v":"40YR IO Fixed"},null,{"$f":"[4]Calc!EE134","v":-0.5},null,"  Lender Paid Comp Plan Amount (LPC)"]
[null,{"$f":"[4]Calc!AP118","v":6.125},{"$f":"[4]Calc!AC118","v":105.75},{"$f":"[4]Calc!AD118","v":105.25},{"$f":"[4]Calc!AE118","v":104.5},null,{"$f":"[4]Calc!DY124","v":"Second Home"},null,{"$f":"[4]Calc!EB124","v":-1},null,null,null,null,null,null,null,null,null,"  Net Rate Sheet Price as Lender Paid (LPC)",null,null,{"$f":"IF(V33<0.001,\"LPC Not Valid\",IFERROR(V31-V33,\"LPC Blank\"))","v":"LPC Not Valid"},{"$f":"IF(V33<=0.1,\"LPC is Blank\",CONCATENATE(Feed!B180,\" \",Feed!D180,\"%\"&\" @ \"&Feed!E180))","v":"LPC is Blank"}]
[null,{"$f":"[4]Calc!AP119","v":6.25},{"$f":"[4]Calc!AC119","v":106},{"$f":"[4]Calc!AD119","v":105.5},{"$f":"[4]Calc!AE119","v":104.75},null,{"$f":"[4]Calc!DY125","v":"DSCR 80.01-85% LTV"},null,{"$f":"[4]Calc!EB125","v":-1.25},null,{"$f":"[4]Calc!$EF$113","v":"Margins"},null,null,null,"Max Price",null,null,null,"  Net Rate Sheet Price - LPC W/ UW Fee Buyout",null,null,{"$f":"IFERROR(IF(Y26=0,\"Missing TLA\",V34-W27),\"LPC Not Valid\")","v":"Missing TLA"}]
[null,{"$f":"[4]Calc!AP120","v":6.375},{"$f":"[4]Calc!AC120","v":106.25},{"$f":"[4]Calc!AD120","v":105.75},{"$f":"[4]Calc!AE120","v":105},null,{"$f":"[4]Calc!DY126","v":"No PPP \"See PPP Section\""},null,{"$f":"[4]Calc!EB126","v":-2},null,{"$f":"[4]Calc!EF114","v":"Occupancy"},null,{"$f":"[4]Calc!$EI$114","v":"Margin"},null,"Owner Occ/Sec Home",null,{"$f":"[4]Calc!EI125","v":102},null,"Loan Number",null,null,"Borrower Name",null,null,null,null,null,null,null,null,null,"You have Selected Income Qualifing Inv Loan"]
[null,{"$f":"[4]Calc!AP121","v":6.4989999999999997},{"$f":"[4]Calc!AC121","v":106.5},{"$f":"[4]Calc!AD121","v":106},{"$f":"[4]Calc!AE121","v":105.25},null,{"$f":"[4]Calc!DY127","v":"6 Months PPP"},null,{"$f":"[4]Calc!EB127","v":-1.75},null,{"$f":"[4]Calc!EF115","v":"Primary Home"},null,{"$f":"[4]Calc!EI115","v":3},null,"Loans W/ No PPP",null,{"$f":"[4]Calc!EI126","v":100},null,null,null,null,null,null,null,null,null,null,null,null," Foreign National",{"$f":"ISERROR(V15)","v":false}]
[null,{"$f":"[4]Calc!AP122","v":6.625},{"$f":"[4]Calc!AC122","v":106.75},{"$f":"[4]Calc!AD122","v":106.25},{"$f":"[4]Calc!AE122","v":105.5},null,{"$f":"[4]Calc!DY128","v":"12 Months PPP"},null,{"$f":"[4]Calc!EB128","v":-1},null,{"$f":"[4]Calc!EF116","v":"Second Home"},null,{"$f":"[4]Calc!EI116","v":3},null,"Loans W/ 6 Month PPP",null,{"$f":"[4]Calc!EI127","v":100},null,"Property Address",null,null,"Compensation Type",null,null,null,"Comp?"]
[null,{"$f":"[4]Calc!AP123","v":6.75},{"$f":"[4]Calc!AC123","v":107},{"$f":"[4]Calc!AD123","v":106.5},{"$f":"[4]Calc!AE123","v":105.75},null,{"$f":"[4]Calc!DY129","v":"24 Months PPP"},null,{"$f":"[4]Calc!EB129","v":-0.5},null,{"$f":"[4]Calc!EF117","v":"Investment Home"},null,{"$f":"[4]Calc!EI117","v":5},null,"Loans W/ 1YR PPP",null,{"$f":"[4]Calc!EI128","v":101}]
[null,{"$f":"[4]Calc!AP124","v":6.875},{"$f":"[4]Calc!AC124","v":107.25},{"$f":"[4]Calc!AD124","v":106.75},{"$f":"[4]Calc!AE124","v":106},null,{"$f":"[4]Calc!DY130","v":"36 Months PPP"},null,{"$f":"[4]Calc!EB130","v":0},null,null,null,null,null,"Loans W/ 2YR PPP",null,{"$f":"[4]Calc!EI129","v":101.5}]
[null,{"$f":"[4]Calc!AP125","v":6.9989999999999997},{"$f":"[4]Calc!AC125","v":107.5},{"$f":"[4]Calc!AD125","v":107},{"$f":"[4]Calc!AE125","v":106.25},null,{"$f":"[4]Calc!DY131","v":"48 Months PPP"},null,{"$f":"[4]Calc!EB131","v":0.25},null,{"$f":"[4]Calc!$EF$117","v":"Investment Home"},null,null,null,"Loans W/ 3YR PPP",null,{"$f":"[4]Calc!EI130","v":102}]
[null,{"$f":"[4]Calc!AP126","v":7.125},{"$f":"[4]Calc!AC126","v":107.75},{"$f":"[4]Calc!AD126","v":107.25},{"$f":"[4]Calc!AE126","v":106.5},null,{"$f":"[4]Calc!DY132","v":"60 Months PPP"},null,{"$f":"[4]Calc!EB132","v":0.5},null,{"$f":"[4]Calc!EF118","v":"Lock Days"},null,{"$f":"[4]Calc!EH118","v":0},null,"Loans W/ 4YR PPP",null,{"$f":"[4]Calc!EI131","v":102.5},null,"*6 months interest on 80% of the original principal balance \nMinimum 6 Months Prepay required except in the following states \nNot allowed in DE, IL1, MD, MI, MN, ND, NJ1, NM, OH, PA\n1Prepay allowed for loans closed in the name of \na Corporation or LLC in IL, and NJ\n*PPP is only Allowed on Investment & DSCR Non-TRID Loans"]
[null,{"$f":"[4]Calc!AP127","v":7.25},{"$f":"[4]Calc!AC127","v":108},{"$f":"[4]Calc!AD127","v":107.5},{"$f":"[4]Calc!AE127","v":106.75},null,{"$f":"[4]Calc!DY133","v":"Escrow Waived"},null,{"$f":"[4]Calc!EB133","v":-0.25},null,{"$f":"[4]Calc!EF119","v":"15 Day"},null,{"$f":"[4]Calc!EH119","v":0.15},null,"Loans W/ 5YR PPP",null,{"$f":"[4]Calc!EI132","v":103}]
[null,{"$f":"[4]Calc!AP128","v":7.375},{"$f":"[4]Calc!AC128","v":108.25},{"$f":"[4]Calc!AD128","v":107.75},{"$f":"[4]Calc!AE128","v":107},null,{"$f":"[4]Calc!DY134","v":"NW Condo"},null,{"$f":"[4]Calc!EB134","v":-1},null,{"$f":"[4]Calc!EF120","v":"30 Day"},null,{"$f":"[4]Calc!EH120","v":0}]
[null,{"$f":"[4]Calc!AP129","v":7.4989999999999997},{"$f":"[4]Calc!AC129","v":108.5},{"$f":"[4]Calc!AD129","v":108},{"$f":"[4]Calc!AE129","v":107.25},null,{"$f":"[4]Calc!DY135","v":"<$150,000"},null,{"$f":"[4]Calc!EB135","v":-1},null,{"$f":"[4]Calc!EF121","v":"45 Day"},null,{"$f":"[4]Calc!EH121","v":0},null,"Extension Cost"]
[null,{"$f":"[4]Calc!AP130","v":7.625},{"$f":"[4]Calc!AC130","v":108.75},{"$f":"[4]Calc!AD130","v":108.25},{"$f":"[4]Calc!AE130","v":107.5},null,{"$f":"[4]Calc!DY136","v":"$150,000-$1,000,000"},null,{"$f":"[4]Calc!EB136","v":0},null,{"$f":"[4]Calc!EF122","v":"60 Day"},null,{"$f":"[4]Calc!EH122","v":-0.375},null,"2 Bps (0.020)",null,"Per Day"]
[null,{"$f":"[4]Calc!AP131","v":7.75},{"$f":"[4]Calc!AC131","v":109},{"$f":"[4]Calc!AD131","v":108.5},{"$f":"[4]Calc!AE131","v":107.75},null,{"$f":"[4]Calc!DY137","v":">$1,000,000"},null,{"$f":"[4]Calc!EB137","v":0}]
[null,{"$f":"[4]Calc!AP132","v":7.875},{"$f":"[4]Calc!AC132","v":109.25},{"$f":"[4]Calc!AD132","v":108.75},{"$f":"[4]Calc!AE132","v":108},null,{"$f":"[4]Calc!DY138","v":">$1,500,000"},null,{"$f":"[4]Calc!EB138","v":0},null,{"$f":"[4]Calc!EC137","v":"Minimum Rates by Doc Type"},null,null,null,{"$f":"[4]Calc!EF137","v":"Loan Term"},{"$f":"[4]Calc!EG137","v":"Caps"},{"$f":"[4]Calc!EI137","v":"Index"}]
[null,{"$f":"[4]Calc!AP133","v":7.9989999999999997},{"$f":"[4]Calc!AC133","v":109.5},{"$f":"[4]Calc!AD133","v":109},{"$f":"[4]Calc!AE133","v":108.25},null,{"$f":"[4]Calc!DY139","v":">$2,000,000"},null,{"$f":"[4]Calc!EB139","v":-0.5},null,{"$f":"[4]Calc!EC138","v":"Full Doc"},{"$f":"[4]Calc!ED138","v":"Alt Doc"},{"$f":"[4]Calc!EE138","v":"DSCR"},null,{"$f":"[4]Calc!EF138","v":"5/1 ARM"},{"$f":"[4]Calc!EG138","v":"5/2/5"},{"$f":"[4]Calc!EI138","v":"1YR Libor"}]
[null,{"$f":"[4]Calc!AP134","v":8.125},{"$f":"[4]Calc!AC134","v":109.75},{"$f":"[4]Calc!AD134","v":109.25},{"$f":"[4]Calc!AE134","v":108.5},null,{"$f":"[4]Calc!DY140","v":">$3,000,000"},null,{"$f":"[4]Calc!EB140","v":-0.75},null,{"$f":"[4]Calc!EC139","v":3.2500000000000001E-2},{"$f":"[4]Calc!ED139","v":3.2500000000000001E-2},{"$f":"[4]Calc!EE139","v":3.7499999999999999E-2},null,{"$f":"[4]Calc!EF139","v":"7/1 ARM"},{"$f":"[4]Calc!EG139","v":"5/2/5"},{"$f":"[4]Calc!EI139","v":"1YR Libor"}]
[null,null,null,null,null,null,{"$f":"[4]Calc!DY141","v":"Foreign Nat' With Fico"},null,{"$f":"[4]Calc!EB141","v":-0.25},null,null,null,null,null,"Floor = Rate"]
[null,null,null,null,null,null,{"$f":"[4]Calc!DY142","v":"Purchase"},null,{"$f":"[4]Calc!EA142","v":0}]
[null,null,null,null,null,null,{"$f":"[4]Calc!DY143","v":"Rate/Term Refi"},null,{"$f":"[4]Calc!EA143","v":0}]

{"sheet":"Feed","index":1,"n_rows":181,"n_cols":30,"rows_kept":181,"cut":false,"hidden":true,"merged":[[36,9,36,11],[46,2,46,7],[180,1,180,2],[179,1,179,2],[176,1,176,2],[60,7,60,8],[79,1,79,4],[79,8,79,11],[123,1,123,4],[127,8,127,11],[177,1,177,2]]}
["FICO","LTV","Grades","Doc Type","Additional Adjs","DTI","Loan Amount","Prepayment Penalties","Escrow Waiver","Purpose","Property Type","Occupancy","Term","Lock Period","Comp Type","Citizenships","Foreign National",null,null,null,null,null,"Message"]
["Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection",null,null,null,"State","Availability","No Penalty","12 Months","24 Months","36 Months","48 Months","60 Months",null,"Compensation Type"]
["780+","<=50","Select - Standard","Full Doc","None in this Dropdown","DTI <50% - All Doc Types","<$150,000","No PPP \"See PPP Section\"","Escrow Not Waived","Purchase","SFR","Primary","5/1 30YR ARM","15 Day","Borrower Paid","US Citizen","Not Applicable1",null,null,null,"Choose a Selection","Y"," ","Choose a Selection"," "," "," "," "," ","Borrower Paid"]
["760-779","50.01-60","A+","Alt Doc","Asset Utilization","DTI ≥50% - All Doc Types","$150,000-$1,000,000","6 Months PPP","Escrow Waived","Rate/Term Refi","1-2 Units","Second Home","5/1 30YR IO ARM","30 Day","Lender Paid","Permanent Resident","Not Applicable2",null,null,null,"Illinois","Y"," ","Loans Must Close in the name of a Corp or LLC to allow PPP otherwise Buyout the PPP","Loans Must Close in the name of a Corp or LLC","Loans Must Close in the name of a Corp or LLC","Loans Must Close in the name of a Corp or LLC","Loans Must Close in the name of a Corp or LLC"," ","Lender Paid"]
["740-759","60.01-65","A","DSCR","VOE Only","No DTI Program",">$1,000,000","12 Months PPP",null,"Debt Consol. ≤ 70% LTV","3-4 Units","Non-Owner (N/A DSCR)","5/1 40YR IO ARM","45 Day",null,"Non Perm Resident","Not Applicable3",null,null,null,"Maryland","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," "]
["720-739","65.01-70","B",null,"1099 Only",null,">$1,500,000","24 Months PPP",null,"Debt Consol. >70% LTV","Condo","Non-Owner (DSCR/No Ratio)","7/1 30YR ARM","60 Day",null,"ITIN",null,null,null,null,"Michigan","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ","Channel"]
["700-719","70.01-75","B-",null,"DSCR 80.01-85% LTV",null,">$2,000,000","36 Months PPP",null,"Cash-Out ≤ 70% LTV","NW Condo",null,"7/1 30YR IO ARM","75 Day",null,"Foreign Nat' No Fico",null,null,null,null,"Minnesota","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ",{"$f":"[6]!Input_Stamp_Channel","v":"W"}]
["680-699","75.01-80","C",null,null,null,">$3,000,000","48 Months PPP",null,"Cash-Out >70% LTV","PUD",null,"7/1 40YR IO ARM",null,null,"Foreign Nat' With Fico",null,null,null,null,"North Dakota","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," "]
["660-679","80.01-85","Select - DSCR",null,null,null,null,"60 Months PPP",null,"Cash-Out >70% LTV",null,null,"15YR Fixed",null,null,null,null,null,null,null,"New Jersey","Y"," ","Loans Must Close in the name of a Corp or LLC to allow PPP otherwise Buyout the PPP","Loans Must Close in the name of a Corp or LLC","Loans Must Close in the name of a Corp or LLC","Loans Must Close in the name of a Corp or LLC","Loans Must Close in the name of a Corp or LLC"," ","Pricing Special"]
["640-659","85.01-90","DSCR (≥1.00)",null,null,null,null,null,null,null,null,null,"30YR Fixed",null,null,null,null,null,null,null,"New Mexico","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ","Eligible"]
["620-639","90.01-95","No Ratio (0.75-0.99)",null,null,null,null,null,null,"Purchase",null,null,"30YR IO Fixed",null,null,null,null,null,null,null,"Pennsylvania","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed",null,"Not Eligible"]
["600-619",null,"No Ratio (<0.75)",null,null,null,null,null,null,"Rate/Term Refi",null,null,"40YR IO Fixed",null,null,null,null,null,null,null,"Texas","Y",null,null,null,null,null,null," "]
["Foreign Nat' No Fico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Other States","Y"," ","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies"," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rules",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,null,"No Prepay",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Prepay Cond. Format",{"$f":"IF(OR('NanQ ONE Program'!U19=\"Primary\",'NanQ ONE Program'!U19=\"Second Home\"),1,0)","v":0},null,"6 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF('NanQ ONE Program'!V33>0,0,1)","v":1},null,"12 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF('NanQ ONE Program'!V39:V39=\"Borrower Paid\",0,1)","v":1},null,"24 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"State Format",{"$f":"IF(OR('NanQ ONE Program'!U19=\"Non-Owner (N/A DSCR)\",'NanQ ONE Program'!U19=\"Non-Owner (DSCR/No Ratio)\"),1,0)","v":0},null,"36 Months PPP",1,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Primary",0,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,"Second Home",0,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,"Non-Owner",1,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,null,null,null,null,null,null,"≥",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Max YSP OO",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,"<$150,000",150000,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,"$150,000-$1,000,000",750000]
[null,null,null,null,">$1,000,000",1250000,null,null,null,"Max Price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,">$1,500,000",1750000,null,null,null,"Owner Occ/Sec Home",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,">$2,000,000",2500000,null,null,null,"Loans W/ No PPP",null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,">$3,000,000",3500000,null,null,null,"Loans W/ 6 Month PPP",null,100,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,"Loans W/ 1YR PPP",null,101,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,"Loans W/ 2YR PPP",null,101.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Max YSP","Loan Balance - Owner Occ/Second",null,null,null,null,null,null,"Loans W/ 3YR PPP",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"≤$2m","2m - 3m",">3m",null,null,null,null,"Loans W/ 4YR PPP",null,102.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"YSP",102,102,102,null,null,null,null,"Loans W/ 5YR PPP",null,103,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Max YSP","Loan Balance - Investment",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,"PPP Mo","<=$150,000","$150,000-$1,000,000",">$1,000,000",">$1,500,000",">$2,000,000",">$3,000,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"60 Months PPP",103,103,103,103,103,103,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"48 Months PPP",102.5,102.5,102.5,102.5,102.5,102.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"36 Months PPP",102,102,102,102,102,102,null,"Owner Occ/Sec Home",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"24 Months PPP",101.5,101.5,101.5,101.5,101.5,101.5,null,"Loans W/ No PPP",null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"12 Months PPP",101,101,101,101,101,101,null,"Loans W/ 6 Month PPP",null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"6 Months PPP",100,100,100,100,100,100,null,"Loans W/ 1YR PPP",null,101,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"No PPP \"See PPP Section\"",100,100,100,100,100,100,null,"Loans W/ 2YR PPP",null,101.5,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,"Loans W/ 3YR PPP",null,102,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,"Loans W/ 4YR PPP",null,102.5,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,"Loans W/ 5YR PPP",null,103,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,0,2000000.01,102,{"$f":"IF(AND($C$66>B60,$C$66<C60),D60,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,2000001,3000000.01,102,{"$f":"IF(AND($C$66>B61,$C$66<C61),D61,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,3000001,10000000,102,{"$error":"#N/A"},null,null,{"$f":"IF('NanQ ONE Program'!V33>0,0,1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Primary / Secondary",{"$f":"SUM(E60:E62)","v":{"$error":"#N/A"}},null,null,{"$f":"IF('NanQ ONE Program'!V33=0,0,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Investment",{"$f":"INDEX(C49:H55,MATCH(B68,B49:B55,0),MATCH(B66,C48:H48,0))","v":{"$error":"#N/A"}},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,{"$f":"IF(OR(B67=\"Primary\",B67=\"Second Home\"),E63,IF(OR(B67=\"Non-Owner (N/A DSCR)\",B67=\"Non-Owner (DSCR/No Ratio)\"),E64,\"ERROR\"))","v":"ERROR"},null,"Non-Owner (N/A DSCR)"]
[null,{"$f":"'NanQ ONE Program'!U17","v":"Choose a Selection"},{"$f":"VLOOKUP(B66,E35:F40,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Non-Owner (N/A DSCR)"]
[null,{"$f":"'NanQ ONE Program'!U19","v":"Choose a Selection"}]
[null,{"$f":"'NanQ ONE Program'!U23","v":"36 Months PPP"}]
[]
[null,0,2000000]
[null,2000001,3000000]
[null,3000001,10000000]
[]
[]
[]
[]
[]
[]
[]
[null,"Base Rate / Base Price",null,null,null,null,null,null,"Base Rate / Base Price"]
[null,"Coupon","Full Doc","Alt Doc","DSCR",null,"Total LLPA",null,"Coupon","Full Doc","Alt Doc","DSCR"]
[null,{"$f":"'NanQ ONE Program'!B11","v":3.25},{"$f":"'NanQ ONE Program'!C11","v":100},{"$f":"'NanQ ONE Program'!D11","v":99.5},{"$f":"'NanQ ONE Program'!E11","v":{"$error":"#N/A"}},null,{"$f":"'NanQ ONE Program'!V27","v":0},1,{"$f":"B121","v":8.125},{"$f":"C121+$G$82","v":109.75},{"$f":"D121+$G$82","v":109.25},{"$f":"E121+$G$82","v":108.5}]
[null,{"$f":"'NanQ ONE Program'!B12","v":3.375},{"$f":"'NanQ ONE Program'!C12","v":100.25},{"$f":"'NanQ ONE Program'!D12","v":99.75},{"$f":"'NanQ ONE Program'!E12","v":{"$error":"#N/A"}},null,null,2,{"$f":"B120","v":7.9989999999999997},{"$f":"C120+$G$82","v":109.5},{"$f":"D120+$G$82","v":109},{"$f":"E120+$G$82","v":108.25}]
[null,{"$f":"'NanQ ONE Program'!B13","v":3.4990000000000001},{"$f":"'NanQ ONE Program'!C13","v":100.5},{"$f":"'NanQ ONE Program'!D13","v":100},{"$f":"'NanQ ONE Program'!E13","v":{"$error":"#N/A"}},null,"Total Price",3,{"$f":"B119","v":7.875},{"$f":"C119+$G$82","v":109.25},{"$f":"D119+$G$82","v":108.75},{"$f":"E119+$G$82","v":108}]
[null,{"$f":"'NanQ ONE Program'!B14","v":3.625},{"$f":"'NanQ ONE Program'!C14","v":100.75},{"$f":"'NanQ ONE Program'!D14","v":100.25},{"$f":"'NanQ ONE Program'!E14","v":{"$error":"#N/A"}},null,{"$f":"'NanQ ONE Program'!V31","v":"ERROR"},4,{"$f":"B118","v":7.75},{"$f":"C118+$G$82","v":109},{"$f":"D118+$G$82","v":108.5},{"$f":"E118+$G$82","v":107.75}]
[null,{"$f":"'NanQ ONE Program'!B15","v":3.75},{"$f":"'NanQ ONE Program'!C15","v":101},{"$f":"'NanQ ONE Program'!D15","v":100.5},{"$f":"'NanQ ONE Program'!E15","v":{"$error":"#N/A"}},null,null,5,{"$f":"B117","v":7.625},{"$f":"C117+$G$82","v":108.75},{"$f":"D117+$G$82","v":108.25},{"$f":"E117+$G$82","v":107.5}]
[null,{"$f":"'NanQ ONE Program'!B16","v":3.875},{"$f":"'NanQ ONE Program'!C16","v":101.25},{"$f":"'NanQ ONE Program'!D16","v":100.75},{"$f":"'NanQ ONE Program'!E16","v":100},null,null,6,{"$f":"B116","v":7.4989999999999997},{"$f":"C116+$G$82","v":108.5},{"$f":"D116+$G$82","v":108},{"$f":"E116+$G$82","v":107.25}]
[null,{"$f":"'NanQ ONE Program'!B17","v":3.9990000000000001},{"$f":"'NanQ ONE Program'!C17","v":101.5},{"$f":"'NanQ ONE Program'!D17","v":101},{"$f":"'NanQ ONE Program'!E17","v":100.25},null,null,7,{"$f":"B115","v":7.375},{"$f":"C115+$G$82","v":108.25},{"$f":"D115+$G$82","v":107.75},{"$f":"E115+$G$82","v":107}]
[null,{"$f":"'NanQ ONE Program'!B18","v":4.125},{"$f":"'NanQ ONE Program'!C18","v":101.75},{"$f":"'NanQ ONE Program'!D18","v":101.25},{"$f":"'NanQ ONE Program'!E18","v":100.5},null,{"$f":"'NanQ ONE Program'!U13","v":"Choose a Selection"},8,{"$f":"B114","v":7.25},{"$f":"C114+$G$82","v":108},{"$f":"D114+$G$82","v":107.5},{"$f":"E114+$G$82","v":106.75}]
[null,{"$f":"'NanQ ONE Program'!B19","v":4.25},{"$f":"'NanQ ONE Program'!C19","v":102},{"$f":"'NanQ ONE Program'!D19","v":101.5},{"$f":"'NanQ ONE Program'!E19","v":100.75},null,null,9,{"$f":"B113","v":7.125},{"$f":"C113+$G$82","v":107.75},{"$f":"D113+$G$82","v":107.25},{"$f":"E113+$G$82","v":106.5}]
[null,{"$f":"'NanQ ONE Program'!B20","v":4.375},{"$f":"'NanQ ONE Program'!C20","v":102.25},{"$f":"'NanQ ONE Program'!D20","v":101.75},{"$f":"'NanQ ONE Program'!E20","v":101},null,null,10,{"$f":"B112","v":6.9989999999999997},{"$f":"C112+$G$82","v":107.5},{"$f":"D112+$G$82","v":107},{"$f":"E112+$G$82","v":106.25}]
[null,{"$f":"'NanQ ONE Program'!B21","v":4.4989999999999997},{"$f":"'NanQ ONE Program'!C21","v":102.5},{"$f":"'NanQ ONE Program'!D21","v":102},{"$f":"'NanQ ONE Program'!E21","v":101.25},null,null,11,{"$f":"B111","v":6.875},{"$f":"C111+$G$82","v":107.25},{"$f":"D111+$G$82","v":106.75},{"$f":"E111+$G$82","v":106}]
[null,{"$f":"'NanQ ONE Program'!B22","v":4.625},{"$f":"'NanQ ONE Program'!C22","v":102.75},{"$f":"'NanQ ONE Program'!D22","v":102.25},{"$f":"'NanQ ONE Program'!E22","v":101.5},null,null,12,{"$f":"B110","v":6.75},{"$f":"C110+$G$82","v":107},{"$f":"D110+$G$82","v":106.5},{"$f":"E110+$G$82","v":105.75}]
[null,{"$f":"'NanQ ONE Program'!B23","v":4.75},{"$f":"'NanQ ONE Program'!C23","v":103},{"$f":"'NanQ ONE Program'!D23","v":102.5},{"$f":"'NanQ ONE Program'!E23","v":101.75},null,null,13,{"$f":"B109","v":6.625},{"$f":"C109+$G$82","v":106.75},{"$f":"D109+$G$82","v":106.25},{"$f":"E109+$G$82","v":105.5}]
[null,{"$f":"'NanQ ONE Program'!B24","v":4.875},{"$f":"'NanQ ONE Program'!C24","v":103.25},{"$f":"'NanQ ONE Program'!D24","v":102.75},{"$f":"'NanQ ONE Program'!E24","v":102},null,null,14,{"$f":"B108","v":6.4989999999999997},{"$f":"C108+$G$82","v":106.5},{"$f":"D108+$G$82","v":106},{"$f":"E108+$G$82","v":105.25}]
[null,{"$f":"'NanQ ONE Program'!B25","v":4.9989999999999997},{"$f":"'NanQ ONE Program'!C25","v":103.5},{"$f":"'NanQ ONE Program'!D25","v":103},{"$f":"'NanQ ONE Program'!E25","v":102.25},null,null,15,{"$f":"B107","v":6.375},{"$f":"C107+$G$82","v":106.25},{"$f":"D107+$G$82","v":105.75},{"$f":"E107+$G$82","v":105}]
[null,{"$f":"'NanQ ONE Program'!B26","v":5.125},{"$f":"'NanQ ONE Program'!C26","v":103.75},{"$f":"'NanQ ONE Program'!D26","v":103.25},{"$f":"'NanQ ONE Program'!E26","v":102.5},null,null,16,{"$f":"B106","v":6.25},{"$f":"C106+$G$82","v":106},{"$f":"D106+$G$82","v":105.5},{"$f":"E106+$G$82","v":104.75}]
[null,{"$f":"'NanQ ONE Program'!B27","v":5.25},{"$f":"'NanQ ONE Program'!C27","v":104},{"$f":"'NanQ ONE Program'!D27","v":103.5},{"$f":"'NanQ ONE Program'!E27","v":102.75},null,null,17,{"$f":"B105","v":6.125},{"$f":"C105+$G$82","v":105.75},{"$f":"D105+$G$82","v":105.25},{"$f":"E105+$G$82","v":104.5}]
[null,{"$f":"'NanQ ONE Program'!B28","v":5.375},{"$f":"'NanQ ONE Program'!C28","v":104.25},{"$f":"'NanQ ONE Program'!D28","v":103.75},{"$f":"'NanQ ONE Program'!E28","v":103},null,null,18,{"$f":"B104","v":5.9989999999999997},{"$f":"C104+$G$82","v":105.5},{"$f":"D104+$G$82","v":105},{"$f":"E104+$G$82","v":104.25}]
[null,{"$f":"'NanQ ONE Program'!B29","v":5.4989999999999997},{"$f":"'NanQ ONE Program'!C29","v":104.5},{"$f":"'NanQ ONE Program'!D29","v":104},{"$f":"'NanQ ONE Program'!E29","v":103.25},null,null,19,{"$f":"B103","v":5.875},{"$f":"C103+$G$82","v":105.25},{"$f":"D103+$G$82","v":104.75},{"$f":"E103+$G$82","v":104}]
[null,{"$f":"'NanQ ONE Program'!B30","v":5.625},{"$f":"'NanQ ONE Program'!C30","v":104.75},{"$f":"'NanQ ONE Program'!D30","v":104.25},{"$f":"'NanQ ONE Program'!E30","v":103.5},null,null,20,{"$f":"B102","v":5.75},{"$f":"C102+$G$82","v":105},{"$f":"D102+$G$82","v":104.5},{"$f":"E102+$G$82","v":103.75}]
[null,{"$f":"'NanQ ONE Program'!B31","v":5.75},{"$f":"'NanQ ONE Program'!C31","v":105},{"$f":"'NanQ ONE Program'!D31","v":104.5},{"$f":"'NanQ ONE Program'!E31","v":103.75},null,null,21,{"$f":"B101","v":5.625},{"$f":"C101+$G$82","v":104.75},{"$f":"D101+$G$82","v":104.25},{"$f":"E101+$G$82","v":103.5}]
[null,{"$f":"'NanQ ONE Program'!B32","v":5.875},{"$f":"'NanQ ONE Program'!C32","v":105.25},{"$f":"'NanQ ONE Program'!D32","v":104.75},{"$f":"'NanQ ONE Program'!E32","v":104},null,null,22,{"$f":"B100","v":5.4989999999999997},{"$f":"C100+$G$82","v":104.5},{"$f":"D100+$G$82","v":104},{"$f":"E100+$G$82","v":103.25}]
[null,{"$f":"'NanQ ONE Program'!B33","v":5.9989999999999997},{"$f":"'NanQ ONE Program'!C33","v":105.5},{"$f":"'NanQ ONE Program'!D33","v":105},{"$f":"'NanQ ONE Program'!E33","v":104.25},null,null,23,{"$f":"B99","v":5.375},{"$f":"C99+$G$82","v":104.25},{"$f":"D99+$G$82","v":103.75},{"$f":"E99+$G$82","v":103}]
[null,{"$f":"'NanQ ONE Program'!B34","v":6.125},{"$f":"'NanQ ONE Program'!C34","v":105.75},{"$f":"'NanQ ONE Program'!D34","v":105.25},{"$f":"'NanQ ONE Program'!E34","v":104.5},null,null,24,{"$f":"B98","v":5.25},{"$f":"C98+$G$82","v":104},{"$f":"D98+$G$82","v":103.5},{"$f":"E98+$G$82","v":102.75}]
[null,{"$f":"'NanQ ONE Program'!B35","v":6.25},{"$f":"'NanQ ONE Program'!C35","v":106},{"$f":"'NanQ ONE Program'!D35","v":105.5},{"$f":"'NanQ ONE Program'!E35","v":104.75},null,null,25,{"$f":"B97","v":5.125},{"$f":"C97+$G$82","v":103.75},{"$f":"D97+$G$82","v":103.25},{"$f":"E97+$G$82","v":102.5}]
[null,{"$f":"'NanQ ONE Program'!B36","v":6.375},{"$f":"'NanQ ONE Program'!C36","v":106.25},{"$f":"'NanQ ONE Program'!D36","v":105.75},{"$f":"'NanQ ONE Program'!E36","v":105},null,null,26,{"$f":"B96","v":4.9989999999999997},{"$f":"C96+$G$82","v":103.5},{"$f":"D96+$G$82","v":103},{"$f":"E96+$G$82","v":102.25}]
[null,{"$f":"'NanQ ONE Program'!B37","v":6.4989999999999997},{"$f":"'NanQ ONE Program'!C37","v":106.5},{"$f":"'NanQ ONE Program'!D37","v":106},{"$f":"'NanQ ONE Program'!E37","v":105.25},null,null,27,{"$f":"B95","v":4.875},{"$f":"C95+$G$82","v":103.25},{"$f":"D95+$G$82","v":102.75},{"$f":"E95+$G$82","v":102}]
[null,{"$f":"'NanQ ONE Program'!B38","v":6.625},{"$f":"'NanQ ONE Program'!C38","v":106.75},{"$f":"'NanQ ONE Program'!D38","v":106.25},{"$f":"'NanQ ONE Program'!E38","v":105.5},null,null,28,{"$f":"B94","v":4.75},{"$f":"C94+$G$82","v":103},{"$f":"D94+$G$82","v":102.5},{"$f":"E94+$G$82","v":101.75}]
[null,{"$f":"'NanQ ONE Program'!B39","v":6.75},{"$f":"'NanQ ONE Program'!C39","v":107},{"$f":"'NanQ ONE Program'!D39","v":106.5},{"$f":"'NanQ ONE Program'!E39","v":105.75},null,null,29,{"$f":"B93","v":4.625},{"$f":"C93+$G$82","v":102.75},{"$f":"D93+$G$82","v":102.25},{"$f":"E93+$G$82","v":101.5}]
[null,{"$f":"'NanQ ONE Program'!B40","v":6.875},{"$f":"'NanQ ONE Program'!C40","v":107.25},{"$f":"'NanQ ONE Program'!D40","v":106.75},{"$f":"'NanQ ONE Program'!E40","v":106},null,null,30,{"$f":"B92","v":4.4989999999999997},{"$f":"C92+$G$82","v":102.5},{"$f":"D92+$G$82","v":102},{"$f":"E92+$G$82","v":101.25}]
[null,{"$f":"'NanQ ONE Program'!B41","v":6.9989999999999997},{"$f":"'NanQ ONE Program'!C41","v":107.5},{"$f":"'NanQ ONE Program'!D41","v":107},{"$f":"'NanQ ONE Program'!E41","v":106.25},null,null,31,{"$f":"B91","v":4.375},{"$f":"C91+$G$82","v":102.25},{"$f":"D91+$G$82","v":101.75},{"$f":"E91+$G$82","v":101}]
[null,{"$f":"'NanQ ONE Program'!B42","v":7.125},{"$f":"'NanQ ONE Program'!C42","v":107.75},{"$f":"'NanQ ONE Program'!D42","v":107.25},{"$f":"'NanQ ONE Program'!E42","v":106.5},null,null,32,{"$f":"B90","v":4.25},{"$f":"C90+$G$82","v":102},{"$f":"D90+$G$82","v":101.5},{"$f":"E90+$G$82","v":100.75}]
[null,{"$f":"'NanQ ONE Program'!B43","v":7.25},{"$f":"'NanQ ONE Program'!C43","v":108},{"$f":"'NanQ ONE Program'!D43","v":107.5},{"$f":"'NanQ ONE Program'!E43","v":106.75},null,null,33,{"$f":"B89","v":4.125},{"$f":"C89+$G$82","v":101.75},{"$f":"D89+$G$82","v":101.25},{"$f":"E89+$G$82","v":100.5}]
[null,{"$f":"'NanQ ONE Program'!B44","v":7.375},{"$f":"'NanQ ONE Program'!C44","v":108.25},{"$f":"'NanQ ONE Program'!D44","v":107.75},{"$f":"'NanQ ONE Program'!E44","v":107},null,null,34,{"$f":"B88","v":3.9990000000000001},{"$f":"C88+$G$82","v":101.5},{"$f":"D88+$G$82","v":101},{"$f":"E88+$G$82","v":100.25}]
[null,{"$f":"'NanQ ONE Program'!B45","v":7.4989999999999997},{"$f":"'NanQ ONE Program'!C45","v":108.5},{"$f":"'NanQ ONE Program'!D45","v":108},{"$f":"'NanQ ONE Program'!E45","v":107.25},null,null,35,{"$f":"B87","v":3.875},{"$f":"C87+$G$82","v":101.25},{"$f":"D87+$G$82","v":100.75},{"$f":"E87+$G$82","v":100}]
[null,{"$f":"'NanQ ONE Program'!B46","v":7.625},{"$f":"'NanQ ONE Program'!C46","v":108.75},{"$f":"'NanQ ONE Program'!D46","v":108.25},{"$f":"'NanQ ONE Program'!E46","v":107.5},null,null,36,{"$f":"B86","v":3.75},{"$f":"C86+$G$82","v":101},{"$f":"D86+$G$82","v":100.5},{"$f":"E86+$G$82","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B47","v":7.75},{"$f":"'NanQ ONE Program'!C47","v":109},{"$f":"'NanQ ONE Program'!D47","v":108.5},{"$f":"'NanQ ONE Program'!E47","v":107.75},null,null,37,{"$f":"B85","v":3.625},{"$f":"C85+$G$82","v":100.75},{"$f":"D85+$G$82","v":100.25},{"$f":"E85+$G$82","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B48","v":7.875},{"$f":"'NanQ ONE Program'!C48","v":109.25},{"$f":"'NanQ ONE Program'!D48","v":108.75},{"$f":"'NanQ ONE Program'!E48","v":108},null,null,38,{"$f":"B84","v":3.4990000000000001},{"$f":"C84+$G$82","v":100.5},{"$f":"D84+$G$82","v":100},{"$f":"E84+$G$82","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B49","v":7.9989999999999997},{"$f":"'NanQ ONE Program'!C49","v":109.5},{"$f":"'NanQ ONE Program'!D49","v":109},{"$f":"'NanQ ONE Program'!E49","v":108.25},null,null,39,{"$f":"B83","v":3.375},{"$f":"C83+$G$82","v":100.25},{"$f":"D83+$G$82","v":99.75},{"$f":"E83+$G$82","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B50","v":8.125},{"$f":"'NanQ ONE Program'!C50","v":109.75},{"$f":"'NanQ ONE Program'!D50","v":109.25},{"$f":"'NanQ ONE Program'!E50","v":108.5},null,null,40,{"$f":"B82","v":3.25},{"$f":"C82+$G$82","v":100},{"$f":"D82+$G$82","v":99.5},{"$f":"E82+$G$82","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(100,J82:J121,-1)","v":40},{"$f":"MATCH(100,K82:K121,-1)","v":38},{"$f":"MATCH(E65,L82:L121,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J122,H82:I121,2,FALSE)","v":3.25},{"$f":"VLOOKUP(K122,H82:I121,2,FALSE)","v":3.4990000000000001},{"$f":"VLOOKUP(L122,H82:L121,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Base Rate / Base Price",null,null,null,null,null,null,null,{"$f":"IF(G89=J81,J123,0)","v":0},{"$f":"IF(G89=K81,K123,0)","v":0},{"$f":"IF(G89=L81,L123,0)","v":0},{"$f":"SUM(J124:L124)","v":0}]
[null,"Coupon","Full Doc","Alt Doc","DSCR",null,"Total LLPA",null,null,{"$f":"VLOOKUP(J122,H82:J121,3,FALSE)","v":100},{"$f":"VLOOKUP(K122,H82:K121,4,FALSE)","v":100},{"$f":"VLOOKUP(L122,H82:L121,5,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"B82","v":3.25},100,99.5,{"$error":"#N/A"},null,{"$f":"'NanQ ONE Program'!V27","v":0},null,null,{"$f":"IF(G89=J81,J125,0)","v":0},{"$f":"IF(G89=K81,K125,0)","v":0},{"$f":"IF(G89=L81,L125,0)","v":0},{"$f":"SUM(J126:L126)","v":0}]
[null,3.375,100.25,99.75,{"$error":"#N/A"},null,"LPC"]
[null,3.4990000000000001,100.5,100,{"$error":"#N/A"},null,{"$f":"'NanQ ONE Program'!V33","v":0},null,"Base Rate / Base Price"]
[null,3.625,100.75,100.25,{"$error":"#N/A"},null,null,null,"Coupon","Full Doc","Alt Doc","DSCR"]
[null,3.75,101,100.5,{"$error":"#N/A"},null,"Total Price",1,{"$f":"I82","v":8.125},{"$f":"C165+$G$126-$G$128","v":109.75},{"$f":"D165+$G$126-$G$128","v":109.25},{"$f":"E165+$G$126-$G$128","v":108.5}]
[null,3.875,101.25,100.75,100,null,{"$f":"'NanQ ONE Program'!V34","v":"LPC Not Valid"},2,7.9989999999999997,{"$f":"C164+$G$126-$G$128","v":109.5},{"$f":"D164+$G$126-$G$128","v":109},{"$f":"E164+$G$126-$G$128","v":108.25}]
[null,3.9990000000000001,101.5,101,100.25,null,null,3,7.875,{"$f":"C163+$G$126-$G$128","v":109.25},{"$f":"D163+$G$126-$G$128","v":108.75},{"$f":"E163+$G$126-$G$128","v":108}]
[null,4.125,101.75,101.25,100.5,null,{"$f":"'NanQ ONE Program'!U13","v":"Choose a Selection"},4,7.75,{"$f":"C162+$G$126-$G$128","v":109},{"$f":"D162+$G$126-$G$128","v":108.5},{"$f":"E162+$G$126-$G$128","v":107.75}]
[null,4.25,102,101.5,100.75,null,null,5,7.625,{"$f":"C161+$G$126-$G$128","v":108.75},{"$f":"D161+$G$126-$G$128","v":108.25},{"$f":"E161+$G$126-$G$128","v":107.5}]
[null,4.375,102.25,101.75,101,null,null,6,7.4989999999999997,{"$f":"C160+$G$126-$G$128","v":108.5},{"$f":"D160+$G$126-$G$128","v":108},{"$f":"E160+$G$126-$G$128","v":107.25}]
[null,4.4989999999999997,102.5,102,101.25,null,null,7,7.375,{"$f":"C159+$G$126-$G$128","v":108.25},{"$f":"D159+$G$126-$G$128","v":107.75},{"$f":"E159+$G$126-$G$128","v":107}]
[null,4.625,102.75,102.25,101.5,null,null,8,7.25,{"$f":"C158+$G$126-$G$128","v":108},{"$f":"D158+$G$126-$G$128","v":107.5},{"$f":"E158+$G$126-$G$128","v":106.75}]
[null,4.75,103,102.5,101.75,null,null,9,7.125,{"$f":"C157+$G$126-$G$128","v":107.75},{"$f":"D157+$G$126-$G$128","v":107.25},{"$f":"E157+$G$126-$G$128","v":106.5}]
[null,4.875,103.25,102.75,102,null,null,10,6.9989999999999997,{"$f":"C156+$G$126-$G$128","v":107.5},{"$f":"D156+$G$126-$G$128","v":107},{"$f":"E156+$G$126-$G$128","v":106.25}]
[null,4.9989999999999997,103.5,103,102.25,null,null,11,6.875,{"$f":"C155+$G$126-$G$128","v":107.25},{"$f":"D155+$G$126-$G$128","v":106.75},{"$f":"E155+$G$126-$G$128","v":106}]
[null,5.125,103.75,103.25,102.5,null,null,12,6.75,{"$f":"C154+$G$126-$G$128","v":107},{"$f":"D154+$G$126-$G$128","v":106.5},{"$f":"E154+$G$126-$G$128","v":105.75}]
[null,5.25,104,103.5,102.75,null,null,13,6.625,{"$f":"C153+$G$126-$G$128","v":106.75},{"$f":"D153+$G$126-$G$128","v":106.25},{"$f":"E153+$G$126-$G$128","v":105.5}]
[null,5.375,104.25,103.75,103,null,null,14,6.4989999999999997,{"$f":"C152+$G$126-$G$128","v":106.5},{"$f":"D152+$G$126-$G$128","v":106},{"$f":"E152+$G$126-$G$128","v":105.25}]
[null,5.4989999999999997,104.5,104,103.25,null,null,15,6.375,{"$f":"C151+$G$126-$G$128","v":106.25},{"$f":"D151+$G$126-$G$128","v":105.75},{"$f":"E151+$G$126-$G$128","v":105}]
[null,5.625,104.75,104.25,103.5,null,null,16,6.25,{"$f":"C150+$G$126-$G$128","v":106},{"$f":"D150+$G$126-$G$128","v":105.5},{"$f":"E150+$G$126-$G$128","v":104.75}]
[null,{"$f":"B102","v":5.75},105,104.5,103.75,null,null,17,6.125,{"$f":"C149+$G$126-$G$128","v":105.75},{"$f":"D149+$G$126-$G$128","v":105.25},{"$f":"E149+$G$126-$G$128","v":104.5}]
[null,5.875,105.25,104.75,104,null,null,18,5.9989999999999997,{"$f":"C148+$G$126-$G$128","v":105.5},{"$f":"D148+$G$126-$G$128","v":105},{"$f":"E148+$G$126-$G$128","v":104.25}]
[null,5.9989999999999997,105.5,105,104.25,null,null,19,5.875,{"$f":"C147+$G$126-$G$128","v":105.25},{"$f":"D147+$G$126-$G$128","v":104.75},{"$f":"E147+$G$126-$G$128","v":104}]
[null,6.125,105.75,105.25,104.5,null,null,20,5.75,{"$f":"C146+$G$126-$G$128","v":105},{"$f":"D146+$G$126-$G$128","v":104.5},{"$f":"E146+$G$126-$G$128","v":103.75}]
[null,6.25,106,105.5,104.75,null,null,21,5.625,{"$f":"C145+$G$126-$G$128","v":104.75},{"$f":"D145+$G$126-$G$128","v":104.25},{"$f":"E145+$G$126-$G$128","v":103.5}]
[null,6.375,106.25,105.75,105,null,null,22,5.4989999999999997,{"$f":"C144+$G$126-$G$128","v":104.5},{"$f":"D144+$G$126-$G$128","v":104},{"$f":"E144+$G$126-$G$128","v":103.25}]
[null,6.4989999999999997,106.5,106,105.25,null,null,23,5.375,{"$f":"C143+$G$126-$G$128","v":104.25},{"$f":"D143+$G$126-$G$128","v":103.75},{"$f":"E143+$G$126-$G$128","v":103}]
[null,6.625,106.75,106.25,105.5,null,null,24,5.25,{"$f":"C142+$G$126-$G$128","v":104},{"$f":"D142+$G$126-$G$128","v":103.5},{"$f":"E142+$G$126-$G$128","v":102.75}]
[null,6.75,107,106.5,105.75,null,null,25,5.125,{"$f":"C141+$G$126-$G$128","v":103.75},{"$f":"D141+$G$126-$G$128","v":103.25},{"$f":"E141+$G$126-$G$128","v":102.5}]
[null,6.875,107.25,106.75,106,null,null,26,4.9989999999999997,{"$f":"C140+$G$126-$G$128","v":103.5},{"$f":"D140+$G$126-$G$128","v":103},{"$f":"E140+$G$126-$G$128","v":102.25}]
[null,6.9989999999999997,107.5,107,106.25,null,null,27,4.875,{"$f":"C139+$G$126-$G$128","v":103.25},{"$f":"D139+$G$126-$G$128","v":102.75},{"$f":"E139+$G$126-$G$128","v":102}]
[null,7.125,107.75,107.25,106.5,null,null,28,4.75,{"$f":"C138+$G$126-$G$128","v":103},{"$f":"D138+$G$126-$G$128","v":102.5},{"$f":"E138+$G$126-$G$128","v":101.75}]
[null,7.25,108,107.5,106.75,null,null,29,4.625,{"$f":"C137+$G$126-$G$128","v":102.75},{"$f":"D137+$G$126-$G$128","v":102.25},{"$f":"E137+$G$126-$G$128","v":101.5}]
[null,7.375,108.25,107.75,107,null,null,30,4.4989999999999997,{"$f":"C136+$G$126-$G$128","v":102.5},{"$f":"D136+$G$126-$G$128","v":102},{"$f":"E136+$G$126-$G$128","v":101.25}]
[null,7.4989999999999997,108.5,108,107.25,null,null,31,4.375,{"$f":"C135+$G$126-$G$128","v":102.25},{"$f":"D135+$G$126-$G$128","v":101.75},{"$f":"E135+$G$126-$G$128","v":101}]
[null,7.625,108.75,108.25,107.5,null,null,32,4.25,{"$f":"C134+$G$126-$G$128","v":102},{"$f":"D134+$G$126-$G$128","v":101.5},{"$f":"E134+$G$126-$G$128","v":100.75}]
[null,7.75,109,108.5,107.75,null,null,33,4.125,{"$f":"C133+$G$126-$G$128","v":101.75},{"$f":"D133+$G$126-$G$128","v":101.25},{"$f":"E133+$G$126-$G$128","v":100.5}]
[null,7.875,109.25,108.75,108,null,null,34,3.9990000000000001,{"$f":"C132+$G$126-$G$128","v":101.5},{"$f":"D132+$G$126-$G$128","v":101},{"$f":"E132+$G$126-$G$128","v":100.25}]
[null,7.9989999999999997,109.5,109,108.25,null,null,35,3.875,{"$f":"C131+$G$126-$G$128","v":101.25},{"$f":"D131+$G$126-$G$128","v":100.75},{"$f":"E131+$G$126-$G$128","v":100}]
[null,8.125,109.75,109.25,108.5,null,null,36,3.75,{"$f":"C130+$G$126-$G$128","v":101},{"$f":"D130+$G$126-$G$128","v":100.5},{"$f":"E130+$G$126-$G$128","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,37,3.625,{"$f":"C129+$G$126-$G$128","v":100.75},{"$f":"D129+$G$126-$G$128","v":100.25},{"$f":"E129+$G$126-$G$128","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,38,3.4990000000000001,{"$f":"C128+$G$126-$G$128","v":100.5},{"$f":"D128+$G$126-$G$128","v":100},{"$f":"E128+$G$126-$G$128","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,39,3.375,{"$f":"C127+$G$126-$G$128","v":100.25},{"$f":"D127+$G$126-$G$128","v":99.75},{"$f":"E127+$G$126-$G$128","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,40,3.25,{"$f":"C126+$G$126-$G$128","v":100},{"$f":"D126+$G$126-$G$128","v":99.5},{"$f":"E126+$G$126-$G$128","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,41,null,{"$f":"MATCH(100,J130:J169,-1)","v":40},{"$f":"MATCH(100,K130:K169,-1)","v":38},{"$f":"MATCH(100,L130:L169,-1)","v":35}]
[null,null,null,null,null,null,null,42,"Par Rates",{"$f":"VLOOKUP(J170,H130:I174,2,FALSE)","v":3.25},{"$f":"VLOOKUP(K170,H130:I174,2,FALSE)","v":3.4990000000000001},{"$f":"VLOOKUP(L170,H130:L174,2,FALSE)","v":3.875}]
[null,null,null,null,null,null,null,43,null,{"$f":"IF(G133=J129,J171,0)","v":0},{"$f":"IF(G133=K129,K171,0)","v":0},{"$f":"IF(G133=L129,L171,0)","v":0},{"$f":"SUM(J172:L172)","v":0}]
[null,null,null,null,null,null,null,44,null,{"$f":"VLOOKUP(J170,H130:J174,3,FALSE)","v":100},{"$f":"VLOOKUP(K170,H130:K174,4,FALSE)","v":100},{"$f":"VLOOKUP(L170,H130:L174,5,FALSE)","v":100}]
[null,null,null,null,null,null,null,45,null,{"$f":"IF(G133=J129,J173,0)","v":0},{"$f":"IF(G133=K129,K173,0)","v":0},{"$f":"IF(G133=L129,L173,0)","v":0},{"$f":"SUM(J174:L174)","v":0}]
[]
[]
[null,"Near Par Rate - BPC",null,{"$f":"Feed!M124","v":0},{"$f":"M126","v":0}]
[null,"Near Par Rate - BPC",null,null,{"$f":"IF(E177>'NanQ ONE Program'!V29,'NanQ ONE Program'!V29,Feed!E177)","v":0}]
[]
[null,"Near Par Rate - LPC",null,{"$f":"Feed!M172","v":0},{"$f":"Feed!M174","v":0}]
[null,"Near Par Rate - LPC",null,null,{"$f":"IF(E180>'NanQ ONE Program'!V29,'NanQ ONE Program'!V29,Feed!E180)","v":0}]

{"sheet":"Cover Page","index":2,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":true,"merged":[[44,1,44,21],[43,1,43,21],[36,2,36,3],[38,2,38,3],[36,5,36,6],[38,5,38,6],[36,8,36,9],[38,8,38,9],[38,17,38,19],[29,13,38,15],[29,2,29,3],[29,4,29,5],[30,6,30,8],[29,6,29,8],[30,2,30,3],[34,17,34,19],[13,13,13,20],[13,2,13,4],[14,3,14,4],[15,2,15,4],[16,2,16,4],[15,5,15,6],[16,5,16,6],[21,2,21,3],[21,4,21,5],[22,2,22,3],[22,4,22,5],[23,2,23,3],[23,4,23,5],[28,2,28,3],[28,4,28,5],[25,2,25,3],[27,2,27,3],[26,2,26,3],[26,4,26,5],[23,13,24,15],[11,1,11,21],[15,17,15,19],[24,17,24,19],[13,8,13,10],[14,8,16,10],[19,13,20,15],[17,13,18,15],[13,5,13,6],[18,17,18,20],[14,5,14,6],[20,17,20,19],[14,13,16,15],[19,2,19,9],[21,13,22,15],[24,2,24,3],[20,6,20,8],[20,2,20,3],[20,4,20,5],[36,17,36,19],[25,13,26,15],[27,13,28,15],[32,17,32,19],[30,17,30,19],[28,17,28,19],[26,17,26,19],[30,4,30,5],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[28,6,28,8],[24,4,24,5],[26,6,26,8],[27,6,27,8],[25,4,25,5],[27,4,27,5],[25,6,25,8]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"19000 MacArthur Boulevard, 2nd Floor"]
[null,null,null,null,null,null,null,null,null,"Irvine, CA 92612"]
[]
[]
[]
[]
[]
[null,"LoanStream Mortgage Wholesale NANQ Rate Sheet"]
[]
[null,null,"Underwriting Fee",null,null,"Relock Fee",null,null,"Mortgagee Clause",null,null,null,null,"Contact list"]
[null,null,"NANQ",1295,null,-0.25,null,null,"OCMBC, INC. ISAOA \n19000 MacArthur Blvd, Ste. 200 Irvine, CA 92612",null,null,null,null,"Corporate \nHeadquarters:",null,null,"Phone:","800-760-1833"]
[null,null,"DOC Fee - All Loans",null,null,"Extension Fee",null,null,null,null,null,null,null,null,null,null,"Email:","Inquires@LSMortgage.com"]
[null,null,79,null,null,"0.02/Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NAN-Q\n Prequals",null,null,"Phone:","Email Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:","EZQual@LSMortgage.com"]
[null,null,"Current Turn Times",null,null,null,null,null,null,null,null,null,null,"U/W Loan \nScenarios NAN-Q",null,null,"Phone:","Email Only"]
[null,null,"Stage",null,"Turn Times",null,"Department Hours",null,null,"Cutoff Time",null,null,null,null,null,null,"Email:","NANQScenario@LSMortgage.com"]
[null,null,"PreQual",null,"24-48 Hours",null,"PreQual Desk Hours: 8:00 AM-5:00 PM PST",null,null,"3:00 PM PST",null,null,null,"Submission Desk",null,null,"Phone:","Email Only"]
[null,null,"Set-up",null,"24-48 Hours",null,"Setup Desk Hours: 8:00 AM-6:00 PM PST",null,null,null,null,null,null,null,null,null,"Email:","Submissions_LS@LSMortgage.com"]
[null,null,"New Underwrite",null,"24-48 Hours",null,"Underwriting Hours: 7:00 AM-6:00 PM PST",null,null,"3:00 PM PST",null,null,null,"Lock Desk:",null,null,"Phone:","949-679-7059"]
[null,null,"Conditions Review",null,"24-48 Hours",null,"Underwriting Hours: 7:00 AM-6:00 PM PST",null,null,"3:00 PM PST",null,null,null,null,null,null,"Email:","LockDesk@LSMortgage.com"]
[null,null,"Part \"A\" QC",null,"48-72 Hours",null,"PreQual Desk Hours: 8:00 AM-5:00 PM PST",null,null,"3:30 PM PST",null,null,null,"CD Desk:",null,null,"Phone:","Email Only"]
[null,null,"Lock Desk",null,"SameDay",null,"Lock Desk Hours are: 8:30 AM - 5:00 PM PST",null,null,"5:00 PM PST",null,null,null,null,null,null,"Email:","CD@LSMortgage.com"]
[null,null,"CTC Review",null,"SameDay",null,"Underwriting Hours: 7:00 AM-6:00 PM PST",null,null,"1:00 PM PST",null,null,null,"Funding Department:",null,null,"Phone:","Email Only"]
[null,null,"CD",null,"SameDay",null,"CD Desk Hours: 7:30 AM-6:00 PM PST",null,null,"12:00 PM PST",null,null,null,null,null,null,"Email:","Funding@LSMortgage.com"]
[null,null,"DOCS",null,"SameDay",null,"DOCS Desk Hours: 7:30 AM-6:00 PM PST",null,null,"12:00 PM PST",null,null,null,"Management \nEscalations",null,null,"Name:","David Racer / Operations"]
[null,null,"Funding",null,"SameDay",null,"Funding Desk Hours: 5:30 AM-5:00 PM PST",null,null,"12:30 PM PST",null,null,null,null,null,null,"Email:","DRacer@LSMortgage.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:","Natalie Hernandez / Closing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:","NHernandez@LSMortgage.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:","Nikki Allen / Underwriting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:","NAllen@LSMortgage.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:","Adam Elway / Capital Markets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:","AElway@LSMortgage.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:","Moe Aziz / Secondary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:","MAziz@LSMortgage.com"]
[]
[]
[]
[]
[null,"RATES AND LLPAs ARE SUBJECT TO CHANGE WITHOUT NOTICE.  "]
[null,"THIS INFORMATION IS INTENDED FOR PROFESSIONAL OR BUSINESS USE ONLY.  NOT FOR CONSUMER DISTRIBUTION."]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}