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?