Web-Based Affordable Housing Calculator Developed in Cooperation with HousingWorks Austin
January 24, 2023
Developed by Aodhan Hemeon-McMahon, in cooperation with Housing Works Austin and ULI Austin’s Affordability Strategic Council, the Affordability Calculator is designed to help policymakers and other Affordable Housing stakeholders understand the financial viability of proposed affordable housing developments.
The tool allows users to input specific development assumptions and an Austin zip code to see if a development would be considered financially feasible for an investor. The tool does this by comparing the return generated from the user’s inputs to an internal rate of return (IRR) “hurdle”. Users can then add subsidy assumptions and/or apply a property tax abatement to push the returns over the hurdle, if necessary.
Instructions:
- Change any of the yellow cells understand whether the project is financially feasible, such as:
- The ZIP Code that your hypothetical development would be located within to (the cell will only accept valid Austin ZIP Codes);
- Development specifications, such as number of units, the bedroom mix in the units, the IRR (internal rate of return) hurdle;
- And any further funding through property tax abatement or subsidies available to the development.
- You can also change other development assumptions on the right side of the spreadsheet, which are automatically populated with base assumptions using current real estate averages, but can be adjusted depending on the specifics you want to project in your hypothetical development.
To learn more about how to use the Affordability Calculator and see the base assumptions and specific sources used to inform them, read the Affordability Calculator Description & Sources document here.