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.
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
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.
Not sure what happened there, Scott. It's a small file, but not that small 🙂 Here it is again.
