It can mean a number of things. The one you mentioned is the literal use. But the "it's screwed" can mean "its doomed to fail". One could say, "i didnt study for this test, I'm screwed" as in "unlikely to succeed.