{"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":52,"n_cols":31,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,6,50,9],[51,8,51,9],[5,1,6,15],[45,1,45,2],[41,6,41,8],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,9,46,10],[46,6,46,7],[47,9,47,10],[47,6,47,7],[48,6,48,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[51,6,51,7],[46,1,46,2],[46,3,46,4],[46,19,46,22],[49,6,49,7],[41,9,41,12],[42,9,42,11],[43,9,43,11],[44,9,44,11],[45,9,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[48,9,48,10],[49,9,49,10],[49,11,49,12],[37,17,45,24],[4,12,4,15],[50,1,50,2],[8,1,8,4],[33,6,33,7],[34,6,34,7],[49,3,49,4],[50,3,50,4],[48,3,48,4],[41,13,41,15],[19,6,19,15],[8,6,8,15],[44,1,44,4],[45,3,45,4],[47,1,47,4],[48,1,48,2],[49,1,49,2],[38,6,38,7],[39,6,39,7],[37,6,37,7],[35,6,35,7],[36,6,36,7],[32,6,32,7],[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],[22,6,22,7],[21,6,21,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[23,6,23,7],[24,6,24,7],[28,17,28,19],[29,17,29,19],[30,17,30,19],[28,21,28,24],[32,17,32,19],[24,17,24,18],[31,17,31,19],[31,20,31,24],[30,21,30,24],[29,21,29,24],[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],[17,17,17,18],[36,17,36,24],[34,17,34,19],[32,20,32,24],[33,17,33,19],[33,20,33,23],[7,21,7,24],[8,21,8,24],[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],[34,20,34,23],[18,17,18,18],[19,17,19,18],[20,17,20,18],[26,17,26,19],[27,17,27,19]]}
[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":"30 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!AV84","v":"2020-10-16"}]
[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,{"$f":"M5","v":"2020-10-16"},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!AB99","v":4.4989999999999997},{"$f":"[4]Calc!AC99","v":97.75},{"$f":"[4]Calc!AD99","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE99","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!AB100","v":4.625},{"$f":"[4]Calc!AC100","v":98.25},{"$f":"[4]Calc!AD100","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE100","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(I43:I50,MATCH(T12,G43:G50,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB101","v":4.75},{"$f":"[4]Calc!AC101","v":98.75},{"$f":"[4]Calc!AD101","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE101","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!AB102","v":4.875},{"$f":"[4]Calc!AC102","v":99.25},{"$f":"[4]Calc!AD102","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE102","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:P$40,MATCH(T14,G$22:G$40,0),MATCH(T10,I21:P21,0))))","v":{"$error":"#N/A"}},null,null,null,null,"12 or 24 Bank Statements"]
[null,{"$f":"[4]Calc!AB103","v":4.9989999999999997},{"$f":"[4]Calc!AC103","v":99.625},{"$f":"[4]Calc!AD103","v":98.875},{"$f":"[4]Calc!AE103","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:P$40,MATCH(T15,G$22:G$40,0),MATCH(T$10,I$21:P$21,0)))))","v":{"$error":"#N/A"}},null,null,null,null,"12 or 24 CPA P&L W/3 Months Bk St"]
[null,{"$f":"[4]Calc!AB104","v":5.125},{"$f":"[4]Calc!AC104","v":100},{"$f":"[4]Calc!AD104","v":99.25},{"$f":"[4]Calc!AE104","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:P$40,MATCH(T16,G$22:G$40,0),MATCH(T$10,I$21:P$21,0))))","v":{"$error":"#N/A"}},null,null,null,null,"Asset Utlization W/ Bank Stmt"]
[null,{"$f":"[4]Calc!AB105","v":5.25},{"$f":"[4]Calc!AC105","v":100.375},{"$f":"[4]Calc!AD105","v":99.625},{"$f":"[4]Calc!AE105","v":{"$error":"#N/A"}},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:P$40,MATCH(T17,G$22:G$40,0),MATCH(T$10,I$21:P$21,0))))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB106","v":5.375},{"$f":"[4]Calc!AC106","v":100.75},{"$f":"[4]Calc!AD106","v":100},{"$f":"[4]Calc!AE106","v":98.875},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:P$40,MATCH(T18,G$22:G$40,0),MATCH(T$10,I$21:P$21,0)))","v":{"$error":"#N/A"}},null,null,null,null,"DSCR/No Ratio Column Includes"]
[null,{"$f":"[4]Calc!AB107","v":5.4989999999999997},{"$f":"[4]Calc!AC107","v":101.125},{"$f":"[4]Calc!AD107","v":100.375},{"$f":"[4]Calc!AE107","v":99.25},null,null,null,null,null,null,null,null,null,null,null,null,"Occupancy",null,null,{"$f":"IF(OR(T19=\"Primary\"),0,IF(OR(T19=\"Non-Owner (DSCR/No Ratio)\"),0,INDEX(I$22:P$40,MATCH(T19,G$22:G$40,0),MATCH(T$10,I$21:P$21,0))))","v":{"$error":"#N/A"}},null,null,null,null,"DSCR"]
[null,{"$f":"[4]Calc!AB108","v":5.625},{"$f":"[4]Calc!AC108","v":101.5},{"$f":"[4]Calc!AD108","v":100.75},{"$f":"[4]Calc!AE108","v":99.625},null,{"$f":"[4]Calc!$AQ$105","v":"Loan Level Price Adjustments"},null,null,null,null,null,null,null,null,null,null,"Property Type",null,null,{"$f":"IF(OR(T20=\"SFR\",T20=\"1-2 Units\",T20=\"PUD\",T20=\"Condo\"),0,INDEX(I$22:P$40,MATCH(T20,G$22:G$40,0),MATCH(T$10,I$21:P$21,0)))","v":{"$error":"#N/A"}},null,null,null,null,"No Ratio"]
[null,{"$f":"[4]Calc!AB109","v":5.75},{"$f":"[4]Calc!AC109","v":101.875},{"$f":"[4]Calc!AD109","v":101.125},{"$f":"[4]Calc!AE109","v":100},null,null,null,{"$f":"[4]Calc!AS106","v":"<=50"},{"$f":"[4]Calc!AT106","v":"50.01-60"},{"$f":"[4]Calc!AU106","v":"60.01-65"},{"$f":"[4]Calc!AV106","v":"65.01-70"},{"$f":"[4]Calc!AW106","v":"70.01-75"},{"$f":"[4]Calc!AX106","v":"75.01-80"},{"$f":"[4]Calc!AY106","v":"80.01-85"},{"$f":"[4]Calc!AZ106","v":"85.01-90"},null,"Loan Term",null,"5/1 30YR ARM",{"$f":"INDEX(P43:P50,MATCH(T21,N43:N50,0))","v":0}]
[null,{"$f":"[4]Calc!AB110","v":5.875},{"$f":"[4]Calc!AC110","v":102.25},{"$f":"[4]Calc!AD110","v":101.5},{"$f":"[4]Calc!AE110","v":100.375},null,{"$f":"[4]Calc!AQ107","v":"*ACH Special*"},null,{"$f":"[4]Calc!AS107","v":0.25},{"$f":"[4]Calc!AT107","v":0.25},{"$f":"[4]Calc!AU107","v":0.25},{"$f":"[4]Calc!AV107","v":0.25},{"$f":"[4]Calc!AW107","v":0.25},{"$f":"[4]Calc!AX107","v":0.25},{"$f":"[4]Calc!AY107","v":0.25},{"$f":"[4]Calc!AZ107","v":0.25},null,"Escrow",null,"Escrow Not Waived",{"$f":"IF(T22=\"Escrow Not Waived\",0,INDEX(I$22:P$40,MATCH(T22,G$22:G$40,0),MATCH(T$10,I$21:P$21,0)))","v":0}]
[null,{"$f":"[4]Calc!AB111","v":5.9989999999999997},{"$f":"[4]Calc!AC111","v":102.625},{"$f":"[4]Calc!AD111","v":101.875},{"$f":"[4]Calc!AE111","v":100.75},null,{"$f":"[4]Calc!AQ108","v":"Full Doc (>50 DTI)"},null,{"$f":"[4]Calc!AS108","v":-0.5},{"$f":"[4]Calc!AT108","v":-0.5},{"$f":"[4]Calc!AU108","v":-0.625},{"$f":"[4]Calc!AV108","v":-0.625},{"$f":"[4]Calc!AW108","v":-0.75},{"$f":"[4]Calc!AX108","v":-1},{"$f":"[4]Calc!AY108","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ108","v":{"$error":"#N/A"}},null,"Prepayment Penalty",null,"No PPP/See State Section",{"$f":"IF(OR(T19=\"Primary\",T19=\"Second Home\"),0,IF(T23=\"No PPP/See State Section\",0,INDEX(I$22:P$40,MATCH(T23,G$22:G$40,0),MATCH(T$10,I$21:P$21,0))))","v":0}]
[null,{"$f":"[4]Calc!AB112","v":6.125},{"$f":"[4]Calc!AC112","v":103},{"$f":"[4]Calc!AD112","v":102.25},{"$f":"[4]Calc!AE112","v":101.125},null,{"$f":"[4]Calc!AQ109","v":"Alt Doc (>43 DTI)"},null,{"$f":"[4]Calc!AS109","v":-0.25},{"$f":"[4]Calc!AT109","v":-0.25},{"$f":"[4]Calc!AU109","v":-0.25},{"$f":"[4]Calc!AV109","v":-0.375},{"$f":"[4]Calc!AW109","v":-0.375},{"$f":"[4]Calc!AX109","v":-0.5},{"$f":"[4]Calc!AY109","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ109","v":{"$error":"#N/A"}},null,"State",null,"All Other States",0]
[null,{"$f":"[4]Calc!AB113","v":6.25},{"$f":"[4]Calc!AC113","v":103.375},{"$f":"[4]Calc!AD113","v":102.625},{"$f":"[4]Calc!AE113","v":101.5},null,{"$f":"[4]Calc!AQ110","v":"Non-Owner (N/A DSCR)"},null,{"$f":"[4]Calc!AS110","v":-0.5},{"$f":"[4]Calc!AT110","v":-0.5},{"$f":"[4]Calc!AU110","v":-0.5},{"$f":"[4]Calc!AV110","v":-0.75},{"$f":"[4]Calc!AW110","v":-1},{"$f":"[4]Calc!AX110","v":-1.375},{"$f":"[4]Calc!AY110","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ110","v":{"$error":"#N/A"}},null,"ACH Special",null,"Yes",{"$f":"IF(T25=\"Yes\",0.25,0)","v":0.25}]
[null,{"$f":"[4]Calc!AB114","v":6.375},{"$f":"[4]Calc!AC114","v":103.75},{"$f":"[4]Calc!AD114","v":103},{"$f":"[4]Calc!AE114","v":101.875},null,{"$f":"[4]Calc!AQ111","v":"24 Month Full Doc"},null,{"$f":"[4]Calc!AS111","v":0.25},{"$f":"[4]Calc!AT111","v":0.25},{"$f":"[4]Calc!AU111","v":0.25},{"$f":"[4]Calc!AV111","v":0.25},{"$f":"[4]Calc!AW111","v":0.25},{"$f":"[4]Calc!AX111","v":0.25},{"$f":"[4]Calc!AY111","v":0.25},{"$f":"[4]Calc!AZ111","v":0.25},null,"Lock Term",null,"30 Day",{"$f":"IF(T26=\"15 Day\",L47,IF(T26=\"30 Day\",L48,IF(T26=\"45 Day\",L49,IF(T26=\"60 Day\",L50,\"NA\"))))","v":0},null,null,null,null,null,null,null,"Minimum rate rule",{"$f":"IF(T9>4.74,0,1)","v":1}]
[null,{"$f":"[4]Calc!AB115","v":6.4989999999999997},{"$f":"[4]Calc!AC115","v":104.125},{"$f":"[4]Calc!AD115","v":103.375},{"$f":"[4]Calc!AE115","v":102.25},null,{"$f":"[4]Calc!AQ112","v":"Asset Utilization"},null,{"$f":"[4]Calc!AS112","v":-0.5},{"$f":"[4]Calc!AT112","v":-0.5},{"$f":"[4]Calc!AU112","v":-0.5},{"$f":"[4]Calc!AV112","v":-0.75},{"$f":"[4]Calc!AW112","v":-1},{"$f":"[4]Calc!AX112","v":-1.5},{"$f":"[4]Calc!AY112","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ112","v":{"$error":"#N/A"}},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!AB116","v":6.625},{"$f":"[4]Calc!AC116","v":104.375},{"$f":"[4]Calc!AD116","v":103.625},{"$f":"[4]Calc!AE116","v":102.5},null,{"$f":"[4]Calc!AQ113","v":"Debt Consolidation"},null,{"$f":"[4]Calc!AS113","v":-0.6},{"$f":"[4]Calc!AT113","v":-0.6},{"$f":"[4]Calc!AU113","v":-0.6},{"$f":"[4]Calc!AV113","v":-0.8},{"$f":"[4]Calc!AW113","v":-1},{"$f":"[4]Calc!AX113","v":-1},{"$f":"[4]Calc!AY113","v":-1.5},{"$f":"[4]Calc!AZ113","v":-2},null,"  Gross Rate Sheet Price (Prior to LLPAs)",null,null,{"$f":"IFERROR(INDEX(B11:E43,MATCH(T9,B11:B43,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!AB117","v":6.75},{"$f":"[4]Calc!AC117","v":104.625},{"$f":"[4]Calc!AD117","v":103.875},{"$f":"[4]Calc!AE117","v":102.75},null,{"$f":"[4]Calc!AQ114","v":"Cash-Out"},null,{"$f":"[4]Calc!AS114","v":-0.6},{"$f":"[4]Calc!AT114","v":-0.6},{"$f":"[4]Calc!AU114","v":-0.6},{"$f":"[4]Calc!AV114","v":-0.8},{"$f":"[4]Calc!AW114","v":-1},{"$f":"[4]Calc!AX114","v":-1.5},{"$f":"[4]Calc!AY114","v":-2},{"$f":"[4]Calc!AZ114","v":{"$error":"#N/A"}},null,"  Max YSP",null,null,{"$f":"Feed!C163","v":100},{"$f":"CONCATENATE(R29,\" \",\"is\",\" \", U29)","v":"  Max YSP is 100"},null,null,null,null,null,null,"Texas rule",{"$f":"IF(NOT(T24=\"Texas\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AB118","v":6.875},{"$f":"[4]Calc!AC118","v":104.875},{"$f":"[4]Calc!AD118","v":104.125},{"$f":"[4]Calc!AE118","v":103},null,{"$f":"[4]Calc!AQ115","v":"3-4 Units"},null,{"$f":"[4]Calc!AS115","v":-0.7},{"$f":"[4]Calc!AT115","v":-0.7},{"$f":"[4]Calc!AU115","v":-0.7},{"$f":"[4]Calc!AV115","v":-0.7},{"$f":"[4]Calc!AW115","v":-0.7},{"$f":"[4]Calc!AX115","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AY115","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ115","v":{"$error":"#N/A"}},null,"  Net Price: Rate Sheet - LLPA (Prior to Max YSP)",null,null,{"$f":"IFERROR(U28+U27,\"Minimum Rate\")","v":"Minimum Rate"},{"$f":"IF(U35=\"Lender Paid\",\"LPC Selected\",IF(AND(U35=\"Borrower Paid\",Y35=\"\",U35=\"Choose a Selection\"),\"BPC is Blank\",\"BPC Inputted\"))","v":"BPC Inputted"},null,null,null,null,null,null,"15 Day Rule",{"$f":"IF(T26=\"15 Day\",0,1)","v":1}]
[null,{"$f":"[4]Calc!AB119","v":6.9989999999999997},{"$f":"[4]Calc!AC119","v":105.125},{"$f":"[4]Calc!AD119","v":104.375},{"$f":"[4]Calc!AE119","v":103.25},null,{"$f":"[4]Calc!AQ116","v":"Second Home"},null,{"$f":"[4]Calc!AS116","v":-0.8},{"$f":"[4]Calc!AT116","v":-0.8},{"$f":"[4]Calc!AU116","v":-0.8},{"$f":"[4]Calc!AV116","v":-1},{"$f":"[4]Calc!AW116","v":-1},{"$f":"[4]Calc!AX116","v":-1},{"$f":"[4]Calc!AY116","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ116","v":{"$error":"#N/A"}},null,"  Net Rate Sheet Price - As Borrower Paid (BPC)",null,null,{"$f":"IFERROR(IF(U30>U29,U29,U30),\"Priced LPC\")","v":100},{"$f":"CONCATENATE(Feed!B141,\" \",Feed!D141,\"%\" &\" @ \"&Feed!E142)","v":"Near Par Rate - BPC 0% @ 0"},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!AB120","v":7.125},{"$f":"[4]Calc!AC120","v":105.375},{"$f":"[4]Calc!AD120","v":104.625},{"$f":"[4]Calc!AE120","v":103.5},null,{"$f":"[4]Calc!AQ117","v":"12 Months PPP"},null,{"$f":"[4]Calc!AS117","v":0},{"$f":"[4]Calc!AT117","v":0},{"$f":"[4]Calc!AU117","v":0},{"$f":"[4]Calc!AV117","v":0},{"$f":"[4]Calc!AW117","v":0},{"$f":"[4]Calc!AX117","v":0},{"$f":"[4]Calc!AY117","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ117","v":{"$error":"#N/A"}},null,"Loan Number",null,null,"Borrower Name",null,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!AB121","v":7.25},{"$f":"[4]Calc!AC121","v":105.625},{"$f":"[4]Calc!AD121","v":104.875},{"$f":"[4]Calc!AE121","v":103.75},null,{"$f":"[4]Calc!AQ118","v":"24 Months PPP"},null,{"$f":"[4]Calc!AS118","v":0.25},{"$f":"[4]Calc!AT118","v":0.25},{"$f":"[4]Calc!AU118","v":0.25},{"$f":"[4]Calc!AV118","v":0.25},{"$f":"[4]Calc!AW118","v":0.25},{"$f":"[4]Calc!AX118","v":0.25},{"$f":"[4]Calc!AY118","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ118","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have Selected Income Qualifing Inv Loan"]
[null,{"$f":"[4]Calc!AB122","v":7.375},{"$f":"[4]Calc!AC122","v":105.875},{"$f":"[4]Calc!AD122","v":105.125},{"$f":"[4]Calc!AE122","v":104},null,{"$f":"[4]Calc!AQ119","v":"36 Months PPP"},null,{"$f":"[4]Calc!AS119","v":0.375},{"$f":"[4]Calc!AT119","v":0.375},{"$f":"[4]Calc!AU119","v":0.375},{"$f":"[4]Calc!AV119","v":0.375},{"$f":"[4]Calc!AW119","v":0.375},{"$f":"[4]Calc!AX119","v":0.375},{"$f":"[4]Calc!AY119","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ119","v":{"$error":"#N/A"}},null,"Property Address",null,null,"Compensation Type",null,null,null,"Comp?"]
[null,{"$f":"[4]Calc!AB123","v":7.4989999999999997},{"$f":"[4]Calc!AC123","v":106.125},{"$f":"[4]Calc!AD123","v":105.375},{"$f":"[4]Calc!AE123","v":104.25},null,{"$f":"[4]Calc!AQ120","v":"48 Months PPP"},null,{"$f":"[4]Calc!AS120","v":0.375},{"$f":"[4]Calc!AT120","v":0.375},{"$f":"[4]Calc!AU120","v":0.375},{"$f":"[4]Calc!AV120","v":0.375},{"$f":"[4]Calc!AW120","v":0.375},{"$f":"[4]Calc!AX120","v":0.375},{"$f":"[4]Calc!AY120","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ120","v":{"$error":"#N/A"}},null,null,null,null,"Borrower Paid"]
[null,{"$f":"[4]Calc!AB124","v":7.625},{"$f":"[4]Calc!AC124","v":106.375},{"$f":"[4]Calc!AD124","v":105.625},{"$f":"[4]Calc!AE124","v":104.5},null,{"$f":"[4]Calc!AQ121","v":"60 Months PPP"},null,{"$f":"[4]Calc!AS121","v":0.5},{"$f":"[4]Calc!AT121","v":0.5},{"$f":"[4]Calc!AU121","v":0.5},{"$f":"[4]Calc!AV121","v":0.5},{"$f":"[4]Calc!AW121","v":0.5},{"$f":"[4]Calc!AX121","v":0.5},{"$f":"[4]Calc!AY121","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ121","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB125","v":7.75},{"$f":"[4]Calc!AC125","v":106.625},{"$f":"[4]Calc!AD125","v":105.875},{"$f":"[4]Calc!AE125","v":104.75},null,{"$f":"[4]Calc!AQ122","v":"NW Condo"},null,{"$f":"[4]Calc!AS122","v":-0.75},{"$f":"[4]Calc!AT122","v":-0.875},{"$f":"[4]Calc!AU122","v":-1},{"$f":"[4]Calc!AV122","v":-1.25},{"$f":"[4]Calc!AW122","v":-1.75},{"$f":"[4]Calc!AX122","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AY122","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ122","v":{"$error":"#N/A"}},null,"Prepayment Penalty (Non-TRID / Business Purpose Loans Only)"]
[null,{"$f":"[4]Calc!AB126","v":7.875},{"$f":"[4]Calc!AC126","v":106.875},{"$f":"[4]Calc!AD126","v":106.125},{"$f":"[4]Calc!AE126","v":105},null,{"$f":"[4]Calc!AQ123","v":"ITIN"},null,{"$f":"[4]Calc!AS123","v":-0.75},{"$f":"[4]Calc!AT123","v":-0.75},{"$f":"[4]Calc!AU123","v":-0.875},{"$f":"[4]Calc!AV123","v":-1},{"$f":"[4]Calc!AW123","v":-1.25},{"$f":"[4]Calc!AX123","v":-1.75},{"$f":"[4]Calc!AY123","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ123","v":{"$error":"#N/A"}},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,{"$f":"[4]Calc!AB127","v":7.9989999999999997},{"$f":"[4]Calc!AC127","v":107.125},{"$f":"[4]Calc!AD127","v":106.375},{"$f":"[4]Calc!AE127","v":105.25},null,{"$f":"[4]Calc!AQ124","v":"$150,001-$1,500,000"},null,{"$f":"[4]Calc!AS124","v":0},{"$f":"[4]Calc!AT124","v":0},{"$f":"[4]Calc!AU124","v":0},{"$f":"[4]Calc!AV124","v":0},{"$f":"[4]Calc!AW124","v":0},{"$f":"[4]Calc!AX124","v":0},{"$f":"[4]Calc!AY124","v":0},{"$f":"[4]Calc!AZ124","v":0}]
[null,{"$f":"[4]Calc!AB128","v":8.125},{"$f":"[4]Calc!AC128","v":107.375},{"$f":"[4]Calc!AD128","v":106.625},{"$f":"[4]Calc!AE128","v":105.5},null,{"$f":"[4]Calc!AQ125","v":"$1,500,001-$3,000,000"},null,{"$f":"[4]Calc!AS125","v":0},{"$f":"[4]Calc!AT125","v":-0.125},{"$f":"[4]Calc!AU125","v":-0.25},{"$f":"[4]Calc!AV125","v":-0.375},{"$f":"[4]Calc!AW125","v":-0.5},{"$f":"[4]Calc!AX125","v":-0.75},{"$f":"[4]Calc!AY125","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AZ125","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AB129","v":8.25},{"$f":"[4]Calc!AC129","v":107.625},{"$f":"[4]Calc!AD129","v":106.875},{"$f":"[4]Calc!AE129","v":105.75}]
[null,{"$f":"[4]Calc!AB130","v":8.375},{"$f":"[4]Calc!AC130","v":107.875},{"$f":"[4]Calc!AD130","v":107.125},{"$f":"[4]Calc!AE130","v":106},null,{"$f":"[4]Calc!AU127","v":"Grades"},null,null,{"$f":"[4]Calc!AY136","v":"Margins"},null,null,null,{"$f":"[4]Calc!AQ127","v":"Loan Term"}]
[null,{"$f":"[4]Calc!AB131","v":8.4990000000000006},{"$f":"[4]Calc!AC131","v":108.125},{"$f":"[4]Calc!AD131","v":107.375},{"$f":"[4]Calc!AE131","v":106.25},null,{"$f":"[4]Calc!AU128","v":"Select - Standard"},{"$f":"[4]Calc!AV128","v":0},{"$f":"[4]Calc!AW128","v":0.5},{"$f":"[4]Calc!AY137","v":"Occupancy"},null,null,{"$f":"[4]Calc!BA137","v":"Margin"},{"$f":"[4]Calc!AQ128","v":"5/1 30YR ARM"},null,{"$f":"[4]Calc!AS128","v":0}]
[null,null,null,null,null,null,{"$f":"[4]Calc!AU129","v":"A+"},null,{"$f":"[4]Calc!AW129","v":0},{"$f":"[4]Calc!AY138","v":"Owner Occ/Sec Home"},null,null,{"$f":"[4]Calc!BA138","v":3},{"$f":"[4]Calc!AQ129","v":"5/1 30YR IO ARM"},null,{"$f":"[4]Calc!AS129","v":-0.25}]
[null,{"$f":"[4]Calc!AQ137","v":"Max Price"},null,null,null,null,{"$f":"[4]Calc!AU130","v":"A"},{"$f":"[4]Calc!AV130","v":0},{"$f":"[4]Calc!AW130","v":-1.5},{"$f":"[4]Calc!AY139","v":"Investment"},null,null,{"$f":"[4]Calc!BA139","v":5},{"$f":"[4]Calc!AQ130","v":"5/1 40YR IO ARM"},null,{"$f":"[4]Calc!AS130","v":-0.375}]
[null,{"$f":"[4]Calc!AQ138","v":"All Scenarios"},null,{"$f":"[4]Calc!AS138","v":100},null,null,{"$f":"[4]Calc!AU131","v":"B"},{"$f":"[4]Calc!AV131","v":0},{"$f":"[4]Calc!AW131","v":-2},{"$f":"[4]Calc!AY130","v":"Lock Days"},null,null,null,{"$f":"[4]Calc!AQ131","v":"7/1 30YR ARM"},null,{"$f":"[4]Calc!AS131","v":-0.125}]
[null,{"$f":"[4]Calc!AQ139","v":"Loans W/ 3YR PPP"},null,{"$f":"[4]Calc!AS139","v":101},null,null,{"$f":"[4]Calc!AU132","v":"B-"},{"$f":"[4]Calc!AV132","v":0},{"$f":"[4]Calc!AW132","v":-2.5},{"$f":"[4]Calc!AY131","v":"15 Day"},{"$f":"[4]Calc!AZ131","v":0},{"$f":"[4]Calc!BA131","v":0.15},null,{"$f":"[4]Calc!AQ132","v":"7/1 30YR IO ARM"},null,{"$f":"[4]Calc!AS132","v":-0.375},null,null,null,{"$f":"[4]Calc!AQ142","v":"Terms"}]
[null,{"$f":"[4]Calc!AU137","v":"Minimum Rates"},null,null,null,null,{"$f":"[4]Calc!AU133","v":"Select - DSCR (Min 1.15+)"},{"$f":"[4]Calc!AV133","v":0},{"$f":"[4]Calc!AW133","v":0.5},{"$f":"[4]Calc!AY132","v":"30 Day"},{"$f":"[4]Calc!AZ132","v":0},{"$f":"[4]Calc!BA132","v":0},null,{"$f":"[4]Calc!AQ133","v":"7/1 40YR IO ARM"},null,{"$f":"[4]Calc!AS133","v":-0.5},null,null,null,{"$f":"[4]Calc!AQ143","v":"Loan Term"},{"$f":"[4]Calc!AR143","v":"Caps"},{"$f":"[4]Calc!AS143","v":"Floor"},{"$f":"[4]Calc!AT143","v":"Index"}]
[null,{"$f":"[4]Calc!AU138","v":"Full Doc"},null,{"$f":"[4]Calc!AV138","v":4.4990000000000002E-2},null,null,{"$f":"[4]Calc!AU134","v":"DSCR - (Min 1.00+)"},{"$f":"[4]Calc!AV134","v":0},{"$f":"[4]Calc!AW134","v":0},{"$f":"[4]Calc!AY133","v":"45 Day"},{"$f":"[4]Calc!AZ133","v":0},{"$f":"[4]Calc!BA133","v":0},null,{"$f":"[4]Calc!AQ134","v":"15YR Fixed"},null,{"$f":"[4]Calc!AS134","v":0},null,null,null,{"$f":"[4]Calc!AQ144","v":"5/1 ARM"},{"$f":"[4]Calc!AR144","v":"5/2/5"},{"$f":"[4]Calc!AS144","v":"=Rate"},{"$f":"[4]Calc!AT144","v":"1YR Libor"}]
[null,{"$f":"[4]Calc!AU139","v":"Alt Doc"},null,{"$f":"[4]Calc!AV139","v":4.999E-2},null,null,{"$f":"[4]Calc!AU135","v":"No Ratio - (0.75-0.99)"},{"$f":"[4]Calc!AV135","v":0},{"$f":"[4]Calc!AW135","v":-1},{"$f":"[4]Calc!AY134","v":"60 Day"},{"$f":"[4]Calc!AZ134","v":0},{"$f":"[4]Calc!BA134","v":-0.125},null,{"$f":"[4]Calc!AQ135","v":"30YR Fixed"},null,{"$f":"[4]Calc!AS135","v":-0.5},null,null,null,{"$f":"[4]Calc!AQ145","v":"7/1 ARM"},{"$f":"[4]Calc!AR145","v":"5/2/5"},{"$f":"[4]Calc!AS145","v":"=Rate"},{"$f":"[4]Calc!AT145","v":"1YR Libor"}]
[null,{"$f":"[4]Calc!AU140","v":"DSCR"},null,{"$f":"[4]Calc!AV140","v":5.3749999999999999E-2},null,null,{"$f":"[4]Calc!AY127","v":"Extension Cost"}]
[null,null,null,null,null,null,{"$f":"[4]Calc!AY128","v":"2 Bps (0.020)"},null,{"$f":"[4]Calc!BA128","v":"Per Day"}]

{"sheet":"Feed","index":1,"n_rows":163,"n_cols":30,"rows_kept":163,"cut":false,"hidden":true,"merged":[[151,1,151,2],[144,1,144,2],[143,1,143,2],[140,1,140,2],[50,7,50,8],[69,1,69,4],[69,8,69,11],[110,1,110,4],[110,8,110,11],[141,1,141,2]]}
["FICO","LTV","Grades","Doc Type","Doc +","DTI","Loan Amount","Prepayment Penalties","Escrow Waiver","Purpose","Property Type","Occupancy","Term","Lock Period","Comp Type","Citizenships","ACH",null,null,null,null,null,"Message"]
["Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Choose a Selection","Yes",null,null,null,"State","Availability","No Penalty","12 Months","24 Months","36 Months","48 Months","60 Months",null,"Compensation Type"]
["780+","<=50","Select - Standard","Full Doc","None of the Above","Full Doc (>50 DTI)","$150,001-$1,500,000","No PPP/See State Section","Escrow Not Waived","Purchase","SFR","Primary","5/1 30YR ARM","15 Day","Borrower Paid","US Citizen","No",null,null,null,"Choose a Selection","Y"," ","Choose a Selection"," "," "," "," "," ","Borrower Paid"]
["760-779","50.01-60","A+","Alt Doc","12 Month Full / Alt Doc","Alt Doc (>43 DTI)","$1,500,001-$3,000,000","12 Months PPP",null,"Rate/Term Refi","1-2 Units","Second Home","5/1 30YR IO ARM","30 Day","Lender Paid","Permanent Resident",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","A","DSCR","24 Month Full Doc","No DTI Program (DSCR)",null,"24 Months PPP",null,"Debt Consolidation","3-4 Units","Non-Owner (N/A DSCR)","5/1 40YR IO ARM","45 Day",null,"Non Perm Resident",null,null,null,null,"Maryland","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," "]
["720-739","65.01-70","B",null,"Asset Utilization","None Of The Above",null,"36 Months PPP",null,"Cash-Out","Condo","Non-Owner (DSCR/No Ratio)","7/1 30YR ARM","60 Day",null,"ITIN",null,null,null,null,"Michigan","Y"," ","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed","PPP Not Allowed"," ","Channel"]
["700-719","70.01-75","B-",null,null,null,null,"48 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":"[6]!Input_Stamp_Channel","v":"W"}]
["680-699","75.01-80","Select - DSCR (Min 1.15+)",null,null,null,null,"60 Months PPP",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","80.01-85","DSCR - (Min 1.00+)",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","85.01-90","No Ratio - (0.75-0.99)",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"]
[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":0},null,"6 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF('NanQ ONE Program'!#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'!U35:U35=\"Borrower Paid\",0,1)","v":0},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"},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":0}]
[null,{"$f":"'NanQ ONE Program'!T23","v":"No PPP/See State Section"}]
[]
[null,0,2000000]
[null,2000001,3000000]
[null,3000001,10000000]
[]
[]
[]
[]
[]
[]
[]
[null,"Base Rate / Base Price",null,null,null,null,null,null,"Base Rate / Base Price"]
[null,"Coupon","Full Doc","Alt Doc","DSCR",null,"Total LLPA",null,"Coupon","Full Doc","Alt Doc","DSCR"]
[null,{"$f":"[4]Calc!AB99","v":4.4989999999999997},{"$f":"[4]Calc!AC99","v":97.75},{"$f":"[4]Calc!AD99","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE99","v":{"$error":"#N/A"}},null,{"$f":"'NanQ ONE Program'!U27","v":{"$error":"#N/A"}},1,{"$f":"B104","v":8.4990000000000006},{"$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!AB100","v":4.625},{"$f":"[4]Calc!AC100","v":98.25},{"$f":"[4]Calc!AD100","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE100","v":{"$error":"#N/A"}},null,null,2,{"$f":"B103","v":8.375},{"$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!AB101","v":4.75},{"$f":"[4]Calc!AC101","v":98.75},{"$f":"[4]Calc!AD101","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE101","v":{"$error":"#N/A"}},null,"Total Price",3,{"$f":"B102","v":8.25},{"$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!AB102","v":4.875},{"$f":"[4]Calc!AC102","v":99.25},{"$f":"[4]Calc!AD102","v":{"$error":"#N/A"}},{"$f":"[4]Calc!AE102","v":{"$error":"#N/A"}},null,100,4,{"$f":"B101","v":8.125},{"$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!AB103","v":4.9989999999999997},{"$f":"[4]Calc!AC103","v":99.625},{"$f":"[4]Calc!AD103","v":98.875},{"$f":"[4]Calc!AE103","v":{"$error":"#N/A"}},null,null,5,{"$f":"B100","v":7.9989999999999997},{"$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!AB104","v":5.125},{"$f":"[4]Calc!AC104","v":100},{"$f":"[4]Calc!AD104","v":99.25},{"$f":"[4]Calc!AE104","v":{"$error":"#N/A"}},null,null,6,{"$f":"B99","v":7.875},{"$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!AB105","v":5.25},{"$f":"[4]Calc!AC105","v":100.375},{"$f":"[4]Calc!AD105","v":99.625},{"$f":"[4]Calc!AE105","v":{"$error":"#N/A"}},null,null,7,{"$f":"B98","v":7.75},{"$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!AB106","v":5.375},{"$f":"[4]Calc!AC106","v":100.75},{"$f":"[4]Calc!AD106","v":100},{"$f":"[4]Calc!AE106","v":98.875},null,{"$f":"'NanQ ONE Program'!T13","v":0},8,{"$f":"B97","v":7.625},{"$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!AB107","v":5.4989999999999997},{"$f":"[4]Calc!AC107","v":101.125},{"$f":"[4]Calc!AD107","v":100.375},{"$f":"[4]Calc!AE107","v":99.25},null,null,9,{"$f":"B96","v":7.4989999999999997},{"$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!AB108","v":5.625},{"$f":"[4]Calc!AC108","v":101.5},{"$f":"[4]Calc!AD108","v":100.75},{"$f":"[4]Calc!AE108","v":99.625},null,null,10,{"$f":"B95","v":7.375},{"$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!AB109","v":5.75},{"$f":"[4]Calc!AC109","v":101.875},{"$f":"[4]Calc!AD109","v":101.125},{"$f":"[4]Calc!AE109","v":100},null,null,11,{"$f":"B94","v":7.25},{"$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!AB110","v":5.875},{"$f":"[4]Calc!AC110","v":102.25},{"$f":"[4]Calc!AD110","v":101.5},{"$f":"[4]Calc!AE110","v":100.375},null,null,12,{"$f":"B93","v":7.125},{"$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!AB111","v":5.9989999999999997},{"$f":"[4]Calc!AC111","v":102.625},{"$f":"[4]Calc!AD111","v":101.875},{"$f":"[4]Calc!AE111","v":100.75},null,null,13,{"$f":"B92","v":6.9989999999999997},{"$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!AB112","v":6.125},{"$f":"[4]Calc!AC112","v":103},{"$f":"[4]Calc!AD112","v":102.25},{"$f":"[4]Calc!AE112","v":101.125},null,null,14,{"$f":"B91","v":6.875},{"$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!AB113","v":6.25},{"$f":"[4]Calc!AC113","v":103.375},{"$f":"[4]Calc!AD113","v":102.625},{"$f":"[4]Calc!AE113","v":101.5},null,null,15,{"$f":"B90","v":6.75},{"$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!AB114","v":6.375},{"$f":"[4]Calc!AC114","v":103.75},{"$f":"[4]Calc!AD114","v":103},{"$f":"[4]Calc!AE114","v":101.875},null,null,16,{"$f":"B89","v":6.625},{"$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!AB115","v":6.4989999999999997},{"$f":"[4]Calc!AC115","v":104.125},{"$f":"[4]Calc!AD115","v":103.375},{"$f":"[4]Calc!AE115","v":102.25},null,null,17,{"$f":"B88","v":6.4989999999999997},{"$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!AB116","v":6.625},{"$f":"[4]Calc!AC116","v":104.375},{"$f":"[4]Calc!AD116","v":103.625},{"$f":"[4]Calc!AE116","v":102.5},null,null,18,{"$f":"B87","v":6.375},{"$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!AB117","v":6.75},{"$f":"[4]Calc!AC117","v":104.625},{"$f":"[4]Calc!AD117","v":103.875},{"$f":"[4]Calc!AE117","v":102.75},null,null,19,{"$f":"B86","v":6.25},{"$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!AB118","v":6.875},{"$f":"[4]Calc!AC118","v":104.875},{"$f":"[4]Calc!AD118","v":104.125},{"$f":"[4]Calc!AE118","v":103},null,null,20,{"$f":"B85","v":6.125},{"$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!AB119","v":6.9989999999999997},{"$f":"[4]Calc!AC119","v":105.125},{"$f":"[4]Calc!AD119","v":104.375},{"$f":"[4]Calc!AE119","v":103.25},null,null,21,{"$f":"B84","v":5.9989999999999997},{"$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!AB120","v":7.125},{"$f":"[4]Calc!AC120","v":105.375},{"$f":"[4]Calc!AD120","v":104.625},{"$f":"[4]Calc!AE120","v":103.5},null,null,22,{"$f":"B83","v":5.875},{"$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!AB121","v":7.25},{"$f":"[4]Calc!AC121","v":105.625},{"$f":"[4]Calc!AD121","v":104.875},{"$f":"[4]Calc!AE121","v":103.75},null,null,23,{"$f":"B82","v":5.75},{"$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!AB122","v":7.375},{"$f":"[4]Calc!AC122","v":105.875},{"$f":"[4]Calc!AD122","v":105.125},{"$f":"[4]Calc!AE122","v":104},null,null,24,{"$f":"B81","v":5.625},{"$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!AB123","v":7.4989999999999997},{"$f":"[4]Calc!AC123","v":106.125},{"$f":"[4]Calc!AD123","v":105.375},{"$f":"[4]Calc!AE123","v":104.25},null,null,25,{"$f":"B80","v":5.4989999999999997},{"$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!AB124","v":7.625},{"$f":"[4]Calc!AC124","v":106.375},{"$f":"[4]Calc!AD124","v":105.625},{"$f":"[4]Calc!AE124","v":104.5},null,null,26,{"$f":"B79","v":5.375},{"$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!AB125","v":7.75},{"$f":"[4]Calc!AC125","v":106.625},{"$f":"[4]Calc!AD125","v":105.875},{"$f":"[4]Calc!AE125","v":104.75},null,null,27,{"$f":"B78","v":5.25},{"$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!AB126","v":7.875},{"$f":"[4]Calc!AC126","v":106.875},{"$f":"[4]Calc!AD126","v":106.125},{"$f":"[4]Calc!AE126","v":105},null,null,28,{"$f":"B77","v":5.125},{"$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!AB127","v":7.9989999999999997},{"$f":"[4]Calc!AC127","v":107.125},{"$f":"[4]Calc!AD127","v":106.375},{"$f":"[4]Calc!AE127","v":105.25},null,null,29,{"$f":"B76","v":4.9989999999999997},{"$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!AB128","v":8.125},{"$f":"[4]Calc!AC128","v":107.375},{"$f":"[4]Calc!AD128","v":106.625},{"$f":"[4]Calc!AE128","v":105.5},null,null,30,{"$f":"B75","v":4.875},{"$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!AB129","v":8.25},{"$f":"[4]Calc!AC129","v":107.625},{"$f":"[4]Calc!AD129","v":106.875},{"$f":"[4]Calc!AE129","v":105.75},null,null,30,{"$f":"B74","v":4.75},{"$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!AB130","v":8.375},{"$f":"[4]Calc!AC130","v":107.875},{"$f":"[4]Calc!AD130","v":107.125},{"$f":"[4]Calc!AE130","v":106},null,null,30,{"$f":"B73","v":4.625},{"$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!AB131","v":8.4990000000000006},{"$f":"[4]Calc!AC131","v":108.125},{"$f":"[4]Calc!AD131","v":107.375},{"$f":"[4]Calc!AE131","v":106.25},null,null,30,{"$f":"B72","v":4.4989999999999997},{"$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":"B75","v":4.875},99.25,{"$error":"#N/A"},{"$error":"#N/A"},null,null,1,{"$f":"I76","v":7.9989999999999997},{"$f":"C138+$G$115-$G$117","v":{"$error":"#REF!"}},{"$f":"D138+$G$115-$G$117","v":{"$error":"#REF!"}},{"$f":"E138+$G$115-$G$117","v":{"$error":"#REF!"}}]
[null,4.9989999999999997,99.625,98.875,{"$error":"#N/A"},null,"Total LLPA",2,{"$f":"I77","v":7.875},{"$f":"C137+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D137+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E137+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.125,100,99.25,{"$error":"#N/A"},null,{"$f":"'NanQ ONE Program'!U27","v":{"$error":"#N/A"}},3,{"$f":"I78","v":7.75},{"$f":"C136+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D136+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E136+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.25,100.375,99.625,{"$error":"#N/A"},null,"LPC",4,{"$f":"I79","v":7.625},{"$f":"C135+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D135+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E135+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.375,100.75,100,98.875,null,null,5,{"$f":"I80","v":7.4989999999999997},{"$f":"C134+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D134+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E134+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.4989999999999997,101.125,100.375,99.25,null,null,6,{"$f":"I81","v":7.375},{"$f":"C133+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D133+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E133+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.625,101.5,100.75,99.625,null,"Total Price",7,{"$f":"I82","v":7.25},{"$f":"C132+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D132+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E132+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.75,101.875,101.125,100,null,null,8,{"$f":"I83","v":7.125},{"$f":"C131+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D131+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E131+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.875,102.25,101.5,100.375,null,null,9,{"$f":"I84","v":6.9989999999999997},{"$f":"C130+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D130+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E130+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,5.9989999999999997,102.625,101.875,100.75,null,{"$f":"'NanQ ONE Program'!T13","v":0},10,{"$f":"I85","v":6.875},{"$f":"C129+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D129+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E129+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.125,103,102.25,101.125,null,null,11,{"$f":"I86","v":6.75},{"$f":"C128+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D128+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E128+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.25,103.375,102.625,101.5,null,null,12,{"$f":"I87","v":6.625},{"$f":"C127+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D127+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E127+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.375,103.75,103,101.875,null,null,13,{"$f":"I88","v":6.4989999999999997},{"$f":"C126+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D126+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E126+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.4989999999999997,104.125,103.375,102.25,null,null,14,{"$f":"I89","v":6.375},{"$f":"C125+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D125+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E125+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.625,104.375,103.625,102.5,null,null,15,{"$f":"I90","v":6.25},{"$f":"C124+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D124+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E124+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.75,104.625,103.875,102.75,null,null,16,{"$f":"I91","v":6.125},{"$f":"C123+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D123+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E123+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.875,104.875,104.125,103,null,null,17,{"$f":"I92","v":5.9989999999999997},{"$f":"C122+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D122+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E122+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,6.9989999999999997,105.125,104.375,103.25,null,null,18,{"$f":"I93","v":5.875},{"$f":"C121+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D121+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E121+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.125,105.375,104.625,103.5,null,null,19,{"$f":"I94","v":5.75},{"$f":"C120+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D120+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E120+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.25,105.625,104.875,103.75,null,null,20,{"$f":"I95","v":5.625},{"$f":"C119+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D119+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E119+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.375,105.875,105.125,104,null,null,21,{"$f":"I96","v":5.4989999999999997},{"$f":"C118+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D118+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E118+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.4989999999999997,106.125,105.375,104.25,null,null,22,{"$f":"I97","v":5.375},{"$f":"C117+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D117+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E117+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.625,106.375,105.625,104.5,null,null,23,{"$f":"I98","v":5.25},{"$f":"C116+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D116+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E116+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.75,106.625,105.875,104.75,null,null,24,{"$f":"I99","v":5.125},{"$f":"C115+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D115+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E115+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,7.875,106.875,106.125,105,null,null,25,{"$f":"I100","v":4.9989999999999997},{"$f":"C114+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D114+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E114+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,26,{"$f":"I101","v":4.875},{"$f":"C113+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"D113+$G$115-$G$117","v":{"$error":"#N/A"}},{"$f":"E113+$G$115-$G$117","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(100,J113:J138,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,K113:K138,-1)","v":{"$error":"#N/A"}},{"$f":"MATCH(100,L113:L138,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J139,H113:I157,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K139,H113:I157,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L139,H113:L157,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,J140,0)","v":0},{"$f":"IF(G122=K112,K140,0)","v":0},{"$f":"IF(G122=L112,L140,0)","v":0},{"$f":"SUM(J141:L141)","v":0}]
[null,"Near Par Rate - BPC",null,null,{"$f":"IF(E141>'NanQ ONE Program'!U29,'NanQ ONE Program'!U29,Feed!E141)","v":0},null,null,null,null,{"$f":"VLOOKUP(J139,H113:J157,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K139,H113:K157,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(L139,H113:L157,5,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G122=J112,J142,0)","v":0},{"$f":"IF(G122=K112,K142,0)","v":0},{"$f":"IF(G122=L112,L142,0)","v":0},{"$f":"SUM(J143:L143)","v":0}]
[null,"Near Par Rate - LPC",null,{"$f":"Feed!M141","v":0},{"$f":"Feed!M143","v":0}]
[null,"Near Par Rate - LPC",null,null,{"$f":"IF(E144>'NanQ ONE Program'!U29,'NanQ ONE Program'!U29,Feed!E144)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Max Price"]
[null,"3YR PPP",101]
[null,"<680 FICO",100]
[null,">80% LTV",100]
[null,">1.5 MM",100]
[null,"All Other Scenarios",100]
[]
[null,"Formula #1",{"$f":"IF('NanQ ONE Program'!T11='NanQ ONE Program'!G18,C154,IF('NanQ ONE Program'!T11='NanQ ONE Program'!G17,C154,C157))","v":100}]
[null,"Formula #2",{"$f":"IF('NanQ ONE Program'!T10='NanQ ONE Program'!O10,C155,C157)","v":100}]
[null,"Formula #3",{"$f":"IF('NanQ ONE Program'!T17='NanQ ONE Program'!G40,C156,C157)","v":100}]
[null,"Formula #4",{"$f":"IF('NanQ ONE Program'!U23=0.375,Feed!C153,Feed!C157)","v":100}]
[null,null,{"$f":"MAX(C159:C162)","v":100}]

{"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":[]}