How does interest rate affect affordability?

Higher rates increase monthly payments and reduce purchasing power, while lower rates improve affordability.