ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   is there a formula for FV with UNEQUAL payments (https://www.excelbanter.com/excel-worksheet-functions/201077-there-formula-fv-unequal-payments.html)

TOMA

is there a formula for FV with UNEQUAL payments
 
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?

Fred Smith[_4_]

is there a formula for FV with UNEQUAL 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.

"toma" wrote in message
...
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?




All times are GMT +1. The time now is 12:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com