simple interest will be what you get if you use the statint sheet

wou need to remove your pers details from the spreadsheet pdf..

you cannot sadly include litigation charges

dx

Sorry I realised that too late and could not remove the attachment,

it is however only a slight extension to my username and there isn't much personal details,

it does not have my address or phone number or email so I thought it probably wouldn't matter much,

on the litigation charges perhaps you can see how many of them there are with very little time between them,

as far as I am aware the only litigation which took place was once only back in 2009

some of the charges only have a few weeks in between them so cannot possibly be litigation in terms of it's definition.

I have asked them for a full explanation of these charges and hopefully they will respond.

Finally managed to complete the spreadsheet,

I have taken most of the litigation costs off but have left three of them because it is impossible that these costs would occur

less than 8 weeks after the first lot of charges and they have only instigated court proceedings once throughout the loan period.

I have asked them to provide more details regarding these litigation costs and also the 'adjustment' charge, as yet they have not replied.

They have however replied to some of my questions,

but have been evasive and only re stated that all questions are answered in the SAR they sent,

but they were not, or else why would I be asking?

Another mystery is how they can list the full charges they are claiming on the 30/09/08 when they have applied a lot of charges since,

how did they know at that date what they would be claiming as the loan did not complete until 2014,

the total amount of charges they are claiming is £9,602.57 (according to the CCA Redemption report)

however the total charges they list are £6,021.17, again I have asked them to explain this and as yet they have not replied.

The redemption report states that these are the figures providing the redemption takes place on 16/3/2015,

and that if it doesn't fresh redemption figures must be applied for.

Once again I am totally confused with all this stuff.

If the spreadsheet is correct to whom to I send it?

I have also lodged a complaint with the FOS because they said they had advised me of this,

also they said I had not made any proposals to them,

I have written to them and said that I felt I had made my proposal clear and that was that I would as a gesture of goodwill

allow the £400 I had overpaid on the loan to be set against any charges they were claiming.

the spreadsheet is not calculation the compounded interest bar the first entry

[which is the wrong way to input PPI anyway and that must be on its own sheet

follow link I below]]

so you've deleted something in the formula cells

download a new copy

dx

Credit Reference Agencies:Experian Equifax CallCredit noddle

fed up with DCA's calling get a TRUECALL BOX!! - HERE

Start Your Own Thread - HERE

Hi

Thanks for that, I do not know however what proportion of the monthly payment was PPI as it is listed as a one off charge at the onset of the loan.

then you calculate it its easy

have you read this :

1. Single Premium PPI Q&A Read Here

if you scan up the agreement we'll help you.

HOW TO UPLOAD DOCUMENTS / IMAGES ON CAG IMMEDIATELY YOU DO NOT NEED 10 POSTS

.

IMPORTANT To protect your IDENTITY and ensure you remain ANONYMOUS on CAG

YOU MUST ensure that you REMOVE all Personal Information including Barcodes, Names, Addresses etc

.

ENSURE: To leave all Monetary Figures and Dates.

.

DO NOT USE A BIRO, PEN, SEE THRU TAPE OR LABELS TO EDIT THE INFORMATION

.

1. SCAN YOUR DOCUMENT

.

- Set your default scan page size to A4 less than 300 DPI (150 will do)

- Scan the required letters/agreements/sheets - as a picture (jpg) file

.

- Don't forget you can use a mobile phone or a digital camera too!!

.

- If you have multiple scans/pictures

please put these into WORD and make a multi page document

.

first ensuring you have removed all Personal Information before converting to PDF.

if you dont have MSOFFICE, use openoffice its free and has a PDF converter.

- IPHONE ONLY: Take a picture and Convert to PDF via an APP

.

2. HOW TO EDIT (Remove Personal Information)

.

- Do this using MSPAINT.EXE or any Photo Editing program and ensure to save the document.

PLEASE TRY AND REFRAIN FROM POSTING FILES OF +1Mb in size

a single sheet of a4 should be about 50kb.

.

.

3. HOW TO CONVERT YOUR DOCUMENT TO PDF

.

- If you have OFFICE installed this has an installable PRINT to PDF option so use this and save as PDF.

- If you have PDF as an installed driver use this program and save as PDF.

.

OR Go to one of the many free online pdf converter websites:

.

- http://freejpgtopdf.com/

- http://www.convert-jpg-to-pdf.net/

- http://www.freepdfconvert.com/

- http://www.pdfmerge.com/

- http://www.primopdf.com/

.

PLEASE REMEMBER: It would be better to upload a Multi-page PDF rather than multiple Single PDFs.

.

4. BEFORE UPLOADING YOUR DOCUMENT ON CAG

.

- Logically Name your PDF File so Users know what it is. DO NOT NAME YOUR FILE USING BANK NAMES OR CAG IN THE TITLE

.

- For Example: Default Notice DDicon-MM-YYYY.

.

IMPORTANT To protect your IDENTITY and ensure you remain ANONYMOUS on CAG please ensure that you do a final check that all Personal Information including Barcodes, Names, Addresses etc. are REMOVED before carrying out the NEXT STEP

.

5. HOW TO UPLOAD YOUR DOCUMENT ON CAG

.

- In your Thread/Post open a new msg box here.

- Click 'Go Advanced' below the msg box.

- Click 'Manage Attachments' below that box.

- Click the 'Add Files' button on the top right.

- Click 'Select Files', navigate to your file(s) on your PC.

- Click 'Upload Files'.

.

- You DON’T have to put a link to the attachment in the msg box just upload it ……… JOB DONE

- You can click on your links to check them too!!

.

I am hoping that the attached spreadsheets are now correct. I have removed the litigation charges however I do feel that in some instances they are inflated, due to the fact that they have only instigated court proceedings once during the loan yet they have made double charges within 8 weeks of each other!

One (of many!!) thing I am unable to understand however is how they could apply the charges they are claiming in 2008 when indeed they have made many records since then.

Hope you will have a look and put me right again if I have done it wrong, regarding putting the agreement on, the copy they have sent is a very poor one and unfortunately I cannot crop the personal details from it.

Thanks everyone for taking the trouble to help me.

Denyse

on the second PPI sheet

you don't list things like that as a 'bulk' figure.

each monthly PPI payment needs inputting

and each date of each letter

that way you'll calc the redress properly

dx

Hi dx,

I can't do this

there is only one charge specified for the PPI and one charge for 41 letters,

it is very difficult to see separate letters and btw there are far more that 41 on their sheets

in fact when I received the SAR I think there were about 300 letters!

but I don't think I ought to point that out to them as it would incur a huge sum on top of what they are claiming already.

Is there a cap on how many letters they are allowed to claim for?

the loan was for 7500 look at the total cost of the loan on the agreement

then do the calc in link 1 below

dx

Credit Reference Agencies:Experian Equifax CallCredit noddle

fed up with DCA's calling get a TRUECALL BOX!! - HERE

Start Your Own Thread - HERE

Ok I have spent most of the day trying to put these spreadsheets right, so here we go again:???:

Just to reiterate the PPI is listed as one payment at the beginning of the loan.

I had to resort to going through all the copies of the letters they sent me to get the dates.

There was no interest charged on the letters so I did not put any on.

There was however interest on all the other charges they put on.

In answer to your post above the CCA redemption report states the following:-

I have posted the revised spreadsheets, and also the CCA redemption report which outlines the initial loan, the interest charged etc.,

thanks for your patience,

you must think I am a little simple

but I can tell you I have a Masters Degree in Social Work and it was nothing compared to this one

thank you for your patience with me.

Oh and if you are wondering why there are four enquiry agents fees on the same date, that is how they have listed it and as these transactions attracted interest I just put them all at that date.

Given the charges I have outlined amount to £8125.12 and they are claiming £9602.47 the difference is £1477.35, should I therefore offer to pay this and hope they will accept?

the charges one is great but it stop interest halfway down?

why don't you attach the xls files then I can sort it.

the PPI one

you say the PPI was 1419 wheres that from>

on the redemption sheet

the total loan was 9287 , 168.51 PCM@96 mths = 16176.96

so calc the monthly PPI cost of the 168.51

The interest stops when it is covering the charges for the letters because they did not attract interest,

so I thought I had better not apply any interest.

When you say attach the xls file do you mean the completed spreadsheets?

I can only attach a pdf file so you would need a programme to convert,

but you could do that anyway with what I have already attached,

so what is the xls file if it is different.

And assuming I get this right (finally!!)

where do I send it, and what do you think about my post regarding offering them the difference?

thank you

£1419 is the difference between the original loan of £7500 and what they consider to be the loan £9297.00,

it also has other fees of £378 was for some sort of finding fee and enquiry

which I have not claimed back.

ok so do we know what you paid for PPI at the start of the loan?

on the letters that they charged no interest on at their rate.

take them off the CISHEET

and use a new copy of the statint sheet.

you are entitled to 8% statint on each letter charge.

dx

Really? even if they haven't charged anything other than the £30 charge for each?

I have attached part of the original agreement, sorry it is in a poor state that's how I received it from them. It's also cropped because it had personal information on it, but I think you can just about make out the figures on it.

I'll redo the letter charges on the stat sheet again tomorrow.

Thanks again

as they have deprived you [just like PPI] of the availability of the letter penalty fees

but not charged you any interest their end

you are still entitled to levy them at 8% statutory interest

as that's what you 'could' have gotten if you have invested the money they took from your in penalty chagres.

Looking at these charges I would accept about £550 of them (being the court action taken previously) because they will have had to outlay some money for that action. I have however paid £400 over the loan repayment so if I redo the letter charges again and then see where we are, where would I be sending these spreadsheets to when they are completed?

thank you

Wonderful that makes complete sense now you put it like that, I am as always very grateful to you for your sharing of knowledge!

right so ,,,,as said before

if you use the calc in this link

1. Single Premium PPI Q&A Read Here

PPI/total loan * 100 = XX%

1419/8919*100=15.91%

so

15.91% of anything you paid was for PPI.

so

you paid monthly - 168.51

so

15.91% of 168.51 = £26.81

so

you now enter the info in the PPI statint sheet properly

enter £25.81 on each date you paid the full PCM.

on any moth you paid more

or

less

or

settled

that PPI% needs to be calculated and entered.

dx

Following your good advice,

I have ended up doing more than one spreadsheet as you can now see,

I am hoping to quote pygmalion 'by jove she's got it', and I know I have been an absolute pain in getting here

Please could you let me know if this is actually the right way now.

By the way I've had a pretty crap day so far and actually found this strangely therapeutic