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

{"sheet":"NanQ ONE Program","index":0,"n_rows":41,"n_cols":31,"rows_kept":41,"cut":false,"hidden":false,"merged":[[22,12,22,14],[17,17,17,18],[36,17,36,19],[34,20,34,24],[35,17,35,19],[35,20,35,23],[7,21,7,24],[8,21,8,24],[36,20,36,23],[26,17,26,19],[27,17,27,19],[33,12,33,13],[33,14,33,15],[13,25,13,27],[19,25,19,27],[21,17,21,18],[18,25,18,27],[17,25,17,27],[11,17,11,18],[22,17,22,18],[23,17,23,18],[25,17,25,18],[16,17,16,18],[18,17,18,18],[19,17,19,18],[20,17,20,18],[1,5,1,8],[2,5,2,8],[3,5,3,8],[14,25,14,27],[15,25,15,27],[4,10,4,11],[9,6,9,7],[5,17,6,24],[8,17,8,18],[13,17,13,18],[3,12,3,15],[0,13,1,15],[9,17,9,18],[10,17,10,18],[2,13,2,15],[14,17,14,18],[15,17,15,18],[7,25,7,27],[8,25,8,27],[10,25,10,27],[12,25,12,27],[9,25,9,27],[7,17,7,18],[12,17,12,18],[23,6,23,7],[24,6,24,7],[28,17,28,19],[29,17,29,19],[30,17,30,19],[28,21,28,24],[34,17,34,19],[24,17,24,18],[33,17,33,19],[33,20,33,24],[31,21,31,24],[30,21,30,24],[32,12,32,13],[32,14,32,15],[30,9,30,10],[29,9,29,10],[31,9,31,10],[32,9,32,10],[31,6,31,7],[31,17,31,19],[29,21,29,24],[32,17,32,19],[32,21,32,24],[10,0,13,0],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[20,6,20,7],[10,6,10,7],[11,6,11,7],[19,6,19,8],[4,12,4,15],[8,1,8,4],[33,6,33,7],[34,6,34,7],[28,9,28,11],[8,6,8,15],[29,12,29,15],[30,14,30,15],[38,6,38,7],[5,1,6,15],[23,9,23,10],[25,12,25,13],[24,9,24,10],[26,12,26,13],[25,9,25,10],[26,9,26,10],[25,6,25,7],[26,6,26,7],[27,6,27,7],[31,12,31,13],[31,14,31,15],[28,6,28,7],[29,6,29,7],[30,6,30,7],[39,6,39,7],[37,6,37,7],[35,6,35,7],[36,6,36,7],[32,6,32,7],[22,6,22,7],[21,6,21,7],[27,9,27,10],[19,12,19,15],[20,12,20,14],[21,12,21,14],[23,12,23,14],[24,12,24,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[27,12,27,13],[28,12,28,13],[28,14,28,15],[30,12,30,13],[19,9,19,11],[20,9,20,10],[21,9,21,10],[22,9,22,10],[39,17,47,24],[37,13,37,15],[34,12,34,13],[34,14,34,15],[35,12,35,13],[35,14,35,15],[36,12,36,13],[36,14,36,15],[33,9,33,10],[34,9,34,10],[35,9,35,10],[38,13,38,14],[38,17,38,24],[39,13,39,15],[36,9,36,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[4]Calc!AV80","v":"Wholesale Ratesheet"}]
[null,null,null,null,null,{"$f":"[5]!Input_Stamp_Header03","v":"LoanStream Mortgage"}]
[null,null,null,null,null,{"$f":"[5]!Input_Stamp_Header04","v":"19000 MacArthur Blvd, Suite 200"},null,null,null,null,null,null,null,{"$f":"[4]Calc!AV82","v":"45 Day Lock Period"}]
[null,null,null,null,null,{"$f":"[5]!Input_Stamp_Header05","v":"Irvine, CA 92612"},null,null,null,null,null,null,{"$f":"[4]Calc!AU83","v":"Borrower Paid Compensation"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"[5]Calc!BB90","v":"Effective Date:"},null,{"$f":"[4]Calc!CU88","v":"2020-12-21"}]
[null,"NanQ \"ONE\" Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[5]Calc!AT87","v":"PriceOne Calculator"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs",null,{"$f":"N1","v":"Wholesale Ratesheet"},null,null,null,"Full Doc Column Includes"]
[null,{"$f":"[4]Calc!AB93","v":"Base Rate / Base Price"},null,null,null,null,{"$f":"[4]Calc!$AQ$94","v":"FICO/LTV Price Adjustments"},null,null,null,null,null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,null,null,"Tax Returns"]
[null,{"$f":"[4]Calc!AB94","v":"Coupon"},{"$f":"[4]Calc!AC94","v":"Full Doc"},{"$f":"[4]Calc!AD94","v":"Alt Doc"},{"$f":"[4]Calc!AE94","v":"DSCR"},null,null,null,{"$f":"[4]Calc!AS95","v":"<=50"},{"$f":"[4]Calc!AT95","v":"50.01-60"},{"$f":"[4]Calc!AU95","v":"60.01-65"},{"$f":"[4]Calc!AV95","v":"65.01-70"},{"$f":"[4]Calc!AW95","v":"70.01-75"},{"$f":"[4]Calc!AX95","v":"75.01-80"},{"$f":"[4]Calc!AY95","v":"80.01-85"},{"$f":"[4]Calc!AZ95","v":"85.01-90"},null,"LTV Range",null,null,null,null,null,null,null,"Asset Utilization Only"]
[null,{"$f":"[4]Calc!AB97","v":4.25},{"$f":"[4]Calc!AC97","v":98.25},{"$f":"[4]Calc!AD97","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE97","v":{"$error":"#N/A"}},null,{"$f":"[5]Calc!AP95","v":"780+"},null,{"$f":"[4]Calc!AS96","v":0.75},{"$f":"[4]Calc!AT96","v":0.625},{"$f":"[4]Calc!AU96","v":0.5},{"$f":"[4]Calc!AV96","v":0.375},{"$f":"[4]Calc!AW96","v":0.125},{"$f":"[4]Calc!AX96","v":-0.375},{"$f":"[4]Calc!AY96","v":-0.875},{"$f":"[4]Calc!AZ96","v":-1.375},null,"FICO Range",null,null,{"$f":"INDEX(I11:P18,MATCH(T11,G11:G18,0),MATCH(T10,I10:P10))","v":{"$error":"#N/A"}},null,null,null,null,"Asset Utilization W/ Full Doc"]
[null,{"$f":"[4]Calc!AB98","v":4.375},{"$f":"[4]Calc!AC98","v":98.75},{"$f":"[4]Calc!AD98","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE98","v":{"$error":"#N/A"}},null,{"$f":"[5]Calc!AP96","v":"760-779"},null,{"$f":"[4]Calc!AS97","v":0.5},{"$f":"[4]Calc!AT97","v":0.375},{"$f":"[4]Calc!AU97","v":0.125},{"$f":"[4]Calc!AV97","v":-0.125},{"$f":"[4]Calc!AW97","v":-0.5},{"$f":"[4]Calc!AX97","v":-1},{"$f":"[4]Calc!AY97","v":-1.75},{"$f":"[4]Calc!AZ97","v":-2.5},null,"Grade",null,null,{"$f":"INDEX(L21:L28,MATCH(T12,J21:J28,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB99","v":4.4989999999999997},{"$f":"[4]Calc!AC99","v":99.25},{"$f":"[4]Calc!AD99","v":98.5},{"$f":"[4]Calc!AE99","v":{"$error":"#N/A"}},null,{"$f":"[5]Calc!AP97","v":"740-759"},null,{"$f":"[4]Calc!AS98","v":0.125},{"$f":"[4]Calc!AT98","v":0},{"$f":"[4]Calc!AU98","v":-0.25},{"$f":"[4]Calc!AV98","v":-0.625},{"$f":"[4]Calc!AW98","v":-1.125},{"$f":"[4]Calc!AX98","v":-1.75},{"$f":"[4]Calc!AY98","v":-2.75},{"$f":"[4]Calc!AZ98","v":-3.75},null,"Doc Type",null,null,null,null,null,null,null,"Alt Doc Column Includes"]
[null,{"$f":"[4]Calc!AB100","v":4.625},{"$f":"[4]Calc!AC100","v":99.75},{"$f":"[4]Calc!AD100","v":99},{"$f":"[4]Calc!AE100","v":{"$error":"#N/A"}},null,{"$f":"[5]Calc!AP98","v":"720-739"},null,{"$f":"[4]Calc!AS99","v":-0.125},{"$f":"[4]Calc!AT99","v":-0.375},{"$f":"[4]Calc!AU99","v":-0.75},{"$f":"[4]Calc!AV99","v":-1.25},{"$f":"[4]Calc!AW99","v":-1.875},{"$f":"[4]Calc!AX99","v":-2.75},{"$f":"[4]Calc!AY99","v":-3.75},{"$f":"[4]Calc!AZ99","v":-4.75},null,"Doc Type +",null,null,{"$f":"IF(T14=\"None of the Above\",0,IF(T14=\"12 Month Full / Alt Doc\",0,INDEX(I$22:I$40,MATCH(T14,G$22:G$40,0))))","v":{"$error":"#N/A"}},null,null,null,null,"12 or 24 Bank Statements"]
[null,{"$f":"[4]Calc!AB101","v":4.75},{"$f":"[4]Calc!AC101","v":100.25},{"$f":"[4]Calc!AD101","v":99.5},{"$f":"[4]Calc!AE101","v":{"$error":"#N/A"}},null,{"$f":"[5]Calc!AP99","v":"700-719"},null,{"$f":"[4]Calc!AS100","v":-0.5},{"$f":"[4]Calc!AT100","v":-0.75},{"$f":"[4]Calc!AU100","v":-1.25},{"$f":"[4]Calc!AV100","v":-1.875},{"$f":"[4]Calc!AW100","v":-2.625},{"$f":"[4]Calc!AX100","v":-3.75},{"$f":"[4]Calc!AY100","v":-4.75},{"$f":"[4]Calc!AZ100","v":{"$error":"#N/A"}},null,"Citizenships",null,null,{"$f":"IF(T15=\"US Citizen\",0,IF(T15=\"Permanent Resident\",0,IF(T15=\"Non Perm Resident\",0,INDEX(I$22:I$40,MATCH(T15,G$22:G$40,0)))))","v":{"$error":"#N/A"}},null,null,null,null,"12 or 24 CPA P&L W/3 Months Bk St"]
[null,{"$f":"[4]Calc!AB102","v":4.875},{"$f":"[4]Calc!AC102","v":100.75},{"$f":"[4]Calc!AD102","v":100},{"$f":"[4]Calc!AE102","v":{"$error":"#N/A"}},null,{"$f":"[5]Calc!AP100","v":"680-699"},null,{"$f":"[4]Calc!AS101","v":-0.75},{"$f":"[4]Calc!AT101","v":-1.25},{"$f":"[4]Calc!AU101","v":-1.875},{"$f":"[4]Calc!AV101","v":-2.625},{"$f":"[4]Calc!AW101","v":-3.5},{"$f":"[4]Calc!AX101","v":-4.75},{"$f":"[4]Calc!AY101","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ101","v":{"$error":"#N/A"}},null,"DTI",null,null,{"$f":"IF(T16=\"None Of The Above\",0,IF(T16=\"No DTI Program (DSCR)\",0,INDEX(I$22:I$40,MATCH(T16,G$22:G$40,0))))","v":{"$error":"#N/A"}},null,null,null,null,"Asset Utlization W/ Bank Stmt"]
[null,{"$f":"[4]Calc!AB103","v":4.9989999999999997},{"$f":"[4]Calc!AC103","v":101.125},{"$f":"[4]Calc!AD103","v":100.375},{"$f":"[4]Calc!AE103","v":99.25},null,{"$f":"[5]Calc!AP101","v":"660-679"},null,{"$f":"[4]Calc!AS102","v":-1.125},{"$f":"[4]Calc!AT102","v":-1.625},{"$f":"[4]Calc!AU102","v":-2.375},{"$f":"[4]Calc!AV102","v":-3.5},{"$f":"[4]Calc!AW102","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AX102","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AY102","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ102","v":{"$error":"#N/A"}},null,"Loan Balance",null,null,{"$f":"IF(T17=\"$5,000,001-$7,500,000\",\"Call Lock Desk\",IF(T17=\"$7,500,001-$10,000,000\",\"Call Lock Desk\",INDEX(I$22:I$40,MATCH(T17,G$22:G$40,0))))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB104","v":5.125},{"$f":"[4]Calc!AC104","v":101.5},{"$f":"[4]Calc!AD104","v":100.75},{"$f":"[4]Calc!AE104","v":99.625},null,{"$f":"[5]Calc!AP102","v":"640-659"},null,{"$f":"[4]Calc!AS103","v":-1.375},{"$f":"[4]Calc!AT103","v":-2},{"$f":"[4]Calc!AU103","v":-3},{"$f":"[4]Calc!AV103","v":-4.5},{"$f":"[4]Calc!AW103","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AX103","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AY103","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ103","v":{"$error":"#N/A"}},null,"Purpose",null,null,{"$f":"IF(OR(T18=\"Purchase\",T18=\"Rate/Term Refi\"),0,INDEX(I$22:I$40,MATCH(T18,G$22:G$40,0)))","v":{"$error":"#N/A"}},null,null,null,null,"DSCR/No Ratio Column Includes"]
[null,{"$f":"[4]Calc!AB105","v":5.25},{"$f":"[4]Calc!AC105","v":101.875},{"$f":"[4]Calc!AD105","v":101.125},{"$f":"[4]Calc!AE105","v":100},null,null,null,null,null,null,null,null,null,null,null,null,"Occupancy",null,"Primary",{"$f":"IF(OR(T19=\"Primary\"),0,IF(OR(T19=\"Non-Owner (DSCR/No Ratio)\"),0,INDEX(I$22:I$40,MATCH(T19,G$22:G$40,0))))","v":0},null,null,null,null,"DSCR"]
[null,{"$f":"[4]Calc!AB106","v":5.375},{"$f":"[4]Calc!AC106","v":102.25},{"$f":"[4]Calc!AD106","v":101.5},{"$f":"[4]Calc!AE106","v":100.375},null,{"$f":"[4]Calc!$AQ$105","v":"Loan Level Price Adjustments"},null,null,{"$f":"[4]Calc!AU127","v":"Grades"},null,null,{"$f":"[4]Calc!CV109","v":"Margins"},{"$f":"[4]Calc!CW109","v":0},{"$f":"[4]Calc!CX109","v":0},{"$f":"[4]Calc!CY109","v":0},null,"Property Type",null,"SFR",{"$f":"IF(OR(T20=\"SFR\",T20=\"1-2 Units\",T20=\"PUD\",T20=\"Condo\"),0,INDEX(I$22:I$40,MATCH(T20,G$22:G$40,0)))","v":0},null,null,null,null,"No Ratio"]
[null,{"$f":"[4]Calc!AB107","v":5.4989999999999997},{"$f":"[4]Calc!AC107","v":102.625},{"$f":"[4]Calc!AD107","v":101.875},{"$f":"[4]Calc!AE107","v":100.75},null,null,null,"LLPA",{"$f":"[4]Calc!CS110","v":"Select - Standard"},null,{"$f":"[4]Calc!CU110","v":0.5},{"$f":"[4]Calc!CV110","v":"Occupancy"},{"$f":"[4]Calc!CW110","v":0},{"$f":"[4]Calc!CX110","v":0},{"$f":"[4]Calc!CY110","v":"Margin"},null,"Loan Term",null,"5/1 30YR ARM",{"$f":"INDEX(L30:L37,MATCH(T21,J30:J37,0))","v":0}]
[null,{"$f":"[4]Calc!AB108","v":5.625},{"$f":"[4]Calc!AC108","v":103},{"$f":"[4]Calc!AD108","v":102.25},{"$f":"[4]Calc!AE108","v":101.125},null,{"$f":"[4]Calc!CP111","v":"*ACH Special*"},null,{"$f":"[4]Calc!CR111","v":0.25},{"$f":"[4]Calc!CS111","v":"A+"},null,{"$f":"[4]Calc!CU111","v":0},{"$f":"[4]Calc!CV111","v":"Primary Home"},{"$f":"[4]Calc!CW111","v":0},{"$f":"[4]Calc!CX111","v":0},{"$f":"[4]Calc!CY111","v":3},null,"Escrow",null,"Escrow Not Waived",{"$f":"IF(T22=\"Escrow Not Waived\",0,INDEX(I$22:I$40,MATCH(T22,G$22:G$40,0)))","v":0}]
[null,{"$f":"[4]Calc!AB109","v":5.75},{"$f":"[4]Calc!AC109","v":103.375},{"$f":"[4]Calc!AD109","v":102.625},{"$f":"[4]Calc!AE109","v":101.5},null,{"$f":"[4]Calc!CP112","v":"Full Doc (>50 DTI)"},null,{"$f":"[4]Calc!CR112","v":-0.625},{"$f":"[4]Calc!CS112","v":"A"},null,{"$f":"[4]Calc!CU112","v":-1.5},{"$f":"[4]Calc!CV112","v":"Second Home"},{"$f":"[4]Calc!CW112","v":0},{"$f":"[4]Calc!CX112","v":0},{"$f":"[4]Calc!CY112","v":3},null,"Prepayment Penalty",null,"36 Months PPP",{"$f":"IF(OR(T19=\"Primary\",T19=\"Second Home\"),0,IF(T23=\"No PPP/See State Section\",0,INDEX(I$22:I$40,MATCH(T23,G$22:G$40,0))))","v":0}]
[null,{"$f":"[4]Calc!AB110","v":5.875},{"$f":"[4]Calc!AC110","v":103.75},{"$f":"[4]Calc!AD110","v":103},{"$f":"[4]Calc!AE110","v":101.875},null,{"$f":"[4]Calc!CP113","v":"Alt Doc (>43 DTI)"},null,{"$f":"[4]Calc!CR113","v":-0.375},{"$f":"[4]Calc!CS113","v":"B"},null,{"$f":"[4]Calc!CU113","v":-2},{"$f":"[4]Calc!CV113","v":"Investment Home"},{"$f":"[4]Calc!CW113","v":0},{"$f":"[4]Calc!CX113","v":0},{"$f":"[4]Calc!CY113","v":5},null,"State",null,"All Other States",0]
[null,{"$f":"[4]Calc!AB111","v":5.9989999999999997},{"$f":"[4]Calc!AC111","v":104.125},{"$f":"[4]Calc!AD111","v":103.375},{"$f":"[4]Calc!AE111","v":102.25},null,{"$f":"[4]Calc!CP114","v":"Non-Owner (N/A DSCR)"},null,{"$f":"[4]Calc!CR114","v":-0.75},{"$f":"[4]Calc!CS114","v":"B-"},null,{"$f":"[4]Calc!CU114","v":-2.5},{"$f":"[4]Calc!CV114","v":"Lock Days"},{"$f":"[4]Calc!CW114","v":0},{"$f":"[4]Calc!CX114","v":0},{"$f":"[4]Calc!CY114","v":0},null,"ACH Special",null,"No",{"$f":"IF(T25=\"Yes\",0.25,0)","v":0}]
[null,{"$f":"[4]Calc!AB112","v":6.125},{"$f":"[4]Calc!AC112","v":104.5},{"$f":"[4]Calc!AD112","v":103.75},{"$f":"[4]Calc!AE112","v":102.625},null,{"$f":"[4]Calc!CP115","v":"24 Month Full Doc"},null,{"$f":"[4]Calc!CR115","v":0.25},{"$f":"[4]Calc!CS115","v":"Select - DSCR (Min 1.15+)"},null,{"$f":"[4]Calc!CU115","v":0.5},{"$f":"[4]Calc!CV115","v":"15 Day"},{"$f":"[4]Calc!CW115","v":0},{"$f":"[4]Calc!CX115","v":0.15},{"$f":"[4]Calc!CY115","v":0},null,"Lock Term",null,"45 Day",{"$f":"IF(T26=\"15 Day\",O26,IF(T26=\"30 Day\",O27,IF(T26=\"45 Day\",O28,IF(T26=\"60 Day\",O29,\"NA\"))))","v":0},null,null,null,null,0,null,null,"Minimum rate rule",{"$f":"IF(T9>4.74,0,1)","v":1}]
[null,{"$f":"[4]Calc!AB113","v":6.25},{"$f":"[4]Calc!AC113","v":104.875},{"$f":"[4]Calc!AD113","v":104.125},{"$f":"[4]Calc!AE113","v":103},null,{"$f":"[4]Calc!CP116","v":"Asset Utilization"},null,{"$f":"[4]Calc!CR116","v":-0.75},{"$f":"[4]Calc!CS116","v":"DSCR - (Min 1.00+)"},null,{"$f":"[4]Calc!CU116","v":0},{"$f":"[4]Calc!CV116","v":"30 Day"},{"$f":"[4]Calc!CW116","v":0},{"$f":"[4]Calc!CX116","v":0},{"$f":"[4]Calc!CY116","v":0},null,"  Total LLPA",null,null,{"$f":"SUM(U11:U26)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Loan Amount rule",{"$f":"IF(U17<5,0,1)","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB114","v":6.375},{"$f":"[4]Calc!AC114","v":105.25},{"$f":"[4]Calc!AD114","v":104.5},{"$f":"[4]Calc!AE114","v":103.375},null,{"$f":"[4]Calc!CP117","v":"Debt Consolidation"},null,{"$f":"[4]Calc!CR117","v":-1},{"$f":"[4]Calc!CS117","v":"No Ratio - (0.75-0.99)"},null,{"$f":"[4]Calc!CU117","v":-1},{"$f":"[4]Calc!CV117","v":"45 Day"},{"$f":"[4]Calc!CW117","v":0},{"$f":"[4]Calc!CX117","v":0},{"$f":"[4]Calc!CY117","v":0},null,"  Gross Rate Sheet Price (Prior to LLPAs)",null,null,{"$f":"IFERROR(INDEX(B11:E40,MATCH(T9,B11:B40,0),MATCH(T13,C10:E10,0)+1),\"Minimum Rate\")","v":"Minimum Rate"},null,null,null,null,null,null,null,"Impounds rule",{"$f":"IF(NOT(T22=\"Escrow Waived\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AB115","v":6.4989999999999997},{"$f":"[4]Calc!AC115","v":105.625},{"$f":"[4]Calc!AD115","v":104.875},{"$f":"[4]Calc!AE115","v":103.75},null,{"$f":"[4]Calc!CP118","v":"Cash-Out"},null,{"$f":"[4]Calc!CR118","v":-1},{"$f":"[4]Calc!AQ127","v":"Loan Term"},null,null,{"$f":"[4]Calc!CV118","v":"60 Day"},{"$f":"[4]Calc!CW118","v":0},{"$f":"[4]Calc!CX118","v":-0.125},{"$f":"[4]Calc!CY118","v":0},null,"  Max YSP",null,null,{"$f":"Feed!D168","v":102},{"$f":"CONCATENATE(R29,\" \",\"is\",\" \", U29)","v":"  Max YSP is 102"},null,null,null,null,null,null,"Texas rule",{"$f":"IF(NOT(T24=\"Texas\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AB116","v":6.625},{"$f":"[4]Calc!AC116","v":105.875},{"$f":"[4]Calc!AD116","v":105.125},{"$f":"[4]Calc!AE116","v":104},null,{"$f":"[4]Calc!CP119","v":"3-4 Units"},null,{"$f":"[4]Calc!CR119","v":-0.75},{"$f":"[4]Calc!CS119","v":"5/1 30YR ARM"},{"$f":"[4]Calc!CT119","v":0},{"$f":"[4]Calc!CU119","v":0},{"$f":"[4]Calc!CV119","v":"Max Price"},{"$f":"[4]Calc!CW119","v":0},{"$f":"[4]Calc!CX119","v":0},{"$f":"[4]Calc!CY119","v":0},null,"  Net Price: Rate Sheet - LLPA (Prior to Max YSP)",null,null,{"$f":"IFERROR(U28+U27,\"Minimum Rate\")","v":"Minimum Rate"},{"$f":"IF(U37=\"Borrower Paid\",\"BPC Selected\",IF(AND(V31=\"LPC Selected\",U32<0.01),\"Input a Valid LPC\",\"LPC Inputted\"))","v":"LPC Inputted"},null,null,null,null,null,null,"15 Day Rule",{"$f":"IF(T26=\"15 Day\",0,1)","v":1}]
[null,{"$f":"[4]Calc!AB117","v":6.75},{"$f":"[4]Calc!AC117","v":106.125},{"$f":"[4]Calc!AD117","v":105.375},{"$f":"[4]Calc!AE117","v":104.25},null,{"$f":"[4]Calc!CP120","v":"Second Home"},null,{"$f":"[4]Calc!CR120","v":-0.75},{"$f":"[4]Calc!CS120","v":"5/1 30YR IO ARM"},null,{"$f":"[4]Calc!CU120","v":-0.25},{"$f":"[4]Calc!CV120","v":"Owner Occ/Sec Home"},{"$f":"[4]Calc!CW120","v":0},{"$f":"[4]Calc!CX120","v":102},{"$f":"[4]Calc!CY120","v":0},null,"  Net Rate Sheet Price - As Borrower Paid (BPC)",null,null,{"$f":"IFERROR(IF(U30>U29,U29,U30),\"Priced LPC\")","v":102},{"$f":"IF(U37=\"Lender Paid\",\"LPC Selected\",IF(AND(U37=\"Borrower Paid\",Y37=\"\",U37=\"Choose a Selection\"),\"BPC is Blank\",\"BPC Inputted\"))","v":"BPC Inputted"},null,null,null,null,null,null,"Cashout/PPP Rule",{"$f":"IF(AND(T18=\"Cash-out\",T23<>\"No Prepay\",T19<>\"primary\"),0,1)","v":1}]
[null,{"$f":"[4]Calc!AB118","v":6.875},{"$f":"[4]Calc!AC118","v":106.375},{"$f":"[4]Calc!AD118","v":105.625},{"$f":"[4]Calc!AE118","v":104.5},null,{"$f":"[4]Calc!CP121","v":"12 Months PPP"},null,{"$f":"[4]Calc!CR121","v":0},{"$f":"[4]Calc!CS121","v":"5/1 40YR IO ARM"},{"$f":"[4]Calc!CT121","v":0},{"$f":"[4]Calc!CU121","v":-0.375},{"$f":"[4]Calc!CV121","v":"Loans W/ 0YR PPP"},{"$f":"[4]Calc!CW121","v":0},{"$f":"[4]Calc!CX121","v":100},{"$f":"[4]Calc!CY121","v":0},null,"Lender Paid Comp Plan Amount (LPC)",null,null,0,{"$f":"CONCATENATE(Feed!B148,\" \",Feed!D148,\"%\" &\" @ \"&Feed!E149)","v":"Near Par Rate - BPC 0% @ 0"},null,null,null,null,null,null,"DSCR",{"$f":"IF(T19=\"Non-Owner (N/A DSCR)\",0,IF(T19=\"Non-Owner (DSCR/No Ratio)\",0,1))","v":1},"You have Selected DSCR No Income Loan"]
[null,{"$f":"[4]Calc!AB119","v":6.9989999999999997},{"$f":"[4]Calc!AC119","v":106.625},{"$f":"[4]Calc!AD119","v":105.875},{"$f":"[4]Calc!AE119","v":104.75},null,{"$f":"[4]Calc!CP122","v":"24 Months PPP"},null,{"$f":"[4]Calc!CR122","v":0.25},{"$f":"[4]Calc!CS122","v":"7/1 30YR ARM"},{"$f":"[4]Calc!CT122","v":0},{"$f":"[4]Calc!CU122","v":-0.125},{"$f":"[4]Calc!CV122","v":"Loans W/ 1YR PPP"},{"$f":"[4]Calc!CW122","v":0},{"$f":"[4]Calc!CX122","v":101},{"$f":"[4]Calc!CY122","v":0},null,"  Net Rate Sheet Price - As Lender Paid (LPC)",null,null,{"$f":"U31-U32","v":102},null,null,null,null,null,null,null,null,null,"You have Selected Income Qualifing Inv Loan"]
[null,{"$f":"[4]Calc!AB120","v":7.125},{"$f":"[4]Calc!AC120","v":106.875},{"$f":"[4]Calc!AD120","v":106.125},{"$f":"[4]Calc!AE120","v":105},null,{"$f":"[4]Calc!CP123","v":"36 Months PPP"},null,{"$f":"[4]Calc!CR123","v":0.375},{"$f":"[4]Calc!CS123","v":"7/1 30YR IO ARM"},{"$f":"[4]Calc!CT123","v":0},{"$f":"[4]Calc!CU123","v":-0.375},{"$f":"[4]Calc!CV123","v":"Loans W/ 2YR PPP"},{"$f":"[4]Calc!CW123","v":0},{"$f":"[4]Calc!CX123","v":101.5},{"$f":"[4]Calc!CY123","v":0},null,"Loan Number",null,null,"Borrower Name"]
[null,{"$f":"[4]Calc!AB121","v":7.25},{"$f":"[4]Calc!AC121","v":107.125},{"$f":"[4]Calc!AD121","v":106.375},{"$f":"[4]Calc!AE121","v":105.25},null,{"$f":"[4]Calc!CP124","v":"48 Months PPP"},null,{"$f":"[4]Calc!CR124","v":0.375},{"$f":"[4]Calc!CS124","v":"7/1 40YR IO ARM"},{"$f":"[4]Calc!CT124","v":0},{"$f":"[4]Calc!CU124","v":-0.5},{"$f":"[4]Calc!CV124","v":"Loans W/ 3YR PPP"},{"$f":"[4]Calc!CW124","v":0},{"$f":"[4]Calc!CX124","v":102},{"$f":"[4]Calc!CY124","v":0}]
[null,{"$f":"[4]Calc!AB122","v":7.375},{"$f":"[4]Calc!AC122","v":107.375},{"$f":"[4]Calc!AD122","v":106.625},{"$f":"[4]Calc!AE122","v":105.5},null,{"$f":"[4]Calc!CP125","v":"60 Months PPP"},null,{"$f":"[4]Calc!CR125","v":0.375},{"$f":"[4]Calc!CS125","v":"15YR Fixed"},{"$f":"[4]Calc!CT125","v":0},{"$f":"[4]Calc!CU125","v":0},{"$f":"[4]Calc!CV125","v":"Loans W/ 4YR PPP"},{"$f":"[4]Calc!CW125","v":0},{"$f":"[4]Calc!CX125","v":102.5},{"$f":"[4]Calc!CY125","v":0},null,"Property Address",null,null,"Compensation Type - Make A Selection",null,null,null,"Comp?"]
[null,{"$f":"[4]Calc!AB123","v":7.4989999999999997},{"$f":"[4]Calc!AC123","v":107.625},{"$f":"[4]Calc!AD123","v":106.875},{"$f":"[4]Calc!AE123","v":105.75},null,{"$f":"[4]Calc!CP126","v":"NW Condo"},null,{"$f":"[4]Calc!CR126","v":-1.25},{"$f":"[4]Calc!CS126","v":"30YR Fixed"},{"$f":"[4]Calc!CT126","v":0},{"$f":"[4]Calc!CU126","v":-0.5},{"$f":"[4]Calc!CV126","v":"Loans W/ 5YR PPP"},{"$f":"[4]Calc!CW126","v":0},{"$f":"[4]Calc!CX126","v":103},{"$f":"[4]Calc!CY126","v":0},null,null,null,null,"Choose a Selection"]
[null,{"$f":"[4]Calc!AB124","v":7.625},{"$f":"[4]Calc!AC124","v":107.875},{"$f":"[4]Calc!AD124","v":107.125},{"$f":"[4]Calc!AE124","v":106},null,{"$f":"[4]Calc!CP127","v":"ITIN"},null,{"$f":"[4]Calc!CR127","v":-1.5},{"$f":"[4]Calc!CS127","v":"Loan Term"},{"$f":"[4]Calc!CT127","v":"Caps"},{"$f":"[4]Calc!CU127","v":"Floor"},{"$f":"[4]Calc!CV127","v":"Index"},{"$f":"[4]Calc!CW127","v":"Extension Cost"},{"$f":"[4]Calc!CX127","v":0},{"$f":"[4]Calc!CY127","v":0}]
[null,{"$f":"[4]Calc!AB125","v":7.75},{"$f":"[4]Calc!AC125","v":108.125},{"$f":"[4]Calc!AD125","v":107.375},{"$f":"[4]Calc!AE125","v":106.25},null,{"$f":"[4]Calc!CP128","v":"$150,001-$1,500,000"},null,{"$f":"[4]Calc!CR128","v":0},{"$f":"[4]Calc!CS128","v":"5/1 ARM"},{"$f":"[4]Calc!CT128","v":"5/2/5"},{"$f":"[4]Calc!CU128","v":"=Rate"},{"$f":"[4]Calc!CV128","v":"1YR Libor"},{"$f":"[4]Calc!CW128","v":"2 Bps (0.020)"},{"$f":"[4]Calc!CX128","v":0},{"$f":"[4]Calc!CY128","v":"Per Day"},null,"Prepayment Penalty (Non-TRID / Business Purpose Loans Only)"]
[null,{"$f":"[4]Calc!AB126","v":7.875},{"$f":"[4]Calc!AC126","v":108.375},{"$f":"[4]Calc!AD126","v":107.625},{"$f":"[4]Calc!AE126","v":106.5},null,{"$f":"[4]Calc!CP129","v":"$1,500,001-$3,000,000"},null,{"$f":"[4]Calc!CR129","v":-0.125},{"$f":"[4]Calc!CS129","v":"7/1 ARM"},{"$f":"[4]Calc!CT129","v":"5/2/5"},{"$f":"[4]Calc!CU129","v":"=Rate"},{"$f":"[4]Calc!CV129","v":"1YR Libor"},"Max 30 Day Extension",null,null,null,"*6 months interest on 80% of the original principal balance \n(Standard Term = 3 years); \nMinimum 12 Month Prepay required except in the following states \nNot allowed in IL1, MD, MI, MN, ND, NJ1, NM, OH, PA\n1Prepay allowed for loans closed in the name of corporations or LLCs in IL, and NJ\n*PPP is only Allowed on Investment & DSCR Non-TRID Loans\nMinimum 12 Month Prepay Required"]
[null,null,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]

{"sheet":"Feed","index":1,"n_rows":186,"n_cols":30,"rows_kept":186,"cut":false,"hidden":true,"merged":[[158,0,158,3],[151,1,151,2],[150,1,150,2],[147,1,147,2],[50,7,50,8],[69,1,69,4],[69,8,69,11],[110,1,110,4],[110,8,110,11],[148,1,148,2]]}
["LTV","FICO","Grades","Doc Type","Doc +","Citizenships","DTI","Loan Amount","Purpose","Occupancy","Property Type","Loan Term","Escrow Waiver","Prepayment Penalties","ACH","Lock Period","Comp Type",null,null,null,null,null,"Message"]
["Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Yes","Choose a Selection","Choose a Selection",null,null,null,"State","Availability","No Penalty","12 Months","24 Months","36 Months","48 Months","60 Months",null,"Compensation Type"]
["<=50","780+","Select - Standard","Full Doc","None of the Above","US Citizen","Full Doc (>50 DTI)","$150,001-$1,500,000","Purchase","Primary","SFR","5/1 30YR ARM","Escrow Not Waived","No PPP/See State Section","No","15 Day","Borrower Paid",null,null,null,"Choose a Selection","Y"," ","Choose a Selection"," "," "," "," "," ","Borrower Paid"]
["50.01-60","760-779","A+","Alt Doc","12 Month Full / Alt Doc","Permanent Resident","Alt Doc (>43 DTI)","$1,500,001-$3,000,000","Rate/Term Refi","Second Home","1-2 Units","5/1 30YR IO ARM",null,"12 Months PPP",null,"30 Day","Lender Paid",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"]
["60.01-65","740-759","A","DSCR","24 Month Full Doc","Non Perm Resident","No DTI Program (DSCR)",null,"Debt Consolidation","Non-Owner (N/A DSCR)","3-4 Units","5/1 40YR IO ARM",null,"24 Months PPP",null,"45 Day",null,null,null,null,"Maryland","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," "]
["65.01-70","720-739","B",null,"Asset Utilization","ITIN","None Of The Above",null,"Cash-Out","Non-Owner (DSCR/No Ratio)","Condo","7/1 30YR ARM",null,"36 Months PPP",null,"60 Day",null,null,null,null,"Michigan","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ","Channel"]
["70.01-75","700-719","B-",null,null,null,null,null,null,null,"NW Condo","7/1 30YR IO ARM",null,"48 Months PPP",null,null,null,null,null,null,"Minnesota","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ",{"$f":"[6]!Input_Stamp_Channel","v":"W"}]
["75.01-80","680-699","Select - DSCR (Min 1.15+)",null,null,null,null,null,null,null,"PUD","7/1 40YR IO ARM",null,"60 Months PPP",null,null,null,null,null,null,"North Dakota","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," "]
["80.01-85","660-679","DSCR - (Min 1.00+)",null,null,null,null,null,null,null,null,"15YR Fixed",null,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"]
["85.01-90","640-659","No Ratio - (0.75-0.99)",null,null,null,null,null,null,null,null,"30YR Fixed",null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas","Y",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Other States","Y"," ","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies","PPP Allowed on Investment properties, State rules applies"," "]
[null,"Rules",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"No Prepay",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Prepay Cond. Format",{"$f":"IF(OR('NanQ ONE Program'!T19=\"Primary\",'NanQ ONE Program'!T19=\"Second Home\"),1,0)","v":1},null,"6 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF('NanQ ONE Program'!#REF!>0,0,1)","v":{"$error":"#REF!"}},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'!U37:U37=\"Borrower Paid\",0,1)","v":1},null,"24 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"State Format",{"$f":"IF(OR('NanQ ONE Program'!T19=\"Non-Owner (N/A DSCR)\",'NanQ ONE Program'!T19=\"Non-Owner (DSCR/No Ratio)\"),1,0)","v":0},null,"36 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Primary",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Second Home",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Non-Owner",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Max YSP OO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"<=$150,000",150000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"$150,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,"36 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,"24 Months PPP",101.5,101.5,101.5,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,100,100,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"6 Months PPP",100,100,100,99,99,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"No PPP \"See PPP Section\"",99.5,99.5,99.5,98.5,98.5,98.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,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'!#REF!>0,0,1)","v":{"$error":"#REF!"}},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'!#REF!=0,0,1)","v":{"$error":"#REF!"}},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:H45,MATCH(B58,B41:B45,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(OR(B57=\"Non-Owner (N/A DSCR)\",B57=\"Non-Owner (DSCR/No Ratio)\"),E54,\"ERROR\"))","v":{"$error":"#N/A"}},null,"Non-Owner (N/A DSCR)"]
[null,{"$f":"'NanQ ONE Program'!T17","v":0},{"$f":"VLOOKUP(B56,E27:F32,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Non-Owner (N/A DSCR)"]
[null,{"$f":"'NanQ ONE Program'!T19","v":"Primary"}]
[null,{"$f":"'NanQ ONE Program'!T23","v":"36 Months PPP"}]
[]
[null,0,2000000]
[null,2000001,3000000]
[null,3000001,10000000]
[]
[]
[]
[]
[]
[]
[]
[null,"Base Rate / Base Price",null,null,null,null,null,null,"Base Rate / Base Price"]
[null,"Coupon","Full Doc","Alt Doc","DSCR",null,"Total LLPA",null,"Coupon","Full Doc","Alt Doc","DSCR"]
[null,{"$f":"[4]Calc!AB97","v":4.25},{"$f":"[4]Calc!AC97","v":98.25},{"$f":"[4]Calc!AD97","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE97","v":{"$error":"#N/A"}},null,{"$f":"'NanQ ONE Program'!U27","v":{"$error":"#N/A"}},1,{"$f":"B104","v":8.25},{"$f":"C104+$G$72","v":{"$error":"#N/A"}},{"$f":"D104+$G$72","v":{"$error":"#N/A"}},{"$f":"E104+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB98","v":4.375},{"$f":"[4]Calc!AC98","v":98.75},{"$f":"[4]Calc!AD98","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE98","v":{"$error":"#N/A"}},null,null,2,{"$f":"B103","v":8.125},{"$f":"C103+$G$72","v":{"$error":"#N/A"}},{"$f":"D103+$G$72","v":{"$error":"#N/A"}},{"$f":"E103+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB99","v":4.4989999999999997},{"$f":"[4]Calc!AC99","v":99.25},{"$f":"[4]Calc!AD99","v":98.5},{"$f":"[4]Calc!AE99","v":{"$error":"#N/A"}},null,"Total Price",3,{"$f":"B102","v":7.9989999999999997},{"$f":"C102+$G$72","v":{"$error":"#N/A"}},{"$f":"D102+$G$72","v":{"$error":"#N/A"}},{"$f":"E102+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB100","v":4.625},{"$f":"[4]Calc!AC100","v":99.75},{"$f":"[4]Calc!AD100","v":99},{"$f":"[4]Calc!AE100","v":{"$error":"#N/A"}},null,100,4,{"$f":"B101","v":7.875},{"$f":"C101+$G$72","v":{"$error":"#N/A"}},{"$f":"D101+$G$72","v":{"$error":"#N/A"}},{"$f":"E101+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB101","v":4.75},{"$f":"[4]Calc!AC101","v":100.25},{"$f":"[4]Calc!AD101","v":99.5},{"$f":"[4]Calc!AE101","v":{"$error":"#N/A"}},null,null,5,{"$f":"B100","v":7.75},{"$f":"C100+$G$72","v":{"$error":"#N/A"}},{"$f":"D100+$G$72","v":{"$error":"#N/A"}},{"$f":"E100+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB102","v":4.875},{"$f":"[4]Calc!AC102","v":100.75},{"$f":"[4]Calc!AD102","v":100},{"$f":"[4]Calc!AE102","v":{"$error":"#N/A"}},null,null,6,{"$f":"B99","v":7.625},{"$f":"C99+$G$72","v":{"$error":"#N/A"}},{"$f":"D99+$G$72","v":{"$error":"#N/A"}},{"$f":"E99+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB103","v":4.9989999999999997},{"$f":"[4]Calc!AC103","v":101.125},{"$f":"[4]Calc!AD103","v":100.375},{"$f":"[4]Calc!AE103","v":99.25},null,null,7,{"$f":"B98","v":7.4989999999999997},{"$f":"C98+$G$72","v":{"$error":"#N/A"}},{"$f":"D98+$G$72","v":{"$error":"#N/A"}},{"$f":"E98+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB104","v":5.125},{"$f":"[4]Calc!AC104","v":101.5},{"$f":"[4]Calc!AD104","v":100.75},{"$f":"[4]Calc!AE104","v":99.625},null,{"$f":"'NanQ ONE Program'!T13","v":0},8,{"$f":"B97","v":7.375},{"$f":"C97+$G$72","v":{"$error":"#N/A"}},{"$f":"D97+$G$72","v":{"$error":"#N/A"}},{"$f":"E97+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB105","v":5.25},{"$f":"[4]Calc!AC105","v":101.875},{"$f":"[4]Calc!AD105","v":101.125},{"$f":"[4]Calc!AE105","v":100},null,null,9,{"$f":"B96","v":7.25},{"$f":"C96+$G$72","v":{"$error":"#N/A"}},{"$f":"D96+$G$72","v":{"$error":"#N/A"}},{"$f":"E96+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB106","v":5.375},{"$f":"[4]Calc!AC106","v":102.25},{"$f":"[4]Calc!AD106","v":101.5},{"$f":"[4]Calc!AE106","v":100.375},null,null,10,{"$f":"B95","v":7.125},{"$f":"C95+$G$72","v":{"$error":"#N/A"}},{"$f":"D95+$G$72","v":{"$error":"#N/A"}},{"$f":"E95+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB107","v":5.4989999999999997},{"$f":"[4]Calc!AC107","v":102.625},{"$f":"[4]Calc!AD107","v":101.875},{"$f":"[4]Calc!AE107","v":100.75},null,null,11,{"$f":"B94","v":6.9989999999999997},{"$f":"C94+$G$72","v":{"$error":"#N/A"}},{"$f":"D94+$G$72","v":{"$error":"#N/A"}},{"$f":"E94+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB108","v":5.625},{"$f":"[4]Calc!AC108","v":103},{"$f":"[4]Calc!AD108","v":102.25},{"$f":"[4]Calc!AE108","v":101.125},null,null,12,{"$f":"B93","v":6.875},{"$f":"C93+$G$72","v":{"$error":"#N/A"}},{"$f":"D93+$G$72","v":{"$error":"#N/A"}},{"$f":"E93+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB109","v":5.75},{"$f":"[4]Calc!AC109","v":103.375},{"$f":"[4]Calc!AD109","v":102.625},{"$f":"[4]Calc!AE109","v":101.5},null,null,13,{"$f":"B92","v":6.75},{"$f":"C92+$G$72","v":{"$error":"#N/A"}},{"$f":"D92+$G$72","v":{"$error":"#N/A"}},{"$f":"E92+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB110","v":5.875},{"$f":"[4]Calc!AC110","v":103.75},{"$f":"[4]Calc!AD110","v":103},{"$f":"[4]Calc!AE110","v":101.875},null,null,14,{"$f":"B91","v":6.625},{"$f":"C91+$G$72","v":{"$error":"#N/A"}},{"$f":"D91+$G$72","v":{"$error":"#N/A"}},{"$f":"E91+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB111","v":5.9989999999999997},{"$f":"[4]Calc!AC111","v":104.125},{"$f":"[4]Calc!AD111","v":103.375},{"$f":"[4]Calc!AE111","v":102.25},null,null,15,{"$f":"B90","v":6.4989999999999997},{"$f":"C90+$G$72","v":{"$error":"#N/A"}},{"$f":"D90+$G$72","v":{"$error":"#N/A"}},{"$f":"E90+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB112","v":6.125},{"$f":"[4]Calc!AC112","v":104.5},{"$f":"[4]Calc!AD112","v":103.75},{"$f":"[4]Calc!AE112","v":102.625},null,null,16,{"$f":"B89","v":6.375},{"$f":"C89+$G$72","v":{"$error":"#N/A"}},{"$f":"D89+$G$72","v":{"$error":"#N/A"}},{"$f":"E89+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB113","v":6.25},{"$f":"[4]Calc!AC113","v":104.875},{"$f":"[4]Calc!AD113","v":104.125},{"$f":"[4]Calc!AE113","v":103},null,null,17,{"$f":"B88","v":6.25},{"$f":"C88+$G$72","v":{"$error":"#N/A"}},{"$f":"D88+$G$72","v":{"$error":"#N/A"}},{"$f":"E88+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB114","v":6.375},{"$f":"[4]Calc!AC114","v":105.25},{"$f":"[4]Calc!AD114","v":104.5},{"$f":"[4]Calc!AE114","v":103.375},null,null,18,{"$f":"B87","v":6.125},{"$f":"C87+$G$72","v":{"$error":"#N/A"}},{"$f":"D87+$G$72","v":{"$error":"#N/A"}},{"$f":"E87+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB115","v":6.4989999999999997},{"$f":"[4]Calc!AC115","v":105.625},{"$f":"[4]Calc!AD115","v":104.875},{"$f":"[4]Calc!AE115","v":103.75},null,null,19,{"$f":"B86","v":5.9989999999999997},{"$f":"C86+$G$72","v":{"$error":"#N/A"}},{"$f":"D86+$G$72","v":{"$error":"#N/A"}},{"$f":"E86+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB116","v":6.625},{"$f":"[4]Calc!AC116","v":105.875},{"$f":"[4]Calc!AD116","v":105.125},{"$f":"[4]Calc!AE116","v":104},null,null,20,{"$f":"B85","v":5.875},{"$f":"C85+$G$72","v":{"$error":"#N/A"}},{"$f":"D85+$G$72","v":{"$error":"#N/A"}},{"$f":"E85+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB117","v":6.75},{"$f":"[4]Calc!AC117","v":106.125},{"$f":"[4]Calc!AD117","v":105.375},{"$f":"[4]Calc!AE117","v":104.25},null,null,21,{"$f":"B84","v":5.75},{"$f":"C84+$G$72","v":{"$error":"#N/A"}},{"$f":"D84+$G$72","v":{"$error":"#N/A"}},{"$f":"E84+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB118","v":6.875},{"$f":"[4]Calc!AC118","v":106.375},{"$f":"[4]Calc!AD118","v":105.625},{"$f":"[4]Calc!AE118","v":104.5},null,null,22,{"$f":"B83","v":5.625},{"$f":"C83+$G$72","v":{"$error":"#N/A"}},{"$f":"D83+$G$72","v":{"$error":"#N/A"}},{"$f":"E83+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB119","v":6.9989999999999997},{"$f":"[4]Calc!AC119","v":106.625},{"$f":"[4]Calc!AD119","v":105.875},{"$f":"[4]Calc!AE119","v":104.75},null,null,23,{"$f":"B82","v":5.4989999999999997},{"$f":"C82+$G$72","v":{"$error":"#N/A"}},{"$f":"D82+$G$72","v":{"$error":"#N/A"}},{"$f":"E82+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB120","v":7.125},{"$f":"[4]Calc!AC120","v":106.875},{"$f":"[4]Calc!AD120","v":106.125},{"$f":"[4]Calc!AE120","v":105},null,null,24,{"$f":"B81","v":5.375},{"$f":"C81+$G$72","v":{"$error":"#N/A"}},{"$f":"D81+$G$72","v":{"$error":"#N/A"}},{"$f":"E81+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB121","v":7.25},{"$f":"[4]Calc!AC121","v":107.125},{"$f":"[4]Calc!AD121","v":106.375},{"$f":"[4]Calc!AE121","v":105.25},null,null,25,{"$f":"B80","v":5.25},{"$f":"C80+$G$72","v":{"$error":"#N/A"}},{"$f":"D80+$G$72","v":{"$error":"#N/A"}},{"$f":"E80+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB122","v":7.375},{"$f":"[4]Calc!AC122","v":107.375},{"$f":"[4]Calc!AD122","v":106.625},{"$f":"[4]Calc!AE122","v":105.5},null,null,26,{"$f":"B79","v":5.125},{"$f":"C79+$G$72","v":{"$error":"#N/A"}},{"$f":"D79+$G$72","v":{"$error":"#N/A"}},{"$f":"E79+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB123","v":7.4989999999999997},{"$f":"[4]Calc!AC123","v":107.625},{"$f":"[4]Calc!AD123","v":106.875},{"$f":"[4]Calc!AE123","v":105.75},null,null,27,{"$f":"B78","v":4.9989999999999997},{"$f":"C78+$G$72","v":{"$error":"#N/A"}},{"$f":"D78+$G$72","v":{"$error":"#N/A"}},{"$f":"E78+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB124","v":7.625},{"$f":"[4]Calc!AC124","v":107.875},{"$f":"[4]Calc!AD124","v":107.125},{"$f":"[4]Calc!AE124","v":106},null,null,28,{"$f":"B77","v":4.875},{"$f":"C77+$G$72","v":{"$error":"#N/A"}},{"$f":"D77+$G$72","v":{"$error":"#N/A"}},{"$f":"E77+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB125","v":7.75},{"$f":"[4]Calc!AC125","v":108.125},{"$f":"[4]Calc!AD125","v":107.375},{"$f":"[4]Calc!AE125","v":106.25},null,null,29,{"$f":"B76","v":4.75},{"$f":"C76+$G$72","v":{"$error":"#N/A"}},{"$f":"D76+$G$72","v":{"$error":"#N/A"}},{"$f":"E76+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB126","v":7.875},{"$f":"[4]Calc!AC126","v":108.375},{"$f":"[4]Calc!AD126","v":107.625},{"$f":"[4]Calc!AE126","v":106.5},null,null,30,{"$f":"B75","v":4.625},{"$f":"C75+$G$72","v":{"$error":"#N/A"}},{"$f":"D75+$G$72","v":{"$error":"#N/A"}},{"$f":"E75+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB127","v":7.9989999999999997},{"$f":"[4]Calc!AC127","v":108.625},{"$f":"[4]Calc!AD127","v":107.875},{"$f":"[4]Calc!AE127","v":106.75},null,null,30,{"$f":"B74","v":4.4989999999999997},{"$f":"C74+$G$72","v":{"$error":"#N/A"}},{"$f":"D74+$G$72","v":{"$error":"#N/A"}},{"$f":"E74+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB128","v":8.125},{"$f":"[4]Calc!AC128","v":108.875},{"$f":"[4]Calc!AD128","v":108.125},{"$f":"[4]Calc!AE128","v":107},null,null,30,{"$f":"B73","v":4.375},{"$f":"C73+$G$72","v":{"$error":"#N/A"}},{"$f":"D73+$G$72","v":{"$error":"#N/A"}},{"$f":"E73+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB129","v":8.25},{"$f":"[4]Calc!AC129","v":109.125},{"$f":"[4]Calc!AD129","v":108.375},{"$f":"[4]Calc!AE129","v":107.25},null,null,30,{"$f":"B72","v":4.25},{"$f":"C72+$G$72","v":{"$error":"#N/A"}},{"$f":"D72+$G$72","v":{"$error":"#N/A"}},{"$f":"E72+$G$72","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(G75,J72:J101,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(G75,K72:K101,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(G75,L72:L104,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J105,H75:I104,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K105,H75:I104,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L105,H75:L104,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G79=J71,J106,0)","v":0},{"$f":"IF(G79=K71,K106,0)","v":0},{"$f":"IF(G79=L71,L106,0)","v":0},{"$f":"SUM(J107:L107)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(J105,H75:J104,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K105,H75:K104,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L105,H75:L104,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G79=J71,J108,0)","v":0},{"$f":"IF(G79=K71,K108,0)","v":0},{"$f":"IF(G79=L71,L108,0)","v":0},{"$f":"SUM(J109:L109)","v":0}]
[]
[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,null,null,"Coupon","Full Doc","Alt Doc","DSCR/No Ratio"]
[null,{"$f":"B72","v":4.25},{"$f":"C72","v":98.25},{"$error":"#N/A"},{"$error":"#N/A"},null,null,1,{"$f":"I72","v":8.25},{"$f":"J72","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B73","v":4.375},98.75,{"$error":"#N/A"},{"$error":"#N/A"},null,"Total LLPA",2,{"$f":"I73","v":8.125},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B74","v":4.4989999999999997},99.25,98.5,{"$error":"#N/A"},null,{"$f":"'NanQ ONE Program'!U27","v":{"$error":"#N/A"}},3,{"$f":"I74","v":7.9989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B75","v":4.625},99.75,99,{"$error":"#N/A"},null,"LPC",4,{"$f":"I75","v":7.875},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B76","v":4.75},100.25,99.5,{"$error":"#N/A"},null,null,5,{"$f":"I76","v":7.75},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B77","v":4.875},100.75,100,{"$error":"#N/A"},null,null,6,{"$f":"I77","v":7.625},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B78","v":4.9989999999999997},101.125,100.375,99.25,null,"Total Price",7,{"$f":"I78","v":7.4989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B79","v":5.125},101.5,100.75,99.625,null,102,8,{"$f":"I79","v":7.375},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B80","v":5.25},101.875,101.125,100,null,null,9,{"$f":"I80","v":7.25},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B81","v":5.375},102.25,101.5,100.375,null,{"$f":"'NanQ ONE Program'!T13","v":0},10,{"$f":"I81","v":7.125},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B82","v":5.4989999999999997},102.625,101.875,100.75,null,null,11,{"$f":"I82","v":6.9989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B83","v":5.625},103,102.25,101.125,null,null,12,{"$f":"I83","v":6.875},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B84","v":5.75},103.375,102.625,101.5,null,null,13,{"$f":"I84","v":6.75},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B85","v":5.875},103.75,103,101.875,null,null,14,{"$f":"I85","v":6.625},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B86","v":5.9989999999999997},104.125,103.375,102.25,null,null,15,{"$f":"I86","v":6.4989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B87","v":6.125},104.5,103.75,102.625,null,null,16,{"$f":"I87","v":6.375},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B88","v":6.25},104.875,104.125,103,null,null,17,{"$f":"I88","v":6.25},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B89","v":6.375},105.25,104.5,103.375,null,null,18,{"$f":"I89","v":6.125},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B90","v":6.4989999999999997},105.625,104.875,103.75,null,null,19,{"$f":"I90","v":5.9989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B91","v":6.625},105.875,105.125,104,null,null,20,{"$f":"I91","v":5.875},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B92","v":6.75},106.125,105.375,104.25,null,null,21,{"$f":"I92","v":5.75},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B93","v":6.875},106.375,105.625,104.5,null,null,22,{"$f":"I93","v":5.625},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B94","v":6.9989999999999997},106.625,105.875,104.75,null,null,23,{"$f":"I94","v":5.4989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B95","v":7.125},106.875,106.125,105,null,null,24,{"$f":"I95","v":5.375},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B96","v":7.25},107.125,106.375,105.25,null,null,25,{"$f":"I96","v":5.25},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B97","v":7.375},107.375,106.625,105.5,null,null,26,{"$f":"I97","v":5.125},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B98","v":7.4989999999999997},107.625,106.875,105.75,null,null,27,{"$f":"I98","v":4.9989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B99","v":7.625},107.875,107.125,106,null,null,28,{"$f":"I99","v":4.875},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B100","v":7.75},108.125,107.375,106.25,null,null,29,{"$f":"I100","v":4.75},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B101","v":7.875},108.375,107.625,106.5,null,null,30,{"$f":"I101","v":4.625},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B102","v":7.9989999999999997},108.625,107.875,106.75,null,null,31,{"$f":"I102","v":4.4989999999999997},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B103","v":8.125},108.875,108.125,107,null,null,32,{"$f":"I103","v":4.375},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B104","v":8.25},109.125,108.375,107.25,null,null,33,{"$f":"I104","v":4.25},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(100,J113:J145,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K113:K145,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L113:L145,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J146,H113:I164,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K146,H113:I164,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L146,H113:L164,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Near Par Rate - BPC",null,{"$f":"Feed!M107","v":0},{"$f":"M109","v":0},null,null,null,null,{"$f":"IF(G122=J112,J147,0)","v":0},{"$f":"IF(G122=K112,K147,0)","v":0},{"$f":"IF(G122=L112,L147,0)","v":0},{"$f":"SUM(J148:L148)","v":0}]
[null,"Near Par Rate - BPC",null,null,{"$f":"IF(E148>'NanQ ONE Program'!U29,'NanQ ONE Program'!U29,Feed!E148)","v":0},null,null,null,null,{"$f":"VLOOKUP(J146,H113:J164,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K146,H113:K164,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L146,H113:L164,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G122=J112,J149,0)","v":0},{"$f":"IF(G122=K112,K149,0)","v":0},{"$f":"IF(G122=L112,L149,0)","v":0},{"$f":"SUM(J150:L150)","v":0}]
[null,"Near Par Rate - LPC",null,{"$f":"Feed!M148","v":0},{"$f":"Feed!M150","v":0}]
[null,"Near Par Rate - LPC",null,null,{"$f":"IF(E151>'NanQ ONE Program'!U29,'NanQ ONE Program'!U29,Feed!E151)","v":0}]
[]
[]
[]
[]
[]
[]
["Max Price"]
[{"$f":"N3","v":"No PPP/See State Section"},{"$f":"J3","v":"Primary"},"Owner Occ/Sec Home",{"$f":"IF('NanQ ONE Program'!T19=Feed!B160,'NanQ ONE Program'!O31,IF('NanQ ONE Program'!T19=Feed!B161,'NanQ ONE Program'!O31,\"NA\"))","v":102}]
["12 Months PPP",{"$f":"J4","v":"Second Home"},"No PPP/See State Section",{"$f":"IF(AND('NanQ ONE Program'!T19=Feed!B162,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C161),'NanQ ONE Program'!O32,IF(AND('NanQ ONE Program'!T19=Feed!B163,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C161),'NanQ ONE Program'!O32,\"NA\"))","v":"NA"}]
["24 Months PPP",{"$f":"J5","v":"Non-Owner (N/A DSCR)"},"12 Months PPP",{"$f":"IF(AND('NanQ ONE Program'!T19=Feed!B162,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C162),'NanQ ONE Program'!O33,IF(AND('NanQ ONE Program'!T19=Feed!B163,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C162),'NanQ ONE Program'!O33,\"NA\"))","v":"NA"}]
["36 Months PPP",{"$f":"J6","v":"Non-Owner (DSCR/No Ratio)"},"24 Months PPP",{"$f":"IF(AND('NanQ ONE Program'!T19=Feed!B162,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C163),'NanQ ONE Program'!O34,IF(AND('NanQ ONE Program'!T19=Feed!B163,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C163),'NanQ ONE Program'!O34,\"NA\"))","v":"NA"}]
["48 Months PPP",null,"36 Months PPP",{"$f":"IF(AND('NanQ ONE Program'!T19=Feed!B162,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C164),'NanQ ONE Program'!O35,IF(AND('NanQ ONE Program'!T19=Feed!B163,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C164),'NanQ ONE Program'!O35,\"NA\"))","v":"NA"}]
["60 Months PPP",null,"48 Months PPP",{"$f":"IF(AND('NanQ ONE Program'!T19=Feed!B162,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C165),'NanQ ONE Program'!O36,IF(AND('NanQ ONE Program'!T19=Feed!B163,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C165),'NanQ ONE Program'!O36,\"NA\"))","v":"NA"}]
[null,null,"60 Months PPP",{"$f":"IF(AND('NanQ ONE Program'!T19=Feed!B162,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C166),'NanQ ONE Program'!O37,IF(AND('NanQ ONE Program'!T19=Feed!B163,'NanQ ONE Program'!T23,'NanQ ONE Program'!T23=Feed!C166),'NanQ ONE Program'!O37,\"NA\"))","v":"NA"}]
[]
[null,null,"Max Price",{"$f":"MAX(D160:D166)","v":102}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,102]
[null,null,null,100]
[null,null,null,101]
[null,null,null,101.5]
[null,null,null,102]
[null,null,null,102.5]
[null,null,null,103]

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

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