We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
Calculator tool for Daily Interest

P1Fanatic
Posts: 375 Forumite


Anyone got a good link for such a tool? I am trying to work out the daily interest rate paid on my Trading212 Cash ISA. The app tells me it is 5.1% AER but I had an email before saying it was dropping to 5% on Sept 9th. I tried one tool but using 5 or 5.1% did not match what Trading212 are paying out:
Daily Compound Interest Calculator (thecalculatorsite.com)
Example:
My ISA balance is £32754.87 and Trading212 are paying £4.47 per day (well it was £4.46 until today). Yet if I use this calculator I get:
5% = £4.49
5.1% = £4.58
So neither match. No doubt I am doing something wrong but I would like to understand what.
Daily Compound Interest Calculator (thecalculatorsite.com)
Example:
My ISA balance is £32754.87 and Trading212 are paying £4.47 per day (well it was £4.46 until today). Yet if I use this calculator I get:
5% = £4.49
5.1% = £4.58
So neither match. No doubt I am doing something wrong but I would like to understand what.
0
Comments
-
If the AER is 5.1% and the account pays interest daily, then the gross rate used will be significantly less than 5.1%, to allow for compounding, I make it 4.97% but don't know if they publish a gross rate and also don't know how they deal with rounding....
https://www.moneysavingexpert.com/banking/interest-rates/#save
0 -
@eskbanker is correct, the underlying rate is 4.97% and the AER 5.1% when interest is compounded.
See the details from the link below, click View Further Details
https://moneyfactscompare.co.uk/isa/easy-access-cash-isas/
0 -
I've only had a T212 cash ISA a few weeks, but this excel formula seems to be working so far to give me an accumulated balance:
=ROUNDDOWN( [A] * (1+ ((1+ [B] )^(1/365.25)-1) ) ^ (TODAY() - DATEVALUE("[C]")),2)[A] = ACCT BALANCE: UPDATE WHENEVER RATE CHANGES[B] = AER: CURRENTLY 5.1%[C] = DATE LAST UPDATED ‘BALANCE’ AMOUNT: UPDATE WHENEVER RATE CHANGES
I think in your case it could be (to start from today):
=ROUNDDOWN(32754.87 * (1+((1+5.1%)^(1/365.25)-1)) ^ (TODAY()-DATEVALUE("11/10/2024")),2)
or at least that gives you something to work from...1
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.3K Banking & Borrowing
- 252.9K Reduce Debt & Boost Income
- 453.2K Spending & Discounts
- 243.3K Work, Benefits & Business
- 597.9K Mortgages, Homes & Bills
- 176.6K Life & Family
- 256.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards