Buying & Selling Real Estate
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback
Updated about 3 years ago,
Modelling inflation and rising interest rates on affordability
I have heard many people say that inflation in our housing market will lead to higher interest rates which will ultimately lead to an affordability crisis and a significant drop in housing prices. I have not seen anything to quantify this so I decided to do just this; determine for a given interest rate, what the purchase price has to be so that the payment is unchanged. It really is a straight forward exercise, vary the purchase price for a given interest rate, such that the principal plus interest payment for a loan is the same. The purpose of this post is to understand the following:
- What changes to the purchase price for each annual rate will need to be to get the same principal plus interest payment.
- The impact on the loan term (15 year versus 30 year) and how it impacts the purchase price for the same principal plus interest payment.
- The impact on purchase price as the government raises treasury rates to combat inflation.
Annual Rate |
Amount |
% increase in purchase price as compared to 5% - 30 year loan |
Amount |
% increase in purchase price as compared to 5% - 15 year loan |
8.000% |
$ 146,320.00 |
-26.8% |
$ 165,499.00 |
-17.3% |
7.500% |
$ 153,550.00 |
-23.2% |
$ 170,611.00 |
-14.7% |
7.000% |
$ 161,376.00 |
-19.3% |
$ 175,961.00 |
-12.0% |
6.500% |
$ 169,862.00 |
-15.1% |
$ 181,561.00 |
-9.2% |
6.000% |
$ 179,074.00 |
-10.5% |
$ 187,424.00 |
-6.3% |
5.500% |
$ 189,091.00 |
-5.5% |
$ 193,565.00 |
-3.2% |
5.000% |
$ 200,000.00 |
0.0% |
$ 200,000.00 |
0.0% |
4.500% |
$ 211,895.00 |
5.9% |
$ 206,746.00 |
3.4% |
4.000% |
$ 224,885.00 |
12.4% |
$ 213,818.00 |
6.9% |
3.750% |
$ 231,830.00 |
15.9% |
$ 217,483.00 |
8.7% |
3.500% |
$ 239,095.00 |
19.5% |
$ 221,238.00 |
10.6% |
3.375% |
$ 242,853.00 |
21.4% |
$ 223,149.00 |
11.6% |
3.250% |
$ 246,697.00 |
23.3% |
$ 225,084.00 |
12.5% |
3.125% |
$ 250,630.00 |
25.3% |
$ 227,041.00 |
13.5% |
3.000% |
$ 254,655.00 |
27.3% |
$ 229,023.00 |
14.5% |
0.000% |
$ 386,510.40 |
93.3% |
$ 284,686.00 |
42.3% |
1: If interest rates decrease to 4% for a house, worth $200,000 when prevailing rates are at 5.00% for 30 years, that person can pay $224,885 for the same property (an increase of 12.4%) without an increase in the principal plus interest. Alternatively, if interest rates rise by 1% to 6%, that same house would sell for $179,074 (a decrease of 10.5%) without an increase in the principal plus interest payment.
2: If a person chooses to use a shorter rate term (15 years instead of 30 years), the impact on affordability is reduced because the total number of payments are reduced. For this reason, when the population of people generally use a 30 year loan, that defines the worst case scenario for housing affordability. For situations where loan terms decrease in duration, the impact on changes in housing prices (higher and lower) is muted.
3: If inflation is tracking at something like 6% year over year and if we believe that housing will keep up at the prevailing inflation rate (new builds are affected by labor, energy, and materials), a 1% increase from 5.00% to 6.00% will only go down in relative value by something like 4.5% (-10.5% - 6%). If inflation tracks at 6% for two years, housing should be above our current rate in two years. For this reason, long term inflation will significantly increase property prices faster than the temporary drop due to affordability. This does assume that wage growth tracks with the inflation rate which may or may not happen.
I recognize that inflation occurs differently for different groups of products and services/labor. With that said, am I missing something about why a relatively small drop (as compared to the gains we saw) would lead to a huge crash in the housing market due to an increase in interest rates?
Thanks in advance.