Calculating monthly versus annual returns | GIC discussions | Discussion forum

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
No permission to create posts
sp_Feed Topic RSS sp_TopicIcon
Calculating monthly versus annual returns
February 5, 2014
9:50 am
Loonie
Member
Members
Forum Posts: 9437
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline
Go to Top
1sp_Permalink sp_Print

I am a bit foggy on how to figure out whether it is better, with GICs, when one has the option, to ask for a monthly payout or an annual one, or some other configuration.

Assuming no immediate need for the money and assuming the income is equally sheltered or not sheltered either way, is there some sort of mathematical formula that I can apply to figure this out? An online tool would be great, but I haven't found one.

My calculator finger is getting worn out trying to do this manually every time, and I make mistakes and have to do it all over again!

February 5, 2014
10:04 am
kanaka
Member
Members
Forum Posts: 1232
Member Since:
December 23, 2011
sp_UserOfflineSmall Offline
Go to Top
2sp_EditHistory sp_Permalink sp_Print

Try this. Not exactly what you are looking for. An annual pay out will give you more than a monthly pay out.

http://www.moneychimp.com/calc.....ulator.htm

If you are into Excel I can send you some of the calculations to use.

February 5, 2014
5:46 pm
Loonie
Member
Members
Forum Posts: 9437
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline
Go to Top
3sp_Permalink sp_Print

Thanks, guys. I guess it's good to know I'm not the only one who hasn't found the magic button to press on this question.
Alas, I haven't mastered Excel, but no doubt should.

February 5, 2014
5:47 pm
Loonie
Member
Members
Forum Posts: 9437
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline
Go to Top
4sp_Permalink sp_Print

Perhaps the best thing would be to ask the financial institution which is making the offer to figure it out, i.e. ask them what exactly would be the returns for the various configurations. That would be slower, but perhaps more reliable than me trying to figure it out and not knowing if I did it right!

February 5, 2014
6:40 pm
kanaka
Member
Members
Forum Posts: 1232
Member Since:
December 23, 2011
sp_UserOfflineSmall Offline
Go to Top
5sp_Permalink sp_Print

Try Outlook Financial. They have a calculator on their web site. I cannot confirm what it does as it won't run on my ipad.

February 5, 2014
10:04 pm
Loonie
Member
Members
Forum Posts: 9437
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline
Go to Top
6sp_EditHistory sp_Permalink sp_Print

Doesn't work on my computer either due to security issues apparently.

February 5, 2014
10:14 pm
Loonie
Member
Members
Forum Posts: 9437
Member Since:
October 21, 2013
sp_UserOfflineSmall Offline
Go to Top
7sp_Permalink sp_Print
No permission to create posts
sp_Feed All RSS
Go to top

Please write your comments in the forum.