Department of Numbers

This section of Department of Numbers is no longer being updated and may be removed in the future. The data here is out of date and should no longer be used.

Columbia, Missouri Home Affordability

The data below measures home affordability for the Columbia, Missouri 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, Missouri Home Price-to-Income Ratios

The current price-to-income ratio for Columbia is 3.5 as determined by March 2014 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, Missouri Home Price-to-Income Ratio History

Date Realtor
(Dollar Ratio)		 FHFA
(Index Ratio)
March 2014 3.50 —
December 2013 3.57 120.8
September 2013 3.65 119.7
June 2013 3.60 119.8
March 2013 3.49 118.4
December 2012 3.56 119.2
September 2012 3.56 118.4
June 2012 3.56 117.1

Columbia, Missouri Home Price-to-Rent Ratios

The current adjusted price-to-rent ratio for Columbia is 19.18 as determined by March 2014 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, Missouri Home Price-to-Rent Ratio History

Date Realtor
(Dollar Ratio)		 Realtor Adjusted
(Dollar Ratio)		 FHFA
(Index Ratio)
March 2014 20.34 19.18 —
December 2013 20.76 19.58 94.6
September 2013 21.19 19.98 93.8
June 2013 20.95 19.76 93.9
March 2013 20.30 19.15 92.7
December 2012 20.69 19.51 93.4
September 2012 20.69 19.51 92.7
June 2012 20.69 19.51 91.7

Columbia, Missouri 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.87 in March 2014.

Rent-to-Mortgage Payment Dollar Ratio: Realtor

Columbia, Missouri Home Rent-to-Mortgage Payment Ratio History

Date Realtor Adjusted Rent
(Dollar Ratio)
March 2014 0.87
December 2013 0.84
September 2013 0.82
June 2013 0.88
March 2013 0.96
December 2012 0.97
September 2012 0.95
June 2012 0.93

Columbia, Missouri Inferred Affordable Mortgage

The inferred affordable mortgage value is determined by taking the median household income for Columbia, Missouri 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, Missouri Inferred Affordable Mortgage History

Date Inferred Mortgage
February 2014 $218,097
January 2014 $214,771
December 2013 $214,014
November 2013 $219,135
October 2013 $220,971
September 2013 $213,261
August 2013 $214,014
July 2013 $216,296
June 2013 $224,172
May 2013 $239,163
April 2013 $241,855
March 2013 $238,276
February 2013 $239,460

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. ↩

Data on deptofnumbers.com is for informational purposes only. No warranty or guarantee of accuracy is offered or implied. Contact ben@deptofnumbers.com (or @deptofnumbers on Twitter) if you have any questions, comments or suggestions. Privacy policy.