According to Thamis (CA) each ship in a fleet of twenty stops 5 percent of trade giving you more profit. I have had very expensive fleets making enough money from raiding to pay for it self. The problem is that this last usually not very long since others will join the raiding feast and your income will become less. The AI knows which trade lane is profitable to raid. But raiding trade lanes is a good way to weaken your enemy.