MrTed46 Posted June 3, 2010 Share Posted June 3, 2010 How would I get the present value of a single payment in various years? For example, I would need the present value of a numbet 1 year from now, 2 years, 3 years...5 years. I would obviously want each year in its own cell but I can't figure it out. Quote Link to comment Share on other sites More sharing options...
Atlanta Cracker Posted June 3, 2010 Share Posted June 3, 2010 Make 2 columns. In Column A put the year number you want and in Column B use the PV function and reference column A for the nper portion of the formula. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.