Hey guys,
I'm trying to create a spreadsheet that allows the user to enter the number of years to college, today’s tuition, estimated annual tuition growth rate and rate of return on investment. I want the spreadsheet to calculate the constant monthly investment needed to save enough to pay for college,
I understand that it's going to be something like.
=PMT(RATE OF RETURN/12, YEARS UNTIL COLLEGE*12, NPV(college costs)
But I can't quite put my finger on how to write it correctly. Any ideas?
Bookmarks