Historic Market Cap data ?

Historic Market Cap data ?

Author
Discussion

dibbly_dobbler

Original Poster:

11,274 posts

198 months

Monday 1st June 2009
quotequote all
Hi Folks.

I have been pondering the current market cap of RBS (amongst others) versus what it was at its peak (having read somewhere that there are now 10 times as many shares in circulation as there used to be which seems very scary - ie 40p now => £4 in the good old days. This makes the current price seem way too high ?).

So anyway I was trying to establish if this is true by looking at market cap data for the last few years but I couldn't find anything useful.

Can anybody help ?

Cheers, DD.

Mx_Stu

810 posts

224 months

Tuesday 2nd June 2009
quotequote all
You can get the historic share price from yahoo finance and previous annual reports should be on the investors section of the rbs website.

If you multiply the share price at the date of the accounts by the issued ordinary share capital then that will give you the market cap at that date.

dibbly_dobbler

Original Poster:

11,274 posts

198 months

Wednesday 3rd June 2009
quotequote all
Cheers Stu.

Had a quick look through the RBS accounts and nothing really leapt out at me to be honest !

Just thought it would be a bit easier to access this data but maybe not ...

matsmith

1,166 posts

210 months

Thursday 4th June 2009
quotequote all
its pretty easy to find market cap on the RBS end of year results, it gives the market cap at the year end for the previous years

there were 9557 million shares in issue at the time that the 2007 results were published

the the peak was about £7.25

so thats £69,288 million at the top

dibbly_dobbler

Original Poster:

11,274 posts

198 months

Friday 5th June 2009
quotequote all
matsmith said:
its pretty easy to find market cap on the RBS end of year results, it gives the market cap at the year end for the previous years

there were 9557 million shares in issue at the time that the 2007 results were published

the the peak was about £7.25

so thats £69,288 million at the top
Thanks Mat thumbup

That pretty much answers my real question which was related to RBS's current market cap in relation to the peak.

So if your numbers are correct the current market cap is very roughly a third of the peak - which arguably does make RBS seem overvalued (although not as badly as was implied by the figures I quoted earlier.)

Doesn't seem to me like there's much scope for the share price to go up substantially from where it is though and there must be next to zero chance of it getting back above a quid any time soon !

Any thoughts ?

matsmith

1,166 posts

210 months

Sunday 7th June 2009
quotequote all
your welcome dibbly

in the past 5 years RBS have trades at a PE of 2.9, 2.9, 2.9, 3.8 and NA

plus they paid dividends of 11.8, 14.8, 16.3, 8.9 and 0%

so i suppose the question is can they make £7 billion profit this year, and would even that be enough to justify a PE of about 3 when they pay no dividend?

i dont know the answer, and maybe someone will add something to this.

what i do know though is that technically they are headed to 75p as long as 35p holds, if 35p doesnt hold then a new situation comes into play, possibly not a very nice one, im not putting any decent sums into this at the moment


also now my brain is awake, il just add that there are some who will argue that because of the extra cash they have from all those rights issues, they become a more valuable company

dibbly_dobbler

Original Poster:

11,274 posts

198 months

Monday 8th June 2009
quotequote all
matsmith said:
your welcome dibbly

in the past 5 years RBS have trades at a PE of 2.9, 2.9, 2.9, 3.8 and NA

plus they paid dividends of 11.8, 14.8, 16.3, 8.9 and 0%

so i suppose the question is can they make £7 billion profit this year, and would even that be enough to justify a PE of about 3 when they pay no dividend?

i dont know the answer, and maybe someone will add something to this.

what i do know though is that technically they are headed to 75p as long as 35p holds, if 35p doesnt hold then a new situation comes into play, possibly not a very nice one, im not putting any decent sums into this at the moment


also now my brain is awake, il just add that there are some who will argue that because of the extra cash they have from all those rights issues, they become a more valuable company
Hi Mat.

Thanks again. I am intrigued by your theories on price levels - do you also post on Google finance as there is a chap on there that sounds a lot like you !?

I must say it seems very unlikely to me that the SP will hit 75 by the year end surely that would imply a Market Cap of over £40 Billion - ie about two thirds of its all time high ?

Sorry for seeming a doubter - I am genuinely interested to hear your take on it.

Cheers, DD

matsmith

1,166 posts

210 months

Monday 8th June 2009
quotequote all
Hi Dibbly, nope i dont post on any other forums

i doubted myself that RBS would get to 10p in the first place (hence i bought at 15p), and then from there it seemed impossible it would get 50p+ again, but i forced myself to believe it and traded it

75p is the reasonable positive scenario, the doom and gloom one see's them go to around 3p

Lloyds are the hot one at the moment, very well behaved. they have perfectly followed the plan i made back in january, so now we need a decision on whether it will get another wave down which will take us to 12p, or a new bull market wave up which would take us to 150p

Barclays could see 18p, but would idealy get to 349p first

theres so much prospect for a horrific scenario, not pleasant to think about. the ideal neat and tidy situation would be for us to get around 5000 ftse, before the next "crash" down to around 2000

its tough at the moment, we are at a massive turning point with a potentially massive move in either direction. late least yr/early this year was relatively easy to read because there was only a doom and gloom scenario, whereas now we really could go either way. though (unfortunately) im favoring the downside as the more likely, and i say unfortunately because i really dont like being negative

dibbly_dobbler

Original Poster:

11,274 posts

198 months

Tuesday 9th June 2009
quotequote all
matsmith said:
Hi Dibbly, nope i dont post on any other forums

i doubted myself that RBS would get to 10p in the first place (hence i bought at 15p), and then from there it seemed impossible it would get 50p+ again, but i forced myself to believe it and traded it

75p is the reasonable positive scenario, the doom and gloom one see's them go to around 3p

Lloyds are the hot one at the moment, very well behaved. they have perfectly followed the plan i made back in january, so now we need a decision on whether it will get another wave down which will take us to 12p, or a new bull market wave up which would take us to 150p

Barclays could see 18p, but would idealy get to 349p first

theres so much prospect for a horrific scenario, not pleasant to think about. the ideal neat and tidy situation would be for us to get around 5000 ftse, before the next "crash" down to around 2000

its tough at the moment, we are at a massive turning point with a potentially massive move in either direction. late least yr/early this year was relatively easy to read because there was only a doom and gloom scenario, whereas now we really could go either way. though (unfortunately) im favoring the downside as the more likely, and i say unfortunately because i really dont like being negative
eek 3p for RBS, 12p for LBG and 18p for Barclays !!

Jings Crivens these are some scary numbers my friend - I haven't heard anybody else talking in these terms but then again not many saw the last crash!

For what it is worth my opinion would be a bit more mainstream - I think there will be modest (especially for RBS) progress from current levels. I reckon all of the really bad news is out in the open already and is already priced in.