Jump to content


  • Tweets

  • Posts

    • The firm has benefited from the AI boom, making it the third-most valuable company in the US.View the full article
    • Former billionaire Hui Ka Yan has been fined and banned from the financial market for life.View the full article
    • In terms of "why didn't I make a claim" - well, that has to be understood in the context of the long-standing legal battle and all its permuations with the shark. In essence there was a repo and probable fire sale of the leasehold property - which would have led to me initiating the complaint/ claim v SPF in summer 19. But there was no quick sale. And battle commenced and it ain't done yet 5y later. A potential sale morphed into trying to do a debt deal and then into a full blown battle heading to trial - based on the shark deliberately racking up costs just so the ceo can keep the property for himself.  Along the way they have launched claims in 4 different counties -v- me - trying to get a backdoor B. (Haven't yet succeeded) Simultaneously I got dragged into a contentious forfeiture claim and then into a lease extension debacle - both of which lasted 3y. (I have an association with the freeholders and handled all that legal stuff too) I had some (friend paid for) legal support to begin with.  But mostly I have handled every thing alone.  The sheer weight of all the different cases has been pretty overwhelming. And tedious.  I'm battling an aggressive financial shark that has investors giving them 00s of millions. They've employed teams of expensive lawyers and barristers. And also got juniors doing the boring menial tasks. And, of course, in text book style they've delayed issues on purpose and then sent 000's of docs to read at the 11th hour. Which I not only boringly did read,  but also simultaneously filed for ease of reference later - which has come in very handy in speeding up collating legal bundles and being able to find evidence quickly.  It's also how I found out the damning stuff I could use -v- them.  Bottom line - I haven't really had a moment to breath for 5y. I've had to write a statement recently. And asked a clinic for advice. One of the volunteers asked how I got into this situation.  Which prompted me to say it all started when I got bad advice from a broker. Which kick-started me in to thinking I really should look into making some kind of formal complaint -v- the broker.  Which is where I am now.  Extenuating circumstances as to why I'm complaining so late.  But hopefully still in time ??  
    • At a key lecture in the City of London, the shadow chancellor will also vow to reform the Treasury.View the full article
    • Despite controversy China's Temu is becoming a global online shopping force.View the full article
  • Recommended Topics

  • Our picks

    • If you are buying a used car – you need to read this survival guide.
      • 1 reply
    • Hello,

      On 15/1/24 booked appointment with Big Motoring World (BMW) to view a mini on 17/1/24 at 8pm at their Enfield dealership.  

      Car was dirty and test drive was two circuits of roundabout on entry to the showroom.  Was p/x my car and rushed by sales exec and a manager into buying the mini and a 3yr warranty that night, sale all wrapped up by 10pm.  They strongly advised me taking warranty out on car that age (2017) and confirmed it was honoured at over 500 UK registered garages.

      The next day, 18/1/24 noticed amber engine warning light on dashboard , immediately phoned BMW aftercare team to ask for it to be investigated asap at nearest garage to me. After 15 mins on hold was told only their 5 service centres across the UK can deal with car issues with earliest date for inspection in March ! Said I’m not happy with that given what sales team advised or driving car. Told an amber warning light only advisory so to drive with caution and call back when light goes red.

      I’m not happy to do this, drive the car or with the after care experience (a sign of further stresses to come) so want a refund and to return the car asap.

      Please can you advise what I need to do today to get this done. 
       

      Many thanks 
      • 81 replies
    • Housing Association property flooding. https://www.consumeractiongroup.co.uk/topic/438641-housing-association-property-flooding/&do=findComment&comment=5124299
      • 160 replies
    • We have finally managed to obtain the transcript of this case.

      The judge's reasoning is very useful and will certainly be helpful in any other cases relating to third-party rights where the customer has contracted with the courier company by using a broker.
      This is generally speaking the problem with using PackLink who are domiciled in Spain and very conveniently out of reach of the British justice system.

      Frankly I don't think that is any accident.

      One of the points that the judge made was that the customers contract with the broker specifically refers to the courier – and it is clear that the courier knows that they are acting for a third party. There is no need to name the third party. They just have to be recognisably part of a class of person – such as a sender or a recipient of the parcel.

      Please note that a recent case against UPS failed on exactly the same issue with the judge held that the Contracts (Rights of Third Parties) Act 1999 did not apply.

      We will be getting that transcript very soon. We will look at it and we will understand how the judge made such catastrophic mistakes. It was a very poor judgement.
      We will be recommending that people do include this adverse judgement in their bundle so that when they go to county court the judge will see both sides and see the arguments against this adverse judgement.
      Also, we will be to demonstrate to the judge that we are fair-minded and that we don't mind bringing everything to the attention of the judge even if it is against our own interests.
      This is good ethical practice.

      It would be very nice if the parcel delivery companies – including EVRi – practised this kind of thing as well.

       

      OT APPROVED, 365MC637, FAROOQ, EVRi, 12.07.23 (BRENT) - J v4.pdf
        • Like
  • Recommended Topics

Spreadsheet with interest


bram stoker
style="text-align: center;">  

Thread Locked

because no one has posted on it for the last 1836 days.

If you need to add something to this thread then

 

Please click the "Report " link

 

at the bottom of one of the posts.

 

If you want to post a new story then

Please

Start your own new thread

That way you will attract more attention to your story and get more visitors and more help 

 

Thanks

Recommended Posts

Due to a lot of queries regarding interest I have designed spreadsheets that attempt to calculate a fair claim.

 

Please ask in this thread if you have any problems with it, and either myself, or someone else will try to help you.

 

These spreadsheets are freely given to help you. Please consider a donation to the site if you decide to use them so that we may continue to help you.

 

:)

 

Some spreadsheets can now be downloaded, using the links below.

 

Please choose the spreadsheet relevant to your claim - there are different versions depending on if you are in England or Scotland, which spreadsheet package you use, and also whether you are claiming for a bank account or credit card.

 

 

Bank Accounts

England - Simple - Excel

England - Simple - Works

England - Simple - OpenOffice

England - Advanced - Excel

England - Advanced - Works

 

Scotland - Simple - Excel

Scotland - Simple - Works

Scotland - Advanced - Excel

Scotland - Advanced - Works SORRY - WE HOPE TO RESTORE THIS LINK SHORTLY

 

 

Credit Cards

 

England - Simple - Excel

England - Simple - Works

England - Simple - OpenOffice

 

England - Advanced - Excel

England - Advanced - Works SORRY - WE HOPE TO RESTORE THIS LINK SHORTLY

 

Scotland - Simple - Excel

Scotland - Simple - Works

 

 

Please note: All spreadsheets are © Reclaim the Right Ltd.

  • Haha 3
  • Confused 6

[

Link to post
Share on other sites

  • Replies 1.6k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi again,

 

Once again, I've read through the threads but don't see anyone else with the same question.

 

Like many other people, I recieved copies of statements from 17/03/00 - 19/09/01. From 19/09/01 - 10/04/06 I recieved 'statement entries' which just detailed any charges/fees that had been levied against my account.

 

I have internet banking but am only able to look back until 07/03 so am unable to correctly fill in the spreadsheet kindly provided by Vampiress. I understand that I need to input what my account balance was at the time? Do I have to go back to Lloyds to request copy statements so that I can get this information?

 

 

Many thanks in anticipation for your help.

 

Feralkat

:)Lloyds ***WON*** £3,500 :)
Link to post
Share on other sites

You do need the balances to complete this particular spreadsheet.

 

If only have monthly balances you should be able to work the balances out if you have a complete list of transactions.

 

Alternatively an estimate could be entered, but this will produce a less acurate figure.

[

Link to post
Share on other sites

I have an interest-free overdraft facility, where the agreed limit has varied between £1000 and £1750. How should I account for this on the sheet?

 

Should I:

 

  1. use the balance as stated? This then puts the interest calculation off, since it is not charged on the whole balance.
  2. add whatever the limit is to the balance? This would be preferable for reading, as I can note the limit alongside, though would depend on whether the sheet calculates credit interest too.
  3. if the balance is between the limit and nil, consider the balance as nil? This produces correct calculations (since if the balance is in this range I neither pay nor receive interest)

Thanks

HSBCLloyds TSBcontractual interestNew Tax Creditscoming for you?NTL/Virgin Media

 

Never give in ... Never yield to force; never yield to the apparently overwhelming might of the enemy. Churchill, 1941

Link to post
Share on other sites

The spreadsheet is not designed to deal with the particular situation you are describing, although it seems you are able to 'fudge' it.

 

As the interest-free figure is not static throughout the time period, you will need to amend every account balance figure you enter on the spreadsheet. You need to deduct the interest-free amount from the true balance on each date, thereby reducing an overdrawn balance or increasing a positive balance.

 

NB. The spreadsheet does not initially deal with interest receivable from the banks. Any interest on amounts they have unlawfully deducted is dealt with in the 8% calculation and is only claimable when taken to court.

 

I will add your point to my list of amendments for future updates.

 

Many thanks for your input. I hope this helps.

[

Link to post
Share on other sites

As the interest-free figure is not static throughout the time period, you will need to amend every account balance figure you enter on the spreadsheet. You need to deduct the interest-free amount from the true balance on each date, thereby reducing an overdrawn balance or increasing a positive balance.

 

For now, since the interest column isn't populated when a zero or positive balance is entered, I have entered -0.01 to allow the entire interest charge to be added.

 

The spreadsheet does not initially deal with interest receivable from the banks. Any interest on amounts they have unlawfully deducted is dealt with in the 8% calculation and is only claimable when taken to court.

 

I have adjusted this to reflect my banks' unauthorised lending rates, which I should be able to claim before going to court (after all, they have effectively borrowed my money, all I am doing is calling it in - like them, I'm entitled to charge interest on that loan).

 

We'll see where that point goes, but I've established that taking the interest-free balance into account, the amount of excess interest has increased 600%

HSBCLloyds TSBcontractual interestNew Tax Creditscoming for you?NTL/Virgin Media

 

Never give in ... Never yield to force; never yield to the apparently overwhelming might of the enemy. Churchill, 1941

Link to post
Share on other sites

Yes, there is a new argument about charging the bank a commercial rate in your initial request and the notes need to be updated to reflect this.

 

To do so, just change the 8% to another rate of interest.

 

The argument is being discussed in another thread if anyone wants to discuss it further. Let's keep this thread for the actual workings of the spreadsheet.

 

There are some good points here. You're all creating work for me. Lol. I'll try to get an update done by the end of next weekend. Wishful thinking.:)

  • Haha 1

[

Link to post
Share on other sites

If the spreadsheet file format weren't so inconvenient, I'd try fixing some of those things myself.

HSBCLloyds TSBcontractual interestNew Tax Creditscoming for you?NTL/Virgin Media

 

Never give in ... Never yield to force; never yield to the apparently overwhelming might of the enemy. Churchill, 1941

Link to post
Share on other sites

If the spreadsheet file format weren't so inconvenient, I'd try fixing some of those things myself.
Do you not have access to Excel? If not there is an alternative spreadsheet for use with Open Office. That said, this is only a clone of the original Excel one - calculating the charges, the dates since 'offence' and the 8% APR element.

 

I won't make any promises, but if you would like me to have a go at converting Vamp's spreadsheet to Open Office I'll give it a shot!

Alecto, Magaera et Tisiphone: Nemesis on Earth is come.

 

All advice and opinions given by Spiceskull are personal, and are not endorsed by Consumer Action Group or Bank Action Group. Your decisions and actions are your own, and should you be in any doubt, you are advised to seek the opinion of a qualified professional.

Link to post
Share on other sites

Do you not have access to Excel? If not there is an alternative spreadsheet for use with Open Office. That said, this is only a clone of the original Excel one - calculating the charges, the dates since 'offence' and the 8% APR element.

No, I meant the internal format was inconvenient. If I make some improvement, and Vampiress wants to incorporate those changes in the master copy, she would have to repeat whatever I've done manually. In collaborative programming projects, which tends to use plain text, all I'd need to do is send a diff, which lets other people make the changes automagically.

 

Incidentally, my spreadsheet of choice is Gnumeric, which (like OpenOffice.org) will handle Excel files with only the required disdain. ;-)

HSBCLloyds TSBcontractual interestNew Tax Creditscoming for you?NTL/Virgin Media

 

Never give in ... Never yield to force; never yield to the apparently overwhelming might of the enemy. Churchill, 1941

Link to post
Share on other sites

Have tried using the spreadsheet but as my account is in credit at the date the interest is applied it shows zero. is this correct?

If you found this post helpful please click on the scales, top right. Thank you.

 

If you find this site helpful and if you reclaim your charges please donate by clicking the button at the top of the page

 

First Direct 1 - settled

First Direct 2 - settled

RBS 1 - claim made 8/5/6

RBS 2 - claim made 8/5/6

GE Capital - counter claim 6/5/6

Halifax - settled 31/5/6

Link to post
Share on other sites

Have tried using the spreadsheet but as my account is in credit at the date the interest is applied it shows zero. is this correct?

That's one of the bugs of the spreadsheet. It is only designed to give an estimate. The balance you enter represents an average balance of the month. For you this spreadsheet doesn't work. I'm sorry.

 

I'll have to look at dealing with this problem. Try entering an average balance of the month for the moment.

  • Confused 1

[

Link to post
Share on other sites

Right lad(y/ies) - quick question:

 

For the life of my account I have so far had either no overdraft or a 0% interest one. I moved from a kiddie account to a student account to a graduate account. I've a suspicion that part of my overdraft wasn't actually 0% (fag packet maths on interest charges - bearing in mind I exceeded my non-overdraft a bit,) but nothing, anywhere, seems to support my theory so I am left having to assume that the entire overdraft is interest free.

 

So, it seems to me that the interest I've paid is likely to be £0 more than it ought to have been - I'd only have paid interest on monies borrowed in excess of my agreed limit. It seems reasonable that interest charges would apply to this.

 

Would this mean that I should leave the second sheet empty, and include no mentions of interest charged when I make my initial claim to the bank? Naturally I shall be filling in the third (8%) sheet when the dreaded moment comes, but I can't see any way in which the second applies..

 

Just wanted to check, this isn't my usual line of work after all! (though if anyone has a business that has computers that want fixing I'll be glad to help:-D

 

Anything but direct and unsubstantiated insults regarding my appearence are gratefully accepted..

 

Krakan

Link to post
Share on other sites

Krakan,

 

You are absolutely correct, have understood completely, and applying the solution you suggest is spot on. Well done, and great to see such wonderful understanding of the workings and application of the spreadsheet. I'm touched.

 

A request for comments direct and without insult were unnecessary. I truly mean every word.

 

Seriously, you have it 'summed' up - pardon the pun.

 

Nice one.

 

Vamp. x:D

  • Confused 1

[

Link to post
Share on other sites

I've just used the new spreadsheet and added almost 10% to my wife's basic claim. What I ended up doing was to use the lowest balance in the preceeding month as the balance, especially as in many months there was a credit balance at the date the interest was deducted. If I didn't do this I ended up with no interest to claim back in that month even though I was being charged interest (if you see what I mean). I'm sure that my method doesn't skew that figures too much - it is only an estimate based on the data available (and without access to a mainframe data centre :rolleyes:).

 

Also the way HFX charge their interest is not (usually) for the current month, but the one preceeding it. I took this into account when I calculated the balance to use.

 

Anyway, thanks for the spreadsheet - I was wondering the best way to claim this related loss back. :cool:

 

Cheers.

Jeep (The Wife & I)

Halifax joint a/c (£3800 charges + £40 interest on charges over 11 years) - paid in full 23/06/06

Halifax joint a/c new charges £1100 - LBA sent 02/08/06

Halifax 2nd a/c (£1500 charges + £150 interest on charges) - partial payment received 13/07/06 (no s69 interest) - AQ filed 07/08/06 - Court awarded 50% of s69 interest (Bank didn't turn up!)

Halifax Visa (#1) Data Protection Act sent - statements arrived - £350 so far

Halifax Visa (#2) Data Protection Act sent - refunded £170

DONATE - Support this site, it supported you!

Follow the route: FAQs > Template Library > Parachute Account > Bank Forums > Spreadsheet

All advice given in good faith and without prejudice or liability, to be taken at your own risk!

Link to post
Share on other sites

Vampiress,

 

Thanks for the spreadsheet. However, there remains a question to which, I suspect, I am not the only one seeking an answer.

 

What's more, I have trawled all around the site and while I do not doubt it's out there somewhere, I'm buggered if I can find it!

 

Anyway, it's a simple question - at least, it is if you know the answer...

 

From where does the second lot of interest, ie the one you claim only if things go as far as court, derive? And, more to the point, why is it only applicable if things go that far?

 

Like I say, I'm sure there's a (relatively) straight-forward answer but I'm a journalist not an accountant or a legal expert and I'm blowed if I can work it out.

 

As ever, thanks in anticipation,

 

Fred_Funk

NatWest: seeking unlawful charges + interest incurred as a result of those charges of £4,292.82 and contractual interest (compounded) of £4,559.41. Court claim issued 16.01.08; acknowledgement of service filled by Cobbetts on 30.01.08

Link to post
Share on other sites

Hello thanks for the spreadsheet, just one (possibly stupid) question!

 

Just entered the interest parts in on the right hand columns, and i take it that it is working out rough estimate of the interest charge which is the piece you would add onto your claim total?

 

19.62 interest.... balance of -1,441.44 at time of interest = 7.21 that i would then add to my charges to the bank?

 

i also saw someone else comment about the spreadsheet not working if the balance you enter is positive? i think u advised to try to work out the average balance for the month - but what happens if the average is also positive?

 

Thanks again!

Link to post
Share on other sites

Essjaydee,

 

You are right to add the interest to the charges (of course, for other looking at this post, I'm NOT talking about the 8% interest).

 

Please see my notes in the spreadsheet as to the date and balance used. They can only ever give an estimate.

 

Vamp. x

[

Link to post
Share on other sites

  • 2 weeks later...

I downloaded the basic Xls sheet, I have entered the statement date and amount and reason. But how do i calculate the days since offence. Do i have to count back for every transaction (about 30)? Is there an easier way to work it out?

Link to post
Share on other sites

Hi,

 

Apologies if this is the wrong place to ask this question, but at what point does the 8% County Courts Act (?) interest get applied? I ask because there are a lot of conflicting accounts (I can expand if necessary) and I like to know exactly where I stand (especially with the letter before action).

 

From what I've largely pieced together, I need to:

 

1. Send a preliminary letter with a list of charges and the approximation of interest charged, without the 8% interest.

 

2. If I don't get any joy, I need to send a letter/notice before action, again including the list of charges but I'm not clear whether or not I can include the 8% at this stage - I'm thinking this is, again, without the 8% added....? :?

 

3. Still no joy, I need to file a claim with the county court, at which point I can add the 8%.

 

Is this the case or have I completely lost it?

 

Many Thanks

Link to post
Share on other sites

style="text-align: center;">  

Thread Locked

because no one has posted on it for the last 1836 days.

If you need to add something to this thread then

 

Please click the "Report " link

 

at the bottom of one of the posts.

 

If you want to post a new story then

Please

Start your own new thread

That way you will attract more attention to your story and get more visitors and more help 

 

Thanks

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 Caggers

    • No registered users viewing this page.

  • Have we helped you ...?


×
×
  • Create New...