This file contains links to "bite-size" training videos for the HCV Tools found on this page.
This file contains step-by-step instructions for using the Two-Year Tool.
- HCV Two-Year Projection Tool (Updated 2/19/2020)
The objective of the Two-Year Tool (TYT) is to analyze a PHA's utilization situation which includes running basic leasing and spending scenarios to better inform decisions going forward in an effort to optimize the program over a multi-year period. There are many variables that affect a PHA's HCV program, some outside of a PHA's control and some that can be impacted by policies and operations; variables including Congressional funding, cost per unit trends, the rate at which participants leave the program (i.e. attrition rate), and the rate at which vouchers are successfully leased (including the time-to success).
Upon opening this tool, a PHA should enter the applicable five character PHA code (e.g. MA002), and click the "Open Two-Year Tool" button. This will create a Tool with all applicable information; you will first be asked to save this file to your computer. Depending on your version of Microsoft Office and your personal settings, you may need to enable editing/macros. Please see the "HCV Two-Year Tool Guide".
This file is updated continuously.
*NOTE 1: The Two-Year Tool will continue to operate with 2019 as Year 1 until final funding letters are sent - current estimate is late March. As such, to examine 2021, the "Years 3 & 4" tab will open by default. Remember, Year 3 (in the Tool) is 2021.
*NOTE 2: Based on feedback, the TYT now includes a breakout of the estimated reserves that are "protected" for any potential offset, i.e. how the Tool gets from estimated "12/31 Reserves" to "Excess Reserves Subject to Offset."
*NOTE 3: The Two-Year Projection Tool now includes an option to breakout a PHA's program into its main components, i.e. non-PBV versus PBV, and even, within PBV, RAD1 PBV versus non-RAD1 PBV. This will allow the user to more accurately project varying cost per unit, and other, trends based on voucher type. This can be found in "Access Additional Tools" and an explanatory video will be uploaded soon.
If you have any issues or questions, please contact Patrick Hatch (firstname.lastname@example.org).
This is an overview of potential routes a PHA may pursue to try and increase the success rate of issued vouchers.
- Tool of Tools (ToT) (Updated 2/19/2020)
This is a combination of two tools:
1) Payment Standard Tool (PST)
This tool helps a PHA determine the repercussions of potential future payment standard changes on both program costs AND participant rent burden.
Additional analytical tools (e.g. overhoused analysis) are available.
The instructions/guide are found within the Tool.
2) HCV Analysis Tool (HAT)
The output of the HAT is two-fold: 1) a four-page PDF with an overview of a PHA's voucher program, including PHA-to-state and PHA-to-country comparisons and 2) a "PIC Drill-Down" report that allows the user to analyze tenant-level data in PIC.