Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is the formula to calculate APR with no payments? | Excel Discussion (Misc queries) | |||
Formula to calculate partial payments | Excel Worksheet Functions | |||
Does anyone have a formula to calculate the car lease payments | Excel Discussion (Misc queries) | |||
How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
Formula for calculating interest payments? | Excel Worksheet Functions |