Affordability has slumped to its lowest level on record, with falling house prices not enough to offset the financial hit delivered by three interest rate rises this year.