reclaiming my dads various PPI's from Lloyds Bank

[NGEddie]

Sorry don't know what you mean? :/ is this a spreadsheet?

[dx100uk]

thought you already had the spreadies thread?

 

http://www.consumeractiongroup.co.uk/forum/showthread.php?330996-Latest-Spreadsheets-PPI-Claims-and-Charges-Claims-Dec-2011

[NGEddie]

Nope

 

Now I have, do you have to fill in all those columns in?!

[dx100uk]

that's why I said 'ideally'

 

you can ofcourse use the CISHEET.

 

dx

[NGEddie]

aha, but I didn't really want to do it through the courts, and it doesn't appear to work out the 8% :/

[dx100uk]

on credit card they charges you compound int

so you charges them it

 

if the card is not active anymore or the int stopped at some point

 

set you claim to date to them.

 

then take the total from the cisheet

 

and pop that into the statint sheet

 

from the claim from date of the cisheet

 

you are entitled to 8% statint

from the date they stopped charging int

to the date of settlement of your PPI claim

 

dx

[NGEddie]

month formula

.

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

 

or use search engine

 

then just pull that formula down

 

dx

 

This just seems to make the days increase rather than the month each time?

[NGEddie]

Also dx I need to enter the rebate amounts they gave back, as this is going to be a long sheet with a few rolling over should I enter all the rebates at the end? or after each loan last payment rolling over?

 

I didn't get what you meant by :-

 

don't forget to blank the resultant minus figure in the int col

 

I usually enter the PPI % of any rebate as a minus figure and blank the 8% column

 

dx

 

either?!

[dx100uk]

see link 1 below

 

as for the month formula

 

type it in a search engine

 

that's where I found mine

 

dx

[NGEddie]

Thanks again dx, I like the way you make me work for the answers because it actually really helps me understand I have a habit of scanning not reading often

 

one thing I couldn't find though, with this :-

 

So the final entry in the spreadsheet of claim should be £200 and the date of that entry should be the date of the rebate. This then ensures that you are compensated for interest on that £200 from the date of rebate right up until now.

 

What happens when there are a few rebates and they all need to go on the same sheet? I didn't know if to put them all at the end together, or after each loan and final payment?

[dx100uk]

rebates ideally go in date order in the sheet as they happen

 

dx

[NGEddie]

Thanks, let the typing commence!

[NGEddie]

As I am doing this, I have the dates for the supposed PPi rebates, but cannot find any entries on the bank statements, but can clearly see the loan monies themselves going in, seems strange?

[NGEddie]

I have actually found them all apart form one for £500 odd! which is no where to be found, all other went into current account at time of settlement and clearly said...insurance refund!

 

I guess it was missed by them, oopsy!

[NGEddie]

Another point, on doing the calculation for the ppi amount rolled over...

 

If I do the ppi % of the settlement figure paid, it is about £150.00 less than the progression sheet makes it out to be :/ so which one do I take notice of?

 

Cheers

 

E!

[dx100uk]

i'd not worry too much

 

they'll more that likely go over the sheets or produce their own anyhow.

 

lets get the claim in

 

and see what rattles

 

dx

[NGEddie]

Ok if you think not then

 

I am right in once the ppi % is found, you find that % of the settlement figure and that is the amount that rolls into the next loan yes?

[dx100uk]

yep

 

however

 

did you not say you identified the rebates was for PPI in each case?

 

dx

[NGEddie]

I did, then on the sheet I have listed that figure, with the rebate below it, so leaving the difference, correct?

[dx100uk]

so you need to enter the full ppi rebate into the sheet as a minus figure and blank the resultant minus int col entry then.

 

dx

[NGEddie]

Cool thats what ive done, the repayments listed, then settlement, then the - rebate

[NGEddie]

So then, I have entered all of them up until the loan was paid off early by additional borrowing from the mortgage, the dates and amounts are clear as day.

 

I would guess from here on in, I am using the % of the PPi from the loan, on each mortgage repayment? This is where it gets tricky, as its from 2002 to current, so a lot of entries! Where the mortgage payment has altered I would think I need to recalculate the % again?

 

At this point, that's so much for all your help dx, your a legend, and others too

 

Cheers

 

E!

[dx100uk]

yes -

 

the loan was paid off by the mortgage

so a % of that payoff was PPI.

 

you wont need to recalc the loan PPI % no

 

but what that % of the mortgage repayment represents in £'s

[NGEddie]

Ok thanks, am just getting the figures together as the additional was like a part 2 on the mortgage...aaaand I just realised the mortgage has ppi on it too, lol, so if we cant find agreement I guess SAR the mortgage company?

 

One think I am puzzled about, we know a % of the ppi rolled over into the mortgage, which is still being paid off now, so how do I calculate that on the spreadsheet, as if we are lucky and get a successful claim we are still effectively paying it off after they have paid out :/ ?!

[dx100uk]

exactly the same method as described above.

 

xx% of each mortgage payment is cc ppi.