Sony is a hard one to quantify remember. The PS3 wasn't just a video game system that was supposed to make them money off hardware and software sales, it was supposed to be a catalyst for all Sony product sales. Drive more HD TV adaption, Surround sound products win the HD format war for Blu-Ray, help sell HD video capture camera things, be an online hub for Sony to advertise / sell all their various Sonic Music / Film products blah blah blah... and more recently it's now one of the main things being used to push 3D technology, thus selling Sony 3DTV's, 3D Blu-Rays, glasses etc.
The PS3 bled a lot of money but it's hard to quantify it all as Sony are such a huge company and everything it does is there for the reason of helping Sony make money from other products too. They've done a great job at establishing IP in the past 5 years or so too.
Nintendo clearly made a ton of money too... I'd assume a lot more then Microsoft, they're just in a transition period right now.