The double whammy of surging mortgage rates and skyrocketing home prices has led to “collapsed” housing affordability in America, according to Chris Flanagan’s team at Bank of America Global Research.