Please help for an old lady

[gizmo111]

There is only 1 account, the rest were savings accounts with hardly any activity and no charges.

How do I put this list up here?

 

PM'd you

[Destinyofsouls]

Thanks bill- I'll give it a go now with Dotty's statements. I assume the interest is going to be a lot higher. Dotty may be able to go to Mauritius then instead of margate

[Destinyofsouls]

wow Bill,

That really makes a difference!!!!

Interest is now £711,000

( Thinks maybe I've dun summat rong :o )

[sarahpp]

wow Bill,

That really makes a difference!!!!

Interest is now £711,000

( Thinks maybe I've dun summat rong :o )

 

Hmm - yes, I think that we can safely say that £711k would appear to be a bit on the wrong side

 

Bill is the expert on spreadsheets but, have you checked whether the dates are right because this can give a hugely inflated figure if not.

[Destinyofsouls]

sarah,

Now copied and pasted the info into the compound sheet. Arrived @ £6,900 interest. Seems a little high?

Did you get the s/sheet that I e mailed?

[Destinyofsouls]

This is over my head. Don't understand the s/sheet.

[sarahpp]

sarah,

Now copied and pasted the info into the compound sheet. Arrived @ £6,900 interest. Seems a little high?

Did you get the s/sheet that I e mailed?

 

That sounds more like it. No, I didn't get the s/sheet but, I am sure that Bill will be along to mop your fevered brow if you are still worried. Over a five year period at around 29% though, that sounds about right.

[Destinyofsouls]

4/3/02 cHARGE £150 Interest = £500.80 ???? Is that right?

 

I sent the s/sheet to your e mail address in your PM

I'll send it again

[sarahpp]

4/3/02 cHARGE £150 Interest = £500.80 ???? Is that right?

 

I sent the s/sheet to your e mail address in your PM

I'll send it again

 

Sounds about right - shocking isn't it? Remember, you are only doing what the banks do i.e. charging interest on interest

[bill-k]

Hi guys - sorry, bit busy. Yes, that looks about right, now, destiny. I'll PM you re the spready.

[chezt]

 

If the answer to No 2 is the account balance on that date the interest has been debited, then do I put in a - sign if in o/d ?

 

 

No it's not, and no you don't !!

 

Hi guys ... sorry to confuse matters BUT If ur using the Vamps spreadies then surely the answer to the above should be YES put a minus sign in front of the amount if the balance is overdrawn?? If you don't the sheet takes it as a credit balance & deducts interest instead of adding it

 

Am I confused here or what? :?

[bill-k]

Hi guys ... sorry to confuse matters BUT If ur using the Vamps spreadies then surely the answer to the above should be YES put a minus sign in front of the amount if the balance is overdrawn?? If you don't the sheet takes it as a credit balance & deducts interest instead of adding it

 

Am I confused here or what? :?

Sorry, guys, one of the upgrades that Vamp put in was to make it unnecessary to put negative values in here. If it's an earlier sheet, then you are indeed right, Chez, and it should be negative (in brackets). If it's the current sheet, then it doesn't have to be - it can be either + or - ve.

 

Sorry for confusion !!

[chezt]

Sorry, guys, one of the upgrades that Vamp put in was to make it unnecessary to put negative values in here. If it's an earlier sheet, then you are indeed right, Chez, and it should be negative (in brackets). If it's the current sheet, then it doesn't have to be - it can be either + or - ve.

 

Sorry for confusion !!

 

Bill I'm still confused! So you mean with the new sheet you just enter the amount & it doesn't matter if it's an overdrawn or in credit balance?

[bill-k]

If I've got this right, Chez, what goes in that column is the average overdrawn balance for the month. If it is an average credit, then I don't think there should be anything in that column cell for that month (or just 0). TBH, I've never claimed the interest on that side of the sheet, so I'm unfamiliar with using it.

If in doubt, though, continue putting a negative figure there, as that should work with old or new sheets.

[chezt]

If I've got this right, Chez, what goes in that column is the average overdrawn balance for the month. If it is an average credit, then I don't think there should be anything in that column cell for that month (or just 0). TBH, I've never claimed the interest on that side of the sheet, so I'm unfamiliar with using it.

If in doubt, though, continue putting a negative figure there, as that should work with old or new sheets.

 

ahhh ... OK gotcha! TBH I could never be a) bothered or b) work it out (!) so I always just entered the balace on the last interest calculating day .. doesn't make much difference overall & saved me loadsa time faffing about tryna work out averages IYKWIM!

 

Cheers matie!

[bill-k]

Batty Bill would have to say, "OH, no - you MUSTN'T do that !!"

 

Bill-k says, "Yeah, sod it, mate - that'll do !"

 

[chezt]

Batty Bill would have to say, "OH, no - you MUSTN'T do that !!"

 

Bill-k says, "Yeah, sod it, mate - that'll do !"

 

I know what you mean but if it's wrong then let the bl**dy bank work it out - that's what I say!

[bill-k]

I know what you mean but if it's wrong then let the bl**dy bank work it out - that's what I say!

Yeah, and I think Vamp agrees with you, too Chez. As long as we have made a reasonable effort, we cannot be expected to get it exactly right. If the bank wants to correct us, then we let them !! That's being reasonable, innit ?

[Destinyofsouls]

Bill,

Just sent you the spready. Let me know ( in laymans terms)if it's OK

Dont know how to claculate what to put in this column:

 

Estimated average overdrawn balance during period of interest

 

Destiny

[chezt]

Bill,

Just sent you the spready. Let me know ( in laymans terms)if it's OK

Dont know how to claculate what to put in this column:

 

Estimated average overdrawn balance during period of interest

 

Destiny

 

Destiny ... this is wot me n Bill were just discussing over the last few posts ... av a read n see if it helps make things a little clearer

[Destinyofsouls]

Hi Chez

 

Unfortunately not. Am I right in thinking you both don't claim for compound interest? because you would have to put a figure in there wouldn't you?

[chezt]

Yes you do have to put a figure in as it needs to be complete to do the calculations on the spready ... I'm claiming compound contractual interest on my claims

[Trish76]

Hi,

what a sad story!!I this were someone I knew,I would go around to her house,ring the DCA (Debt Collection Agency)Get her to talk to them saying that she is giving you Authority to speak to them on her behalf,and let them know the plan of action and what her situation is.

Once she has received the statements,send them The LBA asap.I would then ring the DCA again and advise them that the acc is now in dispute!!!

This is off course purely my opinion and what I would do.

I do hope everything works out ok for her and think it is great of you to help her out!!!

All the best and many kind regards

Trish

[chezt]

Trish it's best to keep all correspondence in writing as you have no record of proof with telephone convs ...as tempting as it is !

 

Yes it is a sad story but with a happy ending on the way for the luvly lady I'm sure

[Destinyofsouls]

Ok Chez,

How do I calculate what figure I put in here?

If there are 8 charges in any one month, what figure do I put against eahc charge in this column?