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

{"sheet":"NanQ ONE Program","index":0,"n_rows":65,"n_cols":26,"rows_kept":65,"cut":false,"hidden":false,"merged":[[7,21,7,23],[8,21,8,23],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[9,21,9,23],[18,18,18,20],[10,4,10,5],[11,4,11,5],[13,18,13,20],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[9,4,9,5],[8,18,8,20],[9,18,9,20],[64,19,64,21],[62,16,62,18],[63,16,63,18],[64,16,64,18],[54,16,54,18],[10,17,10,20],[12,17,12,20],[28,18,28,20],[53,19,53,21],[54,19,54,21],[55,19,55,21],[56,19,56,21],[57,19,57,21],[58,19,58,21],[60,19,60,21],[61,19,61,21],[55,16,55,18],[56,16,56,18],[17,17,17,20],[24,18,24,20],[11,17,11,20],[29,18,29,20],[30,18,30,20],[20,18,20,20],[57,16,57,18],[58,16,58,18],[59,16,59,18],[60,16,60,18],[61,16,61,18],[59,19,59,21],[10,0,13,0],[62,19,62,21],[63,19,63,21],[53,16,53,18],[44,4,44,5],[53,4,53,5],[51,16,51,18],[52,16,52,18],[51,19,51,21],[52,19,52,21],[49,16,49,18],[15,18,15,20],[19,4,19,5],[37,4,37,5],[23,4,23,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[45,10,45,11],[25,4,25,5],[26,4,26,5],[39,13,46,21],[38,13,38,21],[48,4,48,6],[35,16,35,19],[36,16,36,19],[29,4,29,5],[30,4,30,5],[27,4,27,5],[28,4,28,5],[25,18,25,20],[26,18,26,20],[27,18,27,20],[52,4,52,5],[45,4,45,5],[50,4,50,5],[49,4,49,6],[48,8,48,10],[49,8,49,10],[52,8,52,10],[38,6,39,11],[31,14,31,15],[46,10,46,11],[47,4,47,5],[34,13,34,15],[36,13,36,15],[48,13,48,21],[51,13,51,15],[44,8,44,9],[41,4,41,11],[42,4,42,7],[38,4,38,5],[39,4,39,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[46,4,46,6],[54,13,54,15],[49,13,49,15],[50,16,50,18],[19,18,19,20],[16,18,16,20],[25,13,25,14],[16,13,16,14],[31,17,31,20],[43,6,43,7],[44,6,44,7],[45,6,45,7],[43,10,43,11],[44,10,44,11],[33,16,33,20],[24,13,24,14],[22,13,22,14],[21,13,21,14],[30,14,30,15],[29,14,29,15],[45,8,45,9],[46,8,46,9],[47,8,47,11],[34,16,34,20],[35,13,35,15],[50,19,50,21],[49,19,49,21],[51,4,51,5],[60,13,60,15],[61,13,61,15],[62,13,62,15],[63,13,63,15],[64,13,64,15],[59,13,59,15],[55,13,55,15],[56,13,56,15],[57,13,57,15],[58,13,58,15],[54,4,54,6],[46,7,56,7],[55,8,55,10],[56,8,56,10],[50,8,50,10],[51,8,51,10],[53,8,53,10],[54,8,54,10],[52,13,52,15],[50,13,50,15],[53,13,53,15],[0,4,1,7],[2,4,2,7],[3,4,3,7],[0,9,1,11],[4,9,4,11],[5,1,6,11],[8,4,8,11],[21,4,21,11],[4,7,4,8],[2,9,2,11],[3,9,3,11],[5,13,6,20],[7,18,7,20],[28,14,28,15],[23,17,23,20],[33,13,33,15],[21,18,21,20],[8,1,8,2],[43,8,43,9],[42,8,42,11],[23,13,23,14],[12,13,12,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[22,4,22,5],[43,4,43,5],[24,4,24,5],[22,18,22,20]]}
[null,null,null,null,{"$f":"[4]!Input_Stamp_Header03","v":"LoanStream Mortgage"},null,null,null,null,{"$f":"[4]Calc!$BP$89","v":"Commercial Ratesheet"}]
[]
[null,null,null,null,{"$f":"[4]!Input_Stamp_Header04","v":"19000 MacArthur Blvd, Suite 200"},null,null,null,null,{"$f":"[4]!Input_Stamp_Header01","v":"30 Day Lock Period"}]
[null,null,null,null,{"$f":"[4]!Input_Stamp_Header05","v":"Irvine, CA 92612"},null,null,null,null,{"$f":"[4]!Input_Stamp_Header02","v":"Borrower Paid Compensation"}]
[null,null,null,null,null,null,null,"Effective Date:",null,{"$f":"[4]Calc!BU85","v":"2019-12-02"}]
[null,"NanQ \"ONE\" Program",null,null,null,null,null,null,null,null,null,null,null,{"$f":"[4]Calc!AS87","v":"PriceOne NANQ Program"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs",null,null,{"$f":"[4]Calc!$AN$90","v":"CM Ratesheet"},null,null,"DSCR/No Ratio Column Includes"]
[null,{"$f":"[4]Calc!AB93","v":"Base Rate / Base Price"},null,null,{"$f":"[4]Calc!AP93","v":"FICO/LTV Price Adjustments"},null,null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,null,{"$f":"[4]Calc!BY94","v":"DSCR"}]
[null,{"$f":"[4]Calc!AB94","v":"Coupon"},"DSCR/No Ratio",null,null,null,{"$f":"[4]Calc!AT94","v":"<=50"},{"$f":"[4]Calc!AU94","v":"50.01-60"},{"$f":"[4]Calc!AV94","v":"60.01-65"},{"$f":"[4]Calc!AW94","v":"65.01-70"},{"$f":"[4]Calc!AX94","v":"70.01-75"},{"$f":"[4]Calc!AY94","v":"75.01-80"},null,"LTV Range",null,null,null,null,null,null,null,{"$f":"[4]Calc!BY95","v":"No Ratio"}]
[null,{"$f":"[4]Calc!AB99","v":4.4989999999999997},{"$f":"[4]Calc!AO99","v":98.125},null,{"$f":"[4]Calc!AP95","v":"780+"},null,{"$f":"[4]Calc!BR94","v":0},{"$f":"[4]Calc!BS94","v":0},{"$f":"[4]Calc!BT94","v":-0.2},{"$f":"[4]Calc!BU94","v":-0.3},{"$f":"[4]Calc!BV94","v":-0.6},{"$f":"[4]Calc!BW94","v":-0.65},null,"FICO Range",null,null,{"$f":"INDEX(G11:L20,MATCH(P11,E11:E20,0),MATCH(P10,G10:L10))","v":{"$error":"#N/A"}},"Minimum Rate is 4.99% on DSCR & No Ratio"]
[null,{"$f":"[4]Calc!AB100","v":4.625},{"$f":"[4]Calc!AO100","v":98.375},null,{"$f":"[4]Calc!AP96","v":"760-779"},null,{"$f":"[4]Calc!BR95","v":0},{"$f":"[4]Calc!BS95","v":0},{"$f":"[4]Calc!BT95","v":-0.30000000000000004},{"$f":"[4]Calc!BU95","v":-0.39999999999999991},{"$f":"[4]Calc!BV95","v":-0.69999999999999984},{"$f":"[4]Calc!BW95","v":-0.75},null,"Grade",null,null,{"$f":"INDEX(G44:G46,MATCH(P12,E44:E46,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB101","v":4.75},{"$f":"[4]Calc!AO101","v":98.625},null,{"$f":"[4]Calc!AP97","v":"740-759"},null,{"$f":"[4]Calc!BR96","v":-0.2},{"$f":"[4]Calc!BS96","v":-0.30000000000000027},{"$f":"[4]Calc!BT96","v":-0.39999999999999991},{"$f":"[4]Calc!BU96","v":-0.59999999999999987},{"$f":"[4]Calc!BV96","v":-0.79999999999999993},{"$f":"[4]Calc!BW96","v":-1},null,"Doc Type"]
[null,{"$f":"[4]Calc!AB102","v":4.875},{"$f":"[4]Calc!AO102","v":98.875},null,{"$f":"[4]Calc!AP98","v":"720-739"},null,{"$f":"[4]Calc!BR97","v":-0.3},{"$f":"[4]Calc!BS97","v":-0.4},{"$f":"[4]Calc!BT97","v":-0.5},{"$f":"[4]Calc!BU97","v":-0.69999999999999984},{"$f":"[4]Calc!BV97","v":-0.89999999999999991},{"$f":"[4]Calc!BW97","v":-1.05},null,"Doc Type +",null,null,{"$f":"IF(P14=\"None of the Above\",0,INDEX(G$24:L$40,MATCH(P14,E$24:E$40,0),MATCH(P$10,G$23:L$23,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB103","v":4.99},{"$f":"[4]Calc!AO103","v":99.125},null,{"$f":"[4]Calc!AP99","v":"700-719"},null,{"$f":"[4]Calc!BR98","v":-0.4},{"$f":"[4]Calc!BS98","v":-0.49999999999999978},{"$f":"[4]Calc!BT98","v":-0.69999999999999984},{"$f":"[4]Calc!BU98","v":-0.99999999999999989},{"$f":"[4]Calc!BV98","v":-1.2},{"$f":"[4]Calc!BW98","v":-1.75},null,"Citizenships",null,null,{"$f":"IF(P15=\"US Citizen\",0,IF(P15=\"Permanent Resident\",0,IF(P15=\"Non Perm Resident\",0,INDEX(G$24:L$40,MATCH(P15,E$24:E$40,0),MATCH(P$10,G$23:L$23,0)))))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB104","v":5.125},{"$f":"[4]Calc!AO104","v":99.375},null,{"$f":"[4]Calc!AP100","v":"680-699"},null,{"$f":"[4]Calc!BR99","v":-0.6},{"$f":"[4]Calc!BS99","v":-0.69999999999999984},{"$f":"[4]Calc!BT99","v":-0.99999999999999989},{"$f":"[4]Calc!BU99","v":-1.4},{"$f":"[4]Calc!BV99","v":-1.7},{"$f":"[4]Calc!BW99","v":-2.5},null,"Loan Balance",null,null,{"$f":"INDEX(G$24:L$40,MATCH(P16,E$24:E$40,0),MATCH(P$10,G$23:L$23,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB105","v":5.25},{"$f":"[4]Calc!AO105","v":99.625},null,{"$f":"[4]Calc!AP101","v":"660-679"},null,{"$f":"[4]Calc!BR100","v":-1},{"$f":"[4]Calc!BS100","v":-1.0999999999999999},{"$f":"[4]Calc!BT100","v":-1.2999999999999998},{"$f":"[4]Calc!BU100","v":-1.75},{"$f":"[4]Calc!BV100","v":-2.1},{"$f":"[4]Calc!BW100","v":-3.05},null,"Purpose",null,null,{"$f":"IF(OR(P17=\"Purchase\",P17=\"Rate/Term Refi\"),0,INDEX(G$24:L$40,MATCH(P17,E$24:E$40,0),MATCH(P$10,G$23:L$23,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB106","v":5.375},{"$f":"[4]Calc!AO106","v":99.875},null,{"$f":"[4]Calc!AP102","v":"640-659"},null,{"$f":"[4]Calc!BR101","v":-1.2},{"$f":"[4]Calc!BS101","v":-1.3},{"$f":"[4]Calc!BT101","v":-1.6},{"$f":"[4]Calc!BU101","v":-1.9},{"$f":"[4]Calc!BV101","v":-2.6},{"$f":"[4]Calc!BW101","v":-3.75},null,"Occupancy",null,null,{"$f":"IF(OR(P18=\"Primary\"),0,IF(OR(P18=\"Non-Owner (DSCR/No Ratio)\"),0,INDEX(G$24:L$40,MATCH(P18,E$24:E$40,0),MATCH(P$10,G$23:L$23,0))))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB107","v":5.4989999999999997},{"$f":"[4]Calc!AO107","v":100.125},null,{"$f":"[4]Calc!AP103","v":"620-639"},null,{"$f":"[4]Calc!BR102","v":-1.4},{"$f":"[4]Calc!BS102","v":-1.5},{"$f":"[4]Calc!BT102","v":-1.9},{"$f":"[4]Calc!BU102","v":-2.9},{"$f":"[4]Calc!BV102","v":-3.4},{"$f":"[4]Calc!BW102","v":-4.45},null,"Property Type",null,null,{"$f":"IF(OR(P19=\"SFR\",P19=\"1-2 Units\",P19=\"PUD\",P19=\"Condo\"),0,INDEX(G$24:L$40,MATCH(P19,E$24:E$40,0),MATCH(P$10,G$23:L$23,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB108","v":5.625},{"$f":"[4]Calc!AO108","v":100.375},null,{"$f":"[4]Calc!AP105","v":"Foreign National"},null,{"$f":"[4]Calc!BR103","v":-0.39999999999999991},{"$f":"[4]Calc!BS103","v":-0.69999999999999984},{"$f":"[4]Calc!BT103","v":-1.2},{"$f":"[4]Calc!BU103","v":-2},{"$f":"[4]Calc!BV103","v":-3},{"$f":"[4]Calc!BW103","v":{"$error":"#N/A"}},null,"Loan Term",null,null,{"$f":"INDEX(L49:L57,MATCH(P20,I49:I57,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB109","v":5.75},{"$f":"[4]Calc!AO109","v":100.625},null,null,null,null,null,null,null,null,null,null,"Escrow",null,null,{"$f":"IF(P21=\"Escrow Not Waived\",0,INDEX(G$24:L$40,MATCH(P21,E$24:E$40,0),MATCH(P$10,G$23:L$23,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB110","v":5.875},{"$f":"[4]Calc!AO110","v":100.875},null,{"$f":"[4]Calc!AP107","v":"Loan Level Price Adjustments"},null,null,null,null,null,null,null,null,"State",null,"All Other States",0]
[null,{"$f":"[4]Calc!AB111","v":5.99},{"$f":"[4]Calc!AO111","v":101.125},null,null,null,{"$f":"[4]Calc!AT108","v":"<=50"},{"$f":"[4]Calc!AU108","v":"50.01-60"},{"$f":"[4]Calc!AV108","v":"60.01-65"},{"$f":"[4]Calc!AW108","v":"65.01-70"},{"$f":"[4]Calc!AX108","v":"70.01-75"},{"$f":"[4]Calc!AY108","v":"75.01-80"},null,"Prepayment Penalty",null,"12 Months PPP",{"$f":"IF(P22=\"All Other States\",INDEX(G$24:L$40,MATCH(P23,E$24:E$40,0),MATCH(P$10,G$23:L$23,0)),0)","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB112","v":6.125},{"$f":"[4]Calc!AO112","v":101.375},null,{"$f":"[4]Calc!BP107","v":"Foreign National"},{"$f":"[4]Calc!BQ107","v":0},{"$f":"[4]Calc!BR107","v":-0.5},{"$f":"[4]Calc!BS107","v":-0.75},{"$f":"[4]Calc!BT107","v":-1},{"$f":"[4]Calc!BU107","v":-1.25},{"$f":"[4]Calc!BV107","v":-1.5},{"$f":"[4]Calc!BW107","v":{"$error":"#N/A"}},null,"Lock Term",null,"30 Day",{"$f":"INDEX(G51:G54,MATCH(P24,E51:E54,0))","v":0}]
[null,{"$f":"[4]Calc!AB113","v":6.25},{"$f":"[4]Calc!AO113","v":101.625},null,{"$f":"[4]Calc!BP108","v":"Cash-Out"},null,{"$f":"[4]Calc!BR108","v":-0.6},{"$f":"[4]Calc!BS108","v":-0.6},{"$f":"[4]Calc!BT108","v":-0.6},{"$f":"[4]Calc!BU108","v":-0.8},{"$f":"[4]Calc!BV108","v":-1},{"$f":"[4]Calc!BW108","v":-1},null,"December Special",null,{"$f":"IF(P17=\"Purchase\",\"Qualifies for Dec. Special\",\"Doesn’t Qualify This Time :(\")","v":"Doesn’t Qualify This Time :("},{"$f":"IF(P17=\"Purchase\",0.25,0)","v":0}]
[null,{"$f":"[4]Calc!AB114","v":6.375},{"$f":"[4]Calc!AO114","v":101.875},null,{"$f":"[4]Calc!BP109","v":"3-4 Units"},{"$f":"[4]Calc!BQ109","v":0},{"$f":"[4]Calc!BR109","v":-0.7},{"$f":"[4]Calc!BS109","v":-0.7},{"$f":"[4]Calc!BT109","v":-0.7},{"$f":"[4]Calc!BU109","v":-0.7},{"$f":"[4]Calc!BV109","v":-0.7},{"$f":"[4]Calc!BW109","v":-0.7},null,"Exception Adj",null,"To Be Input By Secondary",0,null,null,null,null,null,null,null,"Minimum rate rule",{"$f":"IF(AND(P9<=4.98,P12=\"DSCR\"),1,IF(AND(P9<=4.98,P12=\"No Ratio\"),1,0))","v":0}]
[null,{"$f":"[4]Calc!AB115","v":6.4989999999999997},{"$f":"[4]Calc!AO115","v":102.125},null,{"$f":"[4]Calc!BP110","v":"DSCR/No Ratio ≤639"},{"$f":"[4]Calc!BQ110","v":0},{"$f":"[4]Calc!BR110","v":-1},{"$f":"[4]Calc!BS110","v":-1},{"$f":"[4]Calc!BT110","v":-1},{"$f":"[4]Calc!BU110","v":-1},{"$f":"[4]Calc!BV110","v":-1.5},{"$f":"[4]Calc!BW110","v":-1.75},null,null,"  Total LLPA",null,{"$f":"SUM(Q11:Q26)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Loan Amount rule",{"$f":"IF(Q16<5,0,1)","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB116","v":6.625},{"$f":"[4]Calc!AO116","v":102.375},null,{"$f":"[4]Calc!BP111","v":"Escrow Waived"},{"$f":"[4]Calc!BQ111","v":0},{"$f":"[4]Calc!BR111","v":-0.25},{"$f":"[4]Calc!BS111","v":-0.25},{"$f":"[4]Calc!BT111","v":-0.25},{"$f":"[4]Calc!BU111","v":-0.25},{"$f":"[4]Calc!BV111","v":-0.25},{"$f":"[4]Calc!BW111","v":-0.25},null,null,null,null,null,null,null,null,null,null,null,null,"Impounds rule",{"$f":"IF(NOT(P21=\"Escrow Waived\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AB117","v":6.75},{"$f":"[4]Calc!AO117","v":102.625},null,{"$f":"[4]Calc!BP112","v":"NW Condo"},{"$f":"[4]Calc!BQ112","v":0},{"$f":"[4]Calc!BR112","v":-0.75},{"$f":"[4]Calc!BS112","v":-0.875},{"$f":"[4]Calc!BT112","v":-1},{"$f":"[4]Calc!BU112","v":-1.25},{"$f":"[4]Calc!BV112","v":{"$error":"#N/A"}},{"$f":"[4]Calc!BW112","v":{"$error":"#N/A"}},null,null,"  Gross Rate Sheet Price (Prior to LLPAs)",null,{"$f":"INDEX(B11:C55,MATCH(P9,B11:B55,0),MATCH(P13,C10,0)+1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Texas rule",{"$f":"IF(NOT(P22=\"Texas\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AB118","v":6.875},{"$f":"[4]Calc!AO118","v":102.875},null,{"$f":"[4]Calc!BP113","v":"12 Months PPP"},{"$f":"[4]Calc!BQ113","v":0},{"$f":"[4]Calc!BR113","v":0},{"$f":"[4]Calc!BS113","v":0},{"$f":"[4]Calc!BT113","v":0},{"$f":"[4]Calc!BU113","v":0},{"$f":"[4]Calc!BV113","v":0},{"$f":"[4]Calc!BW113","v":0},null,null,"  Max YSP",null,{"$f":"IF(P22=\"All Other States\",Feed!E56,Feed!E57)","v":100},null,null,null,null,null,null,null,"PPP Rule",{"$f":"IF(P22=\"All Other States\",0,1)","v":0}]
[null,{"$f":"[4]Calc!AB119","v":6.99},{"$f":"[4]Calc!AO119","v":103.125},null,{"$f":"[4]Calc!BP114","v":"24 Months PPP"},{"$f":"[4]Calc!BQ114","v":0},{"$f":"[4]Calc!BR114","v":0.25},{"$f":"[4]Calc!BS114","v":0.25},{"$f":"[4]Calc!BT114","v":0.25},{"$f":"[4]Calc!BU114","v":0.25},{"$f":"[4]Calc!BV114","v":0.25},{"$f":"[4]Calc!BW114","v":0.25},null,null,"  Net Price: Rate Sheet - LLPA (Prior to Max YSP)",null,{"$f":"IFERROR(Q29+Q27,\"Minimum Rate\")","v":"Minimum Rate"}]
[null,{"$f":"[4]Calc!AB120","v":7.125},{"$f":"[4]Calc!AO120","v":103.375},null,{"$f":"[4]Calc!BP115","v":"36 Months PPP"},{"$f":"[4]Calc!BQ115","v":0},{"$f":"[4]Calc!BR115","v":0.5},{"$f":"[4]Calc!BS115","v":0.5},{"$f":"[4]Calc!BT115","v":0.5},{"$f":"[4]Calc!BU115","v":0.5},{"$f":"[4]Calc!BV115","v":0.5},{"$f":"[4]Calc!BW115","v":0.5},null,null,"  Net Rate Sheet Price - As Borrower Paid (BPC)",null,{"$f":"IF(Q31>Q30,Q30,Q31)","v":100},{"$f":"CONCATENATE(Feed!B173,\" \",Feed!D173,\"%\" &\" @ \"&Feed!E173)","v":"Near Par Rate - BPC 0% @ 0"}]
[null,{"$f":"[4]Calc!AB121","v":7.25},{"$f":"[4]Calc!AO121","v":103.625},null,{"$f":"[4]Calc!BP116","v":"48 Months PPP"},{"$f":"[4]Calc!BQ116","v":0},{"$f":"[4]Calc!BR116","v":0.75},{"$f":"[4]Calc!BS116","v":0.75},{"$f":"[4]Calc!BT116","v":0.75},{"$f":"[4]Calc!BU116","v":0.75},{"$f":"[4]Calc!BV116","v":0.75},{"$f":"[4]Calc!BW116","v":0.75}]
[null,{"$f":"[4]Calc!AB122","v":7.375},{"$f":"[4]Calc!AO122","v":103.875},null,{"$f":"[4]Calc!BP117","v":"60 Months PPP"},{"$f":"[4]Calc!BQ117","v":0},{"$f":"[4]Calc!BR117","v":0.75},{"$f":"[4]Calc!BS117","v":0.75},{"$f":"[4]Calc!BT117","v":0.75},{"$f":"[4]Calc!BU117","v":0.75},{"$f":"[4]Calc!BV117","v":0.75},{"$f":"[4]Calc!BW117","v":0.75},null,"Loan Number",null,null,"Borrower Name"]
[null,{"$f":"[4]Calc!AB123","v":7.4989999999999997},{"$f":"[4]Calc!AO123","v":104.125},null,{"$f":"[4]Calc!BP118","v":"<=$150,000"},{"$f":"[4]Calc!BQ118","v":0},{"$f":"[4]Calc!BR118","v":-0.7},{"$f":"[4]Calc!BS118","v":-0.7},{"$f":"[4]Calc!BT118","v":-0.7},{"$f":"[4]Calc!BU118","v":-0.7},{"$f":"[4]Calc!BV118","v":-1},{"$f":"[4]Calc!BW118","v":-1.2}]
[null,{"$f":"[4]Calc!AB124","v":7.625},{"$f":"[4]Calc!AO124","v":104.375},null,{"$f":"[4]Calc!BP119","v":"$150,001-$1,500,000"},{"$f":"[4]Calc!BQ119","v":0},{"$f":"[4]Calc!BR119","v":0},{"$f":"[4]Calc!BS119","v":0},{"$f":"[4]Calc!BT119","v":0},{"$f":"[4]Calc!BU119","v":0},{"$f":"[4]Calc!BV119","v":0},{"$f":"[4]Calc!BW119","v":0},null,"Property Address",null,null,"Compensation Type",null,null,null,0]
[null,{"$f":"[4]Calc!AB125","v":7.75},{"$f":"[4]Calc!AO125","v":104.625},null,{"$f":"[4]Calc!BP120","v":"$1,500,001-$3,000,000"},{"$f":"[4]Calc!BQ120","v":0},{"$f":"[4]Calc!BR120","v":0},{"$f":"[4]Calc!BS120","v":-0.125},{"$f":"[4]Calc!BT120","v":-0.125},{"$f":"[4]Calc!BU120","v":-0.25},{"$f":"[4]Calc!BV120","v":-0.5},{"$f":"[4]Calc!BW120","v":-0.75},null,null,null,null,"Choose a Selection",null,null,null,0]
[null,{"$f":"[4]Calc!AB126","v":7.875},{"$f":"[4]Calc!AO126","v":104.875},null,{"$f":"[4]Calc!BP121","v":"$3,000,001-$5,000,000"},{"$f":"[4]Calc!BQ121","v":0},{"$f":"[4]Calc!BR121","v":-1.5},{"$f":"[4]Calc!BS121","v":-2},{"$f":"[4]Calc!BT121","v":-2.5},{"$f":"[4]Calc!BU121","v":-3},{"$f":"[4]Calc!BV121","v":{"$error":"#N/A"}},{"$f":"[4]Calc!BW121","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB127","v":7.99},{"$f":"[4]Calc!AO127","v":105.125},null,{"$f":"[4]Calc!BP122","v":"$5,000,001-$7,500,000"},{"$f":"[4]Calc!BQ122","v":0},"Please reach out to the Lock Desk to Price Loans >5MM"]
[null,{"$f":"[4]Calc!AB128","v":8.125},{"$f":"[4]Calc!AO128","v":105.375},null,{"$f":"[4]Calc!BP123","v":"$7,500,001-$10,000,000"},{"$f":"[4]Calc!BQ123","v":0},null,null,null,null,null,null,null,"6 months interest on 80% of the original principal balance \n(Standard Term = 3 years); \nNot allowed in IL*, MD, MI, MN, ND, NJ*, NM, PA                                                                                                                                                                        \n\n*Prepay Penalty allowed for loans closed in the name of corporations \nor LLCs in IL, and NJ"]
[null,{"$f":"[4]Calc!AB129","v":8.25},{"$f":"[4]Calc!AO129","v":105.625}]
[null,{"$f":"[4]Calc!AB130","v":8.375},{"$f":"[4]Calc!AO130","v":105.875}]
[null,{"$f":"[4]Calc!AB131","v":8.4990000000000006},{"$f":"[4]Calc!AO131","v":106.125},null,{"$f":"[4]Calc!AV137","v":"Grades"},null,null,null,{"$f":"[4]Calc!BD152","v":"Minimum Rates by Grade"}]
[null,{"$f":"[4]Calc!AB132","v":8.625},{"$f":"[4]Calc!AO132","v":106.375},null,{"$f":"[4]Calc!AV144","v":"Select - DSCR"},null,0.5,null,"Select DSCR",null,"DSCR / No Ratio"]
[null,{"$f":"[4]Calc!AB133","v":8.75},{"$f":"[4]Calc!AO133","v":106.625},null,{"$f":"[4]Calc!AV145","v":"DSCR"},null,{"$f":"[4]Calc!AX145","v":0},null,4.4999999999999998E-2,null,4.99E-2]
[null,{"$f":"[4]Calc!AB134","v":8.875},{"$f":"[4]Calc!AO134","v":109},null,{"$f":"[4]Calc!AV146","v":"No Ratio"},null,{"$f":"[4]Calc!AX146","v":-0.5},null,{"$f":"[4]Calc!BF148","v":"Floor"},null,{"$f":"[4]Calc!BG148","v":"Index"}]
[null,{"$f":"[4]Calc!AB135","v":8.99},{"$f":"[4]Calc!AO135","v":109.25},null,{"$f":"[4]Calc!BP133","v":"Extension Cost"},null,null,null,{"$f":"[4]Calc!BF149","v":"= Margin"},null,{"$f":"[4]Calc!BG149","v":"1YR Libor"}]
[null,{"$f":"[4]Calc!AB136","v":9.125},{"$f":"[4]Calc!AO136","v":109.5},null,{"$f":"[4]Calc!BQ134","v":"2 Bps (0.02)"},null,"Per Day",null,{"$f":"[4]Calc!AP137","v":"Loan Term"}]
[null,{"$f":"[4]Calc!AB137","v":9.25},{"$f":"[4]Calc!AO137","v":109.75},null,null,null,null,null,{"$f":"[4]Calc!AP138","v":"5/1 30YR ARM"},null,null,{"$f":"[4]Calc!AT138","v":0},null,"Quick Reference to the Matrix"]
[null,{"$f":"[4]Calc!AB138","v":9.375},{"$f":"[4]Calc!AO138","v":110},null,{"$f":"[4]Calc!BP136","v":"Lock Days"},null,null,null,{"$f":"[4]Calc!AP139","v":"5/1 30YR IO ARM"},null,null,{"$f":"[4]Calc!AT139","v":-0.05},null,"Credit/Grade:",null,null,"Select DSCR",null,null,"DSCR/No Ratio"]
[null,{"$f":"[4]Calc!AB139","v":9.4990000000000006},{"$f":"[4]Calc!AO139","v":110.25},null,{"$f":"[4]Calc!BP137","v":"15 Day"},null,{"$f":"[4]Calc!BR137","v":0.15},null,{"$f":"[4]Calc!AP140","v":"5/1 40YR IO ARM"},null,null,{"$f":"[4]Calc!AT140","v":-0.1},null,"Minimum FICO",null,null,680,null,null,"620 > 1.00/640 < 1.00"]
[null,{"$f":"[4]Calc!AB140","v":9.625},{"$f":"[4]Calc!AO140","v":110.5},null,{"$f":"[4]Calc!BP138","v":"30 Day"},null,{"$f":"[4]Calc!BR138","v":0},null,{"$f":"[4]Calc!AP141","v":"7/1 30YR ARM"},null,null,{"$f":"[4]Calc!AT141","v":-0.1},null,"Minimum Loan Amount",null,null,150000,null,null,100000]
[null,{"$f":"[4]Calc!AB141","v":9.75},{"$f":"[4]Calc!AO141","v":110.75},null,{"$f":"[4]Calc!BP139","v":"45 Day"},null,{"$f":"[4]Calc!BR139","v":-0.125},null,{"$f":"[4]Calc!AP142","v":"7/1 30YR IO ARM"},null,null,{"$f":"[4]Calc!AT142","v":-0.15},null,"Maximum Loan Amount",null,null,3000000,null,null,10000000]
[null,{"$f":"[4]Calc!AB142","v":9.875},{"$f":"[4]Calc!AO142","v":111},null,{"$f":"[4]Calc!BP140","v":"60 Day"},null,{"$f":"[4]Calc!BR140","v":-0.375},null,{"$f":"[4]Calc!AP143","v":"7/1 40YR IO ARM"},null,null,{"$f":"[4]Calc!AT143","v":-0.2},null,"Housing History",null,null,"0x30x12",null,null,"1x30x12 DSCR / 0x30x12 No Ratio"]
[null,{"$f":"[4]Calc!AB143","v":9.99},{"$f":"[4]Calc!AO143","v":111.25},null,{"$f":"[4]Calc!BP141","v":"Margins"},null,null,null,{"$f":"[4]Calc!AP144","v":"15YR Fixed"},null,null,{"$f":"[4]Calc!AT144","v":0.25},null,"Credit Events",null,null,"48 Months",null,null,"36 Months (12 on BK 13 & 24 SS/DIL)"]
[null,null,null,null,{"$f":"[4]Calc!BP142","v":"Select DSCR"},{"$f":"[4]Calc!BQ142","v":"DSCR"},{"$f":"[4]Calc!BR142","v":"No Ratio"},null,{"$f":"[4]Calc!AP145","v":"30YR Fixed"},null,null,{"$f":"[4]Calc!AT145","v":-0.4},null,"Non Owner Occupied",null,null,"NA",null,null,"No Ratio 5% Red./Max 75%"]
[null,{"$f":"[4]Calc!BD148","v":"Term"},{"$f":"[4]Calc!BE148","v":"Caps"},null,{"$f":"[4]Calc!BP143","v":5},{"$f":"[4]Calc!BQ143","v":6},{"$f":"[4]Calc!BR143","v":6},null,{"$f":"[4]Calc!AP146","v":"30/40YR IO Fixed"},null,null,{"$f":"[4]Calc!AT146","v":-0.5},null,"Cash out",null,null,"5% Reduction/Max 75%",null,null,"5% Reduction/Max 70%"]
[null,{"$f":"[4]Calc!BD149","v":"5/1 ARM"},{"$f":"[4]Calc!BE149","v":"2/2/5"},null,null,null,null,null,null,null,null,null,null,"Second Home ",null,null,"NA",null,null,"NA"]
[null,{"$f":"[4]Calc!BD150","v":"7/1 ARM"},{"$f":"[4]Calc!BE150","v":"5/2/5"},null,null,null,null,null,null,null,null,null,null,"Condo",null,null,"Max 70%",null,null,"Max 75%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo Non-Warrantable",null,null,"NA",null,null,"Max 70%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-4 Unit",null,null,"NA",null,null,"5% Reduction/Max 70%"]
[null,null,null,null,null,null,null,null,null,"-",null,null,null,"Rural Properties",null,null,"NA",null,null,"NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Residual Income",null,null,"NA",null,null,"NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Citizenship Restrictions",null,null,"No ITIN or Foreign Nat.",null,null,"No ITIN or Foreign Nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Income Restrictions",null,null,"Minimum 1YR PPP",null,null,"NA"]

{"sheet":"Feed","index":1,"n_rows":175,"n_cols":29,"rows_kept":175,"cut":false,"hidden":true,"merged":[[174,1,174,2],[50,7,50,8],[69,1,69,4],[69,8,69,11],[118,1,118,4],[122,8,122,11]]}
["FICO","LTV","Grades","Doc Type","Doc +","Loan Amount","Prepayment Penalties","Escrow Waiver","Purpose","Property Type","Occupancy","Term","Lock Period","Comp Type","Citizenships",null,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","Non-Owner (DSCR/No Ratio)","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection",null,null,null,null,"State","Availability","No Penalty","12 Months","24 Months","36 Months","48 Months","60 Months",null,"Compensation Type"]
["780+","<=50","Select - DSCR","DSCR/No Ratio","DSCR/No Ratio ≤639","<=$150,000","12 Months PPP","Escrow Not Waived","Purchase","SFR",null,"5/1 30YR ARM","15 Day","Borrower Paid","US Citizen",null,null,null,null,"Choose a Selection","Y"," ","Choose a Selection"," "," "," "," "," ","Borrower Paid"]
["760-779","50.01-60","DSCR",null,"None of the Above","$150,001-$1,500,000","24 Months PPP","Escrow Waived","Rate/Term Refi","1-2 Units",null,"5/1 30YR IO ARM","30 Day","Lender Paid","Foreign National",null,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","No Ratio",null,null,"$1,500,001-$3,000,000","36 Months PPP",null,"Cash-Out","3-4 Units",null,"5/1 40YR IO ARM","45 Day",null,null,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",null,null,null,"$3,000,001-$5,000,000","48 Months PPP",null,null,"Condo",null,"7/1 30YR ARM","60 Day",null,null,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",null,null,null,"$5,000,001-$7,500,000","60 Months PPP",null,null,"NW Condo",null,"7/1 30YR IO ARM",null,null,null,null,null,null,null,"Minnesota","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ",{"$f":"[5]!Input_Stamp_Channel","v":"W"}]
["680-699","75.01-80",null,null,null,"$7,500,001-$10,000,000",null,null,null,"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",null,null,null,null,null,null,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",null,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",null,null,null,null,null,null,null,null,null,null,"30/40YR 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"]
["Foreign National",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[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'!P18=\"Primary\",'NanQ ONE Program'!P18=\"Second Home\"),1,0)","v":0},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'!Q33>0,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,null,{"$f":"IF('NanQ ONE Program'!Q37:Q37=\"Borrower Paid\",0,1)","v":1},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,"State Format",{"$f":"IF(OR('NanQ ONE Program'!P18=\"Non-Owner (N/A DSCR)\",'NanQ ONE Program'!P18=\"Non-Owner (DSCR/No Ratio)\"),1,0)","v":0},null,"48 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,"60 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,"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,001-$1,500,000",750000]
[null,null,null,null,"$1,500,001-$3,000,000",2000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"$3,000,001-$5,000,000",3500000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"$5,000,001-$7,500,000",5500000,null,null,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,500,001-$10,000,000",8500000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,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 - Owner Occ/Second",null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"YSP",102,101,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,"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,001-$1,500,000","$1,500,001-$3,000,000","$3,000,001-$5,000,000","$5,000,001-$7,500,000","$7,500,001-$10,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,100.5,100.5,100.5,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,100.5,100.5,100.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,100.5,100.5,100.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"24 Months PPP",102,102,102,100,100,100,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,99.5,99.5,99.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"No Prepay",100.5,100.5,100.5,99,99,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,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$56>B50,$C$56<C50),D50,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,101,{"$f":"IF(AND($C$56>B51,$C$56<C51),D51,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,100,{"$error":"#N/A"},null,null,{"$f":"IF('NanQ ONE Program'!Q33>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(E50:E52)","v":{"$error":"#N/A"}},null,null,{"$f":"IF('NanQ ONE Program'!Q33=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:H46,MATCH(B58,B41:B46,0),MATCH(B56,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(B57=\"Primary\",B57=\"Second Home\"),E53,IF(B57=\"Non-Owner (DSCR/No Ratio)\",E54,\"ERROR\"))","v":"ERROR"}]
[null,{"$f":"'NanQ ONE Program'!P16","v":0},{"$f":"VLOOKUP(B56,E27:F32,2,FALSE)","v":{"$error":"#N/A"}},"Force Cap 100",100]
[null,{"$f":"'NanQ ONE Program'!P18","v":0},null,"Force Cap 99",99]
[null,{"$f":"'NanQ ONE Program'!P23","v":"12 Months PPP"}]
[]
[null,0,2000000]
[null,2000001,3000000]
[null,3000001,10000000]
[]
[]
[]
[]
[]
[]
[]
[null,"Base Rate / Base Price",null,null,null,null,null,null,"Base Rate / Base Price"]
[null,"Coupon","Full Doc","Alt Doc","DSCR/No Ratio",null,"Total LLPA",null,"Coupon","Full Doc","Alt Doc","DSCR/No Ratio"]
[null,{"$f":"'NanQ ONE Program'!B11","v":4.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C11","v":98.125},null,{"$f":"'NanQ ONE Program'!Q27","v":{"$error":"#N/A"}},1,9.99,null,null,{"$f":"E116+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B12","v":4.625},null,null,{"$f":"'NanQ ONE Program'!C12","v":98.375},null,null,2,9.875,null,null,{"$f":"E115+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B13","v":4.75},null,null,{"$f":"'NanQ ONE Program'!C13","v":98.625},null,"Total Price",3,9.75,null,null,{"$f":"E114+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B14","v":4.875},null,null,{"$f":"'NanQ ONE Program'!C14","v":98.875},null,{"$f":"'NanQ ONE Program'!Q32","v":100},4,9.625,null,null,{"$f":"E113+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B15","v":4.99},null,null,{"$f":"'NanQ ONE Program'!C15","v":99.125},null,null,5,9.4990000000000006,null,null,{"$f":"E112+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B16","v":5.125},null,null,{"$f":"'NanQ ONE Program'!C16","v":99.375},null,null,6,9.375,null,null,{"$f":"E111+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B17","v":5.25},null,null,{"$f":"'NanQ ONE Program'!C17","v":99.625},null,null,7,9.25,null,null,{"$f":"E110+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B18","v":5.375},null,null,{"$f":"'NanQ ONE Program'!C18","v":99.875},null,{"$f":"'NanQ ONE Program'!P13","v":0},8,9.125,null,null,{"$f":"E109+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B19","v":5.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C19","v":100.125},null,null,9,8.99,null,null,{"$f":"E108+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B20","v":5.625},null,null,{"$f":"'NanQ ONE Program'!C20","v":100.375},null,null,10,8.875,null,null,{"$f":"E107+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B21","v":5.75},null,null,{"$f":"'NanQ ONE Program'!C21","v":100.625},null,null,11,8.75,null,null,{"$f":"E106+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B22","v":5.875},null,null,{"$f":"'NanQ ONE Program'!C22","v":100.875},null,null,12,8.625,null,null,{"$f":"E105+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B23","v":5.99},null,null,{"$f":"'NanQ ONE Program'!C23","v":101.125},null,null,13,8.4990000000000006,null,null,{"$f":"E104+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B24","v":6.125},null,null,{"$f":"'NanQ ONE Program'!C24","v":101.375},null,null,14,8.375,null,null,{"$f":"E103+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B25","v":6.25},null,null,{"$f":"'NanQ ONE Program'!C25","v":101.625},null,null,15,8.25,null,null,{"$f":"E102+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B26","v":6.375},null,null,{"$f":"'NanQ ONE Program'!C26","v":101.875},null,null,16,8.125,null,null,{"$f":"E101+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B27","v":6.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C27","v":102.125},null,null,17,7.99,null,null,{"$f":"E100+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B28","v":6.625},null,null,{"$f":"'NanQ ONE Program'!C28","v":102.375},null,null,18,7.875,null,null,{"$f":"E99+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B29","v":6.75},null,null,{"$f":"'NanQ ONE Program'!C29","v":102.625},null,null,19,7.75,null,null,{"$f":"E98+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B30","v":6.875},null,null,{"$f":"'NanQ ONE Program'!C30","v":102.875},null,null,20,7.625,null,null,{"$f":"E97+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B31","v":6.99},null,null,{"$f":"'NanQ ONE Program'!C31","v":103.125},null,null,21,7.4989999999999997,null,null,{"$f":"E96+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B32","v":7.125},null,null,{"$f":"'NanQ ONE Program'!C32","v":103.375},null,null,22,7.375,null,null,{"$f":"E95+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B33","v":7.25},null,null,{"$f":"'NanQ ONE Program'!C33","v":103.625},null,null,23,7.25,null,null,{"$f":"E94+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B34","v":7.375},null,null,{"$f":"'NanQ ONE Program'!C34","v":103.875},null,null,24,7.125,null,null,{"$f":"E93+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B35","v":7.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C35","v":104.125},null,null,25,6.99,null,null,{"$f":"E92+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B36","v":7.625},null,null,{"$f":"'NanQ ONE Program'!C36","v":104.375},null,null,26,6.875,null,null,{"$f":"E91+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B37","v":7.75},null,null,{"$f":"'NanQ ONE Program'!C37","v":104.625},null,null,27,6.75,null,null,{"$f":"E90+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B38","v":7.875},null,null,{"$f":"'NanQ ONE Program'!C38","v":104.875},null,null,28,6.625,null,null,{"$f":"E89+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B39","v":7.99},null,null,{"$f":"'NanQ ONE Program'!C39","v":105.125},null,null,29,6.4989999999999997,null,null,{"$f":"E88+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B40","v":8.125},null,null,{"$f":"'NanQ ONE Program'!C40","v":105.375},null,null,30,6.375,null,null,{"$f":"E87+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B41","v":8.25},null,null,{"$f":"'NanQ ONE Program'!C41","v":105.625},null,null,31,6.25,null,null,{"$f":"E86+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B42","v":8.375},null,null,{"$f":"'NanQ ONE Program'!C42","v":105.875},null,null,32,6.125,null,null,{"$f":"E85+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B43","v":8.4990000000000006},null,null,{"$f":"'NanQ ONE Program'!C43","v":106.125},null,null,33,5.99,null,null,{"$f":"E84+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B44","v":8.625},null,null,{"$f":"'NanQ ONE Program'!C44","v":106.375},null,null,34,5.875,null,null,{"$f":"E83+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B45","v":8.75},null,null,{"$f":"'NanQ ONE Program'!C45","v":106.625},null,null,35,5.75,null,null,{"$f":"E82+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B46","v":8.875},null,null,{"$f":"'NanQ ONE Program'!C46","v":109},null,null,36,5.625,null,null,{"$f":"E81+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B47","v":8.99},null,null,{"$f":"'NanQ ONE Program'!C47","v":109.25},null,null,37,5.4989999999999997,null,null,{"$f":"E80+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B48","v":9.125},null,null,{"$f":"'NanQ ONE Program'!C48","v":109.5},null,null,38,5.375,null,null,{"$f":"E79+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B49","v":9.25},null,null,{"$f":"'NanQ ONE Program'!C49","v":109.75},null,null,39,5.25,null,null,{"$f":"E78+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B50","v":9.375},null,null,{"$f":"'NanQ ONE Program'!C50","v":110},null,null,40,5.125,null,null,{"$f":"E77+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B51","v":9.4990000000000006},null,null,{"$f":"'NanQ ONE Program'!C51","v":110.25},null,null,41,4.99,null,null,{"$f":"E76+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B52","v":9.625},null,null,{"$f":"'NanQ ONE Program'!C52","v":110.5},null,null,42,4.875,null,null,{"$f":"E75+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B53","v":9.75},null,null,{"$f":"'NanQ ONE Program'!C53","v":110.75},null,null,43,4.75,null,null,{"$f":"E74+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B54","v":9.875},null,null,{"$f":"'NanQ ONE Program'!C54","v":111},null,null,44,4.625,null,null,{"$f":"E73+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B55","v":9.99},null,null,{"$f":"'NanQ ONE Program'!C55","v":111.25},null,null,45,4.4989999999999997,null,null,{"$f":"E72+$G$72","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(100,J72:J116,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K72:K116,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L72:L116,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J117,H72:I116,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K117,H72:I116,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L117,H72:L116,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Base Rate / Base Price",null,null,null,null,null,null,null,{"$f":"IF(G79=J71,J118,0)","v":0},{"$f":"IF(G79=K71,K118,0)","v":0},{"$f":"IF(G79=L71,L118,0)","v":0},{"$f":"SUM(J119:L119)","v":0}]
[null,"Coupon","Full Doc","Alt Doc","DSCR/No Ratio",null,"Total LLPA",null,null,{"$f":"VLOOKUP(J117,H72:J116,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K117,H72:K116,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L117,H72:L116,5,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B11","v":4.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C11","v":98.125},null,{"$f":"'NanQ ONE Program'!Q27","v":{"$error":"#N/A"}},null,null,{"$f":"IF(G79=J71,J120,0)","v":0},{"$f":"IF(G79=K71,K120,0)","v":0},{"$f":"IF(G79=L71,L120,0)","v":0},{"$f":"SUM(J121:L121)","v":0}]
[null,{"$f":"'NanQ ONE Program'!B12","v":4.625},null,null,{"$f":"'NanQ ONE Program'!C12","v":98.375},null,"LPC"]
[null,{"$f":"'NanQ ONE Program'!B13","v":4.75},null,null,{"$f":"'NanQ ONE Program'!C13","v":98.625},null,{"$f":"'NanQ ONE Program'!Q33","v":0},null,"Base Rate / Base Price"]
[null,{"$f":"'NanQ ONE Program'!B14","v":4.875},null,null,{"$f":"'NanQ ONE Program'!C14","v":98.875},null,null,null,"Coupon","Full Doc","Alt Doc","DSCR/No Ratio"]
[null,{"$f":"'NanQ ONE Program'!B15","v":4.99},null,null,{"$f":"'NanQ ONE Program'!C15","v":99.125},null,"Total Price",1,9.99,null,null,{"$f":"E165+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B16","v":5.125},null,null,{"$f":"'NanQ ONE Program'!C16","v":99.375},null,{"$f":"'NanQ ONE Program'!Q32","v":100},2,9.875,null,null,{"$f":"E164+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B17","v":5.25},null,null,{"$f":"'NanQ ONE Program'!C17","v":99.625},null,null,3,9.75,null,null,{"$f":"E163+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B18","v":5.375},null,null,{"$f":"'NanQ ONE Program'!C18","v":99.875},null,{"$f":"'NanQ ONE Program'!P13","v":0},4,9.625,null,null,{"$f":"E162+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B19","v":5.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C19","v":100.125},null,null,5,9.4990000000000006,null,null,{"$f":"E161+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B20","v":5.625},null,null,{"$f":"'NanQ ONE Program'!C20","v":100.375},null,null,6,9.375,null,null,{"$f":"E160+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B21","v":5.75},null,null,{"$f":"'NanQ ONE Program'!C21","v":100.625},null,null,7,9.25,null,null,{"$f":"E159+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B22","v":5.875},null,null,{"$f":"'NanQ ONE Program'!C22","v":100.875},null,null,8,9.125,null,null,{"$f":"E158+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B23","v":5.99},null,null,{"$f":"'NanQ ONE Program'!C23","v":101.125},null,null,9,8.99,null,null,{"$f":"E157+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B24","v":6.125},null,null,{"$f":"'NanQ ONE Program'!C24","v":101.375},null,null,10,8.875,null,null,{"$f":"E156+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B25","v":6.25},null,null,{"$f":"'NanQ ONE Program'!C25","v":101.625},null,null,11,8.75,null,null,{"$f":"E155+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B26","v":6.375},null,null,{"$f":"'NanQ ONE Program'!C26","v":101.875},null,null,12,8.625,null,null,{"$f":"E154+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B27","v":6.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C27","v":102.125},null,null,13,8.4990000000000006,null,null,{"$f":"E153+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B28","v":6.625},null,null,{"$f":"'NanQ ONE Program'!C28","v":102.375},null,null,14,8.375,null,null,{"$f":"E152+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B29","v":6.75},null,null,{"$f":"'NanQ ONE Program'!C29","v":102.625},null,null,15,8.25,null,null,{"$f":"E151+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B30","v":6.875},null,null,{"$f":"'NanQ ONE Program'!C30","v":102.875},null,null,16,8.125,null,null,{"$f":"E150+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B31","v":6.99},null,null,{"$f":"'NanQ ONE Program'!C31","v":103.125},null,null,17,7.99,null,null,{"$f":"E149+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B32","v":7.125},null,null,{"$f":"'NanQ ONE Program'!C32","v":103.375},null,null,18,7.875,null,null,{"$f":"E148+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B33","v":7.25},null,null,{"$f":"'NanQ ONE Program'!C33","v":103.625},null,null,19,7.75,null,null,{"$f":"E147+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B34","v":7.375},null,null,{"$f":"'NanQ ONE Program'!C34","v":103.875},null,null,20,7.625,null,null,{"$f":"E146+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B35","v":7.4989999999999997},null,null,{"$f":"'NanQ ONE Program'!C35","v":104.125},null,null,21,7.4989999999999997,null,null,{"$f":"E145+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B36","v":7.625},null,null,{"$f":"'NanQ ONE Program'!C36","v":104.375},null,null,22,7.375,null,null,{"$f":"E144+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B37","v":7.75},null,null,{"$f":"'NanQ ONE Program'!C37","v":104.625},null,null,23,7.25,null,null,{"$f":"E143+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B38","v":7.875},null,null,{"$f":"'NanQ ONE Program'!C38","v":104.875},null,null,24,7.125,null,null,{"$f":"E142+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B39","v":7.99},null,null,{"$f":"'NanQ ONE Program'!C39","v":105.125},null,null,25,6.99,null,null,{"$f":"E141+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B40","v":8.125},null,null,{"$f":"'NanQ ONE Program'!C40","v":105.375},null,null,26,6.875,null,null,{"$f":"E140+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B41","v":8.25},null,null,{"$f":"'NanQ ONE Program'!C41","v":105.625},null,null,27,6.75,null,null,{"$f":"E139+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B42","v":8.375},null,null,{"$f":"'NanQ ONE Program'!C42","v":105.875},null,null,28,6.625,null,null,{"$f":"E138+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B43","v":8.4990000000000006},null,null,{"$f":"'NanQ ONE Program'!C43","v":106.125},null,null,29,6.4989999999999997,null,null,{"$f":"E137+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B44","v":8.625},null,null,{"$f":"'NanQ ONE Program'!C44","v":106.375},null,null,30,6.375,null,null,{"$f":"E136+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B45","v":8.75},null,null,{"$f":"'NanQ ONE Program'!C45","v":106.625},null,null,31,6.25,null,null,{"$f":"E135+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B46","v":8.875},null,null,{"$f":"'NanQ ONE Program'!C46","v":109},null,null,32,6.125,null,null,{"$f":"E134+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B47","v":8.99},null,null,{"$f":"'NanQ ONE Program'!C47","v":109.25},null,null,33,5.99,null,null,{"$f":"E133+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B48","v":9.125},null,null,{"$f":"'NanQ ONE Program'!C48","v":109.5},null,null,34,5.875,null,null,{"$f":"E132+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B49","v":9.25},null,null,{"$f":"'NanQ ONE Program'!C49","v":109.75},null,null,35,5.75,null,null,{"$f":"E131+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B50","v":9.375},null,null,{"$f":"'NanQ ONE Program'!C50","v":110},null,null,36,5.625,null,null,{"$f":"E130+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B51","v":9.4990000000000006},null,null,{"$f":"'NanQ ONE Program'!C51","v":110.25},null,null,37,5.4989999999999997,null,null,{"$f":"E129+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B52","v":9.625},null,null,{"$f":"'NanQ ONE Program'!C52","v":110.5},null,null,38,5.375,null,null,{"$f":"E128+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B53","v":9.75},null,null,{"$f":"'NanQ ONE Program'!C53","v":110.75},null,null,39,5.25,null,null,{"$f":"E127+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B54","v":9.875},null,null,{"$f":"'NanQ ONE Program'!C54","v":111},null,null,40,5.125,null,null,{"$f":"E126+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B55","v":9.99},null,null,{"$f":"'NanQ ONE Program'!C55","v":111.25},null,null,41,4.99,null,null,{"$f":"E125+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,42,4.875,null,null,{"$f":"E124+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,43,4.75,null,null,{"$f":"E123+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,44,4.625,null,null,{"$f":"E122+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,45,4.4989999999999997,null,null,{"$f":"E121+$G$121-$G$123","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(100,J125:J169,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K125:K169,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L125:L169,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J170,H125:I169,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K170,H125:I169,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L170,H125:L169,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Near Par Rate - BPC",null,{"$f":"Feed!M119","v":0},{"$f":"M121","v":0},null,null,null,null,{"$f":"IF(G128=J124,J171,0)","v":0},{"$f":"IF(G128=K124,K171,0)","v":0},{"$f":"IF(G128=L124,L171,0)","v":0},{"$f":"SUM(J172:L172)","v":0}]
[null,"Near Par Rate - BPC",null,{"$f":"Feed!M119","v":0},{"$f":"IF(E172>'NanQ ONE Program'!Q30,'NanQ ONE Program'!Q30,Feed!E172)","v":0},null,null,null,null,{"$f":"VLOOKUP(J170,H125:J169,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K170,H125:K169,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L170,H125:L169,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G128=J124,J173,0)","v":0},{"$f":"IF(G128=K124,K173,0)","v":0},{"$f":"IF(G128=L124,L173,0)","v":0},{"$f":"SUM(J174:L174)","v":0}]
[null,"Near Par Rate - LPC",null,{"$f":"Feed!M172","v":0},{"$f":"Feed!M174","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":[]}