Vampiress,
As your the spreadsheet wizard among us can I please ask you to create another one for credit cards? Your spreadsheet is ideal for Bank accounts where the interest and charges are paid off monthly.
If a charge is applied to a credit cardit it attracts interest at the companies monthly rate of interest, However, owing to the way they actually apply payments to the account that charge is one of the last to get paid. So unless the account is paid IN FULL every month it continues to accumulate compounded interest.
A spread sheet which allows entry of charges , dates, and the card companies monthly interest rate would be useful for calculating this compounded interest.
I have actually had this confirmed by Mr Gareth Tunnicliffe (legal advocate) at MBNA. He admitted that several charges applied during 2000 could actually have compounded sufficiently over the last 6 years for the interest to be worth more than the accumulated charges.
I am about to make a claim to MBNA for £950 of charges applied over 6 years and compounded interest add £1090 in interest, should be interesting to see what happens.