Damage after 'apocalyptic' flooding to pass €500 mill