{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Annual Summary no RHF","Monthly Detail no RHF"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Annual Summary no RHF","index":0,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[10,1,10,2],[11,1,11,2],[12,1,12,2],[71,1,71,5],[13,1,13,2],[14,1,14,2],[15,1,15,2]],"flags":["formulas_cached_only"]}
["Capital Fund Financing Program (CFFP)",null,null,"U.S. Department of Housing ",null,null," OMB Approval No. 2577-0157"]
["Monthly Debt Service Schedule -- Formula Funds Only",null,null,"and Urban Development ",null,null," (exp. 01/17/2017)"]
["Part A: Annual Summary "]
[]
[]
[]
[]
[]
[]
[null,"Requested Information"]
[null,"Housing Authority Name:"]
[null,"Loan Amount: "]
[null,"Interest Rate:"]
[null,"Interest Rate Fixed?"]
[null,"If Variable Rate, Interest Rate Cap:"]
[null,"Term (in years):"]
[null,"Loan Payments Per Year:"]
[null,"FY and Amount Most Recent Formula Grant:"]
[null,"First HUD Direct Payment Date:"]
[null,"D/S Schedule Date:"]
[]
[null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[null,"Fiscal Year","Principal","Interest","Total Debt ","Adjusted Formula","DS as %"]
[null,"of Grant","Amount","Amount","Service Payment","Grant","of CF"]
{"$rows_empty":20}
[null,"TOTALS"]
[]
[]
[]
[]
[]
["     "]
{"$rows_empty":17}
[null,"Instructions:"]
[null,"1. Fill in the requested information by fiscal year of CFP grant used for debt service."]
[null,"2. If there are on-going fee associated with the transaction, then they must be reflected in the schedule submitted. "]
[null,"3. Column (e): if the PHA has plans which would impact the amount of the CFP, such as demolition or other activities, the most recent year's appropriation, net of any applicable adjustments should be used.  See the term sheet for further guidance."]

{"sheet":"Monthly Detail no RHF","index":1,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,1,60,6],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,10,6],[59,1,59,6]],"flags":["formulas_cached_only"]}
["Capital Fund Financing Program (CFFP)",null,null,"U.S. Department of Housing "]
["Monthly Debt Service  -- Formula Funds Only",null,null,"and Urban Development "]
["Part B: Monthly Detail"]
[]
[]
[null,"PHA:______________________________________"]
[]
[null,"(a)","(b)","(c) ","(d) ","(e)","(f)"]
[null,"Payment Date ","Principal","Interest","Total Debt Service Payment","Direct Payment of Formula Grant Date","FY of Grant Debt Service is to Paid From"]
{"$rows_empty":43}
[null,"TOTALS"]
[]
[]
[]
[]
[null,"Instructions: "]
[null,"1. Fill in information for each payment and with an annual subtotal. "]
[null,"2. Debt service should be shown as being paid from the debt service reserve or capitalized interest account only to the extent that it is provided for in the loan documents."]
[null,"3. Column (e): information regarding direct payments must only be provided if PHA is requesting that HUD make direct payments to Lender.  direct payment may be initiated no more than three business days prior to when payment is due. Payments scheduled to be initiated on weekends or holidays will not be initiated until the following business day."]