Hi,
Hope you're all well. I'm new here and was wondering if I could get some help on an excel calculation I'm trying to do.
Essentially, I'm trying to work out how much each month an individual would get if they saved a fixed amount and received a fixed interest on their savings.
I'm using the future value to calculate this and have a fixed annual interest rate. Below is the formula i've used but the results I get come out incorrectly
=FV(1+interest rate)^(1/12)-1,(D6/12), -(mthly saving amount), -(initial amount),1)
I've attached my spreadsheet containing my formula if that would be more useful. Can anyone tell me what I'm doing wrong.
Thanks for any help
Bookmarks