Jump to content


  • Tweets

  • Posts

    • Unsettling the applecart?,  I'm going to be direct here, I know how this works , I've been in far worse situation than your relative, and I can assure you , now that there i likely a default in her name, it makes absolutely ZERO difference if she pays or not. Denzel Washington in the Equalizer , 'My only regret is that I can't kill you twice'... It's the same with a default, they can only do it once and it stays on your credit file for 6 years if she pays or not, and as it stands right now she's flushing £180 of her hard earned money down the toilet  so that the chaps at Lowell can afford a Christmas party. As for the SAR this is everybody's legal right, originally under the Data Protection act 1998 and now under GDPR, it's her right to find out everything that the original Creditor has on her file, and by not doing it the only person she is doing a massive disservice to is her self. As the father of 2 young adults myself, they need to learn at some point.. right?
    • Thank you for your pointers - much appreciated. dx100uk - Apologies, my request wasn't for super urgent advice and I have limited online access due to my long working hours and caring obligations - the delay in my response doesn't arise in any way from disrespect or ingratitude. I will speak to her at the weekend and see if she will open up a bit more about this, and allow me to submit the subject access request you advise - the original creditor is 118 118 loans and from the letter I saw (which prompted the conversation and the information) the debt collection agency had bought the debt from 118 and were threatening enforcement which is when she has made a payment arrangement with them for an amount of £180 per month. It looks as if she queried matters at the time (so I wonder if I might with the FIO request get access to their investigation file?) - the letter they wrote said "The information that you provided has been carefully considered and reviewed. After all relevant enquiries were made it has been confirmed that there is not enough evidence present to conclusively prove that this application was fraudulent.  However, we have removed the interest as a gesture of goodwill. As a result of the findings, you will be held liable for the capital amount on the loan on the basis of the information found during the investigation and you will be pursued for repayment of the loan agreement executed on 2.11.2022 in accordance with Consumer Credit Act 1974"  The amount at that time was over £3600 in arrears, as no payments had been made on it since inception and I think she only found out about it when a default notice came in paper form. I'm a little reluctant to advise her to just stop paying, and would like to be able to form a view in relation to her position and options before unsetting the applecart - do you think this is reasonable? She is young and inexperienced with these things and getting into this situation has brought about a lot of shame regarding inability to sort things out/stand up for herself, which is one of the reasons I have only found out about this considerably later Thank you once again for your advice - it is very much appreciated.    
    • That's fine - I'm quite happy to attend court if necessary. The question was phrased in such a way that had I declined the 'consideration on the papers' option, I would have had to explain why I didn't think such consideration was appropriate, and since P2G appear to be relying on a single (arguably flawed) issue, I thought it might result in a speedier determination.
    • it was ordered in the retailers store  but your theory isnt relevant anyway, even if it fitted the case... the furniture is unfit for purpose within 30 days so consumer rights act overwrites any need to use 14 days contract law you refer too. dx  
    • Summary of the day from the Times. I wasn't watching for a couple of interesting bits like catching herself out with her own email. Post Office inquiry: Paula Vennells caught out by her own email — watch live ARCHIVE.PH archived 23 May 2024 11:57:02 UTC  
  • 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
      • 161 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 1902 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

I've done a little test on a dummy spreadsheet and worked out that if I change the figure for amount paid in order to leave exactly £180 as my remaining balance (to equate to the penalties charged) it puts the whole amount of the interest charged to interest on penalties. Once I go one pound over this on the amount paid, thus leaving £179 as my remaining balance (and less than the penalties charged), it screws up the interest on penalties figure.

 

You have been very helpful indeed in replying to my messages as you have, and this is not aimed at you personally because I know you are trying to help, and I know it's a free service for which I am extremely grateful, BUT I am a little miffed with the BAG that this query can't be sorted out without me having to have a website, afterall I can't be the only one who paid off more than the penalties charged and has this problem. And it seems there is no way of getting help with this - so where does that leave me now?

Link to post
Share on other sites

  • Replies 1.6k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

You don't need your own website, there are many file hosts that you can use for free. Try RapidShare. Browse for the spreadsheet on your PC and click upload, then paste the link in a post.

Mindzai & Lucid vs Lloyds TSB

 

Mindzai's Account - Partial settlement offer rejected

Joint Account - Partial settlement offer rejected

_________________________

Spreadsheet for compound contractual interest and statutory (s69) interest:

Download v1.9 [Tested with Excel 97-2007 and OpenOffice 2]

PLEASE NOTE: You should fully research contractual interest before you use that functionality of this spreadsheet. If in any doubt please use it to calculate 8% interest under s69 County Courts Act 1984.

Link to post
Share on other sites

Having looked at your spreadsheet I can see how it is getting the amount wrong, and can understand how it's getting that figure. What I can't tell yet is how to fix it. If Vamps is around she may come up with a suggestion faster than I can, but I'll keep trying!

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

I am about to complete the Advanced excell spreadsheet for a TSB credit card.

 

Hope some kind person can answer my queries

 

Do I start the claim from the date that the first charge occurred?

 

Then do I put down all payments, interest and balances for every month after that whether there were charges on them or not?

 

Thanks

Pam:mad:

Link to post
Share on other sites

Hi,

Is there anyone who wouldn't mind taking a look at my excel spread sheet not sure if I have completed it correctly and don't want to look stupid if I send it and its wrong. Let me know?? :o)

Link to post
Share on other sites

Sorry Pam. I did reply with details of using the spreadsheet for bank accounts and then saw that you need advice for the credit card spreadsheet. I've tried looking at it but I don't really understand how it works - probably doesn't help that I've never owned a credit card.

 

Sorry I couldn't help you out, but I'm sure somebody else will reply soon. :)

Mindzai & Lucid vs Lloyds TSB

*Won unconditionally with contractual interest (29.85% compounded)

Lucid's Account - £749.62 * Joint Account - £2019.64 * Mindzai's Account - £595.65

*All settled in full - 6/2/07

*Hearings - 7/2/07

*Prelims sent - 9/8/06

_______

GOT A COURT DATE? A guide to the later stages

 

[sIGPIC][/sIGPIC]

Link to post
Share on other sites

Having looked at your spreadsheet I can see how it is getting the amount wrong, and can understand how it's getting that figure. What I can't tell yet is how to fix it. If Vamps is around she may come up with a suggestion faster than I can, but I'll keep trying!
Right - been thinking a bit more on this this and I think it could well be right. According to the sheet you had a large balance and mostly paid it off that month, leaving £124 of debt. By that time the accumulated charges were greater than the new balance, therefore the interest charged that month was entirely due to the charges, and as they were greater than the balance the proportion of interest was greater than 100% if the interest. I think. ;)

 

If the bank challenges the amount ask them to calculate it for you - after all they've got buildings full of expensive computers to work it out!

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

I am about to complete the Advanced excell spreadsheet for a TSB credit card.

 

Hope some kind person can answer my queries

 

Do I start the claim from the date that the first charge occurred?

 

Then do I put down all payments, interest and balances for every month after that whether there were charges on them or not?

 

Thanks

Pam:mad:

 

Can Someone help me please!!

Link to post
Share on other sites

Start from the month with the first charge. Then enter one line per statement from then until now.

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

Hi,

Is there anyone who wouldn't mind taking a look at my excel spread sheet not sure if I have completed it correctly and don't want to look stupid if I send it and its wrong. Let me know?? :o

 

I need help please going mad!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

Pm me

 

Thanks

Link to post
Share on other sites

Right - been thinking a bit more on this this and I think it could well be right. According to the sheet you had a large balance and mostly paid it off that month, leaving £124 of debt. By that time the accumulated charges were greater than the new balance, therefore the interest charged that month was entirely due to the charges, and as they were greater than the balance the proportion of interest was greater than 100% if the interest. I think. ;)

 

If the bank challenges the amount ask them to calculate it for you - after all they've got buildings full of expensive computers to work it out!

 

Thanks Jeep :). I understand your thinking but I'm not 100% satisfied that this isn't going to make my claim lose credibility, giving the credit card co. the chance to defend and have my claim thrown out. Not saying you're wrong but I do think we're slightly guessing here and I don't feel comfortable proceeding with a claim that might be flawed. Is there any legal onus on them to come up with calculations of what they owe me?

Is anyone with more knowledge than me able to confirm whether you can claim more than 100% of the interest charged? If not, does the spreadsheet template need to be corrected to put in an argument such as 'only insert 100% of interest charged' ?? :confused: Once again, really grateful for your time Jeep.

Link to post
Share on other sites

Does my spreadsheet look as if it's entered correctly? Bear in mind that Barclays calculate the interest for the month but take the money from my account the next month. I went back one month and found the highest overdrawn balance for that period.

 

Here's the spreadsheet (I haven't deleted the extraneous repeating charges from the end of the list yet):

 

spreadsheet_00_06.gif

 

Many thanks.

 

p.s. Haven't entered the "Estimate of previous charges" figure yet. Should I take the average of the charges levied in 2003 then multiply by the number of years from account opening to March 2000?

July 10th 2006 - S.A.R - (Subject Access Request) - (Subject Access Request) - (Subject Access Request) to Barclays delivered

December 1st 2006 - N1 filed! At last!

Link to post
Share on other sites

Does my spreadsheet look as if it's entered correctly? Bear in mind that Barclays calculate the interest for the month but take the money from my account the next month. I went back one month and found the highest overdrawn balance for that period.

[snip]

p.s. Haven't entered the "Estimate of previous charges" figure yet. Should I take the average of the charges levied in 2003 then multiply by the number of years from account opening to March 2000?

Looks fine. I worked out an estimate for my claim by counting the number of months of missing data and multilplying it by the average number of charges received in a month at the oldest rate charged. I also explained how I had arrived at the estimate and the period it covered, etc. in the LBA letter so that they were completely clear.

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

Thanks Jeep :). I understand your thinking but I'm not 100% satisfied that this isn't going to make my claim lose credibility, giving the credit card co. the chance to defend and have my claim thrown out. Not saying you're wrong but I do think we're slightly guessing here and I don't feel comfortable proceeding with a claim that might be flawed. Is there any legal onus on them to come up with calculations of what they owe me?

Is anyone with more knowledge than me able to confirm whether you can claim more than 100% of the interest charged? If not, does the spreadsheet template need to be corrected to put in an argument such as 'only insert 100% of interest charged' ?? :confused: Once again, really grateful for your time Jeep.

I understand your concern. My feeling was that in previous months the proportion was very low, so I don't really think it matters too much in this one month. One option is to overtype the result for that row with the value of the interest for that month. It's the best I can suggest right now.

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

Can somebody show me a way of working out the interest without using a sreadsheet please? I have'nt got this excel thing, i.m a pen'n'paper man myself and can use a calculator, i'm sure theres loads of people out there that wants to know the correct answer to this question. THANKS [email protected]

Link to post
Share on other sites

I have'nt got this excel thing
If you don't have, or don't want Excel, you could always download Open Office (which is completely free) from here.

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

Looks fine. I worked out an estimate for my claim by counting the number of months of missing data and multilplying it by the average number of charges received in a month at the oldest rate charged. I also explained how I had arrived at the estimate and the period it covered, etc. in the LBA letter so that they were completely clear.

 

Thanks very much Jeep - appreciate the advice! As for using the oldest rate, I didn't think that I had to add interest to the estimate figure. To be honest, I have no idea what any older rate might have been.

 

Last thing - this may be a issue with Excel on Apple Mac, but I can't enter a fractional amount for the interest. Everytime I enter 27.9%, Excel rounds it up to 28% when I hit . Any idea how to work around this?

July 10th 2006 - S.A.R - (Subject Access Request) - (Subject Access Request) - (Subject Access Request) to Barclays delivered

December 1st 2006 - N1 filed! At last!

Link to post
Share on other sites

Everytime I enter 27.9%, Excel rounds it up to 28% when I hit . Any idea how to work around this?
You need to format the cell/s so that entries are accepted up to two decimal places...

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

Anyone know how I do this?

July 10th 2006 - S.A.R - (Subject Access Request) - (Subject Access Request) - (Subject Access Request) to Barclays delivered

December 1st 2006 - N1 filed! At last!

Link to post
Share on other sites

Right click cell > Format Cells..., then under the 'Number' tab select 'Number' and select 2 (or whatever) decimal places. You wont notice any change in the actual result however because Excel will be using the decimal figure regardless of the formatting.

 

Edit: just noticed you're on a mac, hence no right click! You can get to the cell formatting menu by using the toolbar: Format > Cells...

  • Confused 1

Mindzai & Lucid vs Lloyds TSB

 

Mindzai's Account - Partial settlement offer rejected

Joint Account - Partial settlement offer rejected

_________________________

Spreadsheet for compound contractual interest and statutory (s69) interest:

Download v1.9 [Tested with Excel 97-2007 and OpenOffice 2]

PLEASE NOTE: You should fully research contractual interest before you use that functionality of this spreadsheet. If in any doubt please use it to calculate 8% interest under s69 County Courts Act 1984.

Link to post
Share on other sites

hi there, could someone out there please clarify for me the 2 points. i intend to go for contractual rate on one of my cards. I know how to work it out with the spreadsheet.But my "interest on penalties" doesn't change when i enter the 24.8% rate,only the cell with the 8% changes obviously.Now my questions are:

1.which of them do i include in my lba?the "now"24.8% one, or the normal "interest on Penalty" one, or both of them??I don't want to end up claiming interest twice and cocking it all up.

2.when i file my claim......do i tick the "are you claiming the s69 8%, blah blah blah thing?And what exactly should i put as charges and as interest out of the 4 amounts on my spreadsheet??

I know it might sound stupid, i just want to make sure i got it all right.

Thanks for your help in advance.

Link to post
Share on other sites

style="text-align: center;">  

Thread Locked

because no one has posted on it for the last 1902 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...