Some of the apps are outdated and no longer available but I there is a way to get new apps and keep it up to date. I'm not familiar with all it's capabilities but I used it to play movies that I have stored on a USB hard drive. It comes with a power supply, HDMI cable and a Remote Control but you can also hook up a mouse and keyboard. Sold as-is, no returns.