I have re-formulated the spreadsheet to take account of these problems: The sheet enclosed no longer has to be 'forced' to start if the account is paid in full every month. If a payment is not made in full it will record the interest on that months PPI payment and continue compounding that interest increasing the compound for each subsequent late payment entry. it no longer compounds all PPI monthly amounts only the ones that are charged interest on. For an acurate compound every monthly statement must be used even if there are no transactions on it and the the totals are zero. Any credits to the account can be shown as a negative entry in the payments column, as these are not payments until used as such. The 8% interest is now calculated on all PPI balances but not compounded. There is now a facility to use 10 different interest rates with a little editing (for more experienced spreadsheet users) or the simple single rate can still be used. Another column has been added to show a record of interest, late paymentcharges and account charges. No calculations require this column and they are there just for reminders, These figures will be included in the entries in column C, Monthly spend. The total of these charges will be shown as an entry at the bottom of the Awards Calculations. It may be useful for future use, it may not, but it now does the job for me. [ATTACH]46295[/ATTACH]

I don't see how thats going to make any difference to achieving a correct calculation. The two Negative entries are credits to the account which show when no other purchases were made, they are not payments. they put the account in credit, in one instance for 3 months. other instances of credits are normally swallowed into the monthly totals by reducing the monthly spend so don't show on the spreadsheet, only on the statements. The interest charges for the late payment in Aug 2006 doesn't show anywhere for interest purposes, and the compound interest column works on the amount of the PPI payment only.

I have checked back and found one late payment on the Mastercard where interest was charged, £12.17 I have attached the spreadsheet, but it doesn't take that interest payment into account on any of the calculations. and when a credit is issued to the card it throws a real wobbly. attached the sheet.[ATTACH]46249[/ATTACH]

I think I will send what transaction history I do have to the FOS and let them have a go.

No, I have CC statements that go back to 2005, I have bank statments that list individual payments to each account from 2002 to 2005 and I have HM Revenue returns that detail joint payments from 2002 back to 1996. This means that I have no record of cash payments/part payments from 2002 to 2005 and no archieves from 1992 to 1996

This has now totally confused me. would it be worth while doing a Data Subject Access Request, and would this show any more details or should I now just send the payment details I have to the FOS and let them sort it out?

But obvously there is something they are offering: £59 interest on £187 of PPI and £68 as the 8% on one account £109 interest on £158 of PPI and £142 as the 8% on the other The figures don't make any logical sense.

I really don't understand this, the PPI is charged every month on the spend at 0.4%, this is paid off every month. that monthly amount should now be credited back to me at the purchase interest rate i was contracted to. An amount is shown as the interest on the PPI on their offers then there is also an 8% interest total. So how is that interest on the PPI payments calculated if it is not compound, it is obviously not done at 8% as thats a seperate calculation and total.

Hi ims21. in a previous reply : In the results box you will only need to take note of the premiums pad and the 8% figure and ignore the compound interest. If the balance was cleared each month then no interest would have ben charged to the account. Although the amount was paid off each month, surely they still owe a compound interest on the amount of PPI that was paid to them. If I hadn't paid them they would have compounded the interest at the then purchase interest rate so as I have paid them and shouldn't have, they must surely owe me compound interest at the then purchase interest rate. Their offers to me included the PPI amount, interest on the PPI amount and 8% interest. so it seems like they are paying some form of interest other than the 8% simple rate. But without a breakdown of figures I have no way of knowing how they have done what. What I propose to do is construct 3 spreadsheets using modified sheets to take account of paying the account off each month and when the account was not used. sheet1 for the Visa account 2003- 2013 sheet2 for the Mastercard account 2003- 2013 sheet3 for the joint accounts 1996 - 2002 From sheet3, I will produce 6 yearly totals of spend and PPI, I will then produce 5 yearly percentage increase/decrease in spend. Then take a yearly average of payments and PPI of those 5 totals this will give an average increase/decrease for 5 years. Working backward by taking the 1996 total and decreasing the value by the average amount will give me a relative value for 1995, doing the same on each susequent years total back to 1992. Sheet3 will now show projected and actual payments from the inception of the account in 1992 to 2002 on a decreasing scale. As sheet1 and sheet2 show a 2:1 ratio of payment totals, I believe that spliting the total payments and PPI paid from sheet3 by a 2:1 ratio and adding the splits to their relevent accounts, will produce sheet1 and sheet2 as two complete sheets from 1992 - 2013.

Thanks for that. very interesting. The next thing I though of is, were these rates applied to every Barclaycard Visa account ? Mastercard didn't change their rate from 2005 to 2013, it stayed at 19.9% so I presume there have always been seperate rates for both cards. Is there any way of getting Barclaycard to disclose/supply historic rates on an account ?

Hi all Does anyone have historic purchase interest rates from 1992 to 2005 on Barclaycard Visa and MasterCard, preferably with start and end dates of variations

After 4 weeks from my last letter to BC demanding a breakdown of the figures they used to make their offers, no reply has been forthcoming, so yesterday (23rd Aug) I phoned the FOS and lodged a formal complaint about their refusal to explain/verify the amounts and their stonewalling tactics. unfortunately it could take 12 - 18 months. Should I continue to persue BC by letter or just let the FOS take the reigns. should I notify BC of the complaint?

OK, got a reply from BC which was a waste of a stamp. they state How they have done it but not What they have done, not a detail in sight, except, I now have a start date which was March 92. They are now saying that if I require account information I need to do a Personal Data Request also known as a Data Subject Access Request( Under Section 7 of the Data Protection Act) for which there is a £10 fee, then send it to the DP Team at Northampton. Also I need to obtain a copy of the Credit Agreement( Known as a section 78 request) and any document refer to in it, the request should be sent in writing to the Section 78 team at, Yes you guessed it, Northampton. should I continue to push for a breakdown of the calculations, which they obviously don't want to give or do a Personal Data Request and see what that throws up. The situation as it stands is : 1. I have calculated the individual card accounts with all the statements that I have back to 2005 on separate spreadsheets 2. Further individual payments on Bank statements back to 2003 on both spreadsheets. 3. further joint payments to BC for Mastercard and Visa on Revenue returns back to 1996, these cannot be split as individual amounts aren't available but the payment is made to BC they received the money, how they settled it with the two providers is not really my concern. This leads to 5. below 4. for 1 and 2 I have had to modify the spreadsheet as it does not take account of compound interest accrual when no ppi is paid although interest is still accumulating the previous balance. 5. I have a spreadsheet of all transactions combining MasterCard and Visa that I have payment records for from 96 to present day 6. I do not have the interest rates charged on the accounts prior to 2005 someone may have these back to 1992 ??? Is there a acceptable calculation that can be used to average a monthly amount for the years when information is not available? All help gratefully received

:?:Seem to have a problem, I wrote to Barclaycard and told them I did not accept their offers and asked for a breakdown of the calculations, interest rates and commencement date of the agreements. This morning I recieved two cheques from Barclaycard in final settlement even though I told them I did not accept it, should I reply to these people again or just take the case to the Financial Ombudsman. I won't cash the cheques.

many thanks, I will instigate that now.