Spreadsheet with interest

[bram stoker]

Sorry if this has already been answered, but can I include the £10 charge from requesting my statements in this spreadsheet, and if so then how?

 

thanks

That would be part of your costs, not your claim.

[bananaboy]

OK makes sense, thanks

[wehavetheright]

Just a quick one, are the spreadsheets you provide on Google under Vampyress Chambers - the same as the ones you provide in the CAG Library eg. Complex bank charges England etc??

 

It's just that I note there has been talk about claiming for contractural interest and the one I filled in on from the CAG library (Complex bank charges England) just asks for the interest date, interest charges, and account balance at interest date. Should I be using the Google spreadsheets instead, or is the Library fully updated?

 

I just need to know if I need to refill this all out again!

 

Thanks to Vampiress for her fabulous sheets!

[wehavetheright]

Hi Vampiress,

you are a legend! I have a query on the spreadsheet I have been using in the Library (England Complex Bank charges Excel). I filled in everything as you said in your notes and in the sheet itself. It seems to automatically calculate the portion of interest charged on the penalty, given the account balance, date interest charged, date penalty charged etc. Is this right?!!

 

Another point - I see the talk about contractural interest - of course it's perfectly fair and logical to claim back the rate of interest at which you were charged. But what if you were charged different rates of interest at different times. Eg. the Natwest authorised borrowing rate for 2006 (so far) is 29.6% annually (2.19%/month) and the authorised borrowing rate for 2006 is something like 16.9%. The rates of course have gone up over the 6 years, so are differing rates.

 

Can I assume that by filling in the Excel spreadsheet in the library taking into account I've inputted the correct information - penalty charged, date charged, interest charged, date interest charged, account balance at interest date - that this automatically calculates the correct interest?

 

Does that make sense?

Thanks, just want to make sure that I am claiming for as near to the amount

I have actually been charged as possible.

i.e. over the last 6 years Natwest has charged me £3,172.00 in penalties and the spreadsheet has calculated that the interest charged on penalties is £987.74.

 

The actual full amount of the interest I was charged by Natwest over the 6 years was £1,578.56. So £590.82 was paid in 'legitimate' interest and £987.74 was paid in unlawful interest.

 

Does this sound right to everyone, as I am about to send my Prelim letter.

 

Thanks all.

[bram stoker]

Just a quick one, are the spreadsheets you provide on Google under Vampyress Chambers - the same as the ones you provide in the CAG Library eg. Complex bank charges England etc??

Yes, they are basically the same, although there are some updates, such as displaying the daily rate etc. You also have a choice to use a spreadsheet for other scenarios that you may prefer, such as compounding the interest. There are also more spreadsheets available for people who are claiming in Scotland.

[bram stoker]

Hi Vampiress,

you are a legend!

Thanks.

I have a query on the spreadsheet I have been using in the Library (England Complex Bank charges Excel). I filled in everything as you said in your notes and in the sheet itself. It seems to automatically calculate the portion of interest charged on the penalty, given the account balance, date interest charged, date penalty charged etc. Is this right?!!

It is a good estimate. Others have gone on to calculate this more accurately. I wanted to keep these as simple as possible, and if the bank wish to recalculate, it's up to you and your bank to negotiate this figure. Remember to be reasonable. Remember also that the banks in court must defend their costs before defending any interest on them.

Another point - I see the talk about contractural interest - of course it's perfectly fair and logical to claim back the rate of interest at which you were charged. But what if you were charged different rates of interest at different times. Eg. the NatWest authorised borrowing rate for 2006 (so far) is 29.6% annually (2.19%/month) and the authorised borrowing rate for 2006 is something like 16.9%. The rates of course have gone up over the 6 years, so are differing rates.

Again, an estimate. Feel free to produce something more accurate and research your historic rates from your own bank account. Remember that you may have switched from one type of account to another within that time period, each type of account carrying different rates. Again, I wanted to keep it simple.

Can I assume that by filling in the Excel spreadsheet in the library taking into account I've inputted the correct information - penalty charged, date charged, interest charged, date interest charged, account balance at interest date - that this automatically calculates the correct interest?

I qualified at maths to A' level standard, and have studied and worked as an accountant for the last 15 years. The theory and the maths have been checked by others. I'm confident the spreadsheets are correct, but am always open to criticism. Keeping a balance between simplicity for everyone, and accuracy, is a judgement call. Others may wish to calculate their interest differently.

Does that make sense?

Absolutely. It's good to have chance to explain these things and to be called to answer occasionally. I know the spreadsheets have helped many, and hope they continue to do so.

Thanks, just want to make sure that I am claiming for as near to the amount I have actually been charged as possible.

It states in the small claim pack to over-estimate your claim if you are not sure. The judge and defendant can barter you down, but you will find it difficult to increase your claim if you've under-estimated.

i.e. over the last 6 years Natwest has charged me £3,172.00 in penalties and the spreadsheet has calculated that the interest charged on penalties is £987.74.

 

The actual full amount of the interest I was charged by Natwest over the 6 years was £1,578.56. So £590.82 was paid in 'legitimate' interest and £987.74 was paid in unlawful interest.

 

Does this sound right to everyone, as I am about to send my Prelim letter.

That sounds fine, although maybe a little low if you've had a lot of charges. Without seeing the whole picture, you can't really judge the accuracy of the figures given in questions such as these. You appear to have grasped the concepts well, and am sure you will do fine.

 

Good luck.

[mnrbig]

Is it possible to alter the spreadsheets to allow for the entry of charges older than six years with the date they actually occured instead of a bulk amount?

[wehavetheright]

Thanks Vampiress. So in other words - the one I have been using in the library, will correctly calculate the amount of interest I have paid on the penalty charges (as long as I input the correct amounts of course). So £987.74 interest sounds right for £3,172.00 worth of penalties? I am about to send it out so I don't want to make any obvious errors!

 

Thanks.

[bram stoker]

Is it possible to alter the spreadsheets to allow for the entry of charges older than six years with the date they actually occured instead of a bulk amount?

The spreadsheet doesn't need any alteration.

[mnrbig]

The spreadsheet doesn't need any alteration.

 

Am I missing something? I have had a look at the advanced Bank charges sheet and when I enter an pre 2001 date I get "#N/A did not find value 01/01/2001" in the interest column.

[bram stoker]

Am I missing something? I have had a look at the advanced Bank charges sheet and when I enter an pre 2001 date I get "#N/A did not find value 01/01/2001" in the interest column.

If you are using the Google spreadsheets you need to enter dates in American format as stated in the Chambers. Some formulae will also not work until you have completed a few entries.

 

Let me know if this doesn't work please.

[wehavetheright]

Thanks Vampiress for your detailed replies. It all looks good from what you say - just wanted to check!

[welshcarp]

i have just filed out the spreadsheet ready for court the tota charges came out at £2303.50 when this was entered on the p column the 8% interest was all over the shop they ranged from 10.88 to over £200 the total with the interest was over £9000 this is surelly incorect :confused:

[bram stoker]

i have just filed out the spreadsheet ready for court the tota charges came out at £2303.50 when this was entered on the p column the 8% interest was all over the shop they ranged from 10.88 to over £200 the total with the interest was over £9000 this is surelly incorect :confused:

Which spreadsheet please?

[welshcarp]

vampiress the spreadsheet i have used is the complex bank charges i believe it is from this web site

[bram stoker]

vampiress the spreadsheet i have used is the complex bank charges i believe it is from this web site

Is this Excel, Works or Google?

[welshcarp]

vampiress have they altered the spreadsheet lately as the spreadsheet i have used is different to ones on here i have the one with a the writing on the left and you side shift the screen and put all you bank account details at top and then fil out the charges below this hope this is not getting to u

[bram stoker]

vampiress have they altered the spreadsheet lately as the spreadsheet i have used is different to ones on here i have the one with a the writing on the left and you side shift the screen and put all you bank account details at top and then fil out the charges below this hope this is not getting to u

Getting to me? C'mon I love a challenge. Lol.

 

The spreadsheets have been updated yes. I'm sending you a PM.

[welshcarp]

its nice to see dedication to a good cause not alot of it about these days

[andrew1]

its nice to see dedication to a good cause not alot of it about these days

 

 

Someone said she's a legend - She is xx

[bram stoker]

You lot give me so much more than my measly £45 from the bank. You're all stars. I hope to meet you all at the Protest. I'll be the Vampiress. ;-)

[rubberlips64]

Hi

am new to threads - have been sat here ages:roll: HRS!

 

i need help with the English simple version spread shet - its the days colum i'm struggling with - do i get all my calenders out since 2000 to calculate the time since the charge was made e.g 31/03/2003 is 1289 days?? or is there an easier way:confused: Would appreciate your advice. Thank you thank you thank you:)

[bram stoker]

Hi

am new to threads - have been sat here ages:roll: HRS!

 

i need help with the English simple version spread shet - its the days colum i'm struggling with - do i get all my calenders out since 2000 to calculate the time since the charge was made e.g 31/03/2003 is 1289 days?? or is there an easier way:confused: Would appreciate your advice. Thank you thank you thank you:)

There was a formula in the days cell which calculated it automatically. If you have deleted it, you need to get it back in by copying it from a new template.

[suealig]

Hello

 

I have just joined the action group. Can anyone help me with a copy of the draft letters that I need to send to Lloyds TSB. I have been screwed by the bank for far too long. In the past 6 months, they have charged me +£350.00 in bank charges. My brother told me about this from listening to the radio, hence this is my first attempt.

[bobtheb]

HE GUIDE TO CLAIMING BACK YOUR CHARGES (complete with links)

Read this first it will help you no end

http://www.consumeractiongroup.co.uk/forum/hsbc-bank/20211-newcomer-then-please-feel.html