Thanks to John O’Gorman for converting the NAMA PDF of foreclosed properties to spreadsheet format. The spreadsheet is of the latest NAMA foreclosure list published last week and has been uploaded to Google docs here. The spreadsheet format should allow you to sort the data and make more sense out of what NAMA is doing.
What do we learn? Out of the 1,054 properties that have been foreclosed, 668 are currently not for sale. We see that accountancy firms that did very well indeed out of the boom, are also doing very well during the bust with KPMG involved in 133 receiverships, PwC in 108 and Ernst and Young with 34. We can see that of the 1,054 properties foreclosed 341 are multiple units, that might indicate two apartments or an estate of 100 homes, so we have difficulty seeing how many properties NAMA now controls via receivers. We can see NAMA has appointed receivers to 33 farms (or more accurately, property termed “agricultural land”) and 24 hotels, a staggering 52 pubs and 73 retail properties of which 34 are “multiple units”. Here are four selected analyses from the data, which is only possible by being able to sort the data.
Firstly, we have the type of property and whether the property is a single or multiple unit.
Secondly the location of the property – this will be updated later when the Northern Ireland data is more properly cleaned.
Thirdly the receivers appointed to the property.
And lastly the sales agents.
It is hoped that future foreclosure lists from NAMA will be converted to spreadsheet data as the lists are published. NAMA had said it had intended publishing the data in manipulable format seven months ago.
UPDATE: 7th February, 2012. The data in the spreadsheet has been “cleaned” further, so that Northern Ireland entries no longer have the asset description appended to the country. The update version of the spreadsheet is here. And this is an extract of the data.
NAMA Wine Lake 