Friday, April 22, 2016

Excel of the Barry Apartment Report Listing of Proposed, Under Construction, and Recently Completed PDX Apartments.

I highly recommend the Barry Apartment reports web site as it provides a wealth of data about apartment sales and construction activity in the Portland metro area. 

Their Spring 2016 Construction reports were recently published; a summary and a complete listing are available in PDF formats. (Their Spring 2016 Apartment Report is also out HERE).

I took the complete listing and was able to paste it into Excel HERE and embedded below. I added a pivot table worksheets and one column based on their Notes column to ID projects identified as subsidized or homeless or related to the Portland Housing Bureau. 

Workbook opens to a summary by phase and by city and on second page by subarea. You likely will have to scroll right or down to see all the data.

[I note some minor unit count/project count discrepancies between my Excel and source document, but have been unable to find any errors in my Excel doc to date]. 

Some observations on completed, proposed, and under construction units:

  • 70% of units are located in the City of Portland
  • 28% of the units are located in the near Westside of Portland
  • There are 566 total units shown as subsidized.

Originally created and posted on the Oregon Housing Blog

Tuesday, April 19, 2016

Monday, April 18, 2016

4 Presidential Candidates: Their Income Tax Housing Subsidies VS. HUD Average Expenditure Per Voucher Household.

To celebrate tax day I thought it might be interesting to see how the current presidential candidates benefit from housing tax deductions for mortgage interest and real estate taxes compared to what HUD spent on average for voucher holders in their states. 

The Excel workbook HERE and embedded below contains a graph on page one with an abbreviated table and a complete set of data on page 2. (You may have to scroll or download the Excel file to see the second page).

I pulled the MID and real estate tax figures for 2014 from the candidate's posted tax returns. I had to estimate those figures as a percentage of the total itemized deductions for both Cruz and Kasich as they have NOT included their itemized deduction worksheets in their posted returns. I used 67% the same percentage as Sanders. And of course, Trump data is NOT included as his returns are not posted on line.

I pulled the HUD average voucher holder for each candidate's state from the HUD Picture of Subsidized Households.

Some observations

  • The lowest income of the candidates was $205K (Sanders) but ALL received substantial housing tax subsidies. (The average voucher income in these 4 states ranged from $11k-$16k).
  • The range of monthly subsidies vs the federal income tax system varied from Sanders receiving  $424 per month to Clinton who received a housing subsidy of $4,351 per month.  
  • The candidates housing tax subsidies were from 54% (Sanders) to 474% (Clinton) of the average HUD expenditure for voucher holders in their state. All candidates except Sanders got MORE in housing tax subsidies than the HUD subsidy received by the average voucher holder in their state.
  • My computations only calculate federal tax subsidies for housing, candidates in states with income taxes also likely receive state income tax benefits for the MID and real estate taxes.  
  • Some of the housing tax subsidies likely came from second homes.

Originally created and posted on the Oregon Housing Blog.

Wednesday, April 13, 2016

A First: Side by Side Comparison of Voucher Tenant Demographics For 39 HUD Moving to Work Agencies.

Surprisingly there is very little data out there about the demographics of voucher tenants who receive assistance from the 39 HUD approved MTW agencies, including 6 NW PHA's. 

I had to dig to put together a list of the MTW agencies in order to extract data from the HUD Picture of Subsidized Households but I eventually did and the result is in the Excel workbook HERE and embedded below. (A codebook for values in the Picture is HERE). 

Users can select up to 15 MTW agencies at a time for comparison, and change the 7 columns to see different voucher metrics; the top row is restricted to showing the US totals [for ALL PHA's] and the columns are conditionally formatted to highlight in yellow to show values BELOW the US totals. The last 6 PHA's selected by default are NW MTW PHA's.

A graph on the second page shows values for the 4th column, set us as the minority % of voucher holders by default.

To see all the columns you likely will have to scroll to the right, to use the pull downs you will likely need to download the Excel file. 

Two Examples: % of Voucher Tenants Who are Minority; HUD Monthly Payment
The table shows that the % of voucher holders who are minorities is 68% for ALL PHA's in the US , but among the 15 MTW PHA's I selected the low is 22% in Vancouver and the high is 98% in both the District of Columbia and Atlanta. 

Similarly, nationally the average HUD monthly payment is $775, but among the MTW agencies I selected the average ranges from a low of $685 in Portland to a high of $1,581 per month in Cambridge, MA.

Originally created and posted on the Oregon Housing Blog

Tuesday, April 12, 2016

A First: Side by Side Comparison of Housing Voucher Metrics from 49 Oregon AND Washington PHA's.

The HUD Picture of Subsidized Households provides a wealth of data on the demographics of HUD tenants.   The focus of this post is the Housing Voucher program. 

I downloaded data for vouchers for all US PHA's and then extracted Oregon and Washington PHA data into an Excel workbook HERE and embedded below. 

To make the data easy to use I constructed a worksheet that allows side by side comparisons, including

  • Selection of up to 10 PHA's at a time. [There are 49 Oregon and Washington PHA's from which to choose].
  • Selection of up to 7 metrics at a time [There are more than 50 metrics from which to choose].
  • A graph showing a visual comparison of the 4th metric selected. [Scroll down to page 2 to see].
  • Conditional formatting showing the high and low values for each metric selected (for the PHA's selected). 

[To view all columns in the worksheet you will have to scroll right, to use the pull downs you likely will have to download the Excel workbook]. 

Examples: Minority and Female Heads of Household % Comparisons
The default metrics selected includes the % of minority households served by the voucher program. From the 10 PHA's I selected you can see that Central Oregon PHA has the lowest % (9%) while the Seattle housing authority has the highest % (63%). 

Similarly, the data for the PHA selections I made show that the highest percentage of voucher holders headed by women is 79% in Clackamas county and the low is 59% in Seattle. 

Originally created and posted on the Oregon Housing Blog