Spreadsheet with interest

[Guy]

Using the spreadsheet on credit cards.

I didnt have statements just a list of charges and the dates. Instead of calculating teh ineterst on the first page of the spread sheet i calculated the APR (eg one card charges 1.313% per month or 15.75% per year. To calculate the total interest charged for this particular card i just put 15.75 in the second page (replacing the 8%). I did some rough manual calcs an the figures work pretty close.

So in effect i have a total cahrges figure plus the interest they have charged on those charges.

So now i have claimed MBNA total charges plus the ineterst at their specific rates per card.

This is teh amount i will put in my Money claim when i file.

Does this sound reasonable / over simplified or completely wrong??

It added several hundred pounds to the total claim (one card was 22% APR)

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[Guy]

God my spellnig is bad!!

Well its the wireless keyboard with dodgy batteries and what looks like tomato sauce inbetween teh keys.

Must ket the kids thier own puter!!

[Lizbrind]

Originally Posted by thewifeandI

I think I know what's going on now...
...

That sorts it. Thanks!

This spreadsheet is even smarter than I thought

[Jane Austen]

Guy,
are you saying that if I replace the formula on the 8% part of the spreadsheet then I can calculate more accurately credit card interest?

Does this affect the calculation for interest on the first page?

I have just filled everything in but I notice my APR is 19.9%.

Any help appreciated.

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[jolajo]

Hi, I hope you can help?
Firstly can I say, please dont get the impression by my questions that i am lazy! i have been struggling for 2 months with the process.....blame it on the depression!! I seem to of hit hurdle after hurdle!!

The problem i have or problems, should i say are....?

I have never looked at/seen a s/sheet before let alone used one?
I have been library but the 2 books completly baffle me?

I cannot find your s/sheet with the notes on??

When I attempted to download from exel it read....file cant open due to lack of disk space???? Defraged still wont? Another member has been trying to help as i pasted figures to her to apply on sheet....she got same message.? Her advice was to contact you, which i have sent a pm explaining my history.

I have had a number of late pay charges from my utility company's over a £100 can these be claimed for as the bank had refused to pay them?
My Inc Support/Incap Ben/Child Benefit was completely took for their charges 3 weeks in a row and quite a few weeks where they took a large portion of my benefits? Can the absolutely genuine distress caused by their illegal actions be compensated for?
Sorry changed topic oops!
Any help offered I will be eternally grateful, thanks to' KATIESAGIE' for trying x

[gizmo111]

Hi,

Is the spreadsheet supposed to print in red - or have I got a printer problem?

Thanks

[bram stoker]

Hi all,

Just a quick catch up on spreadsheets. I haven't been able to be around much. I notice now that some of you are are fully competent on the ins and outs of the spreadsheets provided here, and able to advise each other.

This forum is designed for us all to help each other. As I am not now as available as I have been, it's nice to see you all helping each other, and hope you continue to do so.

I'm just completely gutted the world hasn't fallen down whilst I've not been around. Lol.

Keep it up folks. We're all here to help each other. Thanks.

[jolajo]

What would happen if you admitted your claim and unknowingly had worked out interest at the wrong amount?
Im in a pickle and not very confident in what i am doing although been trying for 2 months!!
Could i enter my total figures for someone to check?? please

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[bram stoker]

Originally Posted by jolajo

What would happen if you admitted your claim and unknowingly had worked out interest at the wrong amount?
Im in a pickle and not very confident in what i am doing although been trying for 2 months!!
Could i enter my total figures for someone to check?? please

If you want to send me your spreadsheet at vampiress.bag@gmail.co.uk I'll take a look.

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[thewifeandI]

Originally Posted by Vampiress

Hi all,

Just a quick catch up on spreadsheets. I haven't been able to be around much. I notice now that some of you are are fully competent on the ins and outs of the spreadsheets provided here, and able to advise each other.

This forum is designed for us all to help each other. As I am not now as available as I have been, it's nice to see you all helping each other, and hope you continue to do so.

I'm just completely gutted the world hasn't fallen down whilst I've not been around. Lol.

Keep it up folks. We're all here to help each other. Thanks.

No probs, it's been enjoyable to pass on my experience and help others out! Thanks for the Rep!

The only area I've stayed away from is the subject of interest charges on CCs, although I'm about to claim on the first of many soon, so I'd welcome your input.

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[thewifeandI]

Originally Posted by gizmo111

Hi,

Is the spreadsheet supposed to print in red - or have I got a printer problem?

Thanks

I wouldn't expect it to - sounds like you are out of ink of one or more colours or got a clogged printhead in your printer. Check your ink levels and if they are OK, run it through a cleaning cycle (see your manual for instructions).

[gizmo111]

Originally Posted by thewifeandI

I wouldn't expect it to - sounds like you are out of ink of one or more colours or got a clogged printhead in your printer. Check your ink levels and if they are OK, run it through a cleaning cycle (see your manual for instructions).

Thanks - it was something to do with the ink - took my 11 year old daughter to fix it for me!

[dave&sueb]

Hi,
I am not sure if I am using this forum correctly so please forgive me if this thread isn't where it should be.
Anyway, it would seem logical to me that to bank customers that have interest free o/draft or no overdraft facility. the whole of any charges including interest on o/drafts can be claimed back in full. The premise I am using is this.
Ignoring the issue of charges for a moment.......The bank has total control over what it pays out of your account...ok.
Therefore, if they exercised their right to refuse a payment on the basis that this would be unauthorised borrowing then customers would never go overdrawn or over limit to begin with !!!
It follows therefore, that when debits are allowed that result in a customer going into unauthorised borrowing.......this is a conscious decision by the bank.!!
are you with me so far?
Right ......now then.....it can be easily seen that the decision to allow a debit to be paid that will knowingly send your account into unauthorised borrowing is a calculated measure designed to attract the automatic penalty charge.!!!! get the drift ??

This would seem to be a form of 'constructive default' analogous to 'constructive dismissal' where the bank is deliberately allowing you to breach their conditions in the knowledge that they will profit from it!!! and I am wondering if there might be a legal precedent.
Would appreciate anyones thoughts as it could be useful in court!

	What are your rights at work Follow this link to read the review of the Guide to your Rights at work, published by Lawpack

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[ROB_5]

Hi,

2 days to go until i send LBA. I dont mind admitting i'm really struggling with the spreadsheet.

Problem 1) How do i know what the interest rate was charged to put in the column "interest charged" on the spreadsheet. On my statements it just says the amout of £ debited and the balance.

At the end of each month on my statements it says "Interest debited £2.11" etc etc.

Should i just total these up and use this as the interest charged??

Could it be that easy??

Hope someone can help.

Rob

	Small Claims kit by Lawpack Sue your bank as many times as you like with just one Small Claims kit by Lawpack. Follow this link to read the review. The kit contains everything you need: instruction manual, templates, examples, forms and a comprehensive CDRom. Applies to England and Wales

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[thewifeandI]

Originally Posted by ROB_5

Hi,

2 days to go until i send LBA. I dont mind admitting i'm really struggling with the spreadsheet.

Problem 1) How do i know what the interest rate was charged to put in the column "interest charged" on the spreadsheet. On my statements it just says the amout of £ debited and the balance.

At the end of each month on my statements it says "Interest debited £2.11" etc etc.

Should i just total these up and use this as the interest charged??

Could it be that easy??

Hope someone can help.

Rob

Hi Rob,
Enter the amount of interest charged into the righthand side of the enhanced spreadsheet. In the blue columns, enter the date the interest was charged, the amount debited and the lowest balance for the month that the interest refers to (either the same month or the one prior to it). The spreadsheet will work out how much was due to the accumulated charges on that date and the amount will show in the yellow column. This is all assuming that you have entered all the charge information into the lefthand side of the sheet (ALL entries are made on the Interest and Charges sheet). Don't forget to enter all this information in date order, oldest first with no gaps.

	Small Claims kit by Lawpack Sue your bank as many times as you like with just one Small Claims kit by Lawpack. Follow this link to read the review. The kit contains everything you need: instruction manual, templates, examples, forms and a comprehensive CDRom. Applies to England and Wales

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[ROB_5]

Thanks for reply Jeep.

Ok, i get what to put in all the columns except the "Interest Charged" column.

so, this is what i have at the moment :



DATE PENALTY APPLIED DETAIL PENALTY CHARGED

13/01/2005 Charge as Notified £30


INTEREST DATE INTEREST CHARGED ACCOUNT BALANCE INTEREST ON PENALTIES

31/01/2005 -£235.11


I'm probably missing something obvious here !! Once i put a figure in the interset charged column then it works out the interest on penalties, but what do i put in the interest charged column.??

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[thewifeandI]

Originally Posted by ROB_5

I'm probably missing something obvious here !! Once i put a figure in the interset charged column then it works out the interest on penalties, but what do i put in the interest charged column.??

In this column you put the full amount of interest debited from your account. EDIT: See post #57 above for an example. The calculation looks at the total amount of charges up to that date, compares it with the overdrawn balance that you had in the month that the interest applies to and works out the proportion of the interest that was due to charges. You will notice that as you get more and more entries filled the proportion goes up to 100% as the entire overdrawn becomes due to charges. Please make sure that you don't try and align the interest with the charges - leave no gaps in either the charges or the interest columns for the sheet to work correctly.

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[ROB_5]

ok, now ive got headache!!
so going by post #57 as example, should i be inserting the total interest debited from each month on my statement into spreadsheet ??

If this is right then there will only be one lot of interest deducted for each month?

startng to make sense. ( i think)

Just thought of something else :

What do i put if i have 3 or 4 charges a month ?



Rob

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[thewifeandI]

Originally Posted by ROB_5

ok, now ive got headache!!

so going by post #57 as example, should i be inserting the total interest debited from each month on my statement into spreadsheet ??
Yes - that's right

If this is right then there will only be one lot of interest deducted for each month?
Yes - that's right

startng to make sense. ( i think)

Just thought of something else :

What do i put if i have 3 or 4 charges a month ?
Rob

You only enter one amount for interest each month - it doesn't have to align with the charges on the left side, just start from the top and put in the interest charged in date order. It doesn't matter how many charges there were in the month, the interest is based on your balance, not specific transactions.

	Are you letting your bank keep your money Are you giving away thousands of pounds?? Many people aren't claiming all of the money they are entitled to when they make their bank charges claims. You have been forced to pay unfair bank charges. Have you forgotten that your bank has charged you inteest on those charges? If you are overdrawn and the bank owes you charges - then your overdraft is made up of charges - money which you bank owes you. Yet you are paying interest to the bank - on your own money!!! Follow this link to see the discussions on this. You might even double th size of your claim.

[ROB_5]

Cool, only taken 4 days so far !!!!

So just to confirm i'm doing it right ---







Many Thanks

Rob