ppi credit card with yorkshire bank reclaim help

[daveg]

hi bill-k thanks for your reply on the caculations thread ,my claim is with a yorkshire bank credit card which i took out in 1995 when in the forces, the card was in use until 2006 and is now closed.
clydesdale refused to uphold so i went to fos,it took me 6 months and 3 sar attempts to get copy statements but they only go back to march 2000 and some from that year are missing. Fos agreed that i should get my ppi back but they would only refund from 2000 to 2006.
I did nt agree so went to the ombusman who has provisionally upheld in my favour pending further evidence from clydesdale, he was due to give his final decision after the 19th of march, am still waiting but they have told me no reply came from clyesdale so am quite confident it is being upheld. This has so far taken two years but i feel we are nearly there.
In his letter it states they have to put me back in postion as per fos guidelines and are to take an average ppi/balance/payment for the first year they have statements for and apply it to the years from 95 to 2000 ,wonderful news .
what i would like to do is to try to work out what i should be looking at in way of a refund as i dont trust them as they have been very obstructive and difficult in all dealings since this began.
i have tryed to use your calulator but arnt sure how to input the average years /payments on the spreadsheets.
I apreciate all or any help please and realise you guys are unindated on your excellent site , it will be 3 months before i expect anything from clydesdale reading other peoples experences any way .
many thanks
dave g

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

Hi Dave, and thanks for starting a thread for this - it keeps things simpler.

First of all - well done for getting your claim upheld in the face of what sure looks like obstruction from Yorkie Bank & Clydesdale. Sure - once a claim goes to the FOS, it can take months on end to get a result - so I'm glad your patience has been rewarded.

OK., so it looks like the FOS are saying that you take an average PPI payment from the first 12 months that you have statements for. You can do this quite easily, my friend - either on a fag-packet (God forbid !!!) or on a basic calculator. Add up the PPI from the first 12 statements that you have - then divide this by 12 - and that is your average PPI payment to use for the pre-2000 estimates. You need to know what the date of the first PPI payment would have been - if in doubt, take this as 1 month after you opened the account.

Post up here:

1. The average PPI payment that you calculated;
2. the date of the first PPI payment;
3. the date of the first 'statemented' payment.

I'll then gladly post up a spready that has all the estimated rows in it.

You then need to copy and paste your 'known' figures into the remaining rows.

Let's do it.

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

hi bill thanks for your help i do understand how to do the average ppi however using my statements is nt straight forward . The first supplied is 17/04/00 showing bal from 20/03/00 of 1488.86 with ppi of 10.27 ,but i then have no further statements until18/10/00 which gives a bal from19/09 of 1518.92 with a payment of 70 on the 2/10 showing ppi of 10.09 ,as i d ont know what payments i payed for the months prior to this statement it is hard to give a true average. Also in dec i payed of my balance of 1495.84 in full so when i try to give averages it shows unrealistic amounts ,not sure if i can apply these to the period they have no statements november95 until march 00.
The amounts anyway are average balance of 1258.22,ppi of 8.43 and payments of 163.98 this being so high due to paying of the balance,more realistic payments were 70 per month.
When reconstructing the account over such a long period of time using this average would this give a realistic amount ?
hope this makes some sense thanks again for your patience and heip it really is appreciated
cheers dave g

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

If the 12 month period they have used for estimating the average monthly PPI from 1995 - 2000 is a year in which they only have a record of two payments, then I agree that this will not produce a very accurate result, and I would certainly question their method. If there are 'holes' in the records, then the fairest way would surely be to tot up every PPI payment that they DO have a record of - and then divide this by the number of payments that make up this total. If what you have is what they have sent you in response to your DSAR, then their records MUST be the same as yours, Dave.

So - punch in all your figures into the Credit Card spreadsheet, then add up the number of PPI payments that you have entered. Now, take the total of PPI paid (at the top of the PPI column) and divide that by the number of PPI payments, and you have the average PPI payment for that period. It would be a good idea to enter the date, followed by a blank row, for each month that there is no record or no payment made. You can then fill in the missing months with your average figure.

It is also a good idea to note which rows have estimated values in the 'item description' column - just enter the letter 'E,' for example. If you can do this, and post your spready here, I will check the calculations and create a complete spready starting at the account opening date in 1995.

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

thanks for that bill , i will do what you advise and get my better half to help me as i m not so good with computors!
As soon as its done i willget it loaded on for you.
As yet i do not have any figures from clydesdale but it would be nice to know what it should be before they supply them , have a great easter bill hope you get plenty of eggs
cheers dave g

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

I know it's a tedious job, Dave, but it will need doing eventually - so now is a good time to do it. Do give my apologies to your dear BH, though !!!

This tip may make the job a little easier. After you have entered the first date in cell D12, enter the following formula in cell D13 below it, then keep copying it to the cells below:

=DATE(YEAR(D12),MONTH(D12)+1,DAY(D12))

This will automatically add 1 month to each date, so you don't have to keep entering the date each time. You will need to check it, though, as payment dates fluctuate, and you may need to over-write with the actual date on some lines.

Have a good Easter yourself, Dave, thank you. I won't expect any eggs at my ripe age - but something in a bottle would be nice. We'll see...

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

hi bill hope you had a great easter and got a nice bottle of something ,i am having trouble logging on to download your spread sheet ,everytime i try to do it it says i m not logged on ! any ideas please thanks dave g

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

Hi Dave - yep, I got my bottle, so I'm a happy Easter bunny !!! I can't think why you're unable to download the spready. Try downloading it from this post - I've attached a copy of it (with the date formula I mentioned earlier already in cell D13 for you). If still no joy, send an email to Simiantics@gmail.com - and I'll send you it from there.

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

PPI SPREADSHEET.xlsHi Bill we managed to get logged on and i have loaded up all the details from all the statements that i have , the account was opened in october 1995 , hopefully i have done it all correctly so there will be enough information.
I have had to show two or three interest amounts as there was different rates for cash/purchase/transfer balances not sure if these are listed in the correct way , anyway i am at your mercy so do your best please and i look forward to your reply.
many many thanks a very greatful user of your si
cheers daveg

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

Hi Dave - yep, I got my bottle, so I'm a happy Easter bunny !!! I can't think why you're unable to download the spready. Try downloading it from this post - I've attached a copy of it (with the date formula I mentioned earlier already in cell D13 for you). If still no joy, send an email to Simiantics@gmail.com - and I'll send you it from there.

Hi bill -K , glad you got your bottle and had a great easter,not sure why we could nt get the spreadsheet to load but daughter had a go and bingo we got it wish i understood computors! We have now loaded up the spreadsheet so hopefully i have done it correctly ,if you could take a look it would be great ,many thanks in advance cheers dave g

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

Hi Dave - I'm currently looking at the spready, and hope to get a result to you shortly. There are a few glitches to iron out.

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

Hi Dave - I'm currently looking at the spready, and hope to get a result to you shortly. There are a few glitches to iron out.

Thank you bill -k really appreciate your valuable time ,there is no rush with this so if you are busy with other stuff no problems,thanks dave g

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

Here's what I've got so far, Dave. I've taken your data and copied it into a fresh spreadsheet.
Then I have looked over it for errors and corrected them, where I thought it was required. Errors with dates occurred a couple of times, but I think that's about all.
Next, I took the rows which had different levels of interest charged, and reduced them to one row each, with the total interest for that month.
Next, I used what appears to be the 'Purchases' APR rate of 27.9% and applied that in column J 'Annual APR Interest Rate.' This needs to be checked to ensure that it is correct, and to account for any changes over the life of the account. PPI premiums are usually classed as a purchase, and so that is the rate we use when calculating the attributable account interest.
Next, I estimated missing values, using calculations based on their individual 'contexts.'

so - I think I have a useable spready for 2000 to account closure, with the gaps closed up with estimates. What I must ask you to do now is go over it and check that the APR is correct, and that my corrections and alterations are also OK. Once we have that nailed down, I can use those figures to estimate the pre-2000 PPI, and will generate a spready with this period included.

So far, we seem to have a claim 'quantum' of around £3500. My guess is that the pre-2000 estimates could add approx. £2000 to this. Can you remember what month in 1995 you opened the account ?

[Bill-K]

Re: ppi credit card with yorkshire bank reclaim help

Well, here's my pre-2000 estimate added to the above spready. and it increases the claim to around £6100. Instead of taking an average of the 2000-2001 figures - which seems inaccurate to me, I have slowly built up the Balance Owing from zero to the amount shown in the first statement we have a copy of. I'm sure this is the FOS preferred method - but even if not - it makes more sense to me than trying to find an average balance from just one year. I hope this is helping, Dave.

[daveg]

Re: ppi credit card with yorkshire bank reclaim help

hi bill , wow what can i say , the biggest thank you for your expertise ,your time , your undoubted patience , i marvel at you guys you really are something special.
The sums are much larger than i was expecting so i am more than happy with what you have worked out for us and you want to see the smile on my lovely wifes face she is already planning a trip to sunnier climes ha ha , we will now see what the calaculations work out when clyesdale get there finger out ! However it will be increasing on a daily basis so no complaints there ,i m not entirely sure how all the figures work out bill but i can see that you must have put alot of time in to work them out and i and my better half are extremley greatful. Once we do get sorted your fantastic site will be getting a slice of the pie in way of a donation .
Bill thanks again i will keep you posted on the outcome cheers dave g