{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Rental Assistance Inventory","FMR And RR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Instructions","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,12],[35,0,35,12],[3,0,3,12],[7,0,7,12],[26,2,26,12],[27,2,27,12],[29,2,29,12],[30,2,30,12],[32,2,32,12],[22,2,22,12],[20,2,20,12],[13,0,13,12],[25,0,25,12],[28,2,28,12],[31,2,31,12],[8,1,8,4],[18,2,18,12],[19,2,19,12],[21,2,21,12],[10,1,10,7],[8,5,8,9],[9,1,9,11]]}
["Purpose:  This worksheet is intended to help CoC Program recipients that provide rental assistance to program participants determine whether or not a prospective unit's rent meets Fair Market Rent (FMR) and Rent Reasonableness standards.  The worksheets will also help recipients determine how much rent they can pay with CoC Program funds.  This worksheet should only be used by recipients of CoC Program RENTAL ASSISTANCE funds.  This worksheet is not intended for rapid re-housing programs that modify the tenant rent calculation.\nBelow are instructions on how to utilize this worksheet."]
[]
["Rental Assistance Inventory Tab:"]
["All units rented with CoC Program Rental Assistance funds should be documented on this tab."]
[]
["How to Use This Tool:"]
["Step 1: Locate local FMR and Utility Allowance information"]
["Each unit requires information about local FMR and possible utility allowance.  "]
[null,"• If you do not know your FMR, you can find it here: ",null,null,null,"http://www.huduser.org/portal/datasets/fmr.html"]
[null,"• If you do not know your local utility allowance, please contact your local housing authority to see if they have calculated it.  If they have not, and you need to calculate it yourself, please review the Utility Allowance Handbook found here:"]
[null," https://www.hudexchange.info/resource/2267/utility-allowance-guidebook/"]
[]
["Step 2: Add unit and rent information"]
["The following information should be entered in the white cells for each prospective unit, one unit per row, on the applicable tab.  Grey scales include standardized formulas:"]
[null,"Unit Name","This should match the name used in the project's recordkeeping."]
[null,"Type of Unit","This type or size of the unit, such as efficiency, one bedroom, etc."]
[null,"Contract Rent","The monthly rent charged by the landlord for the unit."]
[null,"Local FMR","The local Fair Market Rent (FMR) for the unit size."]
[null,"Determined Rent Reasonableness","The monthly rent determined to be reasonable for similar units in the geographic area.\nAdditional information regarding how to determine rent reasonableness can be found here: "]
[null,null,"https://www.hudexchange.info/resources/documents/CoC-Rent-Reasonableness-and-FMR.pdf"]
[null,"All Utilities Included","Indicate whether or not all the utilities are included in the monthly rent (NOTE: Utilities do not include telephone or cable/internet).  If only some utilities are included, but not all, please respond with \"No\"."]
[null,"Utility Allowance","The local utility allowance calcuated for this unit because all utilities are not included.  This cell will only be available if you indicate \"No\" in the \"Utilities Included\" column."]
[null,"Calculated Program Participant Occupancy Charge","The monthly amount the program participant must pay to their landlord, as limited by Section 578.77 of the CoC Program interim rule."]
[]
["Step 3: Check warnings and notes"]
["Each tab includes warnings and notes to help recipients comply with the CoC Program interim rule.  Warnings will begin to show as you click through the different cells.  If warnings are shown, please double check the information.  The following warnings may appear:"]
[null,"Contract Rent","Cell will go red when Contract Rent is above the lower of FMR or Rent Reasonableness."]
[null,"Gross Rent","Cell will go red when Gross Rent (Contract Rent + Utility Allowance) is above the lower of FMR or Rent Reasonableness"]
[null,"Utility Allowance","Cell will go red when an utility allowance amount is required."]
[null,"CoC Program Leasing Funds Allowed","Cell will say \"No Contract\" when the gross rent exceeds the rent reasonableness standard specified for the unit.  CoC Program grant funds can never be used on a unit with gross rents that exceed rent reasonableness."]
[null,"Notes","Cell will display notes regarding whether or not the contract lease can be executed and different ways you can pay for rents that exceed FMR but are within rent reasonableness.  You may need to increase the size of the row to see the entire note."]
[null,"Calculated Program Participant Occupancy Charge","Cell will turn red when an occupancy charge amount is required (even if that amount is zero)."]
[null,"Adjusted Program Participant Contribution","Cell will turn green if a program participant's contribution is less than the utility allowance and the program participant must be reimbursed the difference."]
[]
["Add a Row Button"]
["Please use this button to add additional lines to this tool."]

{"sheet":"Rental Assistance Inventory","index":1,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,4,1,6],[0,4,0,6]]}
[null,null,null,null,"Cells this color indicate a potential issue (see notes column for specific issue)"]
[null,null,null,null,"Cells this color indicate program participants should be reimbursed for utilities"]
[]
["Unit Name","Type of Unit","Contract Rent","Local FMR","Determined Rent Reasonableness","Are All Utilities Included?","Utility Allowance","Gross Rent (Contract Rent + Utility Allowance)","CoC Program Rental Assistance Funds Allowed\n(includes program income and match)","Notes","Calculated Program Participant Rent\n(not adjusted for Utility Allowance)","Adjusted Program Participant Contribution\n(Participant Occupancy Charge - Utility Allowance)\n\n*Negative numbers indicate the amount a program participant needs to be reimbursed for utilities"]
[null,null,null,null,null,null,null,{"$f":"IF(C5=\"\",\"\",C5+IF(OR(F5=\"Yes\",F5=\"\"),0,$G5))","v":""},{"$f":"IF(C5=\"\",\"\",IF(H5>E5,\"No Contract\",IF((H5<=E5),H5,\"No Contract\")))","v":""},{"$f":"IF(C5=\"\",\"\",IF(OR(AND(D5<C5,C5>E5),I5=\"No Contract\"),\"The CoC Program does not allow you to provide rental assistance when the Gross Rent is above Rent Reasonableness, even if it is at or below FMR.\",IF(AND(D5>C5,C5<=E5),\"You can execute this contract.  Remember to document rent reasonableness if the contract rent is below FMR.\",IF(AND(C5>D5,H5<=E5),CONCATENATE(\"The CoC Program allows you to pay above FMR, as long as the unit is considered rent reasonable, but do not forget to watch your budget!\",\"You are still required to serve the number of people listed in your grant agreement.\"),\"\"))))","v":""},null,{"$f":"IF(F5=\"\",\"\",IF(F5=\"no\",K5-G5,K5))","v":""}]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",null,""]
[null,null,null,null,null,null,null,"","","",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(C25=\"\",\"\",C25+IF(OR(F25=\"Yes\",F25=\"\"),0,$G25))","v":""},"","",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",C26+IF(OR(F26=\"Yes\",F26=\"\"),0,$G26))","v":""},{"$f":"IF(C26=\"\",\"\",IF(H26>E26,\"No Contract\",IF((H26<=E26),H26,\"No Contract\")))","v":""},"",null,{"$f":"IF(F26=\"\",\"\",IF(F26=\"no\",K26-G26,K26))","v":""}]
["Total",null,{"$f":"SUBTOTAL(109,EfficienciesTable[Contract Rent])","v":0},{"$f":"SUBTOTAL(109,EfficienciesTable[Local FMR])","v":0},{"$f":"SUBTOTAL(109,EfficienciesTable[Determined Rent Reasonableness])","v":0},null,{"$f":"SUBTOTAL(109,EfficienciesTable[Utility Allowance])","v":0},{"$f":"SUBTOTAL(109,EfficienciesTable[Gross Rent (Contract Rent + Utility Allowance)])","v":0},{"$f":"SUBTOTAL(109,EfficienciesTable[CoC Program Rental Assistance Funds Allowed\n(includes program income and match)])","v":0},null,{"$f":"SUBTOTAL(109,EfficienciesTable[Calculated Program Participant Rent\n(not adjusted for Utility Allowance)])","v":0},{"$f":"SUBTOTAL(109,EfficienciesTable[Adjusted Program Participant Contribution\n(Participant Occupancy Charge - Utility Allowance)\n\n*Negative numbers indicate the amount a program participant needs to be reimbursed for utilities])","v":0}]

{"sheet":"FMR And RR","index":2,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Efficiency"]
["1 Bedroom"]
["2 Bedrooms"]
["3 Bedrooms"]
["4 Bedrooms"]
["Structure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yes"]
["No"]