{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Form Guidance","Form 4662","VData","HData","Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":116,"comments":2,"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":"Form Guidance","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Form 4662","index":1,"n_rows":54,"n_cols":55,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,30,4,31],[22,23,22,24],[35,38,35,39],[37,44,37,45],[38,44,38,45],[36,23,36,25],[35,23,35,25],[34,23,34,25],[33,23,33,25],[22,37,22,43],[23,37,23,39],[29,40,29,42],[30,40,30,42],[7,7,7,26],[8,7,8,14],[12,11,12,12],[11,13,11,14],[27,48,27,52],[36,38,36,53],[4,42,4,46],[2,7,2,26],[2,34,2,53],[11,34,11,35],[19,39,19,41],[12,34,12,35],[13,45,13,47],[9,38,9,44],[3,14,3,19],[21,10,21,11],[13,21,13,22],[22,3,22,12],[13,11,13,12],[19,10,19,11],[20,10,20,11],[12,23,12,24],[12,13,12,14],[12,21,12,22],[12,19,12,20],[12,15,12,16],[12,17,12,18],[13,19,13,20],[25,11,25,26],[29,16,29,20],[30,16,30,20],[27,10,27,12],[26,9,26,26],[4,12,4,17],[7,38,7,53],[8,43,8,49],[18,23,18,24],[13,15,13,16],[9,20,9,21],[13,34,13,37],[9,49,9,53],[8,20,8,26],[11,21,11,22],[11,19,11,20],[11,23,11,24],[12,45,12,47],[11,45,11,47],[11,15,11,16],[11,17,11,18],[20,49,20,51],[21,23,21,24],[20,23,20,24],[15,45,15,47],[14,45,14,47],[19,49,19,51],[19,23,19,24],[11,11,11,12],[9,7,9,9],[18,10,18,11],[15,14,15,18],[28,46,28,50],[28,34,28,38],[26,34,26,38],[27,34,27,38],[26,48,26,52],[23,48,23,50],[22,48,22,52],[20,39,20,41],[16,14,16,18],[13,17,13,18],[13,23,13,24],[13,13,13,14],[43,2,47,53],[49,2,49,16],[49,18,49,22],[31,40,31,42],[49,28,49,42],[39,23,39,25],[37,23,37,25],[38,23,38,25],[49,44,49,48]]}
[]
[null,"Fannie Mae (FM) Underwriter's Data Form (4662)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 6.4 | Last Revised 03/2024"]
[null,null,"Deal Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lender Name:"]
[null,null,"Fannie Mae Commitment Number:"]
[null,null,"Funding / MBS Pool Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MBS as Bond Collateral?",null,null,null,null,null,null,null,null,null,null,null,"Bond Collateral Type:"]
[]
[]
[null,null,null,null,null,null,"Property Name:","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Borrower Loan Purpose:"]
[null,null,null,null,null,null,"Property Type:","",null,null,null,null,null,null,null,"Building Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"App. Loan Amt./ Orig. Alloc. Facility Amt.:"]
[null,null,null,null,null,null,"Year Built:",null,null,null,null,null,null,null,null,null,null,null,null,"Number of Buildings:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mezz. Loan Acquisition UPB:",null,null,null,null,null,null,null,null,null,null,"Mo. Pmt:"]
[]
[null,null,null,null,"Phase Number:",null,null,null,null,null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,null,null,null,null,null,null,null,null,"Pricing Tier:",null,null,null,null,null,null,null,null,null,null,"Treasury Rate:"]
[null,null,null,null,"Year Completed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier Drop Elig.?",null,null,null,null,null,null,null,null,null,null,"Gross Spread:"]
[null,null,null,null,"Constructed Units:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exp. Date:",null,null,null,null,null,null,null,null,null,null,"Cap Cost Factor:",null,null,null,"(SARMs Only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW Floor Rate:",null,null,null,"(Fixed Rate Only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Residential Units:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW Rate:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rentable Residential Area:",null,null,null,null,null,"sq. ft."]
[]
[null,null,null,null,null,null,null,null,null,"Age Restricted?",null,null,null,null,null,null,null,null,null,null,null,null,"Taxes Escrowed?"]
[null,null,null,null,null,null,null,null,null,"Terrorism Ins. Coverage?",null,null,null,null,null,null,null,null,null,null,null,null,"Insurance Escrowed?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Op. Statement (Fiscal Year):",null,null,null,null,null,null,null,null,null,"UW Phys. Occ.:",null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"Seismic Zone 3 or 4?",null,null,null,null,null,null,null,null,null,null,null,null,"Other Special Escrows?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW Cap Rate:",null,null,null,"%",null,null,null,null,null,"UW Econ. Occ.:",null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"High Seismic Risk?",null,null,null,null,null,null,null,null,null,null,null,null,"All Utilities Included in Rent?"]
[null,null,null,"USGS PGA Calculation Tutorial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal Non-conforming Use?",null,null,null,null,null,null,null,null,null,null,null,null,null,"UW Property Value:",null,null,null,null,null,null,null,"as of date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW LTV:",null,null,null,"%",null,null,null,null,null,null,"Mezz. CLTV:",null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Include Hard Addtl Debt)",null,null,null,null,null,null,null,null,null,"(Only with Mezz. Financing)"]
[null,null,"Affordable Housing Type:"]
[null,null,"Describe if \"Other\":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW EGI:",null,null,null,null,null,null,null,null,null,null,null,null,null,"UW Tot. Op. Exp.:"]
[null,null,"HAP Remaining Term:",null,null,null,null,null,null,null,null,null,null,"mos.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW NCF:",null,null,null,null,null,null,null,null,null,null,null,null,null,"UW Cap. Ex. (Repl. Res.):"]
[]
[null,null,"Initial LIHTC Compliance Pd. End Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. UW DSCR Hurdle:"]
[null,null,"LIHTC Extended Use Period End Date ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UW DSCR per Guide Rqmts.:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined Actual DSCR:",null,null,null,"(Incl. Mezz. Financing)"]
[null,null,"For All Properties with Income or Rent Restrictions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Max. Total = 100%)"]
[null,null,null,null,null,"% of Units Above 120% AMI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,"% of Units at or Below 120% AMI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,"% of Units at or Below 100% AMI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,"Tax Relief?"]
[null,null,null,null,null,"% of Units at or Below 80% AMI (\"Low Income\"):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,"Tax Relief Program Type:"]
[null,null,null,null,null,"% of Units at or Below 60% AMI:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax Relief Prog. for Duration of Loan?"]
[null,null,null,null,null,"% of Units at or Below 50% AMI (\"Very Low Income\"):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conv. Loan Affordability Assoc. with Prog.?"]
[null,null,"Total Percentage of Units with Income or Rent Restrictions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[]
[]
[null,null,"Lender Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Underwriter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,"Chief Underwriter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,"Underwriter's Data Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 4662",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2024 Fannie Mae"]
[null,"Fannie Mae"]

{"sheet":"VData","index":2,"n_rows":90,"n_cols":19,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Counter","Section","Label","Field Name","Refers To","R1C1 Reference","Data Type","Display Format","Data Validation","Data Validation Type (xlDVType)","Data Validation Description","Validation Allowable Values","Value","Source Worksheet","Source Column","Source Row","Source Reference","Source Formula (Or Constant)","Source To Use"]
[1,"Deal","Deal Name","DL_NM",{"$f":"GetA1","v":"'Form 4662'!$H$3"},{"$f":"GetR1C1","v":"R3C8"},"General","General",false,0,"",null,{"$f":"DL_NM","v":0},null,null,null,{"$f":"IF(OR($N2=\"\",$O2=\"\",$P2=\"\"),\"\",\"=\"&ADDRESS($P2,COLUMN(INDIRECT($O2&\":\"&$O2)),1,TRUE,$N2))","v":""}]
[2,"Deal","Fannie Mae Commitment Number","CMT_NBR","'Form 4662'!$O$4",{"$f":"GetR1C1","v":"R4C15"},"Number","0",true,7,"Data is validated using an arbitrary formula.","Whole Number with Character Length Equal To 6",{"$f":"CMT_NBR","v":0},null,null,null,{"$f":"IF(OR($N3=\"\",$O3=\"\",$P3=\"\"),\"\",\"=\"&ADDRESS($P3,COLUMN(INDIRECT($O3&\":\"&$O3)),1,TRUE,$N3))","v":""}]
[4,"Deal","Funding / Pool Number (MBS Only)","PL_NBR","'Form 4662'!$M$5",{"$f":"GetR1C1","v":"R5C13"},"General","General",true,6,"Length of text.","Character Length Equal To 6",{"$f":"PL_NBR","v":0},null,null,null,""]
[12,"Lender","Lender Name","LNDR_NM","'Form 4662'!$AI$3",{"$f":"GetR1C1","v":"R3C35"},"General","General",false,0,"",null,{"$f":"LNDR_NM","v":0},null,null,null,""]
[24,"Property","Property Name","PROP_NM","'Form 4662'!$H$8",{"$f":"GetR1C1","v":"R8C8"},"General","General",false,0,"",null,{"$f":"PROP_NM","v":""},null,null,null,""]
[31,"Property","Property Type","PROP_TYP","'Form 4662'!$H$9",{"$f":"GetR1C1","v":"R9C8"},"General","General",true,3,"Value must be present in a specified list.","Multifamily, Cooperative, Dedicated Student, Manufactured Housing, Seniors, Military",{"$f":"PROP_TYP","v":""},null,null,null,""]
[32,"Property","Building Type","BLDG_TYP","'Form 4662'!$U$9",{"$f":"GetR1C1","v":"R9C21"},"General","General",true,3,"Value must be present in a specified list.","Garden, High-Rise, Mid-Rise, Single Family Rental, Townhouse, Other",{"$f":"BLDG_TYP","v":0},null,null,null,""]
[33,"Property","Number of Buildings","BLDG_CNT",{"$f":"GetA1","v":"'Form 4662'!$U$10"},{"$f":"GetR1C1","v":"R10C21"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"BLDG_CNT","v":0},null,null,null,""]
[34,"Property","Rentable Residential Area","RES_AREA","'Form 4662'!$O$17",{"$f":"GetR1C1","v":"R17C15"},"Number","0",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"RES_AREA","v":0},null,null,null,""]
[35,"Property","Residential Units","RES_UNTS","'Form 4662'!$O$16",{"$f":"GetR1C1","v":"R16C15"},"Number","0",true,1,"Whole numeric values.","Whole Number Greater Than 0 And Equal To The Sum Of The Phase Constructed Units (If Populated)",{"$f":"RES_UNTS","v":0},null,null,null,""]
[36,"Property","All Utilities Included in Rent?","UTIL_INCL","'Form 4662'!$X$22",{"$f":"GetR1C1","v":"R22C24"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"UTIL_INCL","v":0},null,null,null,""]
[37,"Property","Year Built","YR_BLT","'Form 4662'!$H$10",{"$f":"GetR1C1","v":"R10C8"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"YR_BLT","v":0},null,null,null,""]
[38,"Property","Phase 1 Completion Year","PHS1_YR","'Form 4662'!$L$13",{"$f":"GetR1C1","v":"R13C12"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS1_YR","v":0},null,null,null,""]
[39,"Property","Phase 1 Constructed Units","PHS1_UNTS","'Form 4662'!$L$14",{"$f":"GetR1C1","v":"R14C12"},"Number","0",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS1_UNTS","v":0},null,null,null,""]
[40,"Property","Phase 2 Completion Year","PHS2_YR","'Form 4662'!$N$13",{"$f":"GetR1C1","v":"R13C14"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS2_YR","v":0},null,null,null,""]
[41,"Property","Phase 2 Constructed Units","PHS2_UNTS","'Form 4662'!$N$14",{"$f":"GetR1C1","v":"R14C14"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS2_UNTS","v":0},null,null,null,""]
[42,"Property","Phase 3 Completion Year","PHS3_YR","'Form 4662'!$P$13",{"$f":"GetR1C1","v":"R13C16"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS3_YR","v":0},null,null,null,""]
[43,"Property","Phase 3 Constructed Units","PHS3_UNTS","'Form 4662'!$P$14",{"$f":"GetR1C1","v":"R14C16"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS3_UNTS","v":0},null,null,null,""]
[44,"Property","Phase 4 Completion Year","PHS4_YR","'Form 4662'!$R$13",{"$f":"GetR1C1","v":"R13C18"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS4_YR","v":0},null,null,null,""]
[45,"Property","Phase 4 Constructed Units","PHS4_UNTS","'Form 4662'!$R$14",{"$f":"GetR1C1","v":"R14C18"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS4_UNTS","v":0},null,null,null,""]
[46,"Property","Phase 5 Completion Year","PHS5_YR","'Form 4662'!$T$13",{"$f":"GetR1C1","v":"R13C20"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS5_YR","v":0},null,null,null,""]
[47,"Property","Phase 5 Constructed Units","PHS5_UNTS","'Form 4662'!$T$14",{"$f":"GetR1C1","v":"R14C20"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS5_UNTS","v":0},null,null,null,""]
[48,"Property","Phase 6 Completion Year","PHS6_YR","'Form 4662'!$V$13",{"$f":"GetR1C1","v":"R13C22"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS6_YR","v":0},null,null,null,""]
[49,"Property","Phase 6 Constructed Units","PHS6_UNTS","'Form 4662'!$V$14",{"$f":"GetR1C1","v":"R14C22"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS6_UNTS","v":0},null,null,null,""]
[50,"Property","Phase 7 Completion Year","PHS7_YR","'Form 4662'!$X$13",{"$f":"GetR1C1","v":"R13C24"},"Number","General",true,1,"Whole numeric values.","Whole Number Between 1800 And Current Year + 5",{"$f":"PHS7_YR","v":0},null,null,null,""]
[51,"Property","Phase 7 Constructed Units","PHS7_UNTS","'Form 4662'!$X$14",{"$f":"GetR1C1","v":"R14C24"},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"PHS7_UNTS","v":0},null,null,null,""]
[56,"Loan","Borrower Loan Purpose","LN_PRPS","'Form 4662'!$AM$8",{"$f":"GetR1C1","v":"R8C39"},"General","General",true,3,"Value must be present in a specified list.","Acquisition, Refinance, Forward Conversion, ARM to Fixed Conversion, Rehabilitation, Equity, Construction Take Out, New Construction",{"$f":"LN_PRPS","v":0},null,null,null,""]
[57,"Loan","Application Loan Amount/ Original Allocable Facility Amount","APP_LN_AMT","'Form 4662'!$AR$9",{"$f":"GetR1C1","v":"R9C44"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"APP_LN_AMT","v":0},null,null,null,""]
[64,"Loan","Pricing Tier","TIER","'Form 4662'!$AI$12",{"$f":"GetR1C1","v":"R12C35"},"Number","General",true,3,"Value must be present in a specified list.","2, 3, 4",{"$f":"TIER","v":0},null,null,null,""]
[65,"Loan","Tier Drop Eligible?","TIER_DRP",{"$f":"GetA1","v":"'Form 4662'!$AI$13"},{"$f":"GetR1C1","v":"R13C35"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"TIER_DRP","v":0},null,null,null,""]
[68,"Loan","Rate Lock Term","LCK_TRM",{"$error":"#REF!"},{"$f":"GetR1C1","v":{"$error":"#REF!"}},"Number","General",true,1,"Whole numeric values.","Whole Number Greater Than 0",null,null,null,null,{"$f":"IF(OR($N32=\"\",$O32=\"\",$P32=\"\"),\"\",\"=\"&ADDRESS($P32,COLUMN(INDIRECT($O32&\":\"&$O32)),1,TRUE,$N32))","v":""}]
[69,"Loan","Lock Expiration Date","LCK_EXP_DT","'Form 4662'!$AI$14",{"$f":"GetR1C1","v":"R14C35"},"Date","m/d/yyyy",false,0,"",null,{"$f":"LCK_EXP_DT","v":"00:00:00"},null,null,null,""]
[70,"Loan","Treasury Rate","TRSY_RT","'Form 4662'!$AT$12",{"$f":"GetR1C1","v":"R12C46"},"Number","0.000",true,2,"Numeric values.","Decimal Between 0 And 25",{"$f":"TRSY_RT","v":0},null,null,null,""]
[71,"Loan","Gross Spread","GRS_SPRD","'Form 4662'!$AT$13",{"$f":"GetR1C1","v":"R13C46"},"Number","0.000",true,2,"Numeric values.","Decimal Between 0 And 25",{"$f":"GRS_SPRD","v":0},null,null,null,""]
[75,"Loan","UW Floor Rate (If Applicable: Fixed Rate Loans Only)","UW_FLR_RT","'Form 4662'!$AT$15",{"$f":"GetR1C1","v":"R15C46"},"Number","0.000",true,2,"Numeric values.","Decimal Between 0 And 25",{"$f":"UW_FLR_RT","v":0},null,null,null,""]
[76,"Loan","UW Rate","UW_RT","'Form 4662'!$AT$16",{"$f":"GetR1C1","v":"R16C46"},"Number","0.000",false,0,"",null,{"$f":"UW_RT","v":0},null,null,null,""]
[79,"Underwriting","UW NCF","UW_NCF","'Form 4662'!$AI$28",{"$f":"GetR1C1","v":"R28C35"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"UW_NCF","v":0},null,null,null,""]
[80,"Underwriting","Co-Op Equiv. NCF","COOP_NCF",{"$error":"#REF!"},{"$f":"GetR1C1","v":{"$error":"#REF!"}},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than Or Equal To 0",null,null,null,null,""]
[82,"Underwriting","UW EGI","UW_EGI","'Form 4662'!$AI$27",{"$f":"GetR1C1","v":"R27C35"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"UW_EGI","v":0},null,null,null,""]
[84,"Underwriting","UW Total Operating Expense","UW_TOE","'Form 4662'!$AW$27",{"$f":"GetR1C1","v":"R27C49"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"UW_TOE","v":0},null,null,null,""]
[88,"Underwriting","UW Physical Occupancy","UW_PHYS_OCC","'Form 4662'!$AX$20",{"$f":"GetR1C1","v":"R20C50"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"UW_PHYS_OCC","v":0},null,null,null,""]
[89,"Underwriting","UW Economic Occupancy","UW_ECON_OCC","'Form 4662'!$AX$21",{"$f":"GetR1C1","v":"R21C50"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"UW_ECON_OCC","v":0},null,null,null,""]
[90,"Underwriting","Minimum UW DSCR Hurdle","MIN_HRDL_DSCR","'Form 4662'!$AO$30",{"$f":"GetR1C1","v":"R30C41"},"Number","0.00",true,2,"Numeric values.","Decimal Between 0 And 99.99",{"$f":"MIN_HRDL_DSCR","v":0},null,null,null,""]
[91,"Underwriting","Actual DSCR","ACTL_DSCR",{"$error":"#REF!"},{"$f":"GetR1C1","v":{"$error":"#REF!"}},"Number","0.00",true,2,"Numeric values.","Decimal Greater Than 0 And Less Than 100",null,null,null,null,""]
[92,"Underwriting","DSCR at Maximum Payment","MAX_PMT_DSCR",{"$error":"#REF!"},{"$f":"GetR1C1","v":{"$error":"#REF!"}},"Number","0.00",true,2,"Numeric values.","Decimal Greater Than 0 And Less Than 100",null,null,null,null,""]
[93,"Underwriting","UW DSCR per Guide Requirements","UW_DSCR","'Form 4662'!$AO$31",{"$f":"GetR1C1","v":"R31C41"},"Number","0.00",true,2,"Numeric values.","Decimal Greater Than 0 And Less Than 100",{"$f":"UW_DSCR","v":0},null,null,null,""]
[95,"Underwriting","Combined Actual DSCR (Including Mezzanine Financing)","MEZZ_DSCR","'Form 4662'!$AO$32",{"$f":"GetR1C1","v":"R32C41"},"Number","0.00",true,2,"Numeric values.","Decimal Between 0 And 99.99",{"$f":"MEZZ_DSCR","v":0},null,null,null,""]
[96,"Underwriting","UW Cap Rate","UW_CAP_RT","'Form 4662'!$AN$21",{"$f":"GetR1C1","v":"R21C40"},"Number","0.000",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"UW_CAP_RT","v":0},null,null,null,""]
[101,"Underwriting","UW Property Value","UW_PROP_VAL",{"$f":"GetA1","v":"'Form 4662'!$AL$23"},{"$f":"GetR1C1","v":"R23C38"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"UW_PROP_VAL","v":0},null,null,null,""]
[103,"Underwriting","UW LTV","UW_LTV","'Form 4662'!$AL$24",{"$f":"GetR1C1","v":"R24C38"},"Number","0.0",true,2,"Numeric values.","Decimal Greater Than 0 And Less Than Or Equal To 100",{"$f":"UW_LTV","v":0},null,null,null,""]
[126,"Affordable","Units with Income or Rent Restrictions","MAH_UNTS","'Form 4662'!$X$40",{"$f":"GetR1C1","v":"R40C24"},"Number","0.00",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_UNTS","v":0},null,null,null,"","=IF(AND(MAH_UNDR_80=\"\",MAH_UNDR_60=\"\",MAH_UNDR_50=\"\"),\"\",SUM(MAH_UNDR_80,MAH_UNDR_60,MAH_UNDR_50))","Formula"]
[127,"Affordable","Affordable Housing Type","MAH_TYP","'Form 4662'!$L$26",{"$f":"GetR1C1","v":"R26C12"},"General","General",true,3,"Value must be present in a specified list.","LIHTC, Proj Based HAP (incl. Sec. 8), Both LIHTC & Proj Based HAP, Other, Not MAH",{"$f":"MAH_TYP","v":0},null,null,null,""]
[128,"Affordable","Other Affordable Housing Type","OTR_MAH_TYP","'Form 4662'!$J$27",{"$f":"GetR1C1","v":"R27C10"},"General","General",false,0,"",null,{"$f":"OTR_MAH_TYP","v":0},null,null,null,""]
[129,"Affordable","At or Below 80% AMI (Low to Moderate Inc - HAP/Sec. 8)","MAH_UNDR_80",{"$f":"GetA1","v":"'Form 4662'!$X$37"},{"$f":"GetR1C1","v":"R37C24"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_UNDR_80","v":0},null,null,null,""]
[130,"Affordable","At or Below 60% AMI:","MAH_UNDR_60","'Form 4662'!$X$38",{"$f":"GetR1C1","v":"R38C24"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_UNDR_60","v":0},null,null,null,{"$f":"IF(OR($N56=\"\",$O56=\"\",$P56=\"\"),\"\",\"=\"&ADDRESS($P56,COLUMN(INDIRECT($O56&\":\"&$O56)),1,TRUE,$N56))","v":""}]
[131,"Affordable","At or Below 50% AMI (Very Low Income - HAP/Sec. 8)","MAH_UNDR_50","'Form 4662'!$X$39",{"$f":"GetR1C1","v":"R39C24"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_UNDR_50","v":0},null,null,null,""]
[132,"Reserves","Immediate Repair Total","RPR_TOT",{"$error":"#REF!"},{"$f":"GetR1C1","v":{"$error":"#REF!"}},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than Or Equal To 0",null,null,null,null,""]
[140,"Property","Seismic Zone 3 or 4?","SZ_ZN","'Form 4662'!$K$21",{"$f":"GetR1C1","v":"R21C11"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"SZ_ZN","v":0},null,null,null,""]
[141,"Property","Terrorism Insurance Coverage?","TRSM_INS","'Form 4662'!$K$20",{"$f":"GetR1C1","v":"R20C11"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"TRSM_INS","v":0},null,null,null,""]
[142,"Property","Taxes Escrowed?","TX_ESCRW","'Form 4662'!$X$19",{"$f":"GetR1C1","v":"R19C24"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"TX_ESCRW","v":0},null,null,null,""]
[143,"Property","Insurance Escrowed?","INS_ESCRW","'Form 4662'!$X$20",{"$f":"GetR1C1","v":"R20C24"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"INS_ESCRW","v":0},null,null,null,""]
[144,"Property","Other Special Escrows?","OTR_ESCRW","'Form 4662'!$X$21",{"$f":"GetR1C1","v":"R21C24"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"OTR_ESCRW","v":0},null,null,null,""]
[161,"Comments","Lender Comments","LNDR_CMTS",{"$f":"GetA1","v":"'Form 4662'!$C$44"},{"$f":"GetR1C1","v":"R44C3"},"General","General",false,0,"",null,{"$f":"LNDR_CMTS","v":0},null,null,null,""]
[162,"Signature","Underwriter Signature","UW_SIGN","'Form 4662'!$C$50",{"$f":"GetR1C1","v":"R50C3"},"General","General",false,0,"",null,{"$f":"UW_SIGN","v":0},null,null,null,""]
[163,"Signature","Underwriter Signature Date","UW_SIGN_DT","'Form 4662'!$S$50",{"$f":"GetR1C1","v":"R50C19"},"Date","m/d/yyyy",true,4,"Date values.","Date <= Current Date",{"$f":"UW_SIGN_DT","v":"00:00:00"},null,null,null,""]
[164,"Signature","Chief Underwriter Signature","CUW_SIGN",{"$f":"GetA1","v":"'Form 4662'!$AC$50"},{"$f":"GetR1C1","v":"R50C29"},"General","General",false,0,"",null,{"$f":"CUW_SIGN","v":0},null,null,null,""]
[165,"Signature","Chief Underwriter Signature Date","CUW_SIGN_DT",{"$f":"GetA1","v":"'Form 4662'!$AS$50"},{"$f":"GetR1C1","v":"R50C45"},"Date","m/d/yyyy",true,4,"Date values.","Date <= Current Date",{"$f":"CUW_SIGN_DT","v":"00:00:00"},null,null,null,""]
[166,"Affordable","HAP Remaining Term (months):","HAP_REM_TRM","'Form 4662'!$K$28",{"$f":"GetR1C1","v":"R28C11"},"Number","0",true,1,"Whole numeric values.","Whole Number Greater Than 0",{"$f":"HAP_REM_TRM","v":0},null,null,null,""]
[167,"Property","Age Restricted?","AGE_RESTR","'Form 4662'!$K$19",{"$f":"GetR1C1","v":"R19C11"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"AGE_RESTR","v":0},null,null,null,""]
[168,"Underwriting","Mezzanine Combined LTV:","UW_CLTV","'Form 4662'!$AW$24",{"$f":"GetR1C1","v":"R24C49"},"Number","0.0",true,2,"Numeric values.","Decimal Greater Than 0 And Less Than Or Equal To 100",{"$f":"UW_CLTV","v":0},null,null,null,""]
[169,"Underwriting","Operating Statement (Fiscal Year):","OP_STMT_FY","'Form 4662'!$AN$20",{"$f":"GetR1C1","v":"R20C40"},"Number","0",true,1,"Whole numeric values.","Whole Number Between Current Year - 1 And Current Year + 1",{"$f":"OP_STMT_FY","v":0},null,null,null,""]
[172,"Property","High Seismic Risk?  (“Yes”, if 10% or greater probability of the Peak Ground Acceleration exceeding 0.15g)","SZ_RSK","'Form 4662'!$K$22",{"$f":"GetR1C1","v":"R22C11"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"SZ_RSK","v":0},null,null,null,""]
[173,"Underwriting","UW Property Value as of Date","UW_PROP_VAL_DT","'Form 4662'!$AW$23",{"$f":"GetR1C1","v":"R23C49"},"Date","m/d/yyyy",true,4,"Date values.","Date <= Current Date",{"$f":"UW_PROP_VAL_DT","v":"00:00:00"},null,null,null,""]
[174,"Loan","Mezzanine Loan Acquisition UPB","MEZZ_LN_ACQ_UPB","'Form 4662'!$AM$10",{"$f":"GetR1C1","v":"R10C39"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than Or Equal To 0",{"$f":"MEZZ_LN_ACQ_UPB","v":0},null,null,null,""]
[175,"Loan","Mezzanine Monthly Payment","MEZZ_LN_MO_PMT","'Form 4662'!$AX$10",{"$f":"GetR1C1","v":"R10C50"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than Or Equal To 0",{"$f":"MEZZ_LN_MO_PMT","v":0},null,null,null,""]
[180,"Loan","Cap Cost Factor (If Applicable: Structured ARM's Only)","CAP_COST_FCTR","'Form 4662'!$AT$14",{"$f":"GetR1C1","v":"R14C46"},"Number","0.000",true,2,"Numeric values.","Decimal Between 0 And 25",{"$f":"CAP_COST_FCTR","v":0},null,null,null,""]
[182,"Affordable","Above 120% AMI","MAH_ABVE_120",{"$f":"GetA1","v":"'Form 4662'!$X$34"},{"$f":"GetR1C1","v":"R34C24"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_ABVE_120","v":0}]
[183,"Affordable","At or Below 120% AMI:","MAH_UNDR_120","'Form 4662'!$X$35",{"$f":"GetR1C1","v":"R35C24"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_UNDR_120","v":0}]
[184,"Affordable","At or Below 100% AMI:","MAH_UNDR_100","'Form 4662'!$X$36",{"$f":"GetR1C1","v":"R36C24"},"Number","0.0",true,2,"Numeric values.","Decimal Between 0 And 100",{"$f":"MAH_UNDR_100","v":0}]
[185,"Affordable","Initial LIHTC Compliance Period End Date","INIT_LIHTC_COMP","'Form 4662'!$Q$30",{"$f":"GetR1C1","v":"R30C17"},"Date","m/d/yyyy",true,4,"Date values.",null,{"$f":"INIT_LIHTC_COMP","v":"00:00:00"}]
[186,"Affordable","LIHTC Extended Use Period End Date","LIHTC_EXT_USE","'Form 4662'!$Q$31",{"$f":"GetR1C1","v":"R31C17"},"Date","m/d/yyyy",true,4,"Date values.",null,{"$f":"LIHTC_EXT_USE","v":"00:00:00"}]
[187,"Deal","MBS as Bond Collateral?","MBS_BOND_COLT_IND","'Form 4662'!$AE$5",{"$f":"GetR1C1","v":"R5C31"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"MBS_BOND_COLT_IND","v":0}]
[188,"Deal","Bond Collateral Type","MBS_BOND_COLT_TYP","'Form 4662'!$AQ$5",{"$f":"GetR1C1","v":"R5C43"},"General","General",true,3,"Value must be present in a specified list.","MTEB, MBS Exchange",{"$f":"MBS_BOND_COLT_TYP","v":0}]
[189,"Property","Legal Non-conforming Use?","LGL_NC_USE_IND","'Form 4662'!$X$23",{"$f":"GetR1C1","v":"R23C24"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"LGL_NC_USE_IND","v":0}]
[190,"Underwriting","UW Capital Expenditures (Replacement Reserves)","UW_TOT_CAP_EX_RPLM_RSRV_AMT","'Form 4662'!$AW$28",{"$f":"GetR1C1","v":"R28C49"},"Currency","_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)",true,2,"Numeric values.","Decimal Greater Than 0",{"$f":"UW_TOT_CAP_EX_RPLM_RSRV_AMT","v":0}]
[191,"Tax Relief","Tax Relief?","TX_RLF_IND","'Form 4662'!$AM$36",{"$f":"GetR1C1","v":"R36C39"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"TX_RLF_IND","v":0}]
[192,"Tax Relief","Tax Relief Program Type","TX_RLF_PGM_TYP","'Form 4662'!$AM$37",{"$f":"GetR1C1","v":"R37C39"},"General","General",true,3,"Value must be present in a specified list.","Payment in Lieu of Taxes (PILOT) Full Amount, Payment in Lieu of Taxes (PILOT) Partial Amount, Tax Exemption or Tax Abatement Full Amount, Tax Exemption or Tax Abatement Partial Amount, Tax Increment Financing (TIF) Full Amount, Tax Increment Financing (TIF) Partial Amount",{"$f":"TX_RLF_PGM_TYP","v":0}]
[193,"Tax Relief","Tax Relief Program for Duration of Loan?","TX_RLF_PGM_LN_DURN_IND","'Form 4662'!$AS$38",{"$f":"GetR1C1","v":"R38C45"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"TX_RLF_PGM_LN_DURN_IND","v":0}]
[194,"Tax Relief","Conventional Loan Affordability Association with Program?","TX_RLF_PGM_CONV_LN_AFRD_ASSC_IND","'Form 4662'!$AS$39",{"$f":"GetR1C1","v":"R39C45"},"True/False","General",true,3,"Value must be present in a specified list.","Yes,No",{"$f":"TX_RLF_PGM_CONV_LN_AFRD_ASSC_IND","v":0}]

{"sheet":"HData","index":3,"n_rows":2,"n_cols":89,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["DL_NM","CMT_NBR","PL_NBR","LNDR_NM","PROP_NM","PROP_TYP","BLDG_TYP","BLDG_CNT","RES_AREA","RES_UNTS","UTIL_INCL","YR_BLT","PHS1_YR","PHS1_UNTS","PHS2_YR","PHS2_UNTS","PHS3_YR","PHS3_UNTS","PHS4_YR","PHS4_UNTS","PHS5_YR","PHS5_UNTS","PHS6_YR","PHS6_UNTS","PHS7_YR","PHS7_UNTS","LN_PRPS","APP_LN_AMT","TIER","TIER_DRP","LCK_TRM","LCK_EXP_DT","TRSY_RT","GRS_SPRD","UW_FLR_RT","UW_RT","UW_NCF","COOP_NCF","UW_EGI","UW_TOE","UW_PHYS_OCC","UW_ECON_OCC","MIN_HRDL_DSCR","ACTL_DSCR","MAX_PMT_DSCR","UW_DSCR","MEZZ_DSCR","UW_CAP_RT","UW_PROP_VAL","UW_LTV","MAH_UNTS","MAH_TYP","OTR_MAH_TYP","MAH_UNDR_80","MAH_UNDR_60","MAH_UNDR_50","RPR_TOT","SZ_ZN","TRSM_INS","TX_ESCRW","INS_ESCRW","OTR_ESCRW","LNDR_CMTS","UW_SIGN","UW_SIGN_DT","CUW_SIGN","CUW_SIGN_DT","HAP_REM_TRM","AGE_RESTR","UW_CLTV","OP_STMT_FY","SZ_RSK","UW_PROP_VAL_DT","MEZZ_LN_ACQ_UPB","MEZZ_LN_MO_PMT","CAP_COST_FCTR","MAH_ABVE_120","MAH_UNDR_120","MAH_UNDR_100","INIT_LIHTC_COMP","LIHTC_EXT_USE","MBS_BOND_COLT_IND","MBS_BOND_COLT_TYP","LGL_NC_USE_IND","UW_TOT_CAP_EX_RPLM_RSRV_AMT","TX_RLF_IND","TX_RLF_PGM_TYP","TX_RLF_PGM_LN_DURN_IND","TX_RLF_PGM_CONV_LN_AFRD_ASSC_IND"]
[{"$f":"DL_NM","v":0},{"$f":"CMT_NBR","v":0},{"$f":"PL_NBR","v":0},{"$f":"LNDR_NM","v":0},{"$f":"PROP_NM","v":""},{"$f":"PROP_TYP","v":""},{"$f":"BLDG_TYP","v":0},{"$f":"BLDG_CNT","v":0},{"$f":"RES_AREA","v":0},{"$f":"RES_UNTS","v":0},{"$f":"UTIL_INCL","v":0},{"$f":"YR_BLT","v":0},{"$f":"PHS1_YR","v":0},{"$f":"PHS1_UNTS","v":0},{"$f":"PHS2_YR","v":0},{"$f":"PHS2_UNTS","v":0},{"$f":"PHS3_YR","v":0},{"$f":"PHS3_UNTS","v":0},{"$f":"PHS4_YR","v":0},{"$f":"PHS4_UNTS","v":0},{"$f":"PHS5_YR","v":0},{"$f":"PHS5_UNTS","v":0},{"$f":"PHS6_YR","v":0},{"$f":"PHS6_UNTS","v":0},{"$f":"PHS7_YR","v":0},{"$f":"PHS7_UNTS","v":0},{"$f":"LN_PRPS","v":0},{"$f":"APP_LN_AMT","v":0},{"$f":"TIER","v":0},{"$f":"TIER_DRP","v":0},null,{"$f":"LCK_EXP_DT","v":"00:00:00"},{"$f":"TRSY_RT","v":0},{"$f":"GRS_SPRD","v":0},{"$f":"UW_FLR_RT","v":0},{"$f":"UW_RT","v":0},{"$f":"UW_NCF","v":0},null,{"$f":"UW_EGI","v":0},{"$f":"UW_TOE","v":0},{"$f":"UW_PHYS_OCC","v":0},{"$f":"UW_ECON_OCC","v":0},{"$f":"MIN_HRDL_DSCR","v":0},null,null,{"$f":"UW_DSCR","v":0},{"$f":"MEZZ_DSCR","v":0},{"$f":"UW_CAP_RT","v":0},{"$f":"UW_PROP_VAL","v":0},{"$f":"UW_LTV","v":0},{"$f":"MAH_UNTS","v":0},{"$f":"MAH_TYP","v":0},{"$f":"OTR_MAH_TYP","v":0},{"$f":"MAH_UNDR_80","v":0},{"$f":"MAH_UNDR_60","v":0},{"$f":"MAH_UNDR_50","v":0},null,{"$f":"SZ_ZN","v":0},{"$f":"TRSM_INS","v":0},{"$f":"TX_ESCRW","v":0},{"$f":"INS_ESCRW","v":0},{"$f":"OTR_ESCRW","v":0},{"$f":"LNDR_CMTS","v":0},{"$f":"UW_SIGN","v":0},{"$f":"UW_SIGN_DT","v":"00:00:00"},{"$f":"CUW_SIGN","v":0},{"$f":"CUW_SIGN_DT","v":"00:00:00"},{"$f":"HAP_REM_TRM","v":0},{"$f":"AGE_RESTR","v":0},{"$f":"UW_CLTV","v":0},{"$f":"OP_STMT_FY","v":0},{"$f":"SZ_RSK","v":0},{"$f":"UW_PROP_VAL_DT","v":"00:00:00"},{"$f":"MEZZ_LN_ACQ_UPB","v":0},{"$f":"MEZZ_LN_MO_PMT","v":0},{"$f":"CAP_COST_FCTR","v":0},{"$f":"MAH_ABVE_120","v":0},{"$f":"MAH_UNDR_120","v":0},{"$f":"MAH_UNDR_100","v":0},{"$f":"INIT_LIHTC_COMP","v":"00:00:00"},{"$f":"LIHTC_EXT_USE","v":"00:00:00"},{"$f":"MBS_BOND_COLT_IND","v":0},{"$f":"MBS_BOND_COLT_TYP","v":0},{"$f":"LGL_NC_USE_IND","v":0},{"$f":"UW_TOT_CAP_EX_RPLM_RSRV_AMT","v":0},{"$f":"TX_RLF_IND","v":0},{"$f":"TX_RLF_PGM_TYP","v":0},{"$f":"TX_RLF_PGM_LN_DURN_IND","v":0},{"$f":"TX_RLF_PGM_CONV_LN_AFRD_ASSC_IND","v":0}]

{"sheet":"Lists","index":4,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["BuildingTypes","BorrowerLoanPurposes","MAHTypes","PropertyTypes","StateCodes","Tiers","YesNo","YesNoNA","TaxReliefProgramTypes","BondCollateralTypes",null,"Sheets in Book",{"$f":"COUNTA(SheetNames)","v":5},null,null,"WorksheetNames",null,{"$f":"IF($M$2<$M$1,\"Copy the Formula in Cell \"&CELL(\"address\",INDEX(WorksheetNames,$M$2))&\" down \"&$M$1-$M$2&\" Rows\",\"\")","v":""}]
["Garden","Acquisition","LIHTC","Multifamily","AL",2,"Yes","Yes","Payment in Lieu of Taxes (PILOT) Full Amount","MTEB",null,"Sheets in List",{"$f":"COUNTA(WorksheetNames)","v":5},null,null,{"$f":"IF(ISERROR(_xlfn.SINGLE(INDEX(SheetNames,ROWS($A$2:A2)))),\"\",INDEX(SheetNames,ROWS($A$2:A2)))","v":"Form Guidance"}]
["High-Rise","Refinance","Proj Based HAP (incl. Sec. 8)","Cooperative","AK",3,"No","No","Payment in Lieu of Taxes (PILOT) Partial Amount","MBS Exchange",null,null,null,null,null,{"$f":"IF(ISERROR(_xlfn.SINGLE(INDEX(SheetNames,ROWS($A$2:A3)))),\"\",INDEX(SheetNames,ROWS($A$2:A3)))","v":"Form 4662"}]
["Mid-Rise","Forward Conversion","Both LIHTC & Proj Based HAP","Dedicated Student","AZ",4,null,"NA","Tax Exemption or Tax Abatement Full Amount",null,null,null,null,null,null,{"$f":"IF(ISERROR(_xlfn.SINGLE(INDEX(SheetNames,ROWS($A$2:A4)))),\"\",INDEX(SheetNames,ROWS($A$2:A4)))","v":"VData"}]
["Single Family Rental","ARM to Fixed Conversion","Not MAH","Manufactured Housing","AR",null,null,null,"Tax Exemption or Tax Abatement Partial Amount",null,null,null,null,null,null,{"$f":"IF(ISERROR(_xlfn.SINGLE(INDEX(SheetNames,ROWS($A$2:A5)))),\"\",INDEX(SheetNames,ROWS($A$2:A5)))","v":"HData"}]
["Townhouse","Rehabilitation","Other","Seniors","CA",null,null,null,"Tax Increment Financing (TIF) Full Amount",null,null,null,null,null,null,{"$f":"IF(ISERROR(_xlfn.SINGLE(INDEX(SheetNames,ROWS($A$2:A6)))),\"\",INDEX(SheetNames,ROWS($A$2:A6)))","v":"Lists"}]
["Other","Equity","Other - Sponsor Initiated Affordability","Military","CO",null,null,null,"Tax Increment Financing (TIF) Partial Amount"]
[null,"Construction Take Out","Other - Special Public Purpose",null,"CT"]
[null,"New Construction","Other – Sponsor Dedicated Workforce",null,"DC"]
[null,null,null,null,"DE"]
[null,null,null,null,"FL"]
[null,null,null,null,"GA"]
[null,null,null,null,"GU"]
[null,null,null,null,"HI"]
[null,null,null,null,"ID"]
[null,null,null,null,"IL"]
[null,null,null,null,"IN"]
[null,null,null,null,"IA"]
[null,null,null,null,"KS"]
[null,null,null,null,"KY"]
[null,null,null,null,"LA"]
[null,null,null,null,"ME"]
[null,null,null,null,"MD"]
[null,null,null,null,"MA"]
[null,null,null,null,"MI"]
[null,null,null,null,"MN"]
[null,null,null,null,"MS"]
[null,null,null,null,"MO"]
[null,null,null,null,"MT"]
[null,null,null,null,"NE"]
[null,null,null,null,"NV"]
[null,null,null,null,"NH"]
[null,null,null,null,"NJ"]
[null,null,null,null,"NM"]
[null,null,null,null,"NY"]
[null,null,null,null,"NC"]
[null,null,null,null,"ND"]
[null,null,null,null,"OH"]
[null,null,null,null,"OK"]
[null,null,null,null,"OR"]
[null,null,null,null,"PA"]
[null,null,null,null,"PR"]
[null,null,null,null,"RI"]
[null,null,null,null,"SC"]
[null,null,null,null,"SD"]
[null,null,null,null,"TN"]
[null,null,null,null,"TX"]
[null,null,null,null,"UT"]
[null,null,null,null,"VT"]
[null,null,null,null,"VA"]
[null,null,null,null,"VI"]
[null,null,null,null,"WA"]
[null,null,null,null,"WV"]
[null,null,null,null,"WI"]
[null,null,null,null,"WY"]