![]() |
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? |
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