is there a formula for FV with UNEQUAL payments

  • Thread starter Thread starter toma
  • Start date Start date
T

toma

As best I can tell the future value function only works for even payments.
Is there another function, or another way, to calculate FV when you have
uneven payments?
 
There are two functions which support irregular payments: XIRR and XNPV.
Unfortunately, there's no XFV.

However, it's easy to set up. Once you have calculated the XNPV of your
payment stream, calculate the future value using the same term and interest
rate.

Regards,
Fred.
 
I am trying to set up a future value formula where I deposit $10,000 at the beginning of each year for 10 years, and then want to know what the future value is at the end of the 29th year using gross rate of 11.5% annually (and a tax rate of 40%)?
 
I am trying to set up a future value formula where I deposit $10,000 at
the beginning of each year for 10 years, and then want to know what
the future value is at the end of the 29th year using  gross rate of 11..5%
annually (and a tax rate of 40%)?
Click to expand...

Does the tax rate apply to the first 10 years as well as to the last
19 years?

If yes:

=FV(11.5%*(1-40%),19,0,-FV(11.5%*(1-40%),10,-10000,0,1))

If no:

=FV(11.5%*(1-40%),19,0,-FV(11.5%,10,-10000,0,1))

PS: Not good practice to post a substantially different question as a
response to another discussion, especially a discussion that is 2
years old.
 
Back
Top