This article can be read by selected Monevator members. Please see our membership plans and consider joining! Already a member? Sign in here.
Index-linked gilts: how to price, value, and track them in your portfolio with our spreadsheet [Members]
Next post: FIRE-side chat: secret squirrel
Previous post: Weekend reading: Trading places
Comments on this entry are closed.
Wonderful. Personally, I like spreadsheets, and I like reading; reading about spreadsheets is a whole new level 🙂
I downloaded v1 for future use. Could you post a note in the comments in case of any updates or corrections?
Many thanks!
Heh heh. Yes, sure will.
When I click the spreadsheet link it just opens up as a new tab on Firefox. I have goggle docs on my tablet. I know how to make and edit the spreadsheet but how do I get it from the link to goggle docs.
I’m shocked that this hasn’t got hundreds of comments…
Many thanks – I got interested in I-L bonds through youthful reading of Troy, Ruffer and CGT, but has it worked for them (Arrested Development gif)? Maybe it has – it certainly should have, given how smart they all are.
But I think ultimately they are still in my ‘too hard’ pile (which sounds better than my ‘I’m not smart enough’ pile…).
It’s probably a cop-out – I’m not a gold bug, but it has seemed to work better for me as an inflation hedge.
Anyway, often things change, and I come back to look at stuff, so I’m very grateful for this and the other article, and will no doubt be reading it carefully in the future.
@Tom — Cheers, and I know. Strangely silent after the huge debate on Linkers last week, and it’s not for lack of Mavens opening and reading the page.
Maybe everyone is just linkered out 😉
Re: Gold, grateful to have some, wish I hadn’t top-sliced it a few months ago… 😉
@Garry — Sorry to hear of your troubles.
I’m not sure exactly what your asking? Are you saying the new tab doesn’t show the spreadsheet? I’ve tested I can’t recreate that here. If this is so then perhaps you have some kind of security feature blocking it?
If you can open it on any device (e.g. desktop) where you’re logged into your Google accounts (e.g. gmail or Google drive) then you should be able to save the document there and re-open it on the tablet.
With that said I wouldn’t want to edit this kind of spreadsheet on a tablet, personally. It’s quite fiddly!
Hope this helps.
This series on linkers has been so valuable as a resource. As I move into deaccumulation I’m trying to simplify matters, thinking of what happens if I get hit by the proverbial bus and leaving my spouse to deal with this stuff, would a linker component to the portfolio be a step too far? Perhaps the complexity is just in the buying…
Anyway it’s definitely food for thought and thanks for all your efforts.
@ Tom and Larsen – Thank you! I know where you’re coming from. They’ve been in my too hard pile for years as well. It’s definitely a learning curve. Not because the material is inherently hard but because it’s scattered about like the fragments of some universe-vaporising super-weapon. And there isn’t a handy manual.
Once you get past all that, linkers are pretty much just a tradable index-linked saving certificate – with a better yield these days.
Hold ’em to maturity and you can’t make a loss if you buy in at a positive yield. One thing I probably haven’t mentioned enough is that Tradeweb publish the real yields on a daily basis.
I’m really keen to set up some linkers but don’t know what I’m doing. I want to make sure I understand the principles. So please forgive what will probably be the first of several silly questions about your spreadsheet.
In the first block, the dirty price (J) for TR26,T27 and T28 is calculated differently from that of T301. It seems to be because you have n/a as the index value for T301 (column U) But today (20th November 2024), looking at https://www.dmo.gov.uk/data/pdfdatareport?reportCode=D1D, I think I can see an index value for T301 of 2.83494.
My main question is why/when is a different formula used for the dirty price for some gilts? Secondly, am I right to now use the same formula for all 4 gilts?
Thank you
Hi David,
These are excellent questions and I can see I neglected to explain the difference. My apologies!
T30I is an 8-month indexation lag linker i.e. it indexes to the inflation rate 8-months ago (as opposed to 3-months ago, which is the standard used by most index-linked gilts today).
T30I is an example of an older type of index-linked gilt. This type uses a different formula (from the 3-monthers) and its index ratio should not be used.
TR26, T27 and T28 are examples of 3-month indexation linkers. This type have effectively succeeded the 8-monthers and their formula does require the index ratio.
There are only two 8-monthers left in circulation: T30I and T2IL.
Thank you.
I think this spreadsheet is a masterpiece!
I bought a very small amount of TR26 – UK Index Linked Gilt 2026 on 22/11 – Friday. I can leave a comment on that over in the ‘How to buy index linked-gilts’ post.
Anyway, the purchase was done on Friday, with Settlement on Tuesday 26/11. I plugged the values from my broker’s contract note in here and it all worked perfectly.
Even better than that, although I had to wait until the 26/11 the indexation ratio was published by the DMO, I found that plugging in all the data, including the settlement date and the ‘units double check’, I could use the goal seek function to tell me what the indexation value should be when it was published, to make the other figures make sense.
When it was published, it was correct, to 5 decinal places that the DMO use, so super impressive.
Thanks, Jam. It’s great to hear the spreadsheet helped. I was hoping it’d encourage more people to dip their toe into linkers but the muted response to this post makes me think it’s still too beardy an area for most.
Appreciate hearing about your experience on the other thread, too.
I’m retired and am happy with the current value of my share portfolio.
I’m not looking for further capital growth but do want to be protected from inflation.
While I procrastinate the value of my portfolio increases but Monevator has educated me in the dangers of that!
I’m very keen to dip my toe into linkers and then hopefully go in up to my waist.
Thank you for what you’ve written on this topic.
I tried to buy some gilts (T27) through IWeb and it gave me a clean price in line with expectation.
When I tried to make a trade it said it could not be completed automatically but had to be submitted as a negotiated order.
Is this normal? I don’t like buying something when I don’t know the price.
Hi David – I’m guessing that you have to place a telephone order? Is that what they mean by a negotiated order?
Snowman reported his experience with Halifax Share Dealing which is essentially iWeb under a different brand name:
https://monevator.com/how-to-buy-index-linked-gilts/#comment-1844172
He was able to buy his linkers online but neither were T27. It seems some brokers are running a hybrid system of online and telephone orders depending on the bond.
The article linked to above summarises the experience of a number of Monevator readers who’ve bought linkers via telephone trades – which is standard at a number of brokers.
The broker will give you an indicative price (which to be fair, is what I get when I place an online order).
That indicative price – whether clean or dirty should be close to the price you can see on Yieldgimp or using the spreadsheet attached to this article.
So far, nobody’s reported anything amiss. The system does seem to work, it’s just arcane like a wizard’s beard.
Thank you for your further comment and apologies for not responding more quickly.
I’m not asking for a response to this post. Just letting you know what happened in case that’s useful.
I didn’t raise a telephone order.
I simply allowed iWeb to submit a ‘negotiated order’ and then got notification of a trade about 30 minutes later. The price was very close to the clean price when I first attempted to make a trade.
This trade was for a trivial amount so I wasn’t concerned about the price. But I’m temperamentally uncomfortable about committing to spend a lot of money on something when I don’t know the price.
I remain very keen on linkers and will be reading through your posts and looking to other sources so that I can use them.
Thank you again for your posts on this topic.
To add to comments by others the articles on linked gilts have been very useful. Another option on the defensive side of the portfolio. Maybe held outside of an ISA as I understand you don’t pay CGT although you may pay tax on interest. I have purchased a few to test how it works. The way platforms display the clean price like you have made an immediate loss is off putting. Ill give it a little more consideration before purchasing more but definitely an option worth considering.
Good morning. I am a brand new member and struggling to understand index linked gilts. I have taken a look at the spreadsheet and will need to take quite a few more looks to understand it properly !! I wondered if fellow readers could ‘pull apart’ this simple scenario.
Say an individual has just retired and only (luckily) needs their portfolio to match inflation to provide the lifestyle required.
They have a portfolio worth 300,000 and need 10,000 a year for their desired lifestyle. They guess they will live for another 30 years.
Could they ‘simply’ on day 1 of retirement buy 10,000 GBP of index linked gilts each maturing one year after the next between year 1 and year 30. When an individual initial 10,000 GBP gilt matures it will ‘pay’ enough back to ‘live their life’ until the next gilt matures the following year and so on and so on ? Does the scenario fall down because there is an implied inflation in todays gilt price so this only protects if inflation turns out to be higher than that implied in todays pricing ? … if so then how can this implied inflation be protected against ? I know I am missing something …. perhaps a lot … all comments welcome
thanks
Miles
@Miles – this article and accompanying spreadsheet deals with the scenario you’re describing: https://monevator.com/index-linked-gilt-ladder/
That said, when you buy linkers today, the price includes inflation as measured by the RPI index – with a lag of three months. In other words, the price in Feb includes all changes in RPI up to November. Not implied inflation but actual inflation.
So £10,000 spent today on linkers buys £10,000 worth of linkers in today’s money – providing we’re not overly concerned with the index-lag, which we shouldn’t be.
So let’s say you want to live on £10,000 at the end of year 1 (adjusted for any inflation accrued in the mean-time).
You buy enough linkers so that their maturity value in one year plus any interest earned in the meantime = £10,000.
All of the linker’s cashflows will automatically adjust in line with inflation during that year because that is how the security is structured. If inflation goes up then that increase will be included in the interest and maturity value you receive as and when the linker pays out.
The same goes for the linkers bought to cover years 2 – 30. You buy enough in today’s money to cover your £10,000 income needs per year. The inflation-adjustment mechanism of each linker covers you for inflation going forward.
So, essentially I’m saying that you’re accurately describing how an index-linked gilt portfolio works when structured to deliver inflation-protected income.
But the price doesn’t include implied inflation it includes actual inflation.
Implied inflation is contained within the yield of nominal gilts. Nominal gilts provide insufficient protection against inflation if it proves higher than expected. But nominal bonds outperform linkers if inflation proves to be lower than expected. You may have read descriptions of the “breakeven rate” which could be where this idea of implied inflation has arisen?
Anyway, I hear you when you say it’s a struggle to get to grips with bonds. It really is!
You should be able to find most of our coverage here:
https://monevator.com/tag/index-linked-gilts/
I hope this helps!
@Miles #18
What you have described will work, it is a an Index Linked Gilt Ladder, as @The Accumulator has said. You will get you investment back, increased in line with actual inflation, plus a small amount extra (the real yield) over the the 30 year period.
Here is a link to a useful site: https://www.yieldgimp.com/index-linked-gilt-yields
See the column ‘Yield’ / ‘(Real)’, for the real return you will get.
So you plan is sound, unless of course you live longer than 30 years!
Taking a step back, what you are trying to do it seems is to come up with a plan to live of a pot of money, for the rest of you life and not lose spending power in real terms, not knowing how long you will live. This is an old investment problem and it is not the first time it has been considered.
Can I suggest reading the book ‘Living Off Your Money’, by Michael McClung. It is a bit of a favourite in these parts. Expensive, but it will replay the cost many times over. It goes through the problem and comes up with what I think are better solutions than the index linked gilt ladder and has heavily influenced my own approach to the problem you describe.
I just used your spreadsheet to help to make my first (test) linker purchase. There’s one thing that I couldn’t figure out and that is how to tell if you are buying a linker from the market at a premium or not, after the inflation and accrued interest adjustment? I can see that the inflation adjusted clean price on the spreadsheet results from multiplying the index ratio with the clean price from the LSE (or implied clean price), and I can see where the dirty price is coming from (inflation adjusted clean price + accrued interest). And I can compare to the indicative broker dirty price before placing the order and on the actual price on the contract note. But how do I tell if I’m paying over or under the odds for a particular linker on its journey towards maturity? Sorry if I’ve missed the obvious…
@Ian #21
>how do I tell if I’m paying over or under the odds for a particular linker on its journey towards maturity?
You will end up paying what the market price is, which can obviously fluctuate depending upon a whole host of things, including expectations of inflation.
However, I think what you want to know is at what price will the IL Gilt be redeemed at. That price is £100 Clean, increased by the up-lift in inflation, i.e. the dirty price at maturity.
Looking here:
https://www.londonstockexchange.com/stock/TR26/united-kingdom/company-page
you see the clean price of TR26 is roughly £100, so you won’t make any gain or loss there. Back as recently as 2022, you can see the clean price was £116, so you would have paid out £116 (clean), to get £100 (clean) back. The real yields on them were negative, this is how that negative real yield showed up in the price.
If you look at TG51, the clean price is roughly £58 now, so you will make a nice profit, as the clean price increase to eventually be £100 at maturity.
Does this help?
YieldGimp.com is now an app, but this is an alterntive website:
https://dividenddata.co.uk/index-linked-gilts-prices-yields.py
The real yield to maturity is in the right most column.
@Ian – apologies if I’ve misunderstood the intent of your question, but you just use the clean price. The clean price effectively exists to tell you if you’re buying over or under par. Above £100, you’re paying above par i.e. the bond is paying a higher rate of interest relative to new issues. Below £100, you’re paying below par i.e. the bond is paying a lower rate of interest relative to new issues.
You strip out inflation in order to get that information.
I don’t think the bond’s price should be construed as paying over or above the odds. The price above or below par is a mechanism to adjust yield-to-maturity. YTM (or real yield in the case of linkers as Jam says) is your return and can be compared to other investing opportunities – adjusted in light of the risks you’re hoping to manage 🙂
Equivalent bonds of the same type and maturity will offer the same yield-to-maturity or else they become illiquid. So if you want a linker that matures in 2028, then any linker that matures in 2028 should offer approx the same yield. (In reality you almost always only get a choice of one linker per year but that’s by the by.)
As Jam says you will make a capital gain as a below par bond’s market price returns to £100. This is to compensate you for its paltry interest payments relative to what the market demands for holding debt today.
If the price is above par then you don’t make the capital gain – in fact you make a loss – but the compensation is the bond’s higher rate of interest (the coupon column on the website Jam linked to).
Long story short, real yield is where it’s at. They’re pretty high at the mo.
@Jam & TA – thanks that’s very helpful and makes perfect sense, but there’s still a gap in my understanding. There are some IL bond prices well over £100. For example, T30I with a particularly high coupon rate of 4.125 maturing in 2030, a price today of £340 and a yield to maturity of minus 19.838. So potentially a big capital loss at maturity. I’m struggling to understand the logic of why anyone would now invest in that – if you can help me figure that out I’d be really grateful!
The YTM you’re quoting for T30I isn’t right. Perhaps because the site you’re quoting can’t cope with 8-month linkers?
Tradeweb is showing a yield of 0.58% for T30I on 22 Apr 2025. It matures 2030, so we’d expect its yield to fit in between the yields for the 2029 and 2031 linkers.
Again quoting Tradeweb, 22 Apr:
2029 yield is 0.38%
2031 yield is 0.67%
So that 2030 yield of 0.58% looks about right.
T30I has a huge coupon versus other linkers. So the high clean price, and the capital loss implied, is required to reduce its return to a yield that makes sense relative to similar linker investments.
Despite the capital loss, you’d still earn an inflation-adjusted return of around 0.58% per year as long as you hold until maturity in 2030. So T30I is every bit as competitive as similar inflation-linked gilts. The dodgy yield you’re seeing is what’s throwing you.
Hopefully that makes sense? I personally find bonds very counterintuitive and it doesn’t help when websites throw up weirdness like that minus yield.
Thanks TA, that clarifies things. It’s the LSE website showing the confusing minus yield to maturity. I’ll register for Tradeweb, but in the meanwhile ShareCast just now shows the T30I Gross Redemption yield as 0.57% so close to what you saw on Tradeweb.
YieldGimp now trying to charge £2.99 pcm for yield to redemption, HRT and ART grossed up equivalent yield data. Shame. It was a good app for data on both linkers and conventional gilts. Tradeweb it is then for ILG data.
Quite agree @Delta Hedge. There is Tradeweb, although you might also like this: https://dividenddata.co.uk/index-linked-gilts-prices-yields.py
That’s super helpful and looks to be a great resource – thanks @Jam. 🙂 Added now to my bookmarks.
From last week’s Economist:
Would inflation-linked bonds survive an inflationary default?
https://www.economist.com/finance-and-economics/2025/10/15/would-inflation-linked-bonds-survive-an-inflationary-default?giftId=221ec546-1118-4c1a-b1fa-ee2dd4361458&utm_campaign=gifted_article
There is also a special report “The coming debt emergency” (of rich world governments), worth reading.
Such headline news probably indicate govt bonds are decent value. Still I’m avoiding nominal bonds, it’s too likely they will be inflated away.
And the DT bangs the warning drums on ILGs too last week:
https://www.telegraph.co.uk/business/2025/10/22/how-the-treasurys-debt-gamble-crushed-britains-finances/
@DH and Jam – It’s worth checking that third party site data lines up with Tradeweb. I’ve discovered a few instances where they’ve been pretty sloppy. Nothing huge but the discrepancies make me think the provider isn’t particularly diligent.
The Economist article sums it up nicely: “Though no asset is truly safe, these bonds come close.”
It reminds me why you’d never want to be 100% in any asset class and why a ‘floor and upside’ portfolio makes a great deal of sense.
Thanks @The Accumulator, I han’t spotted anything obviouly wrong with it myself, but will keep an eye out for if it looks wrong when I next use it.
I do have a little bit of good news to report for anyone who is swapping their ILNSC’s for IL Gilts: You don’t need to wait until maturity to get your money, I cashed some in the day after an anniversary date (but before maturity) and only lost 1 day’s worth of interest (all 0.01% of it! i.e. few pence). So the moral here is you don’t need to wait for them to mature, if you are keen to swap.
For me personally the good new is all my tranches of ILNSC’s paying CPI+0.01% have been converted to RPI+(roughly) 2%. The safest money for nothing trade I have ever done.
The bad news is that I had 9 tranches of them, so moved an unusually large amount of money. This has clearly raised a flag with Interactive Investor who has asked me to fill in a form explaining the source of my wealth, or they will suspend my account. Yikes!
Thank you for the excellent series on ILG. I dipped my toe and bought a few ILGs for my approaching bridge years following your advice and it all went as expected. I’m now trying to understand how to calculate their real value for a monthly check. If I understand correctly, the formula is basically dirty price x the number of units divided by 100? One thing I don’t understand is why I would need to calculate the dirty price using the spreadsheet when dirty prices are listed on websites such as https://dividenddata.co.uk/index-linked-gilts-prices-yields.py and https://giltsyield.com/bond/inflation/ ? What am I missing?
@An observer – Thank you, I’m glad it helped and you had a good first experience.
Re: dirty prices – you’re not missing much I don’t think. There was basically only one site offering a live dirty price when I wrote this piece, then they ducked behind a paywall.
(Completely fair enough btw, they were putting a lot of work into it and providing a valuable service. TI and I have paywalled some of our stuff, too. It’s the only way to keep going. )
I’ve noticed that some of the newer sites often make mistakes. Not massive ones necessarily but it bothers me a bit, especially when you can’t tell who they are or why they are.
Still, calculating the price yourself is also painful. I’ve almost finished another spreadsheet that does it all automatically but real life has gotten in the way 🙂
I haven’t looked at either of those sites in a while. My memory is that they were pretty good when I spot checked them. But I have no idea how long they’ll last, so I’ll get my spreadsheet done one day. Or maybe the brokers will sort themselves out.
I think LateGenXer still maintains his site too: https://lategenxer.streamlit.app/Gilt_Ladder
Looks very good.
And Tradeweb is definitive but not live and a very slow site:
https://reports.tradeweb.com/closing-prices/gilts/
Thank you! I noticed slight differences in dirty prices on the two sites (at the level of the decimal) so a Monevator spreadsheet that calculates them automatically would be much appreciated! Grateful as ever for all your work.
I want to use linkers to preserve capital value, but before I put thousands of pounds into them I wanted to do a test so I spent £100 on a trade.
The test worked and proved you are right – but I don’t know why. Please explain.
Maybe my misunderstanding is that I thought each unit would redeem at £1 and it was always going to be more than that?
On 29/11/24 I invested £100 to Purchase 63.15 UKGOVT OF 0.125 IDX/LKD 22/03/26 Ref:21RB6DQA
Consideration £94.98, broker fee £5 and accrued interest 0.02.
The broker fee is fixed, so I’m not bothered about that in my analysis.
I received 6p interest three times in March, September 2025 and in March 2026.
Throughout the period since I bought the gilts my portfolio has been showing a loss of 35% ish. Why does it do that?
When the gilt matured on 22/03/26 I received £99.54 – not the £63.15 I was expecting.
£99.54 + 18p = £99.72 so my original £95 grew by 5%. which I guess must relate to RPI over that period.
If I buy a gilt, where do I find what I will be paid back when it matures? I expect to get paid X+RPI/CPI, but what is X?
I’d be thankful if you could explain!
@David – My apologies in advance if I’ve misunderstood your question.
If you were redeeming a nominal gilt then it the price would be £1 per unit.
However, an index-linked gilt redeems at £1 per unit (£100 per gilt) plus the change in the RPI index over its lifetime.
The reason your linker shows such a grievous loss after purchase is because you bought at the dirty price but your broker displays the clean price. (On screen, not in the contract note.)
Dirty price is the cost of the investment incorporating inflation adjustments (its real value).
Clean price is the cost of the investment with inflation adjustments stripped out. (Not its real value but an industry standard used for the sake of comparison. Not helpful for retail investors trying to understand what their investment is worth.)
Essentially your broker is being lazy. They could show the dirty price but don’t because it would mean spending resources on updating their systems. AJ Bell does shows the dirty price, it’s doable.
When you bought in (and assuming you hold to maturity) you were destined to receive:
X interest payments up to and including maturity date. Each payment = The coupon rate (except the £ payment per unit is adjusted for inflation over the lifetime of the linker).
DMO publish the amounts per gilt here: https://www.dmo.gov.uk/data/ExportReport?reportCode=D5I
(Divide by 100 for value per unit)
Redemption payment = £1 per unit (again, adjusted for inflation over the lifetime of the linker. See the link above for redemption payment announcements.)
The inflation adjustments are unknown until the RPI figures are in. Once they’re in then you can use the DMO’s values published at the link above to work out how much you will receive given the number of units you hold.
Your 5% gain reflects inflation but also, if you stripped inflation out, you earned a yield to maturity too. See: https://monevator.com/bond-terms/
So if I’ve understood your question correctly, X is £1 per unit. But you weren’t destined to receive £63.15 on the basis that you bought £63.15 units.
The reason being that the linker’s redemption value (or principal) is also adjusted for inflation.
Your linker’s redemption value was £157.294357 per gilt or £1.57294357 per unit. If I multiply that by your holding of 63.15 units then I get a redemption value of £99.33.
Pretty close to your £99.54. There’s probably some other rounding errors in there too 🙂
If you haven’t seen them then these posts may help:
https://monevator.com/how-to-buy-index-linked-gilts/
https://monevator.com/index-linked-gilt-ladder/
I can send you some links to the DMO’s underlying formulas if you want to take it further. Tragically I did and found the maths works. Whenever I find a discrepancy I always find that I’m the source of it 😉
Hope all that helps.
Thank you so much for spending time on this for me, I have a whole load of preconceptions, some right, some wrong that I think are confusing me.
In broad terms, are you saying that when I paid £95 for 63 units the price was already about £1.50 so that’s why I got what I got. And that if inflation has been zero thereafter, I would have received my £95 back in March at redemption?
And if there had been no inflation between the date the bond was issued and the date. I bought it, I would have paid £1.00 instead of £1.50
But actual inflation between those dates meant the £1.00 units were already worth £1.50
And if my broker wasn’t so lazy, he could have shown my trade with a bought price of £1.50 and the value of my investment as £95 when I did the trade.
And he could have also have updated the current value of my investment in nominal terms to include the inflation. In the same way as he shows the price I bought a share for and the market price now.
Or at least they could update the bond price monthly after RPI/CPI announcements.
And of course, show the total trade nominal value change too.
Hopefully you won’t say no. But if you do, let me read your comments again before troubling your time again.
Thank you
David
Hiya,
Yes, you are spot on. The only thing I’d add is that even if inflation didn’t change after your purchase (and 3 months before – your linker is aligned to the RPI index -3 months when adjustments are calculated) you would have earned more than £95 on redemption.
This is where the clean price comes in handy (it may be on your contract note).
Your linker’s end-of-day close price (clean) was £99.638 per gilt.
This is approx what you bought for if you strip out inflation. Divide by 100 for unit clean price.
Hold to maturity and you will earn £100 per gilt (clean or as a result of zero inflation.)
So approx 0.363% of your gain was profit i.e. real yield-to-maturity (over and above inflation.)
I can see on Tradeweb that the real yield for your linker at close on 29 Nov 2024 was 0.4%. The difference is the cost of the accrued interest i.e. the deduction made because you earned interest on the bond (on the next dividend day) that you weren’t entitled to. That is, the interest accumulated before you purchased.
You can check the numbers here:
https://reports.tradeweb.com/closing-prices/gilts/
Tradeweb show a close-of-play dirty price of £149.997071 which tallies with your £1.50 estimation of the unit price you paid that day.
So it tallies, you bagged a small real yield and your money was protected from inflation.
I’ve just checked and coincidentally I bought the same linker (TR26) on 28 Nov 2024.
My numbers are very similar to yours.
Aside from that, I’d just like to note that bonds are an absolute mind-bender 🙂
Thank you for your help. I agree the intricacies of indexed linked bonds could be described as mind-bending. But the overall concept is actually straightforward.
It seems like the confusion is largely due to by brokers showing the clean price rather than the dirty one.
Maybe a note on whether brokers are/are not “lazy” could be a customer service factor relevant for your platform selection tool.
If I am going to get serious about linkers, I’d like to see the accurate value of
my portfolio so may well move it to AJ Bell.
Thank you again for all your help – after a couple of years thinking about it I believe I now understand!
Very glad to help 🙂 Re: AJ Bell – You can buy linkers with just a click of a button so it’s like buying any other security. Many brokers only offer telephone trading at the mo, which sounds pretty laborious judging by reader comments. Costs are very reasonable too and I’ve never had a problem with their service (admittedly my needs are few.)
Best of luck with it!
It’s a personal thing, but I transferred to AJB and whilst their purchasing process is very much simpler I really wished they would show the clean price.
I would just like to know if their value has moved because the clean price moved, the index value changed, or whether the movement in one cancelled the movement in the other out. By showing only the current value it is not so clear.
Maybe the solution would be to show both and really confuse everybody!
I’m looking at the AJ Bell website and TR37 | GB00B1L6W962 (Treasury Index-Linked 1.125% 22/11/2037) price is currently 95.27.
So that means if I buy it, I get 1.125% interest per year and then in November 2037 get (100/95.27) x cumulative CPI change. So if CPI was 0% per annum for next 12 years (unlikely, but for simplicity in this thought experiment) I get £100 plus 12 x £1.125 or £113.50 for an initial outlay of £95.27?
Which is a 20% more than if, in a world where there there had been no inflation, I had left my £95.27 under the mattress for 12 years.
I’d be making about 1.5% a year in a scenario where my intention had simply been to preserve the buying power of the cash for 12 years?
Too good to be true?
@David – yes, you’re right. The real yield for TR37 is currently 1.56% i.e. the return you’ll earn per year if you hold to maturity and reinvest dividends at approx the same interest rate.
Or, you spend the inflation-adjusted dividends and earn a slightly lower annual return.
Does seem like a good deal given current rate of inflation, the going rate on cash in the bank, and the inherent purchasing power protections built into linkers.
@Jam – Haha. Yes, we have to be careful what we wish for. you can find a list of the clean prices here:
https://www.ajbell.co.uk/investment/bonds/gilts/prices
Or pop your linker’s ISIN number into the search field here for all kinds of useful info:
https://www.londonstockexchange.com/live-markets/market-data-dashboard/price-explorer