Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@. Skimlinks & other affiliated links are turned on

Search
  • FIRST POST
    • Tom99
    • By Tom99 14th Mar 18, 7:08 AM
    • 2,068Posts
    • 1,392Thanks
    Tom99
    Corporate Bond online gross redemption yield calc
    • #1
    • 14th Mar 18, 7:08 AM
    Corporate Bond online gross redemption yield calc 14th Mar 18 at 7:08 AM
    Is there such a thing as an online calculator which will give me the accurate gross redemption yield of a specific bond I might want to buy or sell including the accrued interest to today's date that you will pay or receive?

    For example say I hold and want to sell the following bond:

    • British Telecom 8.625% SNR 26/03/2020 GBP (33GL)
    • Number of shares held lets say 8,000
    • Expected net sale price after dealing fees lets say 9,000

    I know I can do this in a spreadsheet but it would be nice to be able to double check my figures.
Page 1
    • bowlhead99
    • By bowlhead99 14th Mar 18, 7:19 AM
    • 7,833 Posts
    • 14,306 Thanks
    bowlhead99
    • #2
    • 14th Mar 18, 7:19 AM
    • #2
    • 14th Mar 18, 7:19 AM
    fixedincomeinvestor.co.uk has that one at a gross redemption yield of 1.457%
    https://www.fixedincomeinvestor.co.uk/x/bondchart.html?id=413&stash=F69FAA18&groupid=4

    They have a yield calculator tab at https://www.fixedincomeinvestor.co.uk/x/yieldcalc.html

    Obviously they are going off market price rather than your actual price including dealing fees etc but you could modify the price in the calculator to end up at what you actually pay per bond.

    As an aside, they have a variety of tables of prices/ yields for different classes of bonds (e.g.) https://www.fixedincomeinvestor.co.uk/x/bondtable.html?groupid=4 which can be handy for research but as they note in the caveats the figures used might be simplified and not account for quirks such as calls/prepayments or other redemption options.
    • Tom99
    • By Tom99 14th Mar 18, 7:54 AM
    • 2,068 Posts
    • 1,392 Thanks
    Tom99
    • #3
    • 14th Mar 18, 7:54 AM
    • #3
    • 14th Mar 18, 7:54 AM
    Thanks for that, it looks just the thing I am looking for. Does the yield quoted include the accrued interest to date it looks like it does?

    It looks like I would have to adjust the price in the calculator, I don't think just taking a pro rata of my price works.

    Also is the price I use the price excluding accrued interest or including?
    Last edited by Tom99; 14-03-2018 at 7:57 AM.
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

2,029Posts Today

7,945Users online

Martin's Twitter
  • It's the start of mini MSE's half term. In order to be the best daddy possible, Im stopping work and going off line? https://t.co/kwjvtd75YU

  • RT @shellsince1982: @MartinSLewis thanx to your email I have just saved myself £222 by taking a SIM only deal for £7.50 a month and keeping?

  • Today's Friday twitter poll: An important question, building on yesterday's important discussions: Which is the best bit of the pizza...

  • Follow Martin