Interest Calculation Conundrum | Your stories | Discussion forum

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Interest Calculation Conundrum
September 5, 2020
8:27 pm
Loonie
Member
Members
Forum Posts: 9391
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline

I'm stumped.

A year ago, I bought a 15 month GIC, compounded annually, no fancy footnotes or conditions.

I checked to see that the interest for the first year had been credited. It had, but the amount credited is higher than I expected.

The rate on the GIC is 3.00%, but the amount I received works out to 3.0165%. It is almost equal to an extra two days' interest, pro-rated.

This is a flat rate, not a rate composed of two portions. There is no bonus. tiered rates, reimbursement, or anything of that kind. Te funds are non-registered. We are agreed on the amount of the principal.

Shouldn't it just be [principal x 3%]?

For obvious reasons, I am not motivated to identify the FI or waste time trying to reach them on the phone toi discuss this, but it is one that is discussed regularly on this forum, so I assume others have had a similar experience and someone must be able to explain this to me.
Can someone please clarify what has happened, or should I expect a correction when the monthly statement comes?

Thx

September 5, 2020
8:42 pm
Norman1
Member
Members
Forum Posts: 7162
Member Since:
April 6, 2013
sp_UserOfflineSmall Offline

Would the first anniversary be on a non-business day, like a Saturday?

September 5, 2020
8:48 pm
MG
Member
Members
Forum Posts: 277
Member Since:
February 16, 2013
sp_UserOfflineSmall Offline

Did you take into account that this year was a leap year , giving you at least one extra day of interest?

September 5, 2020
11:02 pm
Loonie
Member
Members
Forum Posts: 9391
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline

The anniversary date was a regular weekday, last Friday. Would it have made any difference if it weren't?

I did think about the fact that it was a leap year but I felt that a year is a year is a year and couldn't see why they would give me more money for the extra day. I reasoned that the banks wouldn't likely expect to pay out an extra 1/365 every four years - although they have to for HISAs. My assumption was that the rate was calculated to reflect the entire year. Was I wrong?

September 6, 2020
6:51 am
GR
Member
Members
Forum Posts: 661
Member Since:
September 15, 2017
sp_UserOfflineSmall Offline

Loonie,

I assume you are referring to P.T. as I have had same experience with their 15 month GIC. After 1 year, they credited 367 days interest. One "extra" day is because of the leap year and one "extra" day is because they included the anniversary day for the calculation. For interest paid at the end of the 15 months, the calculation started with the day after the anniversary day. Compared to what I expected, they paid interest for 1 more day for the first year and 1 fewer day for the last 3 months (based on number of days in the 3 months). Overall, no excess interest was paid. Yes, some F.I. pay interest for an extra day in a leap year.

September 6, 2020
6:57 am
gicjunkie
Ontario
Member
Members
Forum Posts: 658
Member Since:
November 7, 2014
sp_UserOfflineSmall Offline

I have found that, depending on the institution, extra interest is paid for a leap year. Don't know why there would be another day of interest. Sometimes there are glitches in their computer programmes, and they can claw it back at the end.

September 6, 2020
9:00 am
topgun
Member
Members
Forum Posts: 452
Member Since:
September 6, 2020
sp_UserOfflineSmall Offline

I cashed ALL my RRSP GIC's in the 1990's and invested the cash elsewhere.

I started purchasing term deposits/GIC's in 2018.

I had no feel for where I should buy. A friend recommended buying several $1,000 GIC's with relatively short terms. I tried 120 day, 9 month, 18 month, 1 year and a few 2-5 year GIC's. I found new features that changed since the 1990's. It took about 6 months before I found a MB CU.

I was interested in an Excel spreadsheet program. I had no spreadsheet for GIC's in the 1990's. I created a flexible Excel spreadsheet for ALL terms 31+ days and 1+ year(s). I noticed when an anniversary date happened in April the FI paid one more day of interest for February 29th. I found that ALL the FI I deal with pay extra day interest for leap year.

On the CU statement the GIC is reported with principle plus paid interest and earned interest (i.e. accrued interest). The banks and CU report differently by 1 day. Put July 1st in my program and it computes CU GIC value to June 30th. For bank statements put June 30th (i.e. may be last business day of month) for GIC value.

You can purchase GIC's any FI, insurance company, mutual fund company. I found a FI that pays competitive 5 year rates, good service, good reporting. Ease of depositing/withdrawing funds is important.

Have a Great Day

September 6, 2020
1:59 pm
Loonie
Member
Members
Forum Posts: 9391
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline

Thanks for your comments and experiences. I guess I shall assume that leap year is the issue and that a year is not just a calendar year.
Who knew?
It sounds like yearly terms are in fact daily rates which are advertised as yearly ones for simplicity. This may account for the odd numbers often seen at, for example, Motive, e.g. 2.53 or whatever.
I've noted other minor discrepancies at other FIs in the past but never bothered to investigate as it seemed too much trouble, was in my favour, and smaller amounts than this.
Optimistically, we should therefore see a slight uptick in rates next year! Hah!

September 6, 2020
4:14 pm
Rick
Member
Members
Forum Posts: 1110
Member Since:
February 17, 2013
sp_UserOfflineSmall Offline

gicjunkie said
I have found that, depending on the institution, extra interest is paid for a leap year. Don't know why there would be another day of interest. Sometimes there are glitches in their computer programmes, and they can claw it back at the end.  

I haven't dealt with an FI that actually paid and extra day of interest in a leap year. 1 year is 1 year whether it's 365 or 366 days. Exception is short terms that pay less than a year.

September 6, 2020
8:45 pm
Norman1
Member
Members
Forum Posts: 7162
Member Since:
April 6, 2013
sp_UserOfflineSmall Offline

Loonie said
The anniversary date was a regular weekday, last Friday. Would it have made any difference if it weren't?

I was thinking that perhaps it was a Saturday and Saturday isn't a business day for the banks.

So, they compounded the interest on Monday and Monday would be an extra two days past the anniversary date.

Please write your comments in the forum.