{"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":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,9,1,13],[22,10,22,13],[23,7,23,9],[23,10,23,11],[23,12,23,13],[24,10,24,11],[24,12,24,13],[27,10,27,13],[29,10,29,11],[29,12,29,13],[14,15,14,16],[33,15,33,17],[31,18,31,22],[32,15,32,17],[32,18,32,21],[7,19,7,22],[8,19,8,22],[33,18,33,21],[23,15,23,17],[24,15,24,17],[33,10,33,11],[33,12,33,13],[36,15,44,22],[9,23,9,25],[18,15,18,16],[8,23,8,25],[7,23,7,25],[11,15,11,16],[19,15,19,16],[20,15,20,16],[22,15,22,16],[13,15,13,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[0,5,0,8],[1,5,1,8],[2,5,2,8],[4,8,4,9],[9,4,9,5],[5,15,6,22],[8,15,8,16],[3,10,3,13],[9,15,9,16],[10,15,10,16],[2,11,2,13],[7,15,7,16],[12,15,12,16],[23,4,23,5],[24,4,24,5],[25,15,25,17],[26,15,26,17],[27,15,27,17],[25,19,25,22],[31,15,31,17],[21,15,21,16],[30,15,30,17],[30,18,30,22],[28,19,28,22],[27,19,27,22],[32,10,32,11],[32,12,32,13],[31,4,31,5],[28,15,28,17],[26,19,26,22],[29,15,29,17],[29,19,29,22],[32,8,32,9],[10,0,13,0],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[20,4,20,5],[10,4,10,5],[11,4,11,5],[19,4,19,6],[4,10,4,13],[8,1,8,2],[8,4,8,13],[30,12,30,13],[5,1,6,13],[25,10,25,11],[26,10,26,11],[25,4,25,5],[26,4,26,5],[27,4,27,5],[31,10,31,11],[31,12,31,13],[28,4,28,5],[29,4,29,5],[30,4,30,5],[22,4,22,5],[21,4,21,5],[19,10,19,13],[20,10,20,12],[21,10,21,12],[25,12,25,13],[26,12,26,13],[28,10,28,11],[28,12,28,13],[30,10,30,11],[19,7,19,9],[20,7,20,8],[21,7,21,8],[22,7,22,8],[35,15,35,22]]}
[null,null,null,null,null,{"$f":"[5]!Input_Stamp_Header03","v":"LoanStream Mortgage"},null,null,null,{"$f":"[4]Calc!DE84","v":"Commercial Broker Ratesheet"}]
[null,null,null,null,null,{"$f":"[5]!Input_Stamp_Header04","v":"19000 MacArthur Blvd, Suite 200"}]
[null,null,null,null,null,{"$f":"[5]!Input_Stamp_Header05","v":"Irvine, CA 92612"},null,null,null,null,null,{"$f":"[4]Calc!$DH$86","v":"45 Day Lock Period"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"[4]Calc!DG87","v":"Borrower Paid Compensation"}]
[null,null,null,null,null,null,null,null,{"$f":"[4]Calc!$DE$88","v":"Effective Date:"},null,{"$f":"[4]Calc!DG88","v":"2020-12-22"}]
[null,"NanQ \"ONE\" Program",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[4]Calc!$DD$91","v":"PriceOne Calculator"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs",null,{"$f":"J1","v":"Commercial Broker Ratesheet"},null,null,null,"DSCR/No Ratio Column Includes"]
[null,{"$f":"[4]Calc!AB93","v":"Base Rate / Base Price"},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":"K5","v":"2020-12-22"},null,null,null,"DSCR"]
[null,{"$f":"[4]Calc!AN94","v":"Coupon"},{"$f":"[4]Calc!AO94","v":"DSCR/No Ratio"},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,"No Ratio"]
[null,{"$f":"[4]Calc!AN103","v":4.9989999999999997},{"$f":"[4]Calc!AO103","v":98.75},null,{"$f":"[4]Calc!DB100","v":"780+"},null,{"$f":"[4]Calc!DD100","v":0.75},{"$f":"[4]Calc!DE100","v":0.625},{"$f":"[4]Calc!DF100","v":0.5},{"$f":"[4]Calc!DG100","v":0.375},{"$f":"[4]Calc!DH100","v":0.125},{"$f":"[4]Calc!DI100","v":-0.375},{"$f":"[4]Calc!DJ100","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK100","v":{"$error":"#N/A"}},null,"FICO Range",null,null,{"$f":"INDEX(G11:N18,MATCH(R11,E11:E18,0),MATCH(R10,G10:N10))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AN104","v":5.125},{"$f":"[4]Calc!AO104","v":99.125},null,{"$f":"[4]Calc!DB101","v":"760-779"},null,{"$f":"[4]Calc!DD101","v":0.5},{"$f":"[4]Calc!DE101","v":0.375},{"$f":"[4]Calc!DF101","v":0.125},{"$f":"[4]Calc!DG101","v":-0.125},{"$f":"[4]Calc!DH101","v":-0.5},{"$f":"[4]Calc!DI101","v":-1},{"$f":"[4]Calc!DJ101","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK101","v":{"$error":"#N/A"}},null,"Grade",null,null,{"$f":"INDEX(J21:J28,MATCH(R12,H21:H28,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AN105","v":5.25},{"$f":"[4]Calc!AO105","v":99.5},null,{"$f":"[4]Calc!DB102","v":"740-759"},null,{"$f":"[4]Calc!DD102","v":0.125},{"$f":"[4]Calc!DE102","v":0},{"$f":"[4]Calc!DF102","v":-0.25},{"$f":"[4]Calc!DG102","v":-0.625},{"$f":"[4]Calc!DH102","v":-1.125},{"$f":"[4]Calc!DI102","v":-1.75},{"$f":"[4]Calc!DJ102","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK102","v":{"$error":"#N/A"}},null,"Doc Type",null,"DSCR/No Ratio"]
[null,{"$f":"[4]Calc!AN106","v":5.375},{"$f":"[4]Calc!AO106","v":99.875},null,{"$f":"[4]Calc!DB103","v":"720-739"},null,{"$f":"[4]Calc!DD103","v":-0.125},{"$f":"[4]Calc!DE103","v":-0.375},{"$f":"[4]Calc!DF103","v":-0.75},{"$f":"[4]Calc!DG103","v":-1.25},{"$f":"[4]Calc!DH103","v":-1.875},{"$f":"[4]Calc!DI103","v":-2.75},{"$f":"[4]Calc!DJ103","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK103","v":{"$error":"#N/A"}},null,"Loan Balance",null,null,{"$f":"IF(R14=\"$5,000,001-$7,500,000\",\"Call Lock Desk\",IF(R14=\"$7,500,001-$10,000,000\",\"Call Lock Desk\",INDEX(G$22:G$40,MATCH(R14,E$22:E$40,0))))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AN107","v":5.4989999999999997},{"$f":"[4]Calc!AO107","v":100.25},null,{"$f":"[4]Calc!DB104","v":"700-719"},null,{"$f":"[4]Calc!DD104","v":-0.5},{"$f":"[4]Calc!DE104","v":-0.75},{"$f":"[4]Calc!DF104","v":-1.25},{"$f":"[4]Calc!DG104","v":-1.875},{"$f":"[4]Calc!DH104","v":-2.625},{"$f":"[4]Calc!DI104","v":-3.75},{"$f":"[4]Calc!DJ104","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK104","v":{"$error":"#N/A"}},null,"Purpose",null,null,{"$f":"IF(OR(R15=\"Purchase\",R15=\"Rate/Term Refi\"),0,INDEX(G$22:G$32,MATCH(R15,E$22:E$32,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AN108","v":5.625},{"$f":"[4]Calc!AO108","v":100.625},null,{"$f":"[4]Calc!DB105","v":"680-699"},null,{"$f":"[4]Calc!DD105","v":-0.75},{"$f":"[4]Calc!DE105","v":-1.25},{"$f":"[4]Calc!DF105","v":-1.875},{"$f":"[4]Calc!DG105","v":-2.625},{"$f":"[4]Calc!DH105","v":-3.5},{"$f":"[4]Calc!DI105","v":-4.75},{"$f":"[4]Calc!DJ105","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK105","v":{"$error":"#N/A"}},null,"Occupancy",null,"Non-Owner (DSCR/No Ratio)",{"$f":"IF(OR(R16=\"Primary\"),0,IF(OR(R16=\"Non-Owner (DSCR/No Ratio)\"),0,INDEX(G$22:G$32,MATCH(R16,E$22:E$32,0))))","v":0}]
[null,{"$f":"[4]Calc!AN109","v":5.75},{"$f":"[4]Calc!AO109","v":101},null,{"$f":"[4]Calc!DB106","v":"660-679"},null,{"$f":"[4]Calc!DD106","v":-1.125},{"$f":"[4]Calc!DE106","v":-1.625},{"$f":"[4]Calc!DF106","v":-2.375},{"$f":"[4]Calc!DG106","v":-3.5},{"$f":"[4]Calc!DH106","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DI106","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DJ106","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK106","v":{"$error":"#N/A"}},null,"Property Type",null,"SFR",{"$f":"IF(OR(R17=\"SFR\",R17=\"1-2 Units\",R17=\"PUD\",R17=\"Condo\"),0,INDEX(G$22:G$32,MATCH(R17,E$22:E$32,0)))","v":0}]
[null,{"$f":"[4]Calc!AN110","v":5.875},{"$f":"[4]Calc!AO110","v":101.375},null,{"$f":"[4]Calc!DB107","v":"640-659"},null,{"$f":"[4]Calc!DD107","v":-1.375},{"$f":"[4]Calc!DE107","v":-2},{"$f":"[4]Calc!DF107","v":-3},{"$f":"[4]Calc!DG107","v":-4.5},{"$f":"[4]Calc!DH107","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DI107","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DJ107","v":{"$error":"#N/A"}},{"$f":"[4]Calc!DK107","v":{"$error":"#N/A"}},null,"Loan Term",null,"5/1 30YR ARM",{"$f":"INDEX(J25:J32,MATCH(R18,H25:H32,0))","v":0}]
[null,{"$f":"[4]Calc!AN111","v":5.9989999999999997},{"$f":"[4]Calc!AO111","v":101.75},null,null,null,null,null,null,null,null,null,null,null,null,"Escrow",null,"Escrow Not Waived",{"$f":"IF(R19=\"Escrow Not Waived\",0,INDEX(G$22:G$32,MATCH(R19,E$22:E$32,0)))","v":0}]
[null,{"$f":"[4]Calc!AN112","v":6.125},{"$f":"[4]Calc!AO112","v":102.125},null,"Loan Level Price Adjustments",null,null,"Grades",null,null,"Margins",null,null,null,null,"Prepayment Penalty",null,"36 Months PPP",{"$f":"IF(OR(R16=\"Primary\",R16=\"Second Home\"),0,IF(R20=\"No PPP/See State Section\",0,INDEX(G$22:G$32,MATCH(R20,E$22:E$32,0))))","v":0.375}]
[null,{"$f":"[4]Calc!AN113","v":6.25},{"$f":"[4]Calc!AO113","v":102.5},null,null,null,"LLPA","Select - DSCR (Min 1.15+)",0,0.5,"Occupancy",null,null,"Margin",null,"State",null,"All Other States",0]
[null,{"$f":"[4]Calc!AN114","v":6.375},{"$f":"[4]Calc!AO114","v":102.875},null,"*ACH Special*",null,0.25,"DSCR - (Min 1.00+)",0,0,"Investment Home",null,null,5,null,"ACH Special",null,"No",{"$f":"IF(R22=\"Yes\",0.25,0)","v":0}]
[null,{"$f":"[4]Calc!AN115","v":6.4989999999999997},{"$f":"[4]Calc!AO115","v":103.25},null,"Cash-Out",null,-1,"No Ratio - (0.75-0.99)",0,-1,"Lock Days",null,null,null,null,"Lock Term",null,"45 Day",{"$f":"IF(R23=\"15 Day\",M24,IF(R23=\"30 Day\",M25,IF(R23=\"45 Day\",M26,IF(R23=\"60 Day\",M27,\"NA\"))))","v":0}]
[null,{"$f":"[4]Calc!AN116","v":6.625},{"$f":"[4]Calc!AO116","v":103.5},null,"3-4 Units",null,-0.75,"Loan Term",null,null,"15 Day",0,0.15,null,null,"  Total LLPA",null,null,{"$f":"SUM(S11:S23)","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AN117","v":6.75},{"$f":"[4]Calc!AO117","v":103.75},null,"12 Months PPP",null,0,"5/1 30YR ARM",null,0,"30 Day",0,0,null,null,"  Gross Rate Sheet Price (Prior to LLPAs)",null,null,{"$f":"IFERROR(INDEX(B11:C34,MATCH(R9,B11:B34,0),MATCH(R13,C10:C10,0)+1),\"Minimum Rate\")","v":"Minimum Rate"}]
[null,{"$f":"[4]Calc!AN118","v":6.875},{"$f":"[4]Calc!AO118","v":104},null,"24 Months PPP",null,0.25,"5/1 30YR IO ARM",null,-0.25,"45 Day",0,0,null,null,"  Max YSP",null,null,{"$f":"Feed!B167","v":102},{"$f":"IFERROR(CONCATENATE(P26,\" \",\"is\",\" \", S26),\"Select a Valid Prepay\")","v":"  Max YSP is 102"},null,null,null,null,null,null,"Minimum rate rule",{"$f":"IF(R9>4.74,0,1)","v":1}]
[null,{"$f":"[4]Calc!AN119","v":6.9989999999999997},{"$f":"[4]Calc!AO119","v":104.25},null,"36 Months PPP",null,0.375,"5/1 40YR IO ARM",null,-0.375,"60 Day",0,-0.125,null,null,"  Net Price: Rate Sheet - LLPA (Prior to Max YSP)",null,null,{"$f":"IFERROR(S25+S24,\"Minimum Rate\")","v":"Minimum Rate"},{"$f":"IF(S34=\"Borrower Paid\",\"BPC Selected\",IF(AND(T28=\"LPC Selected\",S29<0.01),\"Input a Valid LPC\",\"LPC Inputted\"))","v":"BPC Selected"},null,null,null,null,null,null,"Loan Amount rule",{"$f":"IF(S14<5,0,1)","v":{"$error":"#N/A"}}]
[null,{"$f":"[4]Calc!AN120","v":7.125},{"$f":"[4]Calc!AO120","v":104.5},null,"48 Months PPP",null,0.375,"7/1 30YR ARM",null,-0.125,"Max Price",null,null,null,null,"  Net Rate Sheet Price - As Borrower Paid (BPC)",null,null,{"$f":"IFERROR(IF(S27>S26,S26,S27),\"Priced LPC\")","v":102},{"$f":"IF(S34=\"Lender Paid\",\"LPC Selected\",IF(AND(S34=\"Borrower Paid\",W34=\"\",S34=\"Choose a Selection\"),\"BPC is Blank\",\"BPC Inputted\"))","v":"BPC Inputted"},null,null,null,null,null,null,"Impounds rule",{"$f":"IF(NOT(R19=\"Escrow Waived\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AN121","v":7.25},{"$f":"[4]Calc!AO121","v":104.75},null,"60 Months PPP",null,0.375,"7/1 30YR IO ARM",null,-0.375,"Loans W/ 0YR PPP",null,100,null,null,"Lender Paid Comp Plan Amount (LPC)",null,null,null,{"$f":"IFERROR(CONCATENATE(Feed!B148,\" \",Feed!D148,\"%\" &\" @ \"&Feed!E149),\"Complete the Scenario on the Calculator\")","v":"Complete the Scenario on the Calculator"},null,null,null,null,null,null,"Texas rule",{"$f":"IF(NOT(R21=\"Texas\"),0,1)","v":0}]
[null,{"$f":"[4]Calc!AN122","v":7.375},{"$f":"[4]Calc!AO122","v":105},null,"NW Condo",null,-1.25,"7/1 40YR IO ARM",null,-0.5,"Loans W/ 1YR PPP",null,101,null,null,"  Net Rate Sheet Price - As Lender Paid (LPC)",null,null,{"$f":"S28-S29","v":102},null,null,null,null,null,null,null,"15 Day Rule",{"$f":"IF(R23=\"15 Day\",0,1)","v":1}]
[null,{"$f":"[4]Calc!AN123","v":7.4989999999999997},{"$f":"[4]Calc!AO123","v":105.25},null,"$150,001-$1,500,000",null,0,"15YR Fixed",null,0,"Loans W/ 2YR PPP",null,101.5,null,null,"Loan Number",null,null,"Borrower Name",null,null,null,null,null,null,null,"Cashout/PPP Rule",{"$f":"IF(AND(R15=\"Cash-out\",R20<>\"No Prepay\",R16<>\"primary\"),0,1)","v":1}]
[null,{"$f":"[4]Calc!AN124","v":7.625},{"$f":"[4]Calc!AO124","v":105.5},null,"$1,500,001-$3,000,000",null,-0.125,"30YR Fixed",null,-0.5,"Loans W/ 3YR PPP",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,"DSCR",{"$f":"IF(R16=\"Non-Owner (N/A DSCR)\",0,IF(R16=\"Non-Owner (DSCR/No Ratio)\",0,1))","v":0},"You have Selected DSCR No Income Loan"]
[null,{"$f":"[4]Calc!AN125","v":7.75},{"$f":"[4]Calc!AO125","v":105.75},null,"Loan Term","Caps","Floor","Index","Extension Cost",null,"Loans W/ 4YR PPP",null,102.5,null,null,"Property Address",null,null,"Compensation Type - Make A Selection",null,null,null,"Comp?",null,null,null,null,null,"You have Selected Income Qualifing Inv Loan"]
[null,{"$f":"[4]Calc!AN126","v":7.875},{"$f":"[4]Calc!AO126","v":106},null,"5/1 ARM & 7/1 ARM","5/2/5","=Rate","1YR Libor","2 bps","Per Day","Loans W/ 5YR PPP",null,103,null,null,null,null,null,"Borrower Paid",null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[4]Calc!$DC$125","v":"Prepayment Penalty (Non-TRID / Business Purpose Loans Only)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[4]Calc!$DC$126","v":"*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":167,"n_cols":29,"rows_kept":167,"cut":false,"hidden":true,"merged":[[158,0,158,1],[69,1,69,2],[69,8,69,9],[110,1,110,2],[110,8,110,9],[151,1,151,2],[150,1,150,2],[147,1,147,2],[50,7,50,8],[148,1,148,2]]}
["LTV","FICO","Grades","Doc Type","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","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 - DSCR (Min 1.15+)","DSCR/No Ratio","$150,001-$1,500,000","Purchase","Non-Owner (DSCR/No Ratio)","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","DSCR - (Min 1.00+)",null,"$1,500,001-$3,000,000","Rate/Term Refi",null,"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","No Ratio - (0.75-0.99)",null,null,"Cash-Out",null,"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",null,null,null,null,null,"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",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",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"," "]
[null,"660-679",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"]
[null,"640-659",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,"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,"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,"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'!R16=\"Primary\",'NanQ ONE Program'!R16=\"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'!S34:S34=\"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'!R16=\"Non-Owner (N/A DSCR)\",'NanQ ONE Program'!R16=\"Non-Owner (DSCR/No Ratio)\"),1,0)","v":1},null,"36 Months PPP",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,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'!R14","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'!R16","v":"Non-Owner (DSCR/No Ratio)"}]
[null,{"$f":"'NanQ ONE Program'!R20","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","DSCR/No Ratio",null,null,null,"Total LLPA",null,"Coupon","DSCR/No Ratio"]
[null,{"$f":"'NanQ ONE Program'!B11","v":4.9989999999999997},{"$f":"'NanQ ONE Program'!C11","v":98.75},null,null,null,{"$f":"'NanQ ONE Program'!S24","v":{"$error":"#N/A"}},1,{"$f":"B95","v":7.875},{"$f":"C95+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B12","v":5.125},{"$f":"'NanQ ONE Program'!C12","v":99.125},null,null,null,null,2,{"$f":"B94","v":7.75},{"$f":"C94+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B13","v":5.25},{"$f":"'NanQ ONE Program'!C13","v":99.5},null,null,null,"PAR Price",3,{"$f":"B93","v":7.625},{"$f":"C93+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B14","v":5.375},{"$f":"'NanQ ONE Program'!C14","v":99.875},null,null,null,100,4,{"$f":"B92","v":7.4989999999999997},{"$f":"C92+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B15","v":5.4989999999999997},{"$f":"'NanQ ONE Program'!C15","v":100.25},null,null,null,null,5,{"$f":"B91","v":7.375},{"$f":"C91+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B16","v":5.625},{"$f":"'NanQ ONE Program'!C16","v":100.625},null,null,null,null,6,{"$f":"B90","v":7.25},{"$f":"C90+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B17","v":5.75},{"$f":"'NanQ ONE Program'!C17","v":101},null,null,null,null,7,{"$f":"B89","v":7.125},{"$f":"C89+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B18","v":5.875},{"$f":"'NanQ ONE Program'!C18","v":101.375},null,null,null,{"$f":"'NanQ ONE Program'!R13","v":"DSCR/No Ratio"},8,{"$f":"B88","v":6.9989999999999997},{"$f":"C88+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B19","v":5.9989999999999997},{"$f":"'NanQ ONE Program'!C19","v":101.75},null,null,null,null,9,{"$f":"B87","v":6.875},{"$f":"C87+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B20","v":6.125},{"$f":"'NanQ ONE Program'!C20","v":102.125},null,null,null,null,10,{"$f":"B86","v":6.75},{"$f":"C86+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B21","v":6.25},{"$f":"'NanQ ONE Program'!C21","v":102.5},null,null,null,null,11,{"$f":"B85","v":6.625},{"$f":"C85+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B22","v":6.375},{"$f":"'NanQ ONE Program'!C22","v":102.875},null,null,null,null,12,{"$f":"B84","v":6.4989999999999997},{"$f":"C84+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B23","v":6.4989999999999997},{"$f":"'NanQ ONE Program'!C23","v":103.25},null,null,null,null,13,{"$f":"B83","v":6.375},{"$f":"C83+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B24","v":6.625},{"$f":"'NanQ ONE Program'!C24","v":103.5},null,null,null,null,14,{"$f":"B82","v":6.25},{"$f":"C82+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B25","v":6.75},{"$f":"'NanQ ONE Program'!C25","v":103.75},null,null,null,null,15,{"$f":"B81","v":6.125},{"$f":"C81+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B26","v":6.875},{"$f":"'NanQ ONE Program'!C26","v":104},null,null,null,null,16,{"$f":"B80","v":5.9989999999999997},{"$f":"C80+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B27","v":6.9989999999999997},{"$f":"'NanQ ONE Program'!C27","v":104.25},null,null,null,null,17,{"$f":"B79","v":5.875},{"$f":"C79+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B28","v":7.125},{"$f":"'NanQ ONE Program'!C28","v":104.5},null,null,null,null,18,{"$f":"B78","v":5.75},{"$f":"C78+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B29","v":7.25},{"$f":"'NanQ ONE Program'!C29","v":104.75},null,null,null,null,19,{"$f":"B77","v":5.625},{"$f":"C77+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B30","v":7.375},{"$f":"'NanQ ONE Program'!C30","v":105},null,null,null,null,20,{"$f":"B76","v":5.4989999999999997},{"$f":"C76+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B31","v":7.4989999999999997},{"$f":"'NanQ ONE Program'!C31","v":105.25},null,null,null,null,21,{"$f":"B75","v":5.375},{"$f":"C75+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B32","v":7.625},{"$f":"'NanQ ONE Program'!C32","v":105.5},null,null,null,null,22,{"$f":"B74","v":5.25},{"$f":"C74+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B33","v":7.75},{"$f":"'NanQ ONE Program'!C33","v":105.75},null,null,null,null,23,{"$f":"B73","v":5.125},{"$f":"C73+$G$72","v":{"$error":"#N/A"}}]
[null,{"$f":"'NanQ ONE Program'!B34","v":7.875},{"$f":"'NanQ ONE Program'!C34","v":106},null,null,null,null,24,{"$f":"B72","v":4.9989999999999997},{"$f":"C72+$G$72","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(G75,J72:J95,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J96,H72:J104,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G79=J71,J97,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(J96,H72:J104,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G79=J71,J99,0)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BPC Rate",{"$f":"SUM(J97)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BPC Price",{"$f":"SUM(J100:J100)","v":{"$error":"#N/A"}}]
[]
[null,"Base Rate / Base Price",null,null,null,null,null,null,"Base Rate / Base Price"]
[null,"Coupon","DSCR/No Ratio",null,null,null,null,null,"Coupon","DSCR/No Ratio"]
[null,{"$f":"B72","v":4.9989999999999997},{"$f":"C72","v":98.75},null,null,null,null,1,{"$f":"I72","v":7.875},{"$f":"J72-$G$117","v":{"$error":"#N/A"}}]
[null,{"$f":"B73","v":5.125},{"$f":"C73","v":99.125},null,null,null,"Total LLPA",2,{"$f":"I73","v":7.75},{"$f":"J73-$G$117","v":{"$error":"#N/A"}}]
[null,{"$f":"B74","v":5.25},{"$f":"C74","v":99.5},null,null,null,{"$f":"'NanQ ONE Program'!S24","v":{"$error":"#N/A"}},3,{"$f":"I74","v":7.625},{"$error":"#N/A"}]
[null,{"$f":"B75","v":5.375},{"$f":"C75","v":99.875},null,null,null,"LPC",4,{"$f":"I75","v":7.4989999999999997},{"$error":"#N/A"}]
[null,{"$f":"B76","v":5.4989999999999997},{"$f":"C76","v":100.25},null,null,null,{"$f":"'NanQ ONE Program'!S29","v":0},5,{"$f":"I76","v":7.375},{"$error":"#N/A"}]
[null,{"$f":"B77","v":5.625},{"$f":"C77","v":100.625},null,null,null,null,6,{"$f":"I77","v":7.25},{"$error":"#N/A"}]
[null,{"$f":"B78","v":5.75},{"$f":"C78","v":101},null,null,null,"Max Price",7,{"$f":"I78","v":7.125},{"$error":"#N/A"}]
[null,{"$f":"B79","v":5.875},{"$f":"C79","v":101.375},null,null,null,{"$f":"B167","v":102},8,{"$f":"I79","v":6.9989999999999997},{"$error":"#N/A"}]
[null,{"$f":"B80","v":5.9989999999999997},{"$f":"C80","v":101.75},null,null,null,null,9,{"$f":"I80","v":6.875},{"$error":"#N/A"}]
[null,{"$f":"B81","v":6.125},{"$f":"C81","v":102.125},null,null,null,{"$f":"'NanQ ONE Program'!R13","v":"DSCR/No Ratio"},10,{"$f":"I81","v":6.75},{"$error":"#N/A"}]
[null,{"$f":"B82","v":6.25},{"$f":"C82","v":102.5},null,null,null,null,11,{"$f":"I82","v":6.625},{"$error":"#N/A"}]
[null,{"$f":"B83","v":6.375},{"$f":"C83","v":102.875},null,null,null,null,12,{"$f":"I83","v":6.4989999999999997},{"$error":"#N/A"}]
[null,{"$f":"B84","v":6.4989999999999997},{"$f":"C84","v":103.25},null,null,null,null,13,{"$f":"I84","v":6.375},{"$error":"#N/A"}]
[null,{"$f":"B85","v":6.625},{"$f":"C85","v":103.5},null,null,null,null,14,{"$f":"I85","v":6.25},{"$error":"#N/A"}]
[null,{"$f":"B86","v":6.75},{"$f":"C86","v":103.75},null,null,null,null,15,{"$f":"I86","v":6.125},{"$error":"#N/A"}]
[null,{"$f":"B87","v":6.875},{"$f":"C87","v":104},null,null,null,null,16,{"$f":"I87","v":5.9989999999999997},{"$error":"#N/A"}]
[null,{"$f":"B88","v":6.9989999999999997},{"$f":"C88","v":104.25},null,null,null,null,17,{"$f":"I88","v":5.875},{"$error":"#N/A"}]
[null,{"$f":"B89","v":7.125},{"$f":"C89","v":104.5},null,null,null,null,18,{"$f":"I89","v":5.75},{"$error":"#N/A"}]
[null,{"$f":"B90","v":7.25},{"$f":"C90","v":104.75},null,null,null,null,19,{"$f":"I90","v":5.625},{"$error":"#N/A"}]
[null,{"$f":"B91","v":7.375},{"$f":"C91","v":105},null,null,null,null,20,{"$f":"I91","v":5.4989999999999997},{"$error":"#N/A"}]
[null,{"$f":"B92","v":7.4989999999999997},{"$f":"C92","v":105.25},null,null,null,null,21,{"$f":"I92","v":5.375},{"$error":"#N/A"}]
[null,{"$f":"B93","v":7.625},{"$f":"C93","v":105.5},null,null,null,null,22,{"$f":"I93","v":5.25},{"$error":"#N/A"}]
[null,{"$f":"B94","v":7.75},{"$f":"C94","v":105.75},null,null,null,null,23,{"$f":"I94","v":5.125},{"$error":"#N/A"}]
[null,{"$f":"B95","v":7.875},{"$f":"C95","v":106},null,null,null,null,24,{"$f":"I95","v":4.9989999999999997},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"MATCH(G120,J113:J136,-1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Par Rates",{"$f":"VLOOKUP(J137,H113:J145,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G122=J112,J138,0)","v":{"$error":"#N/A"}},{"$f":"J139","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(J137,H113:J145,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G122=J112,J140,0)","v":{"$error":"#N/A"}},{"$f":"MIN(J141,G120)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[null,"Near Par Rate - BPC",null,{"$f":"Feed!M107","v":{"$error":"#N/A"}},{"$f":"M109","v":{"$error":"#N/A"}}]
[null,"Near Par Rate - BPC",null,null,{"$f":"IF(E148>'NanQ ONE Program'!S26,'NanQ ONE Program'!S26,Feed!E148)","v":{"$error":"#N/A"}}]
[]
[null,"Near Max Rate",null,{"$f":"Feed!K139","v":{"$error":"#N/A"}},100]
[null,"Near Max Rate",null,null,{"$f":"IF(E151>'NanQ ONE Program'!S26,'NanQ ONE Program'!S26,Feed!E151)","v":100}]
[]
[]
[]
[]
[]
[]
["Max Price"]
[{"$f":"'NanQ ONE Program'!R20","v":"36 Months PPP"}]
[{"$f":"K3","v":"No PPP/See State Section"},100]
["12 Months PPP",101]
["24 Months PPP",101.5]
["36 Months PPP",102]
["48 Months PPP",102.5]
["60 Months PPP",103]
["Max Price",{"$f":"IF(A160=A166,B166,IF(A160=A165,B165,IF(A160=A164,B164,IF(A160=A163,B163,IF(A160=A162,B162,IF(A160=A161,B161,\"NA\"))))))","v":102}]

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