The following four spreadsheets are the latest releases. All have a file name ending in v101.

(Apart from the one that is v102 )

The spreadsheets work in Excel 2007 format, Excel 2010 and should also work in OpenOffice as well.

This first spreadsheet is the latest version of the statutory interest calculator and is used for Single Premium PPI cases. It can also be used where rollover PPI is involved, i.e. a new loan re-financing a previous one and where PPI is included in one or more loans. It can also be used for S69 redress calculation on any sum, like on a closed/frozen interest PENALTY charges claim.

do not enter anything in the claim to date box..stat int runs until they settle a claim.....

StatIntSheet v101.xls

This second spreadsheet is a compound interest calculator and can be used both for PPI claims and Charges Reclaims on Revolving Credit Accounts such as credit cards. Compound interest is not an award that fos will give in respect of PPI claims but it can be used in PPI cases that are pursued through the courts. It is the standard sheet that is also used for charges reclaims both on credit cards and loan accounts where interest in restitution is claimed.

CISheet v101.xls

This third spreadsheet is a calculator that will work out a fos based PPI award on a Revolving Credit Account such as a credit card. It will also work out the additional 8% interest awarded where the account moves into credit as a result of the removal of the PPI from the account. Be aware that you will need ALL of the account statements for this spreadsheet to give the correct result.

FosRunningPPI v102.xls

This fourth spreadsheet is useful in calculating a regulatory based compound interest award for PPI on a Revolving Credit Account. Or for a PENALTY charges Reclaim. Not all statements are required for this sheet because it will work out the compound interest on the PPI payments you do know about. It will not work out the additional 8% interest, to do that you will need spreadsheet three above AND all of your statements.

FosCISheet v101.xls

...............................

if yo have not got a copy of Microsoft Office that includes Excel..

then:

Grab yourself a copy of OpenOffice from here

http://www.openoffice.org/

It is free and is a fully functional office suite.

The spreadsheets will work in OpenOffice

Latest Spreadsheets - PPI Claims and Charges Claims.pdf

Before Printing the PDF TIP

If you DO NOT wish to print Page 1 (Cover Page) of the PDF, please ensure to do the following:

Ensure you go to your Printer Settings and set it to 'Print from Page 2' (this way Page 1 (Cover Page) should not print out).

Note: This will save you Ink & Paper

this sticky is closed for posting

if you have a question

please start a new thread

or see the video below

dx