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.

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: Tool contains, in "Access Additional Tools", a Mainstream-specific TYT, allowing PHAs to analyze their Mainstream programs.

*NOTE 2: Tool contains, on the "Projection Analysis" tab, the second round of Admin fees (Cell L20) and a quick reference on PUC movement (Cell E20) for the PUC Increase Category in PIH 2020-17.

If you have any issues or questions, please contact Patrick Hatch (

This is an overview of potential routes a PHA may pursue to try and increase the success rate of issued vouchers.

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 (with a special two-page bonus PBV/RAD PDF where applicable) and 2) a "PIC Drill-Down" report that allows the user to analyze tenant-level data in PIC.