Manchester City have exited the Champions League and passed up on the chance to further boost their prize money after defeat at Real Madrid.