It sends them to the Graveyard and you still get their effects as well as you gaining 1000+.
You can chain Magical Arrow to your opponent's Magic, regardless of what kind it is, even Normal, and destroy it to inflict 500 damage to your opponent.