Though the Olympic Games are the pinnacle of sport, they have the potential to wreak financial havoc on their host countries.