{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Instructions","Data Entry Sheet","CFFP ACC Amend Attach"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":"Instructions","index":0,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Instructions for Completing Portfolio Schedule for Capital Fund Financing Proposal"]
[]
[null,"Note:  All data entry is performed on the \"Data Entry Sheet\", this sheet is used by HUD staff during their review.  The data is linked to the \"CFFP ACC "]
[null,"Amendment Attach sheet  which will be attached to the CFFP ACC Amendment as part of the HUD Approval letter package."]
[]
["(1)           Enter name of Public Housing Authority."]
[]
["(2)           Enter number of Public Housing Authority."]
[]
["(3)           Enter Data the Capital Fund Financing Proposal is being submitted."]
[]
["(4)           Indicate any anticipated changes to the portfolio that would either increase or decrease the total units, and therefore affect the formula capital funds.  "]
["This calculation should also feed into the Adjusted Capital Fund estimate in the Term Sheet, and the debt services schedule.  On Line (a), indicate whether "]
["any units or properties will be demolished or disposed of, with a “Yes” or a “No”.  On Line (b), indicate whether units will be merged into larger units either "]
["through the CFFP or otherwise, responding with a “Yes” or a “No”.  On Line (c) indicate whether new units will be developed and placed under the ACC, "]
["responding with a “Yes” or a “No”.  On Line (d) indicate any other anticipated change in unit count.  Select from the Drop Down menu, which includes:  "]
["Conversion (Mandatory, Required, Voluntary, Other); HOPE VI Demolition; HOPE VI Revitalization; Homeownership Sales; Casualty Condemnation; "]
["Asset Management [AMPS that are not economically viable that the PHA does not want to, or cannot, sustain]; or other.  "]
[]
["(5)           Enter the Fiscal Year of the Most Recent Capital Fund Grant received by the PHA.  Use four digits (e.g., 2005).  "]
[]
["(6)           Enter the year of Capital Fund funding that will be used to make the first debt service payment.  Use four digits (e.g., 2005).  "]
[]
["(7)           On the rows under this heading, List the HUD Project Number for each public housing development in the PHA’s portfolio.  "]
[]
["(8)           On the rows under this heading, List the Project Name that corresponds to the Project Number.  All existing projects must be included on the form.  "]
["Insert additional rows to the extent needed to."]
[]
["(10)       Enter the Capital Funding per unit.  Note:  HUD will provide you a per unit funding schedule showing the per-unit funding amount from prior grants."]
[]
["(11)       Estimated annual Capital Funding per Project is calculated by a formula.  "]
[]
["(12)       Enter any notes of explanation, if needed."]
[]
["(13)       Subtract any capital funds that need to be used for purposes other than housing authority operations, such as a Voluntary Compliance Agreement (VCA), "]
["a Consent Decree, or Litigation.  The drop down menu will allow you to identify the nature of the reduction.  In column (E), indicate the amount of the reduction "]
["as a negative number so that it is deducted from the total.   Insert as many additional rows for as needed to enter all relevant data."]
[]
["(14)       Sign Certification that the information is accurate to the best of the PHA’s knowledge, and that the data for existing units agrees with data in PIC.  "]
["This form must be signed by the PHA’s chief executive officer."]

{"sheet":"Data Entry Sheet","index":1,"n_rows":42,"n_cols":60,"rows_kept":42,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Capital Fund Financing Program",{"$nulls":6},"U.S. Department of Housing",{"$nulls":9}," OMB Approval No. 2577-0157",{"$nulls":4},"U.S. Department of Housing",{"$nulls":5}," OMB Approval No. 2577-0208"]
["Portfolio Schedule Form",{"$nulls":6},"and Urban Development",{"$nulls":9}," (exp. 11/2008)",{"$nulls":4},"and Urban Development",{"$nulls":5}," (exp. 11/2008)"]
[{"$nulls":7},"Office of Public and Indian Housing",{"$nulls":14},"Office of Public and Indian Housing"]
{"$rows_empty":7}
["(1) PHA Name",{"$nulls":27},0]
["(2) PHA Number",{"$nulls":27},0]
["(3) Date Submitted",{"$nulls":27},"00:00:00"]
["Person Completing Form/ Contact Person"]
["Contact Phone Number"]
["e-mail"]
["(4) Portfolio Changes Planned"]
["(a) Demolition or Disposition"]
["(b) Unit Consolidation or Merger"]
["(c) New Development with approved development proposal"]
["(d) Other (select from List)"]
["(5) FY of Most Recent Capital Fund Grant"]
["(6) 1st Year of CFP for Debt Service Payment"]
["(7) HUD Project Number","(8) Project Name","(9) Number of Units Under ACC","(10) Cap Fund Per Unit Funding","(11) Projected Funding by Development","(12) Comments",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"Total Units Removed",{"$nulls":11},0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["(13) LESS any Reductions","Consent Decree",{"$nulls":26},"Less any reductions",{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LESS any Reductions","Consent Decree",{"$nulls":26},"Less any reductions",{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Units",null,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Capital Funds",null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"I, the undersigned, hereby certify that the existing and projected number of units are true and correct to the best of the PHA's knowledge, and that the numbers for existing units agree with data in PIC."]
[null,null,"Signature:",null,null,"Title:","Date:"]
[]
[{"$nulls":17},"form HUD-52830 (11/2008)",{"$nulls":10},"form HUD-52830 (11/2008)"]

{"sheet":"CFFP ACC Amend Attach","index":2,"n_rows":39,"n_cols":60,"rows_kept":39,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Capital Fund Financing Program",{"$nulls":8},"U.S. Department of Housing",{"$nulls":7}," OMB Approval No. 2577-0157",null,null,null,"U.S. Department of Housing",{"$nulls":5}," OMB Approval No. 2577-0157"]
["Portfolio Schedule Form",{"$nulls":8},"and Urban Development",{"$nulls":7}," (exp. 11/2008)",null,null,null,"and Urban Development",{"$nulls":5}," (exp. 11/2008)"]
[{"$nulls":9},"Office of Public and Indian Housing",{"$nulls":11},"Office of Public and Indian Housing"]
[]
[]
[]
[]
[]
[]
["(1) PHA Name",{"$nulls":27},0]
["(2) PHA Number",{"$nulls":27},0]
["(3) Date Submitted",{"$nulls":27},"00:00:00"]
["Person Completing Form/ Contact Person"]
["Contact Phone Number"]
["e-mail"]
["(4) Portfolio Changes Planned"]
["(a) Demolition or Disposition"]
["(b) Unit Consolidation or Merger"]
["(c) New Development with approved development proposal"]
["(d) Other (select from List)"]
["(5) FY of Most Recent Capital Fund Grant"]
["(6) 1st Year of CFP for Debt Service Payment"]
["(7) HUD Project Number","(8) Project Name","(9) Number of Units Under ACC","(10) Cap Fund Per Unit Funding","(11) Projected Funding by Development","(12) Comments",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"Total Units Removed",{"$nulls":11},0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["(13) LESS any Reductions","Consent Decree",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Less any reductions",{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LESS any Reductions","Consent Decree",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Less any reductions",{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Units",null,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Capital Funds",null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"I, the undersigned, hereby certify that the existing and projected number of units are true and correct to the best of the PHA's knowledge, and that the numbers for existing units agree with data in PIC."]
[null,null,"Signature:",null,null,"Title:","Date:"]