Monthly income

13537394041

Comments

  • JohnRo
    JohnRo Posts: 2,887
    First Anniversary Combo Breaker First Post
    Forumite
    Calculating the total return of a holding over time.

    I understand the total stock return is the appreciation in the price plus any dividends paid, divided by the original price of the stock.

    Using SOI as my example I have purchased, received dividends, sold at profit, repurchased, received more dividends and currently hold.

    How would you calculate SOI total return from this data?

    EdLb8S6.png

    It's fairly obvious the net gain divided by the tax cost on each line gives the TR for that entry.
    I just then had a doubt whether the sale profit can be carried through to the subsequent repurchase soon after in this way and treated as one contiguous transaction chain, is the gain being properly accounted for in the TR figure or do I need to do some sort of rebasing calculation with the old cost and new cost?
    'We don't need to be smarter than the rest; we need to be more disciplined than the rest.' - WB
  • JohnRo
    JohnRo Posts: 2,887
    First Anniversary Combo Breaker First Post
    Forumite
    edited 23 April 2018 at 1:43PM
    I've cobbled a chart that plots the calculated total returns, this includes capital gain (also shown), dividends and any (not so) timely purchases and sales.

    It raises more questions than it answers imo..

    61spAbM.png

    The most obvious thing this demonstrates is the dreaded diworsification process in action. I realise there will always be a winner and a loser where more than two investments are held, it does beg the question whether PGIT in this case is adding any value whatsoever though.

    The aggregate plot is quite close to the portfolio as a whole so these two examples are the bigger picture in a nutshell. I'm looking to gleen some sort of understanding from what this chart is showing, other than the obvious, that laggards are a drag on winners, which is always the case regardless.

    I suppose the conundrum now and going forward is whether the losers will keep being losers longer term and the winners remain on top.

    PGIT is pushing close to an 8% yield currently while MRC yields close to a quarter of that. I can't see how that matters much though when the TR is the proof of the investment pudding.

    Then again the income stream is increasingly feeding the rebalance schedule alongside new money in, so that has a part to play.

    I'll chalk it up as the cost of diversification and hope the next crash mixes things up a little, if not I might have to start reconsidering holdings like PGIT.

    Any thoughts?
    'We don't need to be smarter than the rest; we need to be more disciplined than the rest.' - WB
  • fairleads
    fairleads Posts: 595 Forumite
    JohnRo wrote: »
    Calculating the total return of a holding over time.
    How would you calculate SOI total return from this data?

    EdLb8S6.png

    It's fairly obvious the net gain divided by the tax cost on each line gives the TR for that entry.
    I just then had a doubt whether the sale profit can be carried through to the subsequent repurchase soon after in this way and treated as one contiguous transaction chain, is the gain being properly accounted for in the TR figure or do I need to do some sort of rebasing calculation with the old cost and new cost?

    JR maybe you need to factor in the cost and amount of units purchased against cost and amount of units sold + annual divi
    i.e. (weighted average cost of units disposed minus weighted average base cost of the units ) + div
  • capital0ne
    capital0ne Posts: 872
    First Anniversary First Post
    Forumite
    This thread reminds me of the good old Derek and Clive dialogues!
  • JohnRo
    JohnRo Posts: 2,887
    First Anniversary Combo Breaker First Post
    Forumite
    DAY 1876 - (09/08/18) update for those interested.

    tl;dr - UKML ditched, more of the same.

    Not much has changed in the four months since last update, the antagonistic Trump trade wars and juvenile tweets rumble on, additional sanctions on Russia are in the pipeline and Iran is being promoted as the new focus of his 'do as I say, not as I do' road show.

    Despite this the portfolio valuation trajectory has changed markedly, not unlike the weather, as a rally from lows at last update continues, helped in no small part by strengthening USD and EUR versus GBP.

    r78YTIj.png

    UKML has gone, it's been a bit of a dog in the relatively short 2.5 years I've held it, very dissapointing overall with capital value falling almost 15% and a negative total return of -0.88% in that time.

    TFIF has also been trimmed temporarily as part of a phased shift from a GIA account into ISA. I may revisit the entire debt section of the portfolio at some point as all debt components are causing a relative drag which although entirely expected in rising markets, is being compounded by the uncertainty over RDL. I might instead look at ditching the entire debt section which is largely TR stagnant and instead adjust a strategic cash allocation outside this portfolio.

    gJ8Ca0w.png

    In the mean time the rebalancing continues, I'm not being dictated to entirely by spreadsheet as there are some contentious overlaps and values regarding purchases around the once monthly schedule and relevant ex-dividend dates. It'll all more or less even out over the duration though.

    vE5yDD0.png

    Trailing annual income continues it's choppy rise as new dividends are added to the front of the queue and the year old ones fall off the back. Current equivalent monthly average sits at £544.08 with an income target of £600 pcm in March of this tax year still looking achievable, the loss of UKML and a trimmed TFIF will be a setback though, so the timing will be tight.

    q9iXdyx.png


    In terms of percentage returns many of the rebalancing opportunities have started to evaporate as the downturn at last update has reversed with the total return plot once again decidedly on the up, it seems the long anticipated crash will have to wait.. for now.

    zQWQSM7.png



    Here are the scheduled purchases made since the last update in April.

    2018-05-02 438 HENDRSN F/EAST INC 3.73

    2018-06-01 2116 JPMRGN EPN INV INC 1.58

    2018-07-04 165 MURRAY INTL 11.33

    2018-08-01 1869 JPMN GLOB EMERG 1.26

    Hopefully the EM bias here and the timing proves useful longer term, only time will tell.

    The rising capital input and returns have helped to keep long term cost percentage reductions on track, annual average costs are still heading towards a number below 0.20% this year and should continue to fall away towards the intended trivial percentage value.

    One less than trivial value is the aggregate portfolio OCF, collated from individual KID documents and weighted accordingly to detail the overall internal charge. One or two of the holdings are lifting this number significantly so it's not particularly representative of the majority but still much higher than I would have liked or expected. That said, it is what it is.


    WO6FK1A.png


    The long run projection has obviously lifted since last update and remains on course to deliver something approaching an 8-10% annualised total return, which if maintained long term won't win any prizes but is plently good enough for me.

    POctv9S.png

    Here's the discrete annual performance chart, a chunky negative first quarter in CY 2018 has now gone positive two thirds of the year in thanks to the recent upturn.

    JaZAY1t.png

    That's all folks, hope the image overload provides some interest, next update around December.

    'Derek and Clive'... over and out.
    'We don't need to be smarter than the rest; we need to be more disciplined than the rest.' - WB
  • ColdIron
    ColdIron Posts: 8,900
    First Anniversary Name Dropper Photogenic First Post
    Forumite
    I got another Return of Capital/Liquidation payment from LSLI in June, did you? The gift that keeps on giving apparently
  • JohnRo
    JohnRo Posts: 2,887
    First Anniversary Combo Breaker First Post
    Forumite
    Yes omitted to mention it, it's bitter sweet.

    I was very disappointed with the initial wind up / restructure but the subsequent liquidation payments have been a pleasant surpise.
    'We don't need to be smarter than the rest; we need to be more disciplined than the rest.' - WB
  • Good to see your latest updates John, going well and reaching a great monthly income from your portfolio. Always read with interest thanks for sharing. I am working away on my IT's as well slowly but surely :)
  • JohnRo
    JohnRo Posts: 2,887
    First Anniversary Combo Breaker First Post
    Forumite
    I've decided to ditch the Vanguard US listed ETFs, VNQ and VNQI, it's a real shame but they're effectively locked down by the new PRIIPs regulations and their lack of a KID, which means platforms cannot allow them to be purchased.

    I thought I'd found a fairly decent solution to the global property allocation in these two but as usual I've been overtaken by events and only seem to have succeeded in creating more problems. It doesn't look likely the issue is going to be resolved any time soon so perhaps it's better to fix it now rather than waiting for a change in their KID status that may never arrive.

    I've looked at a few global property funds in the past but opted for the US ETFs at that time, hindsight... One is HDRP, there is also IWDP as an option, but it's relatively pricey and has a slightly lower yield.

    Problem is the HSBC ETF which otherwise looks attractive mentions a 5% entry and exit charge in the KID, first glance I assumed this was the old 5% entry charge most platforms now discount but I'm not sure about that with the additional 5% exit charge as well, does anyone know if these charges are applied internally or platform options?

    I'm not prepared to take a 5% entry and 5% exit hit, no chance, despite having no intention of selling.

    IWDP explicitly states there are no one off entry and/or exit charges, which more than compensates for the higher 0.59% OCF and slightly lower 3.07% current yield, this makes it the most likely option now.

    Choices seem very limited in this area but if you had to choose (fishing for suggestions) one global property IT / ETF as a replacement for VNQ & VNQI what would you choose?
    'We don't need to be smarter than the rest; we need to be more disciplined than the rest.' - WB
  • Thrugelmir
    Thrugelmir Posts: 89,546
    Name Dropper Photogenic First Anniversary First Post
    Forumite
    JohnRo wrote: »
    UKML has gone, it's been a bit of a dog in the relatively short 2.5 years I've held it, very dissapointing overall with capital value falling almost 15% and a negative total return of -0.88% in that time.

    Seeing your post reignited my interest in the stock. Personally I exited a long time back when the managers were struggling to invest the proceeds from the launch.

    Seems to be trading at a discount of 13-15%. Perhaps time to buy back into the stock. Yield of 6% isn't bad either. For an alternative form of fixed interest holding.
Meet your Ambassadors

Categories

  • All Categories
  • 342.5K Banking & Borrowing
  • 249.9K Reduce Debt & Boost Income
  • 449.4K Spending & Discounts
  • 234.6K Work, Benefits & Business
  • 607.1K Mortgages, Homes & Bills
  • 172.8K Life & Family
  • 247.4K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 15.8K Discuss & Feedback
  • 15.1K Coronavirus Support Boards