{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Formula Only"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Formula Only","index":0,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[12,1,12,4],[13,1,13,4],[14,1,14,4],[19,5,23,5],[19,11,23,11],[19,6,23,6],[19,7,23,7],[8,1,8,4],[9,1,9,4],[10,1,10,4],[15,1,15,4],[16,1,16,4],[11,1,11,4],[19,9,23,9],[19,10,23,10],[19,12,23,12],[47,1,47,12],[48,1,48,12],[19,8,23,8],[19,1,23,1],[19,2,23,2],[19,3,23,3],[19,4,23,4]],"flags":["formulas_cached_only"]}
["Capital Fund Financing Program (CFFP)",{"$nulls":5},"U.S. Department of  ",{"$nulls":5}," OMB Approval No. 2577-0157"]
["Periodic Payment Debt Service Schedule -- Formula Funds Only",{"$nulls":5},"Housing and Urban Development",{"$nulls":5}," (exp. 1/311/2017)"]
[]
[]
[]
[]
[]
[]
[null,"Housing Authority Name:"]
[null,"Amount of Proceeds:"]
[null,"Interest Rate (or range of rates if multiple serial or term bonds)"]
[null,"Interest Rate Fixed?"]
[null,"If Variable Rate, Interest Rate Cap:"]
[null,"Term (in years):"]
[null,"FY and Amount of Most Recent Formula Grant:"]
[null,"First Direct HUD Payment due:"]
[null,"D/S Schedule Date:"]
[]
[null,"(a)","(b)","(c) ","(d) ","(e)","(f)","(g)","(h)","(i)","(j)","(k)","(l)"]
[null,"Financing Year","Payment Date","Principal","Interest","Total Debt Service Payment","Ongoing Fees","Total Payment Amount","Adjusted Formula Grant","Total Payment from FY Grant","Percent of FY Grant Used for Payments","Date of Direct Payment of Formula Grant","FY of Grand Debt Service to be Paid From"]
{"$rows_empty":21}
[null,"TOTALS"]
[]
[]
[null,"Instructions: "]
[null,"1. Fill in the requested information for each year of the bond term."]
[null,"2. Column (f) should include any fees (such as remarketing, trustee, draw fees, etc).  Please provide a supporting schedule detailing the Ongoing Payment Requirements"]
[null,"3. Column (h): if the amount of the Formula Grant is anticipated to change due to demolition, disposition, etc., the most recent year's appropriation, net any applicable adjustments projected by the PHA should be used. PHA must use the most recent CFP Grant as basis for estimate. "]
[null,"4. Column (i) should be the sum of all payments reflecting in column (g) that are to be paid from a specific grant. "]
[null,"5. Columns (i), (J) and (l) must tie into each other. "]
[null,"6. Column (k): information regarding direct payments must only be provided if PHA is requesting that HUD make direct payments to Trustee or Lender. Direct payment may be initiated no more than three business days prior to when payment is due. "]
[null,"Payments scheduled to be initiated on weekends or holidays will not be initiated until the following business day."]