Monthly income

JohnRo

Lokolo wrote: »

Sorry I don't want to derail - but - how have you calculated total return? Do you store your dividends elsewhere?

I have an Income Portfolio myself, and have a similar layout to yours apart from the total return, as I have not recorded the cash paid out. Is this what you have done?

Yes, the total return calculation is the combined capital gain (which takes account of transaction fees) plus all dividends received plus all interest earned less all explicit platform charges.

[STRIKE]I started with a mix of funds then added trusts and subsequently sold all the funds so those funds and the income from them are incorporated in the current rolled up dividend total as well as the explicit platform fees they incurred. By the end of the next tax year the numbers should provide a more suitable snapshot of how the current trust only holdings are doing.
[/STRIKE]

...scratch that, I'm getting confused, it's in the same spreadsheet but I haven't been posting that info here, so everything posted on here relates to the trusts held although the cash used to purchase them has in part come from the sale of those funds and the dividend income they generated less the fees they incurred.

I have each holding individually itemised as well so can easily look at various parameters for each element in isolation if needed. I've decided to time purchases using ex dates which massively skewes the real net annualised yield initially but it should soon settle to something approaching the quoted yield after a couple of years or so.

The only platform cost incurred going forward is the transaction cost of each trade and nothing else until or unless CSD change their charging structure.

mike88 wrote: »

Are there any plans to reduce the number of holdings?

Not really, I want give it some time before I decide to start consolidating, or not, but that said I've decided LWI will go and EDIN absorb that allocation. Looking to add the two mentioned above, BRCI and PEW at some point in 2015 and possibly BEE or some other European equity income holding to complement EAT at some point but not for the next year or two.

I know the UK allocation is crowded but want to see how things develop over the next year or three before deciding what or whether to trim and reallocate.

mike88

JohnRo wrote: »

Not really, I want give it some time before I decide to start consolidating, or not, but that said I've decided LWI will go and EDIN absorb that allocation. Looking to add the two mentioned above, BRCI and PEW at some point in 2015 and possibly BEE or some other European equity income holding to complement EAT at some point but not for the next year or two.

I know the UK allocation is crowded but want to see how things develop over the next year or three before deciding what or whether to trim and realocate.

That's probably a sensible approach as it took me nearly 20 years to reduce my portfolio from 30 odd holdings down to 16. I found that there was such a difference in performance between holdings in individual markets that i decided to back my judgement by opting for the smaller number.

TheTracker

Lokolo wrote: »

Sorry I don't want to derail - but - how have you calculated total return? Do you store your dividends elsewhere?

There are spreadsheet templates online. Here is an example that gives YTD, 1, 3, 10 year (and more) returns of your personal portfolio and is one of the best I have seen.

JohnRo

Update - day 622

All starting to feel pedestrian and predictable which was the plan from the start, stress free mechanical process.

Next priority purchase is JEMI some time before the ex div 12th March. Hoping the SP takes a tumble this week but no doubt that'll happen the day after purchase.

Still planning to add BRCI (and possibly PEW after the wind up vote) at some point in the new tax year.

Here's the latest pictures for those interested.

TrustyOven

Some really nicely done graphs there. You must be an Excel or OpenOffice wizard!

JohnRo

A bit of imagination goes a long way, it's actually quite easy to make the graphs, it's the calculations in the data sheet that have taken some considerable time and effort, initially at least, I've often had to ask for oocalc help on here.

Here's another graph, over time the process of rebalancing with new money should pull each plot towards the 0% axis whether it's positive or negative.

This includes the last rebalance of 2014 (JEMI) and next three rebalances due in the new tax year, I'm using the ex div dates for timing purposes so there's no guesswork or emotion involved. BRWM is a top three priority but the next ex-div date is months away so that's why it's not selected. Likewise BRCI & PEW purchases are on hold for now.

TCA

JohnRo wrote: »

BRWM is a top three priority but the next ex-div date is months away so that's why it's not selected.

I think BRWM should already have gone ex-dividend John (based on previous years and their interim results statement), but there appears to be a delay in announcing the annual results, which they said would be mid-Feb. Hanging onto the bad news no doubt.

JohnRo

Yes T you're right, not sure what's going on at BRWM, its reputation has already been dented and this doesn't help matters.

I have it showing a final dividend was due to go EX on 6th March estimated at 14p and then the next interim EX towards the back end of August. For some reason I thought they had already declared it but it won't affect my schedule anyway as this years allowance is used.

That's assuming they will declare it some time this (tax) year. Let's see what they decide to do... the one silver lining is that whenever the next BRWM rebalance takes place it'll reduce that 34% deficit substantially.

TCA

JohnRo wrote: »

I have it showing a final dividend was due to go EX on 6th March estimated at 14p and then the next interim EX towards the back end of August. For some reason I thought they had already declared it but it won't affect my schedule anyway as this years allowance is used.

FYI John, results are out for BRWM and the dividend will be paid on 8th May:

http://www.investegate.co.uk/blackrock-world-mng--brwm-/prn/final-results/20150319164500P167D/

"Maintained final covered dividend at 14 pence per share payable on 8 May 2015 to shareholders on the Company’s register on 27 March 2015 (ex dividend date is 26 March 2015)"

JohnRo

So Catherine is clearing off, or was she pushed? It sounds like the whole London Mining fiasco really has given them all a huge kick up the !!!!, hopefully it spurs them on to greater things in future.

I'll schedule a BRWM rebalance in time for the August Interim, hopefully it won't be cut.