{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NanQ ONE Program","Feed(WS)","Cover Page","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":72,"n_cols":29,"rows_kept":72,"cut":false,"hidden":false,"merged":[[69,20,69,21],[70,20,70,21],[63,20,63,21],[64,20,64,21],[65,20,65,21],[66,20,66,21],[67,20,67,21],[68,20,68,21],[71,18,71,25],[58,22,58,24],[59,22,59,24],[60,22,60,24],[61,22,61,24],[62,22,62,24],[63,22,63,24],[64,22,64,24],[65,22,65,24],[66,22,66,24],[67,22,67,24],[68,22,68,24],[69,22,69,24],[70,22,70,24],[56,20,56,21],[57,20,57,21],[57,22,57,24],[58,20,58,21],[59,20,59,21],[60,20,60,21],[61,20,61,21],[62,20,62,21],[10,6,10,7],[11,6,11,7],[54,0,54,4],[55,0,69,4],[5,0,6,16],[8,0,8,4],[22,6,22,16],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[52,14,52,15],[61,14,61,15],[57,11,57,12],[59,14,59,15],[60,14,60,15],[56,14,56,15],[8,6,8,16],[9,6,9,7],[33,14,33,15],[36,14,36,15],[40,18,40,20],[52,6,52,7],[41,18,41,20],[39,18,39,20],[38,22,38,25],[49,6,49,7],[51,6,51,7],[51,14,51,15],[53,6,53,7],[43,14,43,15],[46,14,46,15],[42,10,42,12],[45,18,55,25],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[58,10,58,11],[58,14,58,16],[47,14,47,15],[54,14,54,15],[55,14,55,15],[60,10,73,12],[62,14,62,15],[56,6,56,7],[55,6,55,7],[61,6,61,7],[54,6,54,7],[53,14,53,15],[48,6,48,7],[34,6,34,7],[35,6,35,7],[37,6,37,7],[36,6,36,7],[38,6,38,7],[50,6,50,7],[39,6,39,7],[36,10,36,11],[35,14,35,15],[34,10,34,11],[49,14,49,15],[50,14,50,15],[42,14,42,15],[48,14,48,15],[39,14,39,15],[37,14,37,15],[38,14,38,15],[47,10,47,12],[40,14,40,15],[41,14,41,15],[45,10,45,11],[43,10,43,11],[44,10,44,11],[45,14,45,16],[34,14,34,15],[35,22,35,25],[32,22,32,25],[30,18,30,20],[26,22,26,25],[27,22,27,25],[32,18,32,20],[29,18,29,20],[33,18,38,21],[34,22,34,25],[33,22,33,25],[28,22,29,25],[33,10,33,11],[42,21,42,24],[42,18,42,20],[0,7,1,10],[30,22,30,25],[39,10,39,11],[40,10,40,11],[0,14,1,16],[3,7,3,10],[4,14,4,16],[13,18,13,19],[14,18,14,19],[24,22,24,25],[2,7,2,10],[21,18,21,19],[8,18,8,19],[7,18,7,19],[2,14,2,16],[3,13,3,16],[4,12,4,13],[28,18,28,20],[37,10,37,11],[35,10,35,11],[20,18,20,19],[12,6,12,7],[13,6,13,7],[16,18,16,19],[12,18,12,19],[11,18,11,19],[15,18,15,19],[17,18,17,19],[32,6,32,8],[32,14,32,16],[32,10,32,12],[23,18,23,19],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[18,18,18,19],[30,6,30,7],[22,18,22,19],[31,18,31,20],[24,18,24,19],[22,26,22,28],[19,18,19,19],[7,26,7,28],[8,26,8,28],[9,26,9,28],[10,26,10,28],[11,26,11,28],[14,26,14,28],[8,23,8,25],[9,23,9,25],[14,22,14,25],[10,23,10,25],[13,22,13,25],[13,26,13,27],[7,21,7,24],[12,26,12,28],[12,22,12,25],[28,26,28,28],[25,18,25,19],[9,18,9,19],[10,18,10,19],[51,10,51,12],[52,10,52,12],[5,18,6,21],[5,22,6,25],[30,26,44,28],[38,10,38,11],[15,26,15,28],[21,26,21,28],[21,22,21,25],[17,26,17,28],[20,26,20,28],[20,22,20,25],[16,26,16,28],[25,22,25,25],[22,22,22,25],[23,22,23,25],[16,22,16,25],[18,22,18,25],[19,22,19,25],[17,22,17,25]]}
[null,null,null,null,null,null,null,"LoanStream Mortgage",null,null,null,null,null,null,"Wholesale Ratesheet",null,null,null,null,null,null,null,null,null,null,null,null,null,"V1.0"]
[]
[null,null,null,null,null,null,null,"19000 MacArthur Blvd, Suite 200",null,null,null,null,null,null,"30 Day Lock Period"]
[null,null,null,null,null,null,null,"Irvine, CA 92612",null,null,null,null,null,"Borrower Paid Compensation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Effective Date:",null,"2023-03-17"]
["NanQ \"ONE\" Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PriceOne Calculator",null,null,null,"Calculator does not verify eligibility.\nPlease use in conjunction with product matrix."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs","Wholesale Ratesheet",null,null,null,{"$f":"O5","v":"2023-03-17"},"Full Doc Column Includes"]
["Base Rate / Base Price",null,null,null,null,null,"FICO/LTV Price Adjustments",null,null,null,null,null,null,null,null,null,null,null," Interest Rate →",null,"Choose a Selection",null,null,null,null,null,"Tax Returns"]
["Coupon","Select (Full/Alt)","Full Doc","Alt Doc","DSCR",null,null,null,"<=50","50.01-60","60.01-65","65.01-70","70.01-75","75.01-80","80.01-85","85.01-90","90.01-95",null,"LTV Range",null,"Choose a Selection",null,null,null,null,null,"1099 Only"]
[6.25,99,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"780+",null,0,0,-0.125,-0.25,-0.5,-0.75,-3.5,-4.5,{"$error":"#N/A"},null,"FICO Range",null,"Choose a Selection",{"$f":"IF(U12='Feed(WS)'!C3,INDEX($G$24:$Q$31,MATCH(U11,$G$24:$G$31,0),MATCH(U10,$G$24:$Q$24,0)),(INDEX(I11:Q21,MATCH(U11,G11:G21,0),MATCH(U10,I10:Q10))))","v":{"$error":"#N/A"}},null,null,null,null,"Asset Utilization Only"]
[6.375,99.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"760-779",null,-0.125,-0.125,-0.25,-0.5,-0.75,-1.25,-3.75,-4.75,{"$error":"#N/A"},null,"Grade",null,"Choose a Selection",{"$f":"IF(U12=\"Choose a Selection\",0,(INDEX(M34:M41,MATCH(U12,K34:K41,0))))","v":0},null,null,null,null,"Asset Utilization W/ Full Doc"]
[6.4989999999999997,99.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"740-759",null,-0.125,-0.25,-0.5,-0.75,-1.25,-1.75,-4,-5,{"$error":"#N/A"},null,"Doc Type",null,"Choose a Selection",null,{"$f":"'Feed(WS)'!B64","v":0},null,null,null,"VOE"]
[6.625,99.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"720-739",null,-0.25,-0.5,-0.75,-1.25,-1.75,-2.25,-4.5,-5.5,{"$error":"#N/A"},null,"Additional Adjs",null,"Choose a Selection",{"$f":"IF(AND(OR(U10='Feed(WS)'!B9:B10),OR(U14='Feed(WS)'!E4:E6)),NA(),IF((AND((IF(U10=\"85.01-90\",1,0))=1,(IF(U13=\"DSCR\",1,0))=1))=TRUE,NA(),(IF(OR((AND(OR(U11='Feed(WS)'!$A$7:$A$12),IF(U10=\"80.01-85\",1,0),IF(U13=\"DSCR\",1,0)))=TRUE,(AND(OR(U11='Feed(WS)'!A6:A12),IF(U10=\"80.01-85\",1,0),IF(U13=\"DSCR\",1,0),OR(U18='Feed(WS)'!J4:J9))=TRUE)),NA(),IF(U14=\"Choose a Selection\",0,(IF(U14=\"None in this Dropdown\",0,IF(U14=\"12 Month Full / Alt Doc\",0,INDEX(I$35:I$69,MATCH(U14,G$35:G$69,0))))))))))","v":0},"Select \"Inv. & 2nd Home >75% LTV\" Adjustment"]
[6.75,100,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"700-719",null,-0.5,-0.75,-1.25,-1.75,-2.25,-2.75,-5,-6,{"$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,G35:I69,3,0),(IF(U15=\"Foreign Nat' No Fico\",INDEX(I13:Q21,MATCH(U15,G13:G21,0),MATCH(U10,I10:Q10)),IF(U15=\"Foreign Nat' With Fico\",IF(U15=\"Foreign Nat' With Fico\",INDEX(G35:I69,(MATCH(U15,G35:G69,0)),3)),NA())))))))))))","v":{"$error":"#N/A"}},null,null,null,null,"Alt Doc Column Includes"]
[6.875,100.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"680-699",null,-0.75,-1.25,-1.75,-2.25,-2.75,-3.5,-5.75,{"$error":"#N/A"},{"$error":"#N/A"},null,"DTI",null,"Choose a Selection",{"$f":"IF(U16=\"DTI ≥50% - All Doc Types\",IF((AND(IF(U16=\"DTI ≥50% - All Doc Types\",1,0),(IF(U18=\"Purchase\",1,0)),(IF(U19=\"Primary\",1,0)),(IF(OR(U10='Feed(WS)'!B3:B8),1,0)),(IF(OR(U11='Feed(WS)'!A3:A9),1,0)),(IF(U12=\"A+\",1,0)))),IF(U16=\"Choose a Selection\",0,(IF(U16=\"DTI  ≤45% - All Doc Types\",0,IF(U16=\"No DTI Program\",0,INDEX(I$35:I$69,MATCH(U16,G$35:G$69,0)))))),NA()), IF((AND(IF(U16=\"DTI ≥50% - All Doc Types\",1,0),(IF(U18<>\"Purchase\",1,0)))),NA(),IF(U16=\"Choose a Selection\",0,(IF(U16=\"DTI ≤45% - All Doc Types\",0,IF(U16=\"No DTI Program\",0,INDEX(I$35:I$69,MATCH(U16,G$35:G$69,0))))))))","v":0},null,{"$f":"W36","v":0},null,null,"12 Bank Statements"]
[6.9989999999999997,100.5,98.75,98.75,{"$error":"#N/A"},null,"660-679",null,-1.25,-1.75,-2.25,-2.75,-3.5,-4.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$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$35:I$69,MATCH(U17,G$35:G$69,0)))))))","v":0},"No Ratio 0.75 - 0.99 (Review Matrix for LTV Qualification) ",null,null,null,"12 or 24 CPA P&L"]
[7.125,100.75,99,99,{"$error":"#N/A"},null,"640-659",null,-1.75,-2.25,-2.75,-3.5,-4.25,-5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Purpose",null,"Choose a Selection",{"$f":"IF(AND(OR(U18='Feed(WS)'!J5:J9),U10=\"85.01-90\"),NA(),IF(ISERROR(IF(OR(U18=\"Purchase\",U18=\"Rate/Term Refi\"),0,INDEX(I$35:I$69,MATCH(U18,G$35:G$69,0)))),0,INDEX(I$35:I$69,MATCH(U18,G$35:G$69,0))))","v":0},null,null,null,null,"Asset Utlization W/ Bank Stmt"]
[7.25,101,99.25,99.25,98.75,null,"620-639",null,-2.25,-2.75,-3.5,-4.25,-5,-6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Occupancy",null,"Choose a Selection",{"$f":"IF(OR('Feed(WS)'!A66:A71=TRUE),IF(U19=\"Choose a Selection\",0,(IF(OR(U19=\"Primary\"),0,IF(OR(U19=\"Non-Owner (Alt Doc/DSCR)\"),0,INDEX(I$35:I$69,MATCH(U19,G$35:G$69,0)))))),NA())","v":{"$error":"#N/A"}}]
[7.375,101.25,99.5,99.5,99,null,"600-619",null,-2.75,-3.5,-4.25,-5,-6,-7,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Property Type",null,"Choose a Selection",{"$f":"IF(AND(OR(U10='Feed(WS)'!B8:B10),OR(U20='Feed(WS)'!K7)),NA(),IF(U17=\"Choose a Selection\",0,(IF(OR(U20=\"SFR\",U20=\"1-2 Units\",U20=\"PUD\",U20=\"Condo\"),0,INDEX(I$35:I$69,MATCH(U20,G$35:G$69,0))))))","v":0}]
[7.4989999999999997,101.5,99.75,99.75,99.25,null,"Foreign Nat' No Fico",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Loan Term",null,"30YR Fixed",{"$f":"IF(AND(U10='Feed(WS)'!B10,OR(U21='Feed(WS)'!M5:M6,U21='Feed(WS)'!M9,U21='Feed(WS)'!M12)),NA(),INDEX(Q34:Q44,MATCH(U21,O34:O44,0)))","v":0},null,null,null,null,"DSCR/No Ratio Column Includes"]
[7.625,101.75,100,100,99.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$35:I$69,MATCH(U22,G$35:G$69,0)))","v":0},null,null,null,null,"DSCR"]
[7.75,102,100.25,100.25,99.75,null,"Select (Full/Alt) FICO/LTV Price Adjustments",null,null,null,null,null,null,null,null,null,null,null,"Prepayment Penalty",null,"No PPP *See PPP Section*",{"$f":"IF(OR(U19=\"Primary\",U19=\"Second Home\"),0,INDEX(I$35:I$69,MATCH(U23,G$35:G$69,0)))","v":-1.5},"MINIMUM 3 YEAR PPP REQUIRED ON >80% LTVs",null,null,null,"No Ratio"]
[7.875,102.25,100.5,100.5,100,null,null,null,"<=50","50.01-60","60.01-65","65.01-70","70.01-75","75.01-80","80.01-85","85.01-90","90.01-95",null,"State",null,"Choose a Selection",0]
[7.9989999999999997,102.5,101,101,100.5,null,"780+",null,0.5,0.375,0.25,0.125,-0.125,-0.375,-1.625,-2.75,{"$error":"#N/A"},null,"Lock Term",null,"30 Day",{"$f":"INDEX(M44:M46,MATCH(U25,K44:K46,0))","v":0}]
[8.125,102.75,101.25,101.25,100.75,null,"760-779",null,0.5,0.375,0.25,0.125,-0.125,-0.375,-1.625,-2.875,{"$error":"#N/A"},null,{"$f":"IF(U26='Feed(WS)'!V2,\"\",\"Inv. & 2nd Home >80% LTV\")","v":""},null,{"$f":"'Feed(WS)'!X2","v":"Not Applicable"},{"$f":"IF(U26='Feed(WS)'!V2,\"\",IF(U26='Feed(WS)'!V3,VLOOKUP('Feed(WS)'!V1,G$35:I$69,3,FALSE),0))","v":""}]
[8.25,103,101.5,101.5,101,null,"740-759",null,0.375,0.25,0.125,0,-0.25,-0.5,-2,-3.375,{"$error":"#N/A"},null,null,null,null,null,0]
[8.375,103.25,101.75,101.75,101.25,null,"720-739",null,0.25,0.125,0,-0.125,-0.375,-0.625,-2.5,-3.875,{"$error":"#N/A"}]
[8.4990000000000006,{"$error":"#N/A"},102,102,101.5,null,"700-719",null,0.125,0,-0.125,-0.5,-0.875,-1.125,-3.375,{"$error":"#N/A"},{"$error":"#N/A"},null,"  Total LLPA",null,null,{"$f":"SUM(V11:V28)+W13","v":{"$error":"#N/A"}},"Calculator does not verify eligibility.\nPlease use in conjunction with product matrix.",null,null,null,"*** Extension Cost"]
[8.625,{"$error":"#N/A"},102.25,102.25,101.75,null,"680-699",null,0,-0.25,-0.5,-0.875,-1.375,-1.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"  Gross Rate Sheet Price (Prior to LLPAs)",null,null,{"$f":"INDEX(A10:E53,MATCH(U9,A10:A53,0),MATCH(U13,B10:E10,0)+1)","v":{"$error":"#N/A"}}]
[8.75,{"$error":"#N/A"},102.5,102.5,102,null,"660-679",null,-0.75,-0.75,-1,-1.375,-1.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"  Net Price: Rate Sheet - LLPA (Prior to Min/Max YSP)",null,null,{"$f":"IFERROR(V30+V29,\"Minimum Rate\")","v":"Minimum Rate"},null,null,null,null,{"$f":"+K61","v":"Temporary Guidance See Below\nExtension Cost\n\n15 Days Max Extensions per schedule below\n\nRates <=8.500% @ 7 bps /day\nRates <=9.500% @ 5 bps / day\nRates >9.500% @ 2 bps / day\nExtension Cost\n\nCurrent lock extension costs/policies apply to all active locks, regardless of lock date\n\nAll 45 day locks are at a 50bp cost and are not eligible for lock extensions"}]
[8.875,{"$error":"#N/A"},102.75,102.75,102.25,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Max YSP",null,null,{"$f":"'Feed(WS)'!D32","v":0}]
[8.9990000000000006,{"$error":"#N/A"},103.25,103.25,102.75,null,"Loan Level Price Adjustments",null,null,null,"Grades",null,null,null,"Loan Term",null,null,null,"Final Price  →",null,null,{"$f":"IFERROR(IF(V31>V32,IF((V31+V34)<V32,V31+V34,V32),V31+V34),\"Final Price\")","v":"Final Price"}]
[9.125,{"$error":"#N/A"},103.5,103.5,103,null,null,null,"LLPA",null,"Select Standard",null,0,null,"15YR Fixed",null,0.25,null,"Borrower Paid Comp Only"]
[9.25,{"$error":"#N/A"},103.75,103.75,103.25,null,"DTI >45% - All Doc Types",null,0,null,"A+",null,0.25,null,"30YR Fixed",null,0,null,null,null,null,null,{"$f":"CONCATENATE('Feed(WS)'!B177,\" \",'Feed(WS)'!D177,\"%\"&\" @ \"&'Feed(WS)'!E177)","v":"Near Par Rate - BPC % @ 0"}]
[9.375,{"$error":"#N/A"},104,104,103.5,null,"DTI ≥50% - All Doc Types",null,-0.5,null,"A",null,-1.25,null,"30YR IO Fixed",null,-0.5]
[9.4990000000000006,{"$error":"#N/A"},104.25,104.25,103.75,null,"ITIN",null,-2,null,"B",null,-2,null,"40YR Fixed",null,-0.5]
[9.625,{"$error":"#N/A"},104.5,104.5,104,null,"VOE Only",null,-0.75,null,"C",null,-2,null,"40YR IO Fixed",null,-0.75]
[9.75,{"$error":"#N/A"},104.75,104.75,104.25,null,"1099 Only",null,-0.75,null,"Select - DSCR",null,1,null,"5/6 30YR ARM",null,0]
[9.875,{"$error":"#N/A"},105,105,104.5,null,"Asset Utilization",null,-0.75,null,"DSCR (≥1.00)",null,0,null,"5/6 30YR IO ARM",null,-0.5,null,"Loan Number",null,null,"Borrower Name"]
[9.9990000000000006,{"$error":"#N/A"},105.25,105.25,104.75,null,"Debt Consol. >70% LTV",null,-1,null,"No Ratio (0.75-0.99)",null,-2,null,"5/6 40YR ARM",null,-0.5]
[10.125,{"$error":"#N/A"},105.5,105.5,105,null,"Debt Consol. ≤ 70% LTV",null,-0.5,null,null,null,null,null,"7/6 30YR ARM",null,0]
[10.25,{"$error":"#N/A"},105.75,105.75,105.25,null,"Cash-Out >70% LTV",null,-1,null,"Lock Days",null,null,null,"7/6 30YR IO ARM",null,-0.5]
[10.375,{"$error":"#N/A"},106,106,105.5,null,"Cash-Out ≤ 70% LTV",null,-0.5,null,"15 Day",null,0,null,"7/6 40YR ARM",null,-0.5]
[10.499000000000001,{"$error":"#N/A"},106.25,106.25,105.75,null,"2 Units",null,0,null,"30 Day",null,0]
[10.625,{"$error":"#N/A"},106.5,106.5,106,null,"3-4 Units",null,-0.5,null,"45 Day",null,-0.5,null,"Max Price",null,null,null,"\n*6 months interest on 80% of the original principal balance\nMinimum 3 Year Prepay Required for All Investment/DSCR Loans with LTV’s >80%\n(States with No PPP >80% is not available) \nNo PPP price option only allowed where prohibited by State\n*PPP is only Allowed on the following:\nNon-TRID Loans -  Investment\nNon-TRID Loans - DSCR\n\nALL STATES REQUIRE A PPP,STATE LEVEL RESTRICTIONS LISTED BELOW\n\n\n\n"]
[10.75,{"$error":"#N/A"},106.75,106.75,106.25,null,"Second Home",null,-0.75,null,null,null,null,null,"Owner Occ/Sec Home",null,100]
[10.875,{"$error":"#N/A"},107,107,106.5,null,"No PPP \"See PPP Section\"",null,-1.5,null,"Minimum Rates by Doc Type",null,null,null,"Loans W/ No PPP",null,99]
[10.999000000000001,{"$error":"#N/A"},107.25,107.25,106.75,null,"6 Months PPP",null,-1.5,null,"Select","Full/Alt Doc","DSCR",null,"Loans W/ 6 Month PPP",null,99]
[11.125,{"$error":"#N/A"},107.5,107.5,107,null,"12 Months PPP",null,-1,null,6.25E-2,6.9989999999999997E-2,7.2499999999999995E-2,null,"Loans W/ 1YR PPP",null,100]
[11.25,{"$error":"#N/A"},107.75,107.75,107.25,null,"24 Months PPP",null,-0.5,null,null,null,null,null,"Loans W/ 2YR PPP",null,100]
[11.375,{"$error":"#N/A"},108,108,107.5,null,"36 Months PPP",null,0,null,"Underwriting Fee",null,null,null,"Loans W/ 3YR PPP",null,100]
[11.499000000000001,{"$error":"#N/A"},108.25,108.25,107.75,null,"48 Months PPP",null,0.25,null,"Click Here",null,null,null,"Loans W/ 4YR PPP",null,100]
[null,null,null,null,null,null,"60 Months PPP",null,0.5,null,null,null,null,null,"Loans W/ 5YR PPP",null,100]
["Non QM Prelocks",null,null,null,null,null,"Escrow Waived",null,-0.25,null,"Loan Term","Caps","Floor",null,">$3,000,000",null,99.5]
["Non-QM Pre-Locks may be locked for 30 or 45 days\n30 day Non-QM Pre-Locks are eligible for up to 15 days of extensions at cost                                                                                                            All Non-QM Pre-Locks must be Submittal Completed/Submitted within 10 days or Lock will be cancelled\nAll 45 day locks are at a 50bp cost and are not eligible for lock extensions\nAll Non-QM locks that expire will be subject to a 25bp Relock Fee and Worse Case Pricing \n",null,null,null,null,null,"NW Condo",null,-1,null,"5/6 ARM","2/1/5","=Rate",null,"80.01-90.00% LTV",null,100]
[null,null,null,null,null,null,"<$150,000",null,-1,null,"7/6 ARM","5/1/5",null,null,"ITIN/Foreign National",null,100,null,"STATES",null,"PPP REQUIRED WHEN:",null,"PPP STRUCTURES",null,null,"NO PPP ALLOWED WHEN:"]
[null,null,null,null,null,null,"$150,000-$1,000,000",null,0,null,"Index","6mo SOFR",null,null,null,null,null,null,"Arkansas",null,"Maximum of 3 years",null,"Max Rates:  3-2-1",null,null,"Never"]
[null,null,null,null,null,null,">$1,000,000",null,0.25,null,"Reset Frequency",null,"6 Mo",null,"ARM Margins",null,null,null,"Illinois",null,"≤ 8% APR, if Cook County > $250K",null,"Max Rates:  3-2-1",null,null,"≥ 8% APR, if Cook County < $250K"]
[null,null,null,null,null,null,">$1,500,000",null,0,null,null,null,null,null,"Occupancy",null,"Margin",null,"Indiana",null,"Fixed Rates",null,"Normal Rates",null,null,"ARM Loans"]
[null,null,null,null,null,null,">$2,000,000",null,-0.5,null,"Temporary Guidance See Below\nExtension Cost\n\n15 Days Max Extensions per schedule below\n\nRates <=8.500% @ 7 bps /day\nRates <=9.500% @ 5 bps / day\nRates >9.500% @ 2 bps / day\nExtension Cost\n\nCurrent lock extension costs/policies apply to all active locks, regardless of lock date\n\nAll 45 day locks are at a 50bp cost and are not eligible for lock extensions",null,null,null,"Primary Home",null,4,null,"Iowa",null,"Maximum of 5 years",null,"Max Rates:  5-4-3-2-1",null,null,"Never"]
[null,null,null,null,null,null,">$2,500,000",null,-0.5,null,null,null,null,null,"Second Home",null,4,null,"Kansas",null,"6 Months only",null,"Normal Rates",null,null,"Never"]
[null,null,null,null,null,null,">$3,000,000",null,-1.5,null,null,null,null,null,"Investment Home",null,4,null,"Kentucky",null,"Always allowed",null,"Max Rates:  3-2-1",null,null,"Never"]
[null,null,null,null,null,null,">$3,500,000",null,-1.5,null,null,null,null,null,null,null,null,null,"Maryland",null,"Maximum of 3 years",null,"Normal Rates",null,null,"Never"]
[null,null,null,null,null,null,">$4,000,000",null,-1.5,null,null,null,null,null,null,null,null,null,"Michigan",null,"Maximum of 3 years",null,"1% Fixed",null,null,"Never"]
[null,null,null,null,null,null,"Foreign Nat' With Fico",null,-1.5,null,null,null,null,null,null,null,null,null,"Missouri",null,"Always allowed",null,"Max Rates:  2-2-2-2",null,null,"Never"]
[null,null,null,null,null,null,"Purchase",null,0,null,null,null,null,null,null,null,null,null,"New Jersey",null,"Closed in name of Corp. or LLC",null,"Normal Rates",null,null,"Closed in name of individual"]
[null,null,null,null,null,null,"Inv. & 2nd Home >80% LTV",null,-1,null,null,null,null,null,null,null,null,null,"Ohio",null,">= $100,000",null,"Normal Rates",null,null,"< $100,000"]
[null,null,null,null,null,null,"Full Doc - Non-Owner",null,-0.5,null,null,null,null,null,null,null,null,null,"Pennsylvania",null,">$301,022 and 1-2 Unit, or any 3-4 Unit",null,"Normal Rates",null,null,"<=$301,022 and 1-2 Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rhode Island",null,"Maximum of 1 year",null,"2% Fixed",null,null,"Never"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas",null,"Purchase, or Non-Homestead Refinances",null,"Normal Rates",null,null,"Closed in name of individual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEVER ALLOWED IN MAINE, MINNESOTA, AND NEW MEXICO"]

{"sheet":"Feed(WS)","index":1,"n_rows":181,"n_cols":29,"rows_kept":181,"cut":false,"hidden":true,"merged":[[0,17,0,18],[180,1,180,2],[179,1,179,2],[176,1,176,2],[79,8,79,11],[127,1,127,4],[177,1,177,2],[19,0,19,2],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[29,0,29,1],[30,0,30,1],[132,8,132,11],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[79,1,79,5]]}
["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,"State",null,"Inv. & 2nd Home >80% LTV"]
["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,"Choose a Selection",null,"Not Applicable",null,{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B9:B10),OR('NanQ ONE Program'!U19=L4:L6)),V3,V2)","v":"Not Applicable"}]
["780+","<=50","Select Standard","Select (Full/Alt)","None in this Dropdown","DTI ≤45% - All Doc Types","<$150,000","No PPP *See PPP Section*","Escrow Not Waived","Purchase","SFR","Primary","15YR Fixed","15 Day","Borrower Paid","US Citizen","Not Applicable1",null,null,"Maine",null,"Yes",null,null,null,null,null,null," "]
["760-779","50.01-60","A+","Full Doc","Asset Utilization","DTI >45% - All Doc Types","$150,000-$1,000,000","6 Months PPP","Escrow Waived","Refinances","2 Units","Second Home","30YR Fixed","30 Day",null,"Permanent Resident","Not Applicable2",null,null,"Minnesota",null,null,null,null,null,null,null,null," "]
["740-759","60.01-65","A","Alt Doc","1099 Only","DTI ≥50% - All Doc Types",">$1,000,000","12 Months PPP",null,"Debt Consol. ≤ 70% LTV","3-4 Units","Full Doc - Non-Owner","30YR IO Fixed","45 Day",null,"Non Perm Resident","Not Applicable3",null,null,"New Mexico",null,null,null,null,null,null,null,null," "]
["720-739","65.01-70","B","DSCR","VOE Only","No DTI Program",">$1,500,000","24 Months PPP",null,"Debt Consol. >70% LTV","Condo","Non-Owner (Alt Doc/DSCR)","40YR IO Fixed","60 Day",null,"ITIN",null,null,null,"All Other States",null,null,null,null,null,null,null,null," "]
["700-719","70.01-75","C",null,null,null,">$2,000,000","36 Months PPP",null,"Cash-Out ≤ 70% LTV","NW Condo",null,"40YR Fixed","75 Day",null,"Foreign Nat' With Fico",null,null,null,null,null,null,null,null,null,null,null,null," "]
["680-699","75.01-80","Select - DSCR",null,null,null,">$2,500,000","48 Months PPP",null,"Cash-Out >70% LTV","PUD",null,"5/6 30YR ARM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["660-679","80.01-85","DSCR (≥1.00)",null,null,null,">$3,000,000","60 Months PPP",null,null,null,null,"5/6 30YR IO ARM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["640-659","85.01-90","No Ratio (0.75-0.99)",null,null,null,">$3,500,000",null,null,null,null,null,"5/6 40YR ARM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["620-639",null,null,null,null,null,">$4,000,000",null,null,null,null,null,"7/6 30YR ARM"]
["600-619",null,null,null,null,null,null,null,null,null,null,null,"7/6 30YR IO ARM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"7/6 40YR ARM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" 'NanQ ONE Program'!"]
["Feed(WS)'!"]
[]
[]
[{"$f":"'NanQ ONE Program'!O46","v":"Max Price"},null,null,"Rules"]
[{"$f":"'NanQ ONE Program'!O47","v":"Owner Occ/Sec Home"},null,{"$f":"'NanQ ONE Program'!Q47","v":100},{"$f":"IF(OR('NanQ ONE Program'!U19=L3:L4),C21,\"\")","v":""}]
[{"$f":"'NanQ ONE Program'!O48","v":"Loans W/ No PPP"},null,{"$f":"'NanQ ONE Program'!Q48","v":99},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H3),C22,\"\")","v":""},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":"'NanQ ONE Program'!O49","v":"Loans W/ 6 Month PPP"},null,{"$f":"'NanQ ONE Program'!Q49","v":99},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H4),C23,\"\")","v":""},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":"'NanQ ONE Program'!O50","v":"Loans W/ 1YR PPP"},null,{"$f":"'NanQ ONE Program'!Q50","v":100},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H5),C24,\"\")","v":""},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":"'NanQ ONE Program'!O51","v":"Loans W/ 2YR PPP"},null,{"$f":"'NanQ ONE Program'!Q51","v":100},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H6),C25,\"\")","v":""},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":"'NanQ ONE Program'!O52","v":"Loans W/ 3YR PPP"},null,{"$f":"'NanQ ONE Program'!Q52","v":100},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H7),C26,\"\")","v":""},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":"'NanQ ONE Program'!O53","v":"Loans W/ 4YR PPP"},null,{"$f":"'NanQ ONE Program'!Q53","v":100},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H8),C27,\"\")","v":""},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":"'NanQ ONE Program'!O54","v":"Loans W/ 5YR PPP"},null,{"$f":"'NanQ ONE Program'!Q54","v":100},{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U23=H9),C28,\"\")","v":""},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":"'NanQ ONE Program'!O55","v":">$3,000,000"},null,{"$f":"'NanQ ONE Program'!Q55","v":99.5},{"$f":"IF(OR('NanQ ONE Program'!U17=G9:G11),C29,\"\")","v":""},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":"'NanQ ONE Program'!O56","v":"80.01-90.00% LTV"},null,{"$f":"'NanQ ONE Program'!Q56","v":100},{"$f":"IF(OR('NanQ ONE Program'!U10=B9:B10),C30,\"\")","v":""},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":"'NanQ ONE Program'!O57","v":"ITIN/Foreign National"},null,{"$f":"'NanQ ONE Program'!Q57","v":100},{"$f":"IF(OR('NanQ ONE Program'!U15=P6:P7),C31,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Final price  →",{"$f":"MIN(D21:D31)","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,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Pop Ups",null,null,null,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 Ratio above 60% warning",{"$f":"IF(AND(OR('NanQ ONE Program'!U10='Feed(WS)'!B5:B10),'NanQ ONE Program'!U12=\"No Ratio (0.75-0.99)\"),TRUE,FALSE)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Disqualifiers",null,null,null,null,"Disqualifiers Select",null,null,null,null,null,"Disqualifiers DSCR",null,null,null,null,"State Rules",null,null,null,null,null,"Disqualifiers A+",null,null,"Disqualifiers ITIN",null,null," "]
[" Foreign National",{"$f":"IF(AND('NanQ ONE Program'!U15='Feed(WS)'!P7,OR('NanQ ONE Program'!U11='Feed(WS)'!A8:A12)),NA(),\"\")","v":""},"FN minimum 700 Fico rule",null,null,"Doc type",{"$f":"IF(AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U12=C4:C10)),NA(),\"\")","v":""},"Select Doc type only pairs with Select grade",null,null,null,"Prop Type",{"$f":"IF(AND(OR('NanQ ONE Program'!U20=K4:K5),'NanQ ONE Program'!U12=C9,OR('NanQ ONE Program'!U10=B9:B10)),NA(),\"\")","v":""},"2-4 Units is capped at 80% LTV",null,null,"All PPPs",{"$f":"IF(AND(OR('NanQ ONE Program'!U24=T3:T5),OR('NanQ ONE Program'!U23=H4:H9),OR('NanQ ONE Program'!U19=L5:L6)),NA(),\"\")","v":""},"NA if PPP is selected for ME,MI, NM",null,null,null,"FICO X Loan Amt X LTV X A+",{"$f":"IF(AND('NanQ ONE Program'!U11=A8,OR('NanQ ONE Program'!U17=G3:G5),OR('NanQ ONE Program'!U10=B10),'NanQ ONE Program'!U12=C4),NA(),\"\")","v":""},"680 FICO caps <125k to 1.5MM at 85% LTV","ITIN",{"$f":"IF(AND('NanQ ONE Program'!U15='Feed(WS)'!P6,'NanQ ONE Program'!U10=B10),NA(),\"\")","v":""},"ITIN N/A for 85.01-90% LTV"," "]
[null,null,null,null,null,"Grade",{"$f":"IF(AND('NanQ ONE Program'!U12=C3,OR('NanQ ONE Program'!U13=D4:D6)),NA(),\"\")","v":""},"Select Grade only pairs with type only pairs with Select Doc type",null,null,null,"Prop Type",{"$f":"IF(AND(OR('NanQ ONE Program'!U20=K4:K5),'NanQ ONE Program'!U12=C9,OR('NanQ ONE Program'!U10=B8:B10),OR('NanQ ONE Program'!U18=J5:J8)),NA(),\"\")","v":""},"2-4 Units is capped at 75% LTV Cahshout (5% Reduction)",null,null,null,null,null,null,null,null,"FICO X Loan Amt X LTV X A+",{"$f":"IF(AND('NanQ ONE Program'!U11=A8,OR('NanQ ONE Program'!U17=G6),OR('NanQ ONE Program'!U10=B9:B10),'NanQ ONE Program'!U12=C4),NA(),\"\")","v":""},"680 FICO caps over 1.5MM to 2 MM 80% LTV","ITIN",{"$f":"IF(AND('NanQ ONE Program'!U15='Feed(WS)'!P6,OR('NanQ ONE Program'!U11='Feed(WS)'!A10:A12)),NA(),\"\")","v":""},"ITIN minimum 660 Fico rule for all LTVs"," "]
[null,null,null,null,null,"Occupancy",{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L5:L6),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"Select N/A s NOO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FICO X Loan Amt X LTV X A+",{"$f":"IF(AND('NanQ ONE Program'!U11=A8,OR('NanQ ONE Program'!U17=G7),OR('NanQ ONE Program'!U10=B8:B10),'NanQ ONE Program'!U12=C4),NA(),\"\")","v":""},"680 FICO caps over 2MM to 2.5MM 75% LTV","ITIN",{"$f":"IF(AND('NanQ ONE Program'!U15='Feed(WS)'!P6,OR('NanQ ONE Program'!U17='Feed(WS)'!G6:G9)),NA(),\"\")","v":""},"ITIN 0-1.5 mil loan amount max"," "]
[" Foreign National",{"$f":"IF(AND('NanQ ONE Program'!U15='Feed(WS)'!P7,OR('NanQ ONE Program'!U17='Feed(WS)'!G7:G9)),NA(),\"\")","v":""},"FN 0-2 mil loan amount max",null,null,"Occupancy",{"$f":"IF(AND(OR('NanQ ONE Program'!U19=L4),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"Select N/A s 2nd Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FICO X Loan Amt X LTV X A+",{"$f":"IF(AND('NanQ ONE Program'!U11=A8,OR('NanQ ONE Program'!U17=G8),OR('NanQ ONE Program'!U10=B7:B10),'NanQ ONE Program'!U12=C4),NA(),\"\")","v":""},"680 FICO caps over 2.5MM to 3MM 70% LTV","ITIN",{"$f":"IF(AND('NanQ ONE Program'!U15='Feed(WS)'!P6,OR('NanQ ONE Program'!U10=B9:B10),OR('NanQ ONE Program'!U19=L5:L6)),NA(),\"\")","v":""},"ITIN N/A for 80.01-90% LTV on NOO"," "]
[null,null,null,null,null,"Prop Type",{"$f":"IF(AND(OR('NanQ ONE Program'!U20=K7),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"Select N/A s NW Condo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FICO X Loan Amt X LTV X A+",{"$f":"IF(AND('NanQ ONE Program'!U11=A8,OR('NanQ ONE Program'!U17=G9:G11),OR('NanQ ONE Program'!U10=B5:B10),'NanQ ONE Program'!U12=C4),NA(),\"\")","v":""},"680 FICO caps over 3MM 60% LTV",null,null,null," "]
["85.01-90% LTV",{"$f":"IF(AND('NanQ ONE Program'!U10='Feed(WS)'!B10,'NanQ ONE Program'!U12='Feed(WS)'!C4,OR('NanQ ONE Program'!U19='Feed(WS)'!L4:L6)),NA(),\"\")","v":""},"A+ / NOO - 2nd home / 85.01-90%",null,null,"Prop Type",{"$f":"IF(AND(OR('NanQ ONE Program'!U20=K4),'NanQ ONE Program'!U13=D3,'NanQ ONE Program'!U10=B10),NA(),\"\")","v":""},"2 Units is capped at 85% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["C Grade >70%",{"$f":"IF(AND('NanQ ONE Program'!U12='Feed(WS)'!C7,OR('NanQ ONE Program'!U10='Feed(WS)'!B7:B10)),NA(),\"\")","v":""},"C Grade /  >70% LTV",null,null,"Prop Type",{"$f":"IF(AND(OR('NanQ ONE Program'!U20=K5),'NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U10=B9:B10)),NA(),\"\")","v":""},"3-4 Units is capped at 80% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["PPP >80% LTV",{"$f":"IF(AND(OR('NanQ ONE Program'!U10='Feed(WS)'!B9:B10),OR('NanQ ONE Program'!U19='Feed(WS)'!L5:L6),OR('NanQ ONE Program'!U23='Feed(WS)'!H2:H6)),NA(),\"\")","v":""},"80.01-90% / NOO / 3YR PP Minimum",null,null,"Loan Term",{"$f":"IF(AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U21=M5:M13,'NanQ ONE Program'!U21=M3)),NA(),\"\")","v":""},"Select N/A s 15Year, ARMS, IO, and 40 Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Grade A+ Min FICO is 660",{"$f":"IF(AND(OR('NanQ ONE Program'!U11=A10:A12),'NanQ ONE Program'!U12=C4),NA(),\"\")","v":""},"Grade A+ Minimum FICO is 660, so under 660 is “NA”",null,null,"Select X Cash out",{"$f":"IF(OR(AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U18=J5:J8),OR('NanQ ONE Program'!U10=B9:B10)),AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U18=J5:J8),OR('NanQ ONE Program'!U17=G5:G11)),AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U18=J5:J8),OR('NanQ ONE Program'!U11=A8:A12))),NA(),\"\")","v":""},"Cash Out caps LTV at 80%, 1MM, and min FICO at 700",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["85.01-90% LTV 2mil cap",{"$f":"IF(AND('NanQ ONE Program'!U10=B10,OR('NanQ ONE Program'!U17=G7:G11)),NA(),\"\")","v":""},"90% LTV Max loan amount is 2MM, so >2 and >3 is “NA”",null,null,"Select X Loan Amount",{"$f":"IF(AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U17=G7:G11,'NanQ ONE Program'!U17=G3)),NA(),\"\")","v":""},"No Select over 2MM or Below <150k",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["80.01-85% LTV 2mil cap",{"$f":"IF(AND('NanQ ONE Program'!U10=B9,OR('NanQ ONE Program'!U17=G7:G11)),NA(),\"\")","v":""},"85% LTV Max Loan Amount is 2.0MM so >2 is “NA”",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND('NanQ ONE Program'!U11=A9,OR('NanQ ONE Program'!U17=G5:G11),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"660-679 FICO caps over 1 MM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["65% LTV 3-4 mil cap",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B6:B10),OR('NanQ ONE Program'!U17=G9:G11)),NA(),\"\")","v":""},"65% LTV Max so >3->4 is “NA”",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND('NanQ ONE Program'!U11=A8,OR('NanQ ONE Program'!U17=G5:G11),OR('NanQ ONE Program'!U10=B3:B10),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"680 FICO caps at 150k - 1MM ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Condo 80% LTV Cap",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B10),OR('NanQ ONE Program'!U20=K6),OR('NanQ ONE Program'!U12=C4:C10)),NA(),\"\")","v":""},"85% Max for Condo",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND('NanQ ONE Program'!U11=A7,OR('NanQ ONE Program'!U17=G5:G11),OR('NanQ ONE Program'!U10=B9:B10),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"700-719 FICO caps over 1 MM at 80% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["2 Unit 85% LTV Cap",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B10),OR('NanQ ONE Program'!U20=K4)),NA(),\"\")","v":""},"85% Max for 2 Units",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND('NanQ ONE Program'!U11=A7,OR('NanQ ONE Program'!U17=G6:G11),OR('NanQ ONE Program'!U10=B8:B10),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"700-719 FICO caps over 1.5 MM at 75% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["NW Condo 75% LTV Cap",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B8:B10),OR('NanQ ONE Program'!U20=K7)),NA(),\"\")","v":""},"75% Max for NW Condo",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND('NanQ ONE Program'!U11=A6,OR('NanQ ONE Program'!U17=G5:G11),OR('NanQ ONE Program'!U10=B10),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"720-739 FICO caps over 1 MM at 85% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["3-4 Unit 80% LTV Cap",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B9:B10),OR('NanQ ONE Program'!U20=K5)),NA(),\"\")","v":""},"80% Max for 3-4 Units",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND('NanQ ONE Program'!U11=A6,OR('NanQ ONE Program'!U17=G6:G11),OR('NanQ ONE Program'!U10=B9:B10),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"720-739 FICO caps over 1.5 MM and 80% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["DSCR",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B7:B10),OR('NanQ ONE Program'!U11=A11:A12),'NanQ ONE Program'!U13=D6),NA(),\"\")","v":""},"DSCR >70% LTV 620 FICO cap",null,null,"FICO X Loan Amt X LTV X Select",{"$f":"IF(AND(OR('NanQ ONE Program'!U11=A3:A5),OR('NanQ ONE Program'!U17=G6:G11),OR('NanQ ONE Program'!U10=B10),'NanQ ONE Program'!U13=D3),NA(),\"\")","v":""},"740+ FICO caps over 1.5 MM at 85% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["DSCR",{"$f":"IF(AND(OR('NanQ ONE Program'!U10='Feed(WS)'!B9:B10),'NanQ ONE Program'!U13='Feed(WS)'!D6,OR('NanQ ONE Program'!U20='Feed(WS)'!K5:K6)),NA(),\"\")","v":""},"DSCR >80% 3-4 Units/Condo",null,null,"FICO X Loan Amt X LTV X Select X Cash",{"$f":"IF(AND(OR('NanQ ONE Program'!U11=A7),OR('NanQ ONE Program'!U17=G4),OR('NanQ ONE Program'!U10=B8:B10),'NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U18=J5:J8)),NA(),\"\")","v":""},"700-719 FICO caps 150k - 1 MM at 75% LTV Cash Out",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["DSCR",{"$f":"IF(AND(OR('NanQ ONE Program'!U11='Feed(WS)'!A7:A12),'NanQ ONE Program'!U13='Feed(WS)'!D6,OR('NanQ ONE Program'!U10='Feed(WS)'!B8:B10),OR('NanQ ONE Program'!U18='Feed(WS)'!J5:J8)),NA(),\"\")","v":""},"DSCR 75% CAP on Cash out FICO <720",null,null,"Additional Adjustments",{"$f":"IF(AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U14=E4:E6)),NA(),\"\")","v":""},"NA for Asset Utilization, 1099, and VOE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["DTI >45%",{"$f":"IF(AND('NanQ ONE Program'!U10=B10,'NanQ ONE Program'!U16=F4,OR('NanQ ONE Program'!U12=C4:C10)),NA(),\"\")","v":""},"DTIs over 45% can't pair with LTVs 85.01-90%",null,null,"Citizenship",{"$f":"IF(AND('NanQ ONE Program'!U13=D3,OR('NanQ ONE Program'!U15=P4:P7)),NA(),\"\")","v":""},"NA for Perm/NonPerm Residents, ITIN, and Foreign National",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["I/O over 80% LTV",{"$f":"IF(AND(OR('NanQ ONE Program'!U10=B9:B10),OR('NanQ ONE Program'!U21=M5:M6,'NanQ ONE Program'!U21=M9,'NanQ ONE Program'!U21=M12)),NA(),\"\")","v":""},"NA for any IO over 80% LTV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total",{"$f":"SUM(B43:B63)+SUM(G43:G62)+SUM(M43:M44)+SUM(R43:R44)+SUM(X43:X47)+SUM(AA43:AA46)","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,null,null,null," "]
["Occupancy"]
[{"$f":"IF(AND('NanQ ONE Program'!U18='Feed(WS)'!J3,OR('NanQ ONE Program'!U10='Feed(WS)'!B9:B10),'NanQ ONE Program'!U12='Feed(WS)'!C4),TRUE(),FALSE)","v":false},"80.01 - 90%/ A+/ Purch"]
[{"$f":"IF(AND('NanQ ONE Program'!U10='Feed(WS)'!B9,'NanQ ONE Program'!U12='Feed(WS)'!C5,OR('NanQ ONE Program'!U11='Feed(WS)'!A3:A6),'NanQ ONE Program'!U18='Feed(WS)'!J3,'NanQ ONE Program'!U19='Feed(WS)'!L3),TRUE,FALSE)","v":false},"80.01-85% / \"A\" Grade / 720 FICO / Purch / Primary"]
[{"$f":"OR('NanQ ONE Program'!U10='Feed(WS)'!B3:B8)","v":false},"<80% LTV's"]
[{"$f":"IF(AND('NanQ ONE Program'!U10='Feed(WS)'!B9,'NanQ ONE Program'!U13='Feed(WS)'!D6,'NanQ ONE Program'!U12='Feed(WS)'!C9,OR('NanQ ONE Program'!U11=A3:A6),OR('NanQ ONE Program'!U18='Feed(WS)'!J3:J4)),TRUE,FALSE)","v":false},"80.01-85% / 720+/ DSCR / >=1.00 Grade / Purch & Rate/term"]
[{"$f":"IF(AND(OR('NanQ ONE Program'!U18='Feed(WS)'!J3:J8),OR('NanQ ONE Program'!U10='Feed(WS)'!B9:B10),'NanQ ONE Program'!U12='Feed(WS)'!C3),TRUE(),FALSE)","v":false},"80.01 - 90%/ Select"]
[{"$f":"IF(AND('NanQ ONE Program'!U18='Feed(WS)'!J4,OR('NanQ ONE Program'!U10='Feed(WS)'!B9),'NanQ ONE Program'!U12='Feed(WS)'!C4),TRUE(),FALSE)","v":false},"80.01 - 85%/ A+/ Rate and term"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Base Rate / Base Price",null,null,null,null,null,null,"Base Rate / Base Price"]
[null,"Coupon","Full Doc","Alt Doc","DSCR",{"$f":"'NanQ ONE Program'!B10","v":"Select (Full/Alt)"},"Total LLPA",null,"Coupon","Full Doc","Alt Doc","DSCR",{"$f":"F81","v":"Select (Full/Alt)"},0]
[null,{"$f":"'NanQ ONE Program'!A11","v":6.25},{"$f":"'NanQ ONE Program'!C11","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!D11","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!E11","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B11","v":99},{"$f":"SUM('NanQ ONE Program'!V11:V28)+B64","v":{"$error":"#N/A"}},1,{"$f":"B82","v":6.25},{"$f":"C82+$G$82","v":{"$error":"#N/A"}},{"$f":"D82+$G$82","v":{"$error":"#N/A"}},{"$f":"E82+$G$82","v":{"$error":"#N/A"}},{"$f":"F82+$G$82","v":{"$error":"#N/A"}},{"$f":"I82:I124","v":6.25}]
[null,{"$f":"'NanQ ONE Program'!A12","v":6.375},{"$f":"'NanQ ONE Program'!C12","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!D12","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!E12","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B12","v":99.25},".",2,6.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.375]
[null,{"$f":"'NanQ ONE Program'!A13","v":6.4989999999999997},{"$f":"'NanQ ONE Program'!C13","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!D13","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!E13","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B13","v":99.5},"Total Price",3,6.4989999999999997,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.4989999999999997]
[null,{"$f":"'NanQ ONE Program'!A14","v":6.625},{"$f":"'NanQ ONE Program'!C14","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!D14","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!E14","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B14","v":99.75},{"$f":"'NanQ ONE Program'!V33","v":"Final Price"},4,6.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.625]
[null,{"$f":"'NanQ ONE Program'!A15","v":6.75},{"$f":"'NanQ ONE Program'!C15","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!D15","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!E15","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B15","v":100},null,5,6.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.75]
[null,{"$f":"'NanQ ONE Program'!A16","v":6.875},{"$f":"'NanQ ONE Program'!C16","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!D16","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!E16","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B16","v":100.25},null,6,6.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.875]
[null,{"$f":"'NanQ ONE Program'!A17","v":6.9989999999999997},{"$f":"'NanQ ONE Program'!C17","v":98.75},{"$f":"'NanQ ONE Program'!D17","v":98.75},{"$f":"'NanQ ONE Program'!E17","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B17","v":100.5},null,7,6.9989999999999997,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.9989999999999997]
[null,{"$f":"'NanQ ONE Program'!A18","v":7.125},{"$f":"'NanQ ONE Program'!C18","v":99},{"$f":"'NanQ ONE Program'!D18","v":99},{"$f":"'NanQ ONE Program'!E18","v":{"$error":"#N/A"}},{"$f":"'NanQ ONE Program'!B18","v":100.75},{"$f":"'NanQ ONE Program'!U13","v":"Choose a Selection"},8,7.125,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.125]
[null,{"$f":"'NanQ ONE Program'!A19","v":7.25},{"$f":"'NanQ ONE Program'!C19","v":99.25},{"$f":"'NanQ ONE Program'!D19","v":99.25},{"$f":"'NanQ ONE Program'!E19","v":98.75},{"$f":"'NanQ ONE Program'!B19","v":101},null,9,7.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.25]
[null,{"$f":"'NanQ ONE Program'!A20","v":7.375},{"$f":"'NanQ ONE Program'!C20","v":99.5},{"$f":"'NanQ ONE Program'!D20","v":99.5},{"$f":"'NanQ ONE Program'!E20","v":99},{"$f":"'NanQ ONE Program'!B20","v":101.25},null,10,7.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.375]
[null,{"$f":"'NanQ ONE Program'!A21","v":7.4989999999999997},{"$f":"'NanQ ONE Program'!C21","v":99.75},{"$f":"'NanQ ONE Program'!D21","v":99.75},{"$f":"'NanQ ONE Program'!E21","v":99.25},{"$f":"'NanQ ONE Program'!B21","v":101.5},null,11,7.4989999999999997,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.4989999999999997]
[null,{"$f":"'NanQ ONE Program'!A22","v":7.625},{"$f":"'NanQ ONE Program'!C22","v":100},{"$f":"'NanQ ONE Program'!D22","v":100},{"$f":"'NanQ ONE Program'!E22","v":99.5},{"$f":"'NanQ ONE Program'!B22","v":101.75},null,12,7.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.625]
[null,{"$f":"'NanQ ONE Program'!A23","v":7.75},{"$f":"'NanQ ONE Program'!C23","v":100.25},{"$f":"'NanQ ONE Program'!D23","v":100.25},{"$f":"'NanQ ONE Program'!E23","v":99.75},{"$f":"'NanQ ONE Program'!B23","v":102},null,13,7.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.75]
[null,{"$f":"'NanQ ONE Program'!A24","v":7.875},{"$f":"'NanQ ONE Program'!C24","v":100.5},{"$f":"'NanQ ONE Program'!D24","v":100.5},{"$f":"'NanQ ONE Program'!E24","v":100},{"$f":"'NanQ ONE Program'!B24","v":102.25},null,14,7.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7.875]
[null,{"$f":"'NanQ ONE Program'!A25","v":7.9989999999999997},{"$f":"'NanQ ONE Program'!C25","v":101},{"$f":"'NanQ ONE Program'!D25","v":101},{"$f":"'NanQ ONE Program'!E25","v":100.5},{"$f":"'NanQ ONE Program'!B25","v":102.5},null,15,7.9989999999999997,{"$f":"C96+$G$82","v":{"$error":"#N/A"}},{"$f":"D96+$G$82","v":{"$error":"#N/A"}},{"$f":"E96+$G$82","v":{"$error":"#N/A"}},{"$error":"#N/A"},7.9989999999999997]
[null,{"$f":"'NanQ ONE Program'!A26","v":8.125},{"$f":"'NanQ ONE Program'!C26","v":101.25},{"$f":"'NanQ ONE Program'!D26","v":101.25},{"$f":"'NanQ ONE Program'!E26","v":100.75},{"$f":"'NanQ ONE Program'!B26","v":102.75},null,16,8.125,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8.125]
[null,{"$f":"'NanQ ONE Program'!A27","v":8.25},{"$f":"'NanQ ONE Program'!C27","v":101.5},{"$f":"'NanQ ONE Program'!D27","v":101.5},{"$f":"'NanQ ONE Program'!E27","v":101},{"$f":"'NanQ ONE Program'!B27","v":103},null,17,8.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8.25]
[null,{"$f":"'NanQ ONE Program'!A28","v":8.375},{"$f":"'NanQ ONE Program'!C28","v":101.75},{"$f":"'NanQ ONE Program'!D28","v":101.75},{"$f":"'NanQ ONE Program'!E28","v":101.25},{"$f":"'NanQ ONE Program'!B28","v":103.25},null,18,8.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8.375]
[null,{"$f":"'NanQ ONE Program'!A29","v":8.4990000000000006},{"$f":"'NanQ ONE Program'!C29","v":102},{"$f":"'NanQ ONE Program'!D29","v":102},{"$f":"'NanQ ONE Program'!E29","v":101.5},null,null,19,8.4990000000000006,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,8.4990000000000006]
[null,{"$f":"'NanQ ONE Program'!A30","v":8.625},{"$f":"'NanQ ONE Program'!C30","v":102.25},{"$f":"'NanQ ONE Program'!D30","v":102.25},{"$f":"'NanQ ONE Program'!E30","v":101.75},null,null,20,8.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,8.625]
[null,{"$f":"'NanQ ONE Program'!A31","v":8.75},{"$f":"'NanQ ONE Program'!C31","v":102.5},{"$f":"'NanQ ONE Program'!D31","v":102.5},{"$f":"'NanQ ONE Program'!E31","v":102},null,null,21,8.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,8.75]
[null,{"$f":"'NanQ ONE Program'!A32","v":8.875},{"$f":"'NanQ ONE Program'!C32","v":102.75},{"$f":"'NanQ ONE Program'!D32","v":102.75},{"$f":"'NanQ ONE Program'!E32","v":102.25},null,null,22,8.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,8.875]
[null,{"$f":"'NanQ ONE Program'!A33","v":8.9990000000000006},{"$f":"'NanQ ONE Program'!C33","v":103.25},{"$f":"'NanQ ONE Program'!D33","v":103.25},{"$f":"'NanQ ONE Program'!E33","v":102.75},null,null,23,8.9990000000000006,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,8.9990000000000006]
[null,{"$f":"'NanQ ONE Program'!A34","v":9.125},{"$f":"'NanQ ONE Program'!C34","v":103.5},{"$f":"'NanQ ONE Program'!D34","v":103.5},{"$f":"'NanQ ONE Program'!E34","v":103},null,null,24,9.125,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.125]
[null,{"$f":"'NanQ ONE Program'!A35","v":9.25},{"$f":"'NanQ ONE Program'!C35","v":103.75},{"$f":"'NanQ ONE Program'!D35","v":103.75},{"$f":"'NanQ ONE Program'!E35","v":103.25},null,null,25,9.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.25]
[null,{"$f":"'NanQ ONE Program'!A36","v":9.375},{"$f":"'NanQ ONE Program'!C36","v":104},{"$f":"'NanQ ONE Program'!D36","v":104},{"$f":"'NanQ ONE Program'!E36","v":103.5},null,null,26,9.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.375]
[null,{"$f":"'NanQ ONE Program'!A37","v":9.4990000000000006},{"$f":"'NanQ ONE Program'!C37","v":104.25},{"$f":"'NanQ ONE Program'!D37","v":104.25},{"$f":"'NanQ ONE Program'!E37","v":103.75},null,null,27,9.4990000000000006,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.4990000000000006]
[null,{"$f":"'NanQ ONE Program'!A38","v":9.625},{"$f":"'NanQ ONE Program'!C38","v":104.5},{"$f":"'NanQ ONE Program'!D38","v":104.5},{"$f":"'NanQ ONE Program'!E38","v":104},null,null,28,9.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.625]
[null,{"$f":"'NanQ ONE Program'!A39","v":9.75},{"$f":"'NanQ ONE Program'!C39","v":104.75},{"$f":"'NanQ ONE Program'!D39","v":104.75},{"$f":"'NanQ ONE Program'!E39","v":104.25},null,null,29,9.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.75]
[null,{"$f":"'NanQ ONE Program'!A40","v":9.875},{"$f":"'NanQ ONE Program'!C40","v":105},{"$f":"'NanQ ONE Program'!D40","v":105},{"$f":"'NanQ ONE Program'!E40","v":104.5},null,null,30,9.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.875]
[null,{"$f":"'NanQ ONE Program'!A41","v":9.9990000000000006},{"$f":"'NanQ ONE Program'!C41","v":105.25},{"$f":"'NanQ ONE Program'!D41","v":105.25},{"$f":"'NanQ ONE Program'!E41","v":104.75},null,null,31,9.9990000000000006,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,9.9990000000000006]
[null,{"$f":"'NanQ ONE Program'!A42","v":10.125},{"$f":"'NanQ ONE Program'!C42","v":105.5},{"$f":"'NanQ ONE Program'!D42","v":105.5},{"$f":"'NanQ ONE Program'!E42","v":105},null,null,32,10.125,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.125]
[null,{"$f":"'NanQ ONE Program'!A43","v":10.25},{"$f":"'NanQ ONE Program'!C43","v":105.75},{"$f":"'NanQ ONE Program'!D43","v":105.75},{"$f":"'NanQ ONE Program'!E43","v":105.25},null,null,33,10.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.25]
[null,{"$f":"'NanQ ONE Program'!A44","v":10.375},{"$f":"'NanQ ONE Program'!C44","v":106},{"$f":"'NanQ ONE Program'!D44","v":106},{"$f":"'NanQ ONE Program'!E44","v":105.5},null,null,34,10.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.375]
[null,{"$f":"'NanQ ONE Program'!A45","v":10.499000000000001},{"$f":"'NanQ ONE Program'!C45","v":106.25},{"$f":"'NanQ ONE Program'!D45","v":106.25},{"$f":"'NanQ ONE Program'!E45","v":105.75},null,null,35,10.499000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.499000000000001]
[null,{"$f":"'NanQ ONE Program'!A46","v":10.625},{"$f":"'NanQ ONE Program'!C46","v":106.5},{"$f":"'NanQ ONE Program'!D46","v":106.5},{"$f":"'NanQ ONE Program'!E46","v":106},null,null,36,10.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.625]
[null,{"$f":"'NanQ ONE Program'!A47","v":10.75},{"$f":"'NanQ ONE Program'!C47","v":106.75},{"$f":"'NanQ ONE Program'!D47","v":106.75},{"$f":"'NanQ ONE Program'!E47","v":106.25},null,null,37,10.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.75]
[null,{"$f":"'NanQ ONE Program'!A48","v":10.875},{"$f":"'NanQ ONE Program'!C48","v":107},{"$f":"'NanQ ONE Program'!D48","v":107},{"$f":"'NanQ ONE Program'!E48","v":106.5},null,null,38,10.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.875]
[null,{"$f":"'NanQ ONE Program'!A49","v":10.999000000000001},{"$f":"'NanQ ONE Program'!C49","v":107.25},{"$f":"'NanQ ONE Program'!D49","v":107.25},{"$f":"'NanQ ONE Program'!E49","v":106.75},null,null,39,10.999000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,10.999000000000001]
[null,{"$f":"'NanQ ONE Program'!A50","v":11.125},{"$f":"'NanQ ONE Program'!C50","v":107.5},{"$f":"'NanQ ONE Program'!D50","v":107.5},{"$f":"'NanQ ONE Program'!E50","v":107},null,null,40,{"$f":"B121","v":11.125},{"$f":"C121+$G$82","v":{"$error":"#N/A"}},{"$f":"D121+$G$82","v":{"$error":"#N/A"}},{"$f":"E121+$G$82","v":{"$error":"#N/A"}},null,11.125]
[null,{"$f":"'NanQ ONE Program'!A51","v":11.25},{"$f":"'NanQ ONE Program'!C51","v":107.75},{"$f":"'NanQ ONE Program'!D51","v":107.75},{"$f":"'NanQ ONE Program'!E51","v":107.25},null,null,41,11.25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,11.25]
[null,{"$f":"'NanQ ONE Program'!A52","v":11.375},{"$f":"'NanQ ONE Program'!C52","v":108},{"$f":"'NanQ ONE Program'!D52","v":108},{"$f":"'NanQ ONE Program'!E52","v":107.5},null,null,42,11.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,11.375]
[null,{"$f":"'NanQ ONE Program'!A53","v":11.499000000000001},{"$f":"'NanQ ONE Program'!C53","v":108.25},{"$f":"'NanQ ONE Program'!D53","v":108.25},{"$f":"'NanQ ONE Program'!E53","v":107.75},null,null,43,11.499000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,11.499000000000001]
[null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(IF(J88>'NanQ ONE Program'!V32,H88,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,J82:J125),H82:J125,3)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,J82:J125)+1,MATCH('NanQ ONE Program'!V32,J82:J125)))=44,43,IF(J88>'NanQ ONE Program'!V32,H88,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,J82:J125),H82:J125,3)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,J82:J125)+1,MATCH('NanQ ONE Program'!V32,J82:J125))))","v":{"$error":"#N/A"}},{"$f":"IF(IF(K88>'NanQ ONE Program'!V32,H88,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,K82:K125),H82:K125,4)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,K82:K125)+1,MATCH('NanQ ONE Program'!V32,K82:K125)))=44,43,IF(K88>'NanQ ONE Program'!V32,H88,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,K82:K125),H82:K125,4)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,K82:K125)+1,MATCH('NanQ ONE Program'!V32,K82:K125))))","v":{"$error":"#N/A"}},{"$f":"IF(IF(L90>'NanQ ONE Program'!V32,H90,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,L82:L125),H82:L125,5)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,L82:L125)+1,MATCH('NanQ ONE Program'!V32,L82:L125)))=44,43,IF(L90>'NanQ ONE Program'!V32,H90,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,L82:L125),H82:L125,5)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,L82:L125)+1,MATCH('NanQ ONE Program'!V32,L82:L125))))","v":{"$error":"#N/A"}},{"$f":"IF(IF(M82>'NanQ ONE Program'!V32,H82,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,M82:M100),H82:M100,6)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,M82:M100)+1,MATCH('NanQ ONE Program'!V32,M82:M100)))=19,18,IF(M82>'NanQ ONE Program'!V32,H82,IF(VLOOKUP(MATCH('NanQ ONE Program'!V32,M82:M100),H82:M100,6)<'NanQ ONE Program'!V32,MATCH('NanQ ONE Program'!V32,M82:M100)+1,MATCH('NanQ ONE Program'!V32,M82:M100))))","v":{"$error":"#N/A"}},"If rate stack height changes adjust the 3 cells to the left of this to match \"=44,43\" (Select is \"=19,18\")"]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J126,H82:I125,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K126,H82:I125,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L126,H82:L125,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M126,H82:M125,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Base Rate / Base Price",null,null,null,null,null,null,null,{"$f":"IF(G89=J81,J127,0)","v":0},{"$f":"IF(G89=K81,K127,0)","v":0},{"$f":"IF(G89=L81,L127,0)","v":0},{"$f":"IF(G89=M81,M127,0)","v":0}]
[null,"Coupon","Full Doc","Alt Doc","DSCR",null,null,null,null,{"$f":"VLOOKUP(J126,H82:J125,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K126,H82:K125,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L126,H82:L125,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M126,H82:M125,6,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"B82","v":6.25},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$f":"IF(G89=J81,J129,0)","v":0},{"$f":"IF(G89=K81,K129,0)","v":0},{"$f":"IF(G89=L81,L129,0)","v":0},{"$f":"IF(G89=M81,M129,0)","v":0},{"$f":"SUM(J128:M128)","v":0}]
[null,6.375,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,6.4989999999999997,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,{"$f":"SUM(J130:M130)","v":0}]
[null,6.625,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Base Rate / Base Price"]
[null,6.75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Coupon","Full Doc","Alt Doc","DSCR"]
[null,6.875,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,1,{"$f":"I82","v":6.25},{"$f":"C169+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D169+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E169+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,6.9989999999999997,98.75,98.75,{"$error":"#N/A"},null,null,2,6.375,{"$f":"C168+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D168+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E168+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.125,99,99,{"$error":"#N/A"},null,"Total LLPA",3,6.4989999999999997,{"$f":"C167+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D167+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E167+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.25,99.25,99.25,98.75,null,{"$f":"SUM('NanQ ONE Program'!V11:V25)","v":{"$error":"#N/A"}},4,6.625,{"$f":"C166+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D166+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E166+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.375,99.5,99.5,99,null,"LPC",5,6.75,{"$f":"C165+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D165+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E165+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.4989999999999997,99.75,99.75,99.25,null,{"$f":"'NanQ ONE Program'!V37","v":0},6,6.875,{"$f":"C164+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D164+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E164+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.625,100,100,99.5,null,null,7,6.9989999999999997,{"$f":"C163+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D163+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E163+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.75,100.25,100.25,99.75,null,"Total Price",8,7.125,{"$f":"C162+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D162+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E162+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.875,100.5,100.5,100,null,{"$f":"'NanQ ONE Program'!V38","v":0},9,7.25,{"$f":"C161+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D161+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E161+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,7.9989999999999997,101,101,100.5,null,null,10,7.375,{"$f":"C160+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D160+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E160+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.125,101.25,101.25,100.75,null,{"$f":"'NanQ ONE Program'!U13","v":"Choose a Selection"},11,7.4989999999999997,{"$f":"C159+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D159+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E159+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.25,101.5,101.5,101,null,null,12,7.625,{"$f":"C158+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D158+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E158+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.375,101.75,101.75,101.25,null,null,13,7.75,{"$f":"C157+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D157+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E157+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.4990000000000006,102,102,101.5,null,null,14,7.875,{"$f":"C156+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D156+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E156+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.625,102.25,102.25,101.75,null,null,15,7.9989999999999997,{"$f":"C155+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D155+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E155+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,{"$f":"B102","v":8.75},102.5,102.5,102,null,null,16,8.125,{"$f":"C154+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D154+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E154+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.875,102.75,102.75,102.25,null,null,17,8.25,{"$f":"C153+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D153+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E153+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,8.9990000000000006,103.25,103.25,102.75,null,null,18,8.375,{"$f":"C152+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D152+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E152+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.125,103.5,103.5,103,null,null,19,8.4990000000000006,{"$f":"C151+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D151+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E151+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.25,103.75,103.75,103.25,null,null,20,8.625,{"$f":"C150+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D150+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E150+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.375,104,104,103.5,null,null,21,8.75,{"$f":"C149+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D149+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E149+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.4990000000000006,104.25,104.25,103.75,null,null,22,8.875,{"$f":"C148+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D148+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E148+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.625,104.5,104.5,104,null,null,23,8.9990000000000006,{"$f":"C147+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D147+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E147+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.75,104.75,104.75,104.25,null,null,24,9.125,{"$f":"C146+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D146+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E146+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.875,105,105,104.5,null,null,25,9.25,{"$f":"C145+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D145+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E145+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,9.9990000000000006,105.25,105.25,104.75,null,null,26,9.375,{"$f":"C144+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D144+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E144+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.125,105.5,105.5,105,null,null,27,9.4990000000000006,{"$f":"C143+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D143+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E143+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.25,105.75,105.75,105.25,null,null,28,9.625,{"$f":"C142+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D142+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E142+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.375,106,106,105.5,null,null,29,9.75,{"$f":"C141+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D141+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E141+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.499000000000001,106.25,106.25,105.75,null,null,30,9.875,{"$f":"C140+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D140+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E140+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.625,106.5,106.5,106,null,null,31,9.9990000000000006,{"$f":"C139+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D139+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E139+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.75,106.75,106.75,106.25,null,null,32,10.125,{"$f":"C138+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D138+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E138+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.875,107,107,106.5,null,null,33,10.25,{"$f":"C137+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D137+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E137+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,10.999000000000001,107.25,107.25,106.75,null,null,34,10.375,{"$f":"C136+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D136+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E136+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,11.125,107.5,107.5,107,null,null,35,10.499000000000001,{"$f":"C135+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D135+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E135+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,36,10.625,{"$f":"C134+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D134+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E134+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,37,10.75,{"$f":"C133+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D133+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E133+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,38,10.875,{"$f":"C132+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D132+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E132+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,39,10.999000000000001,{"$f":"C131+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D131+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E131+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,40,11.125,{"$f":"C130+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"D130+$G$138-$G$140","v":{"$error":"#N/A"}},{"$f":"E130+$G$138-$G$140","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,41,null,{"$f":"MATCH(100,J135:J174,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K135:K174,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L135:L174,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,42,"Par Rates",{"$f":"VLOOKUP(J175,H135:I179,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K175,H135:I179,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L175,H135:L179,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Near Par Rate - BPC",null,{"$f":"IF(E177=0,\"\",N130)","v":""},{"$f":"IF(N132>D32,D32,N132)","v":0},null,null,43,null,{"$f":"IF(G145=J134,J176,0)","v":0},{"$f":"IF(G145=K134,K176,0)","v":0},{"$f":"IF(G145=L134,L176,0)","v":0}]
[null,"Near Par Rate - BPC",null,null,{"$f":"IF(E177>'NanQ ONE Program'!V32,'NanQ ONE Program'!V32,E177)","v":0},null,null,44,null,{"$f":"VLOOKUP(J175,H135:J179,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K175,H135:K179,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L175,H135:L179,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,45,null,{"$f":"IF(G145=J134,J178,0)","v":0},{"$f":"IF(G145=K134,K178,0)","v":0},{"$f":"IF(G145=L134,L178,0)","v":0},{"$f":"SUM(J177:L177)","v":0}]
[null,"Near Par Rate - LPC",null,{"$f":"M179","v":0},{"$f":"M181","v":0}]
[null,"Near Par Rate - LPC",null,null,{"$f":"IF(E180>V31,E180)","v":false},null,null,null,null,null,null,null,{"$f":"SUM(J179:L179)","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":[]}