Department of Numbers

Columbia, South Carolina Home Affordability

The data below measures home affordability for the Columbia, South Carolina metropolitan area using price-to-income and price-to-rent metrics.1 The maximum affordable loan amount for the median household income is also calculated. You can also compare Columbia home affordability to other cities.

Columbia, South Carolina Home Price-to-Income Ratios

The current price-to-income ratio for Columbia is 3.0 as determined by March 2012 Realtor median sales prices. The second chart shows a history of the ratio as an index calculated from the Federal Housing Finance Agency's Columbia HPI series. Median household income data for Columbia is from the Census American Community Survey.

Price-to-Income Dollar Ratio: Realtor

Price-to-Income Index Ratio: FHFA

Note: Index set to 100 in Q1 of 2000

Columbia, South Carolina Home Price-to-Income Ratio History

Date Realtor
(Dollar Ratio)
FHFA
(Index Ratio)
March 2012 3.00
December 2011 3.07 121.6
September 2011 3.04 122.3
June 2011 3.22 121.0
March 2011 2.95 124.5
December 2010 3.10 126.1
September 2010 3.10 126.6
June 2010 3.10 127.0
March 2010 3.10 127.8

Columbia, South Carolina Home Price-to-Rent Ratios

The current adjusted price-to-rent ratio for Columbia is 18.97 as determined by March 2012 Realtor median sales prices. This ratio is calculated using household size adjusted median contract rent for Columbia. The chart below shows an index of the rent ratio calculated from the metro FHFA HPI series and the Columbia median contract rent data from the Census ACS.

Price-to-Rent Dollar Ratio: Realtor, Realtor Adjusted Rent

Price-to-Rent Index Ratio: FHFA

Note: Index set to 100 in Q1 of 2000

Columbia, South Carolina Home Price-to-Rent Ratio History

Date Realtor
(Dollar Ratio)
Realtor Adjusted
(Dollar Ratio)
FHFA
(Index Ratio)
March 2012 19.58 18.97
December 2011 20.02 19.39 106.8
September 2011 19.87 19.24 107.4
June 2011 21.02 20.36 106.2
March 2011 19.27 18.66 109.3
December 2010 20.28 19.64 110.8
September 2010 20.28 19.64 111.2
June 2010 20.28 19.64 111.5
March 2010 20.28 19.64 112.3

Columbia, South Carolina Home Rent-to-Mortgage Payment Ratio

The rent-to-mortgage payment ratio uses the adjusted rent for Columbia against a 100% loan-to-value mortgage (30-year fixed) for the median price home using Realtor home sales statistics. It's a lot like a cap rate, but I find it more appealing in ratio form. A ratio of 1.0 means that annual rent is equivalent annual mortgage payments. Values less than 1.0 indicate rents are cheaper and values greater than 1.0 mean mortgage payments are cheaper. Beware, taxes are not considered here. The rent-to-mortgage payment ratio for Columbia was 0.93 in March 2012.

Rent-to-Mortgage Payment Dollar Ratio: Realtor

Columbia, South Carolina Home Rent-to-Mortgage Payment Ratio History

Date Realtor Adjusted Rent
(Dollar Ratio)
March 2012 0.93
December 2011 0.90
September 2011 0.90
June 2011 0.81
March 2011 0.85
December 2010 0.82
September 2010 0.85
June 2010 0.81
March 2010 0.79

Columbia, South Carolina Inferred Affordable Mortgage

The inferred affordable mortgage value is determined by taking the median household income for Columbia, South Carolina and calculating the mortgage 30% of that income could afford. Traditionally, 30% of income is the maximum amount a homeowner could use towards a home loan. Inferred affordable loan values are calculated from ACS median household income and average monthly mortgage rates.

Inferred Affordable Mortgage

Columbia, South Carolina Inferred Affordable Mortgage History

Date Inferred Mortgage
January 2012 $242,848
December 2011 $241,674
November 2011 $240,799
October 2011 $238,488
September 2011 $237,345
August 2011 $232,853
July 2011 $225,292
June 2011 $226,349
May 2011 $222,940
April 2011 $217,844
March 2011 $217,844
February 2011 $215,116
January 2011 $219,861

1. Specifically, home prices are from the non seasonally adjusted FHFA all-transactions quarterly series. Dollar ratios are calculated using NAR metro prices when available. Rent and income data are from the Census ACS and are carried forward into the following year prior to release of the new data.