Brian Dunning's FileMaker Custom Functions

PVofFV ( FutureVal , Interest , Term )

Present Value of a Future Value

  Average rating: 4.3 (34 votes) Log in to vote

Barry Maskell   Barry Maskell
Real Estate Navigator
http://www.realestatenavigator.com.au

Share on Facebook Share on Twitter

  Sample input:
PVofFV ( 100 , 0.10 , 10 )
  Sample output:
38.55

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Used to calculate the Present Value of a single future value - eg how much in todays money is a future amount given a certain rate of interest (the discount rate)

The FMPro version only calculates the PV of a future income stream hence the need for this function

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.