In our last article, we promised you a calculator so you can copy our methodology and calculate ‘affordable’ houses by determining what an acceptable monthly payment would be. In our current article, we deliver! Thanks to Ironman at Political Calculations for the calculator creation script, it was very useful once again!
Home Affordability Calculator
In the Don’t Quit Your Day Job Home Affordability Index we described in our last article, we discussed how a synthetic index of home affordability can be constructed based upon down payments, mortgage interest rates, front end debt to income ratios, and a salary. Using our St. Louis Fed Data for January 30 year mortgage rates, we were able to determine what home prices were ‘affordable’ with 25% front end DTIs and 20% down payments. Varying those numbers, especially the DTI, make a huge difference in the calculated affordability measure. For example, Bank Rate reports that 28% is a better debt to income ratio. Rather than forcing numbers upon you, we present this calculator where you can force numbers upon yourself!
Note that the ‘affordability’ number presented is a measure of how much house can be afforded with a designated monthly payment – Salary divided into 12 months, multiplied by the front end debt to income ratio. This happens to be the way that many people shop for homes, for better or worse. Your own situation is unique – although using the proper set of inputs can determine what a bank may offer you in terms of credit, the amount of house you purchase is an individual decision. For better or worse, this is how a huge subset of home buyers shops for a home.
For a simple example, the median income in Santa Clara County was $84,990 in 2009. Current mortgage rates are (according to Bankrate on 9/25/2011) 4.00%. Using a 28% DTI and a 20% down payment, “Affordable” housing in Santa Clara County is $519,228.23 or less. Run the numbers in your area!