Working out PPI calculations

[Klw2601]

Afternoon, sorry to ask something again

I have actively searched the forums and found some spreadsheet but im still at a loss as to how you get a guide figure of PPI redress. I have 2 more loans from a SAR that I need a figure for. This is the first if I can manage to copy and paste correctly..

 

[Klw2601]

And the second is here which was paid for 31/48 months. I just can't seem to fathom out and calculations

[dx100uk]

can you put those into ONE multipage pdf so we can zzoommm please

read upload

 

how to calc is in my sig below

 

 

[Klw2601]

Hi again dx, I'm so sorry I don't know how to do that and I can't see a signature ?! I'm not very good with technology I just managed to screenshot the document. Should I delete it ? Thanks for all your help

[honeybee13]

For the 'signature', if you look at the bottom of dx's post, below the sentence in red block capitals and the one in black block caps, no 2 is Reclaim PPI with a link in blue to click on. I think this is the one dx means.

 

HB

[dx100uk]

point 1 read it through 

[dx100uk]

PPIPCM= 1174/6174*100=19%

 

so anything you paid and when 19% was PPI on that payment date

was this 1st loan paid off by another?
 

[Klw2601]

Hi dx no it wasn't the 1st ended Jan 03 and the second started June 2004, I'm so very useless I just can't work anything outx

[dx100uk]

so there you go then done it for you. above

 

use the statint sheet

put every PPI payment in on the day you actually paid....

 

i'e you made a payment 3rd august 2004...19% of that was for PPI..thats what you put in the spready

then the next etc etc.

 

you do the same on their own statint sheet for the other 2 loan

using the same calc PPIPCM%=

PPI/PPI+Loaned sumX100=PPIPCM%

[Klw2601]

Thanks dx, one more question

 

the final payment I paid 6014.71 after 6 months,

presumably because the ppi was front loaded and the loan was only 5000 that final payment included the rest of the total ppi (1174 added at the beginning)

 

if i got a rebate would it of shown on the statement as i cant remember from so many years ago!? 

[dx100uk]

whatever it was you need the date and the rebate.

then you enter that as a MINUS figure in the spready same as a PPI payment on the date they made it.