View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Kramer Rob Kramer is offline
external usenet poster
 
Posts: 1
Default Increasing payment in future value formula?

Yes you can but you need to write it yourself. the Present Value function for
increasing payments is:

PV*(1+r)^n + pmt*((1+r)^n - (1+i)^n))/(r-i) + FV = 0

whe
i = rate of pmt increase per period
r = interest rate per period
n = number of payment periods
pmt = payment made each period
FV = Future value after last paytment is made

If payment is fixed, or i=0, then the formula becomes the familiar

PV*(1+r)^n + pmt*((1+r)^n - 1)/r + FV = 0

as documented in the excel PV function

Payment at month j is:

pmt*(1+i)^j

Let me know if you have any questions or comments. I would be glad to show
how I derived this formula


"AXPJESTER" wrote:

Can I use an increasing payment in a future value formula in 2002 Excel?