It depends on your price of electricity, the hash rate of the network, and the hashes your CPU can produce, but the consensus seems to be that Monero's value will continue to rise. That makes it worth mining to me, but maybe not for everyone.

https://bitcointalk.org/index.php?topic=653467.0