Future Value of Increasing Payments

G

Guest

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

Similar Threads

value error 2
Bitcoin soars above $5,500 0
Future Value Calculation 2
future value 1
Annuity Payments From A Present Amount 2
Trouble with payments 1
Help with Formula 2
rate of return formula 2

Top