In order to estimate a potential yield from a property tax based on value bands, an estimate of the share of properties that fall within each band is needed. As a data set of the values of all of Ireland’s property does not exist, a methodology for estimation must be formulated. In order to build conservatism into the yield forecast from the new local property tax, no single methodology was exclusively used for estimating a distribution of property values. Instead the yield was based on a blend of three approaches.
The first approach was based on the data used in the Thornhill Report updated to include regional variation in property prices. At the time of the Thornhill report a national register of prices of property transactions did not exist. As an alternative, the Central Statistics Office (CSO) provided the number of properties sold across a range of value bands of €50,000 increments for each of the years 2005 to 2009. The data was based on mortgage transactions and is an input into the CSO’s residential property price index (RPPI). Using the national change in values in the CSO RPPI from the year of the transaction to April 2012, a national distribution of property values in 2012 prices was constructed. This is the distribution published in the Thornhill Report (see Table 1 below). Regional variation was added to the Thornhill distribution using county level housing stock from census 2011 data (see Table 2), and regional variation in prices from the CSO RPPI. Three property price distributions were constructed; Dublin, national, and national excluding Dublin. This compares with one distribution in the Thornhill Report.
A weighted average property charge for each of the three regional distributions was constructed, weighted by the share of properties in each band. A county level yield was then calculated based on the number of properties in each county according to data from Census 2011 and the estimated weighted average charge. By summing over all counties a national yield was estimated. This approach results in a larger indicative yield than does the Thornhill approach due to a higher weighting of higher value properties in counties with larger volumes of properties (e.g. Dublin).
Counties were assigned one of the three constructed distributions. The four Dublin local authority areas were assumed to have a distribution in line with the Dublin price distribution, counties with large urban areas and counties adjacent to Dublin were assumed a have a price distribution in line with the national distribution and the remaining counties were assumed to be in line with the national distribution that excludes Dublin (see Table 3).
A weighted average property charge for each of the three regional distributions was constructed, weighted by the share of properties in each band. A county level yield was then calculated based on the number of properties in each county according to data from Census 2011 and the estimated weighted average charge. By summing over all counties a national yield was estimated. This approach results in a larger indicative yield to the Thornhill approach due to a higher weighting of higher value properties in counties with larger volumes of properties (e.g. Dublin).
The second approach used was similar but was based on data from the property price register. In autumn 2012, the Property Services Regulatory Authority published a national register of property prices (www.propertypriceregister.ie). The register includes the date of sale, price and address of all residential properties purchased in Ireland since 1 January 2010, as declared to the Revenue Commissioners for Stamp Duty purposes. The register is updated on an on-going basis. Data from the register were used to produce county level distributions as well as distributions in line with the three regional price indices published by the CSO, namely Dublin, national, and national excluding Dublin. These distributions are set out in Table 4.
The distribution from the register results in a higher incidence of higher value properties and a less peaked distribution to that in the Thornhill Report at values around €100,000 to €200,000 and an analysis based entirely on the register would result in a higher yield compared with the first approach described above. However, caution should be applied to solely relying on the register given the low number of transactions, the high percentage of non-mortgage (i.e. cash transactions) and the possible bias in recent transactions towards transactions of higher quality housing stock which may not represent the generality of housing valuations in the State.
The final method of estimation is based on the ESRI tax-benefit model SWITCH. In the SWITCH model, data on house prices come from the self-assessed value provided by the respondents to the Survey on Income and Living Conditions (SILC) in 2010 with these values indexed to adjust to 2012 prices. The SILC data are based on a sample of all private households, giving it the potential to provide a broader picture than one based on transactions or mortgages.
For each of the approaches described above an assumed deferral rate of 16% was applied. This is based on work by the Economic and Social Research Institute on behalf of the Thornhill Group.
Table 1: Thornhill Report and Property Price Register Distribution
Bands
|
Thornhill Report
|
Property Price Register
|
0-100000
|
7.20%
|
27.40%
|
100001-150000
|
33.70%
|
21.00%
|
150001-200000
|
32.00%
|
19.20%
|
200001-250000
|
14.90%
|
11.20%
|
250001-300000
|
6.21%
|
6.70%
|
300001-350000
|
2.72%
|
4.40%
|
350001-400000
|
1.37%
|
2.60%
|
400001-450000
|
0.72%
|
1.70%
|
450001-500000
|
0.39%
|
1.30%
|
500001-550000
|
0.23%
|
1.00%
|
550001-600000
|
0.12%
|
0.60%
|
600001-650000
|
0.10%
|
0.50%
|
650001-700000
|
0.07%
|
0.40%
|
700001-750000
|
0.03%
|
0.30%
|
750001-800000
|
0.03%
|
0.20%
|
800001-850000
|
0.03%
|
0.20%
|
850001-900000
|
0.02%
|
0.20%
|
900001-950000
|
0.03%
|
0.10%
|
950001-1000000
|
0.01%
|
0.10%
|
>1000000
|
<1%
|
1.00%
|
Total
|
100%
|
100%
|
Table 2: Number of households
Bands
|
Number of Households
|
Carlow
|
19,436
|
Cavan
|
25,818
|
Clare
|
42,648
|
Cork Co Co
|
140,856
|
Cork City
|
47,163
|
Cork Total
|
188,019
|
Donegal
|
57,964
|
Dublin City
|
208,008
|
Fingal
|
93,146
|
D-L Rathdown
|
75,819
|
South Dublin
|
90,019
|
Dublin Total
|
466,992
|
Galway Co Co
|
60,952
|
Galway City
|
27,726
|
Galway Total
|
88,678
|
Kerry
|
53,306
|
Kildare
|
70,763
|
Kilkenny
|
33,679
|
Laois
|
28,020
|
Leitrim
|
12,308
|
Limerick Co Co
|
47,282
|
Limerick City
|
22,367
|
Limerick Total
|
69,649
|
Longford
|
14,453
|
Louth
|
43,972
|
Mayo
|
48,070
|
Meath
|
62,201
|
Monaghan
|
21,264
|
Offaly
|
26,750
|
Roscommon
|
23,672
|
Sligo
|
24,525
|
North Tipperary
|
25,703
|
South Tipperary
|
32,794
|
Waterford Co Co
|
24,114
|
Waterford City
|
18,221
|
Westmeath
|
30,739
|
Wexford
|
52,652
|
Wicklow
|
47,798
|
Table 3: Thornhill Distribution with regional variation
Bands
|
National
|
Dublin
|
National excl Dublin
|
0-100000
|
10.20%
|
3.04%
|
8.87%
|
100001-150000
|
34.02%
|
26.26%
|
36.55%
|
150001-200000
|
29.55%
|
35.42%
|
30.90%
|
200001-250000
|
14.27%
|
16.64%
|
13.90%
|
250001-300000
|
5.70%
|
7.93%
|
5.52%
|
300001-350000
|
2.74%
|
3.86%
|
2.28%
|
350001-400000
|
1.40%
|
2.35%
|
1.04%
|
400001-450000
|
0.75%
|
1.44%
|
0.51%
|
450001-500000
|
0.46%
|
0.69%
|
0.23%
|
500001-550000
|
0.26%
|
0.30%
|
0.12%
|
550001-600000
|
0.09%
|
0.05%
|
0.05%
|
600001-650000
|
0.05%
|
0.67%
|
0.02%
|
650001-700000
|
0.00%
|
0.52%
|
0.01%
|
700001-750000
|
0.08%
|
0.08%
|
0.00%
|
750001-800000
|
0.17%
|
0.46%
|
0.00%
|
800001-850000
|
0.05%
|
0.20%
|
0.00%
|
850001-900000
|
0.11%
|
0.06%
|
0.00%
|
900001-950000
|
0.07%
|
0.04%
|
0.00%
|
950001-1000000
|
0.01%
|
0.00%
|
0.01%
|
>1000000
|
0.04%
|
0.04%
|
0.04%
|
Total
|
100%
|
100%
|
100%
|
Table 4: Property Price Register Distribution
Bands
|
National
|
Dublin
|
National excl Dublin
|
0-100000
|
27.40%
|
8.50%
|
37.60%
|
100001-150000
|
21.00%
|
15.90%
|
23.70%
|
150001-200000
|
19.20%
|
22.30%
|
17.50%
|
200001-250000
|
11.20%
|
14.50%
|
9.40%
|
250001-300000
|
6.70%
|
9.60%
|
5.20%
|
300001-350000
|
4.40%
|
7.40%
|
2.70%
|
350001-400000
|
2.60%
|
4.90%
|
1.40%
|
400001-450000
|
1.70%
|
3.30%
|
0.80%
|
450001-500000
|
1.30%
|
2.90%
|
0.40%
|
500001-550000
|
1.00%
|
2.20%
|
0.30%
|
550001-600000
|
0.60%
|
1.50%
|
0.20%
|
600001-650000
|
0.50%
|
1.10%
|
0.10%
|
650001-700000
|
0.40%
|
0.90%
|
0.10%
|
700001-750000
|
0.30%
|
0.80%
|
0.10%
|
750001-800000
|
0.20%
|
0.50%
|
0.10%
|
800001-850000
|
0.20%
|
0.50%
|
0.00%
|
850001-900000
|
0.20%
|
0.30%
|
0.10%
|
900001-950000
|
0.10%
|
0.30%
|
0.00%
|
950001-1000000
|
0.10%
|
0.20%
|
0.00%
|
>=1000000
|
1.00%
|
2.30%
|
0.20%
|
Total
|
100%
|
100%
|
100%
|