Jump to content


  • Tweets

  • Posts

    • Parents and teens alike are trading in their smartphones for "dumber" models to help stay offline.View the full article
    • The coffee giant is suffering as customers "lose it" over price hikes and other controversies.View the full article
    • Victims as far afield as Singapore, Peru and the United Arab Emirates fell prey to their online scams.View the full article
    • Rights groups warn of state paranoia as experts on hypersonics, the science behind ultrafast missiles, have been jailed.View the full article
    • The Contract itself The airport is actually owned by the Ontario Teachers Pension Plan. There should be an authority from them for Bristol airport group  to sign on their behalf. Without it the contract is invalid. The contract has so many  clauses redacted that it is questionable as to its fairness with regard to the Defendants ability to receive a fair trial. In the case of WH Holding Ltd, West Ham United Football Club Ltd -v- E20 Stadium LLP [2018],  In reaching its decision, the Court gave a clear warning to parties involved in litigation: ‘given the difficulties and suspicions to which extensive redaction inevitably gives rise, parties who decide to adopt such an appropriate in disclosure must take enhanced care to ensure that such redactions are accurately made, and must be prepared to suffer costs consequences if they are not’. The contract is also invalid as the signatories are required to have their signatures co-signed by independent witnesses. There is obviously a question of the date of the signatures not being signed until 16 days after the start of the contract. There is a question too about the photographs. They are supposed to be contemporaneous not taken several months before when the signage may have been different or have moved or damaged since then. The Defendant respectfully asks the Court therefore to treat the contract as invalid or void. With no contract there can be no breach. Indeed even were the contract regarded as valid there would be no breach It is hard to understand why this case was brought to Court as there appears to be no reasonable cause to apply to the DVLA.............
  • Recommended Topics

  • Our picks

    • If you are buying a used car – you need to read this survival guide.
        • Like
      • 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
        • Like
      • 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 5593 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...