Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the formula to calculate APR with no payments? Carl Excel Discussion (Misc queries) 4 April 23rd 08 03:10 AM
Formula to calculate partial payments Jean Excel Worksheet Functions 4 December 29th 06 05:36 PM
Does anyone have a formula to calculate the car lease payments Captain Jack Excel Discussion (Misc queries) 2 July 30th 05 03:11 PM
How do I forecast future payments by analyzing past payments? CeeBee Excel Worksheet Functions 1 March 17th 05 06:43 PM
Formula for calculating interest payments? Jack Shearer Excel Worksheet Functions 3 March 15th 05 06:17 AM


All times are GMT +1. The time now is 10:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"