{"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":66,"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":50,"n_cols":32,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,10,49,12],[45,6,45,7],[46,6,46,7],[47,6,47,7],[31,10,31,11],[40,14,40,15],[41,14,41,15],[36,14,36,15],[44,10,44,11],[36,10,36,11],[43,14,43,16],[40,10,40,11],[41,10,41,11],[42,10,42,11],[43,10,43,11],[39,10,39,12],[46,10,46,12],[39,14,39,15],[42,6,42,7],[43,6,43,7],[44,6,44,7],[48,6,48,7],[40,6,40,7],[41,6,41,7],[0,7,1,10],[27,22,27,25],[39,18,40,25],[31,18,31,20],[34,18,34,20],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[28,6,28,7],[29,6,29,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[30,6,30,7],[31,6,31,7],[28,10,28,11],[24,22,24,25],[25,22,25,23],[25,18,25,19],[21,18,21,19],[3,7,3,10],[3,13,3,16],[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],[27,6,27,7],[49,6,49,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[21,6,21,8],[10,6,10,7],[11,6,11,7],[30,22,30,25],[22,18,22,19],[23,18,23,19],[24,18,24,19],[21,22,21,25],[26,18,26,20],[27,18,27,20],[28,18,28,20],[29,18,29,20],[30,18,30,20],[28,22,28,25],[13,26,13,27],[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],[11,18,11,19],[7,18,7,19],[12,18,12,19],[22,14,22,15],[21,10,21,12],[16,26,16,28],[17,26,17,28],[19,26,19,28],[18,18,18,19],[19,18,19,19],[21,26,21,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],[22,10,22,11],[20,26,20,28],[38,21,38,24],[33,14,33,16],[34,14,34,15],[35,14,35,15],[37,14,37,15],[38,14,38,15],[0,14,1,16],[2,7,2,10],[13,23,13,25],[9,18,9,19],[10,18,10,19],[4,12,4,13],[22,6,22,7],[9,6,9,7],[5,1,6,16],[8,6,8,16],[8,18,8,19],[4,14,4,16],[13,18,13,19],[14,18,14,19],[15,18,15,19],[17,18,17,19],[8,1,8,4],[19,6,19,7],[37,10,37,11],[29,14,29,15],[30,14,30,15],[31,14,31,15],[24,14,24,15],[27,14,27,15],[28,14,28,15],[23,10,23,11],[24,10,24,11],[34,10,34,11],[29,10,29,11],[30,10,30,11],[33,10,33,12],[35,10,35,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[23,14,23,15],[25,14,25,15],[26,14,26,15],[2,14,2,16],[35,18,35,20],[35,21,35,25],[49,14,49,16],[7,22,7,25],[32,18,32,20],[33,18,33,20],[32,22,32,25],[20,22,20,25],[25,24,25,25],[26,22,26,25],[33,22,33,25],[36,18,36,20],[20,18,20,19],[22,22,23,25],[21,14,21,16],[44,14,44,15],[41,18,49,25],[11,22,11,25],[29,22,29,25],[38,18,38,20],[36,21,36,25],[37,18,37,20],[37,21,37,24]]}
[null,null,null,null,null,null,null,{"$f":"[4]Calc!DQ80","v":"LoanStream Mortgage"},null,null,null,null,null,null,{"$f":"[5]Calc!BD86","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!$DR$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!$DQ$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!DR88","v":"2021-07-22"}]
[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":"[5]!Input_Stamp_Ratesheet","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!$DM$98","v":"FICO/LTV Price Adjustments"},null,null,null,null,null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,null,"Tax Returns"]
[null,{"$f":"[4]Calc!AB94","v":"Coupon"},{"$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!DO99","v":"<=50"},{"$f":"[4]Calc!DP99","v":"50.01-60"},{"$f":"[4]Calc!DQ99","v":"60.01-65"},{"$f":"[4]Calc!DR99","v":"65.01-70"},{"$f":"[4]Calc!DS99","v":"70.01-75"},{"$f":"[4]Calc!DT99","v":"75.01-80"},{"$f":"[4]Calc!DU99","v":"80.01-85"},{"$f":"[4]Calc!DV99","v":"85.01-90"},{"$f":"[4]Calc!DW99","v":"90.01-95"},null,"LTV Range",null,null,null,null,null,null,null,"VOE Only"]
[null,{"$f":"[4]Calc!AB95","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!DM100","v":"780+"},null,{"$f":"[4]Calc!DO100","v":0},{"$f":"[4]Calc!DP100","v":0},{"$f":"[4]Calc!DQ100","v":-0.25},{"$f":"[4]Calc!DR100","v":-0.5},{"$f":"[4]Calc!DS100","v":-1},{"$f":"[4]Calc!DT100","v":-1.25},{"$f":"[4]Calc!DU100","v":-1.5},{"$f":"[4]Calc!DV100","v":-3},{"$f":"[4]Calc!DW100","v":-7.25},null,"FICO Range",null,null,{"$f":"INDEX(I11:Q20,MATCH(U11,G11:G20,0),MATCH(U10,I10:Q10))","v":{"$error":"#N/A"}},null,null,null,null,"1099 Only"]
[null,{"$f":"[4]Calc!AB96","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!DM101","v":"760-779"},null,{"$f":"[4]Calc!DO101","v":0},{"$f":"[4]Calc!DP101","v":0},{"$f":"[4]Calc!DQ101","v":-0.5},{"$f":"[4]Calc!DR101","v":-0.75},{"$f":"[4]Calc!DS101","v":-1.25},{"$f":"[4]Calc!DT101","v":-1.5},{"$f":"[4]Calc!DU101","v":-1.75},{"$f":"[4]Calc!DV101","v":-3.75},{"$f":"[4]Calc!DW101","v":-7.5},null,"Grade",null,null,{"$f":"INDEX(M23:M32,MATCH(U12,K23:K32,0))","v":{"$error":"#N/A"}},"45 Days Period Priced as 30 Day Lock",null,null,null,"Asset Utilization Only"]
[null,{"$f":"[4]Calc!AB97","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!DM102","v":"740-759"},null,{"$f":"[4]Calc!DO102","v":-0.125},{"$f":"[4]Calc!DP102","v":-0.25},{"$f":"[4]Calc!DQ102","v":-0.5},{"$f":"[4]Calc!DR102","v":-1},{"$f":"[4]Calc!DS102","v":-1.25},{"$f":"[4]Calc!DT102","v":-1.75},{"$f":"[4]Calc!DU102","v":-2},{"$f":"[4]Calc!DV102","v":-4},{"$f":"[4]Calc!DW102","v":-7.75},null,"Doc Type",null,null,null,null,null,null,null,"Asset Utilization W/ Full Doc"]
[null,{"$f":"[4]Calc!AB98","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!DM103","v":"720-739"},null,{"$f":"[4]Calc!DO103","v":-0.25},{"$f":"[4]Calc!DP103","v":-0.25},{"$f":"[4]Calc!DQ103","v":-0.75},{"$f":"[4]Calc!DR103","v":-1.25},{"$f":"[4]Calc!DS103","v":-1.5},{"$f":"[4]Calc!DT103","v":-1.75},{"$f":"[4]Calc!DU103","v":-2.5},{"$f":"[4]Calc!DV103","v":-4.75},{"$f":"[4]Calc!DW103","v":-8.25},null,"Additional Adjs",null,null,{"$f":"IF(U14=\"None of the Above\",0,IF(U14=\"12 Month Full / Alt Doc\",0,INDEX(I$24:I$49,MATCH(U14,G$24:G$49,0))))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB99","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!DM104","v":"700-719"},null,{"$f":"[4]Calc!DO104","v":-0.625},{"$f":"[4]Calc!DP104","v":-1},{"$f":"[4]Calc!DQ104","v":-1.25},{"$f":"[4]Calc!DR104","v":-1.5},{"$f":"[4]Calc!DS104","v":-2},{"$f":"[4]Calc!DT104","v":-2.5},{"$f":"[4]Calc!DU104","v":-2.875},{"$f":"[4]Calc!DV104","v":-5.5},{"$f":"[4]Calc!DW104","v":{"$error":"#N/A"}},null,"Citizenships",null,null,{"$f":"IF(U15=\"US Citizen\",0,IF(U15=\"Permanent Resident\",0,IF(U15=\"Non Perm Resident\",0,INDEX(I$24:I$49,MATCH(U15,G$24:G$49,0)))))","v":{"$error":"#N/A"}},null,null,null,null,"Alt Doc Column Includes"]
[null,{"$f":"[4]Calc!AB100","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!DM105","v":"680-699"},null,{"$f":"[4]Calc!DO105","v":-0.875},{"$f":"[4]Calc!DP105","v":-1.25},{"$f":"[4]Calc!DQ105","v":-1.5},{"$f":"[4]Calc!DR105","v":-2},{"$f":"[4]Calc!DS105","v":-2.5},{"$f":"[4]Calc!DT105","v":-2.75},{"$f":"[4]Calc!DU105","v":-3.5},{"$f":"[4]Calc!DV105","v":-6.5},{"$f":"[4]Calc!DW105","v":{"$error":"#N/A"}},null,"DTI",null,null,{"$f":"IF(U16=\"DTI <50% - All Doc Types\",0,IF(U16=\"No DTI Program\",0,INDEX(I$24:I$49,MATCH(U16,G$24:G$49,0))))","v":{"$error":"#N/A"}},"Please reach out to the Lock Desk to Price Loans >5MM",null,null,null,"12 or 24 Bank Statements"]
[null,{"$f":"[4]Calc!AB101","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!DM106","v":"660-679"},null,{"$f":"[4]Calc!DO106","v":-1.25},{"$f":"[4]Calc!DP106","v":-2},{"$f":"[4]Calc!DQ106","v":-2.25},{"$f":"[4]Calc!DR106","v":-2.75},{"$f":"[4]Calc!DS106","v":-3.25},{"$f":"[4]Calc!DT106","v":-3.5},{"$f":"[4]Calc!DU106","v":-4.25},{"$f":"[4]Calc!DV106","v":-8},{"$f":"[4]Calc!DW106","v":{"$error":"#N/A"}},null,"Loan Balance",null,null,{"$f":"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$49,MATCH(U17,G$24:G$49,0))))","v":{"$error":"#N/A"}},null,null,null,null,"12 or 24 CPA P&L"]
[null,{"$f":"[4]Calc!AB102","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!DM107","v":"640-659"},null,{"$f":"[4]Calc!DO107","v":-1.625},{"$f":"[4]Calc!DP107","v":-2.25},{"$f":"[4]Calc!DQ107","v":-2.5},{"$f":"[4]Calc!DR107","v":-3},{"$f":"[4]Calc!DS107","v":-3.5},{"$f":"[4]Calc!DT107","v":-4},{"$f":"[4]Calc!DU107","v":-6.75},{"$f":"[4]Calc!DV107","v":-8.5},{"$f":"[4]Calc!DW107","v":{"$error":"#N/A"}},null,"Purpose",null,null,{"$f":"IF(OR(U18=\"Purchase\",U18=\"Rate/Term Refi\"),0,IF(U18=\"Debt Consol. ≤70% LTV\",0,IF(U18=\"Cash-out ≤70% LTV\",0,INDEX(I$24:I$49,MATCH(U18,G$24:G$49,0)))))","v":{"$error":"#N/A"}},"Cashout must be for business purpose only",null,null,null,"Asset Utlization W/ Bank Stmt"]
[null,{"$f":"[4]Calc!AB103","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!DM108","v":"620-639"},null,{"$f":"[4]Calc!DO108","v":-1.875},{"$f":"[4]Calc!DP108","v":-2.5},{"$f":"[4]Calc!DQ108","v":-3},{"$f":"[4]Calc!DR108","v":-3.5},{"$f":"[4]Calc!DS108","v":-4},{"$f":"[4]Calc!DT108","v":-4.25},{"$f":"[4]Calc!DU108","v":-8.5},{"$f":"[4]Calc!DV108","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DW108","v":{"$error":"#N/A"}},null,"Occupancy",null,null,{"$f":"IF(OR(U19=\"Primary\"),0,IF(OR(U19=\"Non-Owner (DSCR/No Ratio)\"),0,INDEX(I$24:I$49,MATCH(U19,G$24:G$49,0))))","v":{"$error":"#N/A"}},{"$f":"IF(U19=\"Non-Owner (N/A DSCR)\",AF33,IF(U19=\"Non-Owner (DSCR/No Ratio)\",AF32,\"\"))","v":""}]
[null,{"$f":"[4]Calc!AB104","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!DM109","v":"600-619"},null,{"$f":"[4]Calc!DO109","v":-2.625},{"$f":"[4]Calc!DP109","v":-3.25},{"$f":"[4]Calc!DQ109","v":-3.75},{"$f":"[4]Calc!DR109","v":-4.25},{"$f":"[4]Calc!DS109","v":-6.25},{"$f":"[4]Calc!DT109","v":-7.75},{"$f":"[4]Calc!DU109","v":-9},{"$f":"[4]Calc!DV109","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DW109","v":{"$error":"#N/A"}},null,"Property Type",null,null,{"$f":"IF(OR(U20=\"SFR\",U20=\"1-2 Units\",U20=\"PUD\",U20=\"Condo\"),0,INDEX(I$24:I$49,MATCH(U20,G$24:G$49,0)))","v":{"$error":"#N/A"}},null,null,null,null,"DSCR/No Ratio Column Includes"]
[null,{"$f":"[4]Calc!AB105","v":4.4989999999999997},{"$f":"[4]Calc!AC105","v":102.5},{"$f":"[4]Calc!AD105","v":102},{"$f":"[4]Calc!AE105","v":101.25},null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan Term",null,null,{"$f":"INDEX(Q23:Q32,MATCH(U21,O23:O32,0))","v":{"$error":"#N/A"}},"*TX Cash-out Min Ln Amt $250,000*",null,null,null,"DSCR"]
[null,{"$f":"[4]Calc!AB106","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,{"$f":"[4]Calc!$DM$111","v":"Loan Level Price Adjustments"},null,null,null,{"$f":"[4]Calc!DQ111","v":"Grades"},null,null,null,{"$f":"[4]Calc!DQ122","v":"Loan Term"},null,null,null,"Escrow",null,"Escrow Not Waived",{"$f":"IF(U22=\"Escrow Not Waived\",0,INDEX(I$24:I$49,MATCH(U22,G$24:G$49,0)))","v":0},"Impounds Required On HPML Loans, Ask Your AM",null,null,null,"No Ratio"]
[null,{"$f":"[4]Calc!AB107","v":4.75},{"$f":"[4]Calc!AC107","v":103},{"$f":"[4]Calc!AD107","v":102.5},{"$f":"[4]Calc!AE107","v":101.75},null,null,null,{"$f":"[5]Calc!$CA107","v":"LLPA"},null,{"$f":"[4]Calc!DQ112","v":"Select - Standard"},null,{"$f":"[4]Calc!DS112","v":0.5},null,{"$f":"[4]Calc!DQ123","v":"5/1 30YR ARM"},null,{"$f":"[4]Calc!DS123","v":0},null,"Prepayment Penalty",null,"No PPP \"See PPP Section\"",{"$f":"IF(OR(U19=\"Primary\",U19=\"Second Home\"),0,INDEX(I$24:I$49,MATCH(U23,G$24:G$49,0)))","v":-2},"Due to state statutes, LSM does not allow ARM loans in New Mexico"]
[null,{"$f":"[4]Calc!AB108","v":4.875},{"$f":"[4]Calc!AC108","v":103.25},{"$f":"[4]Calc!AD108","v":102.75},{"$f":"[4]Calc!AE108","v":102},null,{"$f":"[4]Calc!DM113","v":"DTI ≥50% - All Doc Types"},null,{"$f":"[4]Calc!DP113","v":-0.25},null,{"$f":"[4]Calc!DQ113","v":"A+"},null,{"$f":"[4]Calc!DS113","v":0.25},null,{"$f":"[4]Calc!DQ124","v":"5/1 30YR IO ARM"},null,{"$f":"[4]Calc!DS124","v":-0.125},null,"State",null,"All Other States",0]
[null,{"$f":"[4]Calc!AB109","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!DM114","v":"Non-Owner (N/A DSCR)"},null,{"$f":"[4]Calc!DP114","v":-1},null,{"$f":"[4]Calc!DQ114","v":"A"},null,{"$f":"[4]Calc!DS114","v":-1},null,{"$f":"[4]Calc!DQ125","v":"5/1 40YR IO ARM"},null,{"$f":"[4]Calc!DS125","v":-0.25},null,"Lock Term",null,"30 Day",{"$f":"INDEX(M41:M45,MATCH(U25,K41:K45,0))","v":0},"UW Fee Buyout Calculator"]
[null,{"$f":"[4]Calc!AB110","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!DM115","v":"ITIN"},null,{"$f":"[4]Calc!DP115","v":-1.5},null,{"$f":"[4]Calc!DQ115","v":"B"},null,{"$f":"[4]Calc!DS115","v":-2},null,{"$f":"[4]Calc!DQ126","v":"7/1 30YR ARM"},null,{"$f":"[4]Calc!DS126","v":-0.125},null,"Purchase Special",null,"No",{"$f":"IF(U26=\"Yes\",I50,\"0.000\")","v":"0.000"},"Loan Amount →",null,0,null,null,null,null,"Minimum rate rule",{"$f":"IF(U9>4.74,0,1)","v":1}]
[null,{"$f":"[4]Calc!AB111","v":5.25},{"$f":"[4]Calc!AC111","v":104},{"$f":"[4]Calc!AD111","v":103.5},{"$f":"[4]Calc!AE111","v":102.75},null,{"$f":"[4]Calc!DM116","v":"VOE Only"},null,{"$f":"[4]Calc!DP116","v":-1},null,{"$f":"[4]Calc!DQ116","v":"B-"},null,{"$f":"[4]Calc!DS116","v":-2.5},null,{"$f":"[4]Calc!DQ127","v":"7/1 30YR IO ARM"},null,{"$f":"[4]Calc!DS127","v":-0.25},null,"  Total LLPA",null,null,{"$f":"SUM(V11:V26)","v":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB112","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!DM117","v":"1099 Only"},null,{"$f":"[4]Calc!DP117","v":-1},null,{"$f":"[4]Calc!DQ117","v":"C"},null,{"$f":"[4]Calc!DS117","v":-3},null,{"$f":"[4]Calc!DQ128","v":"7/1 40YR IO ARM"},null,{"$f":"[4]Calc!DS128","v":-0.375},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!AB113","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!DM118","v":"Asset Utilization"},null,{"$f":"[4]Calc!DP118","v":-1},null,{"$f":"[4]Calc!DQ118","v":"Select - DSCR"},null,{"$f":"[4]Calc!DS118","v":0.5},null,{"$f":"[4]Calc!DQ129","v":"15YR Fixed"},null,{"$f":"[4]Calc!DS129","v":0},null,"  Max YSP",null,null,{"$f":"Feed!E57","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!AB114","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!DM119","v":"Debt Consol. >70% LTV"},null,{"$f":"[4]Calc!DP119","v":-0.25},null,{"$f":"[4]Calc!DQ119","v":"DSCR (≥1.00)"},null,{"$f":"[4]Calc!DS119","v":0.25},null,{"$f":"[4]Calc!DQ130","v":"30YR Fixed"},null,{"$f":"[4]Calc!DS130","v":-0.25},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!AB115","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!DM120","v":"Cash-Out >70% LTV"},null,{"$f":"[4]Calc!DP120","v":-0.375},null,{"$f":"[4]Calc!DQ120","v":"No Ratio (0.75-0.99)"},null,{"$f":"[4]Calc!DS120","v":-1},null,{"$f":"[4]Calc!DQ131","v":"30YR IO Fixed"},null,{"$f":"[4]Calc!DS131","v":-0.375},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!B169,\" \",Feed!D169,\"%\" &\" @ \"&Feed!E169)","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!AB116","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!DM121","v":"3-4 Units"},null,{"$f":"[4]Calc!DP121","v":-0.5},null,{"$f":"[4]Calc!DQ121","v":"No Ratio (<0.75)"},null,{"$f":"[4]Calc!DS121","v":-2},null,{"$f":"[4]Calc!DQ132","v":"40YR IO Fixed"},null,{"$f":"[4]Calc!DS132","v":-0.5},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!AB117","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!DM122","v":"Second Home"},null,{"$f":"[4]Calc!DP122","v":-1},null,null,null,null,null,null,null,null,null,"  Lender Paid Comp Plan Amount (LPC)",null,null,null,null,null,null,null,null,null,null,null,null,"You have Selected Income Qualifing Inv Loan"]
[null,{"$f":"[4]Calc!AB118","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!DM123","v":"DSCR <680 OR >75 LTV"},null,{"$f":"[4]Calc!DP123","v":-0.5},null,{"$f":"[4]Calc!$DT$111","v":"Margins"},null,null,null,"Max Price",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!B172,\" \",Feed!D172,\"%\"&\" @ \"&Feed!E172))","v":"LPC is Blank"}]
[null,{"$f":"[4]Calc!AB119","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!DM124","v":"No PPP \"See PPP Section\""},null,{"$f":"[4]Calc!DP124","v":-2},null,{"$f":"[4]Calc!DT112","v":"Occupancy"},null,{"$f":"[4]Calc!DW112","v":"Margin"},null,"Owner Occ/Sec Home",null,102,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!AB120","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!DM125","v":"6 Months PPP"},null,{"$f":"[4]Calc!DP125","v":-1.75},null,{"$f":"[4]Calc!DT113","v":"Primary Home"},null,{"$f":"[4]Calc!DW113","v":3},null,"Loans W/ No PPP",null,100,null,"Loan Number",null,null,"Borrower Name"]
[null,{"$f":"[4]Calc!AB121","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!DM126","v":"12 Months PPP"},null,{"$f":"[4]Calc!DP126","v":-1},null,{"$f":"[4]Calc!DT114","v":"Second Home"},null,{"$f":"[4]Calc!DW114","v":3},null,"Loans W/ 6 Month PPP",null,100]
[null,{"$f":"[4]Calc!AB122","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!DM127","v":"24 Months PPP"},null,{"$f":"[4]Calc!DP127","v":-0.5},null,{"$f":"[4]Calc!DT115","v":"Investment Home"},null,{"$f":"[4]Calc!DW115","v":5},null,"Loans W/ 1YR PPP",null,101,null,"Property Address",null,null,"Compensation Type",null,null,null,"Comp?"]
[null,{"$f":"[4]Calc!AB123","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!DM128","v":"36 Months PPP"},null,{"$f":"[4]Calc!DP128","v":0},null,null,null,null,null,"Loans W/ 2YR PPP",null,101.5]
[null,{"$f":"[4]Calc!AB124","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!DM129","v":"48 Months PPP"},null,{"$f":"[4]Calc!DP129","v":0.25},null,{"$f":"[4]Calc!$DT$116","v":"Lock Days"},null,null,null,"Loans W/ 3YR PPP",null,102]
[null,{"$f":"[4]Calc!AB125","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!DM130","v":"60 Months PPP"},null,{"$f":"[4]Calc!DP130","v":0.5},null,{"$f":"[4]Calc!DT117","v":"15 Day"},null,{"$f":"[4]Calc!DV117","v":0.15},null,"Loans W/ 4YR PPP",null,102.5,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"[4]Calc!AB126","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!DM131","v":"Escrow Waived"},null,{"$f":"[4]Calc!DP131","v":-0.25},null,{"$f":"[4]Calc!DT118","v":"30 Day"},null,{"$f":"[4]Calc!DV118","v":0},null,"Loans W/ 5YR PPP",null,103,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!AB127","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!DM132","v":"NW Condo"},null,{"$f":"[4]Calc!DP132","v":-1},null,{"$f":"[4]Calc!DT119","v":"45 Day"},null,{"$f":"[4]Calc!DV119","v":0}]
[null,{"$f":"[4]Calc!AB128","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!DM133","v":"<$150,000"},null,{"$f":"[4]Calc!DP133","v":-1},null,{"$f":"[4]Calc!DT120","v":"60 Day"},null,{"$f":"[4]Calc!DV120","v":-0.375},null,"Extension Cost"]
[null,{"$f":"[4]Calc!AB129","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!DM134","v":"$150,000-$1,000,000"},null,{"$f":"[4]Calc!DP134","v":0},null,{"$f":"[4]Calc!DT121","v":"75 Day"},null,{"$f":"[4]Calc!DV121","v":-0.625},null,"2 Bps (0.020)",null,"Per Day"]
[null,{"$f":"[4]Calc!AB130","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!DM135","v":">$1,000,000"},null,{"$f":"[4]Calc!DP135","v":0}]
[null,{"$f":"[4]Calc!AB131","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!DM136","v":">$1,500,000"},null,{"$f":"[4]Calc!DP136","v":0},null,{"$f":"[4]Calc!$DQ$135","v":"Minimum Rates by Doc Type"},null,null,null,"Loan Term","Caps","Index"]
[null,{"$f":"[4]Calc!AB132","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!DM137","v":">$2,000,000"},null,{"$f":"[4]Calc!DP137","v":-0.5},null,{"$f":"[4]Calc!DQ136","v":"Full Doc"},{"$f":"[4]Calc!DR136","v":"Alt Doc"},{"$f":"[4]Calc!DS136","v":"DSCR"},null,{"$f":"[4]Calc!$DT$132","v":"5/6 ARM"},{"$f":"[4]Calc!$DU$132","v":"5/2/5"},{"$f":"[4]Calc!$DW$132","v":"6mo SOFR"}]
[null,{"$f":"[4]Calc!AB133","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!DM138","v":">$3,000,000"},null,{"$f":"[4]Calc!DP138","v":-0.75},null,3.2500000000000001E-2,3.2500000000000001E-2,3.875E-2,null,{"$f":"[4]Calc!$DT$133","v":"7/6 ARM"},{"$f":"[4]Calc!$DU$133","v":"5/2/5"},{"$f":"[4]Calc!$DW$133","v":"6mo SOFR"}]
[null,{"$f":"[4]Calc!AB134","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!DM139","v":"Purchase Special"},null,{"$f":"[4]Calc!DP139","v":0.5},null,"2:1 Buydown",null,null,null,"Floor = Rate"]

{"sheet":"Feed","index":1,"n_rows":173,"n_cols":30,"rows_kept":173,"cut":false,"hidden":true,"merged":[[38,2,38,7],[172,1,172,2],[171,1,171,2],[168,1,168,2],[52,7,52,8],[71,1,71,4],[71,8,71,11],[115,1,115,4],[119,8,119,11],[169,1,169,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","*Purchase Special*",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 of the Above","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","Yes",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","No",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",null,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 <680 OR >75 LTV",null,">$2,000,000","36 Months PPP",null,"Cash-Out ≤70% LTV","NW Condo",null,"7/1 30YR IO ARM","75 Day",null,null,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,null,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,null,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,null,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,null,null,null,"40YR IO Fixed",null,null,null,null,null,null,null,"Texas","Y",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,"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,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,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,null,null,null,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,null,null,null,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,null,null,null,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,null,null,null,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,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,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,0,2000000.01,102,{"$f":"IF(AND($C$58>B52,$C$58<C52),D52,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$58>B53,$C$58<C53),D53,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(E52:E54)","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(C41:H47,MATCH(B60,B41:B47,0),MATCH(B58,C40:H40,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(B59=\"Primary\",B59=\"Second Home\"),E55,IF(OR(B59=\"Non-Owner (N/A DSCR)\",B59=\"Non-Owner (DSCR/No Ratio)\"),E56,\"ERROR\"))","v":"ERROR"},null,"Non-Owner (N/A DSCR)"]
[null,{"$f":"'NanQ ONE Program'!U17","v":0},{"$f":"VLOOKUP(B58,E27:F32,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Non-Owner (N/A DSCR)"]
[null,{"$f":"'NanQ ONE Program'!U19","v":0}]
[null,{"$f":"'NanQ ONE Program'!U23","v":"No PPP \"See PPP Section\""}]
[]
[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":{"$error":"#N/A"}},1,{"$f":"B113","v":8.125},{"$f":"C113+$G$74","v":{"$error":"#N/A"}},{"$f":"D113+$G$74","v":{"$error":"#N/A"}},{"$f":"E113+$G$74","v":{"$error":"#N/A"}}]
[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":"B112","v":7.9989999999999997},{"$f":"C112+$G$74","v":{"$error":"#N/A"}},{"$f":"D112+$G$74","v":{"$error":"#N/A"}},{"$f":"E112+$G$74","v":{"$error":"#N/A"}}]
[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":"B111","v":7.875},{"$f":"C111+$G$74","v":{"$error":"#N/A"}},{"$f":"D111+$G$74","v":{"$error":"#N/A"}},{"$f":"E111+$G$74","v":{"$error":"#N/A"}}]
[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":"B110","v":7.75},{"$f":"C110+$G$74","v":{"$error":"#N/A"}},{"$f":"D110+$G$74","v":{"$error":"#N/A"}},{"$f":"E110+$G$74","v":{"$error":"#N/A"}}]
[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":"B109","v":7.625},{"$f":"C109+$G$74","v":{"$error":"#N/A"}},{"$f":"D109+$G$74","v":{"$error":"#N/A"}},{"$f":"E109+$G$74","v":{"$error":"#N/A"}}]
[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":"B108","v":7.4989999999999997},{"$f":"C108+$G$74","v":{"$error":"#N/A"}},{"$f":"D108+$G$74","v":{"$error":"#N/A"}},{"$f":"E108+$G$74","v":{"$error":"#N/A"}}]
[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":"B107","v":7.375},{"$f":"C107+$G$74","v":{"$error":"#N/A"}},{"$f":"D107+$G$74","v":{"$error":"#N/A"}},{"$f":"E107+$G$74","v":{"$error":"#N/A"}}]
[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":0},8,{"$f":"B106","v":7.25},{"$f":"C106+$G$74","v":{"$error":"#N/A"}},{"$f":"D106+$G$74","v":{"$error":"#N/A"}},{"$f":"E106+$G$74","v":{"$error":"#N/A"}}]
[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":"B105","v":7.125},{"$f":"C105+$G$74","v":{"$error":"#N/A"}},{"$f":"D105+$G$74","v":{"$error":"#N/A"}},{"$f":"E105+$G$74","v":{"$error":"#N/A"}}]
[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":"B104","v":6.9989999999999997},{"$f":"C104+$G$74","v":{"$error":"#N/A"}},{"$f":"D104+$G$74","v":{"$error":"#N/A"}},{"$f":"E104+$G$74","v":{"$error":"#N/A"}}]
[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":"B103","v":6.875},{"$f":"C103+$G$74","v":{"$error":"#N/A"}},{"$f":"D103+$G$74","v":{"$error":"#N/A"}},{"$f":"E103+$G$74","v":{"$error":"#N/A"}}]
[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":"B102","v":6.75},{"$f":"C102+$G$74","v":{"$error":"#N/A"}},{"$f":"D102+$G$74","v":{"$error":"#N/A"}},{"$f":"E102+$G$74","v":{"$error":"#N/A"}}]
[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":"B101","v":6.625},{"$f":"C101+$G$74","v":{"$error":"#N/A"}},{"$f":"D101+$G$74","v":{"$error":"#N/A"}},{"$f":"E101+$G$74","v":{"$error":"#N/A"}}]
[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":"B100","v":6.4989999999999997},{"$f":"C100+$G$74","v":{"$error":"#N/A"}},{"$f":"D100+$G$74","v":{"$error":"#N/A"}},{"$f":"E100+$G$74","v":{"$error":"#N/A"}}]
[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":"B99","v":6.375},{"$f":"C99+$G$74","v":{"$error":"#N/A"}},{"$f":"D99+$G$74","v":{"$error":"#N/A"}},{"$f":"E99+$G$74","v":{"$error":"#N/A"}}]
[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":"B98","v":6.25},{"$f":"C98+$G$74","v":{"$error":"#N/A"}},{"$f":"D98+$G$74","v":{"$error":"#N/A"}},{"$f":"E98+$G$74","v":{"$error":"#N/A"}}]
[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":"B97","v":6.125},{"$f":"C97+$G$74","v":{"$error":"#N/A"}},{"$f":"D97+$G$74","v":{"$error":"#N/A"}},{"$f":"E97+$G$74","v":{"$error":"#N/A"}}]
[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":"B96","v":5.9989999999999997},{"$f":"C96+$G$74","v":{"$error":"#N/A"}},{"$f":"D96+$G$74","v":{"$error":"#N/A"}},{"$f":"E96+$G$74","v":{"$error":"#N/A"}}]
[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":"B95","v":5.875},{"$f":"C95+$G$74","v":{"$error":"#N/A"}},{"$f":"D95+$G$74","v":{"$error":"#N/A"}},{"$f":"E95+$G$74","v":{"$error":"#N/A"}}]
[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":"B94","v":5.75},{"$f":"C94+$G$74","v":{"$error":"#N/A"}},{"$f":"D94+$G$74","v":{"$error":"#N/A"}},{"$f":"E94+$G$74","v":{"$error":"#N/A"}}]
[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":"B93","v":5.625},{"$f":"C93+$G$74","v":{"$error":"#N/A"}},{"$f":"D93+$G$74","v":{"$error":"#N/A"}},{"$f":"E93+$G$74","v":{"$error":"#N/A"}}]
[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":"B92","v":5.4989999999999997},{"$f":"C92+$G$74","v":{"$error":"#N/A"}},{"$f":"D92+$G$74","v":{"$error":"#N/A"}},{"$f":"E92+$G$74","v":{"$error":"#N/A"}}]
[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":"B91","v":5.375},{"$f":"C91+$G$74","v":{"$error":"#N/A"}},{"$f":"D91+$G$74","v":{"$error":"#N/A"}},{"$f":"E91+$G$74","v":{"$error":"#N/A"}}]
[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":"B90","v":5.25},{"$f":"C90+$G$74","v":{"$error":"#N/A"}},{"$f":"D90+$G$74","v":{"$error":"#N/A"}},{"$f":"E90+$G$74","v":{"$error":"#N/A"}}]
[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":"B89","v":5.125},{"$f":"C89+$G$74","v":{"$error":"#N/A"}},{"$f":"D89+$G$74","v":{"$error":"#N/A"}},{"$f":"E89+$G$74","v":{"$error":"#N/A"}}]
[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":"B88","v":4.9989999999999997},{"$f":"C88+$G$74","v":{"$error":"#N/A"}},{"$f":"D88+$G$74","v":{"$error":"#N/A"}},{"$f":"E88+$G$74","v":{"$error":"#N/A"}}]
[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":"B87","v":4.875},{"$f":"C87+$G$74","v":{"$error":"#N/A"}},{"$f":"D87+$G$74","v":{"$error":"#N/A"}},{"$f":"E87+$G$74","v":{"$error":"#N/A"}}]
[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":"B86","v":4.75},{"$f":"C86+$G$74","v":{"$error":"#N/A"}},{"$f":"D86+$G$74","v":{"$error":"#N/A"}},{"$f":"E86+$G$74","v":{"$error":"#N/A"}}]
[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":"B85","v":4.625},{"$f":"C85+$G$74","v":{"$error":"#N/A"}},{"$f":"D85+$G$74","v":{"$error":"#N/A"}},{"$f":"E85+$G$74","v":{"$error":"#N/A"}}]
[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":"B84","v":4.4989999999999997},{"$f":"C84+$G$74","v":{"$error":"#N/A"}},{"$f":"D84+$G$74","v":{"$error":"#N/A"}},{"$f":"E84+$G$74","v":{"$error":"#N/A"}}]
[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":"B83","v":4.375},{"$f":"C83+$G$74","v":{"$error":"#N/A"}},{"$f":"D83+$G$74","v":{"$error":"#N/A"}},{"$f":"E83+$G$74","v":{"$error":"#N/A"}}]
[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":"B82","v":4.25},{"$f":"C82+$G$74","v":{"$error":"#N/A"}},{"$f":"D82+$G$74","v":{"$error":"#N/A"}},{"$f":"E82+$G$74","v":{"$error":"#N/A"}}]
[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":"B81","v":4.125},{"$f":"C81+$G$74","v":{"$error":"#N/A"}},{"$f":"D81+$G$74","v":{"$error":"#N/A"}},{"$f":"E81+$G$74","v":{"$error":"#N/A"}}]
[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":"B80","v":3.9990000000000001},{"$f":"C80+$G$74","v":{"$error":"#N/A"}},{"$f":"D80+$G$74","v":{"$error":"#N/A"}},{"$f":"E80+$G$74","v":{"$error":"#N/A"}}]
[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":"B79","v":3.875},{"$f":"C79+$G$74","v":{"$error":"#N/A"}},{"$f":"D79+$G$74","v":{"$error":"#N/A"}},{"$f":"E79+$G$74","v":{"$error":"#N/A"}}]
[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":"B78","v":3.75},{"$f":"C78+$G$74","v":{"$error":"#N/A"}},{"$f":"D78+$G$74","v":{"$error":"#N/A"}},{"$f":"E78+$G$74","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":"B77","v":3.625},{"$f":"C77+$G$74","v":{"$error":"#N/A"}},{"$f":"D77+$G$74","v":{"$error":"#N/A"}},{"$f":"E77+$G$74","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":"B76","v":3.4990000000000001},{"$f":"C76+$G$74","v":{"$error":"#N/A"}},{"$f":"D76+$G$74","v":{"$error":"#N/A"}},{"$f":"E76+$G$74","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":"B75","v":3.375},{"$f":"C75+$G$74","v":{"$error":"#N/A"}},{"$f":"D75+$G$74","v":{"$error":"#N/A"}},{"$f":"E75+$G$74","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":"B74","v":3.25},{"$f":"C74+$G$74","v":{"$error":"#N/A"}},{"$f":"D74+$G$74","v":{"$error":"#N/A"}},{"$f":"E74+$G$74","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(100,J74:J113,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K74:K113,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L74:L113,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J114,H74:I113,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K114,H74:I113,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L114,H74:L113,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Base Rate / Base Price",null,null,null,null,null,null,null,{"$f":"IF(G81=J73,J115,0)","v":0},{"$f":"IF(G81=K73,K115,0)","v":0},{"$f":"IF(G81=L73,L115,0)","v":0},{"$f":"SUM(J116:L116)","v":0}]
[null,"Coupon","Full Doc","Alt Doc","DSCR",null,"Total LLPA",null,null,{"$f":"VLOOKUP(J114,H74:J113,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K114,H74:K113,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L114,H74:L113,5,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"B74","v":3.25},100,99.5,{"$error":"#N/A"},null,{"$f":"'NanQ ONE Program'!V27","v":{"$error":"#N/A"}},null,null,{"$f":"IF(G81=J73,J117,0)","v":0},{"$f":"IF(G81=K73,K117,0)","v":0},{"$f":"IF(G81=L73,L117,0)","v":0},{"$f":"SUM(J118:L118)","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":"I74","v":8.125},{"$f":"C157+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D157+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E157+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,3.875,101.25,100.75,100,null,{"$f":"'NanQ ONE Program'!V34","v":"LPC Not Valid"},2,7.9989999999999997,{"$f":"C156+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D156+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E156+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,3.9990000000000001,101.5,101,100.25,null,null,3,7.875,{"$f":"C155+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D155+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E155+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.125,101.75,101.25,100.5,null,{"$f":"'NanQ ONE Program'!U13","v":0},4,7.75,{"$f":"C154+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D154+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E154+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.25,102,101.5,100.75,null,null,5,7.625,{"$f":"C153+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D153+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E153+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.375,102.25,101.75,101,null,null,6,7.4989999999999997,{"$f":"C152+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D152+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E152+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.4989999999999997,102.5,102,101.25,null,null,7,7.375,{"$f":"C151+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D151+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E151+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.625,102.75,102.25,101.5,null,null,8,7.25,{"$f":"C150+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D150+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E150+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.75,103,102.5,101.75,null,null,9,7.125,{"$f":"C149+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D149+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E149+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.875,103.25,102.75,102,null,null,10,6.9989999999999997,{"$f":"C148+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D148+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E148+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,4.9989999999999997,103.5,103,102.25,null,null,11,6.875,{"$f":"C147+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D147+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E147+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.125,103.75,103.25,102.5,null,null,12,6.75,{"$f":"C146+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D146+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E146+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.25,104,103.5,102.75,null,null,13,6.625,{"$f":"C145+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D145+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E145+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.375,104.25,103.75,103,null,null,14,6.4989999999999997,{"$f":"C144+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D144+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E144+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.4989999999999997,104.5,104,103.25,null,null,15,6.375,{"$f":"C143+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D143+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E143+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.625,104.75,104.25,103.5,null,null,16,6.25,{"$f":"C142+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D142+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E142+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,{"$f":"B94","v":5.75},105,104.5,103.75,null,null,17,6.125,{"$f":"C141+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D141+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E141+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.875,105.25,104.75,104,null,null,18,5.9989999999999997,{"$f":"C140+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D140+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E140+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,5.9989999999999997,105.5,105,104.25,null,null,19,5.875,{"$f":"C139+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D139+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E139+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.125,105.75,105.25,104.5,null,null,20,5.75,{"$f":"C138+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D138+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E138+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.25,106,105.5,104.75,null,null,21,5.625,{"$f":"C137+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D137+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E137+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.375,106.25,105.75,105,null,null,22,5.4989999999999997,{"$f":"C136+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D136+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E136+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.4989999999999997,106.5,106,105.25,null,null,23,5.375,{"$f":"C135+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D135+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E135+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.625,106.75,106.25,105.5,null,null,24,5.25,{"$f":"C134+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D134+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E134+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.75,107,106.5,105.75,null,null,25,5.125,{"$f":"C133+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D133+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E133+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.875,107.25,106.75,106,null,null,26,4.9989999999999997,{"$f":"C132+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D132+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E132+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,6.9989999999999997,107.5,107,106.25,null,null,27,4.875,{"$f":"C131+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D131+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E131+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.125,107.75,107.25,106.5,null,null,28,4.75,{"$f":"C130+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D130+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E130+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.25,108,107.5,106.75,null,null,29,4.625,{"$f":"C129+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D129+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E129+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.375,108.25,107.75,107,null,null,30,4.4989999999999997,{"$f":"C128+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D128+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E128+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.4989999999999997,108.5,108,107.25,null,null,31,4.375,{"$f":"C127+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D127+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E127+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.625,108.75,108.25,107.5,null,null,32,4.25,{"$f":"C126+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D126+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E126+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.75,109,108.5,107.75,null,null,33,4.125,{"$f":"C125+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D125+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E125+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.875,109.25,108.75,108,null,null,34,3.9990000000000001,{"$f":"C124+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D124+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E124+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,7.9989999999999997,109.5,109,108.25,null,null,35,3.875,{"$f":"C123+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D123+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E123+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,8.125,109.75,109.25,108.5,null,null,36,3.75,{"$f":"C122+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D122+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E122+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,37,3.625,{"$f":"C121+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D121+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E121+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,38,3.4990000000000001,{"$f":"C120+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D120+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E120+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,39,3.375,{"$f":"C119+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D119+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E119+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,40,3.25,{"$f":"C118+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"D118+$G$118-$G$120","v":{"$error":"#N/A"}},{"$f":"E118+$G$118-$G$120","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,41,null,{"$f":"MATCH(100,J122:J161,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K122:K161,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L122:L161,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,42,"Par Rates",{"$f":"VLOOKUP(J162,H122:I166,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K162,H122:I166,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L162,H122:L166,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,43,null,{"$f":"IF(G125=J121,J163,0)","v":0},{"$f":"IF(G125=K121,K163,0)","v":0},{"$f":"IF(G125=L121,L163,0)","v":0},{"$f":"SUM(J164:L164)","v":0}]
[null,null,null,null,null,null,null,44,null,{"$f":"VLOOKUP(J162,H122:J166,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K162,H122:K166,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L162,H122:L166,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,45,null,{"$f":"IF(G125=J121,J165,0)","v":0},{"$f":"IF(G125=K121,K165,0)","v":0},{"$f":"IF(G125=L121,L165,0)","v":0},{"$f":"SUM(J166:L166)","v":0}]
[]
[]
[null,"Near Par Rate - BPC",null,{"$f":"Feed!M116","v":0},{"$f":"M118","v":0}]
[null,"Near Par Rate - BPC",null,null,{"$f":"IF(E169>'NanQ ONE Program'!V29,'NanQ ONE Program'!V29,Feed!E169)","v":0}]
[]
[null,"Near Par Rate - LPC",null,{"$f":"Feed!M164","v":0},{"$f":"Feed!M166","v":0}]
[null,"Near Par Rate - LPC",null,null,{"$f":"IF(E172>'NanQ ONE Program'!V29,'NanQ ONE Program'!V29,Feed!E172)","v":0}]

{"sheet":"Cover Page","index":2,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":true,"merged":[[24,4,24,5],[26,6,26,8],[27,6,27,8],[25,4,25,5],[27,4,27,5],[25,6,25,8],[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],[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],[28,2,28,3],[28,4,28,5],[25,2,25,3],[27,2,27,3],[26,2,26,3],[26,4,26,5],[21,2,21,3],[21,4,21,5],[22,2,22,3],[22,4,22,5],[23,2,23,3],[23,4,23,5],[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],[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]]}
[]
[]
[]
[]
[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":[]}