{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Income Limits"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":53,"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":"Calculator","index":0,"n_rows":166,"n_cols":17,"rows_kept":166,"cut":false,"hidden":false,"merged":[[8,0,8,7],[35,0,35,1],[36,0,36,1],[37,0,37,1],[34,0,34,1],[12,2,12,3],[17,2,17,5],[12,4,12,5],[16,4,16,5],[10,4,10,5],[24,3,24,6],[21,0,21,1],[26,0,26,1],[24,0,24,1],[22,0,22,1],[31,4,31,7],[46,0,46,7],[63,0,63,9],[91,0,91,7],[47,0,47,7],[42,0,42,1],[45,1,45,7],[61,0,61,9],[41,0,41,1],[25,0,25,1],[12,0,12,1],[31,0,31,2],[14,0,14,1],[16,2,16,3],[28,3,28,6],[28,0,28,1],[41,3,42,3],[19,0,19,4],[33,0,33,1],[33,5,34,5],[14,2,14,4],[16,0,16,1],[23,3,23,5],[27,3,27,4],[0,0,0,7],[1,0,1,7],[2,0,2,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[147,0,147,1],[146,0,146,1],[130,0,130,7],[27,0,27,1],[38,5,38,7],[42,5,42,7],[43,3,43,4],[44,1,44,7],[117,0,117,7],[88,0,88,7],[12,6,12,7],[16,6,16,7],[33,7,34,7],[33,6,34,6],[10,2,10,3],[23,0,23,1],[26,3,26,4],[39,0,39,1],[40,0,40,1],[156,0,156,7],[155,0,155,9],[76,1,76,7],[65,1,65,4],[65,5,65,9],[66,5,66,9],[66,1,66,4],[74,0,74,9],[144,0,144,9],[143,0,143,9],[104,0,104,7],[87,0,87,7]]}
["NEW JERSEY DEPARTMENT OF COMMUNITY AFFAIRS"]
["COUNCIL ON AFFORDABLE HOUSING (COAH)"]
["AFFORDABLE HOUSING PRICING CALCULATOR"]
[]
[]
["2006 ESTIMATED AND UPDATED WITH 2024 INCOME LIMITS"]
["GENERAL AFFORDABLE HOUSING UNIT SALES PRICE CALCULATIONS"]
["SHOWING MAXIMUM POSSIBLE PRICES"]
["MOBILE HOME CUSTOM CALCS CREATED BY COAH IN 2006 AND UPDATED WITH 2024 INCOME LIMITS"]
[]
[null,"PROJECT:",null,null,"DATE:"]
[" "]
["MUNICIPALITY:",null,null,null,"     PREPARED BY:"]
[]
["MEDIAN INCOME SOURCE:",null,"2024 Regional Limits Update by AHPNJ"]
[]
["COAH REGION:",null,null,null,"           FILE NAME:"]
[null,null,{"$f":"IF(C17,LOOKUP(C17,'Income Limits'!A7:A12,'Income Limits'!B7:B12),\"Enter COAH Region In The Box Above\")","v":"Enter COAH Region In The Box Above"}]
[]
["FINANCIAL INFORMATION"]
[]
["FINANCE RATE (APR %)"]
["SITE RENTAL",null,null,"(Monthly)"]
["PROPERTY TAX RATE",null,0,"(Rate per $100 of assessed value)"]
["EQUALIZATION RATIO",null,0,"(Usually a number between 50.00 and 150.00)"]
["PROPERTY INSURANCE",null,null,"(Monthly)"]
["UNIT FINANCE TERM",null,null,"Years (0 Points)"]
["DOWN PAYMENT",null,0.05,"(Maximum permitted)"]
["PRIVATE MORT INS (PMI)",null,0,"Annual Rate Per $1,000 of Mortgage Amount"]
[]
[]
["PROJECT DATA",null,null,null,"AFFORDABLE UNIT PRICING STRATEGY"]
[]
["TOTAL UNITS",null,null,{"$f":"IF(C34=0,\"<--Enter Units\",\"\")","v":"<--Enter Units"},null," # Of Units","Priced at","% Of Median\nIncome"]
["AFFORDABLE UNITS",null,null,{"$f":"IF(C35=0,\"<--Enter Units\",\"\")","v":"<--Enter Units"}]
["PERCENT SETASIDE",null,{"$f":"IF(C34=0,\"\",IF(C35=0,\"\",C35/C34))","v":""},null,null,null,null,null,null,null,null,{"$f":"(F37)*(H37)","v":0}]
["NUMBER OF LOW",null,null,{"$f":"FIXED(ROUNDUP(C35/2,0),0)&\" Min (50%)\"","v":"0 Min (50%)"},"LOW  ",null,null,0.3,null,null,null,{"$f":"(F38)*(H38)","v":0}]
["NUMBER OF MOD",null,null,{"$f":"FIXED(ROUNDDOWN(C35/2,0),0)&\" Max (50%)\"","v":"0 Max (50%)"},"LOW  ",null,null,0.3]
[null,null," ",null,null,{"$f":"IF(F37+F38<>C37,\"Low-Income Unit Mismatch\",\"\")","v":""},null,null,null,null,null,{"$f":"(F40)*(H40)","v":0}]
["No. OF 1 BEDROOMS",null,null,{"$f":"FIXED(ROUNDDOWN(C35*0.2,0),0)&\" Max (20%)\"","v":"0 Max (20%)"},"MOD  ",null,null,0.5,null,null,null,{"$f":"(F41)*(H41)","v":0}]
["No. OF 2 BEDROOMS",null,null,{"$f":"FIXED(ROUNDUP(C35*0.3,0),0)&\" Min (30%)\"","v":"0 Min (30%)"},"MOD  ",null,null,0.5,null,null,null,{"$f":"(F42)*(H42)","v":0}]
["No. OF 3 BEDROOMS",null,null,{"$f":"FIXED(ROUNDUP(C35*0.2,0),0)&\" Min (20%) Combined\"","v":"0 Min (20%) Combined"},"MOD  ",null,null,0.5]
["No. OF 4 BEDROOMS",null,null,null,null,{"$f":"IF(F40+F41+F42<>C38,\"Moderate-Income Unit Mismatch\",\"\")","v":""}]
[null,null,{"$f":"SUM(C40:C43)","v":0},"<--Total Affordable Units-->",null,{"$f":"SUM(F37:F42)","v":0},{"$f":"IF(F44=0,\"# of units\",\"AVG  =\")","v":"# of units"},{"$f":"IF(F44=0,\"not entered\",(SUM(L36:L41)/F44))","v":"not entered"}]
[null,{"$f":"IF(C44<>C35,\"Units by bedroom does not equal number of affordable units\",IF(F44<>C35,\"Units by low/mod split does not equal number of affordable units\",\"\"))","v":""}]
[null,{"$f":"IF(H44>0.55,\"ERROR - Affordability Average in Unit Pricing Strategy may not exceed 55%\",\"\")","v":""}]
[{"$f":"IF(SUM(B69:B72)>C37,\"PROPOSED DISTRIBUTION OF UNIT TYPES WILL NOT COMPLY WITH RULES.  REALLOCATE THE NUMBER OF UNITS BY UNIT BEDROOM SIZE.\",\"\")","v":""}]
["CALCULATION OF MAXIMUM SALES PRICES"]
[]
[null,"1 BEDROOM",null,"2 BEDROOM",null,"3 BEDROOM",null,"4 BEDROOM"]
[]
[null,"ESTIMATED\nPRICE",null,"ESTIMATED\nPRICE",null,"ESTIMATED\nPRICE",null,"ESTIMATED\nPRICE"]
[]
["TIER 1",{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$40=0,\"N/A\",IF(F37=0,\"N/A\",L54)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$41=0,\"N/A\",IF(F37=0,\"N/A\",M54)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$42=0,\"N/A\",IF(F37=0,\"N/A\",N54)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$43=0,\"N/A\",IF(F37=0,\"N/A\",O54)))","v":"Enter Region"},null,null,null,{"$f":"H97/0.95","v":{"$error":"#N/A"}},{"$f":"H110/0.95","v":{"$error":"#N/A"}},{"$f":"H123/0.95","v":{"$error":"#N/A"}},{"$f":"H136/0.95","v":{"$error":"#N/A"}}]
["TIER 2",{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$40=0,\"N/A\",IF(F38=0,\"N/A\",L55)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$41=0,\"N/A\",IF(F38=0,\"N/A\",M55)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$42=0,\"N/A\",IF(F38=0,\"N/A\",N55)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$43=0,\"N/A\",IF(F38=0,\"N/A\",O55)))","v":"Enter Region"},null,null,null,{"$f":"H98/0.95","v":{"$error":"#N/A"}},{"$f":"H111/0.95","v":{"$error":"#N/A"}},{"$f":"H124/0.95","v":{"$error":"#N/A"}},{"$f":"H137/0.95","v":{"$error":"#N/A"}}]
[]
["TIER 3",{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$40=0,\"N/A\",IF(F40=0,\"N/A\",L57)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$41=0,\"N/A\",IF(F40=0,\"N/A\",M57)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$42=0,\"N/A\",IF(F40=0,\"N/A\",N57)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$43=0,\"N/A\",IF(F40=0,\"N/A\",O57)))","v":"Enter Region"},null,null,null,{"$f":"H100/0.95","v":{"$error":"#N/A"}},{"$f":"H113/0.95","v":{"$error":"#N/A"}},{"$f":"H126/0.95","v":{"$error":"#N/A"}},{"$f":"H139/0.95","v":{"$error":"#N/A"}}]
["TIER 4",{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$40=0,\"N/A\",IF(F41=0,\"N/A\",L58)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$41=0,\"N/A\",IF(F41=0,\"N/A\",M58)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$42=0,\"N/A\",IF(F41=0,\"N/A\",N58)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$43=0,\"N/A\",IF(F41=0,\"N/A\",O58)))","v":"Enter Region"},null,null,null,{"$f":"H101/0.95","v":{"$error":"#N/A"}},{"$f":"H114/0.95","v":{"$error":"#N/A"}},{"$f":"H127/0.95","v":{"$error":"#N/A"}},{"$f":"H140/0.95","v":{"$error":"#N/A"}}]
["TIER 5",{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$40=0,\"N/A\",IF(F42=0,\"N/A\",L59)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$41=0,\"N/A\",IF(F42=0,\"N/A\",M59)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$42=0,\"N/A\",IF(F42=0,\"N/A\",N59)))","v":"Enter Region"},null,{"$f":"IF($C$18=\"Enter COAH Region In The Box Above\",\"Enter Region\",IF($C$43=0,\"N/A\",IF(F42=0,\"N/A\",O59)))","v":"Enter Region"},null,null,null,{"$f":"H102/0.95","v":{"$error":"#N/A"}},{"$f":"H115/0.95","v":{"$error":"#N/A"}},{"$f":"H128/0.95","v":{"$error":"#N/A"}},{"$f":"H141/0.95","v":{"$error":"#N/A"}}]
[]
[]
["PRICING AND BEDROOM DISTRIBUTION DETAIL FOR AFFORDABLE UNITS"]
[]
["This section of the spreadsheet is used to compare the allocation of units in the Range Of Affordability section with the Bedroom Distribution section to ensure that low- and moderate-income units are disbursed properly throughout the project.  It is important to note that N.J.A.C. 5:80-26.3(a) requires that at least 50 percent of the restricted units within each bedroom distribution be low-income units and the remainder may be moderate-income units.  Because the rule states \"at least\", odd numbers of units within each bedroom distribution are rounded up in the low-income tiers.  Additionally, there are multiple strategies for allocating units by bedroom size within the various ranges of affordability.  Completing the matrix below will both ensure rule compliance and provide an opportunity for the developers of affordable housing to test different strategies to determine maximum cash flow.  Enter numbers of units in the yellow boxes to alter the content of the green and orange boxes until the number of units in all green boxes equals the number of units in the adjacent blue boxes and the number of units in all orange boxes equals the number of units in the adjacent blue boxes."]
[]
[null,"Make Entries in Yellow Boxes",null,null,null,"Make Entries in Yellow Boxes"]
[null,"Adjacent Green and Blue Boxes Must Match",null,null,null,"Adjacent Orange and Blue Boxes Must Match"]
[null,"Low\nRequired",null,"Tier 1","Tier 2","Mod\nRequired",null,"Tier 3","Tier 4","Tier 5"]
["1 BR",{"$f":"ROUNDUP(C40/2,0)","v":0},{"$f":"D69+E69","v":0},null,null,{"$f":"C40-B69","v":0},{"$f":"SUM(H69:J69)","v":0}]
["2 BR",{"$f":"ROUNDUP(C41/2,0)","v":0},{"$f":"D70+E70","v":0},null,null,{"$f":"C41-B70","v":0},{"$f":"SUM(H70:J70)","v":0}]
["3 BR",{"$f":"ROUNDUP(C42/2,0)","v":0},{"$f":"D71+E71","v":0},null,null,{"$f":"C42-B71","v":0},{"$f":"SUM(H71:J71)","v":0}]
["4 BR",{"$f":"ROUNDUP(C43/2,0)","v":0},{"$f":"D72+E72","v":0},null,null,{"$f":"C43-B72","v":0},{"$f":"SUM(H72:J72)","v":0}]
[null,null,"Low\nProvided",{"$f":"SUM(D69:D72)","v":0},{"$f":"SUM(E69:E72)","v":0},null,"Mod\nProvided",{"$f":"SUM(H69:H72)","v":0},{"$f":"SUM(I69:I72)","v":0},{"$f":"SUM(J69:J72)","v":0}]
[null,"Total From\nProject Data",{"$f":"SUM(B69:B72)","v":0},{"$f":"F37","v":0},{"$f":"F38","v":0},{"$f":"SUM(F69:F72)","v":0},null,{"$f":"F40","v":0},{"$f":"F41","v":0},{"$f":"F42","v":0}]
[{"$f":"IF(A47<>\"\",\"PROPOSED DISTRIBUTION OF UNIT TYPES WILL NOT COMPLY WITH RULES.  REALLOCATE THE NUMBER OF UNITS BY UNIT BEDROOM SIZE IN PROJECT DATA SECTION.\",\"\")","v":""}]
[]
[null,"GROSS SALES REVENUES FROM AFFORDABLE UNITS"]
[]
[null,null,"TOTAL","Tier 1","Tier 2","Tier 3","Tier 4","Tier 5"]
[null,"1 BR",{"$f":"SUM(D80:H80)","v":0},{"$f":"D69*B54","v":0},{"$f":"E69*B55","v":0},{"$f":"H69*B57","v":0},{"$f":"I69*B58","v":0},{"$f":"J69*B59","v":0}]
[null,"2 BR",{"$f":"SUM(D81:H81)","v":0},{"$f":"D70*D54","v":0},{"$f":"E70*D55","v":0},{"$f":"H70*D57","v":0},{"$f":"I70*D58","v":0},{"$f":"J70*D59","v":0}]
[null,"3 BR",{"$f":"SUM(D82:H82)","v":0},{"$f":"D71*F54","v":0},{"$f":"E71*F55","v":0},{"$f":"H71*F57","v":0},{"$f":"I71*F58","v":0},{"$f":"J71*F59","v":0}]
[null,"4 BR",{"$f":"SUM(D83:H83)","v":0},{"$f":"D72*H54","v":0},{"$f":"E72*H55","v":0},{"$f":"H72*H59","v":0},{"$f":"I72*H58","v":0},{"$f":"J72*H59","v":0}]
[]
[null,"TOTAL",{"$f":"SUM(D85:H85)","v":0},{"$f":"SUM(D80:D83)","v":0},{"$f":"SUM(E80:E83)","v":0},{"$f":"SUM(F80:F83)","v":0},{"$f":"SUM(G80:G83)","v":0},{"$f":"SUM(H80:H83)","v":0}]
[]
[]
["BREAKDOWN OF TOTAL HOUSING EXPENSE"]
["BY BEDROOM SIZE AND CATEGORY"]
[]
[]
["1 BEDROOM UNITS  (1.5 PERSON HOUSEHOLD)"]
[]
["CATEGORY","TOTAL","CONDO","PROPERTY","PROPERTY","PMI","PRINCIPAL","MAXIMUM",null,null,null,null,null,null,null,null,""]
[null,null,"DUES","INSURANCE","TAX",null,"& INTEREST","MORTGAGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["TIER 1",{"$f":"(0.28)*((($C$161)+($D$161))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B97=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B97=0,0,($C$26))","v":{"$error":"#N/A"}},{"$f":"(((B54)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((B54*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B97)-C97-D97-E97-F97","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G97)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,""]
["TIER 2",{"$f":"(0.28)*((($C$162)+($D$162))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B98=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B98=0,0,($C$26))","v":{"$error":"#N/A"}},{"$f":"(((B55)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((B55*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B98)-C98-D98-E98-F98","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G98)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["TIER 3",{"$f":"(0.28)*((($C$164)+($D$164))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B100=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B100=0,0,($C$26))","v":{"$error":"#N/A"}},{"$f":"(((B57)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((B57*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B100)-C100-D100-E100-F100","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G100)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,""]
["TIER 4",{"$f":"(0.28)*((($C$165)+($D$165))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B101=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B101=0,0,($C$26))","v":{"$error":"#N/A"}},{"$f":"(((B58)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((B58*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B101)-C101-D101-E101-F101","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G101)","v":{"$error":"#N/A"}}]
["TIER 5",{"$f":"(0.28)*((($C$166)+($D$166))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B102=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B102=0,0,($C$26))","v":{"$error":"#N/A"}},{"$f":"(((B59)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((B59*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B102)-C102-D102-E102-F102","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G102)","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,""]
[]
["2 BEDROOM UNITS  (3 PERSON HOUSEHOLD)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["CATEGORY","TOTAL","CONDO","PROPERTY","PROPERTY","PMI","PRINCIPAL","MAXIMUM",null,null,null,null,null,null,null,null,""]
[null,null,"DUES","INSURANCE","TAX",null,"& INTEREST","MORTGAGE",null,null,null,null,null,null,null,null,""]
[]
["TIER 1",{"$f":"(0.28*E$161/12)","v":{"$error":"#N/A"}},{"$f":"IF(B110=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B110=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((D54)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((D54*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B110)-C110-D110-E110-F110","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G110)","v":{"$error":"#N/A"}}]
["TIER 2",{"$f":"(0.28*$E$162)/12","v":{"$error":"#N/A"}},{"$f":"IF(B111=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B111=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((D55)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((D55*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B111)-C111-D111-E111-F111","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G111)","v":{"$error":"#N/A"}}]
[]
["TIER 3",{"$f":"(0.28*$E$164)/12","v":{"$error":"#N/A"}},{"$f":"IF(B113=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B113=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((D57)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((D57*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B113)-C113-D113-E113-F113","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G113)","v":{"$error":"#N/A"}}]
["TIER 4",{"$f":"(0.28*$E$165)/12","v":{"$error":"#N/A"}},{"$f":"IF(B114=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B114=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((D58)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((D58*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B114)-C114-D114-E114-F114","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G114)","v":{"$error":"#N/A"}}]
["TIER 5",{"$f":"(0.28*$E$166)/12","v":{"$error":"#N/A"}},{"$f":"IF(B115=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B115=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((D59)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((D59*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B115)-C115-D115-E115-F115","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G115)","v":{"$error":"#N/A"}}]
[]
[]
["3 BEDROOM UNITS  (4.5 PERSON HOUSEHOLD)"]
[]
["CATEGORY","TOTAL","CONDO","PROPERTY","PROPERTY","PMI","PRINCIPAL","MAXIMUM"]
[null,null,"DUES","INSURANCE","TAX",null,"& INTEREST","MORTGAGE"]
[]
["TIER 1",{"$f":"(0.28)*((($F$161)+($G$161))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B123=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B123=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((F54)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((F54*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B123)-C123-D123-E123-F123","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G123)","v":{"$error":"#N/A"}}]
["TIER 2",{"$f":"(0.28)*((($F$162)+($G$162))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B124=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B124=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((F55)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((F55*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B124)-C124-D124-E124-F124","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G124)","v":{"$error":"#N/A"}}]
[]
["TIER 3",{"$f":"(0.28)*((($F$164)+($G$164))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B126=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B126=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((F57)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((F57*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B126)-C126-D126-E126-F126","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G126)","v":{"$error":"#N/A"}}]
["TIER 4",{"$f":"(0.28)*((($F$165)+($G$165))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B127=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B127=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((F58)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((F58*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B127)-C127-D127-E127-F127","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G127)","v":{"$error":"#N/A"}}]
["TIER 5",{"$f":"(0.28)*((($F$166)+($G$166))/2)/12","v":{"$error":"#N/A"}},{"$f":"IF(B128=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B128=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((F59)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((F59*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B128)-C128-D128-E128-F128","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G128)","v":{"$error":"#N/A"}}]
[]
[]
["4 BEDROOM UNITS  (6 PERSON HOUSEHOLD)"]
[]
["CATEGORY","TOTAL","CONDO","PROPERTY","PROPERTY","PMI","PRINCIPAL","MAXIMUM"]
[null,null,"DUES","INSURANCE","TAX",null,"& INTEREST","MORTGAGE"]
[]
["TIER 1",{"$f":"(0.28)*($H$161/12)","v":{"$error":"#N/A"}},{"$f":"IF(B136=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B136=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((H54)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((H54*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B136)-C136-D136-E136-F136","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G136)","v":{"$error":"#N/A"}}]
["TIER 2",{"$f":"(0.28)*($H$162/12)","v":{"$error":"#N/A"}},{"$f":"IF(B137=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B137=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((H55)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((H55*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B137)-C137-D137-E137-F137","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G137)","v":{"$error":"#N/A"}}]
[]
["TIER 3",{"$f":"(0.28)*($H$164/12)","v":{"$error":"#N/A"}},{"$f":"IF(B139=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B139=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((H57)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((H57*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B139)-C139-D139-E139-F139","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G139)","v":{"$error":"#N/A"}}]
["TIER 4",{"$f":"(0.28)*($H$165/12)","v":{"$error":"#N/A"}},{"$f":"IF(B140=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B140=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((H58)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((H58*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B140)-C140-D140-E140-F140","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G140)","v":{"$error":"#N/A"}}]
["TIER 5",{"$f":"(0.28)*($H$166/12)","v":{"$error":"#N/A"}},{"$f":"IF(B141=0,0,($C$23))","v":{"$error":"#N/A"}},{"$f":"IF(B141=0,0,$C$26)","v":{"$error":"#N/A"}},{"$f":"(((H59)*(C$25))/100)*((C$24)/12)","v":0},{"$f":"((H59*0.95)/1000)*((C$29)/12)","v":0},{"$f":"(B141)-C141-D141-E141-F141","v":{"$error":"#N/A"}},{"$f":"PV($C$22/12,$C$27*12,-G141)","v":{"$error":"#N/A"}}]
[]
[]
["INCOME LIMITS FOR QUALIFYING HOUSEHOLDS"]
[{"$f":"C15","v":"2024 Regional Limits Update by AHPNJ"}]
[]
["FAMILY SIZE :",null,"1","2","3","4","5","6","7",8]
["MEDIAN INCOME:",null,{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!C$7:C$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!D$7:D$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!E$7:E$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!F$7:F$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!G$7:G$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!H$7:H$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!I$7:I$12)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($C$17,'Income Limits'!$A$7:$A$12,'Income Limits'!J$7:J$12)","v":{"$error":"#N/A"}}]
[]
["CATEGORY","% USED"]
[]
["MODERATE",0.8,{"$f":"$B152*C$148","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["LOW",0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["VERY LOW",0.3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["This sample calculation provides maximums.  The indicated breakdown is not to be interpreted as mandatory.  These figures are produced only as an aid in configuring a price structure that complies with the Council on Affordable Housing requirements at N.J.A.C. 5:94-7.2 and N.J.A.C. 5:80-26."]
[]
[]
[]
[]
["TIER 1",{"$f":"H37","v":0.3},{"$f":"$B161*C$148","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["TIER 2",{"$f":"H38","v":0.3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["TIER 3",{"$f":"H40","v":0.5},{"$f":"$B164*C$148","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["TIER 4",{"$f":"H41","v":0.5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["TIER 5",{"$f":"H42","v":0.5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Income Limits","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,2,0,7],[1,3,1,6],[2,3,2,6]]}
[null,null,"NEW JERSEY COAH INCOME LIMITS"]
[null,null,null,"MEDIAN INCOME BY FAMILY SIZE"]
[null,null,null,"CURRENT AS OF 2024"]
[]
[null,"Region","1 PERSON","2 PERSON","3 PERSON","4 PERSON","5 PERSON","6 PERSON","7 PERSON","8 PERSON"]
[]
[1,"Bergen, Hudson, Passaic, Sussex",{"$f":"F7*0.7","v":84288.277693909462},{"$f":"F7*0.8","v":96329.460221610832},{"$f":"F7*0.9","v":108370.64274931217},120411.82527701353,{"$f":"F7*1.08","v":130044.77129917462},{"$f":"F7*1.16","v":139677.71732133569},{"$f":"F7*1.24","v":149310.66334349677},{"$f":"F7*1.32","v":158943.60936565787}]
[2,"Essex, Morris, Union, Warren",90591.298711059324,103532.91281263925,116474.52691421914,129416.14101579905,139769.43229706297,150122.72357832687,160476.01485959082,170829.30614085475]
[3,"Hunterdon, Middlesex, Somerset",102340,116960,131580,146200,157896,169592,181288,192984]
[4,"Mercer, Monmouth, Ocean",91037.701584610215,104043.08752526883,117048.47346592743,130053.85940658602,140458.16815911292,150862.47691163977,161266.78566416667,171671.09441669355]
[5,"Burlington, Camden, Gloucester",80290,91760,103230,114700,123876.00000000001,133052,142228,151404]
[6,"Atlantic, Cape May, Cumberland, Salem",68851.650561608491,78687.600641838275,88523.550722068059,98359.500802297844,106228.26086648168,114097.02093066549,121965.78099484932,129834.54105903316]