{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Request for Funds","Compliance Checklist","Funding Sources","Unit Mix","B. HmOwnr Fund Reconciliation","Drop Down Menus"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":8,"defined_names":160,"comments":1,"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":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,0,7,7],[0,0,1,7],[2,0,2,7]]}
["Pursuant to Health and Safety Code (HSC) Section 50843.5(a)\nThe Department is authorized to provide matching grants to Local Housing Trust Funds established by cities and counties, Native American Tribes, and/or incorporated 501(c)(3) nonprofit organizations."]
[]
["Completion of the Request for Funds\nIn order to obtain reimbursement, all fields in which information is requested must be completed by the Grantee within the four tabs of the Request for Funds form. One form should be filled out per project. Request for Funds workbooks which contain blank information will be considered incomplete and will be returned to the Grantee for completion before funds are disbursed.  Any questions pertaining to the Request for Funds requirements or additional documentation requested should be directed to the Grant Management Representative assigned to the project.  If you do not have your Grant Management Representative information, you may submit your email inquiry at LHTFSGM@hcd.ca.gov."]
["Tab 1: Instructions\nPlease navigate through form fields using Tab key and fill in information as prompted.\n\nTab 2: Request for Funds \nFill out the basic grantee and project information as prompted from cells C5:I15. Cell I15 should be the amount of your total LHTF award, not just for the project requesting funds. \n\nExpenditure Breakdown\nCell B18: Input the amount of your LHTF award committed to the project for which you are requesting reimbursement\nCells D18:I18 will automatically populate with amounts once the rest of the form is filled out. \nCell D21: Input the total amount being requested this draw in project costs. Do not include administrative costs in this row. Admin will be recorded in Row 22.  \nCell F21: Input the amount of matching funds committed for this expenditure on project costs. This should match dollar-for-dollar the amount requested from LHTF. This is not the total amount of matching funds committed for the whole project (this will be reported in the Matching Sources section).\nCell D22: Input the amount of Administrative expenses requested for reimbursement for this draw.\nCell F22: Input the amount of matching funds committed for this expenditure on Administrative expenses. The number input should match dollar-for-dollar the amount requested from LHTF. This is not the total amount of matching funds committed for the whole project (this will be reported in the Matching Sources section).\n\nRestricted Unit Breakdown\nCells D26:D29: Input how much of the LHTF award is being requested for units by income restriction level and administrative costs. The total amount should equal the total of the request section above. \n\nMatching Sources\nThis table is for documenting the Matching Funds that were expended for the period for which you are seeking reimbursement.\nCell B33: Select from the drop-down menu the source of the first type of Matching Funds used.\nCell D33: Enter how much from that source was expended this reporting period\nCell F33: Attach documentation verifying the expenditure of matching funds, and select “Yes.” If you do not have documentation available, select “No.”\nRepeat in rows 34-36 for each unique source of Matching Funds expended this reporting period. The table in B39-E39 will automatically populate the percentages of Residential and Non-Residential Sources expended. \n\nTab 3: Compliance Checklist\nThis Checklist lists the required documents to prove that the Grantee is fulfilling the requirements set forth in the LHTF Guidelines and the Grantees’ Standard Agreement. The Grantee will go through each requirement, and select from the drop-down menu in column C either Yes (documentation is provided that proves compliance), No (no documentation has been submitted for that requirement) or N/A (the requirement is not applicable to the Grantee project). The rest of the form is to be filled out by the Representative and Manager for the Department once they have reviewed and approved the Grantee’s forms and ensured that amounts reflect consistency with the Grantee's application. \n\nTab 4: Funding Sources\nThe Funding Sources tab details loan information to subcontractors. Table A4:J10 is for Construction Loans, and A12:J19 for Permanent Loan information\nA5: Enter the lien position of your loan\nB5: Enter the name of the lender\nC5: Enter the term until loan maturity in months\nD5: Enter the annual interest rate of the loan as a percentage\nE5: Select the interest rate type from the drop-down menu\nF5: Enter the amount of the loan\nG5: Enter the annual payment to be made on the loan\nH5: Enter the funding type\nI5: Optional: Space for any comments on the loan\nRepeat for rows 6-16, and on the Permanent Loan table 20-31 for as many loans as are issued for this project. \n\nTab 5: Unit Mix\nThe Unit Mix form provides detail on the number, types and sizes of units in this project. \nColumn A: Select from the dropdown one of the income restrictions for your units. If there is more than one type of income restriction, report each on separate rows.\nColumn B: Enter the number of bedrooms in units of the selected income restriction. Studios should be reported as “0” bedrooms. If the selected unit restriction applies to units of multiple sizes, report each group of units as separate rows (e.g. A project with 10 2-bedroom units and 5 0-Bedroom units for Extremely low income would be: Row 9: ELI,2BR, 10 units; Row 10: ELI, 0BR, 5 units) \nColumn C: Enter how many restricted units matching the level of restriction and size identified are included in this project.  \nColumn D: Enter how many unrestricted units matching the level of restriction and size identified are included in this project. Unrestricted units should only be reported for Manager’s Units and where “Not Restricted” is selected in Column A. \n\nFor Questions: contact your HCD Representative or send your question to LHTFSGM@hcd.ca.gov "]

{"sheet":"Request for Funds","index":1,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[46,1,46,2],[43,3,43,4],[44,1,44,2],[16,3,16,4],[17,3,17,4],[40,7,40,8],[41,7,41,8],[29,5,29,6],[31,1,31,8],[43,1,43,2],[38,5,38,6],[34,7,34,8],[38,7,38,8],[34,3,34,4],[38,3,38,4],[35,5,35,6],[36,5,36,6],[37,5,37,6],[35,7,35,8],[36,7,36,8],[37,7,37,8],[34,5,34,6],[32,7,32,8],[24,3,24,4],[1,1,1,3],[2,1,2,3],[39,5,39,6],[40,5,40,6],[41,5,41,6],[39,7,39,8],[38,1,38,2],[29,3,29,4],[29,1,29,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[39,3,39,4],[40,3,40,4],[41,3,41,4],[32,1,32,2],[32,5,32,6],[35,1,35,2],[36,1,36,2],[37,1,37,2],[35,3,35,4],[36,3,36,4],[37,3,37,4],[34,1,34,2],[58,1,58,4],[55,5,55,7],[56,5,56,7],[57,5,57,7],[58,5,58,7],[56,1,56,4],[57,1,57,4],[47,1,47,8],[48,1,48,8],[49,1,49,4],[50,1,50,4],[51,1,51,4],[52,1,52,4],[49,5,49,8],[50,5,50,8],[51,5,51,8],[52,5,52,8],[53,1,53,8],[55,1,55,4],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[20,9,20,10],[16,1,16,2],[17,1,17,2],[16,8,16,10],[17,8,17,10],[17,5,17,6],[30,11,30,12],[23,11,23,12],[24,9,24,10],[27,9,27,10],[28,9,28,10],[30,1,30,8],[29,9,29,10],[25,9,25,10],[26,9,26,10],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[22,7,22,8],[22,3,22,4],[32,3,32,4],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[23,1,23,10],[22,9,22,10],[3,1,3,2],[5,1,5,2],[19,1,19,2],[19,3,19,4],[10,2,10,5],[10,6,10,7],[11,6,11,7],[13,6,13,7],[11,2,11,5],[13,2,13,5],[19,5,19,6],[19,7,19,8],[12,2,12,5],[12,6,12,7],[14,8,14,10],[19,9,19,10],[13,8,13,10],[12,8,12,10],[11,8,11,10],[10,8,10,10],[7,1,7,10],[9,2,9,3],[8,1,8,2],[16,5,16,6],[14,6,14,7],[45,1,45,2],[20,7,20,8],[20,1,20,2],[20,3,20,4],[20,5,20,6],[42,7,42,8],[33,7,33,8],[42,1,42,2],[33,1,33,2],[42,3,42,4],[33,5,33,6],[42,5,42,6],[21,1,21,2],[21,3,21,4],[28,1,28,2],[22,1,22,2],[14,2,14,5],[15,1,15,10],[33,3,33,4],[21,9,21,10],[21,7,21,8],[21,5,21,6],[22,5,22,6]]}
[null,"beginning of sheet 3 - Request for Funds"]
[null,"DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
[null,"DIVISION OF STATE FINANCIAL ASSISTANCE"]
[null,"2020 West El Camino, 4th Floor"]
[null,"Sacramento, CA  95833"]
[null,"LHTFSGM@hcd.ca.gov"]
[]
[null,"LOCAL HOUSING TRUST FUND (LHTF) PROGRAM \nREQUEST FOR FUNDS (RFF)\nPlease fill out one form per project"]
[null,"Last Revised: 12/27/2021"]
[null,"Draw Request #:"]
[null,"HCD Contract Number:",null,null,null,null,"Project Name: "]
[null,"Grantee Name:",null,null,null,null,"HCD Rep: "]
[null,"Payee:",null,null,null,null,"Payee Address:"]
[null,"Title/Escrow Company:",null,null,null,null,"Title/Escrow Co. Officer Name: "]
[null,"Projected Closing Date:",null,null,null,null,"Total LHTF Award"]
[null,"EXPENDITURE BREAKDOWN"]
[null,"LHTF Award Amount Committed to Project",null,"Previous Project Award Amount Drawn to Date:",null,"Current Draw Request:",null,"Current Request Percentage of Total LHTF Award","Remaining Balance for Project:"]
[null,0,null,{"$f":"F30","v":0},null,{"$f":"D23","v":0},null,{"$f":"IFERROR(F18/I15,0)","v":0},{"$f":"B18-D18-F18","v":0}]
[]
[null,"Category",null,"LHTF Amount Requested this Draw",null,"Matching Amount On Deposit\nMust be used on a dollar-for-dollar basis of award expended per Guidelines §104 (e) ",null,"Remaining Balance Upon Approval",null,"HCD Approved Draw Amount This Period"]
[null,{"$f":"_xlfn.CONCAT(I11,\" Project Costs:\")","v":" Project Costs:"},null,null,null,null,null,{"$f":"B18-D18-D21","v":0}]
[null,"Administrative Costs:",null,null,null,null,null,{"$f":"H21-D22","v":0}]
[null,"TOTAL:",null,{"$f":"SUM(D21:E22)","v":0},null,{"$f":"SUM(F21:G22)","v":0},null,{"$f":"H22","v":0},null,{"$f":"SUM(J21:K22)","v":0}]
[null,"RESTRICTED UNIT BREAKDOWN"]
[null,"Category",null,"LHTF Amount Requested this Draw",null,"Previous Project Award Amount Drawn to Date:",null,"Percent of Project Award Drawn to Date",null,"Percentage of Total Project Award Amount "]
[null,"Amount Requested for Extremely Low Income Units (up to 30% AMI):\nMust be at least 30% of funds, per Guidelines §105 (c) ",null,null,null,null,null,{"$f":"(D26+F26)/(SUM($D$26:$G$28))","v":{"$error":"#DIV/0!"}},null,{"$f":"(D26+F26)/($B$18-(0.05*$B$18))","v":{"$error":"#DIV/0!"}}]
[null,"Amount Requested for Low Income Units (up to 80% AMI):",null,null,null,null,null,{"$f":"(D27+F27)/(SUM($D$26:$G$28))","v":{"$error":"#DIV/0!"}},null,{"$f":"(D27+F27)/($B$18-(0.05*$B$18))","v":{"$error":"#DIV/0!"}}]
[null,"Amount Requested for Moderate Income Units (up to 120% AMI):\nMust be no more than 20% of funds, per Guidelines §105 (d)",null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$f":"(D28+F28)/($B$18-(0.05*$B$18))","v":{"$error":"#DIV/0!"}}]
[null,"Amount Requested for Administrative Costs:\nMust be no more than 5% of Program Funds, per Guidelines §105 (b)",null,{"$f":"D22","v":0},null,null,null,{"$f":"(D29+F29)/($D$18+$F$18)","v":{"$error":"#DIV/0!"}},null,{"$f":"(D29+F29)/($B$18)","v":{"$error":"#DIV/0!"}}]
[null,"TOTAL:",null,{"$f":"SUM(D26:E29)","v":0},null,{"$f":"SUM(F26:G29)","v":0},null,{"$f":"(D30+F30)/($F$30+$D$30)","v":{"$error":"#DIV/0!"}},null,{"$f":"D30/$B$18","v":{"$error":"#DIV/0!"}}]
[null,"MATCHING SOURCES"]
[null,"\"All Program Funds provided pursuant to this section shall be matched on a dollar for dollar basis with dedicated sources of funding, such as taxes, fees, or loan repayments, or public or private contributions by the Applicant. Lines of credit and loans received by the Local Housing Trust Fund are not eligible sources of Matching Funds.\" Guidelines Section 104 (a) \n\"Matching funds shall be on Deposit prior to disbursement of Program Funds.\" Guidelines Section 104 (d) "]
[null,"Source of Matching Funds",null,"Matching Amount On Deposit",null,"Matching Funds Documentation Attached \n(include amount by source and verification of deposit)",null,"HCD Approved Matching Source to Grantee Application"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount on Deposit","Match Amount Expended","Documentation Attached of Matching Funds, including amount by source"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL:",null,{"$f":"SUM(D34:E43)","v":0}]
[null,"Type of Match Source",null,"Total Amount","Percentage"]
[null,"Residential Sources:",null,{"$f":"SUMIF(B34:C43,\"Residential*\",D34:E43)","v":0},{"$f":"D46/D44","v":{"$error":"#DIV/0!"}}]
[null,"Non-Residential Sources:",null,{"$f":"SUMIF(B34:C43,\"<>Residential*\",D34:E43)","v":0},{"$f":"D47/D44","v":{"$error":"#DIV/0!"}}]
[null,"CERTIFICATION"]
[null,"***By signing this request, I certify to the best of my knowledge and belief that the request is true, complete, and accurate, and the expenditures, disbursements and cash receipts will be  for the purposes and objectives set forth in the terms and conditions of the State award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)"]
[null,"Name of Authorized Official",null,null,null,"Title of Authorized Executive Official"]
[]
[null,"Signature of Authorized Official",null,null,null,"Date"]
[]
[null,"HCD USE ONLY"]
[null,"Total Award Balance Remaining:\n(Refer to cell H14 of Grantee Disbursement Tracker after updating with this RFF)",null,null,null,"Percentage of Award Remaining: ",null,{"$f":"IFERROR(D55/I15,0)","v":0}]
[null,"   SGM Representative Name                                                    ",null,null,null,"SGM Representative Signature",null,null,"    Date"]
[]
[null,"   SGM Manager Name                                                 ",null,null,null,"SGM Manager Signature",null,null,"    Date"]

{"sheet":"Compliance Checklist","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,5],[4,1,4,5],[11,1,11,5],[18,2,18,5]]}
[null,"beginning of sheet 2: compliance checklist"]
[null,"LOCAL HOUSING TRUST FUND (LHTF) PROGRAM \nCompliance Checklist for Multifamily Rental Projects"]
[null,null,"Project:",{"$f":"'Request for Funds'!I11","v":0},"Contract #:",{"$f":"'Request for Funds'!C11","v":0}]
[null,"Please fill out column C by selecting Yes, No or N/A from the drop-down menu in response to the Requirement to indicate that you are attaching appropriate proof of compliance. Columns D-F are for HCD Staff to fill out upon review and approval of the documents submitted. The Department shall have the right to request copies of documentation of the activities of the Local Housing Trust Fund at any time prior to or after disbursement of Program Funds on or in addition to what is listed on this checklist. Refer to your Standard Agreement or contact your State Grant Management Representative for more information. "]
[null,"Rental Housing including Permanent Supportive Housing Projects"]
[null,"Requirement  Provide draft copies of all LHTF loan documents prior to escrow and fully executed and recorded copies after close","Documentation Submitted","Rep Approval (initials)","Manager Approval (initials) ","Date of Manager Approval"]
[null,"Promissory Note at an interest rate no higher than 3% per annum and containing the  provision that repayment shall be made to the Department in the event that the Grantee is no longer in operation (pursuant to LHTF Final Guidelines §107 (a))"]
[null,"Deed of Trust securing the Promissory Note (pursuant to LHTF Final Guidelines §107 (a))"]
[null,"Regulatory Agreement sets forth requirements for household income levels and rent restrictions for not less than 55 years for all units assisted by program funds. (pursuant to LHTF Final Guidelines §107 (b)). - Multifamily rental projects only "]
[null,"Where program funds are provided in the form of a construction loan, the Grantee and the housing developer shall enter into a development loan agreement setting forth the terms and conditions required to be met prior to closing escrow.  (pursuant to LHTF Final Guidelines §107 (c)) - Rental Housing Construction Loans only"]
[null,"Copy of Scope of Work, as described in Exhibit A of the Contractor's Standard Agreement"]
[]
[null,"Certificate of Occupancy and/or Completion - Completed projects only"]
[null,"Copy of Proforma Title Insurance Policy after close of escrow"]
[null,"Provide a copy of the Permanent senior lender loan documents fully executed and recorded "]
[null,"Provide a copy of the Permanent junior lender(s) loan documents fully executed and recorded."]
[null,"Provide a copy of Grant documents as applicable fully executed and recorded"]
[null,"California Tax Credit Allocation Committee (TCAC) Reservation Letter as applicable "]
[null,"Additional Comments:"]

{"sheet":"Funding Sources","index":3,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,8,19,10],[14,8,14,10],[20,0,20,1],[11,0,11,1],[12,0,12,10],[13,8,13,10],[15,8,15,10],[16,8,16,10],[17,8,17,10],[18,8,18,10],[8,8,8,10],[9,8,9,10],[10,8,10,10],[1,8,1,9],[1,5,1,6],[4,8,4,10],[5,8,5,10],[3,0,3,10],[6,8,6,10],[7,8,7,10]]}
["beginning of sheet 4: funding sources"]
["TRANSACTION SUMMARY",null,null,null,"Project:",{"$f":"'Request for Funds'!I11","v":0},null,"Contract #",{"$f":"'Request for Funds'!C11","v":0}]
[]
["Construction Sources"]
["Lien Position","Name of Lender ","Term Maturity (months)","Interest\nRate\nsee Guidelines §105 (a)\n","Interest\nRate Type","Amount","Annual\nPayment ","Funding Type","Comments (if HCD, enter contract #)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total: ",{"$f":"SUM(F6:F11)","v":0}]
["Permanent Sources"]
["Lien Position","Name of Lender ","Term to\nMaturity\n(years)","Interest Rate \nsee Guidelines §105 (a)","Interest\nRate Type","Amount","Annual\nPayment ","Funding Type","Comments (if HCD, enter contract #)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total: ",{"$f":"SUM(F15:F20)","v":0}]

{"sheet":"Unit Mix","index":4,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[4,0,4,6]]}
["beginning of tab 4: Unit Mix"]
["Local Housing Trust Fund \nUnit Mix"]
["HCD Contract #",{"$f":"'Request for Funds'!C11","v":0},null,null,"Project Name:",{"$f":"'Request for Funds'!I11","v":0}]
["Grantee Name",{"$f":"'Request for Funds'!C12","v":0}]
[]
["Income Restriction","# of Bedrooms (Studio units are \"0\" bedroom)","HCD LHTF Funded Units","Other Restricted Units (Non-HCD LHTF Funded)","Unrestricted Units","Total Units","Total Bedrooms"]
["Manager Unit",null,null,null,null,{"$f":"SUM(C7:E7)","v":0},{"$f":"B7*F7","v":0}]
["Manager Unit",null,null,null,null,{"$f":"SUM(C8:E8)","v":0},0]
[null,null,null,null,null,{"$f":"SUM(C9:E9)","v":0},{"$f":"B9*F9","v":0}]
[null,null,null,null,null,{"$f":"SUM(C10:E10)","v":0},{"$f":"B10*F10","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"SUM(C19:E19)","v":0},0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTALS",null,{"$f":"SUM(C7:C32)","v":0},{"$f":"SUM(D7:D32)","v":0},{"$f":"SUM(E7:E32)","v":0},{"$f":"SUM(F7:F32)","v":0},0]
[]
["ELI Units:",{"$f":"SUMIF($A$7:$A$32,\"ELI (up to 30% AMI)\",$C$7:$C$32)","v":0},{"$f":"B35/$F$33","v":{"$error":"#DIV/0!"}},null,"ELI Bedrooms:",{"$f":"SUMIF($A$7:$A$32,\"ELI (up to 30% AMI)\",$G$7:$G$32)","v":0},{"$f":"F35/$G$33","v":{"$error":"#DIV/0!"}}]
["LI Units:",{"$f":"SUMIF($A$7:$A$32,\"LI (30%-80% AMI)\",$C$7:$C$32)","v":0},{"$f":"B36/$F$33","v":{"$error":"#DIV/0!"}},null,"LI Bedrooms:",{"$f":"SUMIF($A$7:$A$32,\"LI (30%-80% AMI)\",$G$7:$G$32)","v":0},{"$f":"F36/$G$33","v":{"$error":"#DIV/0!"}}]
["Mod Units:",{"$f":"SUMIF($A$7:$A$32,\"Mod (80%-120% AMI)\",$C$7:$C$32)","v":0},{"$error":"#DIV/0!"},null,"Mod Bedrooms:",{"$f":"SUMIF($A$7:$A$32,\"Mod (80%-120% AMI)\",$G$7:$G$32)","v":0},{"$error":"#DIV/0!"}]
["120% AMI+:",{"$f":"SUMIF($A$7:$A$32,\"120% AMI and above\",$D$7:$D$32)","v":0},{"$error":"#DIV/0!"},null,"120% AMI+ Bedrooms:",{"$f":"SUMIF($A$7:$A$32,\"120% AMI and above\",$G$7:$G$32)","v":0},{"$error":"#DIV/0!"}]
["Unrestricted Units:",{"$f":"SUMIF($A$7:$A$32,\"Not Restricted\",$E$7:$E$32)","v":0},{"$error":"#DIV/0!"},null,"Unrestricted Bedrooms:",{"$f":"SUMIF($A$7:$A$32,\"Not Restricted\",$G$7:$G$32)","v":0},{"$error":"#DIV/0!"}]
["Manager Units",{"$f":"SUMIF($A$7:$A$32,\"Manager Unit\",$E$7:$E$32)","v":0},{"$f":"B40/$F$33","v":{"$error":"#DIV/0!"}},null,"Manager Unit Bedrooms:",{"$f":"SUMIF($A$7:$A$32,\"Manager Unit\",$G$7:$G$32)","v":0},{"$f":"F40/$G$33","v":{"$error":"#DIV/0!"}}]

{"sheet":"B. HmOwnr Fund Reconciliation","index":5,"n_rows":50,"n_cols":32,"rows_kept":50,"cut":false,"hidden":true,"merged":[[0,0,0,18],[1,0,1,1],[44,8,44,10],[45,8,45,10],[46,8,46,10],[4,2,5,2],[4,12,5,12],[4,14,5,14],[4,17,5,17],[4,10,5,10],[4,11,5,11],[4,9,5,9],[2,20,3,26],[2,0,2,18],[3,0,3,18],[4,0,5,0],[4,1,5,1],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,13,5,13],[4,23,5,23],[4,16,5,16],[4,15,5,15],[4,24,5,24],[4,25,5,25],[4,26,5,26],[41,8,41,10],[42,8,42,10],[43,8,43,10],[41,11,41,16],[4,20,5,20],[4,21,5,21],[4,22,5,22]]}
[]
["STATE OF CALIFORNIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
["Local Housing Trust Fund Request For Funds Reconciliation      \nBorrower Summary/Client List for Advances and Reimbursements                                                                                                                                ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCD Use Only"]
["Grantee must provide loan documentation to the Department for review and approval on all construction, permanent and homebuyer/homeowner loan projects. \nPlease do not remove previous draw information from this sheet. "]
["Draw #","Loan Type","Advance or Reimbursement","Name of Project or Primary Borrower","Project or Property Street Address","Project or Property City","Project or Property Zip Code","Loan or Advance Status","Closing Date","Project Type","Eligible Use","LHTF Loan Amount","Match Amount on Deposit","Admin Reimbursement","ELI Unit Cost","LI Unit Cost","Moderate Unit Cost","Total Program and Matching Funds ","Remaining Contract Funds Available ($)",null,"Advanced Funds","Advanced Funds Reconciled","Drawn Total","Verified Usage","Verified Total","Total % Drawn","Verified Total % Drawn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L7+M7,0)","v":0},{"$f":"S6-R7","v":{"$error":"#REF!"}},null,{"$f":"IF(OR($C7=\"Advance\",$C7=\"Advance-PDL or ADF\"),R7,\"$0\")","v":"$0"},{"$f":"IF(AND(H7=\"Closed\",OR(C7=\"Advance\",C7=\"Advance-PDL or ADF\")),\"YES\",\"NO\")","v":"NO"},{"$f":"U7","v":"$0"},{"$f":"IF($H7=\"Closed\", $R7,\"$0\")","v":"$0"},{"$f":"X7","v":"$0"},{"$f":"W7/$S$6","v":{"$error":"#REF!"}},{"$f":"Y7/$S$6","v":{"$error":"#REF!"}},null,null,null,null,"Open/Pending"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"S7-R8","v":{"$error":"#REF!"}},null,{"$f":"IF(OR($C8=\"Advance\",$C8=\"Advance-PDL or ADF\"),R8,\"$0\")","v":"$0"},"NO",{"$f":"U8+U7","v":0},"$0",{"$f":"X8+X7","v":0},{"$f":"W8/$S$6","v":{"$error":"#REF!"}},{"$f":"Y8/$S$6","v":{"$error":"#REF!"}},null,null,null,null,"Closed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"S8-R9","v":{"$error":"#REF!"}},null,"$0","NO",{"$f":"U9+W8","v":0},"$0",{"$f":"X9+Y8","v":0},{"$f":"W9/$S$6","v":{"$error":"#REF!"}},{"$f":"Y9/$S$6","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",{"$f":"X10+Y9","v":0},{"$f":"W10/$S$6","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,"Reimbursement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",{"$f":"X11+Y10","v":0},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,"Advance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",{"$f":"X12+Y11","v":0},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",{"$f":"X13+Y12","v":0},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",{"$f":"X14+Y13","v":0},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,"MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,"OOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,"PDL-MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,"ADU/JADU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,"TA-SELF-HELP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L39+M39,0)","v":0},{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L40+M40,0)","v":0},{"$error":"#REF!"},null,"$0","NO",0,"$0",0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"SUM(L7:L40)","v":0},{"$f":"SUM(M7:M40)","v":0},{"$f":"SUM(N7:N40)","v":0},{"$f":"SUM(O7:O40)","v":0},0,0,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Eligible Project Type\nper LHTF Guidelines §101 (g) ",null,null,"Total Contract Funds by Project and Income Restriction",null,null,null,null,null,null,"Remaining Balance"]
[null,null,null,null,null,null,null,null,null,null,null,"Extremely Low Income","Low Income","Moderate Income","Admin","LHTF Total","Match Amount","Grand Total"]
[null,null,null,null,null,null,null,null,"Rental Housing Projects including Permanent Supportive Housing",null,null,{"$f":"SUM(SUMIFS($O$7:$O$40,$J$7:$J$40,\"Rental Housing Projects including Permanent Supportive Housing\"))","v":0},{"$f":"SUM(SUMIFS($P$7:$P$40,$J$7:$J$40,\"Rental Housing Projects including Permanent Supportive Housing\"))","v":0},{"$f":"SUM(SUMIFS($Q$7:$Q$40,$J$7:$J$40,\"Rental Housing Projects including Permanent Supportive Housing\"))","v":0},{"$f":"SUMIFS($N$7:$N$40,$J$7:$J$40,\"Rental Housing Projects including Permanent Supportive Housing\")","v":0},{"$f":"SUM(L44:O44)","v":0},{"$f":"SUMIFS($M$7:$M$40,$J$7:$J$40,\"Rental Housing Projects including Permanent Supportive Housing\")","v":0},{"$f":"SUM(P44:Q44)","v":0},{"$f":"S40","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Emergency Shelter or Transitional Housing",null,null,{"$f":"SUM(SUMIFS($O$7:$O$40,$J$7:$J$40,\"Emergency Shelter or Transitional Housing\"))","v":0},{"$f":"SUM(SUMIFS($P$7:$P$40,$J$7:$J$40,\"Emergency Shelter or Transitional Housing\"))","v":0},{"$f":"SUM(SUMIFS($Q$7:$Q$40,$J$7:$J$40,\"Emergency Shelter or Transitional Housing\"))","v":0},{"$f":"SUMIFS($N$7:$N$40,$J$7:$J$40,\"Emergency Shelter or Transitional Housing\")","v":0},{"$f":"SUM(L45:O45)","v":0},{"$f":"SUMIFS($M$7:$M$40,$J$7:$J$40,\"Emergency Shelter or Transitional Housing\")","v":0},{"$f":"SUM(P45:Q45)","v":0}]
[null,null,null,null,null,null,null,null,"Homeownership Projects",null,null,{"$f":"SUM(SUMIFS($O$7:$O$40,$J$7:$J$40,\"Homeownership Projects\"))","v":0},{"$f":"SUM(SUMIFS($P$7:$P$40,$J$7:$J$40,\"Homeownership Projects\"))","v":0},{"$f":"SUM(SUMIFS($Q$7:$Q$40,$J$7:$J$40,\"Homeownership Projects\"))","v":0},{"$f":"SUMIFS($N$7:$N$40,$J$7:$J$40,\"Homeownership Projects\")","v":0},0,{"$f":"SUMIFS($M$7:$M$40,$J$7:$J$40,\"Homeownership Projects\")","v":0},0]
[null,null,null,null,null,null,null,null,"ADU/JADU",null,null,{"$f":"SUM(SUMIFS($O$7:$O$40,$J$7:$J$40,\"ADU/JADU\"))","v":0},{"$f":"SUM(SUMIFS($P$7:$P$40,$J$7:$J$40,\"ADU/JADU\"))","v":0},{"$f":"SUM(SUMIFS($Q$7:$Q$40,$J$7:$J$40,\"ADU/JADU\"))","v":0},{"$f":"SUMIFS($N$7:$N$40,$J$7:$J$40,\"ADU/JADU\")","v":0},0,{"$f":"SUMIFS($M$7:$M$40,$J$7:$J$40,\"ADU/JADU\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L44:L47)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Percentage Drawn to Date:",{"$f":"L48/P48","v":{"$error":"#DIV/0!"}},{"$f":"M48/P48","v":{"$error":"#DIV/0!"}},{"$f":"N48/P48","v":{"$error":"#DIV/0!"}},{"$f":"O48/P48","v":{"$error":"#DIV/0!"}},{"$f":"P48/P48","v":{"$error":"#DIV/0!"}},{"$f":"Q48/P48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Percentage of Total Award:",{"$f":"L48/$S$6","v":{"$error":"#REF!"}},{"$f":"M48/$S$6","v":{"$error":"#REF!"}},{"$f":"N48/$S$6","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Drop Down Menus","index":6,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Eligible Use"]
["Construction"]
["Rehabilitation"]
["Conversion"]
["Repair"]
["Reconstruction"]
["Purchase"]
[]
["Eligible Project"]
["Rental Housing Projects including Permanent Supportive Housing"]
["Emergency Shelter or Transitional Housing"]
["Homeownership Projects"]
["ADU/JADU"]
[]
["Loan Type"]
["Construction Loan"]
["Permanent Financing Loan"]
["Both Const/Perm"]
[]
["Match Source"]
["Residential Impact Fees"]
["Residential In-Lieu Fees"]
["Commercial Impact Fees"]
["Commercial In-lieu Fees"]
["Special Taxes (i.e. Hotel tax)"]
["General Obligation Bond"]
["Public General Fund Contribution"]
["Private Donation"]
["Repayments of HTF Loans"]
["Permanent Local Housing Allocation (PLHA)"]
[]
["Restricted Unit"]
["ELI (up to 30% AMI)"]
["LI (30%-80% AMI)"]
["Mod (80%-120% AMI)"]
["120% AMI and above"]
["Not Restricted"]