MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculate Future Value incorporating periodic withdrawls


Posted by Dick on December 18, 2001 12:36 PM

I'd like to set up a spreadsheet that will calculate the future
value of investments, but I need to have the ability to incorporate
periodic withdrawls.
Thanks


Posted by Juan Pablo G. on December 18, 2001 7:56 PM

Why don't you calculate the NPV of the entire cash flow and then, that result take it to the future period using FV ?

Juan Pablo G.