No. For starters, the figure I gave was HMRC’s received amount from 2010. If I’d used 2009s figures the net gain would have been 6 billion more.
In terms of actual running cost/benefit to date, the last time this one came up, I think it was a study by the Fraser of Allander institute that pointed out that revenue from the North sea over the last 20 years had significantly outweighed any inequality of tax revenue. I believe that was (in equivalent rates) in the order of tens of billions over the years, but will need to go digging for the study.
Obviously production rates will decline (estimates vary) but by the same token the price of crude is going to raise significantly (see increased demand from China and India, and drop in production from Saudi) which means that the North Sea’s likely value for the next 20 years is in the order of billions per year.
And before anyone starts with ad hominems about skewed nationalist bias, I’m neither originally from Scotland, nor likely to stay here too much longer, so really don’t have a dog in this fight. I work extensively with exploration and production data though, including revenue figures for HMRC, so have always found it amusing the way that people either write off the north sea as a spent asset, or claim that somehow Scotland’s cost the English money. Both claims have sod all basis in fact.
