dalesman - 26 Feb'12 -
Just to underline the enormity of the under valuation by Cannacord this week I have posted a screenshot on my website dalesmann.com of one of the lesser used but nevertheless useful workbooks contained in ‘Targeting Oil Shares’. Click to enlarge.
This workbook is a simple one and takes all its references from other integrated spreadsheets.
In its most simple form it asks how many recoverable barrels would it take to support the current share price.
At a share price of £3.64 the spreadsheet returns a figure of 667m barrels
This is valuing a barrel of oil at $7. 64 a figure slightly below TPOs $7.80 . His spreadsheet can still be accessed at:
http://dalesmann.com/tpo-revised-gkp-valuation/
I understand it is currently undergoing a slight upwards revision but it will do for now.
This represents a PSC profit of 13% before tax (corresponding to TPO’s 7.8% profit after the 40% AISP tax, in the above calculation a $100 long term oil assumption has been assumed.)
The Cannacord so called valuation ignores their own previous calculations. In BBBS recent valuation
http://dalesmann.com/bbbs-gkp-nav-updated-cheap-at-half-price/
he sites Cannacord using a similar figure to TPO – based on
“- a Discount Rate Reduction Factor (DRRF) of 0.6185 (corresponding to the reduction observed within the Cannacord Adams evaluation of several generic Kurdistan PSC’s when applying a Discount Rate of 10%),”
I strongly suggest you read the whole of BBBS post to gain the full context of this statement.
Suffice to say if BBBS is correct (I’m sure he is) then Cannacord have up till now been using a very similar figure to TPOs £7.80 for a recovered barrel. :0)
They qualify their statement by saying that their calculations are based on 3b bls recoverable. I’m happy to use this figure, which they state was derived after a 28% recovery factor was applied,
GKP has effectively 54% of this figure. After a 10% top-slice has been applied we come to 1.439bbls as the GKP entitlement.
Their current valuation of GKP they say comes out at £1.70. Does it really – then your previous guidance was worthless !
So we are led to believe that 1.439bbls = £1.70/ share – lets assume 893m(fully diluted) shares in issue
And an exchange rate of $1.57 = £1
We then have 1.57 x 1.70 x 893 = market cap of $2.383b according to Cannacord
If we now divide this number by the number of barrels they have assigned to GKP we get 2.383 / 1.439 = $1.65/ recoverable barrel.
Are they actually trying to make us believe this figure – about what Afren paid for contingent resources, not recoverable barrels! Genel paid $5.8/ bl and stated that the Chinese were prepared to pay 33% more ($8.7 / barrel)
Compare that figure with Cannacord’s own declared announcement for a barrel of recovered oil derived from a KRG PSC contract and all of a sudden there is a $6 / barrel disparity.
If we use figures stated by Cannacord Adams in their previous analysis (see BBBS post) a figure close to TPOs $7.80 ,
we get
$7.80 x 1.439 = $11.22billion
Divide that by 893 shares in issue 11.22/0.893 = $12.56/share
Divide this figure by the exchange rate 12.56/$1.57 = £8.00
So using previously stated metrics put out by Cannacord Adams themselves their valuation should be £8.00
They then have applied upside due to a TO situation which amounts to £2.10 – £1.70 = 40p/share or a percentage premium of 23% (strange I’ve heard that figure before haven’t I CJ?)
If we apply a 23% uplift to £8.00 we get £9.84
I think that these figures have now some semblance of truth to them. :0)
I have only used figures put out by Cannacord Adams themselves prior to their last note, their recovery factor , their recovered barrels. All based it seems on the 10.5billion OIP figs at Shaikan which both Todd and John G expect to update us on soon. John has mentioned 18b OIP, Todd a doubling of the resources.
Interestingly if we take Cannacords 28% recovery factor and apply it to 10.5b we get 2.940bl leaving only 60mbo to come from Sheikh Adi, Ber Bahr and Akri Bijeel. As 2.4b has already been declared at Akri Bijeel and we have a fully diluted 77.41m barrels of entitlement there, it appears that Cannacord is throwing in around 17m barrels at Akri Bijeel for FREE as well as the whole of Sheikh Adi and the whole of Ber Bahr – IMHO there is absolutely NOTHING in their figures for these blocks! Am I wrong?
Returning to my workbook and the associated screenshot:
You can see that only 637m barrels are required to support the current market price using $7.64 profit /barrel
If we return to Cannacord Adams entitlement figures assigned to GKP of 1439m, the Shaikan valuation would be $11b or equivalent to £7.00 for Shaikan alone before any TO premium.
In actual fact my own figures as can be seen from the screenshot have an unrisked target of £14.32
A little bit of study looking at the spreadsheet will see how this figure was derived.
So much for what IMHO was a most disingenuous note!
As always I urge you to DYOR . Check out the validity of my workings for yourself – as always I am not giving any advice on holding, selling or buying – that is all down to you!
What we will get in a TO situation is anyones guess - a low ball offer is still possible.
A second longish post 'A Pilot on board' is also posted on my site
Kind regards
Dalesmann