Future Value of Increasing Payments

J

Joe B.

Does anyone have a formula that will figure the Future Value of an investment
where the payments are steadily increasing each period?

For Example:
An investment offers an 8% annual yield over a 10 year period. I would like
to pay $1000 the first year and then increase my payment by 3% each year to
year 10. I know I can do it with a For loop, but is there a simple formula
to use for this?
Any help is greatly appreciated.
 
F

Frank Kabel

Hi
you have a post from Harlan in Excel.worksheetfunctions
P.S.: please don't multipost :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top