A study found the proposed scheme was unaffordable in the current financial climate, the council said.