Beginners' Portfolio: Year-End Valuation

Published in Investing on 28 December 2012

We take a look at how things are going at the end of 2012.

This article is the latest in a series that aims to help novice investors with the stock market. To enjoy past articles in the series, please visit our full archive.

It's a couple of months since our last valuation of the Beginners' Portfolio, and since then I have simply ignored our share prices and just kept an eye on important company news. Honestly, I really have -- until I came to update my spreadsheet for this end-of-2012 report, I really didn't have much clue how things were going price-wise. When you're just starting out, I know it can be hard to switch off from day-to-day share prices. But if you can manage it, I recommend it highly.

Anyway, with the Christmas and New Year holidays upon us, I've had to prepare this in advance, so the prices in the table below are taken from close of play on 19 December.

The "Proceeds" column shows the cash we'd actually get if we sold each holding, after charges.

CompanySharesBuy priceTotal costBid priceProceedsGain/loss% change
Vodafone (LSE: VOD)289168.5p£499.91156.6p£492.57-£56.94-11.4%
Tesco (LSE: TSCO)159305.5p£498.23340.2p£530.92£32.696.6%
GlaxoSmithKline (LSE: GSK)341,440.5p£502.221,354.5p£450.53-£51.69-10.3%
Persimmon79617.9p£500.55811p£630.69£130.14+26%
Blinkx1,31936.9p£499.6862p£807.78£308.10+61.7%
BP (LSE: BP)112434.5p£499.01431.3p£473.06-£25.95-5.2%
Rio Tinto (LSE: RIO)163,048.4p£500.183,506.5p£550.96£50.7810.2%
BAE Systems146332.3p£497.59341.8p£489.03-£8.56-1.7%
Dividends    £70.56£70.56 
Total  £3,996.97 £4,446.09£449.13+11.2%

Dividends as well

Since last time, we've had some more of our shares go ex-dividend, entitling us to juicy payments.

BAE Systems' interim ex-dividend date was 17 October, with a payment of 7.8p per share, bringing us £11.39 to add to the pot. The BAE share price has risen above our purchase price, though it's not enough to cover costs yet on its own -- but adding in the £11.39 puts our BAE holding just in profit.

A BP interim dividend on 7 November of 18p per share brought us £6.26, Glaxo's interim on 14 November added £6.12, and then another week later Vodafone's latest interim dividend brought us £9.45.

What do we think?

Two things strike me this time. One is that Tesco shares have started something of a recovery after a positive third-quarter update. That puts us in the money, though it's early days yet.

The second is that the mining sector has hopefully started to turn around, and our Rio Tinto holding is in profit to the tune of 10%. I had no idea of how the timing would work out when we bought (and I still don't -- it could turn down again). But what counts is to buy shares when you think they're cheap based on long-term expectations, not when you think they've reached the bottom -- the latter is a far harder call than the former.

Overall, including share price rises and dividends, our pot has grown by £449.13, which is a gain of 11.2%. Am I pleased with that?

Well, no, I'm neither happy nor sad about it yet, because it's way too soon to know if we have made good choices. Random noise is enough to make the kind of difference we've seen so far -- ask me again this time next year.

But what I am happy about is that we have a set of companies whose fundamentals really haven't changed, and which I'm still happy to stick with for the long term.

But...

Having said that, there are a couple of interesting observations.

Firstly, our one-off growth share investment in Blinkx accounts for a large part of the gain. Had we not bought it, the portfolio would only be 4% up, in profit to the tune of just £141.03. With higher-risk growth shares, short-term price movements are even more subject to irrational sentiment than ever. It reinforces that what looks like a good performance so far might be just luck -- which is the overriding factor in the short term, anyway.

The other thing is the importance of dividends, which have added 1.7% to our return so far. Without dividends, we'd be 9.5% up. That might not sound like much of a difference, but 1.7% over such a short period is already beating the pants off a savings account -- any long-term share price growth is a bonus!

And finally...

I recommend the Fool report "10 Steps To Making A Million In The Market". It makes clear that making a million is not reliant on hitting a magic share that zooms from nothing to riches overnight, but it can be done with just the kind of shares we have in our Beginners' Portfolio -- plus the magic ingredients of time and patience.

Many people think the idea of making a million is just a pipe dream. If you think that, click here for a copy and see if it changes your mind -- it will cost you nothing.

And do please feel free to share your thoughts on the Beginners' Portfolio Discussion Board.

> Alan does not own any shares mentioned in this article. The Motley Fool owns shares in Tesco and has recommended shares in Vodafone.

Share & subscribe

Comments

The opinions expressed here are those of the individual writers and are not representative of The Motley Fool. If you spot any comments that are unsuitable hit the flag to alert our moderators.

apprenticeDRL 28 Dec 2012 , 10:24am

Alan - I assume that the data in your buy price column 1 and shares column 2 has been transposed, otherwise you seriously overpaid for VOD and I would love to buy TSCO at 159 or even RIO at 16 :-)

BarrenFluffit 28 Dec 2012 , 6:13pm

I've read the above but have to wonder about how useful the method is and weather the data really provides helpful information.

Ok one end date provides a "sell everything now" price but any conclusions about how your doing can easily be evaporated as prices move around. A currency move (or whatever) one day later would make the results completely different even if the underlying investments were the same.
Maybe this method is only realistic for holdings that have been sold and with existing holdings we really don't know until its all over.

goodlifer 28 Dec 2012 , 11:10pm

Could somebody please explain to us the point of all these valuations?
Till you actually sell them they're just reflections of moonshine in running water.

IDPickering 29 Dec 2012 , 3:25pm

I for one am interested in how the portfolio is doing overall, including current prices and dividends accrued.

goodlifer 29 Dec 2012 , 9:34pm

IDPickering
"I for one am interested in how the portfolio is doing overall, including current prices and dividends accrued."

Agree with you about dividends.
But current prices seldom do more than reflect the mood of our heartless, witless market.
Fools' - fools' - paradise?

goodlifer 30 Dec 2012 , 12:00am

IDPickering
A further thought or two,

FWIW, you're right to think there's no great harm in looking at current prices.
Provided, provided, provided.

By all means enjoy that nice warm glow you get when you see those prices going up, but don't kid yourself - as so many people seem to do - you're really any richer,
You're not until you've actually sold and got the money in the bank.

Anyway, as a self-confessed dividend reinvestor you should be hoping for the markret to go down

jaizan 30 Dec 2012 , 4:06am

There's no harm at all in also including some indicators of value when reviewing a portfolio. Such as PE ratio or yield.

ANuvver 30 Dec 2012 , 5:29am

I don't think there's anything wrong with monitoring capital value. Obviously, if you're doing it five times a day, this approach may not be for you.

I've heard many people here claim that they topslice, move stops, rebalance, cut losses, etc, even though they're dividend stalwarts at heart. You can't really do that unless you know what the score is.

It really just comes down to self-discipline. If you're going to panic out of a position when a holding slumps 20% in a month, time to step away from the screen.

I got involved in managing my own investments because I wanted lower costs and complete control. Prior to that, it took ages to get a simple quote of overall book value, and an unbelievable ten working days for an encashment - which was invariably not conducted with my personal tax efficiency in mind. And I was paying for this privileged treatment.

Now I can fire up the spreadsheet at any time and see capital appreciation, current yield, yield on cost, buy/sell flags of my choice, etc, per stock and per asset class. And I can buy or sell in five minutes flat.

Just because I now have this degree of monitoring and control doesn't mean I'm glued to the pf or constantly fiddling with it. I've seen it down and I've seen it up, but as an accumulative reinvestor, months go by without me buying or selling a solitary sausage.

If you have the right temperament, monitoring can actually be a useful reinforcement mechanism. You get to see that even blue chips swing around quite alarmingly at macro whims over time and learn not to take the swings too seriously.

Buy and hold doesn't mean buy and ignore.

Incidentally, I find it useful to regard the bottom-line capital appreciation in terms of x years of inflation. Aiming to stay a few years ahead on that basis while working on sustainable yield gives me a solid strategic focus.

Ah, tactics and strategy. Every investor should play chess...

goodlifer 30 Dec 2012 , 11:21am

"Every investor should play chess."

Or Three Card Brag.
Or Blackjack.

jaizan 30 Dec 2012 , 11:30am

So what type of spreadsheet are you using ANnuvver? Also what data source?

I've been using a google finance spreadsheet, however it's far from perfect. Especially when they start doing irrational things at random (for example, changing the units for sterling 52 week lows from pence to pounds, whilst retaining pence as the units for the share price and 52 week highs).
Google also only seem to have live data for USA and London, so I had to use Yahoo as a source for other markets.

ANuvver 30 Dec 2012 , 4:14pm

Open Office fed by Yahoo Finance. I have to hand-stitch a couple of things in. Never yet found a reliable source for yields, so every few months I trot round the individual websites and update TTM yields.

Google may be live, but as you point out it's awfully inconsistent.

jaizan 31 Dec 2012 , 4:19am

Thank you Anuvver, the advice is much appreciated. Would it be possible to paste in an example of the formula you are using to extract the data from Yahoo finance please?
Experience shows that's a much quicker way to start.

ANuvver 31 Dec 2012 , 8:37am

Well ... I'll warn you, it's pretty propellerheaded stuff. Interesting though, if you like that sort of thing. I'm an old prophead from the days when floppy disks were actually floppy.

The Yahoo API is very useful. This link gives a breakdown of how it works:
http://www.gummy-stuff.org/Yahoo-data.htm

However, interrogating Yahoo (or Google) for one stock at a time is very slow, and having to update the alphabet soup for a multiple call is a pain. Excel is easier to work with TBH, but OpenOffice is free and I'm a cheapskate...

So I use a much Heath Robinsoned version of the stuff you can find here:
http://www.fool.co.uk/search/solr.aspx?q=openoffice+yahoo

Wish I could be of more help, but without knowing whether you're comfortable managing macro libraries and all that jazz, I can't really give you a one-stop solution. Sorry.

Pinchthepennies 31 Dec 2012 , 2:43pm

I use the Hyp Top Up spreadsheet - credit for this goes to itsallaguess who is updating this file and uploads it to gamefront.

The main advantage with this file is for me - it does all the work while you sit and wait for a moment. After the first initial time spent on entering your share holding information all it takes is to press a few buttons to get updates.

On tab 1 - High Yield Portfolio you need to enter the amount of shares you're holding for each of your companies first then on the press of a button this file (or rather the macros within it) updates the share prices with data from Yahoo.

It will then work out the value as a % of total value of the portfolio and assign a value weighting for each share sorted in ascending order.

Afterwards, again at the press of a button, it will update the dividend forecast yield with data from DigitalLook and work out a yield weighting sorted in descending order.

It will then add up the two weighting values and assign a top up order sorted in ascending order.

In its latest version, 10.2, it looks at over 600 shares and should therefore be useful for anyone running a portfolio whether it be a HYP or not.

The way it calculates weightings and top up order may not be useful for people not running a HYP but then again - even if all you take from it are the share prices and the yields then that's fine too.

On tab 2 - Dividends it will automatically fill in the information provided from tab 1, i.e. ticker of each company and then, again on the press of a button, fill in the latest dividend information for each company (Ex-Dividend date, record date, payment date and dividend amount in pennies). I have added 2 more columns for shares held (which is a lookup on tab 1) and Dividend in £ so that I can get an inkling of incoming dividends over the next few months.

All in all: I use it to get automatically up to date information on share prices, yields and dividends and then take this data into my own top up calculator.

ANuvver 31 Dec 2012 , 6:00pm

Thanks for that pinch (and itsallaguess). I'll give it a squizz.

Pinchthepennies 31 Dec 2012 , 6:14pm

I've tried finding it online when I wrote my post - but found that it had been removed so I posted to itsallaguess and he's uploaded the file again.

Here's the link - but I don't know how long it will stay there...:

http://www.gamefront.com/files/22802774/HYP+Top-Up+Spreadsheet+-+v10.2.zip

Pinchthepennies 31 Dec 2012 , 6:17pm

This is a link to a thread about the spread sheet with an explanation of itsallaguess as to when he updates and uploads it - last post it is - don't worry only 9 posts in the thread:

http://boards.fool.co.uk/latest-hyp-top-up-spreadsheet-link-not-working-12665810.aspx?sort=whole#12715025

Pinchthepennies 31 Dec 2012 , 7:36pm

"Every investor should play chess."

@goodlifer

Let's just hope that this doesn't mean that one has to be a good player!

Happy New Year everyone!

jamesbennett1981 15 Jan 2013 , 8:34am

I would class myself as a HY investor. I automatically purchase additional shares with any dividend - my question is how do people view these purchases? My personal way of valuing these is that i class the share purchase at zero cost, any value above this is profit as i have not 'invested' this cash as such. Therefore I have two value pillar - 1. Any Share Value Growth 2. Dividiend Related Income.
Thoughts?

Join the conversation

Please take note - some tags have changed.

Line breaks are converted automatically.

You may use the following tags in your post: [b]bolded text[/b], [i]italicised text[/i]. All other tags will be removed from your post.

If you want to add a link, please ensure you type it as http://www.fool.co.uk as opposed to www.fool.co.uk.

Hello stranger

To add your own comment, please login.

Not yet registered? Register now.