My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Canada Pension Calculation|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Canada Pension Calculation|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Canada Pension Calculation
Avatar
Scott Savage
Sherwood Park, alberta Canada

New Member
Members
Level 0
Forum Posts: 2
Member Since:
September 17, 2019
sp_UserOfflineSmall Offline
1
September 17, 2019 - 11:30 pm
sp_Permalink sp_Print

I am trying to make a choice of whether to take my Canada Pension at age 60, 65 or 70 and want to calculate interest at 6% on the monies received monthly. I have attached the spreadsheet, but can't figure out the FV formula to allow me to do this.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4524
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
September 18, 2019 - 10:16 am
sp_Permalink sp_Print sp_EditHistory

Hi Scott,

Welcome to our forum!

Please see the file attached. Note: the interest rate doesn't take into effect any compounding. This should not be taken as financial advice. I'm merely showing you how the FV function works in Excel. It's up to you to see financial advice that takes into account tax implications and risk factors associated with fluctuating interest rates etc.

Mynda

Avatar
Scott Savage
Sherwood Park, alberta Canada

New Member
Members
Level 0
Forum Posts: 2
Member Since:
September 17, 2019
sp_UserOfflineSmall Offline
3
September 19, 2019 - 3:42 am
sp_Permalink sp_Print

Thanks for taking the time to look at this for me. Seems the attachment included in your reply is 0bytes, so might be corrupt or empty. Excel won't open it for me.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4524
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
September 19, 2019 - 7:26 am
sp_Permalink sp_Print

Not sure what happened there, Scott. It's a small file, but not that small 🙂 Here it is again.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Atos Franzon, Louis Muti
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852

 

Member Stats:
Guest Posters: 49
Members: 32359
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen