is there a formula for FV with UNEQUAL payments

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?
 
F

Fred Smith

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.
 
M

Michael goldberg

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%)?
 
J

joeu2004

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%)?

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.
 

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