I have compiled the latest end of April 2021 FHA servicing data for Oregon into a workbook with three worksheets HERE and embedded below.
The second worksheet combines three HUD Neighborhood Watch sub reports into one worksheet that contains a servicing summary, loss mitigation, and loss mitigation incentive claims data. Filters are in place by default so users may select or sort on individual columns to find , for example, the servicer with the largest number of serious delinquencies, the highest serious delinquent rate, etc.
The FIRST worksheet is a PIVOT table of the data worksheet. The default view in the pivot table are these statewide counts:
- All active loans (63,302)
- 90 day delinquencies (5,547) [5,547/63,302=8.8% serious delinquency rate)
- Foreclosure actions (58)
- Loss mitigation incentive claims paid (2,224)
- Forbearance claims paid (3)
To see information on individual servicers, users can pull down the servicer name in the field at the top of the pivot table or drag it into the Pivot table to see all servicers.
The third worksheet is a vertical listing of all of the data fields in the first worksheet and the HUD Neighborhood Watch sub report from which the data field is associated.
Note: I had previously downloaded the Oregon March 31st servicing data; the April 30 serious delinquency rate of 8.8% is down from the March rate of 9.1%.
<
Originally created and posted on the Oregon Housing Blog.
No comments:
Post a Comment