Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to bruncher,niord,gvonge,Shelford,GrahamPlatt, for Donating to support the site

Gilts short term strategy?

Gilts, bonds, and interest-bearing shares
mc2fool
Lemon Half
Posts: 7972
Joined: November 4th, 2016, 11:24 am
Has thanked: 7 times
Been thanked: 3071 times

Re: Gilts short term strategy?

#608056

Postby mc2fool » August 9th, 2023, 2:02 pm

daveh wrote:The only confusions for me is that on the trade confirmation the consideration for the gilts plus dealing commission adds up to a few pence less than the Net total due. There is no mention of accrued interest, but I'm assuming that's what the few pence difference is, but I was expecting to see it as a separate entry.

Assuming HSDL is the same as IWeb in this (as they're basically the same other than colour) then the webpage trade confirmation you get, indeed, does not itemise the accrued interest and leaves you with a total that isn't quite the sum of the other figures. However, if you wait for the PDF contract note to appear, overnight, that will show the accrued interest, and add up properly.

At least, it has for me, although apparently not always for others: viewtopic.php?p=605305#p605305

monabri
Lemon Half
Posts: 8475
Joined: January 7th, 2017, 9:56 am
Has thanked: 1555 times
Been thanked: 3452 times

Re: Gilts short term strategy?

#608076

Postby monabri » August 9th, 2023, 4:51 pm

mc2fool wrote:
daveh wrote:The only confusions for me is that on the trade confirmation the consideration for the gilts plus dealing commission adds up to a few pence less than the Net total due. There is no mention of accrued interest, but I'm assuming that's what the few pence difference is, but I was expecting to see it as a separate entry.

Assuming HSDL is the same as IWeb in this (as they're basically the same other than colour) then the webpage trade confirmation you get, indeed, does not itemise the accrued interest and leaves you with a total that isn't quite the sum of the other figures. However, if you wait for the PDF contract note to appear, overnight, that will show the accrued interest, and add up properly.

At least, it has for me, although apparently not always for others: viewtopic.php?p=605305#p605305


I purchased a chunk of TR24 yesterday (well, strictly, Mrs M did!). The platform was iWeb. The total spend was £5498.67.

Image

daveh
Lemon Quarter
Posts: 2237
Joined: November 4th, 2016, 11:06 am
Has thanked: 418 times
Been thanked: 819 times

Re: Gilts short term strategy?

#608154

Postby daveh » August 10th, 2023, 10:29 am

Yes the difference was in waiting for the pdf version. I have always printed off the web version as soon as it appears for my records, clearly a mistake.

So the difference was the accrued interest 17p for £5k of TN24 and 40p for 5K of TN25 bought yesterday.

Alaric
Lemon Half
Posts: 6116
Joined: November 5th, 2016, 9:05 am
Has thanked: 21 times
Been thanked: 1427 times

Re: Gilts short term strategy?

#608163

Postby Alaric » August 10th, 2023, 11:13 am

monabri wrote:I purchased a chunk of TR24 yesterday (well, strictly, Mrs M did!). The platform was iWeb. The total spend was £5498.67.


Presumably the "quantity" is the original nominal amount issued and the price quoted is inclusive of indexation? Do they manage to report it that way on the portfolio valuation.

mc2fool
Lemon Half
Posts: 7972
Joined: November 4th, 2016, 11:24 am
Has thanked: 7 times
Been thanked: 3071 times

Re: Gilts short term strategy?

#608165

Postby mc2fool » August 10th, 2023, 11:36 am

daveh wrote:Yes the difference was in waiting for the pdf version. I have always printed off the web version as soon as it appears for my records, clearly a mistake.

So the difference was the accrued interest 17p for £5k of TN24 and 40p for 5K of TN25 bought yesterday.

I always save (print to pdf) the web version and then download the PDF version a day or few later. You can, of course, infer the accrued interest from the web version from the unaccounted for difference, if you want to stick it into your spreadsheet before the PDF one becomes available.

Alaric wrote:
monabri wrote:I purchased a chunk of TR24 yesterday (well, strictly, Mrs M did!). The platform was iWeb. The total spend was £5498.67.

Presumably the "quantity" is the original nominal amount issued and the price quoted is inclusive of indexation? Do they manage to report it that way on the portfolio valuation.

The quantity is the number of gilts bought. The price is indeed the market price inclusive of indexation but, no, they annoyingly (although apparently, quite commonly amongst brokers) do not report it that way in the portfolio valuation, showing the unindexed market price instead, and so it looks like you've taken an instant ~33% loss. See viewtopic.php?p=604678#p604678

daveh
Lemon Quarter
Posts: 2237
Joined: November 4th, 2016, 11:06 am
Has thanked: 418 times
Been thanked: 819 times

Re: Gilts short term strategy?

#608204

Postby daveh » August 10th, 2023, 3:57 pm

mc2fool wrote:
daveh wrote:Yes the difference was in waiting for the pdf version. I have always printed off the web version as soon as it appears for my records, clearly a mistake.

So the difference was the accrued interest 17p for £5k of TN24 and 40p for 5K of TN25 bought yesterday.

I always save (print to pdf) the web version and then download the PDF version a day or few later. You can, of course, infer the accrued interest from the web version from the unaccounted for difference, if you want to stick it into your spreadsheet before the PDF one becomes available.



I'm clearly stupid as for 20 years I've never noticed the pdf version. I've always clicked on the bargain reference the same day I've done the deal, basically as soon as the confirmation email comes through, printed of the web based deal confirmation that pops up for my records, and that's it done. For share purchases it has all the details needed for my spreadsheet and I've never looked at a later date. So for all my previous deals I've never saved, printed or downloaded the pdf version of the trade confirmation.

Though maybe it didn't exist 20 years ago as I just randomly looked back at a deal in 2006 and there isn't a pdf version of the trade confirmation.
It seems the pdf versions came in between Oct 2017 and Jan 2018 - I've just looked back at my trade confirmations and a deal in Oct 2017 is web-based and a deal in Jan 2018 there is a pdf based trade confirmation. So maybe I'm not as stupid as i thought - i just haven't noticed for 5 years!

mc2fool
Lemon Half
Posts: 7972
Joined: November 4th, 2016, 11:24 am
Has thanked: 7 times
Been thanked: 3071 times

Re: Gilts short term strategy?

#608207

Postby mc2fool » August 10th, 2023, 4:20 pm

daveh wrote:I'm clearly stupid as for 20 years I've never noticed the pdf version. I've always clicked on the bargain reference the same day I've done the deal, basically as soon as the confirmation email comes through, printed of the web based deal confirmation that pops up for my records, and that's it done. For share purchases it has all the details needed for my spreadsheet and I've never looked at a later date. So for all my previous deals I've never saved, printed or downloaded the pdf version of the trade confirmation.

Though maybe it didn't exist 20 years ago as I just randomly looked back at a deal in 2006 and there isn't a pdf version of the trade confirmation.
It seems the pdf versions came in between Oct 2017 and Jan 2018 - I've just looked back at my trade confirmations and a deal in Oct 2017 is web-based and a deal in Jan 2018 there is a pdf based trade confirmation. So maybe I'm not as stupid as i thought - i just haven't noticed for 5 years!

Ah, you have a narrower window than I, as I tend only to deal around March/April (bed'n'ISA time), so on my investigation I was going to say they've only been around since sometime during tax year 2017/18, so you can let yourself off for around three quarters of your 20 years. :D

I'd say what's stupid is that there's no indication that a pdf version appears overnight. I can't remember how I stumbled across them....

GeoffF100
Lemon Quarter
Posts: 4809
Joined: November 14th, 2016, 7:33 pm
Has thanked: 179 times
Been thanked: 1387 times

Re: Gilts short term strategy?

#608209

Postby GeoffF100 » August 10th, 2023, 4:24 pm

daveh wrote:It seems the pdf versions came in between Oct 2017 and Jan 2018 - I've just looked back at my trade confirmations and a deal in Oct 2017 is web-based and a deal in Jan 2018 there is a pdf based trade confirmation.

I have got iWeb pdf contract notes predating that on file.

Aminatidi
Lemon Slice
Posts: 428
Joined: March 4th, 2018, 8:22 pm
Has thanked: 61 times
Been thanked: 116 times

Re: Gilts short term strategy?

#611301

Postby Aminatidi » August 26th, 2023, 12:26 pm

Quick question on YTM which I think I understand but not entirely sure.

Is this number "safe" to use for compounding calculations?

For example if I buy TN28 yeldgimp shows 4.59% as the YTM so let's use that for now.

Using a compound interest calculator shows £120K being worth £147,539.51 in 4 years six months.

Obviously it will be a bit less as there's a small 0.125% coupon but that final figure just looks a lot more than my gut reaction thought it would.

Either I'm wrong or Einstein obviously had a point :D

monabri
Lemon Half
Posts: 8475
Joined: January 7th, 2017, 9:56 am
Has thanked: 1555 times
Been thanked: 3452 times

Re: Gilts short term strategy?

#611308

Postby monabri » August 26th, 2023, 1:00 pm

I thought it was the case that one bought TN28 for 82.32 (*) and held to maturity at which point the bond value =100. So, the maturity value would be

(100/82.32) x £120k = £145.77k (plus a tad more from the coupon).


(so, don't compound the YTM percentage value)


(*) TN28 price by reference to:

https://www.dividenddata.co.uk/uk-gilts ... -yields.py

Aminatidi
Lemon Slice
Posts: 428
Joined: March 4th, 2018, 8:22 pm
Has thanked: 61 times
Been thanked: 116 times

Re: Gilts short term strategy?

#611317

Postby Aminatidi » August 26th, 2023, 1:18 pm

monabri wrote:I thought it was the case that one bought TN28 for 82.32 (*) and held to maturity at which point the bond value =100. So, the maturity value would be

(100/82.32) x £120k = £145.77k (plus a tad more from the coupon).


(so, don't compound the YTM percentage value)


(*) TN28 price by reference to:

https://www.dividenddata.co.uk/uk-gilts ... -yields.py


Actually that's probably a much simpler way of going about it isn't it - work backwards from what you know it will be worth on a given date and what you're paying for it on a given date.

Doh :mrgreen:

bluedonkey
Lemon Quarter
Posts: 1818
Joined: November 13th, 2016, 3:41 pm
Has thanked: 1422 times
Been thanked: 658 times

Re: Gilts short term strategy?

#611323

Postby bluedonkey » August 26th, 2023, 1:33 pm

But surely the YTM quoted return is an AER, therefore compounding annually would be correct?

1nvest
Lemon Quarter
Posts: 4565
Joined: May 31st, 2019, 7:55 pm
Has thanked: 727 times
Been thanked: 1446 times

Re: Gilts short term strategy?

#611325

Postby 1nvest » August 26th, 2023, 1:38 pm

Aminatidi wrote:Quick question on YTM which I think I understand but not entirely sure.

Is this number "safe" to use for compounding calculations?

For example if I buy TN28 yeldgimp shows 4.59% as the YTM so let's use that for now.

Using a compound interest calculator shows £120K being worth £147,539.51 in 4 years six months.

Obviously it will be a bit less as there's a small 0.125% coupon but that final figure just looks a lot more than my gut reaction thought it would.

Either I'm wrong or Einstein obviously had a point :D


https://www.yieldgimp.com/gilt-yields indicates a recent price of 82.31 and a yield of 0.125%, matures 31st January 2028, when you get the 100 value back. So on price appreciation alone 100 - 82.31 = 17.69. Or in gain factor terms 100 / 82.31 = 21.5%. With approximately 4 and 5/12 years (4.33 years) left before it matures, the annualised (compounded) price only gain factor = 1.215^(1/4.33) - 1 = 4.6%. That is tax exempt, so for a basic rate taxpayer at 20% tax they'd have to earn 5.75% gross to compare. So on £120,000 that gained 100/82.31 = £145,800 returned at maturity.

A factor is however that the guy that sold you the Gilt would have got some interest for the period between the last interest payment and the time you bought it, so the price you end up paying is increased by that interest payment amount, to cover the sellers fair share of the next interest payment amount, you in effect split that next interest payment amount in time weighted proportions. So adjusting for that and the compounded gain is less than that 4.6% figure as the price you paid was actually higher than the indicated price.

Additionally you'll get interest payments, 0.125% yield relative to 100 face value, which when you've only paid 82.31 = 0.125 / 0.8231 = 0.152% interest, where interest payments are taxable. But at so low yield the amount of tax is negligible. £120,000 invested, 0.152% interest = £182.40 interest, and 20% tax on that = £36.48/year tax type value.

So yes, the YTM figure is a indicator of the actual gain you'll get when the gilt is held to maturity.

If you compare that to a Index Linked Gilt https://www.yieldgimp.com/index-linked-gilt-yields
the T28 matures later in 2028, 10th August. also pays 0.125%, and a recent indicated price of 95.97. Now that's not the actual price you pay, as index linked gilts are all inflation adjusted, so you have to scale that by however much inflation there's been since the Gilt was originally issued (back in June 2018) and the present date. Similarly when it matures you wont get back 100, but 100 scaled by however much inflation there's been since its issue and maturity. A unknown amount, but at least you know you'll offset inflation and also get around a 100/95.97 gain on top, in real (inflation adjusted terms). Along with interest payments, that also rise with inflation. But again where you have to adjust that for the higher price paid in reflection of the sellers fair share of the next interest payment.

Comparing the two on price only, the nominal Gilt gains more, however with the index linked gilt you also have inflation added on top. Whichever of the two turns out to be better is subject to however much inflation there is between now and maturity. The Break-Even column provides a indicator for the comparison that currently indicates 3.83%. Which suggests that if inflation between now and maturity is higher than 3.83% then the Index Linked Gilt was the better choice, If lower than 3.83% then you'd have done better with a conventional Gilt. At a 95.97 price the Index linked Gilt is guaranteed to pay inflation, however that might be x 100 / 95.97 (again I haven't increased the actual price in reflection of paying the seller their share of the next interest payment), around 1% annualised real.

All rough values, for the actual accurate amounts you have to factor in all of the different elements, interest received, the sellers interest amount, the precise timing to maturity ...etc. Where that actual more precise calculation is presented in that yieldgimp table.
Last edited by 1nvest on August 26th, 2023, 1:42 pm, edited 1 time in total.

mc2fool
Lemon Half
Posts: 7972
Joined: November 4th, 2016, 11:24 am
Has thanked: 7 times
Been thanked: 3071 times

Re: Gilts short term strategy?

#611326

Postby mc2fool » August 26th, 2023, 1:41 pm

Aminatidi wrote:Quick question on YTM which I think I understand but not entirely sure.

Is this number "safe" to use for compounding calculations?

For example if I buy TN28 yeldgimp shows 4.59% as the YTM so let's use that for now.

Using a compound interest calculator shows £120K being worth £147,539.51 in 4 years six months.

Obviously it will be a bit less as there's a small 0.125% coupon but that final figure just looks a lot more than my gut reaction thought it would.

Either I'm wrong or Einstein obviously had a point :D

As you're going from yieldgimp, taking their currently shown market price of 82.31 (ok ok, only 0.01 difference from the dividenddata price!)

=YIELD(TODAY(), "31-Jan-2028", 0.125%, 82.31, 100, 2) gives 4.5849%, which rounded to 2 decimal places matches up with yieldgimp's 4.59%

As monabri points out, what you are buying is (100/82.31) * £120K = £145,790.30 of par value, which is what you'll get on 31-Jan-2028, and on each and every 31st of July and January until then (inclusive) you will receive £145,790.30 * 0.125% / 2 = £91.12 for a total of £820.08 in coupons.

(All ignoring accrued interest for simplicity!) (Edited for typos)
Last edited by mc2fool on August 26th, 2023, 1:44 pm, edited 2 times in total.

Aminatidi
Lemon Slice
Posts: 428
Joined: March 4th, 2018, 8:22 pm
Has thanked: 61 times
Been thanked: 116 times

Re: Gilts short term strategy?

#611327

Postby Aminatidi » August 26th, 2023, 1:41 pm

bluedonkey wrote:But surely the YTM quoted return is an AER, therefore compounding annually would be correct?


This is where I think I may have confused myself as maths isn't my strong point.

But with gilts there's the capital gain and the coupon.

Once paid each coupon no longer counts towards the gilt return presumably?

i.e. the next coupon on TN28 can't contribute towards future returns once paid because it's been paid.

Aminatidi
Lemon Slice
Posts: 428
Joined: March 4th, 2018, 8:22 pm
Has thanked: 61 times
Been thanked: 116 times

Re: Gilts short term strategy?

#611330

Postby Aminatidi » August 26th, 2023, 1:49 pm

Just to add I don't feel I understand index linked enough to go there.

Rightly or wrongly I'm attracted to these for the tax benefits and the simplicity and certainty they seem to offer but with the option to "take the hit" and sell in an emergency (unlike fixed rate savings account).

I'm still trying to find the sweet spot and TN28 looks like it might fit the bill.

I did have this money in "wealth preservation" funds but again rightly or wrongly I'm finding them too opaque to be comfortable with them lately plus there's a wider piece of work I'm doing around simplifying and moving more to passive investments.

bluedonkey
Lemon Quarter
Posts: 1818
Joined: November 13th, 2016, 3:41 pm
Has thanked: 1422 times
Been thanked: 658 times

Re: Gilts short term strategy?

#611331

Postby bluedonkey » August 26th, 2023, 1:51 pm

What I like about low coupon short dated gilts is that you get a post tax return similar to a fixed term deposit but you can cash in at any time. With a fixed term deposit, you can't usually access the money before the term is up.

The quoted value of my recent purchase of TN24 is slowly appreciating each week. I do realise that an unexpected change in BOE rate can upset this but then it just means waiting untill closer to redemption date.

bluedonkey
Lemon Quarter
Posts: 1818
Joined: November 13th, 2016, 3:41 pm
Has thanked: 1422 times
Been thanked: 658 times

Re: Gilts short term strategy?

#611333

Postby bluedonkey » August 26th, 2023, 1:54 pm

Others will be able to comment on IL gilts better than I can. The big picture though is that they behave in a kind of halfway between equities and conventional gilts.

Aminatidi
Lemon Slice
Posts: 428
Joined: March 4th, 2018, 8:22 pm
Has thanked: 61 times
Been thanked: 116 times

Re: Gilts short term strategy?

#611335

Postby Aminatidi » August 26th, 2023, 1:59 pm

bluedonkey wrote:What I like about low coupon short dated gilts is that you get a post tax return similar to a fixed term deposit but you can cash in at any time. With a fixed term deposit, you can't usually access the money before the term is up.

The quoted value of my recent purchase of TN24 is slowly appreciating each week. I do realise that an unexpected change in BOE rate can upset this but then it just means waiting untill closer to redemption date.


And this is exactly the penny that dropped for my recently.

What I'm trying to understand and make a decision on is the "sweet spot" on maturity because as you say BOE rate changes can influence the market price.

I'm liking the optionality that being able to sell at any point (albeit with risk of a loss) provides though.

bluedonkey
Lemon Quarter
Posts: 1818
Joined: November 13th, 2016, 3:41 pm
Has thanked: 1422 times
Been thanked: 658 times

Re: Gilts short term strategy?

#611338

Postby bluedonkey » August 26th, 2023, 2:09 pm

That sweet spot is personal and depends how urgently you might need the money prior to redemption. The longer to maturity, the bigger any potential drop. I think TN24 with a redemption date of 31.1.24 is not going to deviate much from a slow appreciation.


Return to “Gilts and Bonds”

Who is online

Users browsing this forum: No registered users and 6 guests