Premium Bond Winner ?

Macsidia

Holding £43K. Back to a more bog standard month for October with a modest £75 win (1x 25, 1x £50). I suppose it’s still a lot better than nothing.

Brings my total now to £1,225 for 2024 with just 2 draws remaining. Hopefully I can have a strong finish to the year as Nov/Dec last year was terrible.

Bravepants

joshii said:

Nil return on £39k for the first time since January.

Jan 24 - £0
Feb 24 - £125
Mar 24 - £200
Apr 24 - £150
May 24 - £200
Jun 24 - £150
Jul 24 - £125
Aug 24 - £100

Sep 24 - £200
Oct 24 - £0

Very good three digit run though!

llewdiskram

Only £75 on FH, my partner got £300 on FH.

I’m convinced at some point I will get a big win, I do think about putting it into a savings pot to get more on interest, but then worry I won’t get my big win 😂

GarbageGuy

£41k invested  £600 Prizes in the last 4 months

fredflower

SnowMan said:

fredflower said:

I also realised it wouldn't work for the year where I bought a block rather than auto reinvested.

You can use the XIRR function for more complicated scenarios where only some winnings are reinvested, and where you buy a new block of bonds, to calculate the average annualised return over the whole period

1. The purchase of bonds including the initial purchase should be treated as +ve cashflows in this function at the date of purchase.

2. Any winnings reinvested in bonds should be ignored completely as cashflows in this function, as these reinvestments form part of the return you are trying to calculate and so you don't want to consider them as cashflows

3. But any winnings paid out and not reinvested should be treated as -ve cashflows (as you are taking the money out of premium bonds) at the date they are paid out.

4. And the final cashflow is the value of bonds you hold now but treat this as negative (so a cashflow of minus 5,100 at say 1st September 2024).   

The XIRR function can be a bit volatile in some circumstances, because there isn't always a unique answer, but it should work OK in this scenario.

For example applying this to the last year gets the same result as before of about 19%, see cell I8 and the formula in the formula bar. The first date is 1st December 2023 because you have to hold bonds for a full month for them to qualify for prizes. The slight difference from before (19% vs 18.9%) is because before we were treating all months as having exactly the same number of days. Of course there are no cashflows of type 3 in this example because all winnings were reinvested. But where there are type 3 cashflows the previous method doesn't work.

Thank you again and sorry for the late reply. 😊 I was hoping to add this new calculation but it seems my brain is mush. I briefly looked at your reply a few weeks ago, Googled the XIRR function, then promptly forgot to do anything while it was fresh in my mind and made sense. 🤦‍♀️

Another complication that comes to mind is that the amount in my totals column would be true for those months without a win as being the 1st of the month, but the win months the amount is increased, but could be anytime in the first week of the month as the draw date varies. 😒

I want my brain back! 🤞

eskbanker

fredflower said:
Another complication that comes to mind is that the amount in my totals column would be true for those months without a win as being the 1st of the month, but the win months the amount is increased, but could be anytime in the first week of the month as the draw date varies. 😒

Not sure I'm fully understanding what you're trying to say here, but there's no need for a spreadsheet model to reflect individual days within a month, so one line per month should suffice - obviously prizes paid during the month will increase the total holding going into the next draw, but the exact date of payment within the month shouldn't matter?

fredflower

Swipe said:

fredflower said:

One thing I noticed on my NS&I online account is that there's no mention of my earlier wins. The wins were received as a cheque rather than my later ones that I set to auto reinvest, but surely they should still be showing on the system..? 🤔

I've checked previous paperwork against what is currently on my account and the holder's numbers match though the hole in data and no more wins for those bonds does make me wonder...

The paper record sent in 2011 when I bought more bonds shows the holder's number, but not an NS&I number. Is it possible to have multiple NS&I numbers?

Thoughts please. 

You could write to them and ask for them to send you the records they have for you internally that the portal doesn't show.

I was hoping to clear things up with a quick phone call but it seems the very polite bot is no good for that and just told me to write to NS&I (as you did). I wrote, waited several weeks, then got a missed call about my complaint (it was a query and/or observation, not a complaint), then a week or so I received a letter regarding my complaint (it wasn't a complaint!! 😤)...

They sent me a summary of all my bonds (not needed as that is complete online) and this is already out of date as I've won again since. 😁 They explained that the online transaction history only shows the past 12 months. This is wrong as mine shows the previous 3 years. There was no mention of the online prize history, though they could confirm my previous wins that do not show online. They did say they'd be sending me my full prize list, though it's been 3 weeks and still no sign.

If they have the information it wouldn't take much to display it all online with filters for years or some way to search a range.

Oh well, at least I know they have records of all my bonds and they are all still active in the draws. 🙂 

fredflower

molerat said:

Swipe said:

fredflower said:

One thing I noticed on my NS&I online account is that there's no mention of my earlier wins. The wins were received as a cheque rather than my later ones that I set to auto reinvest, but surely they should still be showing on the system..? 🤔

I've checked previous paperwork against what is currently on my account and the holder's numbers match though the hole in data and no more wins for those bonds does make me wonder...

The paper record sent in 2011 when I bought more bonds shows the holder's number, but not an NS&I number. Is it possible to have multiple NS&I numbers?

Thoughts please. 

You could write to them and ask for them to send you the records they have for you internally that the portal doesn't show.

What does your on line bond holding show ?  All bonds held against your account should be showing and if not then something is amiss.

On my account the prize history only goes back to 2020.

The list of bonds was correct and complete, but the transaction history and prize list were incomplete. They wrote to tell me only the past 12 months are shown in the transaction history, which is total nonsense as mine goes back 36 months and yours even further.

I just find it very odd (and irritating) that the online information is incomplete. 😊 

PowerSavingMode

SnowMan said:

SnowMan said:

£100 'win' on £1,000 holding

Quality (of holding) over quantity is important

With average luck I can expect another £100 win once in the next 5 years

£100 'win' again this month on £1,000 holding after that previous £100 'win' in July. So as it happened didn't have to wait 5 years but 2 months instead.

How wonderfully lucky! 

I've just won £100 this month on a £3K holding, the last win being £25 in June 2023. So not sure how that ranks in the 'luck stakes'...

fredflower

After reading the latest posts I think I'm doing very well this year. I started with £4475 and now have £5200 (all £725 of my wins have been auto reinvested). 😍 The Aug & Oct wins come from the win reinvested in Feb. 😁

Jan £0
Feb £500
Mar £0
Apr £25
May £0
Jun £0
Jul £0
Aug £50
Sep £50
Oct £100

Let's hope my luck continues...