Prince Charles's black spider memos to be published on Wednesday

[rurallib]

10. from my memory I do remember hearing that yes it does

Here is an article - couple years old that says yes it does:
http://www.theatlantic.com/international/archive/2013/07/is-the-british-royal-family-worth-the-money/278052/

According to Buckingham Palace, sustaining the royal family costs Britons 53 pence, or about 81 cents, per person, per year. The total came to about 33.3 million pounds (about $51.1 million) for 2012-2013, according to the Palace, up from 32.4 million pounds the previous year.
<>
But some British republicans -- those who want to abolish the monarchy -- say the actual cost is much higher, once you factor in things like security detail and the cost of preparing for royal visits. Their figure is about 200 million pounds, or $307 million.
<>
The British tourism agency has reported that the royal family generates close to 500 million pounds, or about $767 million, every year in tourism revenue, drawing visitors to historic royal sites like the Tower of London, Windsor Castle, and Buckingham Palace. The country's tourism agency says that of the 30 million foreign visitors who came to Britain in 2010, 5.8 million visited a castle .

So it looks like any business - you have to spend money to make money. Looks like they bring in about twice what they cost. No doubt in all this it is hard to say where to stop counting costs and where to stop counting revenue. How many tourists would never had taken the trip had there not been a royal family etc.?