Jump to content


  • Tweets

  • Posts

    • Well the difference is that in all our other cases It was Kev who was trying to entrap the motorist so sticking two fingers up to him and daring him to try court was from a position of strength. In your case, sorry, you made a mistake so you're not in the position of strength.  I've looked on Google Maps and the signs are few & far between as per Kev's MO, but there is an entrance sign saying "Pay & Display" (and you've admitted in writing that you knew you had to pay) and the signs by the payment machines do say "Sea View Car Park" (and you've admitted in writing you paid the wrong car park ... and maybe outed yourself as the driver). Something I missed in my previous post is that the LoC is only for one ticket, not two. Sorry, but it's impossible to definitively advise what to so. Personally I'd probably gamble on Kev being a serial bottler of court and reply with a snotty letter ridiculing the signage (given you mentioned the signage in your appeal) - but it is a gamble.  
    • No! What has happened is that your pix were up-to-date: 5 hours' maximum stay and £100 PCN. The lazy solicitors have sent ancient pictures: 4 hours' maximum stay and £60 PCN. Don't let on!  Let them be hoisted by their own lazy petard in the court hearing (if they don't bottle before).
    • Thanks for all the suggestions so far I will amend original WS and send again for review.  While looking at my post at very beginning when I submitted photos of signs around the car park I noticed that it says 5 hours maximum stay while the signage sent by solicitor shows 4 hours maximum stay but mine is related to electric bay abuse not sure if this can be of any use in WS.
    • Not sure what to make of that or what it means for me, I was just about to head to my kip and it's a bit too late for legalise. When is the "expenditure occured"?  When they start spending money to write to me?  Or is this a bad thing (as "harsh" would imply)? When all is said and done, I do not have two beans to rub together, we rent our home and EVERYTHING of value has been purchased by and is in my wife's name and we are not financially linked in any way.  So at least if I can't escape my fate I can at least know that they will get sweet FA from me anyway   edit:  ah.. Sophia Harrison: Time bar decision tough on claimants WWW.SCOTTISHLEGAL.COM Time bar is a very complex area of law in Scotland relating to the period in which a claim for breach of duty can be pursued. The Scottish government...   This explains it like I am 5.  So, a good thing then because creditors clearly know they have suffered a loss the minute I stop paying them, this is why it is "harsh" (for them, not me)? Am I understanding this correctly?  
    • urm......exactly what you filed .....read it carefully... it puts them to strict proof to prove the debt is enforceable, so thus 'holds' their claim till they coughup or not and discontinue. you need to get readingthose threads i posted so you understand. then you'll know whats maybe next how to react or not and whats after that. 5-10 threads a day INHO. dont ever do anything without checking here 1st.
  • 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

Excel Contractual Interest Spreadsheet


Mindzai
style="text-align: center;">  

Thread Locked

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

  • Replies 375
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Awesome spreadsheet - does what it says on the can.

 

How do you calculate the APR....i have a CLASSIC account with an AER of 4.25%.

 

I thought the APR only applied to loans and credit cards

 

:confused:

Link to post
Share on other sites

How do you calculate the APR....i have a CLASSIC account with an AER of 4.25%.

 

I thought the APR only applied to loans and credit cards

 

That's the usual idea, but if your card doesn't have any one-off charges made for certain transactions (eg cash advances, etc.) perhaps they may quote the AER instead.

 

However, if your CLASSIC account is a current account, then the AER or EAR will be quoted instead.

Link to post
Share on other sites

From post 148,

You then raise the figure you obtained from P*(1+r) to the power of n
No, it's (1+r)^n then multiply by P, otherwise you'd be doing P^n x (1+r)^n. Regards, Mad Nick

Abbey £8370 settled 17 Apr 07

Link to post
Share on other sites

That's the usual idea, but if your card doesn't have any one-off charges made for certain transactions (eg cash advances, etc.) perhaps they may quote the AER instead.

 

However, if your CLASSIC account is a current account, then the AER or EAR will be quoted instead.

 

Thx Bill

 

It is a classic current account, and i am still confused as to how to work it the daily & monthly interest rates as the spreadsheet requires the APR figure ----and i have an AER of 4.25%:twisted: :???: :???: :???:

Link to post
Share on other sites

From post 148, No, it's (1+r)^n then multiply by P, otherwise you'd be doing P^n x (1+r)^n. Regards, Mad Nick

I find P*(1+r)^n works for me.

I put the formula on row 1 of my Excel spready exactly as "=B1*(1+(E1/365))^D1"

Where B1 is £100.00, E1 is 20%, and D1 is 365 days, this gives me £122.13

I believe the mathematical hierarchy used forces it to use this set of priorities:-

The spready works out (E1/365) first, to give 0.000548,

then adds 1 to give 1.000548,

then raises this to the power of 365 to give 1.221336,

then multiplies this by 100 to give 122.1336

 

If I try punching the formula in in the order "P^n*(1+r)^n" it just tells me to #### off !!! :D

Link to post
Share on other sites

Thx Bill

 

It is a classic current account, and i am still confused as to how to work it the daily & monthly interest rates as the spreadsheet requires the APR figure ----and i have an AER of 4.25%:twisted: :???: :???: :???:

 

I think you will be correct in entering the APR on the spready as 4.25%.

Link to post
Share on other sites

Bill,

I find P*(1+r)^n works for me.
That formula is spot on and the way Excel works, it will do the (1+r)^n before multiplying by P. It was just that you described it wrongly as "raise the figure you obtained from P*(1+r) to the power of n." That would be [P*(1+r)] all to the power n which, as you computer says, is ****** Regards, Mad Nick

Abbey £8370 settled 17 Apr 07

Link to post
Share on other sites

Unfortunately Bill - The contractual interest TOTAL is less than the statutory 8% TOTAL when using the 4.25%....so i don't think that this is right.

 

Could i pm somebody and maybe someone can look at my spready...working with a figure of 29% seems more reasonable...but that is just a pie in hte sky figure that i remember somebody referring to on another thread.

 

Either a dumb moment or too many red wines for mother's day has got me confused on this spready...help please.

 

Kolo

Link to post
Share on other sites

Bill, That formula is spot on and the way Excel works, it will do the (1+r)^n before multiplying by P. It was just that you described it wrongly as "raise the figure you obtained from P*(1+r) to the power of n." That would be [P*(1+r)] all to the power n which, as you computer says, is ****** Regards, Mad Nick

 

Nick - my apologies for misunderstanding you !! :confused:

 

You are indeed correct, and the way I worded the analysis in my post was indeed incorrect.

 

My thanks for pointing it out as quickly as you have done, and I have now corrected the post to show the method, as you have kindly now clarified.

 

Cheers mate. :)

Link to post
Share on other sites

Unfortunately Bill - The contractual interest TOTAL is less than the statutory 8% TOTAL when using the 4.25%....so i don't think that this is right.

 

Could i pm somebody and maybe someone can look at my spready...working with a figure of 29% seems more reasonable...but that is just a pie in hte sky figure that i remember somebody referring to on another thread.

 

Either a dumb moment or too many red wines for mother's day has got me confused on this spready...help please.

 

Kolo

 

Kolo - the dumb moment is mine !! Yes, of course, if you claim 4.25% compound interest, then it will amount to less than 8% simple interest would !!

 

You need to check what the bank's current annual interest rates are for authorised and unauthorised overdrawing. You should be able to do this by checking online. I think you may then have a higher rate you can use in your spreadsheet.

Link to post
Share on other sites

Kolog, no way is your aer 4.25%, otherwise you would be lending the bank money(!), that is less than the base rate. If you tell me exactly what account you have and who with then i can tell you your APR

Leech

http://www.consumeractiongroup.co.uk/forum/site-questions-suggestions/53182-cant-find-what-youre.html#post436526

click my scales if you think i am helpful ! yes LHS down there !!

Once more into the breach dear friends,once more

or close the wall up with our banks dead ,

The games afoot,follow your spirit and upon this charge

Cry 'God for Harry' England and St George

Henry V battle of Agincourt 1415

Link to post
Share on other sites

i've been looking for the right spreadsheet to use for a CC claim, but this one also only calculates the 8% stat and not the same compounded rate (maybe around 16%) the bank charged me, which is what i thought most people claim?

Link to post
Share on other sites

This the right one Tifo, the compounded part is on the green daily tab!!!!

Once you have filled in the charges click on it and you will see.

Leech

http://www.consumeractiongroup.co.uk/forum/site-questions-suggestions/53182-cant-find-what-youre.html#post436526

click my scales if you think i am helpful ! yes LHS down there !!

Once more into the breach dear friends,once more

or close the wall up with our banks dead ,

The games afoot,follow your spirit and upon this charge

Cry 'God for Harry' England and St George

Henry V battle of Agincourt 1415

Link to post
Share on other sites

Please can anyone advise? I'm working on my spreadsheet (Mindzai's v1.9) i'm almost finished putting my charges in, about 20-30 lines to go. I'm on line number 194 and every time I try to insert the charge I get a pop up message saying 'protected cells cannot be modified'. :confused: What should I do?

Sorted it now, duh! Can't seem to delete this message though!

SM

Paying interest on a loan caused by penalty charges? Read this!!

 

Very useful A-Z here:

http://www.consumeractiongroup.co.uk/forum/site-questions-suggestions/53182-cant-find-what-youre.html?highlight=can%27t+find+what+you%27re+looking+for%3F

 

New strategy for Scots claims here:

http://www.consumeractiongroup.co.uk/forum/scotland/71013-urgent-attention-please-read.html

 

Scottish procedure:

http://www.consumeractiongroup.co.uk/forum/royal-bank-scotland/42620-scottish-procedure.html

I am a layperson not a legal expert, my advice is offered without prejudice or liability, it is purely my opinion based on personal experience and should be treated as such. If in any doubt seek the advice of a qualified professional.

Link to post
Share on other sites

Mindzai has protected some cells to ensure precious fields aren't overwritten. I'm sure this is probably something that has been overlooked and will be amended and a new release will come out but in the meantime, if you go to TOOLS then it will say something along the lines of UNPROTECT SHEET (no precise as I don't have excel to hand right now). Hopefully there are no passwords on it, this will then allow you to carry on. If you have any problems, there may be advice further up in this thread with regards to unprotecting the sheet (and it might be more correct lol)!!

If my post has been useful, tip my scales and let me know

 

Always start with the User guide!

Stuck with RBS charges? Click here!!

 

RBS CA1 £2794 SETTLED!!! RBS CA2 £503 SETTLED!!! HBOS CC £498 SETTLED!!! Barclaycard £705 (with CCI) ONGOING!!! NATWEST CA ONGOING!!! LLOYDS CA x 2, CC, LOAN ONGOING!!! HFC LOAN ONGOING!!!

Link to post
Share on other sites

T4FF you're a sweetie and always reply really quickly- do you live here?LOL

 

You were right of course, simple case of unprotecting sheet, i've done it now and spreadsheet is done, yippee!

 

ps. thanks for kick up the bum earlier!

SM:p

Paying interest on a loan caused by penalty charges? Read this!!

 

Very useful A-Z here:

http://www.consumeractiongroup.co.uk/forum/site-questions-suggestions/53182-cant-find-what-youre.html?highlight=can%27t+find+what+you%27re+looking+for%3F

 

New strategy for Scots claims here:

http://www.consumeractiongroup.co.uk/forum/scotland/71013-urgent-attention-please-read.html

 

Scottish procedure:

http://www.consumeractiongroup.co.uk/forum/royal-bank-scotland/42620-scottish-procedure.html

I am a layperson not a legal expert, my advice is offered without prejudice or liability, it is purely my opinion based on personal experience and should be treated as such. If in any doubt seek the advice of a qualified professional.

Link to post
Share on other sites

do you live here?LOL

:D

If my post has been useful, tip my scales and let me know

 

Always start with the User guide!

Stuck with RBS charges? Click here!!

 

RBS CA1 £2794 SETTLED!!! RBS CA2 £503 SETTLED!!! HBOS CC £498 SETTLED!!! Barclaycard £705 (with CCI) ONGOING!!! NATWEST CA ONGOING!!! LLOYDS CA x 2, CC, LOAN ONGOING!!! HFC LOAN ONGOING!!!

Link to post
Share on other sites

I'm about to send my LBA to Cap One - but I have some serious doubts about the spreadsheet I have used (taken from here... 6. Interest calculation spreadsheets I have used England - Advanced - Excel). Or put more accurately how I've used them. In a nutshell... the sheet does the following to calculate simple contractual int.

 

(Total amount charged in fees over the period of time)

 

Divided by

 

(The statement balance Month 1)-(the payment made in respect of that eg. the one which appears on Month 2 statement)

 

Multiplied by

 

Total interest charged as per Month 1 statement

 

= interest to reclaim for Month 1

 

I might be being thick, but I don't understand why the following month's payment needs to be deducted? Can anyone explain to set my mind at rest?

BATTLES WON/ONGOING

NatWest Bank- £8k+ **SETTLED IN FULL**

Capital One - £2k+ ** SETTLED IN FULL**

Cahoot - £255 **SETTLED IN FULL**

Abbey National - £385 **SETTLED IN FULL**

Central Trust - £3k+ **SETTLED IN FULL**

GMAC RFC - £2k **SETTLED IN FULL**

Now going after Natwest (again) and Halifax.

Link to post
Share on other sites

fATBOY 88 send it over and I'll have a look if you like.

BATTLES WON/ONGOING

NatWest Bank- £8k+ **SETTLED IN FULL**

Capital One - £2k+ ** SETTLED IN FULL**

Cahoot - £255 **SETTLED IN FULL**

Abbey National - £385 **SETTLED IN FULL**

Central Trust - £3k+ **SETTLED IN FULL**

GMAC RFC - £2k **SETTLED IN FULL**

Now going after Natwest (again) and Halifax.

Link to post
Share on other sites

  • Recently Browsing   0 Caggers

    • No registered users viewing this page.

  • Have we helped you ...?


×
×
  • Create New...