An Evaluation of Property Tax Regressivity in Franklin County, Ohio
Center for Municipal Finance
1 Introduction
The property tax is the single largest source of revenue for American local governments. Cities, counties, school districts, and special districts raise roughly $500 billion per year in property taxes, accounting for 72% of local taxes and 47% of locally raised revenue (U.S. Census Bureau 2016). Whether residents rent or own, property taxes directly or indirectly impact almost everyone.
In many cities, however, property taxes are inequitable; low-value properties face higher tax assessments, relative to their actual sale price, than do high-value properties, resulting in regressive taxation that burdens low-income residents disproportionately.
The standard approach for evaluating the quality and fairness of assessments is through a sales ratio study (International Association of Assessing Officers 2013). A property’s sales ratio is defined as the assessed value divided by the sale price. A sales ratio study evaluates the extent of regressivity in a jurisdiction, along with other aspects of assessment performance, by studying sales ratios for properties that sold within a specific time period. A system in which less expensive homes are systematically assessed at higher sales ratios than more expensive homes is regressive.
This report presents a basic sales ratio study for Franklin County, Ohio, based on data from CoreLogic. CoreLogic collects property data from assessors (and other sources) across the country. We use data for residential properties that sold between 2011 and 2019 (the most recent year available for this jurisdiction) and are classified as arm’s-length transactions by CoreLogic. For each home that sold, we compute the sales ratio as the assessed value in place on January 1 of the sale year divided by the sale price. For more details, see the Appendix.
2 Sales Ratio Analysis
The relationship between assessments and sale prices is regressive if less valuable homes are assessed at higher rates (relative to the value of the home) than more valuable homes. To evaluate regressivity in assessments, Figure 2.1 presents a binned scatter plot of sales ratios against sale prices.
For this graph, property sales have been sorted into deciles (10 bins of equal size based on sale price), each representing 10% of all properties sold. Each dot represents the average sale price and average sales ratio for each respective decile of properties. This graph compares the most recent values for 2019 (solid line) with the average across all years of observation from 2011 to 2019 (dashed line). All values were adjusted for inflation to 2019 dollars to facilitate comparisons.
If sale prices are a fair indication of market value and if assessments were fair and accurate, Figure 2.1 would be a flat line indicating that sales ratios do not vary systematically according to sale price. A downward sloping line indicates that less expensive homes are over-assessed compared to more expensive homes and is evidence of regressivity.
In 2019, the most expensive homes (the top decile) were assessed at 27.6% of their value and the least expensive homes (the bottom decile) were assessed at 28.8%. In other words, the least expensive homes were assessed at 1.04 times the rate applied to the most expensive homes. Across our sample from 2011 to 2019, the most expensive homes were assessed at 29.2% of their value and the least expensive homes were assessed at 36.3%, which is 1.24 times the rate applied to the most expensive homes.
Figure 2.1
Figure 2.2 shows the share of properties in each decile that were overassessed or underassessed. relative to the median rate of assessment. That is, a property is classified as overassessed if its sales ratio is above the median sales ratio for the jurisdiction, and classified as underassessed if its sales ratio is below the median. If errors were made randomly, each decile would have 50% of properties overassessed and 50% underassessed. When lower value homes are more likely to be overassessed than higher value homes, it is evidence of regressivity. In Franklin County, Ohio, 71% of the lowest value homes are overassessed and 43% of the highest value homes are overassessed.
Figure 2.2
3 Effective Tax Rates
Assessed values are the basis on which taxes are calculated, meaning that inequities in assessments will be transmitted into inequities in tax rates. In this section, we evaluate effective tax rates – a property’s tax bill divided by its sale price – according to sale price.
Importantly, the effective tax rate is the actual tax rate paid inclusive of exemptions or other tax breaks. Often, because exemptions are more likely to target low-valued properties, they may offset some of the increased taxation resulting from over-assessment. In other words, tax rates will often be somewhat less regressive than assessments. Tax rates also will vary widely based on municipal and school district boundaries. This section analyzes tax rates across the entire county. A brief analysis by school district, which roughly approximates a single taxing district, is also presented in the Appendix.
Consistent with Figure 2.1, in 2019, the most expensive homes (the top decile) had an effective tax rate of 1.90%, while the rate for the least expensive homes (bottom decile) was 1.84%, which is 0.97 times the rate applied to the most expensive homes. Across our sample from 2011 to 2019, the most expensive homes had an effective tax rate of 2.06% of their value and the least expensive homes had an effective tax rate of 2.43%, which is 1.18 times the rate applied to the most expensive homes.
Figure 3.1
Table 3.1
Table 3.1 presents a simple analysis of effective tax rate by sale decile (where sale decile 1 consists of the most inexpensive homes in this jurisdiction and 10 the most expensive). A property’s “fair” tax bill is the bill that would have been charged if the property was taxed at the average rate, and the “shift” is the difference between the fair bill and the actual bill. In 2019, the average effective tax rate in Franklin County, Ohio was 1.82%, 1.73%.
| Tax Year | Sale Decile | Effective Tax Rate | Average Sale | Average Tax Bill | Fair Tax Bill | Average Shift |
|---|---|---|---|---|---|---|
| 2019 | 1 | 1.84% | $59,163 | $1,074.21 | $1,048.27 | $25.94 |
| 2019 | 2 | 1.67% | $99,566 | $1,655.40 | $1,764.16 | -$108.76 |
| 2019 | 3 | 1.64% | $129,254 | $2,124.24 | $2,290.18 | -$165.93 |
| 2019 | 4 | 1.67% | $153,014 | $2,556.18 | $2,711.17 | -$154.98 |
| 2019 | 5 | 1.71% | $175,976 | $3,012.02 | $3,118.01 | -$105.99 |
| 2019 | 6 | 1.74% | $202,834 | $3,532.85 | $3,593.90 | -$61.05 |
| 2019 | 7 | 1.79% | $234,743 | $4,209.99 | $4,159.26 | $50.72 |
| 2019 | 8 | 1.84% | $274,667 | $5,066.23 | $4,866.65 | $199.58 |
| 2019 | 9 | 1.90% | $342,579 | $6,508.94 | $6,069.95 | $438.99 |
| 2019 | 10 | 1.90% | $574,017 | $10,829.66 | $10,170.66 | $659.00 |
For example, in 2019, the average property in the bottom decile sold for a price of $59,163 and had a tax bill of $1,074.21. If this property was taxed at the average rate of all other properties, its fair bill would be $1,048.27, meaning that the homeowner overpaid by $25.94, or 2.5% above the fair tax. Correspondingly, the average property in the top decile sold for $574,017 and had a tax bill of $10,829.66. If this property was taxed at the average rate of all other property, its fair bill would be $10,170.66, meaning that the homeowner overpaid by $659.00, or 6.5% above the fair tax.
4 Industry Standards
Sections 2 and 3 provide graphical evidence of regressivity in property assessments and taxes, but they do not provide a statistical evaluation. In this section, we report several standard statistics used in the evaluation of assessment quality.
The International Association of Assessing Officers (IAAO) defines standards for assessments including standards for uniformity and regressivity (International Association of Assessing Officers 2013). A detailed overview and definition of each measure can be found in the Appendix.
4.1 Coefficient of Dispersion (COD)
The COD is a measure of assessment uniformity, or horizontal equity. It is the average absolute percentage difference from the median sales ratio. For instance, a COD of 10 means that properties have ratios that on average deviate by 10 percent from the median ratio. The IAAO specifies that the acceptable range for COD is below 15, which is shaded in Figure 4.1. For 2019, the COD in Franklin County, Ohio was 15.62. Year-to-year changes in COD can also reveal changes assessment accuracy. In this case, assessments do not meet the IAAO standard for uniformity and are less accurate over the last two years.
Figure 4.1
4.2 Price-Related Differential (PRD)
The PRD is a measure of regressivity, or vertical equity. A PRD of 1 indicates that homes are assessed at the same rate regardless of their sale price. A PRD greater than 1 indicates that less expensive homes are assessed at higher rates than more expensive homes, while a PRD less than 1 represents the opposite situation. The IAAO specifies that the acceptable range of PRD is .98 to 1.03, which is depicted as the shaded region of Figure 4.2. In 2019, the PRD in Franklin County, Ohio, was 0.997 which meets the IAAO standard for vertical equity. PRD values are relatively unchanged over the last two years.
Figure 4.2
4.3 Coefficient of Price-Related Bias (PRB)
The PRB is another quantitative measure of regressivity (vertical equity) which is an alternative to the PRD. PRB is a measure of how much assessed values change as a property’s market value increases. The IAAO specifies that the acceptable range for PRB is between -0.05 and 0.05, which is depicted as the shaded region in the Figure 4.3. In 2019, the PRB in Franklin County, Ohio was 0.033 which indicates that sales ratios increase by 3.3% when home values double. This meets the IAAO standard. PRB values have been relatively relatively unchanged over the last two years.
Figure 4.3
5 Who is Over-Assessed?
By placing homes geographically within individual census tracts (“geocoding”), we are able to explore how assessments differ across geography. We are also able to correlate assessment rates with census demographics on the tract level.
5.1 Geographic Variation
In most jurisdictions, properties of different values are not randomly distributed but rather spatially clustered. If so, then regressivity in assessments will result in some neighborhoods of the jurisdiction being over-assessed and others under-assessed. The two maps below show the spatial distribution of sales ratios (Figure 5.1) and effective tax rates (Figure 5.2), respectively.
Figure 5.1
Figure 5.2
Note that tax rates may vary across jurisdictions for reasons unrelated to assessment quality.
5.2 Demographic Variation
When there are correlations between property values and demographics, assessment regressivity will result in differential taxation by demographics. This section presents a basic demographic profile of Franklin County, Ohio, based on the 2018 American Community Survey produced by the U.S. Census Bureau (Walker 2019a). Next is an analysis of the correlations between census demographics at the tract level and sales ratios and tax rates. Essentially, these correlations reveal whether properties in different sorts of neighborhoods experience different levels of assessment and taxation. It is important to emphasize that we do not have data on the demographics of individual property owners and so these tract-level demographic correlations do not necessarily imply that individual owners with different demographics are assessed or taxed differentially.
Table 5.2.1: A Demographic Profile of Franklin County, Ohio
| Total Population | 1,253,507 |
| Percent Non-White | 36% |
| Percent in Poverty | 17% |
| Percent Homeowners | 54% |
| Percent with Bachelor (or higher) | 39% |
| Per Capita Income | $31,199 |
| Median Age | 34 |
| Median Home Value | $158,400 |
| Median Home Value (State Rank) | 11th |
5.2.1 Demographic Correlates: Sales Ratios
Table 5.2.2 presents results from an analysis in which sales ratios are regressed against census tract demographics. Each row of the table represents the coefficient from a different bivariate regression of sales ratios against the census variable in question.
Table 5.2.2
An example interpretation of this table; a 1% increase in the percentage of individuals with a high school education is correlated with a 0.02% increase in sales ratio.
| Variable | Coefficient | P Value | Significance |
|---|---|---|---|
| Non-Hispanic White Population (Percentage Points) | 0.00% | 0.72 | Not Significant |
| Population in Poverty (Percentage Points) | -0.04% | 0.00 | Significant |
| Share of Homes Vacant (Percentage Points) | -0.11% | 0.00 | Significant |
| Share of Homeowners (Percentage Points) | 0.02% | 0.00 | Significant |
| Share of Single Unit Homes (Percentage Points) | 0.01% | 0.23 | Not Significant |
| Share in Same Home as Last Year (Percentage Points) | 0.05% | 0.00 | Significant |
| High School Education or Higher (Percentage Points) | 0.02% | 0.19 | Not Significant |
| College Education or Higher (Percentage Points) | -0.01% | 0.01 | Significant |
| Per Capita Income ($1000s) | 0.00% | 0.58 | Not Significant |
| Median Household Income ($1000s) | 0.01% | 0.12 | Not Significant |
| Median Age (Years) | 0.05% | 0.00 | Significant |
| Median Home Value ($1000s) | 0.00% | 0.15 | Not Significant |
Figure 5.2.1 presents binned scatterplots of the average assessment rate by census tract for selected demographic variables.
Figure 5.2.1
5.2.2 Demographic Correlates: Effective Tax Rates
Table 5.2.3 shows relationships between effective tax rates and census demographics at the tract level. Each row of the table represents the coefficient from a different bivariate regression of the effective tax rate against the census variable in question.
Table 5.2.3
| Variable | Coefficient | P Value | Significance |
|---|---|---|---|
| Non-Hispanic White Population (Percentage Points) | 0.11% | 0.09 | Not Significant |
| Population in Poverty (Percentage Points) | -0.55% | 0.00 | Significant |
| Share of Homes Vacant (Percentage Points) | -1.17% | 0.00 | Significant |
| Share of Homeowners (Percentage Points) | 0.47% | 0.00 | Significant |
| Share of Single Unit Homes (Percentage Points) | 0.38% | 0.00 | Significant |
| Share in Same Home as Last Year (Percentage Points) | 0.85% | 0.00 | Significant |
| High School Education or Higher (Percentage Points) | 0.37% | 0.04 | Significant |
| College Education or Higher (Percentage Points) | 0.00% | 0.96 | Not Significant |
| Per Capita Income ($1000s) | 0.12% | 0.24 | Not Significant |
| Median Household Income ($1000s) | 0.29% | 0.00 | Significant |
| Median Age (Years) | 0.45% | 0.09 | Not Significant |
| Median Home Value ($1000s) | 0.01% | 0.47 | Not Significant |
An example interpretation of this table; a 1% increase in the percentage of individuals with a high school education is correlated with a 0.37% increase in effective tax rate.
Figure 5.2.2 presents the average tax rate by census tract for selected demographic variables.
Figure 5.2.2
6 Comparison with Other Jurisdictions
Figure 6.1, Figure 6.2, and Table 6.1 compare this jurisdiction to the rest of the nation. Higher values (to the right side) are more regressive.
Figure 6.1
Figure 6.2
Table 6.1
| 90 to 10 ratio | 0.867 |
| 90 to 10 ratio National Rank | 2221/2775 |
| 90 to 10 ratio State Rank | 77/87 |
| 80 to 20 ratio | 0.842 |
| 80 to 20 ratio National Rank | 1674/2775 |
| 80 to 20 ratio State Rank | 72/87 |
| PRD | 1.045 |
| PRD National Rank | 1945.5/2775 |
| PRD State Rank | 74/87 |
| Number of Unranked Counties Nationwide | 353 |
| Number of Unranked Counties Statewide | 1 |
Franklin County, Ohio is ranked 10th least regressive out of 87 Ohio counties in our sample. Note: 1 counties were excluded from our analysis due to lack of data. Home values in Franklin County, Ohio are above average nationwide and regressivity levels are in the bottom quartile.
7 Appendices
Here detailed information on our analysis is presented alongside reference information.
- Click here to learn more about the IAAO Standards
- Click here to see how the IAAO Statistics change over time
- Click here to see how Figure 2.1 changes over time
- Click here to learn how we check that our results are not due to randomness
- Click here to see how tax rates differ across every school district with sufficient data
- Click here to see how alternative measures of regressivity evaluated for Franklin County, Ohio
7.1 IAAO Standards
The International Association of Assessing Officers (IAAO) defines standards for assessments including standards for uniformity and vertical equity (International Association of Assessing Officers 2013). Uniform assessments assess similar properties with as little variability as possible. Vertically equitable assessments assess properties at similar rates regardless of a property’s value. The three main standards are:
Coefficient of Dispersion (COD) is a measure of uniformity based on the average deviation from the median ratio. For example, given a COD of 15, a property worth $100,000 has a 50% chance to be assessed between $85,000 and $115,000.
Price-Related Differential (PRD) is a measure of vertical equity calculated by dividing mean ratios by weighted mean ratios. For example, assume a jurisdiction contains two homes, one worth $100,000 assessed at 12% and one worth $1,000,000 assessed at 8% of the fair market value. The mean ratio would be 10% (\(\frac{12\% + 8\%}{2}\)) while the weighed mean ratio would be 8.4% (\(\frac{0.12*\$100,000 + 0.08*\$1,000,000}{\$1,100,000}\)). The resulting PRD would be \(\frac{10\%}{8.4\%} = 1.2\).
Coefficient of Price-Related Bias (PRB) measures the change in sales ratios relative to a percentage change in property values. For example, a PRB of 0.031 indicates that sales ratios increase by 3.1% when the home value doubles.
Table 7.1.1
| Parameter | Standard Minimum | Standard Maximum |
|---|---|---|
| COD | 5.00 | 15.00 |
| PRD | 0.98 | 1.03 |
| PRB | -0.05 | 0.05 |
7.2 IAAO Statistics by Year
The following is a detailed breakdown by year of our estimates of IAAO standards and their bootstrapped confidence intervals. These estimates form the basis of our COD, PRD, and PRB plots.
Table 7.2.1
| Tax Year | Arms Length Sales | Average Sale Price | COD | PRD | PRB |
|---|---|---|---|---|---|
| 2011 | 11111 | $130,000 | 24.5419 ± 0.517 | 1.1213 ± 0.008 | -0.1225 ± 0.007 |
| 2012 | 12947 | $139,000 | 19.7347 ± 0.358 | 1.0839 ± 0.004 | -0.1032 ± 0.005 |
| 2013 | 15342 | $147,000 | 18.2891 ± 0.304 | 1.0866 ± 0.006 | -0.096 ± 0.004 |
| 2014 | 16474 | $155,000 | 12.7101 ± 0.223 | 1.0299 ± 0.002 | -0.0248 ± 0.003 |
| 2015 | 18259 | $160,000 | 12.3403 ± 0.165 | 1.0272 ± 0.002 | -0.0287 ± 0.003 |
| 2016 | 19678 | $167,500 | 11.9365 ± 0.136 | 1.0179 ± 0.004 | -0.0167 ± 0.003 |
| 2017 | 20454 | $173,900 | 12.3105 ± 0.137 | 1.0088 ± 0.002 | -6e-04 ± 0.002 |
| 2018 | 21128 | $183,000 | 14.063 ± 0.152 | 0.9969 ± 0.002 | 0.026 ± 0.003 |
| 2019 | 21820 | $193,000 | 15.6154 ± 0.169 | 0.9973 ± 0.003 | 0.0327 ± 0.003 |
7.3 Sales Ratio by Decile by Year
The following Figure 7.3.1 replicates Figure 2.1 from Sales Ratio Analysis. For each panel of the Figure 7.3.1, the current year is highlighted in blue and other years are in gray.
Figure 7.3.1
Table 7.3.1 shows the data underling the Figure 2.1 from Sales Ratio Analysis.
Table 7.3.1
| Sale Year | Sale Decile | Average Sale Price | Mean Ratio | Median Ratio |
|---|---|---|---|---|
| 2019 | 1 | $59,442 | 0.2821 | 0.2816 |
| 2019 | 2 | $101,017 | 0.2551 | 0.2481 |
| 2019 | 3 | $131,689 | 0.2497 | 0.2438 |
| 2019 | 4 | $156,509 | 0.2502 | 0.2484 |
| 2019 | 5 | $180,286 | 0.2560 | 0.2537 |
| 2019 | 6 | $208,056 | 0.2577 | 0.2552 |
| 2019 | 7 | $239,764 | 0.2598 | 0.2583 |
| 2019 | 8 | $279,936 | 0.2654 | 0.2660 |
| 2019 | 9 | $349,799 | 0.2685 | 0.2730 |
| 2019 | 10 | $594,478 | 0.2691 | 0.2779 |
| Sale Decile | Average Sale Price | Mean Ratio | Median Ratio |
|---|---|---|---|
| 1 | $57,279 | 0.3625 | 0.3495 |
| 2 | $94,705 | 0.3346 | 0.3164 |
| 3 | $121,932 | 0.3199 | 0.3070 |
| 4 | $144,667 | 0.3106 | 0.3024 |
| 5 | $167,078 | 0.3067 | 0.3012 |
| 6 | $192,859 | 0.3023 | 0.3006 |
| 7 | $224,522 | 0.2992 | 0.2980 |
| 8 | $265,825 | 0.2963 | 0.2953 |
| 9 | $335,003 | 0.2936 | 0.2958 |
| 10 | $575,853 | 0.2924 | 0.2977 |
7.4 Measurement Error and Spurious Regressivity
One limitation of sales ratio studies is that a property’s sale price may be an imperfect indication of its true market value. Given inevitable random factors in the sale of any individual property, the final price may include some “noise.” If properties are spatially cluttered, this will introduce measurement error into the analysis, which could lead to the appearance of regressivity when there is none. For instance, consider two hypothetical homes that are identical and each worth $100,000. If both homes went up for sale at the same time, one home might fetch a price of $105,000, say if the seller were a particularly savvy negotiator, while the other home might garner only $95,000, say if the buyer were a particularly savvy negotiator. If the assessor appropriately valued both homes at $100,000, a sales ratio analysis would indicate regressivity (the higher-priced home is under-assessed and the lower-priced home would be over-assessed, relative to the sale price). While there is no reliable correction for measurement error of this kind, as long as the extent of measurement error is small, relative to the price, the extent of bias will also be small.
We use Monte Carlo simulations to estimate the extent of measurement error that would need to exist for any of our tests to falsely show regressivity due to measurement error. We compare our results with thousands of simulated scenarios to determine the likelihood that our results would be reproduced in the absence of regressivity.
The simulations are conducted as follows. First, using the same data set that was used for the main analysis, we construct a simulated sale price for each property that is set equal to the actual assessed value. In this scenario where simulated sale prices always equal assessed value, the assessments will appear to be perfect according to all of our metrics and there will be no regressivity. We then “jitter” the simulated sale prices by adding random noise drawn from a normal distribution with a mean of zero and a standard deviation of k percent. While we think that measurement error on the order of only a few percentage points is plausible in real data, we consider values of k ranging from 1 to 25. To be concrete, when k is equal to one percent, the simulated sale price is set equal to the assessed value multiplied by (1 plus a random shock drawn from a normal distribution with a mean of zero and a standard deviation of .01). The shock is drawn independently for each property in the data set. For each value of k, we run 100 simulations and record the value of each metric computed in each simulation. The mean value of each metric across the 100 simulations is reported for each value of k.
Intuitively, this exercise shows how much spurious regressivity would exist if assessed values were accurate on average but sale prices contained random noise of a given value, k. We then compare the actual value of the regressivity metrics from the real data with the values from the simulated data to recover an estimate of the amount of noise that would be necessary to produce the observed regressivity statistic if there were in fact no bias in assessments.
Figure 7.4.1 shows the results of our simulations. The dots in each graph show the mean value of the metric in question across the 100 simulations for each value of k. The solid line in each graph shows the value of the metric in the real data. We show simulations for COD, PRD, PRB, and each coefficient in Table 7.4.1.
Figure 7.4.1
7.5 Effective Tax Rate by School District
In many jurisdictions, the tax rate varies based on the overlap of taxing districts, such as municipality, school district, or special district. The final determination of tax bills varies widely place-to-place, but the school district often accounts for the largest component of property taxes. This section presents estimates for the largest school district in this county (contained within one city) and summary information on all unified (K-12) school districts in which sufficient property information is available.
7.5.1 Columbus City School District
Figure 7.5.1
In 2019, the most expensive homes (the top decile) had an effective tax rate of 1.39%, while the rate for the least expensive homes (bottom decile) was 1.96%, which is 1.41 times the rate applied to the most expensive homes. Across our sample from 2011 to 2019, the most expensive homes had an effective tax rate of 1.52% of their value and the least expensive homes had an effective tax rate of 2.54%, which is 1.67 times the rate applied to the most expensive homes.
7.5.2 All Districts
Table 7.5.1
| District | City | Number of Sales | Effective Tax Rate | Average Sale | Average Tax Bill | Bottom Decile Tax Rate | Top Decile Tax Rate | Bottom Decile Sale Price | Top Decile Sale Price |
|---|---|---|---|---|---|---|---|---|---|
| Bexley City School District | BEXLEY | 1141 | 1.98% | $460,050 | $8,938.42 | 2.50% | 1.98% | $146,524 | $1,215,701 |
| Bexley City School District | COLUMBUS | 918 | 1.92% | $410,958 | $7,633.14 | 2.40% | 1.90% | $131,609 | $1,055,462 |
| Canal Winchester Local School District | CANAL WINCHESTER | 2555 | 2.27% | $182,424 | $4,051.64 | 2.88% | 2.08% | $94,713 | $301,350 |
| Columbus City School District | BLACKLICK | 628 | 1.99% | $115,226 | $2,162.86 | 3.27% | 1.66% | $43,056 | $224,040 |
| Columbus City School District | CANAL WINCHESTER | 804 | 2.03% | $106,363 | $2,036.29 | 3.02% | 1.56% | $49,376 | $176,899 |
| Columbus City School District | COLUMBUS | 46966 | 1.88% | $176,897 | $3,010.43 | 2.67% | 1.50% | $40,951 | $484,164 |
| Columbus City School District | DUBLIN | 1517 | 1.97% | $207,532 | $4,026.69 | 2.27% | 1.76% | $140,712 | $297,940 |
| Columbus City School District | GALLOWAY | 728 | 1.94% | $158,320 | $2,957.66 | 2.90% | 1.67% | $90,307 | $243,801 |
| Columbus City School District | GROVE CITY | 726 | 2.05% | $157,390 | $3,113.62 | 3.08% | 1.84% | $94,907 | $217,691 |
| Columbus City School District | NEW ALBANY | 1016 | 1.83% | $183,838 | $3,328.89 | 2.04% | 1.80% | $97,153 | $322,544 |
| Columbus City School District | WESTERVILLE | 1015 | 1.85% | $210,853 | $3,774.21 | 2.24% | 1.46% | $134,870 | $348,449 |
| Dublin City School District | COLUMBUS | 2314 | 2.24% | $174,353 | $3,810.33 | 2.68% | 1.98% | $87,202 | $334,151 |
| Dublin City School District | DUBLIN | 7157 | 2.41% | $327,687 | $7,888.43 | 2.61% | 2.40% | $119,153 | $666,516 |
| Gahanna-Jefferson City School District | BLACKLICK | 1126 | 2.09% | $406,006 | $8,401.20 | 2.41% | 2.09% | $154,656 | $795,565 |
| Gahanna-Jefferson City School District | COLUMBUS | 3181 | 2.06% | $228,039 | $4,610.82 | 2.64% | 2.02% | $110,721 | $428,587 |
| Gahanna-Jefferson City School District | GAHANNA | 2387 | 2.27% | $220,711 | $4,811.58 | 3.14% | 2.01% | $100,339 | $430,300 |
| Grandview Heights City School District | COLUMBUS | 1053 | 1.90% | $352,287 | $6,450.71 | 2.28% | 1.68% | $121,383 | $747,234 |
| Groveport Madison Local School District | CANAL WINCHESTER | 1002 | 1.96% | $137,251 | $2,576.50 | 2.78% | 1.65% | $71,349 | $212,836 |
| Groveport Madison Local School District | COLUMBUS | 2183 | 2.14% | $107,986 | $2,127.31 | 3.18% | 1.54% | $51,165 | $202,212 |
| Groveport Madison Local School District | GROVEPORT | 1558 | 2.13% | $161,008 | $3,343.66 | 2.64% | 1.85% | $77,597 | $259,817 |
| Groveport Madison Local School District | REYNOLDSBURG | 663 | 1.92% | $125,767 | $2,215.44 | 3.08% | 1.39% | $64,399 | $261,374 |
| Hamilton Local School District | COLUMBUS | 1034 | 1.69% | $118,624 | $1,871.20 | 2.63% | 1.33% | $50,141 | $213,683 |
| Hilliard City School District | COLUMBUS | 3239 | 2.30% | $233,034 | $5,272.89 | 2.84% | 2.26% | $114,827 | $520,808 |
| Hilliard City School District | DUBLIN | 1401 | 2.40% | $361,492 | $8,692.14 | 2.43% | 2.32% | $143,333 | $696,629 |
| Hilliard City School District | GALLOWAY | 969 | 2.61% | $222,563 | $5,567.90 | 3.62% | 2.12% | $113,897 | $367,158 |
| Hilliard City School District | HILLIARD | 9444 | 2.41% | $227,606 | $5,431.84 | 2.82% | 2.38% | $90,779 | $441,937 |
| Licking Heights Local School District | BLACKLICK | 3626 | 2.18% | $177,321 | $3,768.11 | 2.54% | 1.89% | $85,926 | $275,643 |
| New Albany-Plain Local School District | NEW ALBANY | 3349 | 2.53% | $510,712 | $13,034.67 | 2.60% | 2.60% | $198,354 | $1,248,965 |
| New Albany-Plain Local School District | WESTERVILLE | 862 | 2.15% | $217,179 | $4,596.80 | 2.82% | 2.04% | $117,079 | $405,667 |
| Reynoldsburg City School District | REYNOLDSBURG | 3884 | 2.41% | $155,830 | $3,589.08 | 3.31% | 2.11% | $62,970 | $310,330 |
| South-Western City School District | COLUMBUS | 5699 | 2.08% | $121,884 | $2,365.33 | 3.06% | 1.63% | $48,708 | $232,561 |
| South-Western City School District | GALLOWAY | 2697 | 1.99% | $153,906 | $2,904.76 | 3.08% | 1.62% | $77,735 | $259,244 |
| South-Western City School District | GROVE CITY | 9242 | 2.12% | $193,218 | $3,983.09 | 2.89% | 1.97% | $86,720 | $363,922 |
| Upper Arlington City School District | COLUMBUS | 4824 | 2.04% | $406,678 | $8,076.36 | 2.33% | 1.91% | $136,017 | $941,877 |
| Upper Arlington City School District | UPPER ARLINGTON | 1757 | 2.03% | $458,593 | $9,062.67 | 2.28% | 1.87% | $150,151 | $1,082,917 |
| Westerville City School District | COLUMBUS | 3512 | 2.25% | $163,469 | $3,492.58 | 3.18% | 1.84% | $68,585 | $283,989 |
| Westerville City School District | WESTERVILLE | 6631 | 2.47% | $221,188 | $5,220.10 | 3.29% | 2.17% | $89,693 | $431,043 |
| Whitehall City School District | COLUMBUS | 869 | 2.02% | $98,915 | $1,878.00 | 2.75% | 1.69% | $39,343 | $215,658 |
| Whitehall City School District | WHITEHALL | 565 | 2.07% | $93,536 | $1,791.84 | 2.92% | 1.66% | $32,497 | $203,849 |
| Worthington City School District | COLUMBUS | 3280 | 2.27% | $281,461 | $6,334.47 | 2.55% | 2.22% | $98,978 | $531,659 |
| Worthington City School District | POWELL | 1098 | 2.21% | $184,265 | $3,952.79 | 2.82% | 1.86% | $97,500 | $266,254 |
| Worthington City School District | WESTERVILLE | 723 | 2.21% | $206,000 | $4,441.79 | 2.75% | 2.07% | $87,416 | $321,015 |
| Worthington City School District | WORTHINGTON | 3791 | 2.21% | $268,859 | $5,765.48 | 2.56% | 2.03% | $89,155 | $555,372 |
7.6 Regression-Based Estimates of Regressivity
Aside from the standard PRD and PRB tests recommended by the IAAO, several alternative metrics have been proposed by academic researchers (Hodge et al. 2017). Table 7.6.1 presents estimates of the most commonly used models.
Model (1) shows a regression of assessed value (AV) against sale price. The coefficient on sale price should equal the jurisdiction’s legally mandated assessment rate (i.e., for each dollar of sale price, the assessed value should increase by the mandated assessment rate). In a jurisdiction where the assessment rate is 100%, the coefficient should be 1. A coefficient smaller than the assessment ratio indicates regressivity.
Model (2) shows a regression of the log of assessed value against the log of sale price, which estimates the elasticity of assessed values with respect to sale price. In the absence of regressivity, this coefficient should be 1. A value less than 1 indicates regressivity.
Model (3) shows a regression log sales ratios against log sale prices. In the absence of regressivity, this coefficient should be zero. A coefficient less than zero is an indication of regressivity.
Table 7.6.1
| Dependent Variable | |||
| AV | log(AV) | log(Sales_Ratio) | |
| (1) | (2) | (3) | |
| SALE_PRICE | 0.26*** | ||
| (0.0003) | |||
| log(SALE_PRICE) | 0.89*** | -0.11*** | |
| (0.001) | (0.001) | ||
| Constant | 7,496.96*** | 0.08*** | 0.08*** |
| (64.30) | (0.01) | (0.01) | |
| Observations | 157,163 | 157,163 | 157,163 |
| R2 | 0.87 | 0.85 | 0.08 |
| Adjusted R2 | 0.87 | 0.85 | 0.08 |
| Note: | p<0.1; p<0.05; p<0.01 | ||
8 Citations
Copyright 2022, The University of Chicago, Center for Municipal Finance
Please cite as: “Berry, Christopher. 2022. An Evaluation of Property Tax Regressivity in Franklin County, Ohio. Policy Brief. The University of Chicago, Center for Municipal Finance. www.propertytaxproject.uchicago.edu”