Spreadsheet with interest - Page 77

wednesday1867 · 16th August 2007, 16:27

Phatram, this is what i did,

Open up the spreadsheet kind you need, compound, contractual or 8%, preferbly one you dont use anymore.

When the spreadsheet opens, click on "Revisions" go back to the earliest date you can.(Hopefully this will be a time before a formula was deleted, so should give you a working spreadsheet)

Copy it and rename it, i renamed mine Blank Such and Such. You can find the copy button, by clicking on file.

Then you have a blank template to copy from all the time, everytime you need another spreadsheet, just do another copy of the blank one.

Hope this helps

hsbcfiddled · 19th September 2007, 20:28

Any suggestions as to how i calculate the APR and is it possible to pay 4 weekly not monthly?

sund1ata · 25th September 2007, 14:24

Errm... I'm attempting to calculate compound interest on a credit card, but none of Vampiress' sheets are up - they are 404'd. I have spent a lot of time on the forum looking for alternatives, or alternate locations but cannot find any. Can anyone help me out? Cheers.

nyc_lond10 · 11th February 2008, 15:32

Anyone know whats going on: I have a problem with the advanced spreadsheet - everymonth I add on th enew interest and let the spreadsheet make the new calcualtion by draggin down the cells, however for some reason a new calcualtion cant be made...i cant see the formula either...any idea whats goign on...? should i just download a new spreadsheet....?

phatram · 22nd February 2008, 16:00

Quote:

Originally Posted by sund1ata

Errm... I'm attempting to calculate compound interest on a credit card, but none of Vampiress' sheets are up - they are 404'd. I have spent a lot of time on the forum looking for alternatives, or alternate locations but cannot find any. Can anyone help me out? Cheers.

bump

checkoutdolly · 9th April 2008, 14:23

same problem as you when it comes to opening them

phatram · 9th April 2008, 14:51

Perhaps you could PM a MOD?

checkoutdolly · 9th April 2008, 15:10

have just done so good idea of yours will see if it does any good am stumped without a spreadsheet

alanfromderby · 9th April 2008, 16:36

Unfortunately we have no control whatsoever over the spreadsheets posted by VAMPIRESS. However, CAG spreadsheets are available and linked from page one of this thread - or via the Bank Template Library.

andrew1 · 9th April 2008, 17:07

They look suspiciously like Vamps spreadsheets to me

mackerel · 20th April 2008, 22:01

Hello

I'm trying to figure out how to use the advanced spreadsheet to get my charges back from barclaycard with penalty charge interest.

There are a couple of things i need someone to point out for me:

1) Column I, the 'Amount Paid' - i get that from the next months statement, yes? And if i paid nothing, i assume i enter a zero?

2) In the sample data in the spreadsheet, under column G 'Interest Charged' it has a flate rate of 12.50 for every row. I'm trying to figure out what interest i enter for this cell from my statements, as it mentions interest in a few places:
* purchase interest
* "interest on your standard balance"
* "interest on your cash balance"
* "next months estimated interest"
I think i need to enter the purchase interest in column G. But is it normal for this to change - from 2002 to 2004 it's 1.385, then from 2004 onwards it's 1.456 and in the most recent statements 1.527. I assume i update the cell whenever this interest increases? Or do i enter the £ amount of interest charged?

Thanks a lot in advance

nyc_lond10 · 26th April 2008, 19:12

Hi - Not sure if anyone can help but here it goes - I downloaded the spreadsheets (advanced) and for the most everything works - however I have noticed that as I am dragging down the formula, the further time elapses, that for whatever reason, the formula wasnt calculating anymore - i know it doesnt make much sense, but i was wondering if anyone knew, or had similar problems....? Secondly, i realize the calcualtions are meant to figure out what portion of the overdraft is interest, what happens when interest rate charges go up....is this reflected in the calculations?

Can anyone help?

mackerel · 27th April 2008, 17:14

Hello

I'm still hoping someone can help with some answers to my post 2 up - waiting to fill out the complex spreadsheet but still don't understand what interest to use - some posts say to enter 27.9%, but i don't see that on my statements anywhere. And i'm still not sure whether to enter a percentage value, or the £ value. If it's the £ value - do i need to enter them both (i get charged interest in my statements twice: interest on standard balance @ 1.385%, and interest on cash balance at 1.462%)?

Please help!

mackerel · 27th April 2008, 17:37

Also, if i have a statement for a month with no charges on it, do i enter that statement in the spreadsheet - just the date of the statement and the statement balance?

TideTurner · 15th June 2008, 01:31

Mackerel,

Telephone the bank and ask for the interest rate which is currently being applied to the account. Use this in the spreadsheet.

sheriehartill · 24th June 2008, 14:51

ooops I sorry for this .. Wrong post wrong place

CAG Products - We think that these will help you to make your claim or Reclaim your Right These sales also help us to keep helping YOU and keeps this site free of third party adverts!

Small Claims Kit	Small Claims Court Guide	CallBurner - Skype CallRecorder Review	Last Will & Testament Kit	Fight a Motoring Ticket

Alternatively you could purchase a CAG email address here, or maybe you'd prefer our address labels here
UPDATE: Consumer Forums ConsumerWiki is now LIVE - click here: ConsumerWiki N.B. Please note - due to postage costs these products are only available in the U.K.